| WITH base_table AS (
SELECT DISTINCT
rev_id,
rev_actor,
... |
6 days ago |
| WITH base_table AS (
SELECT DISTINCT
rev_id,
rev_actor,
... |
6 days ago |
| SELECT
COUNT(DISTINCT rev_id)
FROM
revision
JOIN
actor ON rev_actor =... |
1 week ago |
| SELECT
COUNT(DISTINCT rev_id)
FROM
revision
JOIN
actor ON rev_actor =... |
1 week ago |
| SELECT
*,
'tewiki' AS wiki_db
FROM
site_stats
LIMIT 10 |
2 months ago |
| SELECT
*,
'tewiki' AS wiki_db
FROM
watchlist
LIMIT 10 |
2 months ago |
| SELECT
*,
'tewiki' AS wiki_db
FROM
watchlist
LIMIT 10 |
2 months ago |
| SELECT
*,
'tewiki' AS wiki_db
FROM
user_newtalk
LIMIT 10 |
2 months ago |
| SELECT
*,
'tewiki' AS wiki_db
FROM
user_newtalk
LIMIT 10 |
2 months ago |
| SELECT
*,
'tewiki' AS wiki_db
FROM
user
LIMIT 10 |
2 months ago |
| SELECT rev_actor, COUNT(DISTINCT rev_id) AS edit_count
FROM revision
WHERE... |
2 months ago |
| SELECT rev_actor, COUNT(*) AS edit_count
FROM revision
WHERE rev_page =... |
2 months ago |
| SELECT rev_actor, COUNT(*) AS edit_count
FROM revision
WHERE rev_page =... |
2 months ago |
| SELECT rev_actor, COUNT(*) AS edit_count
FROM revision
WHERE rev_page =... |
2 months ago |
| SELECT rev_actor, COUNT(*) AS edit_count
FROM revision
GROUP BY... |
2 months ago |
| SELECT rev_actor, COUNT(*) AS edit_count
FROM revision
GROUP BY... |
2 months ago |
| SELECT user_id, COUNT(*) AS edit_count
FROM revision
GROUP BY user_id
HAVING... |
2 months ago |
