SELECT t1.*,t7.slug_en, (SELECT t3.price FROM goods_prices as t3 WHERE t3.group_id='1' AND t3.good_id=t1.id LIMIT 1) as price,(SELECT t3.saleprice FROM goods_prices as t3 WHERE t3.group_id='1' AND t3.good_id=t1.id LIMIT 1) as saleprice, (SELECT t3.price FROM specprices as t3 WHERE t3.code=t1.good_n AND t3.uid='' LIMIT 1) as specprice, (SELECT t3.price FROM options as t3 WHERE t3.id=(SELECT t5.optionid FROM basket as t5 WHERE t5.good_id=t1.id AND t5.owner_id='' LIMIT 1) LIMIT 1) as optionprice, (SELECT columnValue FROM langs WHERE tableName='products ' AND tableId=t1.id AND tableColumn='title' AND shortname='en' LIMIT 1) AS titleen , (SELECT quantity FROM basket WHERE good_id=t1.id AND owner_id='' LIMIT 1) AS 'quantity' , (SELECT comment FROM basket WHERE good_id=t1.id AND owner_id='' LIMIT 1) AS 'comment' , (SELECT columnValue FROM langs WHERE tableName='products ' AND tableId=t1.id AND tableColumn='description' AND shortname='en' LIMIT 1 ) AS descriptionen FROM products AS t1 LEFT JOIN sitemap as t7 ON(t1.sitemapid=t7.id) WHERE t1.id in ('')

Basket | Supta.ge

basket

Basket - a page where you can see the products you have selected and place an order.

Image
Product name
Quantity
In Batch
Sum
Price
Total
clean cart
Minimum 99.99 Amount of order will get you a free delivery

×

Order

Total:
0
Shipping:
5
Grandtotal:
5
Delivery address:
Please note: delivery to the regions is provided by "Georgian Post" (within 2-3 working days), the delivery fee will be calculated individually, our representative will contact you as soon as possible regarding the details.
CHECKOUT
კდ მეტა რესტორანი
ფუდ მარკეტი
Magic Candy
m-group
Timeless
ჯიბე
Hyster
დიო
ATC აერო სტრუქტურები
ნიუ ვიჟენ დაზღვევა
დეამედი
მალ მალე
ბადაგონი
ეპამ სისტემსი
სასტუმრო თეორია
აზრი
New Vision University
ჩვენი
პოლი
აისითი
Xiaomi
Hotel Shota Rustaveli
King David Hotel
კდ მეტა რესტორანი,ფუდ მარკეტი,Magic Candy,m-group,Timeless,ჯიბე,Hyster,დიო,ATC აერო სტრუქტურები,ნიუ ვიჟენ დაზღვევა,დეამედი,მალ მალე,ბადაგონი,ეპამ სისტემსი,სასტუმრო თეორია,აზრი,New Vision University,ჩვენი,პოლი,აისითი,Xiaomi,Hotel Shota Rustaveli,King David Hotel,