[sabret00the]

[sql]SELECT grps.groupid, grps.title, grps.description, grps.approved, user.username, grps_catergories.catid, grps_catergories.title AS catname, grps_setting.image_name, grps_setting.private_posts, grps_setting.moderate_members, grps_setting.hidden_group, grps_grouptext.pagetext AS spew
FROM grps_setting
LEFT JOIN user ON ( user.userid = grps_user.userid )
INNER JOIN grps.groupid = grps_setting.groupid
INNER JOIN grps_grouptext.groupid = grps.groupid
LEFT JOIN grps_catergories ON ( grps_catergories.catid = grps.catid )
WHERE groupid = 3
GROUP BY grps.groupid
ORDER BY grps.groupid DESC[/sql]