where:1=1 and ((r.phone like "%慈溪市%" or r.title like "%慈溪市%" or r.no like "%慈溪市%") and (r.phone like "%横河%" or r.title like "%横河%" or r.no like "%横河%") and (r.phone like "%老%" or r.title like "%老%" or r.no like "%老%") and (r.phone like "%工业区%" or r.title like "%工业区%" or r.no like "%工业区%") and (r.phone like "%厂房%" or r.title like "%厂房%" or r.no like "%厂房%") and (r.phone like "%出租%" or r.title like "%出租%" or r.no like "%出租%") )