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 ("302", "303", "381", "384", "386", "387", "388", "385", "408", "420", "421", "422", "457", "458", "545", "575", "577", "578", "579", "580", "581", "582", "583", "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", "306", "399", "430", "431", "308", "400", "401", "402", "411", "412", "413", "414", "415", "416", "417", "418", "419", "546", "309", "423", "424", "425", "426", "543", "544", "310", "433", "434", "435", "436", "437", "438", "439", "440", "441", "442", "443", "444", "445") AND deleted="0" AND available="1" GROUP BY p.product_id ORDER BY name LIMIT -15,15;
KATEGÓRIE
V tejto kategórii sa nič nenachádza