| USE trwiki_p;
select... |
6 years ago |
| USE trwiki_p;
select *,... |
6 years ago |
| USE trwiki_p;
select *,... |
6 years ago |
| USE trwiki_p;
select *,... |
6 years ago |
| USE trwiki_p;
select *,... |
6 years ago |
| USE trwiki_p;
select *, count(*)
from categorylinks
where cl_to not in... |
6 years ago |
| USE trwiki_p;
select *, count(*)
from categorylinks
group by cl_type;
/*... |
6 years ago |
| USE trwiki_p;
select *,... |
6 years ago |
| USE trwiki_p;
select *,... |
6 years ago |
| USE trwiki_p;
select *,... |
6 years ago |
| USE trwiki_p;
select *,... |
6 years ago |
| USE trwiki_p;
select *,... |
6 years ago |
| USE trwiki_p;
select *,... |
6 years ago |
| USE trwiki_p;
select *,... |
6 years ago |
| USE trwiki_p;
select *,... |
6 years ago |
| USE trwiki_p;
select *,... |
6 years ago |
| USE trwiki_p;
select * , left(replace(cl_to,"İ","I"),1) as ilk
,... |
6 years ago |
| USE trwiki_p;
select * , left(replace(cl_to,"İ","I"),1) as ilk
,... |
6 years ago |
| USE trwiki_p;
select * , left(cl_to,1) as ilk
,... |
6 years ago |
| USE trwiki_p;
select * , left(cl_to,1) as ilk
,... |
6 years ago |
| USE trwiki_p;
select * , left(cl_to,1) as ilk
,... |
6 years ago |
| USE trwiki_p;
select * , left(cl_to,1) as ilk
,... |
6 years ago |
| USE trwiki_p;
select * , left(cl_to,1) as ilk
,... |
6 years ago |
| USE trwiki_p;
select * , left(cl_to,1) as ilk
,... |
6 years ago |
| USE trwiki_p;
select * , left(cl_to,1) as ilk
,... |
6 years ago |
| USE trwiki_p;
select * , left(cl_to,1) as ilk
,... |
6 years ago |
| USE trwiki_p;
select * , left(cl_to,1) as ilk
, upper(left(cl_to,20)) as... |
6 years ago |
| USE trwiki_p;
select * , left(cl_to,1) as ilk
, lower(left(cl_to,20)) as... |
6 years ago |
| USE trwiki_p;
select * , left(cl_to,1) as ilk
, lower(left(cl_to,20))) as... |
6 years ago |
| USE trwiki_p;
select * , left(cl_to,1) as ilk
,... |
6 years ago |
| USE trwiki_p;
select * , left(cl_to,1) as ilk, convert(left(cl_to,20) USING... |
6 years ago |
| USE trwiki_p;
select * , left(cl_to,1) as ilk, convert(left(cl_to,20) USING... |
6 years ago |
| USE trwiki_p;
select * , left(cl_to,1) as ilk, convert(left(cl_to,20) USING... |
6 years ago |
| USE trwiki_p;
select * , left(cl_to,1) as ilk
from categorylinks
limit 50
;
|
6 years ago |
| USE trwiki_p;
set @harf = "A";
select * from categorylinks, left(cl_to,1) as... |
6 years ago |
| USE trwiki_p;
set @harf = "A";
select * from categorylinks
-- join page pck... |
6 years ago |
| USE trwiki_p;
set @harf = "A";
select * from categorylinks
-- join page pck... |
6 years ago |
| USE trwiki_p;
set @harf = "A";
select * from categorylinks
join page pck on... |
6 years ago |
| USE trwiki_p;
set @harf = "A"
select * from categorylinks
join page pck on... |
6 years ago |
| USE trwiki_p;
select * from categorylinks
join page pck on... |
6 years ago |
| USE trwiki_p;
select * from categorylinks
join page pck on... |
6 years ago |
| USE trwiki_p;
select * from categorylinks
join page pck on... |
6 years ago |
| USE trwiki_p;
select * from categorylinks
limit 5;
/*
select pl_title,... |
6 years ago |
| USE trwiki_p;
select * from templatelinks
limit 5;
/*
select pl_title,... |
6 years ago |
| USE trwiki_p;
select * from templatelinks
limit 5;
/*select pl_title,... |
6 years ago |
