Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY p.post_id' at line 15 Query: SELECT p.*, CONCAT(mc.firstname,' ',mc.surname) as user_created_name,
CONCAT(mm.firstname,' ',mm.surname) as user_modified_name,
p.forum_id as forumId, count(p3.post_id) as posts , IF(p4.`restrict`,p4.`restrict`,p2.`restrict`) as category_restrict
FROM forum_posts p
LEFT OUTER JOIN forum_post_types ft ON p.post_id=ft.post_id
LEFT JOIN members mc ON mc.member_id=p.user_created /* uc = user created */
LEFT JOIN members mm ON mm.member_id=p.user_modified /* um = user modified */
LEFT OUTER JOIN forum_posts p2 ON p.parent_id=p2.post_id /* get the parent's data */
LEFT OUTER JOIN forum_posts p3 ON p3.parent_id=p.post_id /* get the child's data */
LEFT OUTER JOIN forum_posts p4 ON p2.parent_id=p4.post_id /* get the grandparent's data */
WHERE p.parent_id=0 in /var/www/vhosts/northwestplaywrights.co.uk/httpdocs/treeline/includes/ezSQL.class.php on line 213
Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY p.post_id ORDER BY p.parent_id ASC, p.date_created asc LIMIT 0,4' at line 15 Query: SELECT p.*, CONCAT(mc.firstname,' ',mc.surname) as user_created_name,
CONCAT(mm.firstname,' ',mm.surname) as user_modified_name,
p.forum_id as forumId, count(p3.post_id) as posts , IF(p4.`restrict`,p4.`restrict`,p2.`restrict`) as category_restrict
FROM forum_posts p
LEFT OUTER JOIN forum_post_types ft ON p.post_id=ft.post_id
LEFT JOIN members mc ON mc.member_id=p.user_created /* uc = user created */
LEFT JOIN members mm ON mm.member_id=p.user_modified /* um = user modified */
LEFT OUTER JOIN forum_posts p2 ON p.parent_id=p2.post_id /* get the parent's data */
LEFT OUTER JOIN forum_posts p3 ON p3.parent_id=p.post_id /* get the child's data */
LEFT OUTER JOIN forum_posts p4 ON p2.parent_id=p4.post_id /* g in /var/www/vhosts/northwestplaywrights.co.uk/httpdocs/treeline/includes/ezSQL.class.php on line 213
Warning: Invalid argument supplied for foreach() in /var/www/vhosts/northwestplaywrights.co.uk/httpdocs/forum.php on line 344 North West Playwrights | | View CategoriesTop