Issue: 4.0.7 Upgrade Error

Invalid SQL:
SELECT `gi`.*,`l`.*,`ch`.*,`c`.*,`i`.*,`r`.*,`page`.*, IF(`sub`.`userid`, 1, 0)  AS `issubscribed`,`mk`.`readtime`,`gi`.`userid` AS `group_userid`,`l`.`userid` AS `translate_userid`,`ch`.`userid` AS `chapter_userid`,`r`.`dateline` AS `edit_dateline`,`r`.`flags` + 0 AS `flags`,NULL AS `edit_parentid`,`page`.`pageid` FROM `vw_page` `page`  LEFT JOIN `vw_route` `i` ON (`page`.`pageid` = `i`.`itemid` AND `i`.`itemtypeid` = 1) 
 LEFT JOIN `vw_counter` `c` ON (`c`.`pageid` = `page`.`pageid`) 
 LEFT JOIN `vw_revision` `r` ON (`r`.`revisionid` = `page`.`revisionid`) 
 LEFT JOIN `vw_chapter` `ch` ON (`page`.`pageid` = `ch`.`pageid`) 
 LEFT JOIN `vw_langitem` `l` ON (`page`.`pageid` = `l`.`pageid`) 
 LEFT JOIN `vw_groupitem` `gi` ON (`page`.`pageid` = `gi`.`pageid`) 
 LEFT JOIN `vw_markread` `mk` ON (`mk`.`itemtypeid` = 1 AND `mk`.`itemid` = `page`.`pageid` AND `mk`.`userid` = 1) 
 LEFT JOIN `vw_subscribe` `sub` ON (`sub`.`nodetypeid` = 1 AND `sub`.`nodeid` = `page`.`pageid` AND `sub`.`userid` = 1)   WHERE `page`.`areaid` = 0;

MySQL Error   : Unknown column 'c.pageid' in 'on clause'
Error Number  : 1054
Request Date  : Friday, December 11th 2015 @ 10:08:53 PM
Error Date    : Friday, December 11th 2015 @ 10:08:53 PM
Classname     : vB_Database_MySQLi
MySQL Version : 5.5.46-MariaDB-log