物件一覧
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 mansion_id != 0 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 mansion_id != 0 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))