SELECT J.JOURNALID, J.JOURNALTITLE, J.JOURNALDESCR, J.URL, J.LABS, J.ISSN, P.PUBNAME, P.PAYERID, P.PUBSUPPORTLEVEL, P.SUPPORTEXPIRATIONDATE FROM JOURNAL J left join PUBLISHER P on J.PAYERID = P.PAYERID WHERE J.JOURNALID = AND TRIM(J.EDITORAPPROVAL) = N'YES' AND TRIM(P.EDITORAPPROVAL) = N'YES' SELECT SC.CLASSLABEL FROM JOURNAL_SC JSC, SUBJ_CLASSIFICATION SC WHERE JSC.SUBCLASSID = SC.SUBCLASSID AND SC.CLASSTYPE = N'LF' AND JSC.JOURNALID = AND JSC.STATUS IS NULL SELECT SC.CLASSLABEL, SC.CLASSTYPE, SC.LANGID, SC.FAMILYID FROM JOURNAL_SC JSC, SUBJ_CLASSIFICATION SC WHERE JSC.SUBCLASSID = SC.SUBCLASSID AND (SC.CLASSTYPE = N'SL' OR SC.CLASSTYPE = N'FA') AND JSC.JOURNALID = AND SC.CLASSLABEL != N'None' AND JSC.STATUS IS NULL SELECT ORDERDEPT, ORDERADDR1, ORDERADDR2, ORDERCITY, ORDERSTATE, ORDERZIP, ORDERCOUNTRY, ORDERPHONE, ORDERFAX, ORDEREMAIL FROM JOURNAL_ORDERING_INFO WHERE JOURNALID = The Linguist List -- Journal Page

Journal Information



Title: #trim(JournalTitle)#
Publisher: #trim(PubName)#
 
#sunlink("../publishers.cfm", "LL Supporting Publishers")#
URL: #trim(getjournal.URL)#
Description: #paragraphFormat(trim(JOURNALDESCR))#
ISSN: #ISSN# N/A
Linguistic Field(s): #trim(ClassLabel)#
Language Specialty: #trim(ClassLabel)# #trim(ClassLabel)# #trim(ClassLabel)#
 

Ordering Information for this Journal


Address: #trim(ORDERDEPT)#
#trim(ORDERADDR1)#
#trim(ORDERADDR2)#
#trim(ORDERCITY)#
#trim(ORDERSTATE)#   #trim(ORDERZIP)#
SELECT COUNTRYNAME FROM COUNTRY_CODES WHERE COUNTRYID = #trim(GetCountry.COUNTRYNAME)#
Telephone: #trim(ORDERPHONE)# Not Specified
Fax: #trim(ORDERFAX)# Not Specified
Email: #trim(ORDEREMAIL)# Not Specified

  View all Tables of Contents for this journal.