SELECT t1.*,
t2.title,
t2.intro
FROM nbg_prod t1
LEFT JOIN nbg_prod_info t2 ON t1.id = t2.rec_id
INNER JOIN (
SELECT group_id, MIN(price) as min_price
FROM nbg_prod
WHERE publish=1 AND price > 0
GROUP BY group_id
) min_prices ON t1.group_id = min_prices.group_id
AND t1.price = min_prices.min_price
WHERE t1.publish=1 AND t1.id IN ( SELECT product_id FROM nbg_product_category WHERE category_id IN (714) ) AND t1.id IN (SELECT product_id FROM nbg_product_category WHERE category_id='714') AND t2.lang='geo' AND t1.introimg <> '' ORDER BY t1.sort_id DESC
mira.ge - პროდუქცია
ვებგვერდი ამ ეტაპზე მუშაობს სატესტო რეჟიმში.
ძველი ვერსიის სანახავად დააჭირეთ აქ
+995 598 35 60 01
