103
edits
Support/Interesting queries: Difference between revisions
no edit summary
No edit summary |
No edit summary |
||
| Line 16: | Line 16: | ||
grep -o "\S*\.dll" output.txt > output2.txt | grep -o "\S*\.dll" output.txt > output2.txt | ||
sort output2.txt | uniq -c | sort -nr > report.txt | sort output2.txt | uniq -c | sort -nr > report.txt | ||
==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; | |||