| blank query |
1 year ago |
| SELECT
*
FROM comment
WHERE (comment_text LIKE '%руни.рф%') OR... |
1 year ago |
| SELECT
*
FROM comment
WHERE comment_text LIKE '%руни.рф%'
LIMIT 100; |
1 year ago |
| SELECT
*
FROM comment
WHERE comment_text LIKE '%руни.рф%'
LIMIT 100; |
1 year ago |
| SELECT
*
FROM comment
WHERE comment_text LIKE '%руни.рф%'
LIMIT 100; |
1 year ago |
| SELECT
*
FROM comment
WHERE comment_text LIKE '%руни%'
LIMIT 100; |
1 year ago |
| SELECT
*
FROM comment
WHERE comment_text LIKE '%отмена%'
LIMIT 100; |
1 year ago |
| SELECT
*
FROM comment
WHERE comment_text LIKE '%отмена%'
LIMIT 100; |
1 year ago |
| SELECT
*
FROM comment
WHERE comment_text LIKE '%руни.рф%'
LIMIT 100; |
1 year ago |
| SELECT
*
FROM comment
WHERE CONTAINS('руни.рф', comment_text)
LIMIT 100; |
1 year ago |
| SELECT
*
FROM comment
WHERE CONTAINS('руни.рф', comment_text)
LIMIT 100; |
1 year ago |
| SELECT
*
FROM comment
WHERE CONTAINS(comment_text, 'руни.рф')
LIMIT 100; |
1 year ago |
| blank query |
1 year ago |
| SELECT
LEFT(log_timestamp, 6) AS month,
log_timestamp,
... |
2 years ago |
| SELECT
LEFT(log_timestamp, 6) AS month,
log_timestamp,
... |
2 years ago |
| SELECT
LEFT(log_timestamp, 6) AS month,
log_timestamp,
... |
2 years ago |
| SELECT
LEFT(log_timestamp, 6) AS month,
log_timestamp,
... |
2 years ago |
| SELECT
LEFT(log_timestamp, 6) AS month,
log_timestamp,
... |
2 years ago |
| SELECT
LEFT(log_timestamp, 6) AS month,
log_timestamp,
... |
2 years ago |
| SELECT
log_timestamp,
REPLACE(log_title, '_', ' '),
(SELECT
... |
2 years ago |
| USE ruwiki_p;
SELECT rev_timestamp,
CONCAT((CASE
WHEN page_namespace = 8... |
3 years ago |
| USE ruwiki_p;
SELECT *
FROM revision
LIMIT 100
; |
3 years ago |
| USE ruwiki_p;
SELECT
CONCAT('{{', REPLACE(page_title, '_', ' '), '}}'),
... |
4 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
4 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
4 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
4 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
4 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
4 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
4 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
4 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
4 years ago |
| -- from https://quarry.wmflabs.org/query/30450 by MBH
use ruwiki_p;
select... |
4 years ago |
| -- from https://quarry.wmflabs.org/query/30450 by MBH
use ruwiki_p;
select... |
4 years ago |
| USE ruwiki_p;
SELECT
*
FROM wbc_entity_usage
JOIN page
ON eu_page_id =... |
5 years ago |
| USE ruwiki_p;
SELECT
*,
COUNT(*) AS inner_table_number
FROM... |
5 years ago |
| USE ruwiki_p;
SELECT
*,
COUNT(*) AS inner_table_number
FROM... |
5 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
5 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
5 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
5 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
5 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
5 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
5 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
5 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
5 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
5 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
5 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
5 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
5 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
5 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
5 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
5 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
5 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
5 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
5 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
5 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
5 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
5 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
5 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
5 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
5 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
5 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
5 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
5 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
5 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
5 years ago |
| USE ruwiki_p;
SELECT DISTINCT `ug_group` FROM `user_groups`; |
5 years ago |
| USE ruwiki_p;
SELECT * FROM user_groups
LIMIT 100
; |
5 years ago |
| USE ruwiki_p;
SELECT * FROM user_groups
LIMIT 100
; |
5 years ago |
| USE ruwiki_p;
SELECT * ug_group FROM user_groups
LIMIT 100
; |
5 years ago |
| USE ruwiki_p;
SELECT DISTINCT ug_group FROM user_groups; |
5 years ago |
| USE ruwiki_p;
SELECT DISTINCT ug_group FROM user_groups |
5 years ago |
| USE ruwiki_p;
SELECT DISTINCT `ug_group` FROM `user_groups`; |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM revision
LIMIT 100 |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM user_groups
LIMIT 100 |
5 years ago |
| USE ruwiki_p;
SELECT DISTINCT `ug_group` FROM `user_groups`; |
5 years ago |
| USE ruwiki_p;
SELECT DISTINCT `ug_group` FROM `user_groups`; |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*),
user_name,
fr_timestamp AS 'last... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*),
user_name,
fr_timestamp as 'last... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp as 'last... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp as 'last... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp as 'last timestamp',... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp as 'last timestamp',... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp, fr_flags,... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM (
SELECT *
FROM flaggedrevs
ORDER BY... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp AS 'Last timestamp',... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp, ug_group
FROM (
... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp, fr_flags,... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM (
SELECT *
FROM flaggedrevs
ORDER BY... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM (
SELECT *
FROM flaggedrevs
ORDER BY... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM flaggedrevs
ORDER BY fr_rev_id DESC
LIMIT 10000 00 |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM flaggedrevs
ORDER BY fr_rev_id DESC
LIMIT 1000000 |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp, ug_group
FROM (
... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp, fr_flags,... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp, fr_flags,... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp, fr_flags,... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp, fr_flags,... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp, fr_flags,... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp, fr_flags,... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp, fr_flags,... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp, fr_flags,... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp, fr_flags,... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp, fr_flags,... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp, fr_flags,... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp, fr_flags,... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp, fr_flags,... |
5 years ago |
| USE ruwiki_p;
SELECT user_name, fr_timestamp, fr_flags, ug_group
FROM (
... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp, fr_flags,... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp, fr_flags,... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp, fr_flags,... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp, fr_flags,... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*)
FROM (
SELECT *
FROM (
SELECT COUNT(*)... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM (
SELECT COUNT(*) AS ug_times,
ug_user,
... |
5 years ago |
| SELECT *
FROM (
SELECT COUNT(*) AS ug_times,
ug_user,
ug_group
FROM... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM (
SELECT COUNT(*) AS ug_times,
ug_user,
... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM (
SELECT COUNT(*) AS ug_times,
ug_user,
... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM (
SELECT COUNT(*) AS ug_times,
ug_user,
... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*) AS ug_times,
ug_user,
ug_group
FROM... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*) AS ug_times,
ug_user,
ug_group
FROM... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*) AS ug_times,
ug_user,
ug_group
FROM... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*) AS ug_times,
ug_user,
ug_group
FROM... |
5 years ago |
| USE ruwiki_p;
SELECT SELECT(*) AS ug_times,
ug_user,
ug_group
FROM... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM user_groups
GROUP BY ug_group
LIMIT 100 |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM user_groups
LIMIT 100 |
5 years ago |
| USE ruwiki_p;
SELECT DISTINCT `ug_group` FROM `user_groups`; |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp, fr_flags,... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp, fr_flags,... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp, fr_flags,... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp, fr_flags,... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp, fr_flags,... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp, fr_flags
FROM (
... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp, fr_flags
FROM (
... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp, fr_flags
FROM (
... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp, fr_flags
FROM (
... |
5 years ago |
| USE ruwiki_p;
SELECT * -- COUNT(*), user_name, fr_timestamp, fr_flags
FROM... |
5 years ago |
| USE ruwiki_p;
SELECT * -- COUNT(*), user_name, fr_timestamp, fr_flags
FROM... |
5 years ago |
| USE ruwiki_p;
SELECT * -- COUNT(*), user_name, fr_timestamp, fr_flags
FROM... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp, fr_flags
FROM (
... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp, fr_flags
FROM (
... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name, fr_timestamp
FROM (
SELECT *
... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), user_name
FROM (
SELECT *
FROM... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), 'user_name'
FROM (
SELECT *
FROM... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*)
FROM (
SELECT *
FROM flaggedrevs
ORDER... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*)
FROM (
SELECT *
FROM flaggedrevs
ORDER... |
5 years ago |
| USE ruwiki_p;
SELECT COUNT(*), *
FROM (
SELECT *
FROM flaggedrevs
... |
5 years ago |
| USE ruwiki_p;
SELECT *, COUNT(*)
FROM (
SELECT *
FROM flaggedrevs
... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM (
SELECT *
FROM flaggedrevs
ORDER BY... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM (
SELECT *
FROM flaggedrevs
ORDER BY... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM (
SELECT *
FROM flaggedrevs
ORDER BY... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM (
SELECT *
FROM flaggedrevs
ORDER BY... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM (
SELECT *
FROM flaggedrevs
ORDER BY... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM (
SELECT *
FROM flaggedrevs
ORDER BY... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM (
SELECT *
FROM flaggedrevs
LIMIT 100
) AS ffff; |
5 years ago |
| USE ruwiki_p;
SELECT
page_namespace,
MAX(notredir),
MAX(redir)
FROM (
... |
5 years ago |
| SELECT
page_namespace,
MAX(notredir),
MAX(redir)
FROM (
SELECT... |
5 years ago |
| SELECT
page_namespace,
MAX(notredir),
MAX(redir)
FROM (
SELECT... |
5 years ago |
| SELECT
page_namespace,
MAX(notredir),
MAX(redir)
FROM (
SELECT... |
5 years ago |
| SELECT
page_namespace,
MAX(notredir),
MAX(redir)
FROM (
SELECT... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM (
SELECT *
FROM flaggedrevs
LIMIT 100;
)... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM (
SELECT *
FROM flaggedrevs
LIMIT 100;
)... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM flaggedrevs
LIMIT 100;
--... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM (SELECT *
FROM flaggedrevs
LIMIT... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM (SELECT *
FROM flaggedrevs
LIMIT... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM (SELECT *
FROM flaggedrevs
LIMIT... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM flaggedrevs
-- JOIN user_groups
-- ON fr_user =... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM flaggedrevs
-- JOIN user_groups
-- ON fr_user =... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM flaggedrevs
-- JOIN user_groups
-- ON fr_user =... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM flaggedrevs
-- JOIN user_groups
-- ON fr_user =... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM flaggedrevs
-- JOIN user_groups
-- ON fr_user =... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM flaggedrevs
-- JOIN user_groups
-- ON fr_user =... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM flaggedrevs
JOIN user_groups
ON fr_user =... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM flaggedrevs
JOIN user_groups
ON fr_user =... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM flaggedrevs
JOIN use r_groups
ON fr_user =... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM flaggedrevs
JOIN user_groups
ON fr_user =... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM flaggedrevs
JOIN user_groups
ON fr_user =... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM flaggedrevs
JOIN user_groups
ON fr_user =... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM flaggedrevs
JOIN user_groups
ON fr_user =... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM flaggedrevs
JOIN user_groups
ON fr_user =... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM flaggedrevs
JOIN page
ON fr_page_id =... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM flaggedrevs
JOIN page
ON fr_page_id =... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM flaggedrevs
JOIN page
ON fr_page_id =... |
5 years ago |
| USE ruwiki_p;
SELECT page_title
FROM flaggedrevs
JOIN page
ON fr_page_id =... |
5 years ago |
| USE ruwiki_p;
SELECT page_name
FROM flaggedrevs
JOIN page
ON fr_page_id =... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM flaggedrevs
JOIN page
ON fr_page_id = page_id
--... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM flaggedrevs
WHERE fr_rev_id >= 1000000
-- WHERE... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM flaggedrevs
-- WHERE fr_timestamp >=... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM flaggedrevs
WHERE fr_timestamp >=... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM flaggedrevs
-- WHERE log_type = 'review'
-- AND... |
5 years ago |
| USE ruwiki_p;
SELECT *
FROM logging
-- WHERE log_type = 'review'
-- AND... |
5 years ago |
| USE idwiki_p;
select log_user_text, count(log_id) AS reviews
from... |
5 years ago |
| USE idwiki_p;
select log_user_text, count(log_id) AS reviews
from... |
5 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
... |
5 years ago |
| use ruwiki_p;
select
CONCAT('[[:File:', page_title, ']]')
from page where... |
5 years ago |
| use ruwiki_p;
select
CONCAT('File:', page_title, '|]]')
from page where... |
5 years ago |
| use ruwiki_p;
select * from page where page_namespace = 6 and page_len = 0; |
5 years ago |
| blank query |
5 years ago |
| USE enwiki_p;
SELECT
*
FROM page
JOIN categorylinks ON cl_from =... |
5 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
LIMIT 100
; |
5 years ago |
| USE ruwiki_p;
SELECT
il_from, il_from_namespace, il_to, COUNT(*)
FROM... |
6 years ago |
| USE bawiki_p;
SELECT
il_from, il_from_namespace, il_to, COUNT(*)
FROM... |
6 years ago |
| USE bawiki_p;
SELECT
il_from, il_from_namespace, il_to, COUNT(*)
FROM... |
6 years ago |
| USE bawiki_p;
SELECT
il_from, il_from_namespace, il_to, COUNT(*)
FROM... |
6 years ago |
| USE bawiki_p;
SELECT
il_from, il_from_namespace, il_to, COUNT(*)
FROM... |
6 years ago |
| USE bawiki_p;
SELECT
il_from, il_from_namespace, il_to, COUNT(*)
FROM... |
6 years ago |
| USE bawiki_p;
SELECT
il_from, il_from_namespace, il_to, COUNT(*)
FROM... |
6 years ago |
| USE bawiki_p;
SELECT
il_from, il_from_namespace, il_to, COUNT(*)
FROM... |
6 years ago |
| USE bawiki_p;
SELECT
il_from, il_from_namespace, il_to, COUNT(*)
FROM... |
6 years ago |
| USE bawiki_p;
SELECT
*
FROM imagelinks
GROUP BY il_from, il_to
ORDER BY... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM imagelinks
-- GROUP BY il_from, il_to
-- ORDER... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM imagelinks
GROUP BY il_from, il_to
ORDER BY... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM imagelinks
GROUP BY il_from, il_to
ORDER BY... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM imagelinks
GROUP BY il_from
ORDER BY... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM imagelinks
GROUP BY il_from
ORDER BY... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM imagelinks
GROUP BY il_from
ORDER BY... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM imagelinks
GROUP BY il_from, il_to
ORDER BY... |
6 years ago |
| USE ruwiki_p;
SELECT DISTINCT
*
FROM imagelinks
GROUP BY il_from,... |
6 years ago |
| USE ruwiki_p;
SELECT COUNT(*) FROM
(
SELECT DISTINCT
eu_page_id
FROM... |
6 years ago |
| USE eowiki_p;
SELECT COUNT(*) FROM
(
SELECT DISTINCT
eu_page_id
FROM... |
6 years ago |
| USE etwiki_p;
SELECT COUNT(*) FROM
(
SELECT DISTINCT
eu_page_id
FROM... |
6 years ago |
| USE bewiki_p;
SELECT COUNT(*) FROM
(
SELECT DISTINCT
eu_page_id
FROM... |
6 years ago |
| USE bewiki_p;
SELECT COUNT(*) FROM
(
SELECT DISTINCT
eu_page_id
FROM... |
6 years ago |
| USE ruwiki_p;
SELECT COUNT(*) FROM
(
SELECT DISTINCT
eu_page_id
FROM... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM wbc_entity_usage
WHERE
eu_aspect = 'C.P18'
LIMIT 100; |
6 years ago |
| USE ruwiki_p;
SELECT * FROM
(
SELECT DISTINCT
eu_page_id
FROM... |
6 years ago |
| USE ruwiki_p;
SELECT COUNT(*) FROM
(
SELECT DISTINCT
eu_page_id
FROM... |
6 years ago |
| USE ruwiki_p;
SELECT COUNT(*) FROM
(
SELECT DISTINCT
eu_page_id
FROM... |
6 years ago |
| USE ruwiki_p;
SELECT COUNT(*) FROM
(
SELECT DISTINCT
eu_page_id
FROM... |
6 years ago |
| USE ruwiki_p;
SELECT COUNT(*) FROM
(
SELECT DISTINCT
eu_page_id
FROM... |
6 years ago |
| USE ruwiki_p;
SELECT COUNT(*) FROM
(
SELECT DISTINCT
eu_page_id
FROM... |
6 years ago |
| USE ruwiki_p;
SELECT COUNT(*) FROM
(
SELECT DISTINCT
eu_page_id
FROM... |
6 years ago |
| USE enwiki_p;
SELECT COUNT(*) FROM
(
SELECT DISTINCT
eu_page_id
FROM... |
6 years ago |
| USE enwiki_p;
SELECT
eu_aspect,
COUNT(*)
FROM wbc_entity_usage
WHERE
... |
6 years ago |
| USE frwiki_p;
SELECT COUNT(*) FROM
(
SELECT DISTINCT
eu_page_id
FROM... |
6 years ago |
| USE frwiki_p;
SELECT COUNT(*) FROM
(
SELECT DISTINCT
eu_page_id
FROM... |
6 years ago |
| USE frwiki_p;
SELECT COUNT(*) FROM
(
SELECT DISTINCT
eu_page_id
FROM... |
6 years ago |
| USE frwiki_p;
COUNT(
SELECT DISTINCT
eu_page_id
FROM... |
6 years ago |
| USE frwiki_p;
SELECT DISTINCT
eu_page_id
FROM wbc_entity_usage
WHERE
... |
6 years ago |
| USE frwiki_p;
COUNT DISTINCT
eu_page_id
FROM wbc_entity_usage
WHERE
... |
6 years ago |
| USE frwiki_p;
SELECT DISTINCT
eu_page_id
FROM wbc_entity_usage
WHERE
... |
6 years ago |
| USE frwiki_p;
SELECT-- DISTINCT
eu_page_id
FROM wbc_entity_usage
WHERE
... |
6 years ago |
| USE frwiki_p;
SELECT DISTINCT
eu_page_id
FROM wbc_entity_usage
WHERE
... |
6 years ago |
| USE frwiki_p;
SELECT
eu_page_id
FROM wbc_entity_usage
WHERE
eu_aspect... |
6 years ago |
| USE frwiki_p;
SELECT
eu_page_id
COUNT(*)
FROM wbc_entity_usage
WHERE
... |
6 years ago |
| USE frwiki_p;
SELECT
eu_entity_id,
eu_aspect,
eu_page_id,
--... |
6 years ago |
| USE frwiki_p;
SELECT
eu_entity_id,
eu_aspect,
eu_page_id,
--... |
6 years ago |
| USE frwiki_p;
SELECT
eu_entity_id,
eu_aspect,
eu_page_id,
--... |
6 years ago |
| USE frwiki_p;
SELECT
eu_entity_id,
eu_aspect,
eu_page_id,
--... |
6 years ago |
| USE frwiki_p;
SELECT
eu_entity_id,
eu_aspect,
eu_page_id,
--... |
6 years ago |
| USE frwiki_p;
SELECT
eu_entity_id,
eu_aspect,
eu_page_id,
--... |
6 years ago |
| USE frwiki_p;
SELECT
eu_entity_id,
eu_aspect,
eu_page_id,
--... |
6 years ago |
| USE frwiki_p;
SELECT
eu_entity_id,
eu_aspect,
eu_page_id,
--... |
6 years ago |
| USE frwiki_p;
SELECT
eu_entity_id,
eu_aspect,
eu_page_id,
... |
6 years ago |
| USE frwiki_p;
SELECT
*
FROM page
WHERE
page_title =... |
6 years ago |
| USE frwiki_p;
SELECT
*
FROM page
WHERE
page_title = "Dynastie des... |
6 years ago |
| USE frwiki_p;
SELECT
eu_aspect,
COUNT(*)
FROM wbc_entity_usage
WHERE
... |
6 years ago |
| USE ruwiki_p;
SELECT
eu_aspect,
COUNT(*)
FROM wbc_entity_usage
WHERE
... |
6 years ago |
| USE ruwiki_p;
SELECT
eu_entity_id,
eu_aspect,
eu_page_id,
... |
6 years ago |
| USE ruwiki_p;
SELECT
eu_entity_id,
eu_aspect,
eu_page_id,
... |
6 years ago |
| USE ruwiki_p;
SELECT
eu_entity_id,
eu_aspect,
eu_page_id,
... |
6 years ago |
| USE ruwiki_p;
SELECT
eu_aspect,
eu_page_id,
page_title,
... |
6 years ago |
| USE ruwiki_p;
SELECT
eu_aspect,
eu_page_id,
page_title,
... |
6 years ago |
| USE ruwiki_p;
SELECT
eu_aspect,
eu_page_id,
page_title,
... |
6 years ago |
| USE ruwiki_p;
SELECT
eu_aspect,
eu_page_id,
page_title,
... |
6 years ago |
| USE ruwiki_p;
SELECT
eu_aspect,
eu_page_id,
page_title,
... |
6 years ago |
| USE ruwiki_p;
SELECT
eu_aspect,
eu_page_id,
page_title,
... |
6 years ago |
| USE ruwiki_p;
SELECT
eu_aspect,
eu_page_id,
page_title,
... |
6 years ago |
| USE ruwiki_p;
SELECT
eu_aspect,
eu_page_id,
page_title,
... |
6 years ago |
| USE ruwiki_p;
SELECT
eu_aspect,
eu_page_id,
page_title,
... |
6 years ago |
| USE ruwiki_p;
SELECT
eu_aspect,
eu_page_id,
page_title,
... |
6 years ago |
| USE iawiki_p;
SELECT
eu_aspect,
eu_page_id,
page_title,
... |
6 years ago |
| USE iawiki_p;
SELECT
eu_aspect,
eu_page_id,
COUNT(*)
FROM... |
6 years ago |
| USE iawiki_p;
SELECT
eu_aspect,
eu_page_id-- ,
-- COUNT(*)
FROM... |
6 years ago |
| USE iawiki_p;
SELECT
eu_aspect,
eu_page_id-- ,
-- COUNT(*)
FROM... |
6 years ago |
| USE iawiki_p;
SELECT
eu_aspect,
eu_page_id,
COUNT(*)
FROM... |
6 years ago |
| USE iawiki_p;
SELECT
eu_aspect,
COUNT(*)
FROM wbc_entity_usage
WHERE
... |
6 years ago |
| USE ruwiki_p;
SELECT
eu_aspect,
COUNT(*)
FROM wbc_entity_usage
WHERE
... |
6 years ago |
| USE frwiki_p;
SELECT
eu_aspect,
COUNT(*)
FROM wbc_entity_usage
WHERE
... |
6 years ago |
| USE iawiki_p;
SELECT
eu_aspect,
COUNT(*)
FROM wbc_entity_usage
WHERE
... |
6 years ago |
| USE iawiki_p;
SELECT
eu_entity_id,
eu_aspect,
COUNT(*),
page_title,
... |
6 years ago |
| USE iawiki_p;
SELECT
eu_entity_id,
eu_aspect,
COUNT(*),
page_title,
... |
6 years ago |
| USE iawiki_p;
SELECT
eu_entity_id,
eu_aspect,
COUNT(*),
page_title,
... |
6 years ago |
| USE iawiki_p;
SELECT
eu_entity_id,
eu_aspect,
COUNT(*),
page_title,
... |
6 years ago |
| USE iawiki_p;
SELECT
eu_entity_id,
eu_aspect,
COUNT(*),
page_title,
... |
6 years ago |
| USE iawiki_p;
SELECT
eu_entity_id,
eu_aspect,
COUNT(*),
page_title,
... |
6 years ago |
| USE iawiki_p;
SELECT
eu_entity_id,
eu_aspect,
COUNT(*),
page_title,
... |
6 years ago |
| USE iawiki_p;
SELECT
eu_entity_id,
eu_aspect,
COUNT(*),
page_title,
... |
6 years ago |
| USE iawiki_p;
SELECT
eu_entity_id,
eu_aspect,
COUNT(*),
page_title,
... |
6 years ago |
| USE iawiki_p;
SELECT
eu_entity_id,
eu_aspect,
COUNT(*),
page_title,
... |
6 years ago |
| USE iawiki_p;
SELECT
eu_entity_id,
eu_aspect,
page_title,
... |
6 years ago |
| USE iawiki_p;
SELECT
eu_entity_id,
eu_aspect,
page_title,
... |
6 years ago |
| USE iawiki_p;
SELECT
eu_entity_id,
eu_aspect,
page_title,
... |
6 years ago |
| USE iawiki_p;
SELECT
eu_entity_id,
eu_aspect,
page_title,
... |
6 years ago |
| USE iawiki_p;
SELECT
eu_entity_id,
eu_aspect,
page_title,
... |
6 years ago |
| USE iawiki_p;
SELECT
eu_entity_id,
eu_aspect,
page_title,
... |
6 years ago |
| USE iawiki_p;
SELECT
eu_entity_id,
eu_aspect,
page_title,
... |
6 years ago |
| USE iawiki_p;
SELECT
eu_entity_id,
eu_aspect,
page_title,
... |
6 years ago |
| USE iawiki_p;
SELECT
eu_entity_id,
eu_aspect,
page_title,
... |
6 years ago |
| USE iawiki_p;
SELECT
eu_entity_id,
eu_aspect,
page_title,
... |
6 years ago |
| USE iawiki_p;
SELECT
eu_entity_id,
eu_aspect,
page_title,
... |
6 years ago |
| USE idwiki_p;
SELECT
eu_entity_id,
eu_aspect,
page_title,
... |
6 years ago |
| USE idwiki_p;
SELECT
eu_entity_id,
eu_aspect,
page_title,
... |
6 years ago |
| USE idwiki_p;
SELECT
eu_entity_id,
eu_aspect,
page_title
FROM... |
6 years ago |
| SELECT
*
FROM wb_property_info
LIMIT 100; |
6 years ago |
| USE idwiki_p;
SELECT
*
FROM wb_property_info
LIMIT 100; |
6 years ago |
| USE idwiki_p;
SELECT
*
FROM wb property info
LIMIT 100; |
6 years ago |
| USE idwiki_p;
SELECT
*
FROM wb_property_info
LIMIT 100; |
6 years ago |
| USE idwiki_p;
SELECT
eu_entity_id,
eu_aspect,
page_title
FROM... |
6 years ago |
| USE idwiki_p;
SELECT
eu_entity_id,
eu_aspect,
page_title
FROM... |
6 years ago |
| USE idwiki_p;
SELECT
eu_entity_id,
eu_aspect,
page_title
FROM... |
6 years ago |
| USE ruwiki_p;
SELECT
eu_entity_id,
eu_aspect,
page_title
FROM... |
6 years ago |
| USE ruwiki_p;
SELECT
eu_entity_id,
eu_aspect,
page_title
FROM... |
6 years ago |
| USE ruwiki_p;
SELECT
eu_entity_id,
eu_aspect,
page_title
FROM... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM wbc_entity_usage
JOIN page ON eu_page_id =... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM wbc_entity_usage
LIMIT 100; |
6 years ago |
| USE frwiki_p;
SELECT
*
FROM wbc_entity_usage
LIMIT 100; |
6 years ago |
| blank query |
6 years ago |
| USE ruwiki_p;
SELECT
page_title,
page_len
FROM page
WHERE
... |
6 years ago |
| USE ruwiki_p;
SELECT
page_title,
page_len
FROM page
WHERE
... |
6 years ago |
| USE ruwiki_p;
SELECT
page_title,
page_len
FROM page
WHERE
... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
WHERE
page_namespace = 3
AND page_len... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
WHERE
page_namespace = 3
AND page_len... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
WHERE
page_namespace = 3
AND page_len... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
WHERE
page_namespace = 3
AND page_len... |
6 years ago |
| blank query |
6 years ago |
| USE ruwiki_p;
SELECT
page_title
FROM page
JOIN categorylinks ON cl_from =... |
6 years ago |
| USE ruwiki_p;
SELECT
page_title
FROM page
JOIN categorylinks ON cl_from =... |
6 years ago |
| USE ruwiki_p;
SELECT
page_title
FROM page
JOIN categorylinks ON cl_from =... |
6 years ago |
| USE ruwiki_p;
SELECT
page_title
FROM page
JOIN categorylinks ON cl_from =... |
6 years ago |
| USE ruwiki_p;
SELECT
page_title
FROM page
JOIN categorylinks ON cl_from =... |
6 years ago |
| USE ruwiki_p;
SELECT
page_title
FROM page
JOIN categorylinks ON cl_from =... |
6 years ago |
| USE ruwiki_p;
SELECT
page_title
FROM page
JOIN categorylinks ON cl_from =... |
6 years ago |
| USE ruwiki_p;
SELECT
page_title
FROM page
JOIN categorylinks ON cl_from =... |
6 years ago |
| USE ruwiki_p;
SELECT
page_title
FROM page
JOIN categorylinks ON cl_from =... |
6 years ago |
| USE ruwiki_p;
SELECT
page_title,
our_rev.rev_len,
(
SELECT... |
6 years ago |
| USE ruwiki_p;
SELECT
page_title,
our_rev.rev_len,
(
SELECT... |
6 years ago |
| USE ruwiki_p;
SELECT
page_title,
our_rev.rev_len,
(
SELECT... |
6 years ago |
| USE ruwiki_p;
SELECT
page_title,
our_rev.rev_len,
(
SELECT... |
6 years ago |
| USE ruwiki_p;
SELECT
page_title,
our_rev.rev_len,
(
SELECT... |
6 years ago |
| USE ruwiki_p;
SELECT
page_title,
rev_len,
(
SELECT rev_len
... |
6 years ago |
| USE ruwiki_p;
SELECT
page_title,
rev_len,
(
SELECT rev_len
... |
6 years ago |
| USE ruwiki_p;
SELECT
page_title,
rev_len
FROM page
JOIN categorylinks ON... |
6 years ago |
| USE ruwiki_p;
SELECT
page_title,
rev_len,
(
SELECT rev_len
... |
6 years ago |
| USE ruwiki_p;
SELECT
page_title,
rev_len,
(
SELECT rev_len
... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
JOIN categorylinks ON cl_from =... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
JOIN categorylinks ON cl_from =... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
JOIN categorylinks ON cl_from =... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
JOIN categorylinks ON cl_from =... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
JOIN categorylinks ON cl_from =... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
JOIN categorylinks ON cl_from =... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
JOIN categorylinks
ON cl_from = page_id... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
JOIN categorylinks
ON cl_from = page_id... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
JOIN categorylinks
ON cl_from = page_id... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
WHERE
page_namespace = 1
AND NOT... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
WHERE
page_namespace = 1
AND NOT... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
WHERE
page_namespace = 1
AND NOT... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
WHERE
page_namespace = 1
AND NOT... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
WHERE
page_namespace = 1
AND NOT... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
WHERE
page_namespace = 1
AND NOT... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
WHERE
page_namespace = 1
AND NOT... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
WHERE
page_namespace = 1
AND NOT... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
WHERE
page_namespace = 1
AND... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
WHERE
page_namespace = 1
AND... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
WHERE
page_namespace = 1
AND... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
WHERE
page_namespace = 1
AND... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
WHERE
page_namespace = 1
AND... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
WHERE
page_namespace = 1
AND... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
WHERE
page_namespace = 1
AND NOT... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
WHERE
page_namespace = 1
AND NOT... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
WHERE
page_namespace = 1
AND NOT... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
WHERE
page_namespace = 1
AND NOT... |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
WHERE
page_namespace = 1
LIMIT 100; |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
WHERE
page_namespace = 1
LIMIT 10000; |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM page
WHERE
page_namespace = 1
LIMIT 100; |
6 years ago |
| USE ruwiki_p;
SELECT
*
FROM pages
WHERE
page_namespace = 1
LIMIT 100; |
6 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[User:', user_name, '|]]') AS User,
... |
6 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[User:', user_name, '|]]') AS User,
... |
6 years ago |
| USE ruwiki_p;
SELECT
rev_user_text,
COUNT(rev_user_text),
... |
6 years ago |
| USE ruwiki_p;
SELECT
rev_user_text,
COUNT(rev_user_text),
... |
6 years ago |
| USE ruwiki_p;
SELECT
rev_user_text,
COUNT(rev_user_text),
... |
6 years ago |
| USE ruwiki_p;
SELECT
rev_user_text,
COUNT(rev_user_text),
... |
6 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[User:', user_name, '|]]') AS User,
... |
6 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[User:', user_name, '|]]') AS User,
... |
6 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[User:', user_name, '|]]') AS User,
... |
6 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[User:', user_name, '|]]') AS User,
... |
6 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[User:', user_name, '|]]') AS User,
... |
6 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[User:', user_name, '|]]') AS User,
... |
6 years ago |
| USE ruwiki_p;
SELECT
CONCAT('[[User:', user_name, '|]]') AS User,
... |
6 years ago |
