LISTE POUR : YOB

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

March

YOB
Fine Line Music Cafe Minneapolis Minneapolis, MN
Mar 26, 8:00 pm 2019
Tuesday
Mar 26
8:00 pm
YOB
Fine Line Music Cafe, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 1551
SELECT * from toolcitypagelink WHERE cityname = 'Jackson'
YOB with Voivod
Thalia Mara Hall Jackson Jackson, MS
Mar 27, 8:00 pm 2019
Wednesday
Mar 27
8:00 pm
YOB with Voivod
Thalia Mara Hall, Jackson, MS
SELECT * from toolvenuepagelink WHERE venueid = 610
SELECT * from toolcitypagelink WHERE cityname = 'Cleveland'
YOB
Grog Shop Cleveland Cleveland, OH
Mar 29, 8:30 pm 2019
Friday
Mar 29
8:30 pm
YOB
Grog Shop, Cleveland, OH
SELECT * from toolvenuepagelink WHERE venueid = 2885
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
YOB with Voivod
Phoenix Concert Theatre Toronto Toronto, ON
Mar 30, 8:00 pm 2019
Saturday
Mar 30
8:00 pm
YOB with Voivod
Phoenix Concert Theatre, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 4492
SELECT * from toolcitypagelink WHERE cityname = 'Buffalo'
YOB with Voivod
Town Ballroom Buffalo Buffalo, NY
Mar 31, 7:00 pm 2019
Sunday
Mar 31
7:00 pm
YOB with Voivod
Town Ballroom, Buffalo, NY
SELECT * from toolvenuepagelink WHERE venueid = 3427
SELECT * from toolcitypagelink WHERE cityname = 'Boston'

April

YOB
Royale Boston Boston Boston, MA
Apr 3, 8:00 pm 2019
Wednesday
Apr 3
8:00 pm
YOB
Royale Boston, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 28442
SELECT * from toolcitypagelink WHERE cityname = 'Brooklyn'
YOB with Voivod
Warsaw Brooklyn Brooklyn, NY
Apr 4, 8:00 pm 2019
Thursday
Apr 4
8:00 pm
YOB with Voivod
Warsaw, Brooklyn, NY
SELECT * from toolvenuepagelink WHERE venueid = 7916
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
YOB
Union Transfer Philadelphia Philadelphia, PA
Apr 5, 8:00 pm 2019
Friday
Apr 5
8:00 pm
YOB
Union Transfer, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 31934
SELECT * from toolcitypagelink WHERE cityname = 'Richmond'
YOB with Voivod
The Broadberry Richmond Richmond, VA
Apr 6, 8:00 pm 2019
Saturday
Apr 6
8:00 pm
YOB with Voivod
The Broadberry, Richmond, VA
SELECT * from toolvenuepagelink WHERE venueid = 26753
SELECT * from toolcitypagelink WHERE cityname = 'Raleigh'
YOB with Voivod
Kings Barcade Raleigh Raleigh, NC
Apr 7, 7:00 pm 2019
Sunday
Apr 7
7:00 pm
YOB with Voivod
Kings Barcade, Raleigh, NC
SELECT * from toolvenuepagelink WHERE venueid = 31086
SELECT * from toolcitypagelink WHERE cityname = 'Beach Road'
YOB with Voivod
The Concourse Beach Road Beach Road, Si
Apr 9, 8:00 pm 2019
Tuesday
Apr 9
8:00 pm
YOB with Voivod
The Concourse, Beach Road, Si
SELECT * from toolvenuepagelink WHERE venueid = 33726
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
YOB with Voivod
The Masquerade Atlanta Atlanta, GA
Apr 10, 7:00 pm 2019
Wednesday
Apr 10
7:00 pm
YOB with Voivod
The Masquerade, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 3762
SELECT * from toolcitypagelink WHERE cityname = 'Houston'
YOB with Voivod
Warehouse Live Houston Houston, TX
Apr 12, 8:00 pm 2019
Friday
Apr 12
8:00 pm
YOB with Voivod
Warehouse Live, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 31921
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Voivod
Gas Monkey Live Dallas Dallas, TX
Apr 14, 8:00 pm 2019
Sunday
Apr 14
8:00 pm
Voivod
Gas Monkey Live, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 4497
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
YOB with Amenra
Marquis Theater Denver Denver, CO
Apr 16, 7:00 pm 2019
Tuesday
Apr 16
7:00 pm
YOB with Amenra
Marquis Theater, Denver, CO
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football