this was used to get the website urls

db.py

import mysql.connector
a=[]
b=[]
with open('list.txt') as f:
	for row in f:
		row=row.strip('\n')
		a.append(row)
 

mydb = mysql.connector.connect(
  host="#",
  user="#",
  passwd="#",
  database="#"
)



mycursor = mydb.cursor()
for tablename in a:
	tablename1=str(tablename)
	mycursor.execute("SELECT option_value FROM %s WHERE option_id=1"%tablename1)
	myresult = mycursor.fetchall()
	for x in myresult:
	  b.append(x)

with open("websites.txt", "w") as f:
    for s in b:
        f.write(str(s) +"\n")