a) tried using CTE to see if the query could be improved inplace but no luck so far (https://pastebin.canonical.com/55779/, https://pastebin.canonical.com/55780/).
a) tried using CTE to see if the query could be improved inplace but no luck so far (https:/ /pastebin. canonical. com/55779/, https:/ /pastebin. canonical. com/55780/).