103
edits
Support/Interesting queries: Difference between revisions
Jump to navigation
Jump to search
no edit summary
No edit summary |
No edit summary |
||
| Line 19: | Line 19: | ||
==Instances of a word being used per day== | ==Instances of a word being used per day== | ||
SELECT DATE(FROM_UNIXTIME(commentDate)) d, COUNT(*) c FROM tiki_comments WHERE parentId = 0 AND objectType = 'forum' AND data LIKE '%Vundo%' GROUP BY d ORDER BY d; | SELECT DATE(FROM_UNIXTIME(commentDate)) d, COUNT(*) c FROM tiki_comments WHERE parentId = 0 AND objectType = 'forum' AND data LIKE '%Vundo%' GROUP BY d ORDER BY d; | ||
==Poll results== | |||
SELECT * FROM tiki_poll_options tpo INNER JOIN tiki_poll_votes tpv on tpo.optionId = tpv.optionId INNER JOIN tiki_polls tp on tpo.pollId = tp.pollId WHERE tp.title LIKE '%smart%'; | |||