SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{b28aa529539a0f38b15961e6cb15493bae811d939a4e090309112b076f52ae07}Haan{b28aa529539a0f38b15961e6cb15493bae811d939a4e090309112b076f52ae07}' OR prCity = 'Haan' OR prZip = 'Haan' OR prStreet LIKE '{b28aa529539a0f38b15961e6cb15493bae811d939a4e090309112b076f52ae07}Haan{b28aa529539a0f38b15961e6cb15493bae811d939a4e090309112b076f52ae07}' OR prCountry = 'Haan') AND (prLocation LIKE '{b28aa529539a0f38b15961e6cb15493bae811d939a4e090309112b076f52ae07}Germany{b28aa529539a0f38b15961e6cb15493bae811d939a4e090309112b076f52ae07}' OR prCity = 'Germany' OR prZip = 'Germany' OR prStreet LIKE '{b28aa529539a0f38b15961e6cb15493bae811d939a4e090309112b076f52ae07}Germany{b28aa529539a0f38b15961e6cb15493bae811d939a4e090309112b076f52ae07}' OR prCountry = 'Germany')