Linguist List | Publications Index Page SELECT DISTINCT SUBJ_CLASSIFICATION.SUBCLASSID, SUBJ_CLASSIFICATION.CLASSLABEL FROM LL_SUBMISSION, SUBMISSION_SC, SUBJ_CLASSIFICATION WHERE LL_SUBMISSION.SUBMISSIONID = SUBMISSION_SC.SUBMISSIONID AND SUBMISSION_SC.SUBCLASSID = SUBJ_CLASSIFICATION.SUBCLASSID AND SUBJ_CLASSIFICATION.CTYPE = 'SL' AND SUBJ_CLASSIFICATION.CLASSLABEL != N'None' ORDER BY CLASSLABEL SELECT DISTINCT SUBJ_CLASSIFICATION.SUBCLASSID, SUBJ_CLASSIFICATION.CLASSLABEL FROM BOOK_ANNOUNCEMENT, SUBJ_CLASSIFICATION WHERE BOOK_ANNOUNCEMENT.WRITTENIN = SUBJ_CLASSIFICATION.SUBCLASSID AND SUBJ_CLASSIFICATION.CTYPE = 'SL' AND SUBJ_CLASSIFICATION.CLASSLABEL != N'None' ORDER BY CLASSLABEL SELECT DISTINCT SUBJ_CLASSIFICATION.SUBCLASSID, SUBJ_CLASSIFICATION.CLASSLABEL FROM LL_SUBMISSION, SUBMISSION_SC, SUBJ_CLASSIFICATION WHERE LL_SUBMISSION.SUBMISSIONID = SUBMISSION_SC.SUBMISSIONID AND SUBMISSION_SC.SUBCLASSID = SUBJ_CLASSIFICATION.SUBCLASSID AND SUBJ_CLASSIFICATION.CTYPE = 'LF' AND SUBJ_CLASSIFICATION.CLASSLABEL != N'Not Applicable' ORDER BY CLASSLABEL SELECT DISTINCT COUNT(BOOKID)BCOUNT FROM LL_SUBMISSION, BOOK_ANNOUNCEMENT LEFT JOIN PUBLISHER ON BOOK_ANNOUNCEMENT.PAYERID = PUBLISHER.PAYERID WHERE BOOK_ANNOUNCEMENT.SUBMISSIONID = LL_SUBMISSION.SUBMISSIONID AND LL_SUBMISSION.EDITORAPPROVAL=N'YES' AND PUBLISHER.EDITORAPPROVAL = N'YES' AND LL_SUBMISSION.MAIN = N'YES' AND LL_SUBMISSION.STATUS IS NULL AND BOOK_ANNOUNCEMENT.STATUS IS NULL AND PUBLISHER.STATUS IS NULL SELECT COUNT(SUBMISSIONID) TOCCOUNT FROM LL_SUBMISSION WHERE TOPICID=11 AND trim(EDITORAPPROVAL)=N'YES' SELECT COUNT(SUBMISSIONID)RCOUNT FROM LL_SUBMISSION WHERE TOPICID=9 AND trim(EDITORAPPROVAL)=N'YES' SELECT COUNT(DISSID) DCOUNT FROM DISS_ABS, LL_SUBMISSION WHERE DISS_ABS.SUBMISSIONID = LL_SUBMISSION.SUBMISSIONID AND TRIM(EDITORAPPROVAL)=N'YES' SELECT COUNT(PAPERID) PCOUNT FROM PAPER_INFO WHERE UPPER(TRIM(EDITORAPPROVAL))=N'YES' SELECT COUNT(SUBMISSIONID) SCOUNT FROM LL_SUBMISSION WHERE TOPICID = 13 AND STATUS IS NULL AND EDITORAPPROVAL = n'YES' SELECT COUNT(JOURNALID) JCOUNT FROM JOURNAL WHERE TRIM(EDITORAPPROVAL)=N'YES' SELECT COUNT(LL_SUBMISSION.SUBMISSIONID) JCALLCOUNT FROM Journal_Submission, Journal, LL_Submission WHERE Journal.JournalID = Journal_Submission.JournalID AND Journal_Submission.SubmissionID = LL_Submission.SubmissionID AND LL_Submission.TopicID = '3' AND upper(trim(LL_Submission.EditorApproval)) = n'YES' AND LL_SUBMISSION.ISSUENUMBER IS NOT NULL AND journal_submission.calldeadline > AND JOURNAL.STATUS IS NULL AND JOURNAL_SUBMISSION.STATUS IS NULL AND LL_SUBMISSION.STATUS IS NULL SELECT COUNT(PUBID) PUCOUNT FROM PUBLISHER WHERE TRIM(EDITORAPPROVAL)=N'YES'

Welcome to the Publications Area!


The Publications Area at LINGUIST List contains information on a wide range of linguistic publications. Please browse our facilities below! If you have any questions, please contact the Publications Manager at pubs Linguist List linguistlist.org for more information.


#sunlink("books/", "Books")# Books (#NumberofBooks.bcount#)
#sunlink("reviews/", "Reviews")# Book reviews (#NumberofReviews.rcount#)
#sunlink("diss/", "Dissertations")# Dissertation abstracts (#NumberofDissAbs.dcount#)
#sunlink("papers/", "Academic Papers")# Academic paper abstracts (#NumberofPapers.pcount#)
#sunlink("journals/", "Journals")# Journal listings (#NumberofJournals.jcount#)
#sunlink("journals/", "Journal Calls for Papers")# Journal calls for papers (#NumberofJournalcalls.jcallcount#)
#sunlink("tocs/", "Table of Contents")# Tables of contents for journal issues (#NumberofTOC.TOCCOUNT#)
#sunlink("../sp/software-index.cfm", "Software")# Software announcements (#NumberofSoftware.scount#)
#sunlink("publishers.cfm", "Publishers")# Publisher listings (#NumberofPublishers.pucount#)
#sunlink("Publogin.cfm", "Publisher Login")# Publisher login

Cambridge Extra Blog Cambridge Extra is a free resource for linguists worldwide that seeks to provide the global Linguistics community with information, news, updates and special offers from the world of Linguistics.


Do you publish linguistics material?



Search Publications

Publication Category:    Books  Reviews  Dissertations  All

Subject Language
Note: Subject language is the language the publication is about.
Linguistic Subfield