Difference between revisions of "User talk:Mitja"

From Culture.si
Line 1: Line 1:
{{#array:dump|
+
{ {#fetch:sql|SELECT * FROM page p LIMIT 20 OFFSET 0}}
{{#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
+
{{#var:set|timeline-year|}}
(0,9,11) ORDER BY rnk DESC, page_id DESC LIMIT 20 OFFSET 0}}
+
{{#ask: [[Category:Publishers]]  [[established::>{{{from|1750}}}]]
 +
|?Established
 +
|sort=Established
 +
|order=desc
 +
|format=template
 +
|intro = <div class="timeline">
 +
|outro = </div>
 +
|template=Timeline item
 
}}
 
}}
 +
{{#var:set|timeline-year|}}

Revision as of 22:26, 12 December 2012

{ {#fetch:sql|SELECT * FROM page p LIMIT 20 OFFSET 0}}


2,013
2,002
... further results