Untitled query #51811

SQL

SELECT  p.page_title, c.cl_to, c.cl_from, c.cl_type, l.ll_lang, l.ll_title
FROM
        page p
    INNER JOIN
        (SELECT *
        FROM
            categorylinks
        WHERE cl_to
            IN (
"Linear_algebra", "Convex_geometry", "Determinants", "Geometric_intersection", "Invariant_subspaces", "Linear_algebraists", "Linear_operators", "Matrices", "Matrix_theory", "Module_theory", "Multilinear_algebra", "Numerical_linear_algebra", "Singular_value_decomposition", "Spectral_theory", "Super_linear_algebra", "Theorems_in_linear_algebra", "Topological_vector_spaces", "Vector_spaces", "Vectors_(mathematics_and_physics)", "Linear_algebra_stubs")
        ) AS c
    ON p.page_id = c.cl_from
    LEFT OUTER JOIN
        (SELECT *
        FROM
            langlinks
        WHERE ll_lang IN ("cs", "en")
        ) AS l
    ON l.ll_from = c.cl_from
SQL

Checking query status...
