order by isn't so much matching the condition.  It should say that it matches the condition and then is sorted by year/createddate