MySQL Query : SELECT COUNT(*) as count FROM (select a.*,b.title as htitle,b.address as haddress,b.url as hurl,b.city as city from xmb_doctors as a LEFT JOIN xmb_hospital as b on a.associatedHospitalId=b.id where city = "洛阳" order by popularity desc ) T
MySQL Error : Unknown column 'popularity' in 'order clause'
MySQL Errno : 1054
Message : Unknown column 'popularity' in 'order clause'
Need Help?