View source for Live:Showcount

{{#cargo_query:
tables=Shows
| fields = CONCAT( '{{Float{{!}}right{{!}}{{((}}Iter{{))}}}}' ) = N°, CONCAT( '{{Float{{!}}right{{!}}[[', ShowPage, '|{{ShortDate{{!}}', COALESCE(Day,''), IF(Day<>'' AND Month<>'',' ',''), Month, ' ', Year, '}}]]}}') = Date, CONCAT( COALESCE(CONCAT('{{NoDisplay|', Province, '}}'), ''), COALESCE(CONCAT('{{NoDisplay|', State, '}}'), ''), City ) = City, Venue, CONCAT( '{{NoDisplay{{!}}', Country, '}}', '[[File:', Flag, '.png|x16px|border|', Country, ']]' ) = Country, CONCAT( '[[', Tour, ']]') = Tour, Event
| where = Artist="Linkin Park"
 AND Performers IS NULL
 AND ShowType IN ("album","awards","benefit","concert","festival","label","LPU","private","radio","sports","summit","TV","current","upcoming")
 AND (ShowType2 IS NULL OR ShowType2 IN ("album","awards","benefit","concert","festival","label","LPU","private","radio","sports","summit","TV","current","upcoming"))
 AND ShowType3 IS NULL
| order by = Shows.Date ASC
| format = dynamic table
| rows per page = 50
| column widths = 1.09em,3.5em,7em,10em,3.62em,7em,10em
}}