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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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='2902636' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144357_15163798/argo-profiles-2902636.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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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='4901296' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144357_15163798/argo-profiles-4901296.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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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='6900115' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144357_15163798/argo-profiles-6900115.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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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='6900116' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144357_15163798/argo-profiles-6900116.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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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='6900317' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144357_15163798/argo-profiles-6900317.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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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='6900320' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144357_15163798/argo-profiles-6900320.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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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_144357_15163798/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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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_144357_15163798/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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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_144357_15163798/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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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='6900503' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144357_15163798/argo-profiles-6900503.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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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_144357_15163798/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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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_144357_15163798/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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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_144357_15163798/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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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='6900708' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144357_15163798/argo-profiles-6900708.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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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_144357_15163798/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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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_144357_15163798/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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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_144357_15163798/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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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_144357_15163798/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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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_144357_15163798/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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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='6901019' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144357_15163798/argo-profiles-6901019.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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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='6901041' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144357_15163798/argo-profiles-6901041.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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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_144357_15163798/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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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_144357_15163798/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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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_144357_15163798/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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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_144357_15163798/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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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_144357_15163798/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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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_144357_15163798/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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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_144357_15163798/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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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_144357_15163798/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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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='6901467' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144357_15163798/argo-profiles-6901467.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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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_144357_15163798/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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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='6901512' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144357_15163798/argo-profiles-6901512.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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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='6901513' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144357_15163798/argo-profiles-6901513.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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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_144357_15163798/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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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_144357_15163798/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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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='6901623' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144357_15163798/argo-profiles-6901623.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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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='6901631' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144357_15163798/argo-profiles-6901631.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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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_144357_15163798/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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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_144357_15163798/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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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='6901877' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144357_15163798/argo-profiles-6901877.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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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_144357_15163798/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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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_144357_15163798/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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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_144357_15163798/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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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_144357_15163798/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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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='A8SH4' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144357_15163798/ctd-profiles-A8SH4.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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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='FGTO' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144357_15163798/ctd-profiles-FGTO.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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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='FMCY' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144357_15163798/ctd-profiles-FMCY.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/2015 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2014 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='VRMG4' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250303_144357_15163798/ctd-profiles-VRMG4.nc; -valid_qc=12578