Unknown column 'pm_read.userid' ...

[bilget]

Hi all of you!,
The query given below when i upgraded to mysql 5.0 last stopped working:

SELECT pm_read.*, user.userid AS uid, user.username AS uname, user.usergroupid AS groupid,
SUM(IF(pm_read.fromuid=$userinfo[userid], 1, 0)) AS total FROM pm_read, pm
LEFT JOIN user ON(user.userid=pm_read.userid)
WHERE pm_read.userid=$userinfo[userid] OR pm_read.fromuid=$userinfo[userid] AND
pm_read.pmtextid IN(pm.pmtextid) AND pm.folderid=-1 GROUP BY user.userid");
error is: mysql error: Unknown column 'pm_read.userid' in 'on clause'

Can someone help me pls? -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Renne]

The precedence of the comma-join operator changed. Use the new ANSI join syntax:

SELECT pm_read.*, user.userid AS uid, user.username AS uname, user.usergroupid AS groupid,
SUM(IF(pm_read.fromuid=$userinfo[userid], 1, 0)) AS total
FROM pm_read
JOIN pm ON pm_read.pmtextid = pm.pmtextid
LEFT JOIN user ON user.userid = pm_read.userid
WHERE pm_read.userid=$userinfo[userid]
OR pm_read.fromuid=$userinfo[userid]
AND pm.folderid=-1 GROUP BY user.userid -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --