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