| -- |
2 years ago |
| USE wikidatawiki_p;
SELECT CONCAT("Q",ips_item_id), "Lbn",... |
2 years ago |
| USE wikidatawiki_p;
SELECT CONCAT("Q",ips_item_id), "Lbn",... |
2 years ago |
| -- |
2 years ago |
| SELECT actor_name, count(log_actor)
from logging
join actor on... |
2 years ago |
| SELECT actor_name, count(log_actor)
from logging
join actor on... |
2 years ago |
| -- |
2 years ago |
| SELECT user_id, CONCAT("[[ব্যবহারকারী আলাপ:",user_name,"|",user_name,"]]")... |
2 years ago |
| SELECT user_id, CONCAT("[[ব্যবহারকারী আলাপ:",user_name,"|",user_name,"]]")... |
2 years ago |
| SELECT user_id, CONCAT("[[User:",user_name,"|",user_name,"]]") AS user_name,... |
2 years ago |
| SELECT user_id, CONCAT("[[User:",user_name,"|",user_name,"]]") AS user_name,... |
2 years ago |
| SELECT user_id, CONCAT("[[User Talk:",user_name,"]]") AS user_name,... |
2 years ago |
| USE bnwiki_p;
SELECT user_id, CONCAT("[[User Talk:",user_name,"]]") AS... |
2 years ago |
| USE bnwiki_p;
SELECT user_id, CONCAT("[[User Talk:",user_name,"]]") AS... |
2 years ago |
| -- |
2 years ago |
| t |
2 years ago |
| USE bnwiki_p;
SELECT distinct CONCAT('# [[:আলাপ:',page_title,']]') AS... |
2 years ago |
| USE bnwiki_p;
SELECT distinct CONCAT('# [[:আলাপ:',page_title,']]') AS... |
2 years ago |
| USE bnwiki_p;
SELECT distinct CONCAT('# [[:আলাপ:',page_title,']]') AS... |
2 years ago |
| USE bnwiki_p;
SELECT distinct CONCAT('# [[:আলাপ:',page_title,']]') AS... |
2 years ago |
| --
SELECT ROW_NUMBER() OVER(ORDER BY COUNT(*) DESC) AS rank,
actor_name,
... |
2 years ago |
| --
SELECT ROW_NUMBER() OVER(ORDER BY COUNT(*) DESC) AS rank,
actor_name,
... |
2 years ago |
| -- |
2 years ago |
| USE bnwiki_p;
SELECT concat("# [[:চিত্র:",page_title,"]]") AS... |
2 years ago |
| use bnwiki_p;
select concat("#[[আলাপ:",page_title,"]]"),
actor_name
from... |
2 years ago |
| SELECT
page_namespace,
ns_name,
MAX(notredir),
MAX(redir)
FROM (
... |
2 years ago |
| SELECT
CONCAT('# [[',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
2 years ago |
| SELECT page_title,
(SELECT COUNT(*)
FROM imagelinks
WHERE il_to =... |
2 years ago |
| SELECT CONCAT('# [[আলাপ:',page_title,']]') AS page_title, CONCAT('←... |
2 years ago |
| SELECT DISTINCT
page_title
FROM externallinks
JOIN page
ON el_from =... |
2 years ago |
| -- |
2 years ago |
| USE bnwiki_p;
SELECT CONCAT("[[ব্যবহারকারী:",user_name,"|",user_name,"]]")... |
2 years ago |
| USE bnwiki_p;
SELECT log_title, COUNT(log_id)
FROM logging_logindex
WHERE... |
2 years ago |
| SELECT CONCAT("# [[ব্যবহারকারী:",page_title,"]]") AS page_title, page_len,... |
2 years ago |
| SELECT CONCAT("# [[ব্যবহারকারী:",page_title,"]]") AS page_title, page_len,... |
2 years ago |
| use bnwiki_p;
select CONCAT('[[',p.page_title,']]'), pp.pp_value
from page... |
2 years ago |
| USE bnwiki_p;
SELECT concat("* [[:চিত্র:",REPLACE(REPLACE(p.page_title, '"',... |
2 years ago |
| SELECT actor_name As Username, COUNT(log_id) As Deleted_page
FROM... |
2 years ago |
| SELECT concat("# [[টেমপ্লেট:",page_title,"]]") AS page_title
FROM... |
2 years ago |
| SELECT concat("# [[টেমপ্লেট:",page_title,"]]") AS page_title
FROM... |
2 years ago |
| USE bnwiki_p;
SELECT CONCAT('# [[WP:',page_title,']]') AS page_title
FROM... |
2 years ago |
| USE bnwiki_p;
SELECT CONCAT('# [[WP:',page_title,']]') AS page_title
FROM... |
2 years ago |
