| Subfamily: |
Asopinae Amyot & Serville, 1843: xix, 74 |
| |
|
Asopinae Amyot & Serville, 1843: xix, 74 (Type: Asopus Burmeister, 1834)
Stiretrinae Amyot & Serville, 1843: xix, 74
Jallainae Mulsant & Rey, 1866: 331 (Type: Jalla Hahn, 1832)
Arminae Bergroth, 1904: 32
Amyoteinae Schouteden, 1907: b 2
Discocerinae Schouteden, 1907: b 4
Cazirini Azim & Shafee, 1980: 81
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
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=37541
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=37541
24: ORDER BY fl.STAGE, fm.NAME, tc.TAXA_NAME, c.ID, f.NAME, fl.FOODNAME, fl.ID
