Hi @phack, in Kolibri, there is a many-to-one relationship between content node IDs and content IDs.
For example, in Khan Academy, the same video or exercise (Content ID) can appear in different place in the topic tree (place = Content Node Id).
content_contentnode Sqlite table, there is a column,
content_id. There are other columns
kind that give, the title of the item, and it’s type, respectively (e.g. whether it’s a video, exercise, pdf, etc.)
So in your, SQL, query you might want to select the unique
content_id values, if I’m understanding your original question correctly. The other filters you have added will also filter items that are not topics, and also have been downloaded by and admin in the Device > Channels page. However, by selecting the
id column, you are getting the Content Node Id, and not the Content Id.