USE fawiki_p;
SELECT
CONCAT(
CASE
WHEN page_namespace = 0 THEN... |
4 years ago |
USE fawiki_p;
SELECT
CONCAT(
CASE
WHEN page_namespace = 0 THEN... |
4 years ago |
USE fawiki_p;
SELECT
page_namespace,
page_title,
MIN(rev_timestamp) AS... |
4 years ago |
USE fawiki_p;
SELECT
page_namespace,
page_title,
COUNT(*) AS... |
4 years ago |
USE fawiki_p;
SELECT
page_id,
COUNT(*) AS edits
FROM revision
JOIN page
... |
4 years ago |
USE fawiki_p;
SELECT
page_id,
COUNT(*) AS edits
FROM revision
JOIN page
... |
4 years ago |
USE fawiki_p;
SELECT
rev_page,
COUNT(*) AS edits
FROM revision
GROUP BY... |
4 years ago |
USE fawiki_p;
SELECT MAX(rc_id)
FROM recentchanges |
4 years ago |
use fawiki_p;
select
recentchanges.*
from recentchanges
limit 10 |
4 years ago |
use fawiki_p;
select
rc_id,
rc_timestamp,
actor_user,
... |
4 years ago |
use fawiki_p;
select
rc_id,
rc_timestamp,
actor_user,
... |
4 years ago |
use fawiki_p;
select
rc_id,
rc_timestamp,
actor_user,
... |
4 years ago |