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 ("198", "204", "205", "206", "207", "208", "209", "210", "211", "212", "213") AND deleted="0" AND available="1" GROUP BY p.product_id ORDER BY name LIMIT -15,15;