Weinkarton Versand » Der Spezialist Suche: 
 

KontoWarenkorbzur Kasse



ÜbersichtKontaktÜber unsZahlartenUnsere AGB'sDatenschutzShop-Betreiber


 
  Home » Weinpräsentkartons Weihnachten Überreichung


Weinpräsentkartons Weihnachten Überreichung Unser Angebot
Weinpräsentkartons in weihnachtlichen, festlichen Designs geben Ihrem Weingeschenk einen hochwertigen Look. Die Präsentkartons zur Überreichung erhalten Sie in den Ausführungen für eine, zwei oder 3 Flaschen. Oft aber auch wird der Karton nicht als Weinkarton sondern für viele andere Geschenkideen verwendet.      
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-100, 100' at line 1

select p.products_image, pd.products_name, pd.products_description, p.products_id, dt.products_deliverytime, dt.products_deliverytime_name, p.manufacturers_id, p.products_price, p.products_quantity, p.products_master, p.products_master_status, p.products_tax_class_id, p.products_sort_order, IF(s.status and 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status and 1, s.specials_new_products_price, p.products_price) as final_price, pc.* from wkt_products_description pd, wkt_products p left join wkt_products_deliverytimes dt ON ( ((dt.products_deliverytime=p.products_deliverytime AND p.products_quantity>0) OR (dt.products_deliverytime=p.products_deliverytimeexternal AND p.products_quantity<=0)) AND dt.language_id='2') left join wkt_manufacturers m on p.manufacturers_id = m.manufacturers_id left join wkt_products_qty_discount pc on (pc.products_qty_discount_id=p.products_qty_discount_id) left join wkt_specials s on p.products_id = s.products_id, wkt_products_to_categories p2c where p.products_status = '1' and p.products_listing_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '2' and p2c.categories_id = '19' order by IF(p.products_quantity>0,2,IF(p.products_deliverytime>1 OR p.products_deliverytimeexternal>0,1,0)) DESC,p.products_sort_order asc,pd.products_name asc limit -100, 100

[TEP STOP]