USE enwiki_p;
SELECT COUNT(DISTINCT user_id)
FROM user
LEFT JOIN user_groups... |
6 years ago |
USE enwiki_p;
SELECT COUNT(DISTINCT user_id)
FROM user
LEFT JOIN user_groups... |
6 years ago |
USE enwiki_p;
SELECT COUNT(DISTINCT user.user_id)
FROM user
INNER JOIN... |
6 years ago |
USE enwiki_p;
SELECT COUNT(*)
FROM user
INNER JOIN recentchanges ON... |
6 years ago |
USE enwiki_p;
SELECT COUNT(*)
FROM user
INNER JOIN recentchanges ON... |
6 years ago |
USE enwiki_p;
SELECT COUNT(*) FROM user AS u recentchanges AS rc
INNER JOIN... |
6 years ago |
USE enwiki_p;
SELECT COUNT(*) FROM user recentchanges
INNER JOIN user... |
6 years ago |
USE enwiki_p;
SELECT COUNT(*) FROM (
INNER JOIN user recentchanges ON... |
6 years ago |
USE enwiki_p;
SELECT COUNT(*) FROM user recentchanges
INNER JOIN user... |
6 years ago |
USE enwiki_p;
SELECT * FROM user LIMIT 10; |
6 years ago |
USE enwiki_p;
SELECT COUNT(*) FROM user WHERE user_editcount >= 100; |
6 years ago |
USE enwiki_p;
SELECT * FROM user LIMIT 10; |
6 years ago |
USE enwiki_p;
SELECT COUNT(1) FROM recentchanges; |
6 years ago |
USE enwiki_p;
SHOW TABLE STATUS; |
6 years ago |
USE enwiki_p;
SELECT COUNT(1) FROM recentchanges; |
6 years ago |
USE enwiki_p;
SELECT TABLE_ROWS FROM INFORMATION_SCHEMA.TABLES
WHERE... |
6 years ago |
USE enwiki_p;
SELECT * FROM recentchanges LIMIT 10; |
6 years ago |
USE enwiki_p;
SHOW TABLES; |
6 years ago |
USE enwiki_p;
SELECT * FROM user LIMIT 20; |
6 years ago |
USE enwiki_p;
SELECT COUNT(DISTINCT user_name) FROM user; |
6 years ago |
USE enwiki_p;
SELECT * FROM user LIMIT 10; |
6 years ago |
USE enwiki_p;
SELECT * FROM user_groups LIMIT 10; |
6 years ago |
USE enwiki_p;
SELECT ug_group, COUNT(*) FROM user_groups GROUP BY ug_group; |
6 years ago |
USE enwiki_p;
SELECT COUNT(*) ug_group FROM (SELECT DISTINCT ug_group FROM... |
6 years ago |
USE enwiki_p;
SELECT COUNT(*) ug_group FROM (SELECT DISTINCT ug_group) AS t; |
6 years ago |
USE enwiki_p;
SELECT COUNT(*) ug_group FROM (SELECT DISTINCT ug_group); |
6 years ago |
USE enwiki_p;
SELECT * FROM user_groups LIMIT 10; |
6 years ago |
USE enwiki_p;
SELECT COUNT(DISTINCT ug_user) FROM user_groups; |
6 years ago |
USE enwiki_p;
SELECT * FROM user_groups LIMIT 100; |
6 years ago |
USE enwiki_p;
SELECT * FROM user_groups LIMIT 10; |
6 years ago |
USE enwiki_p;
SELECT * FROM user_properties LIMIT 10; |
6 years ago |
USE enwiki_p;
SELECT COUNT(*) FROM user_properties; |
6 years ago |
USE enwiki_p;
SHOW TABLES; |
6 years ago |
USE enwiki_p;
SELECT COUNT(*) FROM bot_passwords; |
6 years ago |
USE enwiki_p;
SELECT * FROM user
LIMIT 5; |
6 years ago |