| USE ckbwiki_p;
SELECT page_title
FROM page
WHERE page_namespace = 10 --... |
1 month ago |
| USE ckbwiki_p;
SELECT tl_title
FROM templatelinks
WHERE tl_title LIKE '%قورئان%';
|
1 month ago |
| USE ckbwiki_p;
SELECT page_title
FROM templatelinks
WHERE tl_title LIKE... |
1 month ago |
| USE ckbwiki_p;
SELECT
page_title,
cat_pages,
cat_subcats
FROM... |
6 months ago |
| USE ckbwiki_p;
SELECT
page_namespace,
CONCAT('[[',
CASE
WHEN... |
6 months ago |
| USE ckbwiki_p;
SELECT
page_namespace,
CONCAT('[[',
CASE
WHEN... |
6 months ago |
| USE ckbwiki_p;
SELECT
page_namespace,
CASE
WHEN page_namespace = 2... |
6 months ago |
| USE ckbwiki_p;
SELECT
page_namespace,
CONCAT('[[', page_namespace, ':',... |
6 months ago |
| USE ckbwiki_p;
SELECT
page_namespace,
CONCAT('[[', REPLACE(page_title,... |
6 months ago |
| USE ckbwiki_p;
SELECT page_namespace, page_title
FROM page
WHERE page_title... |
6 months ago |
| USE ckbwiki_p;
SELECT page_namespace, page_title
FROM page
WHERE page_title... |
6 months ago |
| USE ckbwiki_p;
SELECT page_title
FROM page
WHERE page_title RLIKE '.*ئارام... |
6 months ago |
| USE ckbwiki_p;
SELECT page_title
FROM page
WHERE page_title RLIKE 'ئارام... |
6 months ago |
| USE ckbwiki_p;
SELECT page_title
FROM page
WHERE page_title LIKE '%ئارام... |
6 months ago |
| USE ckbwiki_p;
SELECT page_title
FROM page
WHERE page_title LIKE '%ئارام بکر%'
|
6 months ago |
| USE ckbwiki_p;
SELECT
page_title,
cat_pages,
cat_subcats
FROM... |
6 months ago |
| USE ckbwiki_p;
SELECT
page_title,
cat_pages,
cat_subcats
FROM... |
6 months ago |
| USE ckbwiki_p;
SELECT
comment_text,
COUNT(*) AS uses
FROM... |
6 months ago |
| USE ckbwiki_p;
SELECT
comment_text,
COUNT(*) AS uses
FROM... |
6 months ago |
| USE ckbwiki_p;
SELECT
CONCAT(ns_name, ':', page_title),
page_len
FROM... |
6 months ago |
| USE ckbwiki_p;
SELECT
CONCAT(ns_name, ':', page_title),
page_len
FROM... |
6 months ago |
| USE ckbwiki_p;
SELECT
CONCAT(ns_name, ':', page_title),
page_len
FROM... |
6 months ago |
| USE ckbwiki_p;
SELECT
CONCAT(ns_name, ':', page_title),
page_len
FROM... |
6 months ago |
| USE ckbwiki_p;
SELECT
COUNT(*),
TRIM(LEADING 'www.' FROM... |
6 months ago |
| USE ckbwiki_p;
SELECT
pl_title,
count(*),
page_id
FROM... |
6 months ago |
| USE ckbwiki_p;
select
rev_user,
count(*) / (... |
6 months ago |
| USE ckbwiki_p;
SELECT
pl_title,
count(*),
page_id
FROM... |
6 months ago |
| USE ckbwiki_p;
SELECT
pl_title,
count(*),
page_id
FROM... |
6 months ago |
| USE ckbwiki_p;
SELECT
pl_title,
count(*),
page_id
FROM... |
6 months ago |
| USE ckbwiki_p;
SELECT
pl_title,
count(*),
page_id
FROM... |
6 months ago |
| USE ckbwiki_p;
SELECT
pl_title,
count(*),
page_id
FROM... |
6 months ago |
| USE ckbwiki_p;
select DATE_FORMAT(log_timestamp,"%Y-%m-%d"), count(*)
... |
6 months ago |
| USE ckbwiki_p;
select DATE_FORMAT(log_timestamp,"%Y-%m-%d"), count(*)
... |
6 months ago |
| USE ckbwiki_p;
select DATE_FORMAT(log_timestamp,"%Y-%m-%d"), count(*)
... |
6 months ago |
| USE ckbwiki_p;
SELECT
DATE( log_timestamp ) AS Date,
COUNT( log_id ) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT DISTINCT
rev_user_text,
user_editcount
FROM... |
6 months ago |
| USE ckbwiki_p;
SELECT
DAY,
ACTIONS
FROM (SELECT
SUBSTR(log_timestamp,... |
6 months ago |
| USE ckbwiki_p;
SELECT
MONTH,
USERS
FROM (SELECT
SUBSTR(afl_timestamp,... |
6 months ago |
| USE ckbwiki_p;
SELECT
SUBSTR(rev_timestamp, 1, 6) AS MONTH,
... |
6 months ago |
| USE ckbwiki_p;
SELECT
CONCAT(month, '/', year) monthly,
SUM(period < 7)... |
6 months ago |
| USE ckbwiki_p;
SELECT rc_title, count(*) as num_edits
FROM recentchanges... |
6 months ago |
| USE ckbwiki_p;
SELECT
log_user_text, COUNT(*)
FROM logging
JOIN... |
6 months ago |
| USE ckbwiki_p;
SELECT
rev_user_text, COUNT(*)
FROM revision
JOIN page
ON... |
6 months ago |
| USE ckbwiki_p;
SELECT
rev_user_text, COUNT(*)
FROM revision
JOIN page
ON... |
6 months ago |
| USE ckbwiki_p;
SELECT
rev_user_text, COUNT(*)
FROM revision
JOIN page
ON... |
6 months ago |
| USE ckbwiki_p;
SELECT
rev_user_text, COUNT(*)
FROM revision
JOIN page
ON... |
6 months ago |
| USE ckbwiki_p;
SELECT
page_namespace,
page_title,
page_len
FROM... |
6 months ago |
| USE ckbwiki_p;
SELECT
page_namespace,
page_title,
page_len
FROM... |
6 months ago |
| USE ckbwiki_p;
SELECT
page_namespace,
page_title,
page_len
FROM... |
6 months ago |
| USE ckbwiki_p;
SELECT
page_namespace,
page_title,
page_len
FROM... |
6 months ago |
| USE ckbwiki_p;
SELECT
page_namespace,
page_title,
page_len
FROM... |
6 months ago |
| USE ckbwiki_p;
WITH InactiveBotsData AS (
SELECT
actor_name AS... |
6 months ago |
| USE ckbwiki_p;
WITH ActiveBotsData AS (
SELECT
actor_name AS... |
6 months ago |
| USE fawiki_p;
WITH ActiveBotsData AS (
SELECT
actor_name AS... |
6 months ago |
| USE kuwiki_p;
WITH ActiveBotsData AS (
SELECT
actor_name AS... |
6 months ago |
| USE arwiki_p;
WITH ActiveBotsData AS (
SELECT
actor_name AS... |
6 months ago |
| USE arwiki_p;
WITH ActiveBotsData AS (
SELECT
actor_name AS... |
6 months ago |
| USE arwiki_p;
WITH ActiveBotsData AS (
SELECT
actor_name AS... |
6 months ago |
| WITH BotsData AS (
SELECT
actor_name AS Username,
... |
6 months ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY LastEditDate DESC) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY LastEditDate DESC) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY LastEditDate DESC) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY LastEditDate DESC) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY LastEditDate DESC) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY LastEditDate DESC) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY LastEditDate DES) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY LastEditDate ASC) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY LastEditDate ASC) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY LastEditDate ASC) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY LastEditDate ASC) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
(@row_number := @row_number + 1) AS '#',
... |
6 months ago |
| USE ckbwiki_p;
SELECT
@row_number := @row_number + 1 AS '#',
... |
6 months ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY LastEditDate ASC) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY LastEditDate ASC) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER () AS '#',
actor_name AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY LastEditDate ASC) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY LastEditDate ASC) AS... |
6 months ago |
| USE ckbwiki_p;
SET @rownum = 0;
SELECT
(@rownum := @rownum + 1) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER () AS `#`,
actor_name AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER () AS '#',
actor_name AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
@counter := @counter + 1 AS `#`,
actor_name... |
6 months ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER () AS 'num',
actor_name AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER () AS '#',
actor_name AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER () AS #,
actor_name AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY LastEditDate ASC) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER () AS '#',
actor_name AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER () AS '#'
actor_name AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER () AS #,
actor_name AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER () AS #,
actor_name AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
'#' AS #,
actor_name AS Username,
... |
6 months ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER () AS "#",
actor_name AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER () AS '#',
actor_name AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| SELECT COUNT(*) AS edit_count
FROM revision
JOIN actor ON rev_actor =... |
6 months ago |
| SELECT COUNT(*) AS edit_count
FROM revision
JOIN actor ON rev_actor =... |
6 months ago |
| SELECT COUNT(*) AS edit_count
FROM revision
JOIN actor ON rev_actor =... |
6 months ago |
| SELECT COUNT(*) AS edit_count
FROM revision
JOIN actor ON rev_actor =... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS edit_count
FROM revision
JOIN actor ON... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS edit_count
FROM revision
JOIN actor ON... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS edit_count
FROM revision
JOIN actor ON... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS edit_count
FROM revision
JOIN actor ON... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS edit_count
FROM revision
JOIN actor ON... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS total_edit_count
FROM revision
JOIN actor... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS count
FROM revision_userindex
JOIN actor... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS count
FROM revision_userindex
JOIN actor... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS count
FROM revision_userindex
JOIN actor... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(DISTINCT rev_id) AS edit_count
FROM... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS edit_count
FROM revision
JOIN actor ON... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS edit_count
FROM revision
JOIN actor ON... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS edit_count
FROM revision
JOIN actor ON... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS edit_count
FROM revision
JOIN actor ON... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS edit_count
FROM revision
JOIN actor ON... |
6 months ago |
| USE ckbwiki_p;
-- Count the number of edits by AramBot
SELECT COUNT(*) AS... |
6 months ago |
| USE ckbwiki_p;
-- Count the number of edits by AramBot
SELECT COUNT(*) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS edit_count
FROM revision
JOIN actor ON... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS edit_count
FROM revision
JOIN actor ON... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS edit_count
FROM revision
JOIN actor ON... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS edit_count
FROM revision
JOIN actor ON... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS edit_count
FROM revision
JOIN actor ON... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS edit_count
FROM revision
JOIN actor ON... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS edit_count
FROM revision
JOIN actor ON... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS edit_count
FROM revision
JOIN actor ON... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS edit_count
FROM revision
JOIN actor ON... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS edit_count
FROM revision
JOIN user ON... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS edit_count
FROM revision
JOIN user ON... |
6 months ago |
| USE ckbwiki_p;
-- Count the number of edits by AramBot
SELECT COUNT(*) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS edit_count
FROM actor
JOIN... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS edit_count
FROM revision
WHERE rev_user =... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS edit_count
FROM revision
WHERE... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS edit_count
FROM revision
WHERE rev_user =... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS edit_count
FROM revision
WHERE... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS edit_count
FROM revision
WHERE... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS edit_count
FROM revision
WHERE rev_user =... |
6 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS edit_count
FROM revision
WHERE... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
actor_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
| USE ckbwiki_p;
SELECT
user.user_name AS Username,
... |
6 months ago |
| SELECT
user.user_name AS Username,
MAX(rev_timestamp) AS... |
6 months ago |
