Difference between revisions of "User talk:Mitja"
From Culture.si
(Created page with '{{Address book category test|category=Architecture}}') |
|||
| Line 1: | Line 1: | ||
| − | {{ | + | {{#array:dump| |
| + | {{#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}} | ||
| + | }} | ||
Revision as of 20:41, 12 December 2012
array ( 'vars' => array ( ), )
