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