| use hewiki_p;
select concat('[[:קטגוריה:', replace(cl_to, "_", " "), ']]')... |
8 years ago |
| use hewiki_p;
select concat('[[:קטגוריה:', replace(cl_to, "_", " "), ']]')... |
8 years ago |
| use hewiki_p;
select concat('[[:קטגוריה:', replace(cl_to, "_", " "), ']]')... |
8 years ago |
| use hewiki_p;
select replace(cl_to, "_", " ") as "category",... |
8 years ago |
| use hewiki_p;
select replace(cl_to, "_", " ") as "category",... |
8 years ago |
| use hewiki_p;
select replace(cl_to, "_", " ") as "category",... |
8 years ago |
| use hewiki_p;
select replace(cl_to, "_", " ") as "category"#,... |
8 years ago |
| use hewiki_p;
select distinct(cl_to) #replace(cl_to, "_", " ") as... |
8 years ago |
| use hewiki_p;
SET @rowno = 0;
select @rowno:=@rowno+1 as `rn`,
(SELECT... |
8 years ago |
| use hewiki_p;
SET @rowno = 0;
select @rowno:=@rowno+1 as `rn`,
(SELECT... |
8 years ago |
| use hewiki_p;
SET @rowno = 0;
SELECT distinct(cl_to), @rowno:=@rowno+1 as... |
8 years ago |
| use hewiki_p;
SET @rowno = 0;
SELECT @rowno:=@rowno+1 as `rn`,... |
8 years ago |
| use hewiki_p;
select distinct(cl_to) #replace(cl_to, "_", " ") as... |
8 years ago |
| use hewiki_p;
select distinct(replace(cl_to), "_", " ") as "category"#,... |
8 years ago |
| use hewiki_p;
select distinct(replace(cl_to), "_", " ") as "category"#,... |
8 years ago |
| use hewiki_p;
select distinct(replace(cl_to), "_", " ") as "category"#,... |
8 years ago |
| use hewiki_p;
select replace(distinct(cl_to), "_", " ") as "category"#,... |
8 years ago |
| use hewiki_p;
select replace(cl_to, "_", " ") as "category",... |
8 years ago |
| use hewiki_p;
set @rowno = 0;
select @rowno:=@rowno+1 as `rn`,... |
8 years ago |
| use hewiki_p;
set @rowno = 0;
select @rowno:=@rowno+1 as `rn`,... |
8 years ago |
| use hewiki_p;
set @rowno = 0;
select @rowno:=@rowno+1 as `rn`,... |
8 years ago |
| use hewiki_p;
set @rowno = 0;
select @rowno:=@rowno+1 as `rn`,... |
8 years ago |
| use hewiki_p;
set @rowno = 0;
select @rowno:=@rowno+1 as `rn`,... |
8 years ago |
| use hewiki_p;
select ROW_NUMBER() OVER(ORDER BY category DESC) AS Row,... |
8 years ago |
| use hewiki_p;
select replace(cl_to, "_", " ") as "category",... |
8 years ago |
| use hewiki_p;
select replace(cl_to, "_", " ") as "category",... |
8 years ago |
| use hewiki_p;
select replace(cl_to, "_", " ") as "category",... |
8 years ago |
| use hewiki_p;
select cl_to as "category", page_title as "template" from page... |
8 years ago |
| use hewiki_p;
select page_title as "template" , cl_to as "category" from... |
8 years ago |
| use hewiki_p;
select page_title as "template" , cl_to as "category" from... |
8 years ago |
| use hewiki_p;
select page_title as "template" , cl_to as "category" from... |
8 years ago |
| use hewiki_p;
select page_title as "template" , cl_to as "category" from... |
8 years ago |
| use hewiki_p;
select page_title as "template" , cl_to as "category" from... |
8 years ago |
| use hewiki_p;
select page_title as "template" , cl_to as "category" from... |
8 years ago |
| use hewiki_p;
select page_title, cl_to from page join categorylinks
on... |
8 years ago |
| use hewiki_p;
select page_title, categorylinks.* from page join... |
8 years ago |
| use hewiki_p;
select page_title from page
where page_namespace = 10
and... |
8 years ago |
| use hewiki_p;
select * from page
where page_namespace = 10
and page_title... |
8 years ago |
| use hewiki_p;
select * from page
where page_namespace = 10
and page_title... |
8 years ago |
| use hewiki_p;
select * from page
where page_namespace = 10
and page_title... |
8 years ago |
| use hewiki_p;
select * from page
where page_namespace = 10
and page_title... |
8 years ago |
| use hewiki_p;
select * from page
where page_namespace = 10
and page_title... |
8 years ago |
| use hewiki_p;
select * from page
where page_namespace = 10
and page_title... |
8 years ago |
| use hewiki_p;
select * from page
where page_namespace = 10
and page_title... |
8 years ago |
| use hewiki_p;
select * from page
where page_namespace = 10
and page_title... |
8 years ago |
| use hewiki_p;
select * from page
where page_namespace = 10
and page_title... |
8 years ago |
| use hewiki_p;
select * from page
where page_namespace = 10
and page_title... |
8 years ago |
| use hewiki_p;
select * from page
where page_namespace = 10
and page_title... |
8 years ago |
| use hewiki_p;
select * from page
where page_namespace = 10
and page_title... |
8 years ago |
| use hewiki_p;
select * from page
where page_namespace = 10
and page_title... |
8 years ago |
| use hewiki_p;
select * from page
where page_namespace = 10
and page_title... |
8 years ago |
| use hewiki_p;
select * from page
where page_namespace = 10
and page_title... |
8 years ago |
| use hewiki_p;
select * from page
where page_namespace = 10
and page_title... |
8 years ago |
| use hewiki_p;
select * from page
where page_namespace = 10
and page_title... |
8 years ago |
| use hewiki_p;
select * from page
where page_namespace = 10
and page_title... |
8 years ago |
| use hewiki_p;
select * from page
where page_namespace = 10
and page_title... |
8 years ago |
| use hewiki_p;
select * from page
where page_namespace = 10
and page_title... |
8 years ago |
| use hewiki_p;
select * from page
where page_namespace = 10
and page_title... |
8 years ago |
| use hewiki_p;
select * from page
where page_namespace = 10
and page_title... |
8 years ago |
| use hewiki_p;
select * from page
where page_namespace = 10
and page_title... |
8 years ago |
| select * from page
where
page_title = "מרטין_אומאלי"
and page_namespace = 0 |
9 years ago |
| select * from page
where
page_title = "מרטין אומאלי"
and page_namespace = 0 |
9 years ago |
| select * from page
where
page_title = "מרטין_אומאלי"
and page_namespace = 0 |
9 years ago |
| select * from page
where
page_title = "מרטין_אומאלי"
and page_namespace = 0 |
9 years ago |
| select * from page
where
and page_title = "מרטין_אומאלי"
and page_namespace = 0 |
9 years ago |
| select * from page join categorylinks
on page_id = cl_from
and page_title =... |
9 years ago |
