Boxing & Martial Arts

SELECT DISTINCT p.parent

                FROM `products` p

                LEFT JOIN `products_popularity` pp

                    ON p.id = pp.id_product

                INNER JOIN product_offers po

                    ON p.`id` = po.id_product

                WHERE pp.id_country = 3

                    AND po.id_country = 3

                    AND po.price > 0

                    AND (po.time_end > 1337587663 OR time_end = 0)

                LIMIT 6