Syntactically it is not wrong. Date is a reserved word, but it is classified as the exceptional reserved words, so you don't actually *need* to back tick it. It would be wise to do so, and even wiser to simply not use date as a property. You're wildcarding the start of a string as well, so you won't be able to benefit from the use of an index.
This also has nothing to do with PHP, and I'll assume mysql since you have a LIMIT there. Moving to mysql forum.
header('HTTP/1.1 420 Enhance Your Calm');