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 = 17
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'

March

Bastille
Air Canada Centre Toronto Toronto, ON
Mar 24, 7:30 pm 2017
Friday
Mar 24
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 1036
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Bastille
Bell Centre Montreal Montreal, QC
Mar 26, 7:30 pm 2017
Sunday
Mar 26
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 3238
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Bastille
Agganis Arena Boston Boston, MA
Mar 27, 8:00 pm 2017
Monday
Mar 27
8:00 pm
Bastille
Agganis Arena, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 1205
SELECT * from toolcitypagelink WHERE cityname = 'Fairfax'
Bastille
Eaglebank Arena Fairfax Fairfax, VA
Mar 28, 8:00 pm 2017
Tuesday
Mar 28
8:00 pm
Bastille
Eaglebank Arena, Fairfax, VA
SELECT * from toolvenuepagelink WHERE venueid = 27950
SELECT * from toolcitypagelink WHERE cityname = 'Brooklyn'
Bastille
Barclays Center Brooklyn Brooklyn, NY
Mar 30, 8:00 pm 2017
Thursday
Mar 30
8:00 pm
Bastille
Barclays Center, Brooklyn, NY
SELECT * from toolvenuepagelink WHERE venueid = 2061
SELECT * from toolcitypagelink WHERE cityname = 'Uncasville'
Bastille
Mohegan Sun Arena Uncasville Uncasville, CT
Mar 31, 7:30 pm 2017
Friday
Mar 31
7:30 pm
Bastille
Mohegan Sun Arena, Uncasville, CT
SELECT * from toolvenuepagelink WHERE venueid = 446
SELECT * from toolcitypagelink WHERE cityname = 'West Lafayette'

April

Bastille
Elliott Hall of Music West Lafayette West Lafayette, IN
Apr 2, 7:00 pm 2017
Sunday
Apr 2
7:00 pm
Bastille
Elliott Hall of Music, West Lafayette, IN
SELECT * from toolvenuepagelink WHERE venueid = 56
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Bastille
Aragon Ballroom Chicago Chicago, IL
Apr 3, 7:30 pm 2017
Monday
Apr 3
7:30 pm
Bastille
Aragon Ballroom, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 29847
SELECT * from toolcitypagelink WHERE cityname = 'Peoria'
Bastille
Renaissance Coliseum Peoria Peoria, IL
Apr 4, 8:30 pm 2017
Tuesday
Apr 4
8:30 pm
Bastille
Renaissance Coliseum, Peoria, IL
SELECT * from toolvenuepagelink WHERE venueid = 33353
SELECT * from toolcitypagelink WHERE cityname = 'Sugar Land'
Bastille
Smart Financial Centre Sugar Land Sugar Land, TX
Apr 6, 7:30 pm 2017
Thursday
Apr 6
7:30 pm
Bastille
Smart Financial Centre, Sugar Land, TX
SELECT * from toolvenuepagelink WHERE venueid = 29952
SELECT * from toolcitypagelink WHERE cityname = 'New Orleans'
Bastille
Champions Square New Orleans New Orleans, LA
Apr 7, 7:30 pm 2017
Friday
Apr 7
7:30 pm
Bastille
Champions Square, New Orleans, LA
SELECT * from toolvenuepagelink WHERE venueid = 2119
SELECT * from toolcitypagelink WHERE cityname = 'Grand Prairie'
Bastille
Verizon Theatre at Grand Prairie Grand Prairie Grand Prairie, TX
Apr 9, 8:00 pm 2017
Sunday
Apr 9
8:00 pm
Bastille
Verizon Theatre at Grand Prairie, Grand Prairie, TX
SELECT * from toolvenuepagelink WHERE venueid = 7648
SELECT * from toolcitypagelink WHERE cityname = 'Phoenix'
Bastille
Comerica Theatre Phoenix Phoenix, AZ
Apr 11, 7:30 pm 2017
Tuesday
Apr 11
7:30 pm
Bastille
Comerica Theatre, Phoenix, AZ
SELECT * from toolvenuepagelink WHERE venueid = 2206
SELECT * from toolcitypagelink WHERE cityname = 'Orem'
Bastille
UCCU Center Orem Orem, UT
Apr 13, 8:00 pm 2017
Thursday
Apr 13
8:00 pm
Bastille
UCCU Center, Orem, UT
SELECT * from toolvenuepagelink WHERE venueid = 7733
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'
Bastille
The Chelsea at the Cosmopolitan of Las Vegas Las Vegas Las Vegas, NV
Apr 14, 7:00 pm 2017
Friday
Apr 14
7:00 pm
Bastille
The Chelsea at the Cosmopolitan of Las Vegas, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 5835
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Bastille
The Novo by Microsoft Los Angeles Los Angeles, CA
Apr 19, 9:00 pm 2017
Wednesday
Apr 19
9:00 pm
Bastille
The Novo by Microsoft, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 1785
SELECT * from toolcitypagelink WHERE cityname = 'Berkeley'
Bastille
Greek Theatre - Berkeley Berkeley Berkeley, CA
Apr 23, 7:00 pm 2017
Sunday
Apr 23
7:00 pm
Bastille
Greek Theatre - Berkeley, Berkeley, CA
SELECT * from toolvenuepagelink WHERE venueid = 1987
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Bastille
Keller Auditorium Portland Portland, OR
Apr 25, 8:00 pm 2017
Tuesday
Apr 25
8:00 pm
Bastille
Keller Auditorium, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 4291
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Bastille
WaMu Theater Seattle Seattle, WA
Apr 26, 8:00 pm 2017
Wednesday
Apr 26
8:00 pm
Bastille
WaMu Theater, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 31661
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
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