Can't create/write to file '/tmp/#sql-temptable-26a-4a6f12-3a6b32.MAI' (Errcode: 28 "No space left on device")
SELECT SQL_CALC_FOUND_ROWS p.*, IF(LENGTH(name_ru), name_ru, name_ru) AS _name_sort, MATCH(name_ru, description_ru, brief_description_ru) AGAINST ('uniel') AS score_1, MATCH(name_ru, description_ru, brief_description_ru) AGAINST ('sky') AS score_2 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 '%uniel%' OR t1.name LIKE '%sky%') AND categoryID<>1 AND enabled=1) OR (categoryID<>1 and enabled=1 AND ( `name_ru` LIKE '%uniel%' OR
`description_ru` LIKE '%uniel%' OR
product_code LIKE '%uniel%' OR
`brief_description_ru` LIKE '%uniel%') AND ( `name_ru` LIKE '%sky%' OR
`description_ru` LIKE '%sky%' OR
product_code LIKE '%sky%' OR
`brief_description_ru` LIKE '%sky%')) GROUP BY p.productID ORDER BY score_1 DESC, score_2 DESC, sort_order, _name_sort LIMIT 0,10