LISTE POUR : State Champs

SELECT tbproductions.*, ttvenues.city,ttvenues.state, CONCAT(ttvenues.city,', ',ttvenues.state) as Region FROM tbproductions,ttvenues , tevoEventPerformers WHERE tbEventsID = 35238 AND tevoEventPerformers.performerId = 35238 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 = 2074
SELECT * from toolcitypagelink WHERE cityname = 'Anaheim'

March

State Champs with Our Last Night
House of Blues - Anaheim Anaheim Anaheim, CA
Mar 24, 6:00 pm 2019
Sunday
Mar 24
6:00 pm
State Champs with Our Last Night
House of Blues - Anaheim, Anaheim, CA
SELECT * from toolvenuepagelink WHERE venueid = 33533
SELECT * from toolcitypagelink WHERE cityname = 'Phoenix'
State Champs
The Van Buren Phoenix Phoenix, AZ
Mar 26, 6:45 pm 2019
Tuesday
Mar 26
6:45 pm
State Champs
The Van Buren, Phoenix, AZ
SELECT * from toolvenuepagelink WHERE venueid = 26602
SELECT * from toolcitypagelink WHERE cityname = 'Austin'
State Champs
Scoot Inn Austin Austin, TX
Mar 28, 5:00 pm 2019
Thursday
Mar 28
5:00 pm
State Champs
Scoot Inn, Austin, TX
SELECT * from toolvenuepagelink WHERE venueid = 2329
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
State Champs
Granada Theater - TX Dallas Dallas, TX
Mar 29, 7:00 pm 2019
Friday
Mar 29
7:00 pm
State Champs
Granada Theater - TX, Dallas, TX
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football