[SOLVED] Syntax Error with GROUP BY and ORDER BY

[Lumio]

Hi

My SQL is like this one:

SELECT
GROUP_CONCAT(`articles`.`article_id`), 
`articles`.`article_title`
FROM `articles`, `article_associations`
WHERE  `articles`.`article_author` = 1 OR
(`articles`.`article_public` = 1 AND
`article_associations`.`a_cat` = 1 AND
`article_associations`.`a_article` = `articles`.`article_id`)
ORDER BY `articles`.`article_modified`
GROUP BY `articles`.`article_id`;

And I get the following 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 'GROUP BY `articles` . `article_id`

 

When I put ORDER BY out it works.

 

//edit:

lol... thats banal. I only have to move ORDER BY after GROUP BY.