Frequently Used Query for Ticket issue

Brand_Navigator_Query(Given by BlueOcean, outdated and not good, please not use if you have optimized version)

Go to the Github which built this doc, then go to doc/files/sqls. You will find all my queries there for different tickets there.