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

January

State Champs
The Republik Honolulu Honolulu, HI
Jan 25, 8:00 pm 2019
Friday
Jan 25
8:00 pm
State Champs
The Republik, Honolulu, HI
SELECT * from toolvenuepagelink WHERE venueid = 680
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'

March

State Champs
House of Blues - Chicago Chicago Chicago, IL
Mar 1, 6:30 pm 2019
Friday
Mar 1
6:30 pm
State Champs
House of Blues - Chicago, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 1490
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
State Champs with Our Last Night
The Fillmore Detroit Detroit Detroit, MI
Mar 2, 6:00 pm 2019
Saturday
Mar 2
6:00 pm
State Champs with Our Last Night
The Fillmore Detroit, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 2885
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
State Champs
Phoenix Concert Theatre Toronto Toronto, ON
Mar 3, 7:00 pm 2019
Sunday
Mar 3
7:00 pm
State Champs
Phoenix Concert Theatre, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 19289
SELECT * from toolcitypagelink WHERE cityname = 'Indianapolis'
State Champs
Deluxe at Old National Centre Indianapolis Indianapolis, IN
Mar 5, 8:00 pm 2019
Tuesday
Mar 5
8:00 pm
State Champs
Deluxe at Old National Centre, Indianapolis, IN
SELECT * from toolvenuepagelink WHERE venueid = 3266
SELECT * from toolcitypagelink WHERE cityname = 'Cleveland'
State Champs
House of Blues - Cleveland Cleveland Cleveland, OH
Mar 6, 6:00 pm 2019
Wednesday
Mar 6
6:00 pm
State Champs
House of Blues - Cleveland, Cleveland, OH
SELECT * from toolvenuepagelink WHERE venueid = 3649
SELECT * from toolcitypagelink WHERE cityname = 'New York'
State Champs
Playstation Theater New York New York, NY
Mar 8, 7:00 pm 2019
Friday
Mar 8
7:00 pm
State Champs
Playstation Theater, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 6064
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
State Champs
House of Blues - Boston Boston Boston, MA
Mar 9, 6:00 pm 2019
Saturday
Mar 9
6:00 pm
State Champs
House of Blues - Boston, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 856
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
State Champs
Theatre of Living Arts Philadelphia Philadelphia, PA
Mar 10, 6:45 pm 2019
Sunday
Mar 10
6:45 pm
State Champs
Theatre of Living Arts, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 16006
SELECT * from toolcitypagelink WHERE cityname = 'Baltimore'
State Champs
Baltimore Soundstage Baltimore Baltimore, MD
Mar 12, 6:45 pm 2019
Tuesday
Mar 12
6:45 pm
State Champs
Baltimore Soundstage, Baltimore, MD
SELECT * from toolvenuepagelink WHERE venueid = 27741
SELECT * from toolcitypagelink WHERE cityname = 'Mesa'
State Champs with Our Last Night
The Underground Mesa Mesa, AZ
Mar 13, 6:45 pm 2019
Wednesday
Mar 13
6:45 pm
State Champs with Our Last Night
The Underground, Mesa, AZ
SELECT * from toolvenuepagelink WHERE venueid = 681
SELECT * from toolcitypagelink WHERE cityname = 'Orlando'
State Champs
House of Blues - Orlando Orlando Orlando, FL
Mar 14, 6:00 pm 2019
Thursday
Mar 14
6:00 pm
State Champs
House of Blues - Orlando, Orlando, FL
SELECT * from toolvenuepagelink WHERE venueid = 1972
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
State Champs
Kennys Alley Atlanta Atlanta, GA
Mar 15, 6:00 pm 2019
Friday
Mar 15
6:00 pm
State Champs
Kennys Alley, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 30531
SELECT * from toolcitypagelink WHERE cityname = 'Louisville'
State Champs with Our Last Night
Mercury Ballroom Louisville Louisville, KY
Mar 16, 7:00 pm 2019
Saturday
Mar 16
7:00 pm
State Champs with Our Last Night
Mercury Ballroom, Louisville, KY
SELECT * from toolvenuepagelink WHERE venueid = 7810
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
State Champs
Summit Music Hall Denver Denver, CO
Mar 18, 6:00 pm 2019
Monday
Mar 18
6:00 pm
State Champs
Summit Music Hall, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 3946
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
State Champs
The Depot Salt Lake City Salt Lake City, UT
Mar 19, 6:00 pm 2019
Tuesday
Mar 19
6:00 pm
State Champs
The Depot, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 1419
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
State Champs
The Showbox Seattle Seattle, WA
Mar 21, 8:00 pm 2019
Thursday
Mar 21
8:00 pm
State Champs
The Showbox, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 4829
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
State Champs
Hawthorne Theatre Portland Portland, OR
Mar 22, 6:45 pm 2019
Friday
Mar 22
6:45 pm
State Champs
Hawthorne Theatre, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 9556
SELECT * from toolcitypagelink WHERE cityname = 'Sacramento'
State Champs
Ace of Spades Sacramento Sacramento, CA
Mar 23, 6:00 pm 2019
Saturday
Mar 23
6:00 pm
State Champs
Ace of Spades, Sacramento, CA
SELECT * from toolvenuepagelink WHERE venueid = 2074
SELECT * from toolcitypagelink WHERE cityname = 'Anaheim'
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