test |
2 years ago |
SELECT
rev_user_text, COUNT(*)
FROM revision
JOIN page
ON rev_page =... |
2 years ago |
SELECT
SUBSTR(rev_timestamp, 1, 6) AS MONTH,
COUNT(rev_id) AS edits
FROM... |
2 years ago |
SELECT
SUBSTR(rev_timestamp, 1, 6) AS MONTH,
COUNT(rev_id) AS edits
FROM... |
2 years ago |
SELECT
SUBSTR(rev_timestamp, 1, 6) AS MONTH,
COUNT(rev_id) AS edits
FROM... |
2 years ago |
SELECT
select concat ("{{u|",user_name,"}}") as "username",
... |
2 years ago |
SELECT
COUNT(rev_id) AS edits
JOIN user ON rev_user = user_id
AND... |
2 years ago |
blank query |
3 years ago |
USE trwiki_p;
SELECT CONCAT('# [[', page_title ,']]') AS page_title,... |
3 years ago |
USE trwiki_p;
SELECT CONCAT('# [[', page_title ,']]') AS page_title,... |
3 years ago |
USE trwiki_p;
SELECT CONCAT('# [[', page_title ,']]') AS page_title,... |
3 years ago |
USE trwiki_p;
SELECT CONCAT('# [[', page_title ,']]') AS page_title,... |
3 years ago |
USE trwiki_p;
SELECT CONCAT('# [[', page_title ,']]') AS page_title,... |
3 years ago |