Invalid SQL:
SELECT cat.socialgroupcategoryid AS categoryid, cat.title, COUNT(socialgroup.groupid)
AS total
FROM socialgroupcategory AS cat
LEFT JOIN socialgroup AS socialgroup
ON (socialgroup.socialgroupcategoryid = cat.socialgroupcategoryid)
WHERE socialgroup.groupid IS NOT NULL
GROUP BY cat.socialgroupcategoryid
ORDER BY total
LIMIT 0, 40;
MySQL Error : Unknown column 'socialgroup.socialgroupcategoryid' in 'on
clause'
Error Number : 1054
Request Date : Friday, November 14th 2008 @ 04:20:51 PM
Error Date : Friday, November 14th 2008 @ 04:20:51 PM
Script : http://vfkfansite.com/forums/group.php
Referrer :
IP Address : Took out my IP
Username : Matt.php
Classname : vB_Database
MySQL Version : 5.0.51a-community
------------------
Anyone know how to fix this?
SELECT cat.socialgroupcategoryid AS categoryid, cat.title, COUNT(socialgroup.groupid)
AS total
FROM socialgroupcategory AS cat
LEFT JOIN socialgroup AS socialgroup
ON (socialgroup.socialgroupcategoryid = cat.socialgroupcategoryid)
WHERE socialgroup.groupid IS NOT NULL
GROUP BY cat.socialgroupcategoryid
ORDER BY total
LIMIT 0, 40;
MySQL Error : Unknown column 'socialgroup.socialgroupcategoryid' in 'on
clause'
Error Number : 1054
Request Date : Friday, November 14th 2008 @ 04:20:51 PM
Error Date : Friday, November 14th 2008 @ 04:20:51 PM
Script : http://vfkfansite.com/forums/group.php
Referrer :
IP Address : Took out my IP
Username : Matt.php
Classname : vB_Database
MySQL Version : 5.0.51a-community
------------------
Anyone know how to fix this?
Comment