| SELECT COUNT(rev_page)*COUNT(DISTINCT rev_user) AS 'Edits times unique... |
9 years ago |
| SELECT COUNT(rev_page)*COUNT(DISTINCT rev_user) AS 'Edits times unique... |
9 years ago |
| SELECT COUNT(rev_page)*COUNT(DISTINCT rev_user) AS 'Edits times unique... |
10 years ago |
| SELECT page_title AS 'Article', COUNT(rev_page)*COUNT(DISTINCT rev_user) AS... |
10 years ago |
| SELECT page_title AS 'Article', COUNT(rev_page) AS 'Number of edits',... |
10 years ago |
| SELECT page_title AS 'Artikel', COUNT(rev_page)*COUNT(DISTINCT rev_user) AS... |
10 years ago |
| SELECT page_title, COUNT(rev_page)*COUNT(DISTINCT rev_user) AS 'Edits times... |
10 years ago |
| SELECT page_title, count(rev_page)*COUNT(DISTINCT rev_user) FROM... |
10 years ago |
| SELECT rev_page, count(rev_page)*COUNT(DISTINCT rev_user) FROM... |
10 years ago |
| SELECT rev_page, count(rev_page), COUNT(DISTINCT rev_user) FROM... |
10 years ago |
| /*SELECT rev_page, count(rev_page) FROM svwiki_p.revision
JOIN svwiki_p.page... |
10 years ago |
| SELECT rev_page, count(rev_page) FROM svwiki_p.revision
JOIN svwiki_p.page... |
10 years ago |
| SELECT * FROM svwiki_p.revision
JOIN svwiki_p.page ON rev_page =... |
10 years ago |
| SELECT * FROM svwiki_p.revision
LIMIT 10 |
10 years ago |
| SELECT rev_page, count(rev_page) FROM svwiki_p.revision
WHERE rev_timestamp ... |
10 years ago |
| SELECT rev_page, count(rev_page) FROM svwiki_p.revision
WHERE rev_timestamp ... |
10 years ago |
| SELECT rev_id, count(rev_page) FROM svwiki_p.revision
WHERE rev_timestamp >... |
10 years ago |
| SELECT rev_id, count(rev_page) FROM svwiki_p.revision
WHERE rev_timestamp >... |
10 years ago |
| SELECT * FROM svwiki_p.revision
WHERE rev_timestamp > ... |
10 years ago |
| SELECT * FROM svwiki_p.revision LIMIT 20 |
10 years ago |
| SELECT LIMIT 20 * FROM svwiki_p.revision |
10 years ago |
| SELECT TOP 20 * FROM svwiki_p.revision |
10 years ago |
| SELECT * FROM svwiki_p.revision where rev_user = (SELECT user_id FROM... |
10 years ago |
| SELECT COUNT(DISTINCT rev_user) FROM svwiki_p.revision |
10 years ago |
| SELECT COUNT(DISTINCT rev_user) FROM svwiki_p.revisions |
10 years ago |
| SELECT COUNT DISTINCT rev_user FROM svwiki_p.revisions |
10 years ago |
