| SELECT site, COUNT(*) AS LINKS
FROM (SELECT SUBSTRING_INDEX(SUBSTRING(el_to,... |
2 years ago |
| SELECT site, COUNT(*) AS LINKS
FROM (SELECT SUBSTRING_INDEX(SUBSTRING(el_to,... |
2 years ago |
| SELECT site, COUNT(*) AS LINKS
FROM (SELECT SUBSTRING_INDEX(SUBSTRING(el_to,... |
2 years ago |
| SELECT site, COUNT(*) AS LINKS
FROM (SELECT SUBSTRING_INDEX(SUBSTRING(el_to,... |
2 years ago |
| SELECT site, COUNT(*) AS LINKS
FROM (SELECT SUBSTRING_INDEX(SUBSTRING(el_to,... |
2 years ago |
| SELECT site, COUNT(*) AS LINKS
FROM (SELECT SUBSTRING_INDEX(SUBSTRING(el_to,... |
2 years ago |
| SELECT
page_title,rev_timestamp
FROM
page,revision,actor
WHERE
... |
2 years ago |
| use fawiki_p;
select page_title
from page
where page_namespace = 0
and... |
2 years ago |
| SET @N = 750;
SET @today = mid(replace(now(),"-",""),5,4); /*
"0428";
--... |
2 years ago |
| USE orwiki_p;
SET @N = 750;
SET @today = mid(replace(now(),"-",""),5,4);... |
2 years ago |
| # Adapted from "replicating Xtools stuff in a normal query", 29 Dec... |
2 years ago |
| SELECT * FROM image
WHERE img_size < 50
ORDER BY img_size ASC
LIMIT... |
2 years ago |
| select log_title, deletions_count FROM (
SELECT count(*) as... |
2 years ago |
| #USE stop;
USE fawiki_p;
SELECT now() AS timestamp;
#empty links, no target... |
5 years ago |
| use fawiki_p;
select page_title
from page
where page_namespace = 0
and... |
5 years ago |
| use fawiki_p;
select page_title
from page
where page_namespace = 0
and... |
5 years ago |
| use fawiki_p;
select page_title
from page
where page_namespace = 0
and... |
5 years ago |
| use fawiki_p;
select page_title
from page
where page_namespace = 0
and... |
5 years ago |
| use fawiki_p;
SELECT CONCAT("# [[",p1.page_title,"]]") AS page_title
FROM... |
5 years ago |
| use fawiki_p;
SELECT CONCAT("# [[بحث:",p1.page_title,"]]") AS... |
5 years ago |
| use fawiki_p;
SELECT CONCAT("# [[بحث:",p1.page_title,"]]") AS... |
5 years ago |
| use fawiki_p;
SELECT CONCAT("# [[بحث:",p1.page_title,"]]") AS... |
5 years ago |
| use fawiki_p;
SELECT CONCAT("# [[بحث:",p1.page_title,"]]") AS... |
5 years ago |
