Difference between revisions of "User talk:Mitja"

Latest revision as of 15:09, 19 October 2016

@@ Line 1: / Line 1: @@
-{{#array:dump|
+{{#title:pageid}}
-{{#fetch:sql|SELECT page_id, page_namespace, page_title, old_text AS page_text, ts_rank(titlevector, to_tsquery('default','postgres')) AS rnk FROM page p, revision r,
-pagecontent c WHERE p.page_latest = r.rev_id AND r.rev_text_id = c.old_id AND textvector @@ to_tsquery('default','postgres') AND page_is_redirect = '0' AND page_namespace IN
-(0,9,11) ORDER BY rnk DESC, page_id DESC LIMIT 20 OFFSET 0}}
-}}