select cli_n_logo, cli_ch_url from t_calendrier_liens where (cli_n_logo<>0) and cal_ch_ref ='1316205' 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 ='1316207' 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 ='1316208' 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 ='1316206' 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 ='1316209' 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 ='1316204' and cli_ch_url<>'' and cli_n_annee=2017