Microsoft OLE DB Provider for SQL Server error '80040e14'

Incorrect syntax near the keyword 'ORDER'.

/wood-burning-stove-installation-cornwall/charnwood-c4-with-log-stand/index.asp, line 117