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