LISTE POUR : Bastille

SELECT tbproductions.*, ttvenues.city,ttvenues.state, CONCAT(ttvenues.city,', ',ttvenues.state) as Region FROM tbproductions,ttvenues , tevoEventPerformers WHERE tbEventsID = 40035 AND tevoEventPerformers.performerId = 40035 AND tevoEventPerformers.isPrimary = 1 AND tbproductions.tbVenuesID = ttvenues.id AND tbproductions.tbVenuesID = ttvenues.id AND tevoEventPerformers.eventId = tbproductions.ID ORDER BY tbproductions.Eventdate
DATES
ÉVÉNEMENT
SELECT * from toolvenuepagelink WHERE venueid = 31661
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'

April

Bastille
Doug Mitchell Thunderbird Sports Centre Vancouver Vancouver, BC
Apr 27, 7:30 pm 2017
Thursday
Apr 27
7:30 pm
Bastille
Doug Mitchell Thunderbird Sports Centre, Vancouver, BC
SELECT * from toolvenuepagelink WHERE venueid = 2162
SELECT * from toolcitypagelink WHERE cityname = 'Boise'
Bastille
Taco Bell Arena Boise Boise, ID
Apr 29, 7:00 pm 2017
Saturday
Apr 29
7:00 pm
Bastille
Taco Bell Arena, Boise, ID
SELECT * from toolvenuepagelink WHERE venueid = 2910
SELECT * from toolcitypagelink WHERE cityname = 'Bozeman'
Bastille
Brick Breeden Fieldhouse Bozeman Bozeman, Mt
Apr 30, 7:00 pm 2017
Sunday
Apr 30
7:00 pm
Bastille
Brick Breeden Fieldhouse, Bozeman, Mt
SELECT * from toolvenuepagelink WHERE venueid = 1162
SELECT * from toolcitypagelink WHERE cityname = 'Omaha'

May

Bastille
Orpheum Theatre - Omaha Omaha Omaha, NE
May 2, 7:30 pm 2017
Tuesday
May 2
7:30 pm
Bastille
Orpheum Theatre - Omaha, Omaha, NE
SELECT * from toolvenuepagelink WHERE venueid = 3036
SELECT * from toolcitypagelink WHERE cityname = 'Clive'
Bastille
7 Flags Event Center Clive Clive, IA
May 3, 7:00 pm 2017
Wednesday
May 3
7:00 pm
Bastille
7 Flags Event Center, Clive, IA
SELECT * from toolvenuepagelink WHERE venueid = 32385
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
Bastille
Ascend Amphitheater Nashville Nashville, TN
May 5, 7:00 pm 2017
Friday
May 5
7:00 pm
Bastille
Ascend Amphitheater, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 8847
SELECT * from toolcitypagelink WHERE cityname = 'Charlotte'
Bastille
Charlotte Metro Credit Union Amphitheatre Charlotte Charlotte, NC
May 6, 7:30 pm 2017
Saturday
May 6
7:30 pm
Bastille
Charlotte Metro Credit Union Amphitheatre, Charlotte, NC
SELECT * from toolvenuepagelink WHERE venueid = 5369
SELECT * from toolcitypagelink WHERE cityname = 'St Augustine'
Bastille
St Augustine Amphitheatre St Augustine St Augustine, FL
May 7, 7:00 pm 2017
Sunday
May 7
7:00 pm
Bastille
St Augustine Amphitheatre, St Augustine, FL
SELECT * from toolvenuepagelink WHERE venueid = 2716
SELECT * from toolcitypagelink WHERE cityname = 'Orlando'
Bastille
Central Florida Fairgrounds Orlando Orlando, FL
May 9, 8:00 pm 2017
Tuesday
May 9
8:00 pm
Bastille
Central Florida Fairgrounds, Orlando, FL
SELECT * from toolvenuepagelink WHERE venueid = 475
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
Bastille
Fox Theatre Atlanta Atlanta Atlanta, GA
May 10, 8:00 pm 2017
Wednesday
May 10
8:00 pm
Bastille
Fox Theatre Atlanta, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 7333
SELECT * from toolcitypagelink WHERE cityname = 'Raleigh'
Bastille
Red Hat Amphitheatre (Formerly Raleigh Amphitheatre) Raleigh Raleigh, NC
May 12, 7:00 pm 2017
Friday
May 12
7:00 pm
Bastille
Red Hat Amphitheatre (Formerly Raleigh Amphitheatre), Raleigh, NC
Billets Coldplay
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football