Untitled query #76917

SQL

   import requests

# Define the category name and search string
category = 'Images_from_Wiki_Loves_Monuments_2023_in_Italy_-_Tuscany'
search_string = '09C6630016'

# Make an API request to get the list of pages in the category
category_url = f"https://en.wikipedia.org/w/api.php?action=query&list=categorymembers&cmtitle=Category:{category}&cmlimit=max&format=json"
response = requests.get(category_url)
data = response.json()

# Initialize a list to store file titles containing the search string
matching_files = []

# Loop through the pages in the category
for page in data['query']['categorymembers']:
    page_title = page['title']
    
    # Make an API request to get the wikitext content of the page
    page_url = f"https://en.wikipedia.org/w/api.php?action=query&prop=revisions&titles={page_title}&rvprop=content&format=json"
    response = requests.get(page_url)
    page_data = response.json()
    
    # Check if the search string is in the wikitext content
    if 'pages' in page_data['query']:
        for page_id, page_info in page_data['query']['pages'].items():
            wikitext = page_info['revisions'][0]['*']
            if search_string in wikitext:
                matching_files.append(page_title)

# Print the list of matching file titles
for file_title in matching_files:
    print(file_title)
SQL

Checking query status...
