SELECT COUNT(DISTINCT `t`.`id`)
FROM `dealers_places` `t`
LEFT OUTER JOIN `products_dealers_places` `products_products` ON (`t`.`id`=`products_products`.`dealers_places_id`)
LEFT OUTER JOIN `products` `products` ON (`products`.`id`=`products_products`.`products_id`)
WHERE (products.products_id=:ycp0)

// it knows TO JOIN `products_products`.products_id ON `products`.id, yet IN the WHERE clause it looks FOR `products`.products_id.....WHEN it needs TO look FOR `products`.id