SELECT COUNT(*) articles,
SUM(CASE WHEN rev_len < 2500 THEN 1 ELSE 0 END)... |
2 years ago |
SELECT COUNT(*) articles,
SUM(CASE WHEN rev_len < 2500 THEN 1 ELSE 0 END)... |
2 years ago |
SELECT COUNT(*) articles,
SUM(CASE WHEN Nirmaljoshi.rev_len < 2500 THEN 1... |
2 years ago |
SELECT COUNT(*) articles,
SUM(CASE WHEN Nirmaljoshi.rev_len < 2500 THEN 1... |
2 years ago |
SELECT COUNT(*) articles,
SUM(CASE WHEN Nirmaljoshi.rev_len < 2500 THEN 1... |
2 years ago |
SELECT COUNT(*) Nirmaljoshi.articles
FROM (
SELECT *
FROM revision
... |
2 years ago |
SELECT *
FROM (
SELECT *
FROM revision
JOIN actor_revision ON actor_id... |
2 years ago |
SELECT *
FROM (
SELECT *
FROM revision
JOIN actor_revision ON actor_id... |
2 years ago |
SELECT COUNT(*) Nirmaljoshi.articles,
SUM(CASE WHEN Nirmaljoshi.rev_len <... |
2 years ago |
(SELECT *
FROM revision
JOIN actor_revision ON actor_id = rev_actor
... |
2 years ago |
SELECT *
FROM revision
JOIN actor_revision ON actor_id = rev_actor
... |
2 years ago |
SELECT *
FROM revision
JOIN actor_revision ON actor_id = rev_actor
... |
2 years ago |
COUNT(*) Nirmaljoshi.articles,
SUM(CASE WHEN Nirmaljoshi.rev_len < 2500... |
2 years ago |
COUNT(*) Nirmaljoshi.articles,
SUM(CASE WHEN Nirmaljoshi.rev_len < 2500... |
2 years ago |
COUNT(*) articles,
SUM(CASE WHEN rev_len < 2500 THEN 1 ELSE 0 END) as... |
2 years ago |
COUNT(*) articles,
SUM(CASE WHEN rev_len < 2500 THEN 1 ELSE 0 END) as... |
2 years ago |
COUNT(*) articles,
SUM(CASE WHEN rev_len < 2500 THEN 1 ELSE 0 END) as... |
2 years ago |
SELECT *
FROM revision
JOIN actor_revision ON actor_id = rev_actor
JOIN page... |
2 years ago |
SELECT COUNT(*) articles,
SUM(CASE WHEN rev_len < 2500 THEN 1 ELSE 0 END)... |
2 years ago |
SELECT COUNT(*) articles,
SUM(CASE WHEN rev_len < 2500 THEN 1 ELSE 0 END)... |
2 years ago |