1993 Tour Info

Deprecated: Non-static method Configure::read() should not be called statically, assuming $this from incompatible context in /home/distortion/revision/cake/libs/view/view.php on line 661

1993 - 131 shows played
Date:	Location:	Venue:

01.26	London, UK	Camden Underworld	Info
01.27	Frankfurt, Germany	Batschkapp	Info
01.28	Hamburg, Germany	Markthalle	Info
01.31	Copenhagen, Denmark	Pumpehuset	Info

02.01	Oslo, Norway	Rockefeller	Info
02.02	Stockholm, Sweden	Unknown	Info
02.04	Berlin, Germany	The Loft	Info
02.05	Amsterdam, The Netherlands	The Word	Info
02.06	Brussels, Belgium	V.K.	Info
02.07	Amsterdam, The Netherlands	Melkwag	Info
02.08	Paris, France	Elysee Montmartre	Info
02.10	Cologne, Germany	Club Luxor	Info
02.11	Zurich, Switzerland	Electric Ballroom	Info
02.12	Munich, Germany	Terminal 1	Info
02.13	Milan, Italy	Zimba	Info
02.16	Birmingham, UK	Edwards 8	Info
02.17	Nottingham, UK	Rock City	Info
02.18	London, UK	Astoria	Info
02.19	London , UK	ULU	Info
02.21	Glasgow, UK	King Tuts Wah-Wah Hut	Info
02.22	Newcastle, UK	Riverside	Info
02.23	Newcastle, UK	The Riverside	Info

04.13	San Francisco, CA	Unknown	Info
04.14	Santa Barbara, CA	The Anaconda Theater	Info
04.15	Las Vegas, NV	Huntridge Theater	Info
04.19	Santa Clara, CA	One Step Beyond	Info
04.21	Berkeley, CA	Berkeley Square	Info
04.23	Hollywood, CA	Scientology Garden Pavilion	Info
04.24	Hollywood, CA	Scientology Garden Pavilion	Info
04.26	Anaheim, CA	California Dreams	Info

05.06	Hollywood, CA	The Palladium	Info
05.07	Hollywood, CA	The Palladium	Info
05.21	Liverpool, UK	Royal Court	Info
05.22	Nottingham, UK	Rock City	Info
05.24	Glasgow, UK	Barrowlands	Info
05.25	Manchester, UK	The Ritz	Info
05.26	London, UK	Town and Country Club	Info
05.27	Newcastle, UK	Newcastle Mayfair	Info
05.28	London, UK	Brixton Academy	Info
05.31	Landgraaf, The Netherlands	Pink Pop Festival	Info

06.01	Munich, Germany	Unknown	Info
06.02	Dusseldorf, Germany	Tor 3	Info
06.04	Amsterdam, The Netherlands	Paradiso	Info
06.05	Hamburg, Germany	GoBang Festival	Info
06.06	Dienze, France	Brielport	Info
06.07	Paris, France	Le Zenith	Info
06.09	Zurich, Switzerland	Volkshaus	Info
06.10	Milan, Italy	Milan City Square	Info
06.11	Geneve, Switzerland	Palladium	Info
06.12	Reykjavik, Iceland	Reykjavik Festival	Info
06.17	Vancouver, British Columbia	Thunderbird Stadium	Info
06.18	Vancouver, British Columbia	Thunderbird Stadium	Info
06.19	George, WA	The Gorge	Info
06.20	Portland, OR	Portland Meadows	Info
06.22	Mountain View, CA	Shoreline Amphitheater	Info
06.23	Mountain View, CA	Shoreline Amphitheater	Info
06.25	Ogden, UT	Weber County Fairgrounds	Info
06.26	Denver, CO	Fiddler's Green	Info
06.28	Des Moines, IA	Iowa State Fairgrounds	Info
06.29	St. Paul, MN	Harriet Island	Info

07.01	Maryland Heights, MO	Riverport Amphitheater	Info
07.02	Tinley Park, IL	World Music Amphitheater	Info
07.03	Tinley Park, IL	World Music Amphitheater	Info
07.05	Noblesville, IN	Deer Creek Amphitheater	Info
07.06	Antioch, TN	Starwood Amphitheater	Info
07.08	Thornville, OH	Buckeye Lake Music Theater	Info
07.09	Milan, MI	Milan Dragway	Info
07.10	Barrie, Ontario	Molson Park	Info
07.12	Stanhope, NJ	Waterloo Village	Info
07.13	Stanhope, NJ	Waterloo Village	Info
07.16	Stanhope, NJ	Waterloo Village	Info
07.17	North Kingstown, RI	Quonset State Airport	Info
07.18	Philadelphia, PA	JFK Stadium	Info
07.20	Charlestown, WV	Shenandoah Downs	Info
07.21	Pittsburgh, PA	Starlake Amphitheater	Info
07.23	Raleigh, NC	Walnut Creek Amphitheater	Info
07.24	Charlotte, NC	Metrolina Expo	Info
07.25	Atlanta, GA	Lakewood Amphitheater	Info
07.27	Miami, FL	Bicentennial Park	Info
07.28	Orlando, FL	Central Florida Fairgrounds	Info
07.30	New Orleans, LA	UNO Soccer Field	Info
07.31	Houston, TX	Houston Raceway Park	Info

08.01	Dallas, TX	Starplex Amphitheater	Info
08.04	Chandler, AZ	Compton Terrace	Info
08.06	Irwindale, CA	Santa Fe Dam	Info
08.07	Irwindale, CA	Santa Fe Dam	Info
08.15	Kuuloa Ranch, HI	Big Mele Music Festival	Info
08.24	Dublin, UK	Tivolt	Info
08.25	Belfast , UK	Ulster Hall	Info
08.27	Reading, UK	Reading Festival Grounds	Info
08.28	Hasselt, Belgium	Pukkelpop Festival	Info
08.29	Dronten, The Netherlands	Lowlands Festival	Info
08.31	Stockholm, Sweden	Palladium	Info

