LISTE POUR : LANY

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

April

Lany
Fillmore Miami Beach at Jackie Gleason Theater Miami Beach Miami Beach, FL
Apr 23, 8:00 pm 2019
Tuesday
Apr 23
8:00 pm
Lany
Fillmore Miami Beach at Jackie Gleason Theater, Miami Beach, FL
SELECT * from toolvenuepagelink WHERE venueid = 681
SELECT * from toolcitypagelink WHERE cityname = 'Orlando'
Lany
House of Blues - Orlando Orlando Orlando, FL
Apr 24, 8:00 pm 2019
Wednesday
Apr 24
8:00 pm
Lany
House of Blues - Orlando, Orlando, FL
SELECT * from toolvenuepagelink WHERE venueid = 30220
SELECT * from toolcitypagelink WHERE cityname = 'Birmingham'
Lany
Iron City - Birmingham Birmingham Birmingham, AL
Apr 26, 8:00 pm 2019
Friday
Apr 26
8:00 pm
Lany
Iron City - Birmingham, Birmingham, AL
SELECT * from toolvenuepagelink WHERE venueid = 31640
SELECT * from toolcitypagelink WHERE cityname = 'Columbia'
Lany
The Senate Columbia Columbia, SC
Apr 27, 7:30 pm 2019
Saturday
Apr 27
7:30 pm
Lany
The Senate, Columbia, SC
SELECT * from toolvenuepagelink WHERE venueid = 1366
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
LANY
Ryman Auditorium Nashville Nashville, TN
Apr 28, 7:30 pm 2019
Sunday
Apr 28
7:30 pm
LANY
Ryman Auditorium, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 33347
SELECT * from toolcitypagelink WHERE cityname = 'St. Louis'
Lany
The Pageant St. Louis St. Louis, MO
Apr 30, 8:00 pm 2019
Tuesday
Apr 30
8:00 pm
Lany
The Pageant, St. Louis, MO
SELECT * from toolvenuepagelink WHERE venueid = 1005
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'

May

