List:Rammstein performances with support act Raging Speedhorn
More actions
Function: CargoSQLQuery::run Query: SELECT `Shows`.`_pageID` AS `cargo_backlink_page_id_Shows`,CONCAT( '{{Float|right|{{Iter}}}}' ) AS `N°`,CONCAT( '<div style="display: none;">', Month, '</div>{{Float|right|{{ShortDate|', COALESCE(Day,), IF(Day<> AND Month<>,' ',), Month, ' ', Year, '}}}}') AS `Date`,CONCAT( COALESCE(Venue,), IF(Venue<> AND Event<>,' / ',), COALESCE(Event,)) AS `Venue / Event`,`City` AS `City`,CONCAT( '<div style="display: none;">', Country, '</div>', '', Country, '' ) AS `Country`,CONCAT( '', Tour, '') AS `Tour` FROM `cargo__Shows` `Shows` WHERE Artist= "Rammstein" AND ShowType IN ("upcoming","current","concert","private","TV","label","fanclub","performance") AND Support HOLDS "Raging Speedhorn" ORDER BY `Shows`.`Date`,`Shows`.`ShowCount` LIMIT 5000
