Disk full (/var/tmp/#sql_504_0); waiting for someone to free some space...
SELECT SQL_CALC_FOUND_ROWS p.*, name_uk 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 ( ( t1.name LIKE '%блакитний%') AND categoryID<>1 AND enabled=1) GROUP BY p.productID ORDER BY Price ASC LIMIT 0,10