| USE commonswiki_p;
SELECT IF(rev_parent_id = 0,"create", "edit"),... |
4 years ago |
| USE commonswiki_p;
SELECT IF(rev_parent_id = 0,"create", "edit"),... |
4 years ago |
| USE commonswiki_p;
SELECT IF rev_parent_id = 0 THEN "create" ELSE "edit",... |
4 years ago |
| USE commonswiki_p;
SELECT (IF rev_parent_id = 0 THEN "create" ELSE "edit"),... |
4 years ago |
| USE commonswiki_p;
SELECT rev_parent_id = 0, LEFT(rev_timestamp, 6),... |
4 years ago |
| USE commonswiki_p;
SELECT rev_parent_id = 0, LEFT(rev_timestamp, 6),... |
4 years ago |
| USE commonswiki_p;
SELECT rev_parent_id = 0, LEFT(rev_timestamp, 6)... |
4 years ago |
| USE commonswiki_p;
SELECT rev_parent_id = 0, COUNT(*)
FROM... |
4 years ago |
| USE commonswiki_p;
SELECT rev_parent_id = 0, revision_userindex.*
FROM... |
4 years ago |
| USE commonswiki_p;
SELECT rev_parent_id = 0, *
FROM revision_userindex
JOIN... |
4 years ago |
| USE commonswiki_p;
SELECT rev_parent_id = 0, *
FROM revision_userindex
JOIN... |
4 years ago |
| USE commonswiki_p;
SELECT (rev_parent_id = 0), *
FROM... |
4 years ago |
| USE commonswiki_p;
SELECT *
FROM revision_userindex
JOIN page ON rev_page =... |
4 years ago |
| USE commonswiki_p;
SELECT COUNT(rev_id)
FROM revision_userindex
JOIN page ON... |
4 years ago |
| USE commonswiki_p;
SELECT COUNT(page_id)
FROM revision_userindex
JOIN page... |
4 years ago |
| USE commonswiki_p;
SELECT COUNT(*)
FROM revision_userindex
JOIN page ON... |
4 years ago |
| USE commonswiki_p;
SELECT (rev_parent_id = 0), COUNT(*)
FROM... |
4 years ago |
| USE commonswiki_p;
SELECT rev_parent_id = 0, COUNT(*)
FROM... |
4 years ago |
| USE commonswiki_p;
SELECT COUNT(*)
FROM revision_userindex
JOIN page ON... |
4 years ago |
