Disk full (/tmp/#sql_5e73_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")<hr>SELECT SQL_CALC_FOUND_ROWS  p.*, 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 ( ( t1.name LIKE '%для коттеджа%') AND categoryID&lt;&gt;1 AND enabled=1) GROUP BY p.productID  ORDER BY sort_order, _name_sort LIMIT 0,30