Difference between revisions of "User talk:Mitja"
Line 62: | Line 62: | ||
{{#arr:dataloop | {{#arr:dataloop | ||
− | |{{#data:select|p=Event.Country|cnt=count(*)|#groupby=1 | + | |{{#data:select|p=Event.Country|cnt=count(*)|#groupby=1}} |
| each = <li>{{{p}}} ({{{cnt}}}) | | each = <li>{{{p}}} ({{{cnt}}}) | ||
}} | }} |
Revision as of 01:30, 25 February 2016
All events
Performers
SELECT DISTINCT (__Event__x__Performer._multi_to) AS "P", (count(*)) AS "Cnt" FROM "tbl_Event" AS __Event LEFT JOIN "tbl__Event__x__Performer" AS __Event__x__Performer ON (__Event._row_ref = __Event__x__Performer._multi_from) GROUP BY 1 LIMIT 1000 OFFSET 0