| use fawiki_p;
SELECT
actor_name,
COUNT(rev_id) AS freq
FROM... |
4 years ago |
| use fawiki_p;
SELECT
actor_name,
COUNT(*)
FROM logging_userindex
JOIN... |
4 years ago |
| use fawiki_p;
SELECT
actor_name,
GROUP_CONCAT(DISTINCT(ug_group)... |
4 years ago |
| use fawiki_p;
SELECT
actor_name,
CONCAT('... |
4 years ago |
| use fawiki_p;
/*SELECT
users.user_name,
CONCAT('... |
4 years ago |
| use fawiki_p;
/*SELECT
users.user_name,
CONCAT('... |
4 years ago |
| use fawiki_p;
/*SELECT
users.user_name,
CONCAT('... |
4 years ago |
| use fawiki_p;
SELECT DISTINCT
rev_user_text,
COUNT(*) cnt,
CASE
... |
4 years ago |
| use fawiki_p;
SELECT DISTINCT
rev_user_text,
COUNT(*) cnt,
CASE
... |
4 years ago |
| use fawiki_p;
SELECT
actor_name,
STR_TO_DATE(LEFT(min(rev_timestamp),... |
4 years ago |
| use fawiki_p;
/*SELECT
rev_user_text,
... |
4 years ago |
| use fawiki_p;
SELECT rev_user, rev_user_text, rev_actor
FROM revision
where... |
4 years ago |
| use fawiki_p;
SELECT *
FROM revision
where rev_user = 0
limit 100 |
4 years ago |
| use fawiki_p;
explain ipblocks |
4 years ago |
| use fawiki_p;
SELECT
user_name blockee,
actor_name blocker,
... |
4 years ago |
| use fawiki_p;
explain ipblocks |
4 years ago |
| use fawiki_p;
SELECT
actor_name,
sum(img_size) AS tot
FROM image
JOIN... |
4 years ago |
| use fawiki_p;
SELECT
actor_name,
sum(img_size) AS tot
FROM image
JOIN... |
4 years ago |
| use fawiki_p;
explain image |
4 years ago |
| use fawiki_p;
SELECT
ipb_address,
MID(ipb_address, INSTR(ipb_address,... |
4 years ago |
| use fawiki_p;
explain actor |
4 years ago |
| use fawiki_p;
SELECT *
FROM (
SELECT DISTINCT
user_name,
... |
4 years ago |
| use fawiki_p;
SELECT
user_name,
IFNULL(del.cnt, 0),
IFNULL(res.cnt,... |
4 years ago |
| use fawiki_p;
SELECT
user_name,
IFNULL(del.cnt, 0),
IFNULL(res.cnt,... |
4 years ago |
| use fawiki_p;
SELECT
user_name,
IFNULL(del.cnt, 0),
IFNULL(res.cnt,... |
4 years ago |
| use fawiki_p;
SELECT
user_name,
COUNT(log_id) cnt
FROM user
JOIN actor
... |
4 years ago |
| use fawiki_p;
SELECT *
FROM page
WHERE page_id = 1171408 |
4 years ago |
| use fawiki_p;
SELECT page_title
FROM page
JOIN (
SELECT
rev_page,
... |
4 years ago |
| use fawiki_p;
SELECT * FROM user_properties WHERE up_property = 'nickname'... |
4 years ago |
| use fawiki_p;
SELECT * FROM user_properties WHERE up_property = 'nickname'... |
4 years ago |
| use fawiki_p;
SELECT * FROM user_properties WHERE up_property = 'nickname'... |
4 years ago |
| use fawiki_p;
SELECT * FROM user_properties WHERE up_property = 'nickname' LIMIT 100 |
4 years ago |
| use fawiki_p;
SELECT DISTINCT up_value FROM user_properties WHERE... |
4 years ago |
| use fawiki_p;
SELECT DISTINCT up_value FROM user_properties WHERE... |
4 years ago |
| use fawiki_p;
SELECT * FROM user_properties WHERE up_property = 'gender' LIMIT 100 |
4 years ago |
| use fawiki_p;
SELECT * FROM user_properties WHERE up_property = 'gender' |
4 years ago |
| use fawiki_p;
SELECT up_property, COUNT(*) FROM user_properties GROUP BY up_property |
4 years ago |
| use fawiki_p;
SELECT up_property, COUNT(*) FROM user_properties GROPU BY up_property |
4 years ago |
| use fawiki_p;
SELECT * FROM user_properties LIMIT 100 |
4 years ago |
| use fawiki_p;
SELECT * FROM user_properties |
4 years ago |
| use fawiki_p;
SELECT
ipb_address,
actor_name,
... |
4 years ago |
| use fawiki_p;
SELECT
ipb_address,
ipb_by_text,
... |
4 years ago |
