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