value poping up in new while duplicated in sampling (SE)

[cedricbriandgithub]

SELECT * FROM datawg.t_samplinginfo_sai AS tss
JOIN datawg.t_groupsamp_grsa AS tgg ON grsa_sai_id =sai_id
JOIN datawg.t_metricgroupsamp_megsa AS tmm ON meg_gr_id=gr_id
WHERE sai_cou_code ='SE'
AND sai_id = 803
AND gr_year = 2011
AND grsa_lfs_code = 'Y'

803 SE_West_Kar SE
803 SE_West_Kar SE
803 SE_West_Kar SE
803 SE_West_Kar SE

[cedricbriandgithub]

SE_West_Kar 2011 appears both in deleted and new metrics.
Delete SE_West_Kar first
2024_Eel_Data_Call_Annex9_Other_Sampling_Data_SE_test_West_Kar.xlsx

Nothing in new :

Deleted will delete anyways so if the sheet is "deleted" the whole list is always returned without check

[cedricbriandgithub]

sai_id	sai_name	sai_cou_code	sai_emu_nameshort	sai_area_division	sai_hty_code	sai_comment	sai_samplingobjective	sai_samplingstrategy	sai_protocol	sai_qal_id	sai_lastupdate	sai_dts_datasource	gr_id	gr_year	gr_number	gr_comment	gr_lastupdate	gr_dts_datasource	grsa_sai_id	grsa_lfs_code	meg_id	meg_gr_id	meg_mty_id	meg_value	meg_last_update	meg_qal_id	meg_dts_datasource
803	SE_West_Kar	SE	SE_West	27.3.a	C	Random sample may be non representative as fishermen may have chosen large eels for selling.	EU DCF	Commercial fishery	Fyke-net fishery.Eels from Käringöfjorden. 2007 random sampling. 2009-2011 Stratified sampling (5 individuals per cm). Data sampled during quater two and three in Käringöfjorden.	1	2023-09-05	dc_2023	4 110	2 010	67		2023-09-05	dc_2023	803	Y	12 863	4 110	1	487,552238806	2023-09-05	1	dc_2023
803	SE_West_Kar	SE	SE_West	27.3.a	C	Random sample may be non representative as fishermen may have chosen large eels for selling.	EU DCF	Commercial fishery	Fyke-net fishery.Eels from Käringöfjorden. 2007 random sampling. 2009-2011 Stratified sampling (5 individuals per cm). Data sampled during quater two and three in Käringöfjorden.	1	2023-09-05	dc_2023	4 110	2 010	67		2023-09-05	dc_2023	803	Y	12 864	4 110	2	205,4328358209	2023-09-05	1	dc_2023
803	SE_West_Kar	SE	SE_West	27.3.a	C	Random sample may be non representative as fishermen may have chosen large eels for selling.	EU DCF	Commercial fishery	Fyke-net fishery.Eels from Käringöfjorden. 2007 random sampling. 2009-2011 Stratified sampling (5 individuals per cm). Data sampled during quater two and three in Käringöfjorden.	1	2023-09-05	dc_2023	4 110	2 010	67		2023-09-05	dc_2023	803	Y	12 865	4 110	3	10,2575757576	2023-09-05	1	dc_2023
803	SE_West_Kar	SE	SE_West	27.3.a	C	Random sample may be non representative as fishermen may have chosen large eels for selling.	EU DCF	Commercial fishery	Fyke-net fishery.Eels from Käringöfjorden. 2007 random sampling. 2009-2011 Stratified sampling (5 individuals per cm). Data sampled during quater two and three in Käringöfjorden.	1	2023-09-05	dc_2023	4 110	2 010	67		2023-09-05	dc_2023	803	Y	12 866	4 110	6	0,9552238806	2023-09-05	1	dc_2023
803	SE_West_Kar	SE	SE_West	27.3.a	C	Random sample may be non representative as fishermen may have chosen large eels for selling.	EU DCF	Commercial fishery	Fyke-net fishery.Eels from Käringöfjorden. 2007 random sampling. 2009-2011 Stratified sampling (5 individuals per cm). Data sampled during quater two and three in Käringöfjorden.	1	2023-09-05	dc_2023	4 110	2 010	67		2023-09-05	dc_2023	803	Y	12 867	4 110	7	1	2023-09-05	1	dc_2023
803	SE_West_Kar	SE	SE_West	27.3.a	C	Random sample may be non representative as fishermen may have chosen large eels for selling.	EU DCF	Commercial fishery	Fyke-net fishery.Eels from Käringöfjorden. 2007 random sampling. 2009-2011 Stratified sampling (5 individuals per cm). Data sampled during quater two and three in Käringöfjorden.	1	2023-09-05	dc_2023	4 110	2 010	67		2023-09-05	dc_2023	803	Y	12 868	4 110	8	0	2023-09-05	1	dc_2023
803	SE_West_Kar	SE	SE_West	27.3.a	C	Random sample may be non representative as fishermen may have chosen large eels for selling.	EU DCF	Commercial fishery	Fyke-net fishery.Eels from Käringöfjorden. 2007 random sampling. 2009-2011 Stratified sampling (5 individuals per cm). Data sampled during quater two and three in Käringöfjorden.	1	2023-09-05	dc_2023	4 110	2 010	67		2023-09-05	dc_2023	803	Y	12 869	4 110	21	487,552238806	2023-09-05	1	dc_2023
803	SE_West_Kar	SE	SE_West	27.3.a	C	Random sample may be non representative as fishermen may have chosen large eels for selling.	EU DCF	Commercial fishery	Fyke-net fishery.Eels from Käringöfjorden. 2007 random sampling. 2009-2011 Stratified sampling (5 individuals per cm). Data sampled during quater two and three in Käringöfjorden.	1	2023-09-05	dc_2023	4 110	2 010	67		2023-09-05	dc_2023	803	Y	12 870	4 110	22	205,4328358209	2023-09-05	1	dc_2023
803	SE_West_Kar	SE	SE_West	27.3.a	C	Random sample may be non representative as fishermen may have chosen large eels for selling.	EU DCF	Commercial fishery	Fyke-net fishery.Eels from Käringöfjorden. 2007 random sampling. 2009-2011 Stratified sampling (5 individuals per cm). Data sampled during quater two and three in Käringöfjorden.	1	2023-09-05	dc_2023	4 110	2 010	67		2023-09-05	dc_2023	803	Y	12 871	4 110	23	10,2575757576	2023-09-05	1	dc_2023
803	SE_West_Kar	SE	SE_West	27.3.a	C	Random sample may be non representative as fishermen may have chosen large eels for selling.	EU DCF	Commercial fishery	Fyke-net fishery.Eels from Käringöfjorden. 2007 random sampling. 2009-2011 Stratified sampling (5 individuals per cm). Data sampled during quater two and three in Käringöfjorden.	1	2023-09-05	dc_2023	4 110	2 010	67		2023-09-05	dc_2023	803	Y	12 872	4 110	25	0	2023-09-05	1	dc_2023
803	SE_West_Kar	SE	SE_West	27.3.a	C	Random sample may be non representative as fishermen may have chosen large eels for selling.	EU DCF	Commercial fishery	Fyke-net fishery.Eels from Käringöfjorden. 2007 random sampling. 2009-2011 Stratified sampling (5 individuals per cm). Data sampled during quater two and three in Käringöfjorden.	1	2023-09-05	dc_2023	4 112	2 011	76		2023-09-05	dc_2023	803	Y	12 884	4 112	1	477,2763157895	2023-09-05	1	dc_2023
803	SE_West_Kar	SE	SE_West	27.3.a	C	Random sample may be non representative as fishermen may have chosen large eels for selling.	EU DCF	Commercial fishery	Fyke-net fishery.Eels from Käringöfjorden. 2007 random sampling. 2009-2011 Stratified sampling (5 individuals per cm). Data sampled during quater two and three in Käringöfjorden.	1	2023-09-05	dc_2023	4 112	2 011	76		2023-09-05	dc_2023	803	Y	12 885	4 112	2	191,3815789474	2023-09-05	1	dc_2023
803	SE_West_Kar	SE	SE_West	27.3.a	C	Random sample may be non representative as fishermen may have chosen large eels for selling.	EU DCF	Commercial fishery	Fyke-net fishery.Eels from Käringöfjorden. 2007 random sampling. 2009-2011 Stratified sampling (5 individuals per cm). Data sampled during quater two and three in Käringöfjorden.	1	2023-09-05	dc_2023	4 112	2 011	76		2023-09-05	dc_2023	803	Y	12 886	4 112	3	10,0921052632	2023-09-05	1	dc_2023
803	SE_West_Kar	SE	SE_West	27.3.a	C	Random sample may be non representative as fishermen may have chosen large eels for selling.	EU DCF	Commercial fishery	Fyke-net fishery.Eels from Käringöfjorden. 2007 random sampling. 2009-2011 Stratified sampling (5 individuals per cm). Data sampled during quater two and three in Käringöfjorden.	1	2023-09-05	dc_2023	4 112	2 011	76		2023-09-05	dc_2023	803	Y	12 887	4 112	6	0,9736842105	2023-09-05	1	dc_2023

[cedricbriandgithub]

1. The values do not show in the existing group metric tab : find why
2. The step duplicates includes gr_number and not life stage, this is probably wrong, as an update to the group number will not be detected