Disk full (/tmp/#sql_6ef0_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
SELECT p.*, IF(LENGTH(name_ru), name_ru, name_ru) AS _name_sort FROM SC_products p LEFT JOIN SC_tagged_objects t2 ON p.productID=t2.object_id LEFT JOIN SC_tags t1 ON t2.tag_id=t1.id AND t2.object_type="product" WHERE ( ( LOWER(t1.name) LIKE '%зоомагазин%') AND categoryID<>1 AND enabled=1) GROUP BY p.productID ORDER BY sort_order, _name_sort LIMIT 0,30