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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='4101691' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/drifting-buoys-4101691.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='4101771' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/drifting-buoys-4101771.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='4400900' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/drifting-buoys-4400900.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='4401631' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/drifting-buoys-4401631.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='4402652' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/drifting-buoys-4402652.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='6202577' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/drifting-buoys-6202577.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='6202579' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/drifting-buoys-6202579.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='6202581' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/drifting-buoys-6202581.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='6202583' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/drifting-buoys-6202583.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='6202586' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/drifting-buoys-6202586.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='6202594' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/drifting-buoys-6202594.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='6202595' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/drifting-buoys-6202595.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='6202596' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/drifting-buoys-6202596.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='6203610' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/drifting-buoys-6203610.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='6203757' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/drifting-buoys-6203757.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='6301615' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/drifting-buoys-6301615.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='6301616' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/drifting-buoys-6301616.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='6301617' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/drifting-buoys-6301617.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='6402551' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/drifting-buoys-6402551.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='EXB04573' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/drifting-buoys-EXB04573.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='2ICI4' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/tsg-2ICI4.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='A8MA9' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/tsg-A8MA9.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='A8RH6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/tsg-A8RH6.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='CNGUSYM' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/tsg-CNGUSYM.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='D5LS3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/tsg-D5LS3.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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_20240626_062055_15043156/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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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_20240626_062055_15043156/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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='DIGX2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/tsg-DIGX2.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='EAJ3GDS' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/tsg-EAJ3GDS.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='FABB' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/tsg-FABB.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='FAJ7028' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/tsg-FAJ7028.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='FAJ8114' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/tsg-FAJ8114.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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_20240626_062055_15043156/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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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_20240626_062055_15043156/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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='FMCY' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/tsg-FMCY.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='FMLW' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/tsg-FMLW.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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_20240626_062055_15043156/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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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_20240626_062055_15043156/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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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_20240626_062055_15043156/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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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_20240626_062055_15043156/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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='FNUR' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/tsg-FNUR.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='FO5984' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/tsg-FO5984.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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_20240626_062055_15043156/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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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_20240626_062055_15043156/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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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_20240626_062055_15043156/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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='LY2227' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/tsg-LY2227.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='SBCT' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/tsg-SBCT.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='SKEC' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/tsg-SKEC.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='VRZP8' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/tsg-VRZP8.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='WDE9586' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/tsg-WDE9586.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='WDF9323' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/tsg-WDF9323.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='WDM5414' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/tsg-WDM5414.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='6200053' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/mooring-buoys-time-series-6200053.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='6200054' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/mooring-buoys-time-series-6200054.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='6200058' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/mooring-buoys-time-series-6200058.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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_20240626_062055_15043156/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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='EXIN0005' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/mooring-buoys-time-series-EXIN0005.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('31/12/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2017 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 <= 49.17 AND cl.lat_max >= 48.35 AND ((cl.long_min <= -2.56 AND cl.long_max >= -4.62) OR (cl.long_min <= MOD(-2.56+360, 360) AND cl.long_max >= MOD(-4.62+360, 360)) OR (cl.long_min <= MOD(-2.56-360, 360) AND cl.long_max >= MOD(-4.62-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 <= 49.17 AND l.latitude >= 48.35 AND ((l.longitude <= -2.56 AND l.longitude >= -4.62) OR (l.longitude <= MOD(-2.56+360, 360) AND l.longitude >= MOD(-4.62+360, 360)) OR (l.longitude <= MOD(-2.56-360, 360) AND l.longitude >= MOD(-4.62-360, 360)) ) AND (temp = '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='IF000997' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240626_062055_15043156/mooring-buoys-time-series-IF000997.csv;