SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{055f3e29541dcd28046f6e9c82edb5c55081433cd6017cb2052b6a4d1ab94d6d}Cancelada{055f3e29541dcd28046f6e9c82edb5c55081433cd6017cb2052b6a4d1ab94d6d}' OR prCity = 'Cancelada' OR prZip = 'Cancelada' OR prStreet LIKE '{055f3e29541dcd28046f6e9c82edb5c55081433cd6017cb2052b6a4d1ab94d6d}Cancelada{055f3e29541dcd28046f6e9c82edb5c55081433cd6017cb2052b6a4d1ab94d6d}' OR prCountry = 'Cancelada') AND (prLocation LIKE '{055f3e29541dcd28046f6e9c82edb5c55081433cd6017cb2052b6a4d1ab94d6d}Spain{055f3e29541dcd28046f6e9c82edb5c55081433cd6017cb2052b6a4d1ab94d6d}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{055f3e29541dcd28046f6e9c82edb5c55081433cd6017cb2052b6a4d1ab94d6d}Spain{055f3e29541dcd28046f6e9c82edb5c55081433cd6017cb2052b6a4d1ab94d6d}' OR prCountry = 'Spain')