Query

SELECT
    id,
    created_at,
    name,
    source_lang,
    translations_langs
FROM qwnogpy_ww21770_datasharing.core.courses
WHERE is_translation_published
ORDER BY created_at DESC 

Description

• id: ID of the course
• created_at: timestamp when the course was created
• name : name of the course
• source_lang: source language of the course (language it which it was initially created)
• translations_langs: translation languages of the course, in an ARRAY

To go further

Fetch the translations of a course

Fetch the elements of a course