About Members
Bad Query: SELECT g.name, g.object, count(u1.object) AS count FROM genre AS g LEFT JOIN user_rel AS u1 ON g.object = u1.object LEFT JOIN user_rel AS u2 ON (u1.user = u2.user AND u2.type = 'skill') LEFT JOIN user AS u3 ON (u1.user = u3.object) WHERE u2.object = AND u3.status = 1 AND u1.user <> 0 GROUP BY u1.object ORDER BY g.name | Error: (1064) 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 'AND u3.status = 1 AND u1.user <> 0 GROUP BY u1.object ' at line 12