bug fix in sql statement,. forgot to reverse the order
add autogen index.yaml