Wage Bill Bulletins - Salaries and Remuneration Commission (SRC)

WordPress database error: [Table 'srcgo_2019.ia_wsm_uniqueVisitors' doesn't exist]
CREATE OR REPLACE VIEW ia_wsm_dateWiseFirstVisitors AS SELECT DATE_FORMAT(CONVERT_TZ(firstVisitTime,'+00:00','+03:00'),'%Y-%m-%d') as recordDate, COUNT(visitorId) as visitors FROM ia_wsm_uniqueVisitors GROUP BY DATE_FORMAT(CONVERT_TZ(firstVisitTime,'+00:00','+03:00'),'%Y-%m-%d')

WordPress database error: [Table 'srcgo_2019.ia_wsm_pageViews' doesn't exist]
CREATE OR REPLACE VIEW ia_wsm_dateWisePageViews AS SELECT DATE_FORMAT(CONVERT_TZ(visitLastActionTime,'+00:00','+03:00'),'%Y-%m-%d') as recordDate, SUM(totalViews) as pageViews FROM ia_wsm_pageViews GROUP BY DATE_FORMAT(CONVERT_TZ(visitLastActionTime,'+00:00','+03:00'),'%Y-%m-%d')

WordPress database error: [View 'srcgo_2019.ia_wsm_bounceVisits' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them]
CREATE OR REPLACE VIEW ia_wsm_dateWiseBounce AS SELECT DATE_FORMAT(CONVERT_TZ(visitLastActionTime,'+00:00','+03:00'),'%Y-%m-%d') as recordDate, COUNT(*) as bounce FROM ia_wsm_bounceVisits GROUP BY DATE_FORMAT(CONVERT_TZ(visitLastActionTime,'+00:00','+03:00'),'%Y-%m-%d')

WordPress database error: [View 'srcgo_2019.ia_wsm_dateWiseBounce' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them]
CREATE OR REPLACE VIEW ia_wsm_dateWiseBounceRate AS SELECT dwb.recordDate, dwb.bounce, dwp.pageViews, dwv.visitors, ((dwb.bounce/dwp.pageViews)*100) AS bRatePageViews, ((dwb.bounce/dwv.visitors)*100) AS bRateVisitors FROM ia_wsm_dateWiseBounce dwb LEFT JOIN ia_wsm_dateWisePageViews dwp ON dwb.recordDate=dwp.recordDate LEFT JOIN ia_wsm_dateWiseVisitors dwv ON dwb.recordDate=dwv.recordDate

WordPress database error: [Table 'srcgo_2019.ia_wsm_pageViews' doesn't exist]
CREATE OR REPLACE VIEW ia_wsm_hourWisePageViews AS SELECT HOUR(CONVERT_TZ(visitLastActionTime,'+00:00','+03:00')) as hour, SUM(totalViews) as pageViews FROM ia_wsm_pageViews WHERE CONVERT_TZ(visitLastActionTime,'+00:00','+03:00') >= '2026-08-24 00:00:00' GROUP BY HOUR(CONVERT_TZ(visitLastActionTime,'+00:00','+03:00'))

WordPress database error: [View 'srcgo_2019.ia_wsm_bounceVisits' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them]
CREATE OR REPLACE VIEW ia_wsm_hourWiseBounce AS SELECT HOUR(CONVERT_TZ(visitLastActionTime,'+00:00','+03:00')) as hour, COUNT(*) as bounce FROM ia_wsm_bounceVisits WHERE CONVERT_TZ(visitLastActionTime,'+00:00','+03:00') >= '2026-08-24 00:00:00' GROUP BY HOUR(CONVERT_TZ(visitLastActionTime,'+00:00','+03:00'))

WordPress database error: [View 'srcgo_2019.ia_wsm_hourWiseBounce' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them]
CREATE OR REPLACE VIEW ia_wsm_hourWiseBounceRate AS SELECT hwb.hour, hwb.bounce, hwp.pageViews, hwv.visitors, ((hwb.bounce/hwp.pageViews)*100) AS bRatePageViews, ((hwb.bounce/hwv.visitors)*100) AS bRateVisitors FROM ia_wsm_hourWiseBounce hwb LEFT JOIN ia_wsm_hourWisePageViews hwp ON hwb.hour=hwp.hour LEFT JOIN ia_wsm_hourWiseVisitors hwv ON hwb.hour=hwv.hour

WordPress database error: [Table 'srcgo_2019.ia_wsm_uniqueVisitors' doesn't exist]
CREATE OR REPLACE VIEW ia_wsm_hourWiseFirstVisitors AS SELECT HOUR(CONVERT_TZ(firstVisitTime,'+00:00','+03:00')) as hour, COUNT(*) as visitors FROM ia_wsm_uniqueVisitors WHERE CONVERT_TZ(firstVisitTime,'+00:00','+03:00') >= '2026-08-24 00:00:00' GROUP BY HOUR(CONVERT_TZ(firstVisitTime,'+00:00','+03:00'))

WordPress database error: [Table 'srcgo_2019.ia_wsm_pageViews' doesn't exist]
SELECT HOUR(CONVERT_TZ(visitLastActionTime,'+00:00','+03:00')) as hour, SUM(totalViews) as pageViews FROM ia_wsm_pageViews WHERE CONVERT_TZ(visitLastActionTime,'+00:00','+03:00') >= '2026-08-23 00:00:00' AND CONVERT_TZ(visitLastActionTime,'+00:00','+03:00') <= '2026-08-23 23:59:59' GROUP BY HOUR(CONVERT_TZ(visitLastActionTime,'+00:00','+03:00'))

WordPress database error: [Table 'srcgo_2019.ia_wsm_uniqueVisitors' doesn't exist]
SELECT HOUR(CONVERT_TZ(firstVisitTime,'+00:00','+03:00')) as hour, COUNT(*) as visitors FROM ia_wsm_uniqueVisitors WHERE CONVERT_TZ(firstVisitTime,'+00:00','+03:00') >= '2026-08-23 00:00:00' AND CONVERT_TZ(firstVisitTime,'+00:00','+03:00') <= '2026-08-23 23:59:59' GROUP BY HOUR(CONVERT_TZ(firstVisitTime,'+00:00','+03:00'))