| use commonswiki_p;
SELECT SUBSTRING(img_name, -4) AS 'Extension',... |
4 years ago |
| use commonswiki_p;
SELECT SUBSTRING(img_name, -4) AS 'Extension',... |
4 years ago |
| SELECT SUBSTRING(img_name, -4) AS 'Extension', COUNT(img_name) AS... |
4 years ago |
| use commonswiki_p;
SELECT SUBSTRING(img_name, -4) AS 'Extension',... |
4 years ago |
| SELECT SUBSTRING(img_name, -4) AS 'Extension', COUNT(img_name) AS... |
4 years ago |
| SELECT SUBSTRING(img_name, -4) AS 'Extension', COUNT(img_name) AS... |
4 years ago |
| SELECT SUBSTRING(img_name, -4) AS 'Extension', COUNT(img_name) AS... |
4 years ago |
| SELECT SUBSTRING(img_name, -4) AS 'Extension', COUNT(img_name) FROM... |
4 years ago |
| SELECT SUBSTRING(img_name, -4), COUNT(img_name) FROM image
GROUP BY... |
4 years ago |
| SELECT SUBSTRING(img_name, -4), COUNT(img_name) FROM image
GROUP BY... |
4 years ago |
| SELECT SUBSTRING(img_name, -4), COUNT(img_name) FROM image
GROUP BY... |
4 years ago |
| SELECT img_name, COUNT(img_name) FROM image
GROUP BY SUBSTRING(img_name, -4) |
4 years ago |
| SELECT CONCAT('[[:File:', REPLACE(img_name, '_', ' '), ']]') AS FILE FROM... |
4 years ago |
| SELECT * FROM image
WHERE NOT (
img_name LIKE '%.png'
OR img_name LIKE... |
4 years ago |
| SELECT CONCAT('[[', page_title, ']]') FROM page
WHERE page_namespace = 0
AND... |
4 years ago |
| SELECT CONCAT('[[', page_title, ']]'), page_id FROM page
WHERE... |
4 years ago |
| SELECT page_title, page_id FROM page
WHERE page_namespace = 0
AND page_id IN... |
4 years ago |
| SELECT page_title, page_id FROM page
WHERE page_namespace = 0
AND page_id IN... |
4 years ago |
| SELECT page_title, page_id FROM page
LIMIT 10 |
4 years ago |
| SELECT page_name, page_id FROM page
LIMIT 10 |
4 years ago |
| SELECT * FROM actor
WHERE actor_user = 34581532 |
4 years ago |
| SELECT * FROM actor
LIMIT 1 |
4 years ago |
| SELECT * FROM user
WHERE user_name = 'DannyS712' |
4 years ago |
| SELECT * FROM logging
WHERE log_type = 'move'
AND log_namespace = 6
LIMIT 100 |
4 years ago |
| SELECT * FROM logging
WHERE log_type = 'move'
LIMIT 100 |
4 years ago |
| SELECT * FROM logging
LIMIT 100 |
4 years ago |
| SELECT log_actor FROM logging_logindex
WHERE log_type = 'move'
AND... |
4 years ago |
| SELECT log_actor, COUNT(log_actor) FROM logging_logindex
WHERE log_type =... |
4 years ago |
| SELECT log_actor, COUNT(log_actor) FROM logging_logindex
WHERE log_type =... |
4 years ago |
| SELECT log_actor, COUNT(*) FROM logging_logindex
WHERE log_type = 'move'
AND... |
4 years ago |
| SELECT log_actor, COUNT(*) FROM logging_logindex
WHERE log_type = 'move'
AND... |
4 years ago |
| SELECT log_actor, COUNT(*) FROM logging_logindex
WHERE log_type = 'move'
AND... |
4 years ago |
| SELECT log_actor FROM logging_logindex
WHERE log_type = 'move'
AND... |
4 years ago |
| SELECT * FROM logging_logindex
WHERE log_type = 'move'
AND log_namespace =... |
4 years ago |
| SELECT * FROM logging_logindex
WHERE log_type = 'move'
AND log_namespace =... |
4 years ago |
| SELECT * FROM logging_logindex
WHERE log_type = 'move'
AND log_namespace =... |
4 years ago |
| SELECT * FROM logging_logindex
WHERE log_type = 'move'
AND log_namespace =... |
4 years ago |
| SELECT * FROM logging_logindex
WHERE log_type = 'move'
AND log_namespace = 6
LIMIT 10 |
4 years ago |
| SELECT * FROM logging
WHERE log_type = 'move'
AND log_namespace = 6
LIMIT 10 |
4 years ago |
| SELECT * FROM logging
WHERE log_type = 'move'
AND log_namespace = 6
LIMIT 100 |
4 years ago |
| SELECT * FROM logging
WHERE log_type = 'move'
LIMIT 100 |
4 years ago |
| SELECT DISTINCT log_type FROM logging |
4 years ago |
| SELECT * FROM logging
WHERE log_type <> 'delete'
LIMIT 100 |
4 years ago |
| SELECT * FROM logging
WHERE log_type <> 'delet'
LIMIT 100 |
4 years ago |
| SELECT * FROM logging
LIMIT 100 |
4 years ago |
| SELECT DISTINCT ug_group FROM user_groups |
4 years ago |
| SELECT user_id, user_name, user_registration FROM user
WHERE user_name = 'NVPA8200' |
4 years ago |
| SELECT * FROM user
WHERE user_name = 'NVPA8200' |
4 years ago |
| SELECT *, count(*) FROM logging_userindex
WHERE log_action = 'patrol'
GROUP... |
4 years ago |
| SELECT *, count(*) FROM logging_userindex
WHERE log_action = 'patrol'
GROUP... |
4 years ago |
| SELECT *, count(*) FROM logging_userindex
WHERE log_action = 'patrol'
GROUP... |
4 years ago |
| SELECT *, count(*) FROM logging_userindex
WHERE log_action = 'patrol'
GROUP... |
4 years ago |
| SELECT *, count(*) FROM logging
WHERE log_action = 'patrol'
GROUP BY... |
4 years ago |
| SELECT * FROM logging
WHERE log_action = 'patrol'
LIMIT 10 |
4 years ago |
| SELECT log_actor, log_user_text FROM logging
WHERE log_action = 'patrol'
LIMIT 10 |
4 years ago |
| SELECT log_actor, log_user_text FROM logging_userindex
WHERE log_action =... |
4 years ago |
| SELECT log_actor, log_user_text, count(*) FROM logging_userindex
WHERE... |
4 years ago |
| SELECT log_actor, log_user_text, count(*) FROM logging_userindex
WHERE... |
4 years ago |
| SELECT log_actor, log_user_text, count(*) FROM logging_userindex
WHERE... |
4 years ago |
| SELECT log_actor, log_user_text, count(*) FROM logging_userindex
WHERE... |
4 years ago |
| SELECT *, count(*) FROM logging_userindex
WHERE log_actor = 2167
AND... |
4 years ago |
| SELECT count(*) FROM logging_userindex
WHERE log_actor = 2167
AND log_action... |
4 years ago |
| SELECT * FROM logging_userindex
WHERE log_actor = 2167
AND log_action =... |
4 years ago |
| SELECT * FROM logging_userindex
WHERE log_actor = 2167
AND log_action =... |
4 years ago |
| SELECT * FROM logging_userindex
WHERE log_actor = 2167
AND log_action =... |
4 years ago |
| SELECT * FROM logging_userindex
WHERE log_actor = 2167
AND log_type NOT IN... |
4 years ago |
| SELECT * FROM logging_userindex
WHERE log_actor = 2167
AND log_type NOT IN... |
4 years ago |
| SELECT * FROM logging_userindex
WHERE log_actor = 2167
AND log_type NOT IN... |
4 years ago |
| SELECT * FROM logging_userindex
WHERE log_actor = 2167
AND log_type NOT IN... |
4 years ago |
| SELECT * FROM logging_userindex
WHERE log_actor = 2167
AND log_type NOT IN... |
4 years ago |
| SELECT * FROM logging_userindex
WHERE log_actor = 2167
AND log_type NOT IN... |
4 years ago |
| SELECT * FROM logging_userindex
WHERE log_actor = 2167
AND log_type <>... |
4 years ago |
| SELECT * FROM logging_userindex
WHERE log_actor = 2167
LIMIT 100 |
4 years ago |
| SELECT * FROM logging_userindex
WHERE log_actor = 2167
LIMIT 1000 |
4 years ago |
| SELECT * FROM logging_userindex
WHERE log_actor = 2167
LIMIT 10 |
4 years ago |
| SELECT * FROM logging_userindex
WHERE log_actor = 2167
LIMIT 1 |
4 years ago |
| SELECT * FROM logging
WHERE log_actor = 2167
LIMIT 1 |
4 years ago |
| SELECT * FROM logging
WHERE log_actor = 2167
LIMIT 10 |
4 years ago |
| SELECT * FROM actor
WHERE actor_user = 34581532
LIMIT 10 |
4 years ago |
| SELECT * FROM actor
WHERE actor_user = 34581532
LIMIT 10 |
4 years ago |
| SELECT * FROM logging
WHERE log_user = 34581532
LIMIT 10 |
4 years ago |
| SELECT * FROM logging
LIMIT 10 |
4 years ago |
| SELECT * FROM logging
WHERE log_user_text = 'DannyS712'
LIMIT 10 |
4 years ago |
| SELECT * FROM logging
WHERE log_user_text = 'DannyS712'
LIMIT 100 |
4 years ago |
| SELECT * FROM logging
LIMIT 100 |
4 years ago |
| SELECT count(*) FROM revision
WHERE rev_page = 12 |
4 years ago |
| SELECT * FROM revision
WHERE rev_page = 12 |
4 years ago |
| SELECT * FROM change_tag_def |
4 years ago |
| blank query |
4 years ago |
| DESCRIBE heartbeat |
4 years ago |
| SELECT COUNT(page_title) FROM page
WHERE page_namespace = 0
AND... |
4 years ago |
| SELECT COUNT(page_id) FROM page
WHERE page_namespace = 0
AND... |
4 years ago |
| SELECT COUNT(page_title) FROM page
WHERE page_namespace = 0
AND... |
4 years ago |
| SELECT COUNT(*) FROM page
WHERE page_namespace = 0
AND page_is_redirect =... |
4 years ago |
| SELECT * FROM change_tag_def |
4 years ago |
| SELECT * FROM recentchanges
WHERE rc_this_oldid = 893409469 |
4 years ago |
| SELECT * FROM change_tag_def |
4 years ago |
| SELECT pp_page FROM page_props
WHERE pp_propname = 'disambiguation'
LIMIT 100 |
4 years ago |
| SELECT * FROM page_props
WHERE pp_propname = 'disambiguation'
LIMIT 5 |
4 years ago |
| SELECT * FROM page_props
WHERE pp_propname = 'disambiguation'
AND pp_value =... |
4 years ago |
| SELECT * FROM page_props
WHERE pp_propname = 'disambiguation'
AND pp_value =... |
4 years ago |
| SELECT * FROM page_props
WHERE pp_propname = 'disambiguation'
AND pp_value =... |
4 years ago |
| SELECT * FROM page_props
WHERE pp_propname = 'disambiguation'
AND pp_value =... |
4 years ago |
| SELECT * FROM page_props
WHERE pp_propname = 'disambiguation'
AND pp_value =... |
4 years ago |
| SELECT page_id, page_namespace, CONCAT('[[:Category:', page_title, ']]')... |
4 years ago |
| SELECT page_id, CONCAT('[[:Category:', page_title, ']]') FROM page
WHERE... |
4 years ago |
| SELECT * FROM page
WHERE page_namespace = 14
AND page_title REGEXP... |
4 years ago |
| SELECT * FROM page
WHERE page_namespace = 14
AND page_title REGEXP... |
4 years ago |
| SELECT * FROM page
WHERE page_namespace = 14
AND page_title REGEXP... |
4 years ago |
| SELECT * FROM page
WHERE page_namespace = 14
AND page_title REGEXP... |
4 years ago |
| SELECT * FROM page
WHERE page_namespace = 14
AND page_title REGEXP... |
4 years ago |
| SELECT * FROM page
WHERE page_namespace = 14
AND page_title REGEXP... |
4 years ago |
| SELECT * FROM page
WHERE page_namespace = 14
AND page_title REGEXP... |
4 years ago |
| SELECT * FROM page
WHERE page_namespace = 14
AND page_title REGEXP... |
4 years ago |
| SELECT * FROM page
WHERE page_namespace = 14
AND page_title LIKE... |
4 years ago |
| SELECT * FROM page
WHERE page_namespace = 14
AND page_title LIKE '%Esports%'
LIMIT 50 |
4 years ago |
| SELECT * FROM page
WHERE page_namespace = 14
AND page_title LIKE '%eSports%'
LIMIT 50 |
4 years ago |
| SELECT * FROM page
WHERE page_namespace = 14
AND page_title LIKE '%Esports%'
LIMIT 50 |
4 years ago |
| SELECT * FROM page
WHERE page_namespace = 14
AND page_title LIKE '%esports%'
LIMIT 50 |
4 years ago |
| SELECT * FROM page
WHERE page_namespace = 14
AND page_title LIKE '%esports'
LIMIT 50 |
4 years ago |
| SELECT * FROM page
WHERE page_namespace = 14
AND page_title LIKE '%esports'
LIMIT 50 |
4 years ago |
| SELECT * FROM page
WHERE page_namespace = 14
LIMIT 50 |
4 years ago |
| SELECT * FROM page
WHERE page_namespace = 14
AND page_title LIKE '%eSports%'
LIMIT 50 |
4 years ago |
| SELECT DISTINCT cl_to FROM categorylinks
WHERE cl_type = 'subcat'
LIMIT 100 |
5 years ago |
| SELECT cl_to, cl_from, page.page_title FROM categorylinks
LEFT JOIN page
ON... |
5 years ago |
| SELECT DISTINCT cl_to, cl_from, page.page_title FROM categorylinks
LEFT JOIN... |
5 years ago |
| SELECT cl_from, DISTINCT cl_to, page.page_title FROM categorylinks
LEFT JOIN... |
5 years ago |
| SELECT cl_from, cl_to, page.page_title FROM categorylinks
LEFT JOIN page
ON... |
5 years ago |
| SELECT cl_from, page.page_title FROM categorylinks
LEFT JOIN page
ON... |
5 years ago |
| SELECT cl_from, page.page_title FROM categorylinks
LEFT JOIN page
ON... |
5 years ago |
| SELECT cl_from, page.page_title FROM categorylinks
LEFT JOIN page
ON... |
5 years ago |
| SELECT cl_from, page.page_title FROM categorylinks
LEFT JOIN page
ON... |
5 years ago |
| SELECT cl_from, page.page_title FROM categorylinks
LEFT JOIN page
ON... |
5 years ago |
| SELECT cl_from, page.page_title FROM categorylinks
LEFT JOIN page
ON... |
5 years ago |
| SELECT *, page.* FROM categorylinks
LEFT JOIN page
ON page.page_id =... |
5 years ago |
| SELECT cl_from, page.* FROM categorylinks
LEFT JOIN page
ON page.page_id =... |
5 years ago |
| SELECT page_title
FROM page
LEFT JOIN categorylinks
ON... |
5 years ago |
| SELECT page_title
FROM page
LEFT JOIN categorylinks
ON... |
5 years ago |
| SELECT page_title
FROM page
LEFT JOIN categorylinks
ON... |
5 years ago |
| SELECT DISTINCT cl_from FROM categorylinks
WHERE cl_type = 'subcat'
LIMIT 100 |
5 years ago |
| SELECT DISTINCT cl_from FROM categorylinks
LIMIT 100 |
5 years ago |
| SELECT DISTINCT cl_from FROM categorylinks |
5 years ago |
| SELECT * FROM user_groups
LEFT JOIN user ON user_groups.ug_user =... |
5 years ago |
| SELECT * FROM user_groups
LEFT JOIN user ON user_groups.ug_user =... |
5 years ago |
| SELECT * FROM page
LEFT JOIN revision
ON page.page_latest =... |
5 years ago |
| SELECT * FROM abuse_filter_log
WHERE afl_user = 'DannyS712' |
5 years ago |
| DESCRIBE abuse_filter_log |
5 years ago |
| SELECT * FROM abuse_filter_log |
5 years ago |
