Untitled query #53616

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 (
"Accessible_building", "Architects", "Architectural_communication", "Architectural_competitions", "Architectural_controversies", "Architectural_design", "Architectural_education", "Architectural_elements", "Architectural_history", "Architectural_styles", "Architectural_terminology", "Architectural_theory", "Architecture", "Architecture_awards", "Architecture_by_continent", "Architecture_by_country", "Architecture_by_culture", "Architecture_by_period", "Architecture_by_region", "Architecture_festivals", "Architecture_lists", "Architecture_occupations", "Architecture_organizations", "Architecture_records", "Architecture_stubs", "Architecture_writers", "Bridge_design", "Building_codes", "Building_engineering", "Building_materials", "Buildings_and_structures", "Buildings_and_structures_demolished_by_controlled_implosion", "Destruction_of_buildings", "Floating_architecture", "Heritage_listed_buildings_and_structures_by_country", "Images_of_buildings_and_structures", "Landscape_architecture", "Pair-houses", "Proposed_buildings_and_structures", "Religious_architecture", "Rooms", "Sacred_geometry", "Stepped_gables", "Sustainable_architecture", "Urban_planning", "Wooden_architecture", "Works_about_architecture")

            ) 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...
