select cli_n_logo, cli_ch_url from t_calendrier_liens where (cli_n_logo<>0) and cal_ch_ref ='1316210' 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 ='1316214' 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 ='1316212' 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 ='1316211' 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 ='1316213' 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 ='1316215' and cli_ch_url<>'' and cli_n_annee=2017