Something strange happening with code

Can anyone perhaps shed some light.

On this site, http://www.codelimephotography.com.au/index.php - the courses which are the 2nd menu list, use exactly the same template for all of the courses in that list.  All of the pages work except for the first one (Beginner's Photography) which has an error message "MySQL 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 's Photography Course') ORDER BY DATE' at line 3".

What's strange is that the other pages work?  

Any suggestions on how to fix this?

Thanks