WordPress database error: [Table 'u130194771_WPD72.wp_wsm_bounceVisits' doesn't exist]CREATE OR REPLACE VIEW wp_wsm_dateWiseBounce AS SELECT DATE_FORMAT(CONVERT_TZ(visitLastActionTime,'+00:00','+10:00'),'%Y-%m-%d') as recordDate, COUNT(*) as bounce FROM wp_wsm_bounceVisits GROUP BY DATE_FORMAT(CONVERT_TZ(visitLastActionTime,'+00:00','+10:00'),'%Y-%m-%d')
WordPress database error: [Table 'u130194771_WPD72.wp_wsm_dateWiseBounce' doesn't exist]CREATE OR REPLACE VIEW wp_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 wp_wsm_dateWiseBounce dwb LEFT JOIN wp_wsm_dateWisePageViews dwp ON dwb.recordDate=dwp.recordDate LEFT JOIN wp_wsm_dateWiseVisitors dwv ON dwb.recordDate=dwv.recordDate
WordPress database error: [Table 'u130194771_WPD72.wp_wsm_bounceVisits' doesn't exist]CREATE OR REPLACE VIEW wp_wsm_dateHourWiseBounce AS SELECT DATE_FORMAT(CONVERT_TZ(visitLastActionTime,'+00:00','+10:00'),'%Y-%m-%d %H:00:00') as recordDateHour, COUNT(*) as bounce FROM wp_wsm_bounceVisits GROUP BY DATE_FORMAT(CONVERT_TZ(visitLastActionTime,'+00:00','+10:00'),'%Y-%m-%d %H:00:00')
WordPress database error: [Table 'u130194771_WPD72.wp_wsm_dateHourWiseBounce' doesn't exist]CREATE OR REPLACE VIEW wp_wsm_dateHourWiseBounceRate AS SELECT dwb.recordDateHour, dwb.bounce, dwp.pageViews, dwv.visitors, ((dwb.bounce/dwp.pageViews)*100) AS bRatePageViews, ((dwb.bounce/dwv.visitors)*100) AS bRateVisitors FROM wp_wsm_dateHourWiseBounce dwb LEFT JOIN wp_wsm_dateHourWisePageViews dwp ON dwb.recordDateHour=dwp.recordDateHour LEFT JOIN wp_wsm_dateHourWiseVisitors dwv ON dwb.recordDateHour=dwv.recordDateHour
WordPress database error: [Table 'u130194771_WPD72.wp_wsm_bounceVisits' doesn't exist]CREATE OR REPLACE VIEW wp_wsm_hourWiseBounce AS SELECT HOUR(CONVERT_TZ(visitLastActionTime,'+00:00','+10:00')) as hour, COUNT(*) as bounce FROM wp_wsm_bounceVisits WHERE CONVERT_TZ(visitLastActionTime,'+00:00','+10:00') >= '2026-07-23 00:00:00' GROUP BY HOUR(CONVERT_TZ(visitLastActionTime,'+00:00','+10:00'))
WordPress database error: [Table 'u130194771_WPD72.wp_wsm_hourWiseBounce' doesn't exist]CREATE OR REPLACE VIEW wp_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 wp_wsm_hourWiseBounce hwb LEFT JOIN wp_wsm_hourWisePageViews hwp ON hwb.hour=hwp.hour LEFT JOIN wp_wsm_hourWiseVisitors hwv ON hwb.hour=hwv.hour