SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='DBBH' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/tsg-DBBH.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='DBBT' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/tsg-DBBT.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FAC8862' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/tsg-FAC8862.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FAWQ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/tsg-FAWQ.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FGA3812' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/tsg-FGA3812.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FGG2872' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/tsg-FGG2872.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FGG8669' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/tsg-FGG8669.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FGTO' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/tsg-FGTO.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FIEH' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/tsg-FIEH.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FIEI' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/tsg-FIEI.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FKJB' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/tsg-FKJB.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FMNB' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/tsg-FMNB.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FMUR' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/tsg-FMUR.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FNAV' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/tsg-FNAV.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FNCM' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/tsg-FNCM.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FNFP' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/tsg-FNFP.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FNHO' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/tsg-FNHO.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FPCS' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/tsg-FPCS.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FQBE' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/tsg-FQBE.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FS4536' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/tsg-FS4536.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='LXSQ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/tsg-LXSQ.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='XJBI' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/tsg-XJBI.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='13001' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-13001.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='13002' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-13002.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6100196' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-6100196.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6100197' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-6100197.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6100198' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-6100198.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6100280' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-6100280.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6100281' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-6100281.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6100284' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-6100284.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6100430' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-6100430.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6200021' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-6200021.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6200024' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-6200024.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6200025' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-6200025.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6200082' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-6200082.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6200084' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-6200084.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6200085' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-6200085.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6200310' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-6200310.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6200443' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-6200443.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6200450' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-6200450.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6201038' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-6201038.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6201039' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-6201039.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6201040' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-6201040.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6201062' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-6201062.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6201572' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-6201572.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXIN0002' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-EXIN0002.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXIN0003' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-EXIN0003.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXIN0004' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-EXIN0004.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXIN0006' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-EXIN0006.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXMY0476' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-EXMY0476.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXMY0490' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-EXMY0490.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXMY1653' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-EXMY1653.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXMY2019' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-EXMY2019.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXMY3593' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-EXMY3593.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXMY3714' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-EXMY3714.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXMY3776' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-EXMY3776.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXMY3777' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-EXMY3777.csv;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('24/03/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('24/02/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 51.7 AND cl.lat_max >= 6.95 AND ((cl.long_min <= 47.21 AND cl.long_max >= -64.66) OR (cl.long_min <= MOD(47.21+360, 360) AND cl.long_max >= MOD(-64.66+360, 360)) OR (cl.long_min <= MOD(47.21-360, 360) AND cl.long_max >= MOD(-64.66-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 51.7 AND l.latitude >= 6.95 AND ((l.longitude <= 47.21 AND l.longitude >= -64.66) OR (l.longitude <= MOD(47.21+360, 360) AND l.longitude >= MOD(-64.66+360, 360)) OR (l.longitude <= MOD(47.21-360, 360) AND l.longitude >= MOD(-64.66-360, 360)) ) AND (psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXMY3778' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250324_091737_15174689/mooring-buoys-time-series-EXMY3778.csv;