id IS NOT NULL and id != 0 and price IS NOT NULL and price !=0 and (members IS NULL or members=0) and (status=1 or status=2 or status=3) and own_company=2 and (del IS NULL or del=0) and (property=4 or property=5) and property_sub=2 and ((address1 IS NOT NULL and (address1<>28 or address1=28 and (address2<>204 and address2<>207 and address2<>214))) or (address1 IS NULL or address1 IS NOT NULL and (address1<>28 or address1=28 and (address2 IS NULL or address2<>204 and address2<>207 and address2<>214)) AND other_address IS NOT NULL))
その他エリアの中古一戸建てをさがすid IS NOT NULL and id != 0 and price IS NOT NULL and price !=0 and (members IS NULL or members=0) and (status=1 or status=2 or status=3) and own_company=2 and (del IS NULL or del=0) and (property=4 or property=5) and property_sub=2 and ((address1 IS NOT NULL and (address1<>28 or address1=28 and (address2<>204 and address2<>207 and address2<>214))) or (address1 IS NULL or address1 IS NOT NULL and (address1<>28 or address1=28 and (address2 IS NULL or address2<>204 and address2<>207 and address2<>214)) AND other_address IS NOT NULL))