| SELECT
s.page_namespace AS subject_ns,
t.page_namespace AS talk_ns,
... |
3 years ago |
| SELECT page_id, page_namespace, page_title FROM `page`,`searchindex`
WHERE... |
3 years ago |
| SELECT page_id, page_namespace, page_title FROM `page`,`searchindex`
WHERE... |
3 years ago |
| USE bnwiki_p;
SELECT actor_name,rc_title, rc_timestamp FROM recentchanges AS... |
3 years ago |
| SELECT DISTINCT p.page_title #a.img_name
FROM image a
INNER JOIN image b ON... |
3 years ago |
| -- |
3 years ago |
| SELECT concat("#[[:বিষয়শ্রেণী:",page_title,"]]")
FROM (SELECT page_title
... |
3 years ago |
| SELECT concat("#[[:বিষয়শ্রেণী:",page_title,"]]")
FROM (SELECT page_title
... |
3 years ago |
| show tables |
3 years ago |
| show |
3 years ago |
| use bnwiki_p;
select CONCAT ('* [[', p.page_title, ']]'), p.page_len
FROM... |
3 years ago |
| use bnwiki_p;
select CONCAT ('* [[', p.page_title, ']]'), p.page_len
FROM... |
3 years ago |
| show tables |
3 years ago |
| SELECT actor_name, count(log_actor)
from logging
join actor on... |
3 years ago |
| -- comment |
3 years ago |
| use bnwiki_p;
SELECT concat("* [[:চিত্র:",REPLACE(page_title, '_', '... |
3 years ago |
| USE bnwiki_p;
SELECT distinct CONCAT('# [[:আলাপ:',page_title,']]') AS... |
3 years ago |
| use bnwiki_p;
SELECT CONCAT("[[",page_title,"|",page_title,"]]") AS... |
3 years ago |
| -- |
3 years ago |
| select concat("#[[আলাপ:",page_title,"]]"),
actor_name
from revision
join... |
3 years ago |
| use bnwiki_p;
select concat("#[[আলাপ:",page_title,"]]"),
actor_name
from... |
3 years ago |
| select concat("#[[আলাপ:",page_title,"]]"),
actor_name
from revision
join... |
3 years ago |
| -- comment |
3 years ago |
| use bnwiki_p;
select concat("#[[আলাপ:",page_title,"]]"),
actor_name
from... |
3 years ago |
| -- comment |
3 years ago |
| SELECT actor_name, count(log_actor)
from logging
join actor on... |
3 years ago |
| SELECT CONCAT( '# [[', @prefix, 'বিষয়শ্রেণী আলোচনা:', pg.page_title, ']]')... |
3 years ago |
| SELECT CONCAT( '# [[', @prefix, 'আলাপ:', pg.page_title, ']]') AS 'Title'... |
3 years ago |
| USE bnwiki_p;
SELECT CONCAT("# [[User:",page_title,"]]") FROM page
WHERE... |
3 years ago |
| use bnwiki_p;
select concat("#[[:টেমপ্লেট আলোচনা:",page_title,"]]")
from... |
3 years ago |
| use bnwiki_p;
select concat("#[[:বিষয়শ্রেণী আলোচনা:",page_title,"]]")
from... |
3 years ago |
| SELECT concat("#[[:বিষয়শ্রেণী:",page_title,"]]")
FROM (SELECT page_title
... |
3 years ago |
| SELECT concat("#[[:বিষয়শ্রেণী:",page_title,"]]")
FROM (SELECT page_title
... |
3 years ago |
