| Family: |
Pentatomidae Leach, 1815: 121 |
| |
|
Pentatomidae Leach, 1815: 121 (Type: Pentatoma Olivier, 1789)
Rhaphigastridae Amyot & Serville, 1843: xxv, 141
Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /web/ukrbin.com/www/db_api.php on line 156
MySQL error: Subquery returns more than 1 row
SELECT DISTINCT t.TITLE CNAME1,
c.AUTHORID AUID, ac.NAME AUNAME, c.AYEAR, c.ABRACK, c.AYEARREM,
tc.TAXA_NAME CNAME, c.RANK, tc.AU_CAPTION,
fm.ID FMID, fm.NAME FMNAME, fo.ID FOID, fo.NAME FONAME,
c.ID CLID, fl.STAGE, fl.NOTES
FROM classes ff /* host parent taxa */
JOIN classobj_tree tt ON tt.POBJID=ff.OBJID
LEFT JOIN classes f ON f.OBJID=tt.OBJID /* host plants */
JOIN food_links fl ON fl.ID2=f.ID
JOIN classes c ON c.ID=fl.ID1 /* phytophages */
LEFT JOIN c_author ac ON ac.ID=c.AUTHORID
LEFT JOIN languages l ON l.CODE='en'
LEFT JOIN titles t ON t.POBJID=c.OBJID AND t.LANGID=l.ID AND t.SIGNATURE='classes'
LEFT JOIN classes_taxa tc on tc.ID=c.ID
LEFT JOIN classes fm ON fm.OBJID =
(SELECT t.POBJID
FROM classobj_tree t
WHERE t.OBJID=c.OBJID AND t.PRANK IN(13,14))
LEFT JOIN classes fo ON fo.OBJID =
(SELECT t.POBJID
FROM classobj_tree t
WHERE t.OBJID=c.OBJID AND t.PRANK=19)
WHERE ff.ID=600
ORDER BY fl.STAGE, fm.NAME, tc.TAXA_NAME, c.ID, f.NAME, fl.FOODNAME, fl.ID
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
