| set @itemId = 60400606;
set @language = 'en';
USE wikidatawiki_p;
SELECT
# ... |
4 years ago |
| set @itemId = 60400606;
set @language = 'en';
USE wikidatawiki_p;
SELECT
# ... |
4 years ago |
| set @itemId = 60400606;
set @language = 'en';
USE wikidatawiki_p;
SELECT
# ... |
4 years ago |
| set @itemId = 60400606;
set @language = 'en';
USE wikidatawiki_p;
SELECT
# ... |
4 years ago |
| set @itemId = 60400606;
set @language = 'en';
USE wikidatawiki_p;
SELECT
# ... |
4 years ago |
| set @itemId = 60400606;
set @language = 'en';
USE wikidatawiki_p;
SELECT
# ... |
4 years ago |
| set @itemId = 60400606;
set @language = 'en';
USE wikidatawiki_p;
SELECT
... |
4 years ago |
| set @itemId = 60400606;
set @language = 'en';
USE wikidatawiki_p;
SELECT
... |
4 years ago |
| set @itemId = 60400606;
set @lanugage = 'en';
USE wikidatawiki_p;
SELECT
... |
4 years ago |
| set @itemId = 60400606;
set @lanugage = 'en';
USE wikidatawiki_p;
SELECT
... |
4 years ago |
| set @itemId = 60400606;
set @lanugage = 'en';
USE wikidatawiki_p;
SELECT
... |
4 years ago |
| set @lanugage = 'en';
USE wikidatawiki_p;
SELECT
wbit_item_id as id,
... |
4 years ago |
| set @lanugage = 'en';
USE wikidatawiki_p;
SELECT
wbit_item_id as id,
... |
4 years ago |
| set @lanugage = 'en';
USE wikidatawiki_p;
SELECT
wbit_item_id as id,
... |
4 years ago |
| set @lanugage = 'en';
USE wikidatawiki_p;
SELECT
wbit_item_id as id,
... |
4 years ago |
| set @lanugage = 'en';
USE wikidatawiki_p;
SELECT
wbit_item_id as id,
... |
4 years ago |
| USE wikidatawiki_p;
SELECT
wbit_item_id as id,
wby_name as type,
... |
4 years ago |
| USE wikidatawiki_p;
SELECT
wbit_item_id as id,
wby_name as type,
... |
4 years ago |
| SELECT
wbit_item_id as id,
wby_name as type,
wbxl_language as... |
4 years ago |
| SELECT
CONVERT(p1.page_title USING utf8)
FROM
page AS p1
WHERE
... |
4 years ago |
| SELECT
CONVERT(p1.page_title USING utf8)
FROM
page AS p1
WHERE
... |
4 years ago |
| USE commonswiki_p;
SELECT page_title
FROM page
WHERE page_namespace = 10
AND... |
4 years ago |
| USE commonswiki_p;
SELECT page_title
FROM page
WHERE page_namespace = 10
AND... |
4 years ago |
| SELECT * FROM abuse_filter LIMIT 10;
SELECT * FROM abuse_filter_action LIMIT... |
4 years ago |
| /*
SELECT * FROM abuse_filter LIMIT 10;
SELECT * FROM abuse_filter_action... |
4 years ago |
| /*
SELECT * FROM abuse_filter LIMIT 10;
SELECT * FROM abuse_filter_action... |
4 years ago |
| /*
SELECT * FROM abuse_filter LIMIT 10;
SELECT * FROM abuse_filter_action... |
4 years ago |
| /*
SELECT * FROM abuse_filter LIMIT 10;
SELECT * FROM abuse_filter_action... |
4 years ago |
| SELECT * FROM abuse_filter LIMIT 10;
SELECT * FROM abuse_filter_action LIMIT... |
4 years ago |
| SHOW tables; |
4 years ago |
| LIST table; |
4 years ago |
| LIST tables; |
4 years ago |
| SELECT * FROM abuse_filter_history
LIMIT 100 |
4 years ago |
| SELECT page_title, substring(iwl_title, 10, LENGTH(iwl_title)) AS Category... |
4 years ago |
| SELECT page_title, substring(iwl_title, 10, LENGTH(iwl_title)) AS Category... |
4 years ago |
| SELECT page_title, substring(iwl_title, 10, LENGTH(iwl_title)) AS Category... |
4 years ago |
| SELECT page_title, substring(iwl_title, 10, LENGTH(iwl_title)) AS Category... |
4 years ago |
| SELECT page_title, substring(iwl_title, 10, LENGTH(iwl_title)) AS Category... |
4 years ago |
| SELECT page_title, substring(iwl_title, 10, LENGTH(iwl_title)) AS Category... |
4 years ago |
| SELECT page_title, substring(iwl_title, 10, LENGTH(iwl_title)) AS Category... |
4 years ago |
| SELECT *, substring(iwl_title, 10, LENGTH(iwl_title)) AS Category FROM... |
4 years ago |
| SELECT *, substring(iwl_title, 10, LENGTH(iwl_title)) AS 'Category' FROM... |
4 years ago |
| SELECT *, substring(iwl_title, 10, LENGTH(iwl_title)) AS 'Category' FROM... |
4 years ago |
| SELECT *, substring(iwl_title, 10, LENGTH(iwl_title)) AS 'Category' FROM... |
4 years ago |
| SELECT *, substring(iwl_title, 10, LENGTH(iwl_title)) AS 'Category' FROM... |
4 years ago |
| SELECT *, substring(iwl_title, 10, LENGTH(iwl_title)) AS 'Category' FROM... |
4 years ago |
| SELECT *, substring(iwl_title, 10, LENGTH(iwl_title)) AS 'Category' FROM... |
4 years ago |
| SELECT *, substring(iwl_title, 10, LENGTH(iwl_title)) AS 'Category' FROM... |
4 years ago |
| SELECT substring(iwl_title, 10, LENGTH(iwl_title)) AS 'Category' FROM... |
4 years ago |
| SELECT substring(iwl_title, 5, LENGTH(iwl_title)) FROM iwlinks
WHERE... |
4 years ago |
| SELECT substring(iwl_title, 5, len(iwl_title)) FROM iwlinks
WHERE iwl_from =... |
4 years ago |
| SELECT substring(iwl_title, 5, len(iwl_title)) FROM iwlinks
WHERE iwl_from =... |
4 years ago |
| SELECT substring(iwl_title, 5, len(iwl_title)); FROM iwlinks
WHERE iwl_from... |
4 years ago |
| SELECT * FROM iwlinks
WHERE iwl_from = 24408
AND iwl_prefix = 'commons'
AND... |
4 years ago |
| SELECT * FROM iwlinks
WHERE iwl_from = 24408 |
4 years ago |
| SELECT * FROM externallinks
WHERE el_from = 24408 |
4 years ago |
| use commonswiki_p;
SELECT gil_to, COUNT(gil_page) FROM pagelinks
JOIN... |
4 years ago |
| use commonswiki_p;
SELECT gil_to, COUNT(gil_page) FROM pagelinks
JOIN... |
4 years ago |
| use commonswiki_p;
SELECT gil_to, COUNT(gil_page) FROM pagelinks
JOIN... |
4 years ago |
| use commonswiki_p;
DESCRIBE globalimagelinks;
DESCRIBE pagelinks;
SELECT... |
4 years ago |
| use commonswiki_p;
DESCRIBE globalimagelinks;
DESCRIBE pagelinks;
SELECT... |
4 years ago |
| use commonswiki_p;
DESCRIBE globalimagelinks;
DESCRIBE pagelinks;
SELECT *... |
4 years ago |
| use commonswiki_p;
DESCRIBE globalimagelinks;
SELECT * FROM... |
4 years ago |
| use commonswiki_p;
DESCRIBE globalimagelinks;
DESCRIBE pagelinks;
SELECT *... |
4 years ago |
| use commonswiki_p;
DESCRIBE globalimagelinks;
DESCRIBE pagelinks;
SELECT *... |
4 years ago |
| use commonswiki_p;
DESCRIBE globalimagelinks;
DESCRIBE pagelinks;
SELECT *... |
4 years ago |
| use commonswiki_p;
DESCRIBE globalimagelinks;
SELECT * FROM... |
4 years ago |
| use commonswiki_p;
DESCRIBE globalimagelinks;
SELECT * FROM... |
4 years ago |
| use commonswiki_p;
DESCRIBE globalimagelinks;
SELECT * FROM... |
4 years ago |
| use commonswiki_p;
DESCRIBE globalimagelinks;
SELECT * FROM... |
4 years ago |
| USE mediawikiwiki_p;
SELECT user_groups.*, user_name, globaluser.gu_locked... |
4 years ago |
| USE mediawikiwiki_p;
SELECT user_groups.*, user_name, globaluser.gu_locked... |
4 years ago |
| USE mediawikiwiki_p;
SELECT user_groups.*, user_name, globaluser.gu_locked... |
4 years ago |
| USE mediawikiwiki_p;
SELECT user_groups.*, user_name, globaluser.gu_locked... |
4 years ago |
| USE mediawikiwiki_p;
SELECT user_groups.*, user_name, globaluser.gu_locked... |
4 years ago |
| USE mediawikiwiki_p;
SELECT user_groups.*, user_name, globaluser.gu_locked... |
4 years ago |
| USE mediawikiwiki_p;
SELECT user_groups.*, user_name, globaluser.gu_locked... |
4 years ago |
| USE mediawikiwiki_p;
SELECT user_groups.*, user_name, globaluser.gu_locked... |
4 years ago |
| USE centralauth_p;
DESCRIBE globaluser;
USE mediawikiwiki_p;
SELECT... |
4 years ago |
| USE centralauth_p;
DESCRIBE globaluser;
USE mediawikiwiki_p;
SELECT * FROM... |
4 years ago |
| USE centralauth_p;
DESCRIBE globaluser;
USE mediawikiwiki_p;
SELECT * FROM... |
4 years ago |
| USE centralauth_p;
DESCRIBE globaluser;
USE mediawikiwiki_p;
SELECT * FROM... |
4 years ago |
| USE centralauth_p;
DESCRIBE globaluser;
USE mediawikiwiki_p;
SELECT * FROM... |
4 years ago |
| USE centralauth_p;
DESCRIBE globaluser;
USE mediawikiwiki_p;
SELECT * FROM... |
4 years ago |
| USE centralauth_p;
DESCRIBE globaluser;
USE mediawikiwiki_p;
SELECT * FROM... |
4 years ago |
| USE centralauth_p;
DESCRIBE globaluser;
USE mediawikiwiki_p;
SELECT ug.*,... |
4 years ago |
| USE centralauth_p;
DESCRIBE globaluser;
USE mediawikiwiki_p;
SELECT ug.*,... |
4 years ago |
| USE centralauth_p;
DESCRIBE globaluser;
USE mediawikiwiki_p;
SELECT ug.*,... |
4 years ago |
| USE centralauth_p;
DESCRIBE globaluser;
USE mediawikiwiki_p;
SELECT ug.*,... |
4 years ago |
| USE centralauth_p;
DESCRIBE globaluser;
USE mediawikiwiki_p;
SELECT ug.*,... |
4 years ago |
| USE centralauth_p;
DESCRIBE globaluser;
USE mediawikiwiki_p;
SELECT ug.*,... |
4 years ago |
| USE centralauth_p;
DESCRIBE globaluser;
USE mediawikiwiki_p;
SELECT ug.*,... |
4 years ago |
| USE centralauth_p;
DESCRIBE globaluser; |
4 years ago |
| USE centralauth_p;
SHOW tables; |
4 years ago |
| USE metawiki_p;
SHOW tables; |
4 years ago |
| USE metawiki_p;
LIST tables; |
4 years ago |
| USE centralauthwiki_p;
LIST tables; |
4 years ago |
| USE centralauth_p;
LIST tables; |
4 years ago |
| #USE simplewiki_p;
SELECT * FROM categorylinks
JOIN page ON page_id =... |
4 years ago |
| USE simplewiki_p;
SELECT * FROM categorylinks
JOIN page ON page_id =... |
4 years ago |
| USE simplewiki_p;
SELECT * FROM categorylinks
JOIN page ON page_id =... |
4 years ago |
| USE simplewiki_p;
SELECT * FROM categorylinks
WHERE cl_to =... |
4 years ago |
| USE enwikinews_p;
SELECT ctl1.cl_to, COUNT(*), page.page_id FROM... |
4 years ago |
| USE enwikinews_p;
SELECT ctl1.cl_to, COUNT(*), page.page_id FROM... |
4 years ago |
| USE enwikinews_p;
SELECT ctl1.cl_to, COUNT(*), page.page_id FROM... |
4 years ago |
| USE enwikinews_p;
SELECT ctl1.*, page.page_id FROM categorylinks ctl1
JOIN... |
4 years ago |
| USE enwikinews_p;
SELECT ctl1.*, page.page_id, page_props.* FROM... |
4 years ago |
| USE enwikinews_p;
SELECT ctl1,*, page.page_id, page_props.* FROM... |
4 years ago |
| USE enwikinews_p;
SELECT * FROM categorylinks ctl1
JOIN page ON... |
4 years ago |
| USE enwikinews_p;
SELECT * FROM categorylinks
JOIN page ON page.page_title =... |
4 years ago |
| USE enwikinews_p;
SELECT * FROM categorylinks
WHERE cl_type = 'file'
AND... |
4 years ago |
| USE enwikinews_p;
SELECT * FROM categorylinks
WHERE cl_type = 'file'
AND... |
4 years ago |
| USE enwikinews_p;
SELECT * FROM categorylinks
WHERE cl_type = 'file'
AND... |
4 years ago |
| USE enwikinews_p;
SELECT * FROM categorylinks
WHERE cl_type = 'file'
AND... |
4 years ago |
| USE enwikinews_p;
SELECT * FROM categorylinks
WHERE cl_type = 'file'
AND... |
4 years ago |
| USE enwikinews_p;
SELECT * FROM categorylinks
WHERE cl_type = 'file'
AND... |
4 years ago |
| USE enwikinews_p;
SELECT * FROM categorylinks
WHERE cl_type = 'file'
LIMIT 10 |
4 years ago |
| USE enwikinews_p;
SELECT * FROM categorylinks
LIMIT 10 |
4 years ago |
| SELECT cl_from, cl_to, cl_type FROM categorylinks
WHERE cl_type =... |
4 years ago |
| SELECT cl_from, cl_to, cl_type FROM categorylinks
WHERE cl_type =... |
4 years ago |
| SELECT cl_from, cl_to, cl_type FROM categorylinks
WHERE cl_type =... |
4 years ago |
| SELECT cl_from, cl_to, cl_type FROM categorylinks
WHERE cl_type =... |
4 years ago |
| SELECT * FROM categorylinks
WHERE cl_type = 'subcat'
GROUP BY cl_from
HAVING... |
4 years ago |
| SELECT * FROM categorylinks
WHERE cl_type = 'subcat'
LIMIT 100 |
4 years ago |
| SELECT * FROM categorylinks
LIMIT 100 |
4 years ago |
