Untitled query #31516

SQL

namespaces = list(range(0, 16)) + [100, 101, 108, 109, 118, 119, 446, 447, 710, 711, 828, 829, 2300, 2301, 2302, 2303];

linter_cat_order = [7, 12, 17, 16, 14, 9, 6, 13, 10, 15, 3, 1, 8, 11, 4, 2, 5];

for ns in namespaces:
        counts[ns] = {}
        for lint in linter_cat_order:
                counts[ns][lint] = 0

with conn.cursor() as cur:
        for ns in namespaces:
                for lint in linter_cat_order:
                        cur.execute("select count(*) from linter inner join page on page.page_id=linter.linter_page where linter_cat={0} and page.page_namespace={1};".format(lint, ns))
SQL

Checking query status...
