LISTE POUR : Conan Gray

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

March

Conan Gray
House of Blues - Dallas Dallas Dallas, TX
Mar 21, 8:00 pm 2019
Thursday
Mar 21
8:00 pm
Conan Gray
House of Blues - Dallas, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 5679
SELECT * from toolcitypagelink WHERE cityname = 'Houston'
Conan Gray
House of Blues - Houston Houston Houston, TX
Mar 22, 7:00 pm 2019
Friday
Mar 22
7:00 pm
Conan Gray
House of Blues - Houston, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 28994
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
Conan Gray
Terminal West Atlanta Atlanta, GA
Mar 24, 8:00 pm 2019
Sunday
Mar 24
8:00 pm
Conan Gray
Terminal West, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 1822
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Conan Gray
Bowery Ballroom New York New York, NY
Mar 27, 7:00 pm 2019
Wednesday
Mar 27
7:00 pm
Conan Gray
Bowery Ballroom, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 4853
SELECT * from toolcitypagelink WHERE cityname = 'Brooklyn'
Conan Gray
Music Hall of Williamsburg Brooklyn Brooklyn, NY
Mar 28, 8:00 pm 2019
Thursday
Mar 28
8:00 pm
Conan Gray
Music Hall of Williamsburg, Brooklyn, NY
SELECT * from toolvenuepagelink WHERE venueid = 27958
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Conan Gray
U Street Music Hall Washington Washington, DC
Mar 29, 7:00 pm 2019
Friday
Mar 29
7:00 pm
Conan Gray
U Street Music Hall, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 32703
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Conan Gray
The Foundry - TX Dallas Dallas, TX
Mar 30, 8:00 pm 2019
Saturday
Mar 30
8:00 pm
Conan Gray
The Foundry - TX, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 31549
SELECT * from toolcitypagelink WHERE cityname = 'Cambridge'

April

Conan Gray
The Sinclair Cambridge Cambridge, MA
Apr 2, 8:00 pm 2019
Tuesday
Apr 2
8:00 pm
Conan Gray
The Sinclair, Cambridge, MA
SELECT * from toolvenuepagelink WHERE venueid = 18120
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Conan Gray
L'Astral Montreal Montreal, QC
Apr 4, 8:00 pm 2019
Thursday
Apr 4
8:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 3142
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Conan Gray
Mod Club Theatre Toronto Toronto, ON
Apr 5, 7:00 pm 2019
Friday
Apr 5
7:00 pm
Conan Gray
Mod Club Theatre, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 33195
SELECT * from toolcitypagelink WHERE cityname = 'Ferndale'
Conan Gray
The Loving Touch Ferndale Ferndale, MI
Apr 6, 7:00 pm 2019
Saturday
Apr 6
7:00 pm
Conan Gray
The Loving Touch, Ferndale, MI
SELECT * from toolvenuepagelink WHERE venueid = 5471
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Conan Gray
Bottom Lounge Chicago Chicago, IL
Apr 8, 7:30 pm 2019
Monday
Apr 8
7:30 pm
Conan Gray
Bottom Lounge, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 493
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
Conan Gray
Fine Line Music Cafe Minneapolis Minneapolis, MN
Apr 9, 7:30 pm 2019
Tuesday
Apr 9
7:30 pm
Conan Gray
Fine Line Music Cafe, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 6040
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Conan Gray
Riot Room Kansas City Kansas City, MO
Apr 10, 8:00 pm 2019
Wednesday
Apr 10
8:00 pm
Conan Gray
Riot Room, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 159
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
Conan Gray
Bluebird Theater Denver Denver, CO
Apr 12, 8:00 pm 2019
Friday
Apr 12
8:00 pm
Conan Gray
Bluebird Theater, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 5375
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
Conan Gray
Kilby Court Salt Lake City Salt Lake City, UT
Apr 13, 7:00 pm 2019
Saturday
Apr 13
7:00 pm
Conan Gray
Kilby Court, Salt Lake City, UT
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football