Difference between revisions of "ISFDB:Reviews of Essays"

From ISFDB
Jump to navigation Jump to search
(These can't be right, can they?)
 
 
Line 55: Line 55:
 
[http://www.isfdb.org/cgi-bin/title.cgi?1168584 The Way to Write Science Fiction ]<br>
 
[http://www.isfdb.org/cgi-bin/title.cgi?1168584 The Way to Write Science Fiction ]<br>
  
Derived from this SQL:  
+
Derived from this SQL: <nowiki>
  
 
select '[http://www.isfdb.org/cgi-bin/title.cgi?',
 
select '[http://www.isfdb.org/cgi-bin/title.cgi?',
Line 65: Line 65:
 
and    t.title_ttype = 'REVIEW'
 
and    t.title_ttype = 'REVIEW'
 
and    t2.title_ttype = 'ESSAY'
 
and    t2.title_ttype = 'ESSAY'
 +
 +
</nowiki>
  
 
[[User:BLongley|BLongley]] 01:38, 19 April 2011 (UTC)
 
[[User:BLongley|BLongley]] 01:38, 19 April 2011 (UTC)

Latest revision as of 21:40, 18 April 2011

Nonliterary Influences on Science Fiction
Deep Time
Deep Time
Deep Time
Deep Time
Elric
The Planet That Wasn't
Andre Norton: Fables and Futures
Krazy Kat
Voices from the Sky
The Stars in Their Courses
Dreams Must Explain Themselves
Supernatural Horror in Literature
The Art of Science Fiction
Alchemical Texts
The Road to Infinity
Going Into Space
The Art of Science Fiction
From Elfland to Poughkeepsie
Future Shock
H. P. Lovecraft, a Portrait
Number Seven, Queer Street
Science Fiction and Mrs Brown
From Elfland to Poughkeepsie
That Buck Rogers Stuff
Niven's Laws
Lovecraft: A Symposium
Algernon, Charlie, and I
The Planet That Wasn't
The Engines of the Night
From Elfland to Poughkeepsie
Whirligig World
Workshops: The Minefields of Science Fiction
Deep Time
Number Seven, Queer Street
The Engines of the Night
Woman in the Year 2000
Counting Nuns
Epizootics
Tour of the Universe
The Engines of the Night
Andre Norton: Fables & Futures
The Tragedy of the Moon
H. P. Lovecraft, a Portrait
Letter (Wonder Stories, November-December 1935)
Flat Earth Again
The Limits of Individual Plasticity
The Gentleman from Angell Street
The Most Amazing Thing
Letter (Amazing Stories, September 1929)
The Snows of Olympus
Magic
"It" Came From Outer Space
The Way to Write Science Fiction
The Way to Write Science Fiction

Derived from this SQL: select '[http://www.isfdb.org/cgi-bin/title.cgi?', t.title_id, t.title_title , ']<br>' from titles t, title_relationships tr, titles t2 WHERE t.title_id = tr.review_id and t2.title_id = tr.title_id and t.title_ttype = 'REVIEW' and t2.title_ttype = 'ESSAY'

BLongley 01:38, 19 April 2011 (UTC)