Also if i need a list id what can i do ? aia.execute("SELECT id, w from list") links=aia.fetchall() I want to.. idlist=[1, 2, 3] ( I don't want to use FOR and APPEND because the query have 2 million result and i want to speed)