#!/usr/bin/python3 import sys num = int(sys.argv[1]) query = "SELECT u{tab}.User,u{tab}.Host FROM".format(tab=num) for i in range(num): query += " (SELECT u{tab}.User,u{tab}.Host, (SELECT {tab} FROM DUAL) i1, (SELECT MAX({tab}) FROM DUAL) i2 FROM".format(tab=num-i-1) query += " mysql.user u0" for j in range(num): query += ") u{} ".format(j+1) print(query)