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