| use frwiki_p;
SELECT enp.page_title, "P2767", enel.el_to, concat('S143'),... |
8 years ago |
| use enwiki_p;
SELECT enp.page_title, "P2767", enel.el_to, concat('S143'),... |
8 years ago |
| use plwiki_p;
SELECT enp.page_title, "P2767", enel.el_to, concat('S143'),... |
8 years ago |
| use eswiki_p;
SELECT enp.page_title, "P2767", enel.el_to, concat('S143'),... |
8 years ago |
| use frwiki_p;
SELECT *
FROM externallinks enel
where el_to like... |
8 years ago |
| use sawiki_p;
SELECT p.page_title
from page p
where p.page_namespace=14
and... |
8 years ago |
| use sawiki_p;
select *
from page
where page_namespace=14 and page_title... |
8 years ago |
| use sawiki_p;
select *
from page
where page_namespace=14 and page_title... |
8 years ago |
| select now();
USE lvwiki_p;
SELECT rc_user_text as "Dalībnieks",... |
8 years ago |
| USE lvwiki_p;
SELECT rc_user_text as "Dalībnieks", count(rc_id) as "Labojumu... |
8 years ago |
| USE lvwiki_p;
SELECT *#rc_user_text, count(rc_id)
from recentchanges
where... |
8 years ago |
| USE lvwiki_p;
SELECT distinct rc_type#, rc_comment, rc_namespace
from... |
8 years ago |
| USE lvwiki_p;
SELECT distinct rc_type, rc_comment, rc_namespace
from... |
8 years ago |
| USE lvwiki_p;
SELECT *
from recentchanges
where rc_type=142
limit 100 |
8 years ago |
| USE lvwiki_p;
SELECT *
from recentchanges
where rc_type in 142
limit 100 |
8 years ago |
| USE lvwiki_p;
SELECT *
from recentchanges
where rc_type in (0,1,3,6,142)
limit 100 |
8 years ago |
| USE lvwiki_p;
SELECT *
from recentchanges
where rc_type in (0,1,3,6,142)
limit 100 |
8 years ago |
| USE lvwiki_p;
SELECT distinct rc_type, rc_user_text
#count(rc_type),
from... |
8 years ago |
| USE lvwiki_p;
SELECT rc_user_text,
#count(rc_type),
distinct rc_type
from... |
8 years ago |
| USE lvwiki_p;
SELECT rc_user_text,
#count(rc_type),
distinct rc_type
from... |
8 years ago |
| USE lvwiki_p;
SELECT rc_user_text,
#count(rc_type),
distinct rc_type
from... |
8 years ago |
| USE lvwiki_p;
SELECT rc_user_text, count(rc_type), rc_type
from... |
8 years ago |
| USE lvwiki_p;
SELECT rc_user_text, count(rc_type)
from recentchanges
where... |
8 years ago |
| USE lvwiki_p;
SELECT rc_user_text, count(rc_id)
from recentchanges
where... |
8 years ago |
| USE lvwiki_p;
SELECT rc_user_text, count(rc_id)
from recentchanges
where... |
8 years ago |
| USE lvwiki_p;
SELECT rc_user_text, count(rc_id)
from recentchanges
where... |
8 years ago |
| USE lvwiki_p;
SELECT rc_user_text, count(rc_id)
from recentchanges
where... |
8 years ago |
| USE lvwiki_p;
SELECT *#rc_user_text, count(rc_id)
from recentchanges
where... |
8 years ago |
| USE lvwiki_p;
SELECT *#rc_user_text, count(rc_id)
from recentchanges
where... |
8 years ago |
| USE lvwiki_p;
SELECT *#rc_user_text, count(rc_id)
from recentchanges
where... |
8 years ago |
| USE lvwiki_p;
SELECT *#rc_user_text, count(rc_id)
from recentchanges
where... |
8 years ago |
| USE lvwiki_p;
SELECT rc_user_text, count(rc_id)
from recentchanges
where... |
8 years ago |
| USE lvwiki_p;
SELECT rc_user_text, count(rc_id)
from recentchanges
where... |
8 years ago |
| USE lvwiki_p;
SELECT *
from recentchanges
where rc_type in (0,1,2,3,4)
limit 100; |
8 years ago |
| USE lvwiki_p;
SELECT *
from recentchanges
where rc_type in (0,1,2,3,4)
limit 15; |
8 years ago |
| USE lvwiki_p;
SELECT *
from recentchanges
where rc_source not in... |
8 years ago |
| USE lvwiki_p;
SELECT *
from recentchanges
where rc_type not in... |
8 years ago |
| USE lvwiki_p;
SELECT *
from recentchanges
limit 15; |
8 years ago |
