Error Number: 1146
Table 'tugthr._numbers' doesn't exist
SELECT DATE(IntervalEnd) as Date, IF(Likes.NumOption1 IS NULL, 0, Likes.NumOption1) as 'NumOption1', IF(Likes.NumOption2 IS NULL, 0, Likes.NumOption2) as 'NumOption2', IF(Likes.NumOption3 IS NULL, 0, Likes.NumOption3) as 'NumOption3', IF(Likes.NumOption4 IS NULL, 0, Likes.NumOption4) as 'NumOption4', IF(Likes.NumOption5 IS NULL, 0, Likes.NumOption5) as 'NumOption5' FROM (( SELECT DATE_ADD(@StartDateTime, INTERVAL (-1 * (nr-1)) DAY) as IntervalStart, DATE_ADD(@StartDateTime, INTERVAL -1 * (nr-2) DAY) as IntervalEnd FROM `_numbers` WHERE DATE_ADD(@StartDateTime, INTERVAL -1 * (nr-1) DAY) >= DATE_ADD(NOW(), interval -30 DAY) AND DATE_ADD(@StartDateTime, INTERVAL -1 * (nr-1) DAY) < NOW() LIMIT 30 ) as Intervals) LEFT JOIN (SELECT DATE(commentDate) as Date, SUM(CASE WHEN postOption = 'Option1' and ifVote = '1' THEN 1 ELSE 0 END) as 'NumOption1', SUM(CASE WHEN postOption = 'Option2' and ifVote = '1' THEN 1 ELSE 0 END) as 'NumOption2', SUM(CASE WHEN postOption = 'Option3' and ifVote = '1' THEN 1 ELSE 0 END) as 'NumOption3', SUM(CASE WHEN postOption = 'Option4' and ifVote = '1' THEN 1 ELSE 0 END) as 'NumOption4', SUM(CASE WHEN postOption = 'Option5' and ifVote = '1' THEN 1 ELSE 0 END) as 'NumOption5' FROM `response_table` WHERE `postID` = '67' GROUP BY `response_table`.`postID`, DATE(commentDate)) as Likes ON (Date >= Intervals.IntervalStart AND Date < Intervals.IntervalEnd) GROUP BY `IntervalStart` ORDER BY `IntervalEnd`
Filename: models/Statistics_model.php
Line Number: 133