User:Mitja

Number of events related

{{#data:grid |Count = count(distinct Event.#) |Article=Event.Related |#groupby = Event.Related |#where = Event.Years.Year IS NOT NULL AND COALESCE(Event.Status,)= and (Event.Years='Year_2013') and (Event.Related!=Event.Country) and (Event.Related!=Event.City) and (Event.Related!=Event.Venue) |#limit = 1000 |#orderby = count(distinct Event.#) DESC }} {{#data:grid |Count = count(distinct Event.#) |Article=Event.Related |#groupby = Event.Related |#where = Event.Years.Year IS NOT NULL AND COALESCE(Event.Status,)= and (Event.Years='Year_2013') and (Event.Related!=Event.Country) and (Event.Related!=Event.City) and (Event.Related!=Event.Venue) |#limit = 1000 |#offset = 1001 |#orderby = count(distinct Event.#) DESC }} {{#data:grid |Count = count(distinct Event.#) |Article=Event.Related |#groupby = Event.Related |#where = Event.Years.Year IS NOT NULL AND COALESCE(Event.Status,)= and (Event.Years='Year_2013') and (Event.Related!=Event.Country) and (Event.Related!=Event.City) and (Event.Related!=Event.Venue) |#limit = 1000 |#offset = 2001 |#orderby = count(distinct Event.#) DESC }}