DB query failed: Disk full (/tmp/#sql_239643_5.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") | SQL: SELECT P.*, CONCAT('catalog/images','/','catalog_large_', TRIM(TRAILING '/' FROM SUBSTRING_INDEX(P.Image, ',', 1))) as BigImage,
         CONCAT('catalog/images','/','catalog_large_', TRIM(TRAILING '/' FROM SUBSTRING_INDEX(P.Image, ',', 1))) as MediumImage,
         CONCAT('catalog/images','/', 'catalog_small_', TRIM(TRAILING '/' FROM SUBSTRING_INDEX(P.Image, ',', 1))) as SmallImage , 
        IF(P.`Availability` like 'Есть в наличии',1,0) as SortField  ,
        (SELECT GROUP_CONCAT(FT.Title SEPARATOR '|') 
        FROM main__filters_tree FT 
        INNER JOIN main__filters_catalog_relations FTR 
        ON FT.id=FTR.filter_id  
        WHERE FTR.catalog_id=P.id 
        AND FT.has_childs=0 
        GROUP BY P.id) as FiltersGroup  ,(SELECT GROUP_CONCAT(FT.id SEPARATOR ',') 
        FROM main__filters_tree FT 
        INNER JOIN main__filters_catalog_relations FTR 
        ON FT.id=FTR.filter_id  
        WHERE FTR.catalog_id=P.id 
        AND FT.has_childs=0 
        GROUP BY P.id) as FiltersIds  FROM main__catalog P 
              WHERE 1=1  AND P.category_id IN ( 
                    SELECT CatRel.child_id FROM main__categories_relations CatRel 
                    LEFT JOIN main__categories Cat ON CatRel.child_id=Cat.id  
                    WHERE Cat.type='102'  AND  CatRel.category_id=310 )  AND (
                P.Type = '5'
                OR P.Type LIKE '5,%'
                OR P.Type LIKE '%,5'
                OR P.Type LIKE '%,5,%'
            )  AND P.subtype='23'  AND P.Visible='1'  ORDER BY SortField DESC, P.Title < 'а',P.Title ASC