Lany
Arvest Bank Theatre at The Midland Kansas City Kansas City, MO
May 1, 8:00 pm 2019
Wednesday
May 1
8:00 pm
Lany
Arvest Bank Theatre at The Midland, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 33839
SELECT * from toolcitypagelink WHERE cityname = 'Madison'
Lany
The Sylvee Madison Madison, WI
May 3, 8:00 pm 2019
Friday
May 3
8:00 pm
Lany
The Sylvee, Madison, WI
SELECT * from toolvenuepagelink WHERE venueid = 33343
SELECT * from toolcitypagelink WHERE cityname = 'Milwaukee'
Lany
The Rave/Eagles Club Milwaukee Milwaukee, WI
May 4, 8:00 pm 2019
Saturday
May 4
8:00 pm
Lany
The Rave/Eagles Club, Milwaukee, WI
SELECT * from toolvenuepagelink WHERE venueid = 1857
SELECT * from toolcitypagelink WHERE cityname = 'Cincinnati'
Lany
Bogarts Cincinnati Cincinnati, OH
May 6, 7:00 pm 2019
Monday
May 6
7:00 pm
Lany
Bogarts, Cincinnati, OH
SELECT * from toolvenuepagelink WHERE venueid = 938
SELECT * from toolcitypagelink WHERE cityname = 'Cleveland'
Lany
Masonic Auditorium Cleveland Cleveland, OH
May 7, 8:00 pm 2019
Tuesday
May 7
8:00 pm
Lany
Masonic Auditorium, Cleveland, OH
SELECT * from toolvenuepagelink WHERE venueid = 1490
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
Lany
The Fillmore Detroit Detroit Detroit, MI
May 8, 7:00 pm 2019
Wednesday
May 8
7:00 pm
Lany
The Fillmore Detroit, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 6064
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Lany
House of Blues - Boston Boston Boston, MA
May 10, 8:00 pm 2019
Friday
May 10
8:00 pm
Lany
House of Blues - Boston, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 6064
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Lany
House of Blues - Boston Boston Boston, MA
May 11, 7:00 pm 2019
Saturday
May 11
7:00 pm
Lany
House of Blues - Boston, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 7725
SELECT * from toolcitypagelink WHERE cityname = 'Pittsburgh'
Lany
Stage AE Pittsburgh Pittsburgh, PA
May 13, 7:00 pm 2019
Monday
May 13
7:00 pm
Lany
Stage AE, Pittsburgh, PA
SELECT * from toolvenuepagelink WHERE venueid = 1959
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Lany
9:30 Club Washington Washington, DC
May 15, 7:00 pm 2019
Wednesday
May 15
7:00 pm
Lany
9:30 Club, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 1959
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Lany
9:30 Club Washington Washington, DC
May 16, 7:00 pm 2019
Thursday
May 16
7:00 pm
Lany
9:30 Club, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 625
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Lany
Hammerstein Ballroom New York New York, NY
May 17, 8:00 pm 2019
Friday
May 17
8:00 pm
Lany
Hammerstein Ballroom, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 32474
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
Lany
The Fillmore Philadelphia Philadelphia Philadelphia, PA
May 20, 8:00 pm 2019
Monday
May 20
8:00 pm
Lany
The Fillmore Philadelphia, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 18146
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Lany
Rebel Toronto Toronto, ON
May 21, 8:00 pm 2019
Tuesday
May 21
8:00 pm
Lany
Rebel, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 18146
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
LANY
Rebel Toronto Toronto, ON
May 22, 7:00 pm 2019
Wednesday
May 22
7:00 pm
LANY
Rebel, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 18123
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Lany
Corona Theatre Montreal Montreal, QC
May 23, 8:00 pm 2019
Thursday
May 23
8:00 pm
Lany
Corona Theatre, Montreal, QC
SELECT * from toolvenuepagelink WHERE venueid = 2056
SELECT * from toolcitypagelink WHERE cityname = 'Columbus'
Lany
Express Live Columbus Columbus, OH
May 28, 7:00 pm 2019
Tuesday
May 28
7:00 pm
Lany
Express Live, Columbus, OH
SELECT * from toolvenuepagelink WHERE venueid = 1927
SELECT * from toolcitypagelink WHERE cityname = 'Indianapolis'
Lany
Egyptian Room at Old National Centre Indianapolis Indianapolis, IN
May 29, 8:00 pm 2019
Wednesday
May 29
8:00 pm
Lany
Egyptian Room at Old National Centre, Indianapolis, IN
SELECT * from toolvenuepagelink WHERE venueid = 2232
SELECT * from toolcitypagelink WHERE cityname = 'Norfolk'
Lany
The Norva Norfolk Norfolk, VA
May 31, 8:00 pm 2019
Friday
May 31
8:00 pm
Lany
The Norva, Norfolk, VA
SELECT * from toolvenuepagelink WHERE venueid = 3555
SELECT * from toolcitypagelink WHERE cityname = 'Raleigh'

June

