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