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