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 (8826,8827,8828,8829,8880,8881,8882,8830,8831,8832,8833,8835,8836,8837,8838,8842,8878,8843,8879,8844,8910,8912,8849,8850,8851,8852,8888,8889,8890,8891,8892,8895,8908,8853,8854,8855,8857,8858,8859,8884,8885,8839,8840,8877,8841,8861,8862,8863,8864,8865,8856,8866,8867,8868,8869,8860,8911,8845,8846,8847,8848,8883,8870,8871,8872,8873,8874,8875,8876,8893,8894,8826) OR H.id IN (8826,8827,8828,8829,8880,8881,8882,8830,8831,8832,8833,8835,8836,8837,8838,8842,8878,8843,8879,8844,8910,8912,8849,8850,8851,8852,8888,8889,8890,8891,8892,8895,8908,8853,8854,8855,8857,8858,8859,8884,8885,8839,8840,8877,8841,8861,8862,8863,8864,8865,8856,8866,8867,8868,8869,8860,8911,8845,8846,8847,8848,8883,8870,8871,8872,8873,8874,8875,8876,8893,8894)) 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 AND (JSON_CONTAINS(P.property_id, 5622)) GROUP BY P.id ORDER BY P.is_recommended DESC, P.place_at_end, P.id DESC LIMIT 504,24
Chyba: Can't create/write to file '/tmp/#sql-temptable-717-2760387-11272.MAI' (Errcode: 28 "No space left on device")