|
|
| (5 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| − | <!--
| + | {{#title:pageid}} |
| − | {{#arr:dataloop | |
| − | |{{#fetch:sql|SELECT page_id, page_namespace, page_title, old_text AS page_text, 3*ts_rank(textvector, to_tsquery('metka')) + ts_rank(textvector, to_tsquery('metka')) AS rnk, ts_headline(old_text, to_tsquery('metka')) as snippet 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('metka') OR titlevector @@ to_tsquery('metka')) AND page_is_redirect = '0' AND page_namespace IN
| |
| − | (0,6,14) ORDER BY rnk DESC, page_id DESC LIMIT 20 OFFSET 0}}
| |
| − | |each = <li>{{{page_title}}}, {{{rnk}}}<br><small>{{{snippet}}}</small>
| |
| − | }}
| |
| − | | |
| − | | |
| − | | |
| − | { {#arr:dataloop
| |
| − | |{{#fetch:sql|select xc._multi_to as country,xt._multi_to as category,count(*) as cnt from "tbl_Event" e,"tbl__Event__x__Tag" xt,"tbl__Event__x__Country" xc where xt._multi_from=e._row_ref and xc._multi_from=e._row_ref and (extract(year from e."Start")=2013 or extract(year from e."End")=2013) and xt._multi_to not in ('Top','Archives','Education','Embassies','Media','Support services','Maribor,_European_Capital_of_Culture_2012') group by xc._multi_to,xt._multi_to order by xc._multi_to,xt._multi_to}}
| |
| − | |each = <li>{{{country}}}, {{{category}}}, {{{cnt}}}
| |
| − | }}
| |
| − | | |
| − | -->
| |
| − | === All events ===
| |
| − | | |
| − | {{#arr:dataloop
| |
| − | |{{#data:select|cnt=count(Event.#ref)}}
| |
| − | | each = <li>Total: ({{{cnt}}})
| |
| − | }}
| |
| − | | |
| − | === Performers ===
| |
| − | | |
| − | {{#arr:dataloop
| |
| − | |{{#data:select|p=Event.Performer|cnt=count(*)|#groupby=1}}
| |
| − | | each = <li>{{{p}}} ({{{cnt}}})
| |
| − | }}
| |
| − | | |
| − | === Festivals ===
| |
| − | | |
| − | {{#arr:dataloop
| |
| − | |{{#data:select|p=Event.Festival|cnt=count(*)|#groupby=1}}
| |
| − | | each = <li>{{{p}}} ({{{cnt}}})
| |
| − | }}
| |
| − | | |
| − | === Years ===
| |
| − | | |
| − | {{#arr:dataloop
| |
| − | |{{#data:select|p=Event.Years|cnt=count(*)|#groupby=1}}
| |
| − | | each = <li>{{{p}}} ({{{cnt}}})
| |
| − | }}
| |
| − | | |
| − | === Venues ===
| |
| − | | |
| − | {{#arr:dataloop
| |
| − | |{{#data:select|p=Event.Venue|cnt=count(*)|#groupby=1}}
| |
| − | | each = <li>{{{p}}} ({{{cnt}}})
| |
| − | }}
| |
| − | | |
| − | === Cities ===
| |
| − | | |
| − | {{#arr:dataloop
| |
| − | |{{#data:select|p=Event.City|cnt=count(*)|#groupby=1}}
| |
| − | | each = <li>{{{p}}} ({{{cnt}}})
| |
| − | }}
| |
| − | | |
| − | === Countries ===
| |
| − | | |
| − | {{#arr:dataloop
| |
| − | |{{#data:select|p=Event.Country|cnt=count(*)|#groupby=1}}
| |
| − | | each = <li>{{{p}}} ({{{cnt}}})
| |
| − | }} | |
