Difference between revisions of "User talk:Mitja"

Latest revision as of 15:09, 19 October 2016

@@ Line 1: / Line 1: @@
-{{#arr:dataloop
+{{#title:pageid}}
-|{{#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') group by xc._multi_to,xt._multi_to order by xc._multi_to,xt._multi_to}}
-|each = <li>{{{country}}}, {{{category}}}, {{{cnt}}}
-}}