Pristatymo vieta:
Kupiškis - 6.00€
+370 60 651 652
Informacija: 9:00 - 21:00

Gėlių Pristatymas į Namus Kupiškyje

SELECT A.stock, A.id, A.name, A.prod_code, A.linkname, A.price2, A.price3, A.old_price1, A.price1, A.akcija, A.image1, A.filter, A.cat_id, A.manufacturer_id, A.group_id, if( A.price1 < A.price1 && A.price1 > 0, A.price1, A.price1) as price, A.ptype, H.card_number as akcija_name, H.type as akcija_type, H.linkname as akcija_cls, A.info5 as short_description, A.image2, A.check1 FROM infol_products as A inner join infol_products_cats as D on A.id = D.prod_id and D.cat_id='4' LEFT JOIN infol_discounts AS H ON H.id = A.akcija WHERE 1 and A.ptype != 6777 AND A.active = 1 GROUP BY A.id ORDER BY check1, DL.order_id, price limit 0,56Unknown column 'DL.order_id' in 'order clause'81