| SHOW COLUMNS FROM abuse_filter;
SHOW COLUMNS FROM abuse_filter_action;
SHOW... |
10 months ago |
|
BEGIN NOT ATOMIC
DECLARE c CURSOR FOR EXECUTE IMMEDIATE 'SHOW... |
10 months ago |
|
BEGIN NOT ATOMIC
DECLARE c CURSOR FOR SHOW TABLES;
DECLARE CONTINUE HANDLER... |
10 months ago |
|
BEGIN NOT ATOMIC
DECLARE c CURSOR FOR 'SHOW TABLES';
-- DECLARE CONTINUE... |
10 months ago |
|
BEGIN NOT ATOMIC
DECLARE c CURSOR FOR 'SHOW TABLES';
DECLARE CONTINUE... |
10 months ago |
|
BEGIN NOT ATOMIC
EXECUTE IMMEDIATE 'SHOW TABLES';
END |
10 months ago |
|
BEGIN NOT ATOMIC
EXECUTE IMMEDIATE 'SELECT 1';
END |
10 months ago |
| BEGIN NOT ATOMIC
EXECUTE IMMEDIATE 'SELECT 1'
END |
10 months ago |
| show columns from category;
show columns from categorylinks;
|
10 months ago |
| SELECT * FROM linktarget JOIN pagelinks on lt_id = pl_target_id LIMIT 5;
|
10 months ago |
| SELECT * FROM linktarget JOIN pagelinks on lt_id = pl_from LIMIT 5;
|
10 months ago |
| SELECT * FROM pagelinks LIMIT 5;
|
10 months ago |
| SELECT * FROM linktarget JOIN pagelinks on lt_id = pl_id LIMIT 5;
|
10 months ago |
| SELECT * FROM linktarget JOIN pagelinks on lt_id = page_id LIMIT 5;
|
10 months ago |
| SELECT * FROM linktarget LIMIT 5;
|
10 months ago |
| SELECT * FROM pagelinks JOIN linktarget LIMIT 5;
|
10 months ago |
| SELECT * FROM linktarget LIMIT 15;
|
10 months ago |
| SELECT * FROM linktarget LIMIT 5;
SELECT * FROM linter LIMIT 5;
|
10 months ago |
| SELECT * FROM global_block_whitelist LIMIT 5 |
10 months ago |
| SELECT ipb_expiry, COUNT(*) FROM ipblocks GROUP BY IF(ipb_expiry =... |
10 months ago |
| SELECT ipb_expiry, COUNT(*) FROM ipblocks GROUP BY IF(ipb_expiry, 'infinity'); |
10 months ago |
| SELECT ipb_expiry, COUNT(*) FROM ipblocks GROUP BY ipb_expiry; |
10 months ago |
| SELECT * FROM ipblocks LIMIT 5; |
10 months ago |
| SELECT COUNT(*) FROM ipblocks; |
10 months ago |
| SHOW engine innodb status |
10 months ago |
| SHOW PROCESSLIST |
10 months ago |
| show databases |
10 months ago |
| show databases |
10 months ago |
| select table_schema, table_name from information_schema.tables |
10 months ago |
| show create table bgwiki.site_stats |
10 months ago |
| show create table site_stats |
10 months ago |
| SELECT * FROM site_stats LIMIT 5 |
10 months ago |
| SELECT * FROM site_identifiers LIMIT 5 |
10 months ago |
| SELECT * FROM updatelog LIMIT 5 |
10 months ago |
| SELECT * FROM transcode LIMIT 5 |
10 months ago |
| select * from revision WHERE rev_actor = 450 AND rev_deleted > 0; |
10 months ago |
| select * from revision where rev_actor = 450 WHERE rev_deleted > 0; |
10 months ago |
| select * from revision where rev_actor = 450; |
10 months ago |
| select * from revision where rev_actor = 123457; |
10 months ago |
| select * from actor where actor_name LIKE 'Сал%' |
10 months ago |
| select * from actor where actor_name LIKE 'Са%' |
10 months ago |
| select * from actor where actor_name LIKE 'С%' |
10 months ago |
| SELECT rev_actor, DATE_FORMAT(MIN(rev_timestamp), '%Y-%m-%d') AS first_rev... |
10 months ago |
| SELECT rev_actor, DATE_FORMAT(MIN(rev_timestamp), '%Y-%m-%d') AS first_rev... |
10 months ago |
| SELECT rev_actor, DATE_FORMAT(MIN(rev_timestamp), '%Y-%m-%d') AS first_rev... |
10 months ago |
| SELECT
actor_name AS editor,
COUNT(*) AS revisions,
... |
10 months ago |
| SELECT
actor_name AS editor,
COUNT(*) AS revisions,
... |
10 months ago |
| SELECT
actor_name AS editor,
COUNT(*) AS revisions,
... |
10 months ago |
| SELECT
actor_name AS editor,
COUNT(*) AS revisions,
... |
10 months ago |
| SELECT
actor_name AS editor,
COUNT(*) AS revisions,
... |
10 months ago |
| SELECT
actor_name AS editor,
COUNT(*) AS revisions,
... |
10 months ago |
| SELECT
actor_name AS editor,
COUNT(*) AS revisions,
... |
10 months ago |
| SELECT
actor_name AS editor,
COUNT(*) AS revisions,
... |
10 months ago |
| EXPLAIN
SELECT
actor_name AS editor,
COUNT(*) AS revisions,
... |
10 months ago |
| SELECT
actor_name AS editor,
COUNT(*) AS revisions,
... |
10 months ago |
| SELECT
actor_name AS editor,
COUNT(*) AS revisions,
... |
10 months ago |
| SElECT page_title, COUNT(*)
FROM externallinks el JOIN page p ON el_from =... |
10 months ago |
| SElECT page_title, COUNT(*)
FROM externallinks el JOIN page p ON el_from =... |
10 months ago |
| select * from page limit 5; |
10 months ago |
| SElECT page_title, COUNT(*) FROM externallinks el JOIN page p ON el_from =... |
10 months ago |
| SElECT * FROM externallinks el JOIN page p ON el_from = page_id LIMIT 5 |
10 months ago |
| SElECT * FROM externallinks el JOIN pages p ON el_from = page_id LIMIT 5 |
10 months ago |
| SElECT * FROM externallinks LIMIT 5 |
10 months ago |
| SElECT * FROM externallinks |
10 months ago |
| SELECT
actor_name AS editor,
COUNT(*) AS revisions,
... |
10 months ago |
| SELECT
actor_name AS editor,
COUNT(*) AS revisions,
... |
10 months ago |
| SELECT
actor_name AS editor,
COUNT(*) AS revisions,
... |
10 months ago |
| SELECT r.*, p.page_title FROM redirect r JOIN page p ON r.rd_from =... |
10 months ago |
| SELECT r.*, p.page_title FROM redirect r JOIN page p ON r.rd_from =... |
10 months ago |
| SELECT r.*, p_page_title FROM redirect r JOIN page p ON r.rd_from =... |
10 months ago |
| SELECT * FROM redirect JOIN page ON rd_from = page_id LIMIT 5; |
10 months ago |
| SELECT * FROM redirect LIMIT 5; |
10 months ago |
| SELECT * FROM redirect; |
10 months ago |
| SELECT
actor_name AS editor,
COUNT(*) AS revisions,
... |
10 months ago |
| SELECT
actor_name AS editor,
COUNT(*) AS revisions,
... |
10 months ago |
| SELECT
actor_name AS editor,
COUNT(*) AS revisions,
... |
10 months ago |
| SELECT * FROM ip_changes LIMIT 5 |
10 months ago |
| SELECT * FROM babel LIMIT 5 |
10 months ago |
| SELECT * FROM actor_revision LIMIT 5; |
10 months ago |
| SELECT * FROM actor LIMIT 5; |
10 months ago |
| SELECT
actor_name AS editor,
COUNT(*) AS revisions,
... |
10 months ago |
| SELECT
actor_name AS editor,
COUNT(*) AS revisions,
... |
10 months ago |
| SELECT
actor_name AS editor,
COUNT(*) AS revisions,
... |
10 months ago |
| SELECT
actor_name AS editor,
COUNT(*) AS revisions,
... |
10 months ago |
| SELECT
actor_name AS editor,
COUNT(*) AS revisions,
... |
10 months ago |
| SELECT COUNT(DISTINCT p.page_id)
FROM page p JOIN pagelinks pl ON p.page_id... |
10 months ago |
| SELECT
page_title
FROM page
JOIN pagelinks
ON pl_from = page_id
JOIN... |
10 months ago |
| SELECT
page_title
FROM page
JOIN pagelinks
ON pl_from = page_id
JOIN... |
10 months ago |
| SELECT COUNT(DISTINCT page_title), COUNT(*) FROM page
JOIN categorylinks
ON... |
10 months ago |
| SELECT * FROM templatelinks LIMIT 5 |
10 months ago |
| SELECT COUNT(DISTINCT page_title) FROM page
JOIN templatelinks
ON tl_from =... |
10 months ago |
| SELECT COUNT(DISTINCT page_title) FROM page
JOIN templatelinks
ON tl_from =... |
10 months ago |
| SELECT COUNT(DISTINCT page_title) FROM page
JOIN templatelinks
ON tl_from =... |
10 months ago |
| SELECT COUNT(DISTINCT page_title) FROM page
JOIN templatelinks
ON tl_from =... |
10 months ago |
| SELECT DISTINCT page_title, cl_to FROM page
JOIN templatelinks
ON tl_from =... |
10 months ago |
| SELECT DISTINCT page_title, cl_to FROM page
JOIN templatelinks
ON tl_from =... |
10 months ago |
| SELECT DISTINCT page_title, cl_to FROM page
JOIN templatelinks
ON tl_from =... |
10 months ago |
| SELECT DISTINCT page_title, cl_to FROM page
JOIN templatelinks
ON tl_from =... |
10 months ago |
| SELECT DISTINCT page_title, cl_to FROM page
JOIN templatelinks
ON tl_from =... |
10 months ago |
| SELECT DISTINCT page_title FROM page
JOIN templatelinks
ON tl_from =... |
10 months ago |
| SELECT page_title FROM page
JOIN templatelinks
ON tl_from = page_id
JOIN... |
10 months ago |
| SELECT
DATE_FORMAT(log_timestamp, "%Y-%m") AS month,
COUNT(log_id) AS... |
10 months ago |
| SELECT
DATE_FORMAT(log_timestamp, "%Y-%m") AS month,
COUNT(log_id) AS... |
10 months ago |
| SELECT
DATE_FORMAT(log_timestamp, "%Y-%m") AS month,
COUNT(log_id) AS... |
10 months ago |
| SELECT
DATE_FORMAT(log_timestamp, "%Y-%m-%d") AS day,
COUNT(log_id) AS... |
10 months ago |
| SELECT
DATE_FORMAT(log_timestamp, "%Y-%m-%d") AS day,
COUNT(log_id) AS... |
10 months ago |
