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