JohnE/Audio Files

Audio files

1977

• Bootleg: Angry Young Sod
• Bootleg: Live At The Agora 1977
• Bootleg: Some Like It Hot
• Concert 1977-07-21 Manchester
• Concert 1977-07-27 London
• Concert 1977-08-02 Liverpool
• Concert 1977-08-11 Bilzen
• Concert 1977-08-21 London
• Concert 1977-08-30 Paisley
• Concert 1977-08-31 Edinburgh
• Concert 1977-09-01 Falkirk
• Concert 1977-09-04 London
• Concert 1977-10-13 Glasgow
• Concert 1977-10-15 Leeds
• Concert 1977-10-21 Manchester
• Concert 1977-10-22 Leicester
• Concert 1977-10-31 Guildford
• Concert 1977-11-05 Lancaster
• Concert 1977-11-15 San Francisco (early)
• Concert 1977-11-15 San Francisco (late)
• Concert 1977-11-18 Los Angeles (early)
• Concert 1977-11-19 Los Angeles (early)
• Concert 1977-11-23 New Orleans
• Concert 1977-12-01 Milwaukee
• Concert 1977-12-02 Chicago
• Concert 1977-12-06 Marcy
• Concert 1977-12-09 Boston (early)
• Concert 1977-12-14 New York (late)
• Concert 1977-12-16 Asbury Park (early)
• Concert 1977-12-16 Asbury Park (late)
• Concert 1977-12-22 London
• Radio 1977-09-27 Capital Radio
• TV 1977-09-01 Top Of The Pops
• TV 1977-09-30 Nöjesliv
• TV 1977-11-10 Top Of The Pops

(Why does the yellow Triangle of Terror occur?)

1977 - try to not display "Concert"

• Bootleg: Angry Young Sod
• Bootleg: Live At The Agora 1977
• Bootleg: Some Like It Hot
• Concert 1977-07-21 Manchester
• Concert 1977-07-27 London
• Concert 1977-08-02 Liverpool
• Concert 1977-08-11 Bilzen
• Concert 1977-08-21 London
• Concert 1977-08-30 Paisley
• Concert 1977-08-31 Edinburgh
• Concert 1977-09-01 Falkirk
• Concert 1977-09-04 London
• Concert 1977-10-13 Glasgow
• Concert 1977-10-15 Leeds
• Concert 1977-10-21 Manchester
• Concert 1977-10-22 Leicester
• Concert 1977-10-31 Guildford
• Concert 1977-11-05 Lancaster
• Concert 1977-11-15 San Francisco (early)
• Concert 1977-11-15 San Francisco (late)
• Concert 1977-11-18 Los Angeles (early)
• Concert 1977-11-19 Los Angeles (early)
• Concert 1977-11-23 New Orleans
• Concert 1977-12-01 Milwaukee
• Concert 1977-12-02 Chicago
• Concert 1977-12-06 Marcy
• Concert 1977-12-09 Boston (early)
• Concert 1977-12-14 New York (late)
• Concert 1977-12-16 Asbury Park (early)
• Concert 1977-12-16 Asbury Park (late)
• Concert 1977-12-22 London
• Radio 1977-09-27 Capital Radio
• TV 1977-09-01 Top Of The Pops
• TV 1977-09-30 Nöjesliv
• TV 1977-11-10 Top Of The Pops

- doesn't work

1978

B

• Bootleg: Crawling Through The USA
• Bootleg: Frisco Beat
• Bootleg: I've Just Come From California
• Bootleg: Live Attraction

C

• Concert 1978-01-20 London
• Concert 1978-01-25 Austin
• Concert 1978-01-26 New Orleans
• Concert 1978-01-28 Dallas
• Concert 1978-01-31 St. Louis
• Concert 1978-02-01 Kansas City
• Concert 1978-02-04 Boulder
• Concert 1978-02-07 Berkeley
• Concert 1978-02-08 Davis (late)
• Concert 1978-02-09 Eugene
• Concert 1978-02-10 Seattle
• Concert 1978-02-11 Portland
• Concert 1978-02-14 Minneapolis

C cont.

• Concert 1978-02-15 Milwaukee
• Concert 1978-02-18 Brockport
• Concert 1978-02-20 Cincinnati (late)
• Concert 1978-02-23 New Brunswick
• Concert 1978-02-24 Upper Darby
• Concert 1978-02-26 Providence (late)
• Concert 1978-03-01 Amherst
• Concert 1978-03-03 Brookville (early)
• Concert 1978-03-04 Buffalo (early)
• Concert 1978-03-04 Buffalo (late)
• Concert 1978-03-16 Dublin
• Concert 1978-03-22 Newcastle upon Tyne
• Concert 1978-03-29 Brighton
• Concert 1978-04-01 Bracknell
• Concert 1978-04-04 Glasgow
• Concert 1978-04-12 Portsmouth
• Concert 1978-04-14 Birmingham

C cont.

• Concert 1978-04-15 London
• Concert 1978-04-16 London
• Concert 1978-04-19 Minneapolis
• Concert 1978-04-21 Chicago
• Concert 1978-04-22 Royal Oak (early)
• Concert 1978-04-22 Royal Oak (late)
• Concert 1978-04-27 Syracuse
• Concert 1978-04-29 Toronto (early)
• Concert 1978-04-29 Toronto (late)
• Concert 1978-04-30 Montreal
• Concert 1978-05-04 Boston
• Concert 1978-05-05 Passaic
• Concert 1978-05-06 New York (early)
• Concert 1978-05-06 New York (late)
• Concert 1978-05-07 Pawtucket
• Concert 1978-05-09 Willimantic
• ... further results

1979

Debug output SQLStore

ASK Query

[[Category:Audio files]] [[Category:1979]]

SQL Query

SELECT DISTINCT
  t0.smw_id AS id,
  t0.smw_title AS t,
  t0.smw_namespace AS ns,
  t0.smw_iw AS iw,
  t0.smw_subobject AS so,
  t0.smw_sortkey AS sortkey, t0.smw_sort
FROM
  `wiki_smw_object_ids` AS t0
INNER JOIN
  (`wiki_smw_fpt_inst` AS t2
INNER JOIN
  `wiki_t3` AS t3 ON t2.o_id=t3.id
INNER JOIN
  `wiki_smw_fpt_inst` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
  (
   (t4.o_id=248684)
  )
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
  t0.smw_sort ASC
LIMIT
  55
OFFSET
  0

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t3	ALL	PRIMARY				4		Using temporary; Using filesort
1	SIMPLE	t2	ref	s_id, o_id, s_id_2, o_id_2	o_id_2	5	elvis_wiki.t3.id	29		Using index
1	SIMPLE	t4	ref	s_id, o_id, s_id_2, o_id_2	s_id_2	9	elvis_wiki.t2.s_id, const	1		Using index
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	elvis_wiki.t2.s_id	1		Using where

Auxilliary Tables

• Temporary table t3
    Recursively computed hierarchy for element(s) (689).
    SELECT s_id FROM `wiki_smw_fpt_subc` WHERE o_id=689 LIMIT 1

Query Metrics

Query-Size:2
Query-Depth:0

Errors and Warnings

None