Job lot of used maternity clothes

INSERT INTO

                    `products_popularity` (`id_product`, `id_country`, `accumulator`)

                    VALUES (237927, 3, 1)

                ON DUPLICATE KEY UPDATE `accumulator` = `accumulator` + 1

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 > 1337578421 OR time_end = 0)

                LIMIT 6