SELECT `id`, `name`, `position`, `signedthru`, `salary2010`, `sb2010`, `wk2010`,`rb2010`,`basesalary2010`, `number`, `college`, `otherbonus` FROM `roster` WHERE signedthru >= 2010 AND (active='y' OR active='e' OR active='i' OR active='p') ORDER BY salary2010 DESC<br />Unknown column 'salary2010' in 'field list'