| SELECT actor_name as user,
COUNT(*) as cnt
FROM revision
JOIN change_tag
ON... |
2 years ago |
| -- |
2 years ago |
| SELECT CONCAT('# [[আলাপ:',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
2 years ago |
| -- |
2 years ago |
| SELECT CONCAT('# [[',page_title,']]') as page_title
FROM page
LEFT JOIN... |
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 |
| (
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 |
| (
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 actor_name, count(log_actor)
from logging
join actor on... |
2 years ago |
| -- |
2 years ago |
| SELECT CONCAT count(log_actor)
from logging
join actor on (logging.log_actor... |
2 years ago |
| SELECT actor_name, count(log_actor)
from logging
join actor on... |
2 years ago |
| SELECT CONCAT
count(log_actor)
from logging
join... |
2 years ago |
| SELECT count(log_actor)
from logging
join actor on (logging.log_actor =... |
2 years ago |
| -- |
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 concat("#[[আলাপ:",page_title,"]]"),
actor_name
from revision
join... |
2 years ago |
| SELECT CONCAT('# [[বিষয়শ্রেণী আলোচনা:',page_title,']]')
FROM page
LEFT JOIN... |
2 years ago |
| SELECT CONCAT('# [[টেমপ্লেট আলোচনা:',page_title,']]')
FROM page
LEFT JOIN... |
2 years ago |
| SELECT CONCAT('# [[উইকিপিডিয়া আলোচনা:',page_title,']]')
FROM page
LEFT JOIN... |
2 years ago |
| -- |
2 years ago |
| SELECT CONCAT('# [[আলাপ:',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
2 years ago |
| -- |
2 years ago |
| SELECT actor_name as user,
COUNT(*) as cnt
FROM revision
JOIN change_tag
ON... |
2 years ago |
| SELECT actor_name as user,
COUNT(*) as cnt
FROM revision
JOIN change_tag
ON... |
2 years ago |
| SELECT actor_name as user,
COUNT(*) as cnt
FROM revision
JOIN change_tag
ON... |
2 years ago |
| SELECT actor_name as user,
COUNT(*) as cnt
FROM revision
JOIN change_tag
ON... |
2 years ago |
| SELECT actor_name as user,
COUNT(*) as cnt
FROM revision
JOIN change_tag
ON... |
2 years ago |
| -- |
2 years ago |
| SELECT actor_name as user,
COUNT(*) as cnt
FROM revision
JOIN change_tag
ON... |
2 years ago |
| SELECT actor_name as user,
COUNT(*) as cnt
FROM revision
JOIN change_tag
ON... |
2 years ago |
| -- |
2 years ago |
| SELECT CONCAT('# [[আলাপ:',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
2 years ago |
| -- |
2 years ago |
| SELECT distinct CONCAT('# [[:আলাপ:',page_title,']]') AS page_title,... |
2 years ago |
| SELECT distinct CONCAT('# [[:আলাপ:',page_title,']]') AS page_title,... |
2 years ago |
| -- |
2 years ago |
| SELECT CONCAT('# [[',page_title,']]') AS page_title,... |
2 years ago |
| SELECT CONCAT('# [[',page_title,']]') AS page_title,... |
2 years ago |
| USE bnwiki_p;
SELECT CONCAT('# [[',page_title,']]') AS page_title,... |
2 years ago |
| SELECT
CONCAT('# [[',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
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 |
| select concat("#[[আলাপ:",page_title,"]]"),
actor_name
from revision
join... |
2 years ago |
| select concat("#[[আলাপ:",page_title,"]]"),
actor_name
from revision
join... |
2 years ago |
| -- |
2 years ago |
| USE bnwiki_p;
SELECT
page_namespace,... |
2 years ago |
| -- |
2 years ago |
| USE bnwiki_p;
SELECT CONCAT('# [[ব্যবহারকারী:',page_title,']]') as... |
2 years ago |
| -- |
2 years ago |
| SELECT CONCAT('# [[আলাপ:',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
2 years ago |
| -- |
2 years ago |
| SELECT CONCAT('# [[আলাপ:',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
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 concat("#[[আলাপ:",page_title,"]]"),
actor_name
from revision
join... |
2 years ago |
| -- |
2 years ago |
| SELECT CONCAT('# [[আলাপ:',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
2 years ago |
| -- |
2 years ago |
| SELECT CONCAT('# [[আলাপ:',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
2 years ago |
| -- |
2 years ago |
| SELECT CONCAT('# [[আলাপ:',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
2 years ago |
| -- |
2 years ago |
| SELECT CONCAT('# [[আলাপ:',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
2 years ago |
| -- |
2 years ago |
| SELECT actor_name, count(log_actor)
from logging
join actor on... |
2 years ago |
| -- |
2 years ago |
| SELECT CONCAT('# [[আলাপ:',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
2 years ago |
| -- |
2 years ago |
| SELECT CONCAT('# [[আলাপ:',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
2 years ago |
| SELECT CONCAT('# [[আলাপ:',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
2 years ago |
| SELECT CONCAT('# [[টেমপ্লেট আলোচনা:',page_title,']]')
FROM page
LEFT JOIN... |
2 years ago |
| SELECT CONCAT('# [[উইকিপিডিয়া আলোচনা:',page_title,']]')
FROM page
LEFT JOIN... |
2 years ago |
| SELECT CONCAT('# [[চিত্র আলোচনা:',page_title,']]')
FROM page
LEFT JOIN... |
2 years ago |
| -- |
2 years ago |
| -- |
2 years ago |
| SELECT CONCAT('# [[আলাপ:',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
2 years ago |
| -- |
2 years ago |
| SELECT CONCAT('# [[আলাপ:',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
2 years ago |
| -- |
2 years ago |
| SELECT CONCAT('# [[আলাপ:',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
2 years ago |
| -- |
2 years ago |
| SELECT actor_name, count(log_actor)
from logging
join actor on... |
2 years ago |
| select concat("#[[আলাপ:",page_title,"]]"),
actor_name
from revision
join... |
2 years ago |
| select concat("#[[আলাপ:",page_title,"]]"),
actor_name
from revision
join... |
2 years ago |
| SELECT CONCAT('# [[আলাপ:',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
2 years ago |
| -- |
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 |
| 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 |
| 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 CONCAT('# [[আলাপ:',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
2 years ago |
| SELECT CONCAT('# [[আলাপ:',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
2 years ago |
| SELECT CONCAT('# [[আলাপ:',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
2 years ago |
| -- |
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('# [[',page_title,']]') AS page_title,... |
2 years ago |
| SELECT
CONCAT('# [[',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
2 years ago |
| USE bnwiki_p;
SELECT CONCAT("# [[User:",page_title,"]]") FROM page
WHERE... |
2 years ago |
| USE bnwiki_p;
SELECT CONCAT("# [[User:",page_title,"]]") FROM page
WHERE... |
2 years ago |
| -- |
2 years ago |
| SELECT CONCAT('# [[আলাপ:',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
2 years ago |
| SELECT CONCAT('# [[আলাপ:',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
2 years ago |
| -- |
2 years ago |
| SELECT CONCAT('# [[আলাপ:',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
2 years ago |
| -- |
2 years ago |
| use bnwiki_p;
select concat("#[[আলাপ:",page_title,"]]"),
actor_name
from... |
2 years ago |
| SELECT CONCAT('# [[আলাপ:',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
2 years ago |
