translations under review

SQL

WITH
    in_pages AS (
        SELECT
            page_id,
            page_title
        FROM page
        WHERE page_title IN {PAGES_LIST}),
        
    infoboxes AS (
        SELECT
            page_id AS inf_id,
            page_title AS inf_title
        FROM page 
        WHERE
            page_title REGEXP '(.*Infobox.*|.*ज्ञानसन्दूक.*|.*infobox.*)' AND
            NOT page_title REGEXP '(.*/doc.*|.*/row.*|.*/lua.*|.*/sandbox.*)' AND
            page_namespace = 10 AND
            page_is_redirect = 0),
    
    links AS (
        SELECT
            *
        FROM
            pagelinks pl
        JOIN
            in_pages p
            ON pl.pl_from = p.page_id
        JOIN
            infoboxes i
            ON pl.pl_title = i.inf_title)
                

SELECT * FROM links
SQL

Checking query status...
