ISFDB talk:ISFDB1 Notes

Small project, based on Ahasuerus' desire for "Find all Titles whose Synopsis and/or Note fields contain %%, a remnant of the pre-ISFDB-2 days". BLongley 00:18, 30 April 2011 (UTC)

SQL for generating this page:

select DISTINCT "[http://www.isfdb.org/cgi-bin/title.cgi?" , t.title_id , " ", t.title_title , "] " from titles t, notes n where t.note_id = n.note_id and n.note_note like '%\%\%%'

N.B. SQL to search synopses below, but no results found:

select DISTINCT "[http://www.isfdb.org/cgi-bin/title.cgi?" , t.title_id , " ", t.title_title , "] " from titles t where t.title_synopsis like '%\%\%%'