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 ("305", "390", "389", "391", "392", "393", "394", "395", "396", "397", "398", "432", "539", "541", "570", "571", "572", "573", "574", "576", "584", "585", "586", "588", "589", "590", "591", "592", "593") AND deleted="0" AND available="1" GROUP BY p.product_id ORDER BY name LIMIT -15,15;
KATEGÓRIE
| Khan Arms| Chiappa Firearms| Webley Scott| Henry| German Sports Gun| Hammerli | Heckler Koch| Ruger| Tikka| Sako| Norinco| Blaser| Mauser| Zastava| Hunt| Winmark| Lithgow| Akkar| Bark Factory| Derya| Oberland Arms| Smith Wesson| Daniel Defense| KelTec| Barrett| Saiga| DB| HiPoint
V tejto kategórii sa nič nenachádza