some sql queries from forumperso

-- viewforums

SELECT p2.`fid`, p2.`titre`, p2.`description`, p1.`uid`, p4.`username`,
 p1.`tid`, p1.`time` AS `timestamp`, p3.`sujet`, p2.`nb_topics`, p2.`nb_posts`, p2.`p_fid`
FROM `forums_title` AS p2'.
 LEFT JOIN `forums` AS p1 ON p1.`pid`=p2.`last_pid`'.
 LEFT JOIN `forums_topics` AS p3 ON p1.`tid`=p3.`tid`'.
 LEFT JOIN `users` AS p4 ON p1.`uid`=p4.`uid`'.
ORDER BY p2.`fid` ASC;

-- viewsubforums

SELECT p2.`titre`, p2.`description`, p2.`moderator`, p2.`nb_topics`, p2.`nb_posts`,
 p2.`p_fid`,'.// p7.`titre` AS `titre2`, p7.`p_fid` AS `p_fid2`, p8.`titre` AS `titre3`, p8.`p_fid` AS `p_fid3`,
 p3.`sujet`, p1.`tid`, p4.`uid`, p4.`username` , p3.`status`, p1.`time` AS `timestamp`, p3.`posts`, p6.`uid` AS `luid`, p6.`username` AS `lusername`,
 p5.`time` AS `ltimestamp`
FROM `forums_title` AS p2
 LEFT JOIN `forums_topics` AS p3 ON p2.`fid`=p3.`fid`'.//' LEFT JOIN `forums_topics` AS p3 ON ( p1.`tid`=p3.`tid` AND p1.`fid`=p3.`fid` )
 LEFT JOIN `forums` AS p1 ON ( p1.`status` <> "R%" AND p1.`status` <> "R" AND p1.`tid`=p3.`tid` )
 LEFT JOIN `users` AS p4 ON p1.`uid`=p4.`uid`
 LEFT JOIN `forums` AS p5 ON p3.`last_pid`=p5.`pid`
 LEFT JOIN `users` AS p6 ON p5.`uid`=p6.`uid`
--  LEFT JOIN `forums_title` AS p7 ON p2.`p_fid`=p7.`fid`
--  LEFT JOIN `forums_title` AS p8 ON p7.`p_fid`=p8.`fid`
WHERE p2.`fid`= "$id"
ORDER BY p3.`last_pid` DESC;

 -- viewtopics

SELECT p2.`titre`, p2.`description`, p2.`moderator`, p3.`sujet`,
 p2.`fid`, p1.`pid`, p4.`uid`, p4.`username`, p4.`avatar` , p4.`grade` , p1.`message`, p4.`signature`,
 p1.`status`, p3.`status` AS `t_status`, p1.`time` AS `timestamp`
FROM `forums_title` AS p2
 LEFT JOIN `forums_topics` AS p3 ON p2.`fid`=p3.`fid`
 LEFT JOIN `forums` AS p1 ON p1.`tid`=p3.`tid`
 LEFT JOIN `users` AS p4 ON p1.`uid`=p4.`uid`
WHERE p1.`tid`= "$id"
ORDER BY p1.`pid` ASC;

--