SELECT COUNT(id) as nbitem FROM news WHERE statut = 1 AND publication <= NOW() AND site = "agence::27"

SELECT N.id, N.title_fr as title, N.statut, N.on_main, N.publication, N.created, N.content_fr as content, I.name, N.date, N.site FROM news N LEFT OUTER JOIN image I ON N.img = I.id WHERE N.statut = 1 AND N.publication <= NOW() AND N.site = "agence::27" ORDER BY publication DESC

Bovis déménagement, transport

49 - Bovis Pays de Loire Agence bovis

Bovis Transfert Bovis Fine Art Site groupe