| use itwikisource_p;
describe user_groups; |
3 years ago |
| use itwikisource_p;
describe users; |
3 years ago |
| use itwikisource_p;
select
user_name,
twofifty.cnt as edits,
... |
3 years ago |
| use itwiki_p;
select
user_name,
twofifty.cnt as edits,
onefive.cnt as... |
3 years ago |
| USE itwiki_p;
SELECT
revactor_actor,
actor_revision.actor_name,
... |
4 years ago |
| USE itwiki_p;
SELECT *
FROM user
WHERE user_editcount > 1000
AND user_id... |
4 years ago |
| USE itwiki_p;
SELECT *
FROM user
WHERE user_editcount > 10
AND user_id NOT... |
4 years ago |
| USE itwikisource_p;
SELECT *
FROM user
WHERE user_editcount > 100
AND... |
4 years ago |
| USE itwiki_p;
SELECT *
FROM user
WHERE user_editcount > 100
AND user_id NOT... |
4 years ago |
| USE itwiki_p;
SELECT *
FROM user
WHERE user_editcount > 300
AND user_id NOT... |
4 years ago |
| USE itwiki_p;
SELECT *
FROM user
WHERE user_editcount > 250
AND user_id NOT... |
4 years ago |
| USE itwiki_p;
SELECT *
FROM user
WHERE user_editcount > 500
AND user_id NOT... |
4 years ago |
| USE itwiki_p;
SELECT *
FROM user
WHERE user_editcount > 1000
AND user_id... |
4 years ago |
| USE itwiki_p;
SELECT *
FROM user
WHERE user_editcount > 1000 AND user_id NOT... |
4 years ago |
| USE itwiki_p;
SELECT user_id
FROM user
WHERE user_editcount > 1000 AND... |
4 years ago |
| USE itwiki_p;
SELECT *
FROM ipblocks
WHERE ipb_user != 0
#AND ipb_expiry =... |
4 years ago |
| USE itwiki_p;
SELECT *
FROM ipblocks
WHERE ipb_user != 0
AND ipb_expiry = 'infinity' |
4 years ago |
| USE itwiki_p;
SELECT *
FROM ipblocks
WHERE ipb_user != 0
AND ipb_expiry =... |
4 years ago |
| USE itwiki_p;
SELECT *
FROM ipblocks
WHERE ipb_user = 0
AND ipb_expiry =... |
4 years ago |
