select cli_n_logo, cli_ch_url from t_calendrier_liens where (cli_n_logo<>0) and cal_ch_ref ='1738057' and cli_ch_url<>'' and cli_n_annee=2017

select cli_n_logo, cli_ch_url from t_calendrier_liens where (cli_n_logo<>0) and cal_ch_ref ='1738042' and cli_ch_url<>'' and cli_n_annee=2017

select cli_n_logo, cli_ch_url from t_calendrier_liens where (cli_n_logo<>0) and cal_ch_ref ='1738046' and cli_ch_url<>'' and cli_n_annee=2017

select cli_n_logo, cli_ch_url from t_calendrier_liens where (cli_n_logo<>0) and cal_ch_ref ='1738049' and cli_ch_url<>'' and cli_n_annee=2017

select cli_n_logo, cli_ch_url from t_calendrier_liens where (cli_n_logo<>0) and cal_ch_ref ='1738053' and cli_ch_url<>'' and cli_n_annee=2017

select cli_n_logo, cli_ch_url from t_calendrier_liens where (cli_n_logo<>0) and cal_ch_ref ='1738054' and cli_ch_url<>'' and cli_n_annee=2017