
12-11-2006, 02:32 PM
|
|
|
Join Date: Aug 2006
Posts: 214
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Quote:
Originally Posted by fishhub
Database error in vBulletin 3.5.4:
Invalid SQL:
SELECT a.*, au.*, post.userid, post.postid
FROM post AS post
INNER JOIN award_user AS au ON (au.userid=post.userid)
INNER JOIN award AS a ON (a.award_id=au.award_id)
WHERE post.postid IN (0,17342,17343,17344,17345,17351,17357,17376,17464 ,17470,17472) GROUP BY post.postid
GROUP BY au.issue_id
ORDER BY au.issue_time DESC;
MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY au.issue_id
ORDER BY au.issue_time DESC' at line 7
Error Number : 1064
I got the above problems. Any kind soul can assist? TIA
|
bump, anyone can advice on this? TIA
|