MySQL Query : select count(h.id) from qmtuan_hotel as h left join ( select hotelid,min(normalprice) as pingshi from qmtuan_hotel_room_price where normalprice>0 group by hotelid) as p on h.id=p.hotelid where p.hotelid is not null and p.pingshi>0 and h.hide=1 and h.cid=2443
MySQL Error : Unknown column 'h.hide' in 'where clause'
MySQL Errno : 1054
Message : MySQL Query Error