select cli_n_logo, cli_ch_url from t_calendrier_liens where (cli_n_logo<>0) and cal_ch_ref ='1315872' 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 ='1316164' 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 ='1316165' 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 ='1316166' 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 ='1316167' 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 ='1315848' and cli_ch_url<>'' and cli_n_annee=2017