SELECT
id AS id,
officialname AS name,
englishname AS englishname,
typology AS class
FROM
dsm_datasources
WHERE
typology LIKE '%datarepository%'