Phoca Forum

Code: Select all

 JLIB_DATABASE_QUERY_FAILED SQL=SELECT a.*,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS parentcat_title, c.id AS parentcat_id,cc.countid AS countid FROM `jgovce_phocadownload_categories` AS a LEFT JOIN `jgovce_languages` AS l ON l.lang_code = a.language LEFT JOIN jgovce_users AS uc ON uc.id=a.checked_out LEFT JOIN jgovce_viewlevels AS ag ON ag.id = a.access LEFT JOIN jgovce_phocadownload_categories AS c ON c.id = a.parent_id LEFT JOIN (SELECT cc.parent_id, count(*) AS countid FROM jgovce_phocadownload_categories AS cc GROUP BY cc.parent_id ) AS cc ON a.parent_id = cc.parent_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc 

Code: Select all

JLIB_DATABASE_QUERY_FAILED SQL=SELECT a.*,f.id as file_id,cc.id as category_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno,uc.name AS editor,fa.countfaid,fn.countfnid FROM jgovce_users AS a LEFT JOIN jgovce_phocadownload AS f ON f.owner_id = a.id LEFT JOIN jgovce_phocadownload_categories AS cc ON cc.id = f.catid LEFT JOIN jgovce_users AS ua ON ua.id=f.owner_id LEFT JOIN jgovce_users AS uc ON uc.id=f.checked_out LEFT JOIN (SELECT fa.owner_id, fa.id, count(*) AS countfaid FROM jgovce_phocadownload AS fa WHERE fa.approved = 1 GROUP BY fa.owner_id) AS fa ON a.id = fa.owner_id LEFT JOIN (SELECT fn.owner_id, fn.id, count(*) AS countfnid FROM jgovce_phocadownload AS fn WHERE fn.approved = 0 GROUP BY fn.owner_id) AS fn ON a.id = fn.owner_id WHERE a.id > 0 AND (fa.countfaid > 0 OR fn.countfnid > 0) GROUP BY a.id ORDER BY uc.username asc JLIB_DATABASE_QUERY_FAILED SQL=SELECT a.*,f.id as file_id,cc.id as category_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno,uc.name AS editor,fa.countfaid,fn.countfnid FROM jgovce_users AS a LEFT JOIN jgovce_phocadownload AS f ON f.owner_id = a.id LEFT JOIN jgovce_phocadownload_categories ..