SELECT idproduct, product.name_short AS name_short, product.name_long AS name_long, product.path AS path, product.vat AS vat, product.price_sale AS price_sale, product.price_sale_nonvat AS price_sale_nonvat, product.price_old AS price_old, product.price_old_nonvat AS price_old_nonvat, product.variation AS variation, product.availability AS availability, product.manufacturer AS manufacturer, product.warranty AS warranty, product.quantity_min AS quantity_min, product.quantity_unit AS quantity_unit, product.weight AS weight, product.identifier AS identifier, product_gallery.filename AS filename, product_gallery.path AS filename_path, product_gallery.w_s AS th2_width, product_gallery.h_s AS th2_height FROM product LEFT JOIN product_gallery ON (product.idproduct = product_gallery.product_idproduct AND product_gallery.ord = 1) WHERE product.host_idhost = 1 AND idproduct = 23696 AND product.hide = '0' GROUP BY product.idproduct LIMIT 1 Košík | Antiquart

Košík

Váš košík je prázdny