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