问Mysql连接不同

EN

        SELECT count(bv.postId) as views, SUM(if(vote=1, 1, 0)) as likes, SUM(if(vote=-1, 1, 0)) as meeh, GROUP_CONCAT(taxonomy_id) as target, GROUP_CONCAT(t.name) as tname, `t`.`type` as `ttype`, `users`.`fullname`, `users`.`picture`, `users`.`role`, `users`.`picture`, `blog`.* FROM `blog` 
INNER JOIN `blog_taxonomy` `bt` ON `bt`.`blog_id` = `blog`.`id` 
INNER JOIN `users` ON `users`.`id` = `blog`.`user_id` 
INNER JOIN `taxonomy` `t` ON `t`.`id` = bt.`taxonomy_id` 
LEFT JOIN `blog_views` `bv` ON `blog`.`id` = `bv`.`postId` 
WHERE MONTH(blog.time_posted) = 4 AND `blog`.`deleted` =0 GROUP BY `blog`.`id` ORDER BY `blog`.`id` DESC

Table:blog_views 
postId  userId  vote[int values, 1 for like, -1 for dislike and 0 default]

Table blog_taxonomy:
taxonomy_id post_id
 1           1
 2           1
Table Taxonomy
 id  name
  1   art
  2   music

select count(bv.postId) as views, SUM(if(vote=1, 1, 0)) as likes, SUM(if(vote=-1, 1, 0)) as meet from blog_views where postId = ?{blog.id}
group by postId

SELECT bv.views, bv.likes, bv.meeh, GROUP_CONCAT(taxonomy_id) as target, GROUP_CONCAT(t.name) as tname, `t`.`type` as `ttype`, `users`.`fullname`, `users`.`picture`, `users`.`role`, `users`.`picture`, `blog`.* FROM `blog` 
INNER JOIN `blog_taxonomy` `bt` ON `bt`.`blog_id` = `blog`.`id` 
INNER JOIN `users` ON `users`.`id` = `blog`.`user_id` 
INNER JOIN `taxonomy` `t` ON `t`.`id` = bt.`taxonomy_id` 
LEFT JOIN (select count(*) as views,postId,SUM(if(vote=1, 1, 0)) as likes, SUM(if(vote=-1, 1, 0)) as meeh from `blog_views` group by postId) `bv` ON `bt`.`blog_id` = `bv`.`postId` 
WHERE MONTH(blog.time_posted) = 4 AND `blog`.`deleted` =0 GROUP BY `blog`.`id` ORDER BY `blog`.`id` DESC