SignUp
Ukrainian Biodiversity Information Network
Національна мережа інформації з біорізноманіття
  Catalogue »  Animalia »  Arthropoda »  Insecta
Class:  Insecta
Insects

 
Overview
References: 3/2605 (3/250)
Distribution
 



Warning: mysqli::query(): (08S01/1053): Server shutdown in progress in /web/ukrbin.com/www/db_api.php on line 142
MySQL error: Server shutdown in progress

show sql text »
1:
2: SELECT
3: (SELECT COUNT(DISTINCT r.LITID)
4: FROM lit_ref_taxon r WHERE r.CLASSID=c.ID) CURREFCNT,
5:
6: (SELECT COUNT(DISTINCT r.LITID) FROM classobj_tree t
7: JOIN classes c1 ON c1.OBJID=t.OBJID
8: JOIN lit_ref_taxon r ON r.CLASSID=c1.ID
9: WHERE t.POBJID=c.OBJID /* AND t.OBJID <> c.OBJID */
10: ) NESTREFCNT,
11:
12: (SELECT COUNT(DISTINCT lf.FILEID) FROM lit_ref_taxon r
13: JOIN lit_ref_file lf ON lf.LITID=r.LITID
14: WHERE r.CLASSID=c.ID) CURDOWNCNT,
15:
16: (SELECT COUNT(DISTINCT b.ID)
17: FROM lit_ref_taxon r
18: JOIN literature b ON b.ID=r.LITID AND b.DOWN_URL != ''
19: WHERE r.CLASSID=c.ID) CURDOWN_CNT,
20:
21: (SELECT COUNT(DISTINCT lf.FILEID) FROM classobj_tree t
22: JOIN classes c1 ON c1.OBJID=t.OBJID
23: JOIN lit_ref_taxon r ON r.CLASSID=c1.ID
24: JOIN lit_ref_file lf ON lf.LITID=r.LITID
25: WHERE t.POBJID=c.OBJID /* AND t.OBJID <> c.OBJID */
26: ) NESTDOWNCNT,
27:
28: (SELECT COUNT(DISTINCT b.ID) FROM classobj_tree t
29: JOIN classes c1 ON c1.OBJID=t.OBJID
30: JOIN lit_ref_taxon r ON r.CLASSID=c1.ID
31: JOIN literature b ON b.ID=r.LITID AND b.DOWN_URL != ''
32: WHERE t.POBJID=c.OBJID /* AND t.OBJID <> c.OBJID */
33: ) NESTDOWN_CNT
34:
35: FROM classes c
36: WHERE c.ID=2952
37: