SELECT 'rollback' AS action, page_id AS pageid, actor_name AS user FROM page... |
3 months ago |
SELECT 'rollback' AS action, page_id AS pageid, actor_name AS user FROM page... |
3 months ago |
# SELECT page_id, actor_name FROM page INNER JOIN revision ON page_latest =... |
3 months ago |
# SELECT page_id, actor_name FROM page INNER JOIN revision ON page_latest =... |
3 months ago |
# SELECT page_id, actor_name FROM page INNER JOIN revision ON page_latest =... |
3 months ago |
SELECT page_id, actor_name FROM page INNER JOIN revision ON page_latest =... |
3 months ago |
SELECT page_namespace, page_title, actor_name FROM page INNER JOIN revision... |
3 months ago |
SELECT page_namespace, page_title, actor_name FROM page INNER JOIN revision... |
3 months ago |
SELECT * FROM page INNER JOIN revision ON page_latest = rev_id LIMIT 10; |
3 months ago |
SELECT * FROM page LEFT JOIN revision ON page_latest = rev_id LIMIT 10; |
3 months ago |
SELECT * FROM page LEFT JOIN revision ON page_id = rev_page LIMIT 10; |
3 months ago |
SELECT page_namespace, page_title FROM actor LEFT JOIN revision ON actor_id... |
3 months ago |
SELECT * FROM actor LEFT JOIN revision ON actor_id = rev_actor INNER JOIN... |
3 months ago |
SELECT * FROM actor LEFT JOIN revision ON actor_id = rev_actor WHERE... |
3 months ago |
SELECT * FROM actor WHERE actor_user IS NULL LIMIT 10; |
3 months ago |
SELECT * FROM actor LIMIT 10; |
3 months ago |
SELECT * FROM recentchanges ORDER BY rc_id DESC LIMIT 1;
SELECT * FROM... |
3 months ago |
SELECT * FROM recentchanges ORDER BY rc_id DESC LIMIT 1; |
3 months ago |
SELECT * FROM recentchanges LIMIT 1; |
3 months ago |