select cli_n_logo, cli_ch_url from t_calendrier_liens where (cli_n_logo<>0) and cal_ch_ref ='1316194' 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 ='1316192' 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 ='1316193' 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 ='1316195' 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 ='1316196' 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 ='1316197' and cli_ch_url<>'' and cli_n_annee=2017