gistfile1.sql

SELECT `products`.*
FROM `products`
INNER JOIN `distributions` ON `distributions`.`product_id` = `products`.`id`
WHERE (`distributions`.`product_id` IN (
 SELECT `distributions`.`product_id`
 FROM `distributions`
 WHERE (`distributions`.`country_id` = 6)
 AND (`distributions`.`active` = 1)
))
AND (`distributions`.`displayed_on_homepage` = 1)
group by `products`.`id`