SELECT user_id, user_name, user_editcount, user_registration
FROM... |
1 year ago |
SELECT user_id, user_name, user_editcount, user_registration
FROM... |
1 year ago |
SELECT user_id, user_name, user_editcount, user_registration
FROM... |
1 year ago |
select * from user_former_groups join user on ufg_user=user_id where... |
1 year ago |
select * from user_former_groups join user on ufg_user=user_id where... |
1 year ago |
select * from user_former_groups where ufg_group="patroller"; |
1 year ago |
select * from user_former_groups limit 1; |
1 year ago |
select * from user_former_groups; |
1 year ago |
select * from logging where log_id=149824208; |
1 year ago |
select * from logging where log_id=149824208; |
1 year ago |
SELECT REGEXP_REPLACE(SUBSTR(p.page_title, 23),... |
1 year ago |
SELECT
page.page_title AS `Article`,
draft.page_title AS `Draft`
FROM
... |
1 year ago |
SELECT page_title as AFD, actor_name as User,
... |
1 year ago |
SELECT page_title as AFD, actor_name as User,
... |
1 year ago |
SELECT page_title as AFD, actor_name as User,
... |
1 year ago |
SELECT page_title as AFD, actor_name as User, page_creation,
... |
1 year ago |
SELECT page_title as AFD, actor_name as User, page_creation,
... |
1 year ago |
SELECT page_title as AFD, actor_name as User, page_created,
... |
1 year ago |
SELECT actor_name as `creator`, COUNT(*) as `#`, page_title as `Example... |
1 year ago |
SELECT actor_name as `creator`, COUNT(*) as `#`, page_title as `Example... |
1 year ago |
SELECT actor_name as `creator`, COUNT(*) as `#`, page_title as `Example... |
1 year ago |
SELECT actor_name as `creator`, COUNT(*) as `#`, page_title as `Example... |
1 year ago |
select * from pagetriage_page join page on page_id=ptrp_page_id where... |
1 year ago |
select * from pagetriage_page join page on page_id=ptrp_page_id where... |
1 year ago |
select * from ipblocks where ipb_expiry="infinity" limit 10; |
1 year ago |
select * from ipblocks where ipb_expiry="infinite" limit 10; |
1 year ago |
select * from ipblocks where ipb_expiry="infinity" limit 10; |
1 year ago |
select * from ipblocks where ipb_expiry=infinity limit 10; |
1 year ago |
select * from ipblocks limit 10; |
1 year ago |
SELECT *
FROM pagetriage_page
JOIN page ON page_id = ptrp_page_id
where... |
1 year ago |
SELECT page_namespace, page_title, ptrp_created, COUNT(*)
FROM... |
1 year ago |
desc pagetriage_page; |
1 year ago |
desc pagetriage_page;SELECT page_namespace, page_title, ptrp_created_on,... |
1 year ago |
SELECT page_namespace, page_title, ptrp_created_on, COUNT(*)
FROM... |
1 year ago |
SELECT page_namespace, page_title, ptrp_creationdate, COUNT(*)
FROM... |
1 year ago |
SELECT page_namespace, page_title, ptrp_creation_date, COUNT(*)
FROM... |
1 year ago |
DESC page; |
1 year ago |
SELECT page_namespace, page_title, COUNT(*)
FROM pagetriage_page
JOIN page... |
1 year ago |
DESC page; |
2 years ago |
SELECT page_title
FROM revision
JOIN actor_revision ON actor_id =... |
2 years ago |
SELECT page_title
FROM revision
JOIN actor_revision ON actor_id =... |
2 years ago |
SELECT page_title
FROM revision
JOIN actor_revision ON actor_id =... |
2 years ago |
SELECT actor_name as "Creator", page_title
FROM revision
JOIN actor_revision... |
2 years ago |
DESC page; |
2 years ago |
#select count(*) from watchlist where wl_user=40581682;
DESCRIBE watchlist_expiry; |
2 years ago |
select count(*) from watchlist where wl_user=40581682; |
2 years ago |
select count(*) from watchlist wehre wl_user=40581682; |
2 years ago |
SELECT page_title as AFD, actor_name as User,
... |
2 years ago |
SELECT page_title as AFD, actor_name as User,
... |
2 years ago |
select date_format(20221112232036,'%Y-%m-%d %H:%i:%s'),... |
2 years ago |
select date_format(20221112232036,'%Y-%m-%d_%H:%i:%s'),... |
2 years ago |
select date_format(20221112232036,'%Y%m%d_%H%i%s'),... |
2 years ago |
select date_format(20221112232036,'%Y%m%d_%H%i%s'), FROM_UNIXTIME(,... |
2 years ago |
select date_format(CURRENT_TIMESTAMP,'%Y%m%d_%H%i%s'),... |
2 years ago |
select FROM_UNIXTIME(20221112232036, '%d-%m-%Y %H:%i:%s') AS Response from... |
2 years ago |
select FROM_UNIXTIME(20221112232036, '%d-%m-%Y %H:%i:%s') AS Response from 1; |
2 years ago |
select FROM_UNIXTIME(20221112232036, '%d-%m-%Y %H:%i:%s') AS Response; |
2 years ago |
select FROM_UNIXTIME(20221112232036, '%d-%m-%Y %H:%i:%s') AS Response' |
2 years ago |
SELECT page_title as AFD, actor_name as User, rev_timestamp as `Revision... |
2 years ago |
SELECT ptrp_created as `Created on`, page_title as Article
FROM... |
2 years ago |
SELECT ptrp_created as `Created on`, page_title as Article
FROM... |
2 years ago |
SELECT ptrp_created as `Created on`, page_title as Article
FROM... |
2 years ago |
SELECT page_title as Article, ptrp_created as `Created on`
FROM... |
2 years ago |
SELECT page_title
FROM pagetriage_page
JOIN page ON ptrp_page_id =... |
2 years ago |
SELECT page_title
FROM pagetriage_page
JOIN page ON ptrp_page_id =... |
2 years ago |
SELECT page_title, actor_name, rev_timestamp
FROM page p
JOIN... |
2 years ago |
select * from pagetriage_tags; |
2 years ago |
select * from pagetriage_tags; |
2 years ago |
SELECT page_namespace, page_title, ptrpt_page_id, ptrp_created,... |
2 years ago |
SELECT page_namespace, page_title, ptrpt_page_id, ptrp_created,... |
2 years ago |
SELECT page_namespace, page_title, ptrpt_page_id, ptrp_created,... |
2 years ago |