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 ("403", "521", "522", "523", "524", "525", "526", "527", "528", "529", "530", "531", "532", "533", "534", "535", "536", "537", "550", "552", "553") AND deleted="0" AND available="1" GROUP BY p.product_id ORDER BY name LIMIT -15,15;