Disk full (/tmp/#sql_6ef0_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")<hr>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=&quot;product&quot;
			WHERE ( ( LOWER(t1.name) LIKE '%trixie%') AND categoryID&lt;&gt;1 AND enabled=1) GROUP BY p.productID  ORDER BY sort_order, _name_sort LIMIT 0,30