SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.city' in 'on clause' (SQL: select `hid`, max(`createtime`) as maxtime from (select p.`hid`, p.`createtime` from  pictures as p left join house as h on p.site=h.city and p.hid=h.hid where p.site='cq' and p.status=1 and h.status=1 and p.pictypeid = 12) as table1 group by hid order by maxtime desc)