Untitled query #79465

SQL

    select DISTINCT page_title as 'en',
    CASE WHEN ll_lang = 'ab' THEN ll_title ELSE '' END AS 'ab',
    CASE WHEN ll_lang = 'ace' THEN ll_title ELSE '' END AS 'ace',
    CASE WHEN ll_lang = 'af' THEN ll_title ELSE '' END AS 'af',
    CASE WHEN ll_lang = 'als' THEN ll_title ELSE '' END AS 'als',
    CASE WHEN ll_lang = 'alt' THEN ll_title ELSE '' END AS 'alt',
    CASE WHEN ll_lang = 'am' THEN ll_title ELSE '' END AS 'am',
    CASE WHEN ll_lang = 'ami' THEN ll_title ELSE '' END AS 'ami',
    CASE WHEN ll_lang = 'an' THEN ll_title ELSE '' END AS 'an',
    CASE WHEN ll_lang = 'ang' THEN ll_title ELSE '' END AS 'ang',
    CASE WHEN ll_lang = 'anp' THEN ll_title ELSE '' END AS 'anp',
    CASE WHEN ll_lang = 'ar' THEN ll_title ELSE '' END AS 'ar',
    CASE WHEN ll_lang = 'arc' THEN ll_title ELSE '' END AS 'arc',
    CASE WHEN ll_lang = 'ary' THEN ll_title ELSE '' END AS 'ary',
    CASE WHEN ll_lang = 'arz' THEN ll_title ELSE '' END AS 'arz',
    CASE WHEN ll_lang = 'as' THEN ll_title ELSE '' END AS 'as',
    CASE WHEN ll_lang = 'ast' THEN ll_title ELSE '' END AS 'ast',
    CASE WHEN ll_lang = 'atj' THEN ll_title ELSE '' END AS 'atj',
    CASE WHEN ll_lang = 'av' THEN ll_title ELSE '' END AS 'av',
    CASE WHEN ll_lang = 'avk' THEN ll_title ELSE '' END AS 'avk',
    CASE WHEN ll_lang = 'awa' THEN ll_title ELSE '' END AS 'awa',
    CASE WHEN ll_lang = 'ay' THEN ll_title ELSE '' END AS 'ay'

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