Ok, i am running a query:

PHP Code:
SELECT usershop.shopnameusershop.shopdescusershop.userid FROM `usershopINNER JOIN `prem_usershopON `usershop.ID` = `prem_usershop.IDORDER BY `usershop.purchasesDESC LIMIT 0,10 
And it returns this error:
Unknown column 'usershop.ID' in 'on clause'

I checked my table, usershop and it does have a collumn ID. So what's wrong :X?