LISTE POUR : Flogging Molly

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

February

Flogging Molly
Fox Theater at Foxwoods Resort Casino Mashantucket Mashantucket, CT
Feb 21, 7:30 pm 2019
Thursday
Feb 21
7:30 pm
Flogging Molly
Fox Theater at Foxwoods Resort Casino, Mashantucket, CT
SELECT * from toolvenuepagelink WHERE venueid = 6064
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Flogging Molly
House of Blues - Boston Boston Boston, MA
Feb 22, 8:00 pm 2019
Friday
Feb 22
8:00 pm
Flogging Molly
House of Blues - Boston, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 32474
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
Flogging Molly
The Fillmore Philadelphia Philadelphia Philadelphia, PA
Feb 23, 8:00 pm 2019
Saturday
Feb 23
8:00 pm
Flogging Molly
The Fillmore Philadelphia, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 7900
SELECT * from toolcitypagelink WHERE cityname = 'Silver Spring'
Flogging Molly
The Fillmore Silver Spring Silver Spring Silver Spring, MD
Feb 24, 7:00 pm 2019
Sunday
Feb 24
7:00 pm
Flogging Molly
The Fillmore Silver Spring, Silver Spring, MD
SELECT * from toolvenuepagelink WHERE venueid = 7963
SELECT * from toolcitypagelink WHERE cityname = 'Huntington'
Flogging Molly
The Paramount in Huntington Huntington Huntington, NY
Feb 26, 7:00 pm 2019
Tuesday
Feb 26
7:00 pm
Flogging Molly
The Paramount in Huntington, Huntington, NY
SELECT * from toolvenuepagelink WHERE venueid = 5814
SELECT * from toolcitypagelink WHERE cityname = 'Montclair'
Flogging Molly
Wellmont Theatre Montclair Montclair, NJ
Feb 28, 7:00 pm 2019
Thursday
Feb 28
7:00 pm
Flogging Molly
Wellmont Theatre, Montclair, NJ
SELECT * from toolvenuepagelink WHERE venueid = 2625
SELECT * from toolcitypagelink WHERE cityname = 'Jim Thorpe'

March

Flogging Molly
Penns Peak Jim Thorpe Jim Thorpe, PA
Mar 1, 8:00 pm 2019
Friday
Mar 1
8:00 pm
Flogging Molly
Penns Peak, Jim Thorpe, PA
SELECT * from toolvenuepagelink WHERE venueid = 4294
SELECT * from toolcitypagelink WHERE cityname = 'Rochester'
Flogging Molly
Main Street Armory Rochester Rochester, NY
Mar 2, 7:00 pm 2019
Saturday
Mar 2
7:00 pm
Flogging Molly
Main Street Armory, Rochester, NY
SELECT * from toolvenuepagelink WHERE venueid = 2992
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Flogging Molly with Lucero
Danforth Music Hall Toronto Toronto, ON
Mar 3, 6:30 pm 2019
Sunday
Mar 3
6:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 1857
SELECT * from toolcitypagelink WHERE cityname = 'Cincinnati'
Flogging Molly
Bogarts Cincinnati Cincinnati, OH
Mar 5, 8:00 pm 2019
Tuesday
Mar 5
8:00 pm
Flogging Molly
Bogarts, Cincinnati, OH
SELECT * from toolvenuepagelink WHERE venueid = 1927
SELECT * from toolcitypagelink WHERE cityname = 'Indianapolis'
Flogging Molly
Egyptian Room at Old National Centre Indianapolis Indianapolis, IN
Mar 7, 7:30 pm 2019
Thursday
Mar 7
7:30 pm
Flogging Molly
Egyptian Room at Old National Centre, Indianapolis, IN
SELECT * from toolvenuepagelink WHERE venueid = 1490
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
Flogging Molly
The Fillmore Detroit Detroit Detroit, MI
Mar 8, 7:00 pm 2019
Friday
Mar 8
7:00 pm
Flogging Molly
The Fillmore Detroit, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 56
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Flogging Molly
Aragon Ballroom Chicago Chicago, IL
Mar 9, 8:00 pm 2019
Saturday
Mar 9
8:00 pm
Flogging Molly
Aragon Ballroom, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 33347
SELECT * from toolcitypagelink WHERE cityname = 'St. Louis'
Flogging Molly
The Pageant St. Louis St. Louis, MO
Mar 10, 7:30 pm 2019
Sunday
Mar 10
7:30 pm
Flogging Molly
The Pageant, St. Louis, MO
SELECT * from toolvenuepagelink WHERE venueid = 3748
SELECT * from toolcitypagelink WHERE cityname = 'North Kansas City'
Flogging Molly
VooDoo Lounge Kansas City North Kansas City North Kansas City, MO
Mar 12, 7:30 pm 2019
Tuesday
Mar 12
7:30 pm
Flogging Molly
VooDoo Lounge Kansas City, North Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 9539
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
Flogging Molly
The Complex Salt Lake City Salt Lake City, UT
Mar 14, 8:00 pm 2019
Thursday
Mar 14
8:00 pm
Flogging Molly
The Complex, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 7733
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'
Flogging Molly
The Chelsea at the Cosmopolitan of Las Vegas Las Vegas Las Vegas, NV
Mar 15, 8:00 pm 2019
Friday
Mar 15
8:00 pm
Flogging Molly
The Chelsea at the Cosmopolitan of Las Vegas, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 3867
SELECT * from toolcitypagelink WHERE cityname = 'Cabazon'
Flogging Molly
Morongo Casino Resort and Spa Cabazon Cabazon, CA
Mar 16, 9:00 pm 2019
Saturday
Mar 16
9:00 pm
Flogging Molly
Morongo Casino Resort and Spa, Cabazon, CA
SELECT * from toolvenuepagelink WHERE venueid = 670
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Flogging Molly
Hollywood Palladium Los Angeles Los Angeles, CA
Mar 17, 6:00 pm 2019
Sunday
Mar 17
6:00 pm
Flogging Molly
Hollywood Palladium, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 2159
SELECT * from toolcitypagelink WHERE cityname = 'Santa Cruz'
Flogging Molly
The Catalyst - CA Santa Cruz Santa Cruz, CA
Mar 19, 8:00 pm 2019
Tuesday
Mar 19
8:00 pm
Flogging Molly
The Catalyst - CA, Santa Cruz, CA
SELECT * from toolvenuepagelink WHERE venueid = 2159
SELECT * from toolcitypagelink WHERE cityname = 'Santa Cruz'
Flogging Molly
The Catalyst - CA Santa Cruz Santa Cruz, CA
Mar 20, 7:00 pm 2019
Wednesday
Mar 20
7:00 pm
Flogging Molly
The Catalyst - CA, Santa Cruz, CA
SELECT * from toolvenuepagelink WHERE venueid = 3257
SELECT * from toolcitypagelink WHERE cityname = 'Reno'
Flogging Molly
Grand Sierra Theatre Reno Reno, NV
Mar 23, 8:00 pm 2019
Saturday
Mar 23
8:00 pm
Flogging Molly
Grand Sierra Theatre, Reno, NV
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football