| SELECT
CONCAT('# [[',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
2 years ago |
| SELECT distinct CONCAT('# [[:talk:',page_title,']]') AS page_title,... |
2 years ago |
| SELECT distinct CONCAT('# [[:File:',page_title,']]') AS page_title,... |
2 years ago |
| SELECT
page_namespace,
REPLACE(page_title,'_',' ') AS page_title,
... |
2 years ago |
| SELECT p2.page_namespace, p2.page_title, r2.rev_len, r2.rev_timestamp,... |
2 years ago |
| SELECT
page_namespace AS pns, page_title,
rd_namespace AS rdns,... |
2 years ago |
| SELECT concat("# [[টেমপ্লেট:",page_title,"]]") AS page_title
FROM... |
2 years ago |
| SELECT actor_name,count(rev_actor) as count from revision,comment,actor,page... |
2 years ago |
| SELECT actor_name as user,
COUNT(*) as cnt
FROM revision
JOIN change_tag
ON... |
2 years ago |
