Ξψθακΰ οπθ βϋοξλνενθθ ηΰοπξρΰ:
SELECT ps.id, ps.price, ps.articul, ps.inorder, ps.type, ps.section, ps.img, ps.img1,
ps2.name, ps2.shorttext, SUM(spq.qty) AS qonstorage
FROM publications ps
JOIN publications2 ps2 ON (ps.id = ps2.id1)
JOIN ps_ss psss ON (ps.id = psss.prod_id)
LEFT JOIN storages_products_qtys spq ON (spq.prod_id = ps.id)
WHERE psss.sec_id = '2170'
AND ps.type = 'product'
AND ps2.lang = '1'
AND ps2.active = 'y' GROUP BY ps.id ORDER BY psss.sort asc, qonstorage DESC LIMIT 12
Got error 28 from storage engine
2 - SCORPIO - ΠΠ°Π³Π°Π·ΠΈΠ½ ΠΏΠΎΠ΄Π°ΡΠΊΠΎΠ², Π΄Π΅ΠΊΠΎΡΠ°, ΠΈΠ»Π»ΡΠΌΠΈΠ½Π°ΡΠΈΠΈ
