deal with missing queries in data formats