Tag cloud doesn't list per store tags

[marcatos]

Method getTags on Block/Sidebar/TagClaud.php has an error in one of the join conditions.

Resulting query is in my case is:

SELECT
  `main_table`.*,
  count(main_table.tag_id) AS `count`
FROM `magefan_blog_tag` AS `main_table`
  LEFT JOIN `magefan_blog_post_tag` AS `pt` ON main_table.tag_id = pt.tag_id
  LEFT JOIN `magefan_blog_post` AS `p` ON p.post_id = pt.post_id
  LEFT JOIN `magefan_blog_post_store` AS `ps` ON p.post_id = pt.post_id
WHERE (ps.store_id IN (0, 2))
GROUP BY `main_table`.`tag_id`

but it should rather be (ON p.post_id = ps.post_id)

SELECT
  `main_table`.*,
  count(main_table.tag_id) AS `count`
FROM `magefan_blog_tag` AS `main_table`
  LEFT JOIN `magefan_blog_post_tag` AS `pt` ON main_table.tag_id = pt.tag_id
  LEFT JOIN `magefan_blog_post` AS `p` ON p.post_id = pt.post_id
  LEFT JOIN `magefan_blog_post_store` AS `ps` ON p.post_id = ps.post_id
WHERE (ps.store_id IN (0, 2))
GROUP BY `main_table`.`tag_id`

[magefan]

Thank you for your report and solution for Magento 2 Blog.