use frwiki_p;
SELECT user_name, count(1) as count
FROM... |
3 years ago |
use frwiki_p;
SELECT DISTINCT ctd_name
FROM change_tag_def
ORDER BY ctd_name;
|
3 years ago |
use frwiki_p;
SELECT DISTINCT(log_type)
FROM logging
ORDER BY log_type;
|
3 years ago |
use frwiki_p;
SELECT DISTINCT(log_type)
FROM logging;
|
3 years ago |
use frwiki_p;
SELECT DISTINCT(log_type)
FROM logging
LIMIT 10;
|
3 years ago |
use frwiki_p;
SELECT DISTINCT(log_type)
FROM logging_userindex
LIMIT 10;
|
3 years ago |
use frwiki_p;
SELECT DISTINC(log_type)
FROM logging_userindex
LIMIT 10;
|
3 years ago |
use frwiki_p;
SELECT *
FROM logging_userindex
WHERE log_type = 'patrol'
LIMIT 10;
|
3 years ago |
use frwiki_p;
SELECT *
FROM logging_userindex
WHERE log_type = 'review'
LIMIT 10;
|
3 years ago |
use frwiki_p;
SELECT *
FROM logging_userindex
LIMIT 10;
|
3 years ago |
use frwiki_p;
SELECT *
FROM logging_userindex
WHERE log_type = 'review'
LIMIT 10;
|
3 years ago |
use frwiki_p;
SELECT *
FROM logging_userindex
WHERE log_type =... |
3 years ago |
use frwiki_p;
SELECT user_name, count(1) as count
FROM... |
3 years ago |
use frwiki_p;
SELECT user_name, count(1) as count
FROM logging
LEFT JOIN... |
3 years ago |
use frwiki_p;
SELECT *
FROM logging
WHERE log_actor=2316059
AND log_type =... |
3 years ago |
use frwiki_p;
SELECT log_actor, user_id, user_name
FROM logging, user
WHERE... |
3 years ago |
use frwiki_p;
SELECT log_actor, user_id, user_name
FROM logging, user
WHERE... |
3 years ago |
use frwiki_p;
SELECT log_actor, user_id, user_name
FROM logging, user
WHERE... |
3 years ago |
use frwiki_p;
SELECT *
FROM logging, user
WHERE log_actor = user_id
AND... |
3 years ago |
use frwiki_p;
SELECT *
FROM logging, user
WHERE log_actor = user_id
LIMIT 10;
|
3 years ago |
use frwiki_p;
SELECT *
FROM logging
WHERE log_actor=2316059
AND log_type =... |
3 years ago |
use frwiki_p;
SELECT *
FROM user
WHERE user_name like 'Ciseleur'
LIMIT 10;
|
3 years ago |
use frwiki_p;
SELECT *
FROM logging
WHERE log_actor=26339962
AND log_type =... |
3 years ago |
use frwiki_p;
SELECT *
FROM logging
WHERE user_id=26339962
AND log_type =... |
3 years ago |
SELECT *
FROM user
WHERE user_name like 'Ciseleur'
LIMIT 10; |
3 years ago |
use frwiki_p;
SELECT *
FROM user_groups
LIMIT 10;
|
3 years ago |
use frwiki_p;
SELECT *
FROM logging
WHERE log_type = 'patrol'
LIMIT 10; |
3 years ago |
use frwiki_p;
SELECT *
FROM logging
LIMIT 10; |
3 years ago |
use frwiki_p;
SELECT user_name, count(1) as count
FROM logging
LEFT JOIN... |
4 years ago |
use frwiki_p;
SELECT count(1) as count, log_user_text
FROM logging
LEFT JOIN... |
4 years ago |
use frwiki_p;
SELECT count(1) as user_name, count
FROM logging
LEFT JOIN... |
4 years ago |
use frwiki_p;
SELECT count(1) as count, user_name
FROM logging
LEFT JOIN... |
4 years ago |
use frwiki_p;
SELECT count(1) as count, user_name
FROM logging
LEFT JOIN... |
4 years ago |
use frwiki_p;
SELECT pl_namespace, pl_title, COUNT(*) AS nlinks
FROM... |
4 years ago |
use frwiki_p;
SELECT count(1) as count, user_name
FROM logging
LEFT JOIN... |
4 years ago |