-- |
2 years ago |
SELECT CONCAT('# [[টেমপ্লেট আলোচনা:',page_title,']]') AS page_title,... |
2 years ago |
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,']]')
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 |
--
SET @ns = 1; # Talk namespace number to search
SET @prefix = ''; #... |
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... |
2 years ago |
-- |
2 years ago |
SELECT actor_name,count(rev_actor) as count from revision,comment,actor,page... |
2 years ago |
SELECT
CONCAT("#") AS number,... |
2 years ago |
-- |
2 years ago |
USE bnwiki_p;
SELECT CONCAT("# [[User:",page_title,"]]") AS page_title
FROM... |
2 years ago |
USE bnwiki_p;
SELECT CONCAT("# [[User:",page_title,"]]") FROM page
WHERE... |
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,']]') AS page_title, CONCAT('←... |
2 years ago |
SELECT CONCAT('# [[আলাপ:',page_title,']]') AS page_title, CONCAT('←... |
2 years ago |
USE bnwiki_p;
SELECT CONCAT('# [[',page_title,']]') AS page_title,... |
2 years ago |
USE bnwiki_p;
SELECT CONCAT('# [[',page_title,']]') AS page_title,... |
2 years ago |
USE bnwiki_p;
SELECT CONCAT('# [[',page_title,']]') AS page_title,... |
2 years ago |
USE bnwiki_p;
SELECT CONCAT('# [[',page_title,']]') AS page_title,... |
2 years ago |
USE bnwiki_p;
SELECT CONCAT('# [[',page_title,']]') AS page_title,... |
2 years ago |
USE bnwiki_p;
SELECT CONCAT('# [[',page_title,']]') AS page_title,... |
2 years ago |
USE bnwiki_p;
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,"]]") AS page_title
FROM... |
2 years ago |
SELECT concat("# [[টেমপ্লেট:",page_title,"]]") AS page_title
FROM... |
3 years ago |
select * from page where page_len = 0; |
3 years ago |