Linguist List - Reviews Available for the Book Choose a Review!
Back
SELECT SUBMISSIONID as ID, SSUBJECT as SUB, ISSUENUMBER as ISS, MSGBODY as FILENAME, TOPICID, MSGNUMBER, NMSGBODY FROM LL_SUBMISSION WHERE SUBMISSIONID = AND TOPICID = 9 AND STATUS IS NULL
SELECT PUB.AMAZONOPTOUT, BAN.BOOKID BOOKID, BAN.BOOKTITLE BOOKTITLE, BAN.SUBMISSIONID SUBMISSIONID, PUB.PUBNAME PUBNAME, PUB.PAYERID PAYERID, PUB.PUBURL PUBURL, SUBR.RELATEDCOMMENT FROM LL_SUBMISSION LLS left join SUBMSSION_RELATIONSHIP SUBR on LLS.SUBMISSIONID = SUBR.SUBMISSIONID1 left join BOOK_ANNOUNCEMENT BAN on SUBR.SUBMISSIONID = BAN.SUBMISSIONID left join PUBLISHER PUB on BAN.PAYERID = PUB.PAYERID WHERE LLS.SUBMISSIONID = SELECT BOOKPAGES, BOOKPRICE, ISBN, ISBN13, BOOKFORM, BA.SUBMISSIONID, BOOKCOUNTRYID FROM BOOK_INSTANCES BI, BOOK_ANNOUNCEMENT BA WHERE BI.SUBMISSIONID=BA.SUBMISSIONID AND BA.BOOKID = AND BA.STATUS IS NULL AND BI.STATUS IS NULL AND BOOKCOUNTRYID IN (5,21) SELECT DISTINCT ISBN, ISBN13 FROM BOOK_INSTANCES BI, BOOK_ANNOUNCEMENT BA WHERE BI.SUBMISSIONID=BA.SUBMISSIONID AND BA.BOOKID = AND BA.STATUS IS NULL AND BI.STATUS IS NULL AND BOOKCOUNTRYID IN (5,21) AND ( BOOKFORM = N'Hardback' OR BOOKFORM = N'Paperback' OR BOOKFORM = N'Hardback + CD-rom' ) SELECT LLP.PERSONID, COALESCE(LLP.PERSONFN, '') || ' ' || COALESCE(LLP.PERSONMI, '') || ' ' || COALESCE(LLP.PERSONLN, '') AS PERSONNAME FROM LL_SUBMISSION LLS left join PERSON_SUBMISSION LPS on LLS.SUBMISSIONID = LPS.SUBMISSIONID left join LL_PERSON LLP on LPS.PERSONID = LLP.PERSONID WHERE LLS.SUBMISSIONID = AND LLS.STATUS IS NULL AND LLP.STATUS IS NULL SELECT LLP.PERSONID, COALESCE(LLP.PERSONFN, '') || ' ' || COALESCE(LLP.PERSONMI, '') || ' ' || COALESCE(LLP.PERSONLN, '') AS PERSONNAME FROM LL_PERSON LLP left join PERSON_SUBMISSION PSUB on PSUB.PERSONID = LLP.PERSONID WHERE PSUB.SUBMISSIONID = AND LLP.STATUS IS NULL ORDER BY PSUB.ORDERING SELECT SSC.SUBCLASSID subclassid FROM SUBMISSION_SC SSC WHERE SSC.SUBMISSIONID = AND SSC.STATUS IS NULL SELECT SUBCLASSID, CLASSTYPE, CLASSLABEL, FAMILYID, LANGID FROM SUBJ_CLASSIFICATION WHERE SUBCLASSID =

Review of  #GetBook.BOOKTITLE#

SELECT NCLOB_PATH FROM TOPIC_TYPE WHERE TOPICID = 9 ", "all")>
#review2b#

Reviewer: #getperson.personname# Sorry, No Reviewer Data Available!
Book Title: #GetBook.BOOKTITLE# Sorry, No Book Data Available!
Book Author: #Autharray[j]# Sorry, No Book Author Data Available!
Publisher: #GetBook.PUBNAME# #Trim(GetBook.PUBNAME)#
Linguistic Field(s): #LFArray[k]#
Subject Language(s): #SLArray[k]#
#SLArray[k]#
Language Family(ies): #FamLabelArray[k]#
Issue Number: #Trim(ISS)#
SELECT SRL.SUBMISSIONID1 FROM SUBMSSION_RELATIONSHIP SRL, LL_SUBMISSION LLS WHERE SRL.RELTYPEID = '81' AND SRL.SUBMISSIONID = AND SRL.SUBMISSIONID = LLS.SUBMISSIONID AND LLS.EDITORAPPROVAL = 'YES' AND SRL.STATUS IS NULL AND LLS.STATUS IS NULL SELECT count(issuenumber) total FROM LL_SUBMISSION WHERE SUBMISSIONID =

Read Review Discussions Issues:
SELECT ISSUENUMBER FROM LL_SUBMISSION WHERE SUBMISSIONID = #newissuenum1#


Buy Buy Buy
#sunlink("/LL/posttolinguist2.cfm?TOPICID=5&revtitle=#Trim(GetBook.BOOKTITLE)#&LINGFIELDS=#Trim(lflist)#&SUBLANG=#Trim(SLlist)#&langfam=#Trim(Famlist)#&Famlabel=#Trim(FamLabellist)#&sllabel=#Trim(SLlabellist)#&LFlabellist=#Trim(LFlabellist)#&ISS=#Trim(GetSubID.ISS)#&RevSubID=#Trim(RevSubID)#","Discuss this Review")#
#sunlink("/LL/posting-help2.cfm","Help on Posting")#
", "all")> ", "all")> ","all")> ","all")> ","all")>
Review:
#review#
 
ABOUT THE REVIEWER:
#relcomm6#

Versions:
Format: #Trim(BOOKFORM)#
ISBN: #trim(ISBN)#
ISBN-13: #Trim(ISBN13)# N/A
Pages: #Trim(BOOKPAGES)#
Prices: SELECT COUNTRY || ' ' || CURRENCY curr FROM BOOK_COUNTRY WHERE BOOKCOUNTRYID = #trim(getcountry2.curr)# #Trim(BOOKPRICE)#
 
Format: #Trim(BOOKFORM)#
ISBN-13: #Trim(ISBN13)# N/A
Pages: #Trim(BOOKPAGES)#
Prices: SELECT COUNTRY || ' ' || CURRENCY curr FROM BOOK_COUNTRY WHERE BOOKCOUNTRYID = #trim(getcountry2.curr)# #Trim(BOOKPRICE)#
Sorry, no reviews found!