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
select payment method
×