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