Closed cedricbriandgithub closed 2 years ago
SELECT DISTINCT eel_typ_id, eel_typ_name FROM datawg.t_eelstock_eel t JOIN REF.tr_typeseries_typ ttt ON ttt.typ_id = t.eel_typ_id
WHERE eel_lfs_code='OG'
AND eel_qal_id IN (0,1,2,3,4);
eel_typ_id | typ_name |
---|---|
8 | q_release_kg |
9 | q_release_n |
10 | gee_n |
11 | q_aqua_kg |
SELECT count(*) FROM datawg.t_eelstock_eel WHERE eel_lfs_code='OG' AND eel_qal_id IN (0,1,2,3,4); --469
SELECT count(*) FROM datawg.t_eelstock_eel WHERE eel_lfs_code='OG' AND eel_qal_id IN (0,1,2,3,4); --519
469 519
SELECT DISTINCT count(*), eel_typ_id, typ_name, eel_emu_nameshort FROM datawg.t_eelstock_eel t JOIN REF.tr_typeseries_typ ttt ON ttt.typ_id = t.eel_typ_id
WHERE eel_lfs_code='OG'
AND eel_qal_id IN (0,1,2,3,4)
GROUP BY eel_typ_id, typ_name, eel_emu_nameshort;
count | eel_typ_id | typ_name | eel_emu_nameshort |
---|---|---|---|
1 | 8 | q_release_kg | DK_Inla |
1 | 8 | q_release_kg | ES_Cata |
1 | 8 | q_release_kg | LV_Latv |
1 | 9 | q_release_n | DK_Inla |
1 | 9 | q_release_n | ES_Cata |
1 | 9 | q_release_n | LV_Latv |
1 | 10 | gee_n | PT_Port |
2 | 8 | q_release_kg | DE_Warn |
2 | 9 | q_release_n | DE_Warn |
2 | 11 | q_aqua_kg | DK_total |
3 | 10 | gee_n | DE_Eide |
4 | 8 | q_release_kg | PL_total |
4 | 9 | q_release_n | PL_total |
6 | 8 | q_release_kg | DE_Eide |
6 | 9 | q_release_n | DE_Eide |
9 | 8 | q_release_kg | DK_total |
9 | 8 | q_release_kg | LT_total |
9 | 9 | q_release_n | DK_total |
9 | 9 | q_release_n | LT_total |
10 | 8 | q_release_kg | ES_Vale |
10 | 9 | q_release_n | ES_Vale |
13 | 11 | q_aqua_kg | DE_total |
15 | 11 | q_aqua_kg | ES_total |
18 | 8 | q_release_kg | EE_Narv |
18 | 9 | q_release_n | EE_Narv |
18 | 10 | gee_n | EE_Narv |
23 | 10 | gee_n | DE_Schl |
44 | 8 | q_release_kg | DE_Schl |
44 | 8 | q_release_kg | PL_Oder |
44 | 9 | q_release_n | DE_Schl |
44 | 9 | q_release_n | PL_Oder |
48 | 8 | q_release_kg | PL_Vist |
48 | 9 | q_release_n | PL_Vist |
wont fix, this stage is used in germany
OG is ongrown eel, by what stage do we replace the eel, yellow eel surely ?