MySQL Error
Message: MySQL Query Error
SQL: SELECT COUNT(*) FROM ctb_house h LEFT JOIN ctb_loft l ON h.loft_id=l.id LEFT JOIN ctb_members m ON h.uid=m.uid WHERE 1 AND h.display=1 AND LEFT(zone_id, 3)='003' AND (h.firstchar = 'E' OR l.firstchar = 'E')
Error: Column 'zone_id' in where clause is ambiguous
Errno.: 1052
Click here to seek help.