SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{49bc17c320944397b0df3d4da7d532a441ae1e7fedad9cb023ceaf63ec40abf6}Lloret{49bc17c320944397b0df3d4da7d532a441ae1e7fedad9cb023ceaf63ec40abf6}' OR prCity = 'Lloret' OR prZip = 'Lloret' OR prStreet LIKE '{49bc17c320944397b0df3d4da7d532a441ae1e7fedad9cb023ceaf63ec40abf6}Lloret{49bc17c320944397b0df3d4da7d532a441ae1e7fedad9cb023ceaf63ec40abf6}' OR prCountry = 'Lloret') AND (prLocation LIKE '{49bc17c320944397b0df3d4da7d532a441ae1e7fedad9cb023ceaf63ec40abf6}de{49bc17c320944397b0df3d4da7d532a441ae1e7fedad9cb023ceaf63ec40abf6}' OR prCity = 'de' OR prZip = 'de' OR prStreet LIKE '{49bc17c320944397b0df3d4da7d532a441ae1e7fedad9cb023ceaf63ec40abf6}de{49bc17c320944397b0df3d4da7d532a441ae1e7fedad9cb023ceaf63ec40abf6}' OR prCountry = 'de') AND (prLocation LIKE '{49bc17c320944397b0df3d4da7d532a441ae1e7fedad9cb023ceaf63ec40abf6}Mar{49bc17c320944397b0df3d4da7d532a441ae1e7fedad9cb023ceaf63ec40abf6}' OR prCity = 'Mar' OR prZip = 'Mar' OR prStreet LIKE '{49bc17c320944397b0df3d4da7d532a441ae1e7fedad9cb023ceaf63ec40abf6}Mar{49bc17c320944397b0df3d4da7d532a441ae1e7fedad9cb023ceaf63ec40abf6}' OR prCountry = 'Mar') AND (prLocation LIKE '{49bc17c320944397b0df3d4da7d532a441ae1e7fedad9cb023ceaf63ec40abf6}Spain{49bc17c320944397b0df3d4da7d532a441ae1e7fedad9cb023ceaf63ec40abf6}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{49bc17c320944397b0df3d4da7d532a441ae1e7fedad9cb023ceaf63ec40abf6}Spain{49bc17c320944397b0df3d4da7d532a441ae1e7fedad9cb023ceaf63ec40abf6}' OR prCountry = 'Spain')