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 (8827,8828,8829,8880,8881,8882,8830,8831,8832,8833,8835,8836,8837,8838,8842,8878,8843,8879,8844,8910,8912,8827) OR H.id IN (8827,8828,8829,8880,8881,8882,8830,8831,8832,8833,8835,8836,8837,8838,8842,8878,8843,8879,8844,8910,8912)) AND PL.lang_id = 7 AND PL.uri != "" AND PL.name != "" AND P.active = 1 AND P.deleted = 0 AND P.sale_finished = 0 AND HL.lang_id = 7 AND HL.active = 1 AND PV.active = 1 AND PD.domain_id = 7 AND PD.forbidden = 0
GROUP BY P.id
ORDER BY P.is_recommended DESC, P.place_at_end, P.id DESC
LIMIT 2880,24
Chyba: Can't create/write to file '/tmp/#sql-temptable-717-27679fb-15a9bd.MAI' (Errcode: 28 "No space left on device")