SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{4678785c653f97d17625974822c07b13f7d69f7ccfe18694caa3805cede7d111}Aachen{4678785c653f97d17625974822c07b13f7d69f7ccfe18694caa3805cede7d111}' OR prCity = 'Aachen' OR prZip = 'Aachen' OR prStreet LIKE '{4678785c653f97d17625974822c07b13f7d69f7ccfe18694caa3805cede7d111}Aachen{4678785c653f97d17625974822c07b13f7d69f7ccfe18694caa3805cede7d111}' OR prCountry = 'Aachen') AND (prLocation LIKE '{4678785c653f97d17625974822c07b13f7d69f7ccfe18694caa3805cede7d111}/{4678785c653f97d17625974822c07b13f7d69f7ccfe18694caa3805cede7d111}' OR prCity = '/' OR prZip = '/' OR prStreet LIKE '{4678785c653f97d17625974822c07b13f7d69f7ccfe18694caa3805cede7d111}/{4678785c653f97d17625974822c07b13f7d69f7ccfe18694caa3805cede7d111}' OR prCountry = '/') AND (prLocation LIKE '{4678785c653f97d17625974822c07b13f7d69f7ccfe18694caa3805cede7d111}Brand{4678785c653f97d17625974822c07b13f7d69f7ccfe18694caa3805cede7d111}' OR prCity = 'Brand' OR prZip = 'Brand' OR prStreet LIKE '{4678785c653f97d17625974822c07b13f7d69f7ccfe18694caa3805cede7d111}Brand{4678785c653f97d17625974822c07b13f7d69f7ccfe18694caa3805cede7d111}' OR prCountry = 'Brand') AND (prLocation LIKE '{4678785c653f97d17625974822c07b13f7d69f7ccfe18694caa3805cede7d111}Germany{4678785c653f97d17625974822c07b13f7d69f7ccfe18694caa3805cede7d111}' OR prCity = 'Germany' OR prZip = 'Germany' OR prStreet LIKE '{4678785c653f97d17625974822c07b13f7d69f7ccfe18694caa3805cede7d111}Germany{4678785c653f97d17625974822c07b13f7d69f7ccfe18694caa3805cede7d111}' OR prCountry = 'Germany')
