Unknown column '20desc' in 'order clause'select distinct(houses.house_id)
         from pixilink_360.houses
         join pixilink_360.houses_sites on (houses_sites.house_id = houses.house_id)
         left join pixilink_360.typesofhouses on (houses.type = typesofhouses.house_type)
         where houses_sites.site_id = 1455 and featured  = 'y' and is_deleted <> 1 and status='Approved' order by price%20desc