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