KaZeo
+
coursdedroit
Follow me
Join now
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"

Cours-de-droit.net
Recherche dans le site cours-de-droit.ne
Tous les cours