09.01	Oslo, Norway	Sentrum Scene	Info
09.02	Copenhagen, Denmark	Grey Hall	Info
09.03	Aarhus, Denmark	Aarhus Festival	Info
09.05	Bremen, Germany	Aladin Music Hall	Info
09.06	Offenbach, Germany	Stadthalle	Info
09.07	Munich, Germany	Terminal 1	Info
09.09	Paris, France	Elysee Montmartre	Info
09.10	Paris, France	Elysee Montmartre	Info
09.11	Hengelo, The Netherlands	Metropol	Info
09.12	Den Bosch, The Netherlands	Popwerk Festival Ground	Info
09.21	Marseille, France	Le Moulin	Info
09.22	Montpellier, France	Salle Victori	Info
09.23	Toulouse , France	Le Bikini	Info
09.25	La Rochelle, France	Parc Expo	Info
09.28	Nantes, France	L'escall	Info
09.29	Rennes, France	La Cit	Info
09.30	Caen, France	Le Zenith	Info

10.01	Poitiers, France	Le Confort Moderne	Info
10.05	Lyon, France	Le Transbordeur	Info
10.06	Grenoble, France	Le Summum	Info
10.07	Bescanson, France	Montjoye	Info
10.08	Nancy, France	Espace Seichamps	Info
10.09	St. Quentin, France	Salle Bienfait	Info
10.12	Birmingham, UK	Birmingham Institute	Info
10.13	Nottingham, UK	Rock City	Info
10.14	Liverpool, UK	Cray House	Info
10.15	Lyon, France	Le Transbordeur	Info
10.16	Newcastle, UK	Riverside	Info
10.17	Glasgow, UK	Cathouse	Info
10.18	Manchester, UK	Manchester University	Info
10.19	Bradford, UK	Queens Hall	Info
10.20	Bristol, UK	Bierkeller	Info
10.21	London, UK	Camden Underworld	Info
10.22	London, UK	Astoria	Info

12.09	Phoenix, AZ	The Grind	Info
12.10	Las Vegas, NV	Huntridge Theater	Info
12.11	Santa Ana, CA	Rhythm Caf	Info
12.12	San Francisco, CA	Trocadero Transfer	Info

(default) 15 queries took 466 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `do_setlists`	6	6	4
2	DESCRIBE `do_songs`	4	4	66
3	DESCRIBE `do_shows`	7	7	1
4	DESCRIBE `do_venues`	7	7	15
5	DESCRIBE `do_tours`	4	4	120
6	DESCRIBE `do_bands`	3	3	115
7	DESCRIBE `do_photos`	7	7	26
8	DESCRIBE `do_integrations`	4	4	1
9	DESCRIBE `do_menus`	5	5	1
10	DESCRIBE `do_news`	5	5	2
11	SELECT month(date) as month, day(date) as day, `Show`., `Venue`. FROM `do_shows` AS `Show` LEFT JOIN `do_venues` AS `Venue` ON (`Show`.`venue_id` = `Venue`.`id`) WHERE year(date) = '1993' ORDER BY month(date), day(date) ASC	131	131	111
12	SELECT count(*) AS count FROM `do_shows` AS `Show` LEFT JOIN `do_venues` AS `Venue` ON (`Show`.`venue_id` = `Venue`.`id`) WHERE year(date) = '1993' GROUP BY cancellationStatus	1	1	1
13	SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`name`, `Menu`.`h_link`, `Menu`.`type` FROM `do_menus` AS `Menu` WHERE 1 = 1 ORDER BY `id` ASC	40	40	1
14	SELECT year(newsTime) as year, month(newsTime) as month, count(*) as count FROM `do_news` AS `News` WHERE 1 = 1 GROUP BY month, year ORDER BY `year` DESC, `month` DESC	31	31	1
15	SELECT year(date) as year, count(*) as count FROM `do_shows` AS `Shows` WHERE 1 = 1 GROUP BY year(date)	13	13	1

(default) 15 queries took 466 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `do_setlists`

DESCRIBE `do_songs`

DESCRIBE `do_shows`

DESCRIBE `do_venues`

DESCRIBE `do_tours`

120

DESCRIBE `do_bands`

115

DESCRIBE `do_photos`

DESCRIBE `do_integrations`

DESCRIBE `do_menus`

DESCRIBE `do_news`

SELECT month(date) as month, day(date) as day, `Show`.*, `Venue`.* FROM `do_shows` AS `Show` LEFT JOIN `do_venues` AS `Venue` ON (`Show`.`venue_id` = `Venue`.`id`) WHERE year(date) = '1993' ORDER BY month(date), day(date) ASC

131

111

SELECT count(*) AS count FROM `do_shows` AS `Show` LEFT JOIN `do_venues` AS `Venue` ON (`Show`.`venue_id` = `Venue`.`id`) WHERE year(date) = '1993' GROUP BY cancellationStatus

SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`name`, `Menu`.`h_link`, `Menu`.`type` FROM `do_menus` AS `Menu` WHERE 1 = 1 ORDER BY `id` ASC

SELECT year(newsTime) as year, month(newsTime) as month, count(*) as count FROM `do_news` AS `News` WHERE 1 = 1 GROUP BY month, year ORDER BY `year` DESC, `month` DESC

SELECT year(date) as year, count(*) as count FROM `do_shows` AS `Shows` WHERE 1 = 1 GROUP BY year(date)