Knowledge Item View

SELECT
    (SELECT COUNT(*) FROM tbl_KNOWLEDGE_UserItemView AS `View` WHERE `View`.DateView BETWEEN '2019-01-01' AND '2019-01-31') AS `January 2019`,
    (SELECT COUNT(*) FROM tbl_KNOWLEDGE_UserItemView AS `View` WHERE `View`.DateView BETWEEN '2019-02-01' AND '2019-02-31') AS `February 2019`,
    (SELECT COUNT(*) FROM tbl_KNOWLEDGE_UserItemView AS `View` WHERE `View`.DateView BETWEEN '2019-03-01' AND '2019-03-31') AS `March 2019`,
    (SELECT COUNT(*) FROM tbl_KNOWLEDGE_UserItemView AS `View` WHERE `View`.DateView BETWEEN '2019-04-01' AND '2019-04-31') AS `April 2019`,
    (SELECT COUNT(*) FROM tbl_KNOWLEDGE_UserItemView AS `View` WHERE `View`.DateView BETWEEN '2019-05-01' AND '2019-05-31') AS `May 2019`,
    (SELECT COUNT(*) FROM tbl_KNOWLEDGE_UserItemView AS `View` WHERE `View`.DateView BETWEEN '2019-06-01' AND '2019-06-31') AS `June 2019`,
    (SELECT COUNT(*) FROM tbl_KNOWLEDGE_UserItemView AS `View` WHERE `View`.DateView BETWEEN '2019-07-01' AND '2019-07-31') AS `July 2019`,
    (SELECT COUNT(*) FROM tbl_KNOWLEDGE_UserItemView AS `View` WHERE `View`.DateView BETWEEN '2019-08-01' AND '2019-08-31') AS `August 2019`,
    (SELECT COUNT(*) FROM tbl_KNOWLEDGE_UserItemView AS `View` WHERE `View`.DateView BETWEEN '2019-09-01' AND '2019-09-31') AS `September 2019`,
    (SELECT COUNT(*) FROM tbl_KNOWLEDGE_UserItemView AS `View` WHERE `View`.DateView BETWEEN '2019-10-01' AND '2019-10-31') AS `October 2019`,
    (SELECT COUNT(*) FROM tbl_KNOWLEDGE_UserItemView AS `View` WHERE `View`.DateView BETWEEN '2019-11-01' AND '2019-11-31') AS `November 2019`,
    (SELECT COUNT(*) FROM tbl_KNOWLEDGE_UserItemView AS `View` WHERE `View`.DateView BETWEEN '2019-12-01' AND '2019-12-31') AS `December 2019`