Template:Infobox tour: Difference between revisions

From SPCodex, The Smashing Pumpkins wiki
No edit summary
No edit summary
Line 35: Line 35:
tables=shows
tables=shows
|fields=COUNT(DISTINCT location)
|fields=COUNT(DISTINCT location)
|where=shows.artist = "{{{artist}}}" AND shows.tour = "{{{name}}}"
}}</includeonly>
| label17        = No. of countries
| data17        = <includeonly>{{#cargo_query:
tables=shows
|fields=COUNT(DISTINCT country)
|where=shows.artist = "{{{artist}}}" AND shows.tour = "{{{name}}}"
|where=shows.artist = "{{{artist}}}" AND shows.tour = "{{{name}}}"
}}</includeonly>
}}</includeonly>

Revision as of 03:41, 21 September 2020

Infobox tour tour
Tour by [[]]
Start date{{#var:start_date}}
End date{{#var:end_date}}