| blank query |
2 years ago |
| use bnwiki_p;
select concat("#[[আলাপ:",page_title,"]]"),
actor_name
from... |
2 years ago |
| blank query |
2 years ago |
| use wikidatawiki_p;
SELECT CURRENT_DATE;
SELECT term_text, count(*)
from... |
2 years ago |
| use wikidatawiki_p;
SELECT CURRENT_DATE;
SELECT term_text, count(*)
from... |
2 years ago |
| use wikidatawiki_p;
SELECT CURRENT_DATE;
SELECT term_text, count(*)
from... |
2 years ago |
| use wikidatawiki_p;
SELECT CURRENT_DATE;
SELECT term_text, count(*)
from... |
2 years ago |
| SELECT CURRENT_DATE;
SELECT term_text, count(*)
from wb_terms
WHERE... |
2 years ago |
| - |
2 years ago |
| SELECT
CONCAT('# [[আলাপ:',page_title,']]')
FROM page
LEFT JOIN... |
2 years ago |
| select p.page_title, pp.pp_value
from page p
join page_props pp on p.page_id... |
2 years ago |
| -- |
2 years ago |
| SELECT
CONCAT('[[{{ns:', page_namespace, '}}:', page_title, ']]') AS... |
2 years ago |
| -- |
2 years ago |
| SELECT concat('* [[File talk:', p.page_title, ']] ') as pagetitle
FROM page... |
2 years ago |
| SELECT user_name, user_editcount
FROM user_groups
LEFT JOIN user
ON ug_user... |
2 years ago |
| -- |
2 years ago |
| --
SET @counter:=0;
SELECT... |
2 years ago |
| -- |
2 years ago |
| SET @counter:=0;
SELECT... |
2 years ago |
| SET @counter:=0;
SELECT... |
2 years ago |
| -- |
2 years ago |
| select actor_name, count(rev_actor)
from revision
JOIN actor ON actor_id =... |
2 years ago |
| --
select actor_name, count(rev_actor)
from revision
JOIN actor ON actor_id... |
2 years ago |
| -- |
2 years ago |
| --
SET @counter:=0;
SELECT... |
2 years ago |
| -- |
2 years ago |
| SET @counter:=0;
SELECT... |
2 years ago |
| SET @counter:=0;
SELECT... |
2 years ago |
| SET @counter:=0;
SELECT... |
2 years ago |
