The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
||||
|
||||
what am i doing wrong with this query (joins)
[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] |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|