SELECT lang, COUNT(1) as articles_count
FROM
(
SELECT R.rev_id,
... |
2 years ago |
SELECT lang, COUNT(1) as articles_count
FROM
(
SELECT R.rev_id,
... |
2 years ago |
SELECT lang, COUNT(1) as articles_count
FROM
(
SELECT R.rev_id,... |
2 years ago |
SELECT lang, COUNT(1) as articles_count
FROM
(
SELECT R.rev_id,... |
2 years ago |
SELECT lang, COUNT(1) as articles_count
FROM
(
SELECT R.rev_id,... |
2 years ago |
SELECT lang, COUNT(1) as articles_count
FROM
(
SELECT R.rev_id,... |
2 years ago |
SELECT R.rev_id, P.page_title, substring(replace(replace(C.comment_text,... |
2 years ago |
SELECT R.rev_id, P.page_title, substring(replace(replace(C.comment_text,... |
2 years ago |
SELECT R.rev_id, P.page_title, replace(C.comment_text, "«", "")
FROM... |
2 years ago |
SELECT R.rev_id, P.page_title, C.comment_text,... |
2 years ago |
SELECT lang, COUNT(1) as articles_count, /*GROUP_CONCAT(page_title) as... |
2 years ago |
SELECT lang, COUNT(1) as articles_count, /*GROUP_CONCAT(page_title) as... |
2 years ago |
SELECT lang, COUNT(1) as articles_count/*, GROUP_CONCAT(page_title) as... |
2 years ago |
SELECT lang, COUNT(1) as articles_count, GROUP_CONCAT(page_title) as... |
2 years ago |
SELECT lang, COUNT(1) as articles_count, GROUP_CONCAT(page_title) as... |
2 years ago |
SELECT lang, COUNT(1) as articles_count, GROUP_CONCAT(page_title) as... |
2 years ago |
SELECT lang, COUNT(1) as articles_count
FROM
(
SELECT R.rev_id,... |
2 years ago |
#SELECT lang, COUNT(1) as articles_count
#FROM
#(
SELECT R.rev_id,... |
2 years ago |
#SELECT lang, COUNT(1) as articles_count
#FROM
#(
SELECT R.rev_id,... |
2 years ago |
SELECT lang, COUNT(1) as articles_count
FROM
(
SELECT R.rev_id,... |
2 years ago |
SELECT lang, COUNT(1) as articles_count, GROUP_CONCAT(page_title) as... |
2 years ago |
SELECT lang, COUNT(1) as articles_count, GROUP_CONCAT(P.page_title) as... |
2 years ago |
SELECT lang, COUNT(1) as articles_count, STRING_AGG(P.page_title, " |... |
2 years ago |
SELECT lang, COUNT(1) as articles_count
FROM
(
SELECT R.rev_id,... |
2 years ago |
/*SELECT lang, COUNT(1) as articles_count
FROM
(
SELECT R.rev_id,... |
2 years ago |
/*SELECT lang, COUNT(1) as articles_count
FROM
(
SELECT R.rev_id,... |
2 years ago |
/*SELECT lang, COUNT(1) as articles_count
FROM
(
SELECT R.rev_id,... |
2 years ago |
SELECT lang, COUNT(1) as articles_count
FROM
(
SELECT R.rev_id,... |
2 years ago |
SELECT lang, COUNT(1) as articles
FROM
(
SELECT R.rev_id, C.comment_text,... |
2 years ago |
SELECT rev_id
FROM
(
SELECT R.rev_id, C.comment_text,... |
2 years ago |
SELECT *
FROM (
SELECT R.rev_id, C.comment_text, substring(C.comment_text,... |
2 years ago |
SELECT *
FROM (
SELECT R.rev_id, C.comment_text, substring(C.comment_text,... |
2 years ago |
SELECT *
FROM (
SELECT R.rev_id, C.comment_text, substring(C.comment_text,... |
2 years ago |
SELECT R.rev_id, C.comment_text, substring(C.comment_text, 72, 2) AS... |
2 years ago |
SELECT R.rev_id, C.comment_text, substring(C.comment_text, 72, 2) AS... |
2 years ago |
SELECT R.rev_id, C.comment_text, substring(C.comment_text, 72, 2) AS... |
2 years ago |
SELECT P.page_title, R.rev_id, C.comment_text, substring(C.comment_text, 72,... |
2 years ago |
SELECT P.page_title, R.rev_id, C.comment_text, substring(C.comment_text, 72,... |
2 years ago |
SELECT P.page_title, C.comment_text, substring(C.comment_text, 72, 2) AS... |
2 years ago |
SELECT P.page_title, C.comment_text, substring(C.comment_text, 72, 2) AS... |
2 years ago |
SELECT P.page_title, C.comment_text, substring(C.comment_text, 72, 8) AS... |
2 years ago |
SELECT P.page_title, C.comment_text, substring(C.comment_text, 70, 8) AS... |
2 years ago |
SELECT P.page_title, C.comment_text, substring(C.comment_text, 40, 8) AS... |
2 years ago |
SELECT P.page_title, C.comment_text, substring(C.comment_text, 20, 8) AS... |
2 years ago |
SELECT P.page_title, C.comment_text, substring(C.comment_text, 20, 5) AS... |
2 years ago |
SELECT P.page_title, C.comment_text#,... |
2 years ago |
SELECT P.page_title, C.comment_text,... |
2 years ago |
SELECT P.page_title, C.comment_text, COUNT(T.ct_tag_id) AS tags
FROM... |
2 years ago |
SELECT P.page_title C.comment_text#, COUNT(T.ct_tag_id) AS tags
FROM... |
2 years ago |
SELECT P.page_title C.comment_text#, COUNT(T.ct_tag_id) AS tags
FROM... |
2 years ago |
SELECT P.page_title C.comment_text, COUNT(T.ct_tag_id) AS tags
FROM... |
2 years ago |
SELECT P.page_title C.comment_text, COUNT(T.ct_tag_id)
FROM... |
2 years ago |
SELECT P.page_title C.comment_text, AVG(T.ct_tag_id)
FROM ukwiki_p.revision... |
2 years ago |
SELECT *#P.page_title, T.ct_params, C.comment_text, T.ct_tag_id
FROM... |
2 years ago |
SELECT P.page_title, T.ct_params, C.comment_text, T.ct_tag_id
FROM... |
2 years ago |
SELECT P.page_title, T.ct_params, C.comment_text, T.ct_tag_id
FROM... |
2 years ago |
SELECT P.page_title, T.ct_params/*, C.comment_text*/, T.ct_tag_id
FROM... |
2 years ago |
SELECT P.page_title, R.rev_id, T.ct_params/*, C.comment_text*/,... |
2 years ago |
SELECT P.page_title, R.rev_id, T.ct_params/*, C.comment_text*/,... |
2 years ago |
SELECT P.page_title, T.ct_params/*, C.comment_text*/, T.ct_tag_id
FROM... |
2 years ago |
SELECT P.page_title, T.ct_params/*, C.comment_text*/, T.ct_tag_id
FROM... |
2 years ago |
SELECT P.page_title, T.ct_params, C.comment_text, T.ct_tag_id
FROM... |
2 years ago |
/*SELECT P.page_title, T.ct_params, C.comment_text, T.ct_tag_id
FROM... |
2 years ago |
/*SELECT P.page_title, T.ct_params, C.comment_text, T.ct_tag_id
FROM... |
2 years ago |
#SELECT #P.page_title,
#P.page_namespace,
#A.actor_name,
... |
2 years ago |
#SELECT #P.page_title,
#P.page_namespace,
#A.actor_name,
... |
2 years ago |
#SELECT #P.page_title,
#P.page_namespace,
#A.actor_name,
... |
2 years ago |
#SELECT #P.page_title,
#P.page_namespace,
#A.actor_name,
... |
2 years ago |
#SELECT #P.page_title,
#P.page_namespace,
#A.actor_name,
... |
2 years ago |
#SELECT #P.page_title,
#P.page_namespace,
#A.actor_name,
... |
2 years ago |
#SELECT #P.page_title,
#P.page_namespace,
#A.actor_name,
... |
2 years ago |
SELECT #P.page_title,
#P.page_namespace,
#A.actor_name,
... |
3 years ago |
SELECT #P.page_title,
#P.page_namespace,
#A.actor_name,
... |
3 years ago |
SELECT #P.page_title,
#P.page_namespace,
#A.actor_name,
... |
3 years ago |
SELECT #P.page_title,
#P.page_namespace,
#A.actor_name,
... |
3 years ago |