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