SELECT count(*) as nb FROM bateaux as b INNER JOIN photos as p ON b.id_bateau=p.id_bateau LEFT JOIN agents AS a ON a.id_agent = b.idagent WHERE b.type=2 AND b.actif LIKE 'Oui' AND b.XB = 'Oui' AND ( quille=1 OR quille=2 OR quille=3 OR quille=4 OR quille=5 OR quille=6 OR quille=7) ORDER BY b.date_ajout descSELECT b.constructeur,b.affaires,b.id_bateau,b.idagent,b.region,b.modele,b.annee,b.marque,b.longueur,b.prix,b.placeport,p.*,a.nom,a.prenom,a.dept_visite,b.code_tva FROM bateaux as b INNER JOIN photos as p ON b.id_bateau=p.id_bateau LEFT JOIN agents AS a ON a.id_agent = b.idagent WHERE b.type=2 AND b.actif LIKE 'Oui' AND b.XB = 'Oui' AND ( quille=1 OR quille=2 OR quille=3 OR quille=4 OR quille=5 OR quille=6 OR quille=7) ORDER BY b.date_ajout desc LIMIT 0,30