# Pastebin cP1Vjw3J
    my $query = "SELECT entity_tag.tag AS tag_id, $type AS entity,
                        tag.name AS tag_name, genre.id AS genre_id,
                        is_upvote
                 FROM $table entity_tag
                 JOIN tag ON tag.id = entity_tag.tag
                 JOIN genre ON tag.name = genre.name
                 WHERE editor = ?
                 AND $type IN (" . placeholders(@ids) . ')
                 ORDER BY tag.name COLLATE musicbrainz';