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`