Disk full (/tmp/#sql-temptable-3e96a6-e07f-2ce.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") , query: SELECT
c.*,
cp.price,
cp.priceold,if(c.brand_id=0,0,1) issetbrand,
b.brand,b.sort brandsort,
if ( c.is_other=1,1 ,(SELECT SUM(avail) total FROM `catalog_avail` WHERE id_shop IN (1,2) AND id_good=c.id) ) avail
FROM `catalog` c
LEFT JOIN brands b ON c.brand_id=b.id
LEFT JOIN catalog_price cp ON c.id=cp.id_good AND cp.id_discount_group=12
WHERE
c.is_delete=0 AND cp.price>0 AND
(
(SELECT SUM(avail) total FROM `catalog_avail` WHERE id_shop IN (1,2) AND id_good=c.id)>0
OR c.is_other=1
)
AND (c.id_group=157 OR c.id_group IN (157,157)) ORDER BY issetbrand DESC, brandsort , c.name,c.id LIMIT 0,24