Untitled query #53102

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", "Asymptotic_geometric_analysis", "Convex_analysis", "Convex_hulls", "Geometric_transversal_theory", "Oriented_matroids", "Polyhedra", "Polytopes", "Theorems_in_convex_geometry", "Determinants", "Geometric_intersection", "Invariant_subspaces", "Linear_algebraists", "Linear_operators", "Bilinear_operators", "Generalizations_of_the_derivative", "Integral_transforms", "Linear_operators_in_calculus", "Matrices", "Transforms", "Unitary_operators", "Matrices", "Random_matrices", "Sparse_matrices", "Matrix_theory", "Matrices", "Determinants", "Matrix_decompositions", "Matrix_normal_forms", "Triangles_of_numbers", "Module_theory", "Multilinear_algebra", "Bilinear_operators", "Clifford_algebras", "Determinants", "Invariant_theory", "Monoidal_categories", "Tensors", "Numerical_linear_algebra", "Domain_decomposition_methods", "Exchange_algorithms", "Least_squares", "Matrix_decompositions", "Matrix_multiplication_algorithms", "Relaxation_(iterative_methods)", "Sparse_matrices", "Singular_value_decomposition", "Spectral_theory", "Super_linear_algebra", "Theorems_in_linear_algebra", "Theorems_in_representation_theory", "Topological_vector_spaces", "Fréchet_spaces", "Normed_spaces", "Sobolev_spaces", "Vector_spaces", "Function_spaces", "Metric_linear_spaces", "Spacetime", "Topological_vector_spaces", "Vectors_(mathematics_and_physics)", "Four-vectors", "Operations_on_vectors", "Topological_vector_spaces", "Vector_calculus", "Linear_algebra_stubs")
        ) AS c
    ON p.page_id = c.cl_from
    LEFT OUTER JOIN
        (SELECT *
        FROM
            langlinks
        WHERE ll_lang IN ("en", "cs")
        ) AS l
    ON l.ll_from = c.cl_from
SQL

Checking query status...
