SELECT DISTINCT `tarif`, `strike`, logo01
					FROM `articles_tarifs` 
					WHERE 
					`articles_tarifs`.`devise` = :devise 
					AND `articles_tarifs`.`type` = :type
					AND `articles_tarifs`.`codbar` = :codbar
					AND `articles_tarifs`.`date_start`<= :date_render  
					AND `articles_tarifs`.`date_end`>= :date_render  
					AND `codepro` IN
					(
					SELECT `articles`.`codepro` 
					FROM `articles`
					INNER JOIN `articles_sites` ON (`articles`.`codepro` = `articles_sites`.`codepro`) 
					LEFT OUTER JOIN `articles_declinaisons` ON (`articles`.`codepro` = `articles_declinaisons`.`codepro`) 
					WHERE `articles_sites`.`site` = :site AND `articles`.`dispo`<>'ERR' AND `articles`.`date_start`<= :date_render  
					AND `articles`.`date_end`>= :date_render AND `articles`.`code_catalogue` = :codepro )
					AND `articles_tarifs`.`date_start` = (
					SELECT max(`date_start`) 
					FROM `articles_tarifs` as t
					WHERE `articles_tarifs`.`codepro` = `t`.`codepro` 
					AND `devise` = :devise 
					AND `type` = :type
					AND `codbar` = :codbar
					AND `date_start` <= :date_render  
					AND `date_end` >= :date_render 
					)
					ORDER BY `tarif` ASC

Array
(
    [:site] => 1
    [:devise] => EUR
    [:type] => TTC
    [:codbar] => BAR
    [:date_render] => 2026-06-23 16:16:33
    [:codepro] => 4548736064560
)