صارف:Obaid Raza/کیوری
کوڈ
ترمیمUSE urwiki_p;
SET @row_number = 0;
SELECT (@row_number:=@row_number + 1) AS num, CONCAT("|[[",page_title,"]]") AS page_title, CONCAT("|[[",pl_title,"]]") AS pl_title
FROM pagelinks, page
WHERE pl_title NOT LIKE '%(%)%'
AND pl_title NOT LIKE '%:)%'
AND pl_title NOT LIKE '%:-)%'
AND pl_title NOT LIKE '%)))%'
AND pl_title NOT LIKE '%Pre)Thing%'
AND pl_from = page_id
AND pl_from_namespace = 0
AND pl_namespace = 0
AND (pl_title LIKE '%)%)%' OR pl_title LIKE '%(%(%' OR pl_title LIKE '%(%' OR pl_title LIKE '%)%')
GROUP BY pl_title
ORDER BY /*page_len ASC,*/ pl_title ASC, page_title ASC;
نتائج
ترمیمکوڈ
ترمیمUSE urwiki_p;
SELECT p.page_id FROM page p
JOIN redirect r ON r.rd_from = p.page_id
WHERE p.page_namespace = 0
AND r.rd_namespace NOT IN (0, #Article
14, # Category
10, # Template
4, # Wikipedia
5, # Wikipedia talk - see Wikipedia:Redirects for discussion/Log/2012 July 16#Rules to consider/Confer in e-mail debate
12, # Help
100) # Portal
یہ ویکی ڈیٹا پر موجود صفحہ کا رمز ہے۔
- 3091
- 120252
- 355469
- 358156
- 358157
- 361685
- 3414
- 57753
- 177882
- 3569
- 97323
- 169414
- 342200
- 346157
- 262585
- 265257
- 93637
- 345207
- 345208
- 358294
کوڈ
ترمیمUSE urwiki_p;
SELECT CONCAT('# [[',page_title,']]') as page_title
FROM page
JOIN externallinks
ON page_id = el_from
WHERE page_namespace = 0
AND (el_to LIKE 'http://ar.wikipedia.org/wiki/%'
OR el_to LIKE 'https://ar.wikipedia.org/wiki/%')
GROUP BY page_title
ORDER BY page_title;
SELECT CONCAT('# ',el_to) as el_to#, COUNT(*) AS counting
FROM page
JOIN externallinks
ON page_id = el_from
WHERE page_namespace = 0
AND (el_to LIKE 'http://ar.wikipedia.org/wiki/%'
OR el_to LIKE 'https://ar.wikipedia.org/wiki/%')
GROUP BY el_to
ORDER BY /*counting DESC,*/ el_to;
- ابو العاص بن ربیع
- اربعین
- بایزید بسطامی
- بہاء الدین عاملی
- جعفر الصادق
- حبیب النجار
- دفعہ
- سٹوپا
- عبدالعلیم سلفی
- فراغ
- یوشع بن نون