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 'PZ1' :

SHUTDOWN is in progress.:SELECT FGNAMES.*, tblSuperfamilies.Superfamily FROM tblSuperfamilies INNER JOIN FGNAMES ON tblSuperfamilies.SuperfamilyID = FGNAMES.SUPERFAMFK WHERE FAMCODE Like 'PZ1' 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

Lipothymus Grandi, 1922

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 MASTER.ValFamTrib, MASTER.VALGENUS, MASTER.VALSPECIES, MASTER.VALAUTHOR, MASTER.VALDATE, CASE WHEN Left(VALAUTHOR,1)='(' THEN 'true' ELSE 'false' END AS ValidAuthBracket, COUNTRY.COUNTRY, COUNTRY.STATE, COUNTRY.REGION, COUNTRY.FULL_NAME FROM ((MASTER INNER JOIN DIST ON MASTER.TAXONCODE = DIST.TAXONCODE) LEFT JOIN COUNTRY ON (DIST.STATE = COUNTRY.STATE) AND (DIST.COUNTRY = COUNTRY.COUNTRY) AND (DIST.REGION = COUNTRY.REGION)) INNER JOIN FGNAMES ON MASTER.FAMILY = FGNAMES.FAMCODE WHERE((VALGENUS = 'Lipothymus') AND (VALAUTHOR = 'Grandi') AND (VALDATE = '1922') AND (HOMCODE = '0') AND ((VALSPECIES Is Null))) ORDER BY COUNTRY.FULL_NAME,COUNTRY.STATE:

SHUTDOWN is in progress.:SELECT DISTINCT MASTER.ValFamTrib, MASTER.VALGENUS, MASTER.VALSPECIES, MASTER.VALAUTHOR, MASTER.VALDATE, CASE WHEN Left(VALAUTHOR,1)='(' THEN 'true' ELSE 'false' END AS ValidAuthBracket, COUNTRY.COUNTRY, COUNTRY.STATE, COUNTRY.REGION, COUNTRY.FULL_NAME FROM ((MASTER INNER JOIN DIST ON MASTER.TAXONCODE = DIST.TAXONCODE) LEFT JOIN COUNTRY ON (DIST.STATE = COUNTRY.STATE) AND (DIST.COUNTRY = COUNTRY.COUNTRY) AND (DIST.REGION = COUNTRY.REGION)) INNER JOIN FGNAMES ON MASTER.FAMILY = FGNAMES.FAMCODE WHERE((VALGENUS = 'Lipothymus') AND (VALAUTHOR = 'Grandi') AND (VALDATE = '1922') AND (HOMCODE = '0') AND ((VALSPECIES Is Null))) ORDER BY COUNTRY.FULL_NAME,COUNTRY.STATE in <process:Query> near the end[line 110 -- line 110]click here for more info