SELECT
A2.id AS id_article, A2.status_coms, A2.id_rub,
A2.titre AS article_titre, A2.message, A2.date,
A2.auteur AS auteur_id, A2.tags, M.login AS auteur_login,
R.titre AS rub_titre, OpRub.prive, COUNT(C.id) AS comments
FROM
(
SELECT A.id,A.id_blog,A.id_rub,A.titre,A.message,A.`date`,A.auteur,A.tags,OA.status_coms FROM articles AS A
JOIN `options_articles` AS OA ON (A.id = OA.id_article AND A.id_blog = OA.id_blog)
WHERE A.id_blog =
AND ( A.tags LIKE '%droit%commercial%' OR A.titre LIKE '%droit%commercial%' )
AND OA.disponible = 'oui'
ORDER BY A.date DESC LIMIT
) AS A2
LEFT JOIN `commentaires_articles` AS C ON (A2.id = C.id_article AND A2.id_blog = C.id_blog AND C.status = 'accepted')
JOIN `membres` AS M ON (A2.auteur = M.id)
LEFT JOIN `rubriques` AS R ON (A2.id_rub = R.id)
LEFT JOIN `options_rubriques` AS OpRub ON (A2.id_rub = OpRub.id_rub)
GROUP BY A2.id
ORDER BY A2.date DESC Aucun résultat pour votre recherche "droit commercial" |