LANY
The Ritz Raleigh Raleigh, NC
Jun 1, 8:00 pm 2019
Saturday
Jun 1
8:00 pm
LANY
The Ritz, Raleigh, NC
SELECT * from toolvenuepagelink WHERE venueid = 33488
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
Lany
Coca-Cola Roxy Theater Atlanta Atlanta, GA
Jun 2, 8:00 pm 2019
Sunday
Jun 2
8:00 pm
Lany
Coca-Cola Roxy Theater, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 27821
SELECT * from toolcitypagelink WHERE cityname = 'New Orleans'
Lany
The Joy Theater New Orleans New Orleans, LA
Jun 4, 8:00 pm 2019
Tuesday
Jun 4
8:00 pm
Lany
The Joy Theater, New Orleans, LA
SELECT * from toolvenuepagelink WHERE venueid = 30567
SELECT * from toolcitypagelink WHERE cityname = 'San Antonio'
Lany
Aztec Theater San Antonio San Antonio, TX
Jun 6, 7:00 pm 2019
Thursday
Jun 6
7:00 pm
Lany
Aztec Theater, San Antonio, TX
SELECT * from toolvenuepagelink WHERE venueid = 2156
SELECT * from toolcitypagelink WHERE cityname = 'Houston'
Lany
Revention Music Center Houston Houston, TX
Jun 7, 8:00 pm 2019
Friday
Jun 7
8:00 pm
Lany
Revention Music Center, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 8118
SELECT * from toolcitypagelink WHERE cityname = 'Austin'
Lany
Stubbs BBQ Austin Austin, TX
Jun 8, 7:00 pm 2019
Saturday
Jun 8
7:00 pm
Lany
Stubbs BBQ, Austin, TX
SELECT * from toolvenuepagelink WHERE venueid = 2050
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
Lany
Fillmore Auditorium Denver Denver, CO
Jun 10, 7:30 pm 2019
Monday
Jun 10
7:30 pm
Lany
Fillmore Auditorium, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 1957
SELECT * from toolcitypagelink WHERE cityname = 'Magna'
Lany
The Great Saltair Magna Magna, UT
Jun 11, 8:00 pm 2019
Tuesday
Jun 11
8:00 pm
Lany
The Great Saltair, Magna, UT
SELECT * from toolvenuepagelink WHERE venueid = 29474
SELECT * from toolcitypagelink WHERE cityname = 'Garden City'
Lany
Revolution Concert House and Event Center Garden City Garden City, ID
Jun 12, 8:00 pm 2019
Wednesday
Jun 12
8:00 pm
Lany
Revolution Concert House and Event Center, Garden City, ID
SELECT * from toolvenuepagelink WHERE venueid = 2497
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
Lany
The Masonic San Francisco San Francisco, CA
Jun 14, 7:00 pm 2019
Friday
Jun 14
7:00 pm
Lany
The Masonic, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 2497
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
LANY
The Masonic San Francisco San Francisco, CA
Jun 15, 8:00 pm 2019
Saturday
Jun 15
8:00 pm
LANY
The Masonic, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 938
SELECT * from toolcitypagelink WHERE cityname = 'Cleveland'
LANY
Masonic Auditorium Cleveland Cleveland, OH
Jun 15, 8:00 pm 2019
Saturday
Jun 15
8:00 pm
LANY
Masonic Auditorium, Cleveland, OH
SELECT * from toolvenuepagelink WHERE venueid = 1272
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
LANY
Queen Elizabeth Theatre - Vancouver Vancouver Vancouver, BC
Jun 17, 7:30 pm 2019
Monday
Jun 17
7:30 pm
LANY
Queen Elizabeth Theatre - Vancouver, Vancouver, BC
SELECT * from toolvenuepagelink WHERE venueid = 3015
SELECT * from toolcitypagelink WHERE cityname = 'Spokane'
Lany
Knitting Factory Concert House Spokane Spokane, WA
Jun 18, 8:00 pm 2019
Tuesday
Jun 18
8:00 pm
Lany
Knitting Factory Concert House, Spokane, WA
SELECT * from toolvenuepagelink WHERE venueid = 1987
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
LANY
Keller Auditorium Portland Portland, OR
Jun 19, 7:30 pm 2019
Wednesday
Jun 19
7:30 pm
LANY
Keller Auditorium, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 5085
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Lany
Showbox SoDo Seattle Seattle, WA
Jun 21, 8:00 pm 2019
Friday
Jun 21
8:00 pm
Lany
Showbox SoDo, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 5085
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Lany
Showbox SoDo Seattle Seattle, WA
Jun 22, 8:00 pm 2019
Saturday
Jun 22
8:00 pm
Lany
Showbox SoDo, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 2074
SELECT * from toolcitypagelink WHERE cityname = 'Anaheim'
Lany
House of Blues - Anaheim Anaheim Anaheim, CA
Jun 25, 7:00 pm 2019
Tuesday
Jun 25
7:00 pm
Lany
House of Blues - Anaheim, Anaheim, CA
SELECT * from toolvenuepagelink WHERE venueid = 603
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Lany
Greek Theatre - Los Angeles Los Angeles Los Angeles, CA
Jun 27, 7:00 pm 2019
Thursday
Jun 27
7:00 pm
Lany
Greek Theatre - Los Angeles, Los Angeles, CA
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football