Popular search terms:

Home / Our science / Data / Universal Chalcidoidea Database

Universal Chalcidoidea Database

Taxon record

SHUTDOWN is in progress.:SELECT FGNAMES.*, tblSuperfamilies.Superfamily FROM tblSuperfamilies INNER JOIN FGNAMES ON tblSuperfamilies.SuperfamilyID = FGNAMES.SUPERFAMFK WHERE FAMCODE Like 'EE' :

SHUTDOWN is in progress.:SELECT FGNAMES.*, tblSuperfamilies.Superfamily FROM tblSuperfamilies INNER JOIN FGNAMES ON tblSuperfamilies.SuperfamilyID = FGNAMES.SUPERFAMFK WHERE FAMCODE Like 'EE' in <process:SQL> near the content: [/td> </tr> </process:SQL> <comment>END get family/subfamily names</comment> ][line 120 -- line 120]click here for more info

Neruandella Trjapitzin, 2004

Please note: this list is derived from literature in which Chalcids are identified to genus level only. It does not include records for species.

List all references
SHUTDOWN is in progress.:SELECT DISTINCT ValFamTrib, DISPLAYORD, [ORDER], HOSTFAMILY, HOSNUMBER, FAMGROUP, HOSGENUS, HOSSPECIES, FAMILY + ' - ' + COALESCE(HOSGENUS,'') + ' ' + COALESCE(HOSSPECIES,'') As HostTaxon, RELATION, PAGEREF, COMMONNAME, AUTHOR, YEAR, TITLE, JOURBOOK, VOLUME, PAGES, HOSNUMBER, HOSTSUPERFAM, NOTES, EDITOR, PUBLISHER FROM tblAllHostRefs WHERE((VALGENUS = 'Neruandella') AND (VALAUTHOR = 'Trjapitzin') AND (VALDATE = '2004') AND (HOMCODE = '0') AND ((VALSPECIES Is Null))) ORDER BY DISPLAYORD,[ORDER],HOSTFAMILY,HOSGENUS,HOSSPECIES,AUTHOR,YEAR:

SHUTDOWN is in progress.:SELECT DISTINCT ValFamTrib, DISPLAYORD, [ORDER], HOSTFAMILY, HOSNUMBER, FAMGROUP, HOSGENUS, HOSSPECIES, FAMILY + ' - ' + COALESCE(HOSGENUS,'') + ' ' + COALESCE(HOSSPECIES,'') As HostTaxon, RELATION, PAGEREF, COMMONNAME, AUTHOR, YEAR, TITLE, JOURBOOK, VOLUME, PAGES, HOSNUMBER, HOSTSUPERFAM, NOTES, EDITOR, PUBLISHER FROM tblAllHostRefs WHERE((VALGENUS = 'Neruandella') AND (VALAUTHOR = 'Trjapitzin') AND (VALDATE = '2004') AND (HOMCODE = '0') AND ((VALSPECIES Is Null))) ORDER BY DISPLAYORD,[ORDER],HOSTFAMILY,HOSGENUS,HOSSPECIES,AUTHOR,YEAR in <process:Query> near the end[line 125 -- line 125]click here for more info