SignUp
Ukrainian Biodiversity Information Network
Національна мережа інформації з біорізноманіття
  Catalogue »  Animalia »  Arthropoda »  Insecta »  Hemiptera »  Heteroptera »  Pentatomorpha »  Pentatomoidea »  Pentatomidae Leach, 1815: 121     [species]
Family:  Pentatomidae Leach, 1815: 121
Pentatomidae Leach, 1815: 121   (Type: Pentatoma Olivier, 1789)   (Pentatomides)
Rhaphigastridae Amyot & Serville, 1843: xxv, 141   (Rhaphigastrides)

 
Overview
Phenogram
References: 5/32 (5/28)
Distribution
Map
 



Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /web/ukrbin.com/www/db_api.php on line 142
MySQL error: Subquery returns more than 1 row

show sql text »
1: SELECT DISTINCT t.TITLE CNAME1,
2: c.AUTHORID AUID, ac.NAME AUNAME, c.AYEAR, c.ABRACK, c.AYEARREM,
3: tc.TAXA_NAME CNAME, c.RANK, tc.AU_CAPTION,
4: fm.ID FMID, fm.NAME FMNAME, fo.ID FOID, fo.NAME FONAME,
5: c.ID CLID, fl.STAGE, fl.NOTES
6: FROM classes ff /* host parent taxa */
7: JOIN classobj_tree tt ON tt.POBJID=ff.OBJID
8: LEFT JOIN classes f ON f.OBJID=tt.OBJID /* host plants */
9: JOIN food_links fl ON fl.ID2=f.ID
10: JOIN classes c ON c.ID=fl.ID1 /* phytophages */
11: LEFT JOIN c_author ac ON ac.ID=c.AUTHORID
12: LEFT JOIN languages l ON l.CODE='en'
13: LEFT JOIN titles t ON t.POBJID=c.OBJID AND t.LANGID=l.ID AND t.SIGNATURE='classes'
14: LEFT JOIN classes_taxa tc on tc.ID=c.ID
15: LEFT JOIN classes fm ON fm.OBJID =
16: (SELECT t.POBJID
17: FROM classobj_tree t
18: WHERE t.OBJID=c.OBJID AND t.PRANK IN(13,14))
19: LEFT JOIN classes fo ON fo.OBJID =
20: (SELECT t.POBJID
21: FROM classobj_tree t
22: WHERE t.OBJID=c.OBJID AND t.PRANK=19)
23: WHERE ff.ID=600
24: ORDER BY fl.STAGE, fm.NAME, tc.TAXA_NAME, c.ID, f.NAME, fl.FOODNAME, fl.ID