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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='6204612' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/drifting-buoys-6204612.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='6204613' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/drifting-buoys-6204613.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='6204614' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/drifting-buoys-6204614.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='2WDQB3E' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-2WDQB3E.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='3EFK6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-3EFK6.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='3ETR7' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-3ETR7.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='5LHX2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-5LHX2.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='5QQQVZL' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-5QQQVZL.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='7WFBSAS' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-7WFBSAS.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='9HA3858' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-9HA3858.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='9HA4777' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-9HA4777.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='9HA5063' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-9HA5063.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='9HA5682' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-9HA5682.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='9V6172' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-9V6172.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='9V9407' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-9V9407.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='A8SI6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-A8SI6.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='CZEF3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-CZEF3.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='DQQNGXU' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-DQQNGXU.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='DXSHNGW' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-DXSHNGW.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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_20240624_110615_15041441/tsg-EAJ3GDS.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='JSZF9CP' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-JSZF9CP.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='MBFI9' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-MBFI9.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='NRW2RTV' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-NRW2RTV.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='RVJZZZD' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-RVJZZZD.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='TBWUK80' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-TBWUK80.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='V7JD2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-V7JD2.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='V7NJ6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-V7NJ6.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='V7QJ5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-V7QJ5.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='V7RX6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-V7RX6.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='V7UU7' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-V7UU7.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='V7ZZ6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-V7ZZ6.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='VRFX6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-VRFX6.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='VRHE3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-VRHE3.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='VRMC7' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-VRMC7.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='VRNE6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-VRNE6.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='VRPF9' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-VRPF9.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='VRQZ7' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-VRQZ7.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='VRRQ5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-VRRQ5.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='VRTU5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-VRTU5.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='WSFABLK' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-WSFABLK.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='XCGBCPP' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/tsg-XCGBCPP.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='6100197' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/mooring-buoys-time-series-6100197.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='6100280' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/mooring-buoys-time-series-6100280.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='6100281' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/mooring-buoys-time-series-6100281.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='6100417' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/mooring-buoys-time-series-6100417.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='6100430' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/mooring-buoys-time-series-6100430.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='6100499' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/mooring-buoys-time-series-6100499.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='EXMY1830' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/mooring-buoys-time-series-EXMY1830.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='EXMY1836' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/mooring-buoys-time-series-EXMY1836.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='EXMY1837' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/mooring-buoys-time-series-EXMY1837.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='EXMY1914' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/mooring-buoys-time-series-EXMY1914.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='EXMY1915' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/mooring-buoys-time-series-EXMY1915.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='EXMY2382' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/mooring-buoys-time-series-EXMY2382.nc;
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/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('15/05/2024 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 <= 41.15 AND cl.lat_max >= 36.731 AND ((cl.long_min <= 5.202 AND cl.long_max >= -0.355) OR (cl.long_min <= MOD(5.202+360, 360) AND cl.long_max >= MOD(-0.355+360, 360)) OR (cl.long_min <= MOD(5.202-360, 360) AND cl.long_max >= MOD(-0.355-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 <= 41.15 AND l.latitude >= 36.731 AND ((l.longitude <= 5.202 AND l.longitude >= -0.355) OR (l.longitude <= MOD(5.202+360, 360) AND l.longitude >= MOD(-0.355+360, 360)) OR (l.longitude <= MOD(5.202-360, 360) AND l.longitude >= MOD(-0.355-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='EXMY3714' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240624_110615_15041441/mooring-buoys-time-series-EXMY3714.nc;