Untitled query #79465

SQL

    select DISTINCT page_title as 'en',
    CASE WHEN ll_lang = 'wuu' THEN ll_title ELSE '' END AS 'wuu',
    CASE WHEN ll_lang = 'xal' THEN ll_title ELSE '' END AS 'xal',
    CASE WHEN ll_lang = 'xh' THEN ll_title ELSE '' END AS 'xh',
    CASE WHEN ll_lang = 'xmf' THEN ll_title ELSE '' END AS 'xmf',
    CASE WHEN ll_lang = 'yi' THEN ll_title ELSE '' END AS 'yi',
    CASE WHEN ll_lang = 'yo' THEN ll_title ELSE '' END AS 'yo',
    CASE WHEN ll_lang = 'za' THEN ll_title ELSE '' END AS 'za',
    CASE WHEN ll_lang = 'zea' THEN ll_title ELSE '' END AS 'zea',
    CASE WHEN ll_lang = 'zgh' THEN ll_title ELSE '' END AS 'zgh',
    CASE WHEN ll_lang = 'zh' THEN ll_title ELSE '' END AS 'zh',
    CASE WHEN ll_lang = 'zh-classical' THEN ll_title ELSE '' END AS 'zh-classical',
    CASE WHEN ll_lang = 'zh-min-nan' THEN ll_title ELSE '' END AS 'zh-min-nan',
    CASE WHEN ll_lang = 'zh-yue' THEN ll_title ELSE '' END AS 'zh-yue',
    CASE WHEN ll_lang = 'zu' THEN ll_title ELSE '' END AS 'zu'

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