Publicité inconnue: select urlsite, DateJour, capping_clic_nb, capping_clic_freq, capping_clic_type, capping.id, campagnes.id from pub left join statpubjour ON pub.Id=IdPub AND DateJour=NOW() and Emplacement=6 left join campagnes on campagnes.id=idcampagne left join capping on capping.id_campagne=campagnes.id and typecap=2 and ip="3.149.243.32" where pub.Id='304'