საიტი მუშაობს სატესტო რეჟიმში
პროდუქცია
ფილტრი
SELECT t1.*,t2.namege as 'subcat',t2.slug as 'subcatslug',t3.namege as 'cat',t3.slug as 'catslug',
(SELECT img FROM productimgs WHERE productid=t1.id AND main=1 LIMIT 1) AS mainimg,
(SELECT img FROM options WHERE pid=t1.id AND main=1 LIMIT 1) AS optionimg,
(SELECT price FROM options WHERE pid=t1.id AND main=1 LIMIT 1) AS oprice,
(SELECT pricecard FROM options WHERE pid=t1.id AND main=1 LIMIT 1) AS pricecard,
(SELECT slug FROM productgroups as t2 WHERE t1.groupid=id) as 'gslug' FROM products AS t1
LEFT JOIN categories as t2 ON(t1.category=t2.id)
LEFT JOIN categories as t3 ON(t2.id=t3.pid)
WHERE t1.id>0 AND (FIND_IN_SET(3,category) OR category IN (SELECT id FROM categories WHERE pid='3')) ORDER BY cast((SELECT price FROM options WHERE pid=t1.id AND main=1 LIMIT 1) as unsigned) LIMIT 24 OFFSET 0