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