Mysql error: Can't create/write to file '/tmp/#sql-temptable-1aea02-2506c-31c27.MAD' (Errcode: 28 "No space left on device")

Error code: 1

Query: SELECT DISTINCT catalog_groups.ID,catalog_groups.Name,catalog_groups.Code,catalog_groups.Image,catalog_groups.Label,catalog_groups.Color,catalog_groups.LabelPlace,catalog_groups.LabelAll,catalog_groups.H,catalog_groups.SortIndex,catalog_groups.Hide,catalog_groups.NumColumn,catalog_groups.NumMax,catalog_groups.Place,catalog_groups.IsAjax,catalog_groups.Random,catalog_groups.Type,catalog_groups.CatID,catalog_groups.HideNotAvailable,catalog_groups.StoreID,catalog_groups.Template,catalog_groups.OrderField,catalog_groups.HideModelsOf,catalog_groups.HideModelsOfCats,catalog_groups.DiscountID,catalog_groups.ImageFacade,catalog_groups.Title,catalog_groups.Keywords,catalog_groups.Description,catalog_groups.NoIndex,catalog_groups.Domains,catalog_groups.NumModels,catalog_groups.NumModelsRaw,catalog_groups.NumBindings,catalog_groups.NumGifts,IFNULL((SELECT IF(Text != '',Text,NULL) FROM lang_values WHERE TableName='catalog_groups' AND FieldName='Name' AND TableID=catalog_groups.ID AND Lang='ru' AND Domain IN(0,105) ORDER BY Domain DESC LIMIT 1),catalog_groups.Name) as Name FROM catalog_groups LEFT JOIN pages_binder as pb2 ON pb2.ItemID=catalog_groups.ID AND pb2.ItemCls='iCatalogGroup' AND pb2.IsNegative='' LEFT JOIN pages_binder as pb3 ON pb3.ItemID=catalog_groups.ID AND pb3.ItemCls='iCatalogGroup' AND pb3.IsNegative='on' AND pb3.ResourceID IN('2', '0') AND pb3.Resource='iCatalogCategory' WHERE (FIND_IN_SET('left', Place) OR FIND_IN_SET('left_main', Place)) AND (pb2.ID IS NULL OR ((pb2.ResourceID = '2' AND pb2.Resource = 'iCatalogCategory') OR (pb2.ResourceID = 0 AND pb2.Resource = 'iCatalogCategory'))) AND (pb3.ID IS NULL) AND (catalog_groups.Domains = '' OR FIND_IN_SET('105', catalog_groups.Domains)) AND catalog_groups.Hide = ? AND (pb2.ID IS NULL OR ((pb2.ResourceID = '2' AND pb2.Resource = 'iCatalogCategory') OR (pb2.ResourceID = 0 AND pb2.Resource = 'iCatalogCategory'))) AND (pb3.ID IS NULL) ORDER BY catalog_groups.SortIndex ASC, catalog_groups.ID ASC

Params:

Array
(
    [0] => 
)