Phoca Forum

Code: Select all

SELECT a.*, cc.title AS  parentname, u.name AS editor, g.name AS groupname, v.average AS ratingavg, ua.username AS usercatname, c.countid AS countid
  FROM jos_phocagallery_categories AS a 
  LEFT JOIN jos_users AS u
  ON u.id = a.checked_out 
  LEFT JOIN jos_groups AS g
  ON g.id = a.access 
  LEFT JOIN jos_phocagallery_categories AS cc
  ON cc.id = a.parent_id
  LEFT JOIN jos_phocagallery_votes_statistics AS v
  ON v.catid = a.id
  LEFT JOIN jos_users AS ua
  ON ua.id = a.owner_id JOIN (SELECT c.parent_id, count(*) AS countid
  FROM jos_phocagallery_categories AS c
  GROUP BY c.parent_id ) AS c
  ON a.parent_id = c.parent_id
  ORDER BY  a.ordering