code: def namedb_get_name_by_preorder_hash( cur, preorder_hash, include_history=True ):
      
  
      select_query = "SELECT * FROM name_records WHERE preorder_hash = ?;"
      name_rows = namedb_query_execute( cur, select_query, (preorder_hash,))
  
      name_row = name_rows.fetchone()
      if name_row is None:
          # no such preorder
          return None 
  
      namerec = {}
      namerec.update( name_row )
  
      if include_history:
          hist = namedb_get_history( cur, namerec['name'] )
          namerec['history'] = hist
  
      return namerec
docs: Get a name by its preorder hash (regardless of whether or not it was expired or revoked.)