SELECT DISTINCT LANG_NAME.SUBCLASSID,
(LANG_NAME.LANGNAMECODE) Code,
LANG_NAME.LANGNAME,
LANG_NAME.NAMETYPE,
SUBJ_CLASSIFICATION.SUBCLASSID sub,
SUBJ_CLASSIFICATION.CLASSLABEL,
SUBJ_CLASSIFICATION.FAMILYID,
SUBJ_CLASSIFICATION.STATUS,
LANG_FAMILIES.SUBGROUP
FROM LANG_NAME, SUBJ_CLASSIFICATION, LANG_FAMILIES
WHERE LANG_NAME.SUBCLASSID = SUBJ_CLASSIFICATION.SUBCLASSID
AND SUBJ_CLASSIFICATION.FAMILYID = LANG_FAMILIES.FAMILYID
AND (UPPER(SUBJ_CLASSIFICATION.FAMILYID) LIKE n'#FID#')
ORDER BY SUBJ_CLASSIFICATION.CLASSLABEL
SELECT SUBCLASSID
FROM SUBJ_CLASSIFICATION
WHERE CTYPE = 'FA'
AND (
UPPER(SUBJ_CLASSIFICATION.FAMILYID) LIKE n'#FID#')
SELECT SUBGROUP
FROM LANG_FAMILIES
WHERE FAMILYID = n'#Mid(SelectSL.familyid,1,2)#'
SELECT LANG_FAMILIES_ALT.ALTERNATE_NAME
FROM LANG_FAMILIES_ALT
WHERE SUBCLASSID = n'#getsubclassid.subclassid#'::integer
SELECT FAMILYID
FROM LANG_FAMILIES
WHERE FAMILYID = n'#FID#'
#getlangnumber.RecordCount# language
s
in the #SelectSL.SUBGROUP# subgroup
of #findfamilyname.subgroup#
Subgrouping Code: #FID#
#EXTINCT#
= Language Extinct;
*
= Language Near Extinction;
SELECT SUBGROUP
FROM LANG_FAMILIES
WHERE FAMILYID = n'#FID#'
SELECT LANGID
FROM SUBJ_CLASSIFICATION
WHERE trim(FAMILYID) like n'#trim(FID)#%'
AND CTYPE = 'SL'
Tree for #getfamilyname.subgroup#
Alternate Names: #temp_altList#
Alternate Name: #getalternatefamnames.alternate_name#
Click on one of the subordinate nodes for a tree of that subgroup.
Click on a language for a fuller description of that language.
Note: This application uses Java, and will be slow the first time it is run.
SELECT distinct SUBJ_CLASSIFICATION.SUBCLASSID,
SUBJ_CLASSIFICATION.CLASSLABEL,
SUBJ_CLASSIFICATION.FAMILYID,
SUBJ_CLASSIFICATION.CTYPE,
(LANG_NAME.LANGNAMECODE) Code
FROM LANG_NAME, SUBJ_CLASSIFICATION
WHERE LANG_NAME.SUBCLASSID = SUBJ_CLASSIFICATION.SUBCLASSID
AND UPPER(SUBJ_CLASSIFICATION.FAMILYID) LIKE n'#FID#'
AND SUBJ_CLASSIFICATION.CTYPE = 'SL'
ORDER BY SUBJ_CLASSIFICATION.CLASSLABEL
|