Dotaz:
SELECT SQL_CALC_FOUND_ROWS P.type, P.id, P.is_recommended, PL.name, PL.uri, P.vat, P.group_id, PL.perex
FROM product P
INNER JOIN product_lang PL ON PL.product_id = P.id INNER JOIN htree H ON H.id = P.category_id INNER JOIN htree_lang HL ON H.id = HL.category_id INNER JOIN product_domain PD ON PD.product_id = P.id LEFT JOIN product_multicategory M ON P.id = M.product_id LEFT JOIN product_variant PV ON PV.product_id = P.id
WHERE (M.category_id IN (8880,8880) OR H.id IN (8880)) AND PL.lang_id = 3 AND PL.uri != "" AND PL.name != "" AND P.active = 1 AND P.deleted = 0 AND P.sale_finished = 0 AND HL.lang_id = 3 AND HL.active = 1 AND PV.active = 1 AND PD.domain_id = 3 AND PD.forbidden = 0
GROUP BY P.id
ORDER BY P.is_recommended DESC, P.place_at_end, P.id DESC
LIMIT 144,24
Chyba: Can't create/write to file '/tmp/#sql-temptable-717-275eeca-17305e.MAI' (Errcode: 28 "No space left on device")