SELECT p.product_id, p.sk_name AS name, p.sk_description AS description, p.sk_keywords AS keywords, p.price as price1, p.code_1, p.price, p.price_old, if(p.price_old != 0, p.price_old, p.price) AS discount_price_w_vat, p.image_src, p.manufacturer_id, p.action, p.sale, p.naObjednavku, p.osobnyOdber, p.recommend, p.date FROM gdp_hunting_product AS p JOIN gdp_hunting_product_menu AS pm USING (product_id) WHERE pm.menu_id IN ("303", "381", "384", "386", "387", "388", "385", "408", "420", "421", "422", "457", "458", "545", "575", "577", "578", "579", "580", "581", "582", "583") AND deleted="0" AND available="1" GROUP BY p.product_id ORDER BY name LIMIT -15,15;
KATEGÓRIE
| Heckler Koch| Chiappa Firearms| HS Produkt| Beretta USA| Ruger| German Sports Gun| CZ| Grand Power| Norinco| CSA| Glock| Walther| North American Arms| KelTec| Smith Wesson| Arex| Sphinx| Arsenal| Kimber| Magnum| Hi-Point
V tejto kategórii sa nič nenachádza