: SELECT ps.id, ps.price, ps.articul, ps.img, ps.img1,
ps2.name, ps2.shorttext, ps.articul, 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 = '2137' AND ps.type = 'product'
AND ps2.lang = '1' AND ps2.active = 'y'
AND ps.price <= 76 AND ps.id <> 7809
AND qonstorage > 0
GROUP BY ps.id
ORDER BY ps.price DESC LIMIT 5 Got error 28 from storage engine
: SELECT ps.id, ps.price, ps.articul, ps.img, ps.img1,
ps2.name, ps2.shorttext, ps.articul, 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 = '2137' AND ps.type = 'product'
AND ps2.lang = '1' AND ps2.active = 'y'
AND ps.price > 76 AND ps.id <> 7809
AND qonstorage > 0
GROUP BY ps.id
ORDER BY ps.price ASC LIMIT 5 Got error 28 from storage engine
: SELECT tags.pid as pid, tags.tid as tid, gs2.text as text
FROM tags tags
LEFT JOIN groups gs ON (tags.tid = gs.id)
JOIN groups2 gs2 ON (gs2.id1 = gs.id)
WHERE tags.pid = '7809' AND gs2.lang = '1' AND gs2.active = 'y' ORDER BY gs2.text Got error 28 from storage engine Шар стеклянный 10 см, ручная роспись - SCORPIO - Магазин подарков, декора, иллюминации
