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