|
Recherche...
|
(getListeSujets) Impossible d'obtenir la liste des messages du forum SELECT f.pere as pere, f.last_date as date, f.id as id, f.last_auteur as last_auteur,
f.auteur as auteur, f.sujet as sujet, f.nb_fils as nb_fils, f.nb_fils_visi as nb_fils_visi, f.forum as forum, f.supp as suppression,
f.visi_sujet as visi_sujet, f.priorite as priorite, f.verrou as verrou,
u.pbem_datas as pbem_datas, ul.pbem_datas as lpbem_datas, u.id as toceurid, ul.id as ltoceurid
FROM frm_toc f LEFT JOIN toceurs u ON f.auteur = u.nom
LEFT JOIN toceurs ul ON f.last_auteur = ul.nom WHERE f.sujet LIKE '%%débutant%%' AND f.type = 'toc-forum' ORDER BY f.priorite DESC, f.last_date DESC LIMIT 0,30;
