Untitled query #79465

SQL

    select DISTINCT page_title as 'en',
    
    CASE WHEN ll_lang = 'ar' THEN ll_title ELSE '' END AS 'ar',
    CASE WHEN ll_lang = 'de' THEN ll_title ELSE '' END AS 'de',
    CASE WHEN ll_lang = 'fr' THEN ll_title ELSE '' END AS 'fr',
    CASE WHEN ll_lang = 'es' THEN ll_title ELSE '' END AS 'es',
    CASE WHEN ll_lang = 'it' THEN ll_title ELSE '' END AS 'it',
    CASE WHEN ll_lang = 'pt' THEN ll_title ELSE '' END AS 'pt',
    CASE WHEN ll_lang = 'ru' THEN ll_title ELSE '' END AS 'ru',
    CASE WHEN ll_lang = 'fa' THEN ll_title ELSE '' END AS 'fa',
    CASE WHEN ll_lang = 'pl' THEN ll_title ELSE '' END AS 'pl',
    CASE WHEN ll_lang = 'zh' THEN ll_title ELSE '' END AS 'zh',
    CASE WHEN ll_lang = 'ja' THEN ll_title ELSE '' END AS 'ja',
    CASE WHEN ll_lang = 'uk' THEN ll_title ELSE '' END AS 'uk',
    CASE WHEN ll_lang = 'nl' THEN ll_title ELSE '' END AS 'nl',
    CASE WHEN ll_lang = 'ca' THEN ll_title ELSE '' END AS 'ca',
    CASE WHEN ll_lang = 'sv' THEN ll_title ELSE '' END AS 'sv',
    CASE WHEN ll_lang = 'sr' THEN ll_title ELSE '' END AS 'sr',
    CASE WHEN ll_lang = 'tr' THEN ll_title ELSE '' END AS 'tr',
    CASE WHEN ll_lang = 'ko' THEN ll_title ELSE '' END AS 'ko'

    from page, langlinks, page_assessments, page_assessments_projects
        where pap_project_title = "Medicine"
        and pa_project_id = pap_project_id
        and pa_page_id = page_id
        and page_id = ll_from
        and page_is_redirect = 0
        and page_namespace = 0
        group by page_title
    limit 10
SQL

Checking query status...
