| use ukwiki_p;
SELECT
SUBSTRING_INDEX(
... |
9 months ago |
| user ukwiki_p;
SELECT
SUBSTRING_INDEX(
... |
9 months ago |
| SELECT
SUBSTRING_INDEX(
SUBSTRING_INDEX(text_content,... |
9 months ago |
| SELECT
tl_from AS page_id,
COUNT(*) AS usage_count
FROM... |
9 months ago |
| SELECT
tl_from AS page_id,
COUNT(*) AS usage_count
FROM... |
9 months ago |
| SELECT
tl_from AS page_id,
tl_title AS template_title,
COUNT(*)... |
9 months ago |
| SELECT
tl_from AS page_id,
tl_title AS template_title,
COUNT(*)... |
9 months ago |
| SELECT
tl_from AS page_id,
tl_title AS template_title,
COUNT(*)... |
9 months ago |
| SELECT
SUBSTRING_INDEX(
SUBSTRING_INDEX(text_content,... |
9 months ago |
| SELECT *
FROM site_stats; |
9 months ago |
| SELECT ss_version
FROM site_stats; |
9 months ago |
| describe text |
9 months ago |
| describe text |
9 months ago |
| describe text |
9 months ago |
| SELECT
SUBSTRING_INDEX(
SUBSTRING_INDEX(old_text, '|автор=',... |
9 months ago |
| SELECT
SUBSTRING_INDEX(
SUBSTRING_INDEX(text_content,... |
9 months ago |
| SELECT
SUBSTRING_INDEX(
SUBSTRING_INDEX(page_content,... |
9 months ago |
| SELECT
SUBSTRING_INDEX(
SUBSTRING_INDEX(tl_content, '|автор=',... |
9 months ago |
| SELECT COUNT(*)
FROM templatelinks
WHERE tl_from_namespace = 1
AND... |
9 months ago |
| SELECT COUNT(*)
FROM templatelinks
WHERE tl_from_namespace = 1
AND... |
9 months ago |
| SELECT COUNT(*)
FROM templatelinks
WHERE tl_from_namespace = 1
AND... |
9 months ago |
| SELECT page_title, COUNT(*) AS inclusion_count
FROM linktarget
LEFT JOIN... |
9 months ago |
| SELECT page_title, COUNT(*) AS inclusion_count
FROM linktarget
LEFT JOIN... |
9 months ago |
| SELECT page_title, COUNT(*) AS inclusion_count
FROM linktarget
LEFT JOIN... |
9 months ago |
| SELECT page_title, COUNT(*) AS inclusion_count
FROM linktarget
LEFT JOIN... |
9 months ago |
| SELECT page_title, COUNT(*) AS inclusion_count
FROM linktarget
LEFT JOIN... |
9 months ago |
| SELECT page_title, COUNT(*) AS inclusion_count
FROM linktarget
LEFT JOIN... |
9 months ago |
| SELECT page_title, COUNT(*) AS inclusion_count
FROM linktarget
LEFT JOIN... |
9 months ago |
| SELECT COUNT(*)
FROM templatelinks
WHERE tl_from_namespace = 1
AND... |
9 months ago |
| SELECT COUNT(*)
FROM templatelinks
WHERE tl_from_namespace = 1
AND... |
9 months ago |
| SELECT COUNT(*)
FROM templatelinks
WHERE tl_from_namespace = 1
AND... |
9 months ago |
| SELECT COUNT(*)
FROM templatelinks
WHERE tl_from_namespace = 0 -- Assuming... |
9 months ago |
| SELECT COUNT(*)
FROM templatelinks
WHERE tl_from_namespace = 0 -- Assuming... |
9 months ago |
| SELECT COUNT(*)
FROM templatelinks
WHERE tl_from_namespace = 1
AND... |
9 months ago |
| SELECT COUNT(*)
FROM templatelinks
WHERE tl_from_namespace = 0 -- Assuming... |
9 months ago |
| SELECT COUNT(*)
FROM templatelinks
WHERE tl_from_namespace = 1 -- Assuming... |
9 months ago |
| SELECT COUNT(*)
FROM templatelinks
WHERE tl_from_namespace = 1 -- Assuming... |
9 months ago |
| SELECT COUNT(*)
FROM templatelinks
WHERE tl_from_namespace = 0 -- Assuming... |
9 months ago |
| SELECT COUNT(*) FROM templatelinks; |
9 months ago |
| USE ukwiki_p;
SELECT DISTINCT (CASE WHEN page_namespace=10 THEN... |
9 months ago |
| USE ukwiki_p;
SELECT DISTINCT (CASE WHEN page_namespace=10 THEN... |
9 months ago |
| SELECT COUNT(*)
FROM page
JOIN templatelinks ON page_id = tl_from
JOIN page... |
9 months ago |
| SELECT COUNT(*)
FROM page
JOIN templatelinks ON page_id = tl_from
JOIN page... |
9 months ago |
| SELECT
COUNT(*) AS count
FROM
ukwiki_p.page
JOIN
... |
9 months ago |
| SELECT
COUNT(*) AS count
FROM
ukwiki_p.page
JOIN
... |
9 months ago |
| SELECT
actor_name AS username,
COUNT(*) AS count
FROM
... |
9 months ago |
| SELECT
actor_name AS username,
COUNT(*) AS count
FROM
... |
9 months ago |
| SELECT
actor_name AS username,
COUNT(*) AS count
FROM
... |
9 months ago |
| SELECT
actor_name AS username,
COUNT(*) AS count
FROM
... |
9 months ago |
| SELECT
actor_name AS username,
COUNT(*) AS count
FROM
... |
9 months ago |
| SELECT
actor_name AS username,
COUNT(*) AS count
FROM
... |
9 months ago |
| SELECT
actor_name AS username,
COUNT(*) AS count
FROM
... |
9 months ago |
| SELECT
actor_name AS username,
COUNT(*) AS count
FROM
... |
9 months ago |
| SELECT
actor_name AS username,
COUNT(*) AS count
FROM
... |
9 months ago |
| SELECT
rev_user_text AS username,
COUNT(*) AS count
FROM
... |
9 months ago |
| SELECT
tl_title AS username,
COUNT(*) AS count
FROM
... |
9 months ago |
