SELECT
CONCAT("Template:", lt_title) as tmpl,
COUNT(*) as cnt
FROM... |
1 year ago |
SELECT
page_namespace,
page_title,
page_len
FROM page
WHERE page_len >... |
1 year ago |
SELECT
page_namespace,
page_title,
page_len
FROM page
WHERE page_len >... |
1 year ago |
SELECT
page_namespace,
page_title,
page_len
FROM page
WHERE page_len >... |
1 year ago |
-- -- |
2 years ago |
select rc_title, comment_text
from `recentchanges`
join `comment`
on... |
2 years ago |
select rc_title, comment_text
from `recentchanges`
join `comment`
on... |
3 years ago |
select rc_title, comment_text
from `recentchanges`
join `comment`
on... |
3 years ago |
select rc_title, comment_text
from `recentchanges`
join `comment`
on... |
3 years ago |
select rc_title, comment_text
from `recentchanges`
join `comment`
on... |
3 years ago |
select rc_title, comment_text
from `recentchanges`
join `comment`
on... |
3 years ago |
select rc_title, comment_text
from `recentchanges`
join `comment`
on... |
3 years ago |
select *
from recentchanges
where rc_type in (0, 1)
and rc_patrolled = 0
limit 10; |
3 years ago |
select count(*) from recentchanges
where rc_type = 0
and rc_patrolled = 0
limit 10; |
3 years ago |
select * from recentchanges
where rc_type = 0
and rc_patrolled = 0
limit 10; |
3 years ago |
select * from recentchanges
limit 10; |
3 years ago |
select * from recentchances
limit 10; |
3 years ago |
-- -- |
3 years ago |
/*
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
/*
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
/*
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
/*
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
/*
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
/*
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
/*
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
/*
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
/*
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
/* SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
/* SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY pp_propname;... |
3 years ago |
/* SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY pp_propname;... |
3 years ago |
/* SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY pp_propname;... |
3 years ago |
/* SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY pp_propname;... |
3 years ago |
/* SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY pp_propname;... |
3 years ago |
/* SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY pp_propname;... |
3 years ago |
/* SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY pp_propname;... |
3 years ago |
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY pp_propname;
/*... |
3 years ago |
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
SELECT pp_propname, COUNT(pp_page)
FROM page_props
GROUP BY... |
3 years ago |
SELECT pp_propname, COUNT(page_id)
FROM page
JOIN page_props ON pp_page =... |
3 years ago |
SELECT pp_propname -- , COUNT(page_id)
FROM page
JOIN page_props ON pp_page... |
3 years ago |
SELECT pp_propname -- , COUNT(page_id)
FROM page
JOIN page_props ON pp_page... |
3 years ago |
SELECT pp_progname -- , COUNT(page_id)
FROM page
JOIN page_props ON pp_page... |
3 years ago |
SELECT * -- ppp.pp_progname -- , COUNT(page_id)
FROM page
JOIN page_props ON... |
3 years ago |
SELECT ppp.pp_progname -- , COUNT(page_id)
FROM page
JOIN page_props AS... |
3 years ago |
SELECT ppp.pp_progname -- , COUNT(page_id)
FROM page
JOIN page_props AS... |
3 years ago |
SELECT pp_progname -- , COUNT(page_id)
FROM page
JOIN page_props ON pp_page... |
3 years ago |
SELECT * -- pp_progname, COUNT(page_id)
FROM page
JOIN page_props ON pp_page... |
3 years ago |
SELECT * -- pp_progname, COUNT(page_id)
FROM page
JOIN page_props ON pp_page... |
3 years ago |
SELECT * -- pp_progname, COUNT(page_id)
FROM page
JOIN page_props ON pp_page... |
3 years ago |
SELECT pp_progname, COUNT(page_id)
FROM page
JOIN page_props ON pp_page =... |
3 years ago |
SELECT *
FROM page
JOIN page_props ON pp_page = page_id
LIMIT 10; |
3 years ago |
SELECT 5*9; |
3 years ago |
SET @ct:=0;
SELECT
CONCAT("{{subst:formatnum:",@ct:=@ct+1,"}}") AS... |
3 years ago |
SET @ct:=0;
SELECT
CONCAT("{{subst:formatnum:",@ct:=@ct+1,"}}") AS... |
3 years ago |
SET @ct:=0;
SELECT
CONCAT("{{subst:formatnum:",@ct:=@ct+1,"}}") AS... |
3 years ago |
Select 3; |
3 years ago |
SET @ct:=0;
SELECT
CONCAT("{{subst:formatnum:",@ct:=@ct+1,"}}") AS... |
3 years ago |
SET @ct:=0;
SELECT
CONCAT("{{subst:formatnum:",@ct:=@ct+1,"}}")
AS... |
3 years ago |
SET @ct:=0;
SELECT
CONCAT("{{subst:formatnum:",@ct:=@ct+1,"}}")
AS... |
3 years ago |
SET @ct:=0;
SELECT
CONCAT("{{subst:formatnum:",@ct:=@ct+1,"}}")
AS... |
3 years ago |
SET @ct:=0;
SELECT
CONCAT("{{subst:formatnum:",@ct:=@ct+1,"}}") as... |
3 years ago |
SET @ct:=0;
SELECT
CONCAT("{{subst:formatnum:",@ct:=@ct+1,"}}") as... |
3 years ago |
SET @ct:=0;
SELECT @ct:=@ct+1 as r,
CONCAT("{{u|",user,"}}") as... |
3 years ago |
SET @ct:=0;
SELECT @ct:=@ct+1 as r,
CONCAT("{{u|",user,"}}") as... |
3 years ago |
SET @ct:=0;
SELECT @ct:=@ct+1 as r,
CONCAT("{{u|",user,"}}") as... |
3 years ago |
SET @ct:=0;
SELECT @ct:=@ct+1, user, cnt FROM (
SELECT
actor_name AS user,
... |
3 years ago |
SET @ct:=0;
SELECT @ct:=@ct+1, * FROM (
SELECT
actor_name AS user,
... |
3 years ago |
SET @ct:=0;
SELECT @ct:=@ct+1 FROM (
SELECT
actor_name AS user,
... |
3 years ago |
SET @ct:=0;
SELECT @ct FROM (
SELECT
@ct,
actor_name AS user,
... |
3 years ago |
SET @ct:=0;
SELECT @ct FROM (
SELECT
@ct,
actor_name AS user,
... |
3 years ago |
SET @ct:=0;
SELECT @ct:=@ct+1 FROM (
SELECT
@ct,
actor_name AS user,
... |
3 years ago |
SET @ct:=0;
SELECT @ct:=@ct+1 FROM (
SELECT
ct,
actor_name AS user,
... |
3 years ago |
-- SET @ct:=0;
-- select @ct:=@ct+1 from (
SELECT
actor_name AS user,
... |
3 years ago |
SET @ct:=0;
select @ct:=@ct+1 from (
SELECT
actor_name AS user,
... |
3 years ago |
SET @ct:=0;
select @ct:=@ct+1, actor_name from (
SELECT
actor_name AS... |
3 years ago |
SET @ct:=0;
select @ct:=@ct+1, actor_name from (
SELECT
actor_name AS... |
3 years ago |
SET @ct:=0;
select @ct:=@ct+1, actor_name from (
SELECT
actor_name AS... |
3 years ago |
SET @ct:=0;
select @ct:=@ct+1, actor_name from (
SELECT
actor_name AS... |
3 years ago |
SET @ct:=0;
select @ct:=@ct+1, * from (
SELECT
actor_name AS user,
... |
3 years ago |
SELECT
actor_name AS user,
COUNT(rev_id) AS cnt
FROM actor INNER JOIN... |
3 years ago |
SELECT
actor_name AS user,
COUNT(rev_id) AS cnt,
ROW_NUMBER() OVER... |
3 years ago |
SELECT
actor_name AS user,
COUNT(rev_id) AS cnt,
ROW_NUMBER() OVER... |
3 years ago |
SELECT
ROW_NUMBER() OVER (PARTITION BY user ORDER BY cnt Desc),
actor_name... |
3 years ago |
SET @r:=0;
SELECT
@r AS rank,
actor_name AS user,
COUNT(rev_id) AS... |
3 years ago |
SET @r:=0;
SELECT
@r:=@r+1 AS rank,
actor_name AS user,
COUNT(rev_id)... |
3 years ago |
SET @cnt:=0;
SELECT
@cnt:=@cnt+1 AS rank,
actor_name AS user,
... |
3 years ago |
SET @cnt:=0;
SELECT
@cnt:=@cnt+1 AS rank
actor_name AS user,
... |
3 years ago |
SET @cnt:=0;
SELECT @cnt:=@cnt+1, rc_id
from recentchanges
limit 5; |
3 years ago |
SET @counter:=0;
SELECT @counter:=@counter+1, rc_id
from recentchanges
limit 5; |
3 years ago |
select rc_id
from recentchanges
limit 5; |
3 years ago |