• Can you give me some pointers of rewriting this query? Can data be grabbed at 1 shot instead of doing UNION ALL.