| select count(*), 'categorize-hiddencat' as _query
from recentchanges
join... |
2 years ago |
| select *
from recentchanges
join page on page_namespace=rc_namespace AND... |
2 years ago |
| SELECT
page_id,
page_title,
cat_files,
(SELECT COUNT(*) FROM... |
2 years ago |
| SELECT
page_id,
page_title,
cat_files,
(SELECT COUNT(*) FROM... |
2 years ago |
| SELECT
page_id,
page_title,
cat_files,
(SELECT COUNT(*) FROM... |
2 years ago |
| SELECT
SUBSTR(rc_timestamp, 1, 8) AS _date,
rc_title,
actor_name,
... |
2 years ago |
| SELECT
SUBSTR(rc_timestamp, 1, 8) AS _date,
rc_title,
actor_name,
... |
2 years ago |
| SELECT
SUBSTRING(rc_timestamp, 1, 8) AS _date,
rc_title,
... |
2 years ago |
| SELECT
SUBSTRING(rc_timestamp, 0, 8) AS _date,
rc_title,
... |
2 years ago |
| SELECT
SUBSTRING(rc_timestamp FROM 0 FOR 8) AS _date,
rc_title,
... |
2 years ago |
| SELECT
SUBSTR(rc_timestamp, 0, 8) AS _date,
rc_title,
actor_name,
... |
2 years ago |
| SELECT
rc_timestamp, rc_title,
actor_name,
comment_text,
... |
2 years ago |
| SELECT
rc_timestamp, rc_title,
actor_name,
comment_text,
... |
2 years ago |
| SELECT
rc_timestamp, rc_title,
comment_text, comment_id,
rc_minor,... |
2 years ago |
| SELECT
rc_timestamp, rc_title,
comment_text, comment_id,
rc_minor,... |
2 years ago |
| SELECT
rc_timestamp, rc_title, rc_minor, rc_this_oldid, rc_last_oldid,... |
2 years ago |
| SELECT
rc_timestamp, rc_title, rc_minor, rc_this_oldid, rc_last_oldid,... |
2 years ago |
| SELECT
rc_timestamp, rc_title, rc_minor, rc_this_oldid, rc_last_oldid,... |
2 years ago |
| SELECT
rc_timestamp, rc_title, rc_minor, rc_bot, rc_this_oldid,... |
2 years ago |
| SELECT
rc_timestamp, rc_title, rc_minor, rc_bot, rc_cur_id, rc_this_oldid,... |
2 years ago |
| SELECT
*
FROM recentchanges
WHERE rc_bot=1
AND rc_namespace=0 --... |
2 years ago |
| SELECT
*
FROM recentchanges
WHERE rc_bot=1
AND rc_namespace=0
ORDER BY... |
2 years ago |
| SELECT
*
FROM recentchanges
WHERE rc_bot=1
ORDER BY rc_timestamp DESC
LIMIT 10; |
2 years ago |
