[SOLVED] Query Issue

[ainoy31]

Hello-

 

I can not figure out why this code is not working. 

 

SELECT f.id as id, f.forum_name as forum,

    f.forum_desc as description,

    count(p.forum_id) as threads, u.name as mod

  FROM forum_forum f

  LEFT JOIN forum_posts p

  ON f.id = p.forum_id

  AND p.topic_id=0

  LEFT JOIN forum_users u

  ON f.forum_moderator = u.id

  GROUP BY f.id

 

I get the message that the MySQL server version for the right syntax to use near 'mod FROM forum_forum f LEFT JOIN forum_posts p ON f.id = p.forum_id ' at line 3

 

I have looked ove this many times and need a second eye.  Much appreciation.

[Barand]

MOD is a MySQL reserved word

[ainoy31]

changed mod to something else like modder worked.  much appreciation.