const notes = await api.runOnBackend(() => { return api.sql.getRows(` SELECT notes.noteId, COUNT(branches.branchId) AS count FROM notes JOIN branches USING (noteId) WHERE notes.isDeleted = 0 AND branches.isDeleted = 0 GROUP BY notes.noteId HAVING count > 1 ORDER BY count DESC LIMIT 100`); }); const $statsTable = api.$container.find('.stats-table'); for (const note of notes) { $statsTable.append( $("<tr>") .append( $("<td>").append(await api.createNoteLink(note.noteId, {showNotePath: true})) ) .append($("<td nowrap>").text(note.count)) ); }