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= left join campagnes on campagnes.id=idcampagne left join capping on capping.id_campagne=campagnes.id and typecap=2 and ip="34.207.82.217" where pub.Id='2929'