}
// this is (and has to) return the same fields as the query in tag_get_tags
- $sql = "SELECT DISTINCT tg.id, tg.tagtype, tg.name, tg.rawname, tg.flag, ti.ordering
+ $sql = "SELECT ti.id AS taginstanceid, tg.id, tg.tagtype, tg.name, tg.rawname, tg.flag, ti.ordering
FROM {tag} tg
INNER JOIN {tag_instance} ti ON tg.id = ti.tagid
- WHERE tg.id IN ({$tag_correlation->correlatedtags})";
+ WHERE tg.id IN ({$tag_correlation->correlatedtags})
+ ORDER BY ti.ordering ASC";
$result = $DB->get_records_sql($sql);
if (!$result) {
return array();