Mysql error: Can't create/write to file '/tmp/#sql-temptable-176e51-10f4c6b-427b9f.MAI' (Errcode: 28 "No space left on device")

Error code: 1

Query: SELECT DISTINCT adv_objects.ID,adv_objects.Name,adv_objects.GroupID,adv_objects.Url,adv_objects.Image,adv_objects.Image2,adv_objects.BackgroundImage,adv_objects.BackgroundImage2,adv_objects.BackgroundColor,adv_objects.Color,adv_objects.Height,adv_objects.HeightMobile,adv_objects.FontIcon,adv_objects.HtmlCode,adv_objects.Target,adv_objects.Redirect,adv_objects.Text,adv_objects.SortIndex,adv_objects.Hide,adv_objects.Once,adv_objects.Frequency,adv_objects.Domains,adv_objects.Price,adv_objects.OldPrice,adv_objects.PriceName,adv_objects.OldPriceName,adv_objects.Currency,adv_objects.ButtonName,adv_objects.ButtonHref,adv_objects.ButtonRightContent,adv_objects.Features,adv_objects.ClassName,adv_objects.Shield,adv_objects.Notice FROM adv_objects LEFT JOIN pages_binder as pb2 ON pb2.ItemID=adv_objects.ID AND pb2.ItemCls='iAdvObject' AND pb2.IsNegative='' LEFT JOIN pages_binder as pb3 ON pb3.ItemID=adv_objects.ID AND pb3.ItemCls='iAdvObject' AND pb3.IsNegative='on' AND pb3.ResourceID IN('2', '0') AND pb3.Resource='iCatalogCategory' LEFT JOIN user_filters ON user_filters.Resource='iAdvObject' AND user_filters.ResourceID=adv_objects.ID WHERE `GroupID` = ? 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 ( user_filters.ID IS NULL OR (user_filters.ID > 0 AND (user_filters.Gender='' AND (user_filters.`Groups` = '' OR FIND_IN_SET('6', user_filters.`Groups`)) AND user_filters.UserIDs = '' AND user_filters.MinAge = 0 AND user_filters.MaxAge = 0 AND user_filters.LocationID IN (0, 250))) ) AND (DateStart IS NULL OR DateStart < NOW()) AND (DateFinish IS NULL OR DateFinish > NOW()) AND (adv_objects.Domains = '' OR FIND_IN_SET('107', adv_objects.Domains)) AND (adv_objects.LangCheck = '' OR FIND_IN_SET('ru', adv_objects.LangCheck)) AND adv_objects.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 adv_objects.SortIndex ASC, adv_objects.ID ASC LIMIT 1

Params:

Array
(
    [0] => 20
    [1] => 
)