SELECT DISTINCT Bookmark.id, Bookmark.url, Bookmark.title, Ups.total
FROM bookmarks AS Bookmark
LEFT JOIN (SELECT COUNT(id) AS total, bookmark_id FROM ups GROUP BY bookmark_id) AS Ups ON Ups.bookmark_id = Bookmark.id
JOIN (SELECT Tag.tag AS tag, BookmarksTag.bookmark_id AS bookmark_id FROM tags AS Tag JOIN bookmarks_tags AS BookmarksTag ON BookmarksTag.tag_id = Tag.id WHERE Tag.tag LIKE "blog") AS Tags ON Tags.bookmark_id = Bookmark.id
ORDER BY Bookmark.id DESC