Difference between revisions of "User talk:Mitja"
From Culture.si
| Line 18: | Line 18: | ||
{{#arr:dataloop | {{#arr:dataloop | ||
| − | |{{#data:select|cnt=count(Event.#ref)|#limit= | + | |{{#data:select|cnt=count(Event.#ref)|#limit=1000}} |
| each = <li>Total: ({{{cnt}}}) | | each = <li>Total: ({{{cnt}}}) | ||
}} | }} | ||
| Line 24: | Line 24: | ||
=== Performers === | === Performers === | ||
| − | {{#data:sql|p=Event.Performer|cnt=count(*)|#groupby=1|#limit= | + | {{#data:sql|p=Event.Performer|cnt=count(*)|#groupby=1|#limit=1000}} |
{{#arr:dataloop | {{#arr:dataloop | ||
| − | |{{#data:select|p=Event.Performer|cnt=count(*)|#groupby=1|#limit= | + | |{{#data:select|p=Event.Performer|cnt=count(*)|#groupby=1|#limit=1000}} |
| each = <li>{{{p}}} ({{{cnt}}}) | | each = <li>{{{p}}} ({{{cnt}}}) | ||
}} | }} | ||
| Line 34: | Line 34: | ||
{{#arr:dataloop | {{#arr:dataloop | ||
| − | |{{#data:select|p=Event.Festival|cnt=count(*)|#groupby=1|#limit= | + | |{{#data:select|p=Event.Festival|cnt=count(*)|#groupby=1|#limit=1000}} |
| each = <li>{{{p}}} ({{{cnt}}}) | | each = <li>{{{p}}} ({{{cnt}}}) | ||
}} | }} | ||
| Line 41: | Line 41: | ||
{{#arr:dataloop | {{#arr:dataloop | ||
| − | |{{#data:select|p=Event.Years|cnt=count(*)|#groupby=1|#limit= | + | |{{#data:select|p=Event.Years|cnt=count(*)|#groupby=1|#limit=1000}} |
| each = <li>{{{p}}} ({{{cnt}}}) | | each = <li>{{{p}}} ({{{cnt}}}) | ||
}} | }} | ||
| Line 48: | Line 48: | ||
{{#arr:dataloop | {{#arr:dataloop | ||
| − | |{{#data:select|p=Event.Venue|cnt=count(*)|#groupby=1|#limit= | + | |{{#data:select|p=Event.Venue|cnt=count(*)|#groupby=1|#limit=1000}} |
| each = <li>{{{p}}} ({{{cnt}}}) | | each = <li>{{{p}}} ({{{cnt}}}) | ||
}} | }} | ||
| Line 55: | Line 55: | ||
{{#arr:dataloop | {{#arr:dataloop | ||
| − | |{{#data:select|p=Event.City|cnt=count(*)|#groupby=1|#limit= | + | |{{#data:select|p=Event.City|cnt=count(*)|#groupby=1|#limit=1000}} |
| each = <li>{{{p}}} ({{{cnt}}}) | | each = <li>{{{p}}} ({{{cnt}}}) | ||
}} | }} | ||
| Line 62: | Line 62: | ||
{{#arr:dataloop | {{#arr:dataloop | ||
| − | |{{#data:select|p=Event.Country|cnt=count(*)|#groupby=1|#limit= | + | |{{#data:select|p=Event.Country|cnt=count(*)|#groupby=1|#limit=1000}} |
| each = <li>{{{p}}} ({{{cnt}}}) | | each = <li>{{{p}}} ({{{cnt}}}) | ||
}} | }} | ||
Revision as of 01:29, 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
