[Resolved] What's wrong?

[zzz]

Trying to output top 3 listings:

SELECT COUNT(T1.ads_id) AS COUNT, T1.ads_issue, T2.issue_id, T2.issue_onlinestatus, T2.issue_date
FROM T1
GROUP BY T1.ads_id
LEFT JOIN 01_intel_issues ON (T1.ads_issue = T2.issue_id)
WHERE T2.issue_onlinestatus = 'ON' AND MONTH(T2.issue_date)=$checkMonth
LIMIT 0,3

But keep getting the following error message:

SQL/DB 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 'LEFT JOIN T2 ON ( T1.ads_issue = T2.]

[leatherback]

Hi,

If I am correct, you first place the join syntax, and then the group by. You can check on mysql.org in the manual but I think this is the problem

[zzz]

I swapped places and now get the following error:

SQL/DB 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 'WHERE T2.issue_onlinestatus = 'ON' AND MONTH(01_in]

[leatherback]

Hi,

from the manual, I find this order:

SELECT
    [FROM table_references
    [WHERE where_definition]
    [GROUP BY {col_name | expr | position}
    [ASC | DESC], ... [WITH ROLLUP]]
    [HAVING where_definition]
    [ORDER BY {col_name | expr | position}
    [ASC | DESC] , ...]
    [LIMIT {[offset,] row_count | row_count OFFSET offset}]
    [PROCEDURE procedure_name(argument_list)]
    [FOR UPDATE | LOCK IN SHARE MODE]

Make sure your query is in the right order. I have found mysql to be picky about these things

[zzz]

This might've been it. I moved my GROUP by under WHERE and it worked...