Sunday, September 23, 2007

SQL reporting

SELECT * FROM bibtex_entry AS TB, (SELECT bibtex_index , if(bibtex_key LIKE "%keyX%",1,0) AS F2, if(crossref LIKE "",1,0) AS F3, if(keywords LIKE "%science%",1,0) AS F4, if(doi LIKE "",1,0) AS F5, if(url LIKE "%http://book1.com.sg%",1,0) AS F6, if(citeseerurl LIKE "",1,0) AS F7, if(pdf LIKE "%D:\IO.pdf%",1,0) AS F8, if(comment LIKE "%-%",1,0) AS F9, if(owner LIKE "%astroart%",1,0) AS F10, if(timestamp LIKE "%09.09.2006%",1,0) AS F11, if(abstract LIKE "%nil%",1,0) AS F12, if(review LIKE "%no comment yet%",1,0) AS F13, if(year LIKE "%1999%",1,0) AS F14, if(author LIKE "%writer Lim%",1,0) AS F15, if(title LIKE "%new book 1 %",1,0) AS F16, if(volume LIKE "%2.3%",1,0) AS F17, if(number LIKE %100%,1,0) AS F18, if(pages LIKE "%100-200%",1,0) AS F19, if(series LIKE "%2.2%",1,0) AS F20, if(address LIKE "%ang mo kio%",1,0) AS F21, if(edition LIKE "%2%",1,0) AS F22, if(month LIKE "%july%",1,0) AS F23, if(note LIKE "%-%",1,0) AS F24, if(publisher LIKE "%johnson%",1,0) AS F25, if(editor LIKE "%ed-4%",1,0) AS F26 FROM bibtex_entry AS TB,book AS TYPE WHERE TB.bibtex_index = TYPE.bibtex_index ) AS P,book AS TYPE where TB.bibtex_index=TYPE.bibtex_index and TYPE.bibtex_index = P.bibtex_indexand (F0+F1+F2+F3+F4+F5+F6+F7+F8+F9+F10+F11+F12+F13+F14+F15+F16+F17+F18+F19+F20+F21+F22+F23+F24)>17

No comments: