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