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