Untitled query #51199

SQL

SELECT
    p.page_title,
    cl.cl_to
FROM
    commonswiki_p.page p
INNER JOIN
    commonswiki_p.categorylinks cl
ON
    p.page_id = cl.cl_from
INNER JOIN
    commonswiki_p.page c
ON
    cl.cl_to = c.page_title
LEFT JOIN (
    SELECT
        p.page_title AS title2,
        cl.cl_to AS cl_to2
    FROM
        commonswiki_p.page p
    INNER JOIN
        commonswiki_p.categorylinks cl
    ON
        p.page_id = cl.cl_from
    INNER JOIN
        commonswiki_p.page c
    ON
        cl.cl_to = c.page_title
    INNER JOIN
        commonswiki_p.page_props pp
    ON
        c.page_id = pp.pp_page
    WHERE
        pp.pp_propname = 'hiddencat'
    AND
        c.page_namespace = 14
    AND
        p.page_namespace = 6
    AND
        p.page_title in ('Melpomene_Melodie_7.jpg')
) ON page_title = title2 AND cl_to = cl_to2

WHERE
    c.page_namespace = 14
AND
    p.page_namespace = 6
AND
    p.page_title in ('Melpomene_Melodie_7.jpg')

LEFT JOIN
SQL

Checking query status...
