LISTE POUR : SWMRS

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

March

SWMRS
Music Box - San Diego San Diego San Diego, CA
Mar 28, 8:00 pm 2019
Thursday
Mar 28
8:00 pm
SWMRS
Music Box - San Diego, San Diego, CA
SELECT * from toolvenuepagelink WHERE venueid = 31751
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'
SWMRS
Vinyl at Hard Rock Hotel & Casino Las Vegas Las Vegas Las Vegas, NV
Mar 29, 8:00 pm 2019
Friday
Mar 29
8:00 pm
SWMRS
Vinyl at Hard Rock Hotel & Casino Las Vegas, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 3554
SELECT * from toolcitypagelink WHERE cityname = 'Albuquerque'
SWMRS
Sunshine Theatre Albuquerque Albuquerque, NM
Mar 30, 8:00 pm 2019
Saturday
Mar 30
8:00 pm
SWMRS
Sunshine Theatre, Albuquerque, NM
SELECT * from toolvenuepagelink WHERE venueid = 33807
SELECT * from toolcitypagelink WHERE cityname = 'Austin'

April

SWMRS
Barracuda Austin Austin, TX
Apr 1, 7:00 pm 2019
Monday
Apr 1
7:00 pm
SWMRS
Barracuda, Austin, TX
SELECT * from toolvenuepagelink WHERE venueid = 30770
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
SWMRS
Gas Monkey Bar N’ Grill Dallas Dallas, TX
Apr 2, 8:00 pm 2019
Tuesday
Apr 2
8:00 pm
SWMRS
Gas Monkey Bar N’ Grill, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 1972
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
SWMRS
Kennys Alley Atlanta Atlanta, GA
Apr 4, 7:00 pm 2019
Thursday
Apr 4
7:00 pm
SWMRS
Kennys Alley, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 4510
SELECT * from toolcitypagelink WHERE cityname = 'Charlotte'
SWMRS
Amos Southend Charlotte Charlotte, NC
Apr 5, 8:00 pm 2019
Friday
Apr 5
8:00 pm
SWMRS
Amos Southend, Charlotte, NC
SELECT * from toolvenuepagelink WHERE venueid = 4116
SELECT * from toolcitypagelink WHERE cityname = 'Pittsburgh'
SWMRS
Rex Theatre Pittsburgh Pittsburgh, PA
Apr 6, 8:00 pm 2019
Saturday
Apr 6
8:00 pm
SWMRS
Rex Theatre, Pittsburgh, PA
SELECT * from toolvenuepagelink WHERE venueid = 1959
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
SWMRS
9:30 Club Washington Washington, DC
Apr 7, 7:00 pm 2019
Sunday
Apr 7
7:00 pm
SWMRS
9:30 Club, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 856
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
SWMRS
Theatre of Living Arts Philadelphia Philadelphia, PA
Apr 9, 8:00 pm 2019
Tuesday
Apr 9
8:00 pm
SWMRS
Theatre of Living Arts, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 33405
SELECT * from toolcitypagelink WHERE cityname = 'Brooklyn'
SWMRS
Brooklyn Steel Brooklyn Brooklyn, NY
Apr 11, 7:00 pm 2019
Thursday
Apr 11
7:00 pm
SWMRS
Brooklyn Steel, Brooklyn, NY
SELECT * from toolvenuepagelink WHERE venueid = 2254
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
SWMRS
Paradise Rock Club Boston Boston, MA
Apr 12, 6:00 pm 2019
Friday
Apr 12
6:00 pm
SWMRS
Paradise Rock Club, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 5960
SELECT * from toolcitypagelink WHERE cityname = 'Syracuse'
SWMRS
Westcott Theatre Syracuse Syracuse, NY
Apr 13, 8:00 pm 2019
Saturday
Apr 13
8:00 pm
SWMRS
Westcott Theatre, Syracuse, NY
SELECT * from toolvenuepagelink WHERE venueid = 2885
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
SWMRS
Phoenix Concert Theatre Toronto Toronto, ON
Apr 14, 7:00 pm 2019
Sunday
Apr 14
7:00 pm
SWMRS
Phoenix Concert Theatre, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 905
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
SWMRS
Majestic Theatre Detroit Detroit Detroit, MI
Apr 16, 7:00 pm 2019
Tuesday
Apr 16
7:00 pm
SWMRS
Majestic Theatre Detroit, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 2759
SELECT * from toolcitypagelink WHERE cityname = 'Cincinnati'
SWMRS
20th Century Theater Cincinnati Cincinnati, OH
Apr 17, 8:00 pm 2019
Wednesday
Apr 17
8:00 pm
SWMRS
20th Century Theater, Cincinnati, OH
SELECT * from toolvenuepagelink WHERE venueid = 30272
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
SWMRS
Concord Music Hall Chicago Chicago, IL
Apr 19, 7:00 pm 2019
Friday
Apr 19
7:00 pm
SWMRS
Concord Music Hall, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 2283
SELECT * from toolcitypagelink WHERE cityname = 'Milwaukee'
SWMRS
Rave-Eagles Ballroom Milwaukee Milwaukee, WI
Apr 20, 7:00 pm 2019
Saturday
Apr 20
7:00 pm
SWMRS
Rave-Eagles Ballroom, Milwaukee, WI
SELECT * from toolvenuepagelink WHERE venueid = 19289
SELECT * from toolcitypagelink WHERE cityname = 'Indianapolis'
SWMRS
Deluxe at Old National Centre Indianapolis Indianapolis, IN
Apr 22, 7:30 pm 2019
Monday
Apr 22
7:30 pm
SWMRS
Deluxe at Old National Centre, Indianapolis, IN
SELECT * from toolvenuepagelink WHERE venueid = 30759
SELECT * from toolcitypagelink WHERE cityname = 'St. Louis'
SWMRS
The Ready Room St. Louis St. Louis, MO
Apr 23, 7:00 pm 2019
Tuesday
Apr 23
7:00 pm
SWMRS
The Ready Room, St. Louis, MO
SELECT * from toolvenuepagelink WHERE venueid = 2040
SELECT * from toolcitypagelink WHERE cityname = 'Englewood'
SWMRS
Gothic Theatre Englewood Englewood, CO
Apr 25, 8:00 pm 2019
Thursday
Apr 25
8:00 pm
SWMRS
Gothic Theatre, Englewood, CO
SELECT * from toolvenuepagelink WHERE venueid = 9539
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
SWMRS
The Complex Salt Lake City Salt Lake City, UT
Apr 27, 7:00 pm 2019
Saturday
Apr 27
7:00 pm
SWMRS
The Complex, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 4459
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
SWMRS
El Corazon Seattle Seattle, WA
Apr 29, 8:00 pm 2019
Monday
Apr 29
8:00 pm
SWMRS
El Corazon, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 4059
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
SWMRS
Wonder Ballroom Portland Portland, OR
Apr 30, 8:00 pm 2019
Tuesday
Apr 30
8:00 pm
SWMRS
Wonder Ballroom, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 30318
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'

May

SWMRS
Belasco Theatre - LA Los Angeles Los Angeles, CA
May 3, 7:00 pm 2019
Friday
May 3
7:00 pm
SWMRS
Belasco Theatre - LA, 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