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 (8845,8846,8847,8848,8883,8845) OR H.id IN (8845,8846,8847,8848,8883)) 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 600,24
Chyba: Can't create/write to file '/tmp/#sql-temptable-717-2768fdc-15c4c2.MAI' (Errcode: 28 "No space left on device")