SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='1901520' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-1901520.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6900321' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6900321.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6900322' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6900322.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6900374' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6900374.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6900377' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6900377.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6900378' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6900378.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6900379' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6900379.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6900415' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6900415.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6900417' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6900417.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6900538' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6900538.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6900636' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6900636.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6900662' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6900662.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6900701' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6900701.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6900786' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6900786.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6900787' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6900787.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6900788' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6900788.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6900957' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6900957.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6900968' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6900968.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901021' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6901021.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901042' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6901042.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901143' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6901143.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901237' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6901237.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901239' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6901239.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901242' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6901242.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901243' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6901243.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901244' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6901244.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901245' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6901245.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901247' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6901247.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901412' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6901412.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901413' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6901413.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901418' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6901418.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901419' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6901419.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901450' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6901450.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901476' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6901476.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901511' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6901511.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901554' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6901554.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901567' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6901567.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901600' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6901600.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901621' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6901621.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901648' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6901648.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901653' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6901653.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901672' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6901672.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901707' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6901707.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901836' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6901836.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901839' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6901839.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901861' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6901861.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901878' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6901878.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901913' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6901913.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6901914' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6901914.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6902572' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6902572.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6902663' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6902663.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6902664' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6902664.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='6903177' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/argo-profiles-6903177.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='9HA2362' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/ctd-profiles-9HA2362.nc; -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 3, 11, 12, 13, 14, 15, 19) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 42.267 AND s.latitude >= 29.737 AND ((s.longitude <= 3.58 AND s.longitude >= -14.917) OR (s.longitude <= MOD(3.58+360, 360) AND s.longitude >= MOD(-14.917+360, 360)) OR (s.longitude <= MOD(3.58-360, 360) AND s.longitude >= MOD(-14.917-360, 360)) ) AND s.station_date <= TO_DATE('01/01/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='DBFP' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144543_15163900/ctd-profiles-DBFP.nc; -valid_qc=12578