- $tag_stmt = DBA::p("SELECT `term`, COUNT(`term`) AS `total` FROM `term`
- LEFT JOIN `item` ON `term`.`oid` = `item`.`id`
- WHERE `term`.`uid` = ? AND `term`.`type` = ?
- AND `term`.`otype` = ?
- AND `item`.`visible` AND NOT `item`.`deleted` AND NOT `item`.`moderated`
+ $tag_stmt = DBA::p("SELECT `name`, COUNT(`name`) AS `total` FROM `tag-search-view`
+ LEFT JOIN `post-user-view` ON `tag-search-view`.`uri-id` = `post-user-view`.`uri-id` AND `tag-search-view`.`uid` = `post-user-view`.`uid`
+ WHERE `tag-search-view`.`uid` = ?
+ AND `post-user-view`.`visible` AND NOT `post-user-view`.`deleted`