[SOLVED] Error with Query?

[unsider]

Sometimes my query executes properly, and at other times it does not, when it does not it returns:

 

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 'ORDER by date_created ASC' at line 1

 

All of the table columns exist: date_created, etc...

 

constants:

<?php
define("TBL_TUTORIALS", "tutorial");
define("TBL_TUTORIAL_CATEGORIES", "tutorial_categories");
?>

 

Query:

<?php
$query = "Select *, COUNT(*) FROM ".TBL_TUTORIALS." INNER JOIN ".TBL_TUTORIAL_CATEGORIES." ON cat = cat_id 
WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) GROUP BY date_created DESC LIMIT 10";
?>

 

Any noticeable errors, it seems like everything should work...

 

 

[unsider]

Figured it out.