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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='5802034' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/drifting-buoys-5802034.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='6203865' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/drifting-buoys-6203865.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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_20241212_143445_15126319/tsg-2WDQB3E.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='3FOA6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-3FOA6.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='3GFKKCC' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-3GFKKCC.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='3VR2YKH' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-3VR2YKH.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='3WH466J' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-3WH466J.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='4SYY57Q' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-4SYY57Q.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='9HA3062' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-9HA3062.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='9HA4240' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-9HA4240.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='9HA4766' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-9HA4766.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='AHSBERV' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-AHSBERV.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='ALBARO' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-ALBARO.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='C6EF4' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-C6EF4.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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_20241212_143445_15126319/tsg-CNGUSYM.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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_20241212_143445_15126319/tsg-DXSHNGW.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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_20241212_143445_15126319/tsg-EAJ3GDS.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='ELYB6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-ELYB6.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='ERFU9CD' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-ERFU9CD.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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_20241212_143445_15126319/tsg-FGG2872.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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_20241212_143445_15126319/tsg-FGG8669.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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_20241212_143445_15126319/tsg-FNFP.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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_20241212_143445_15126319/tsg-FQBE.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='GNJ2FHW' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-GNJ2FHW.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='HBLLCVS' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-HBLLCVS.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='HWQ33VU' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-HWQ33VU.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='KSKM' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-KSKM.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='LUARZ8N' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-LUARZ8N.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='LYHH6ZZ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-LYHH6ZZ.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='MERFR01' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-MERFR01.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='MVDFG6N' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-MVDFG6N.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='SFMRARM' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-SFMRARM.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='SHIP' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-SHIP.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='TEKW9TX' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-TEKW9TX.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='V7A6073' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-V7A6073.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='V7DJ7' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-V7DJ7.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='V7UU4' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-V7UU4.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='VCDJG9K' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-VCDJG9K.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='VHYXE6E' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-VHYXE6E.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='VRJF2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-VRJF2.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='WNMJYHB' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-WNMJYHB.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='WUKJN8R' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-WUKJN8R.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='XBHG5AS' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-XBHG5AS.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='YLKET8R' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-YLKET8R.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='ZECF3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-ZECF3.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='ZQBVSBE' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/tsg-ZQBVSBE.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='6200021' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/mooring-buoys-time-series-6200021.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='6200059' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/mooring-buoys-time-series-6200059.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='6200069' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/mooring-buoys-time-series-6200069.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='6200074' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/mooring-buoys-time-series-6200074.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='6200078' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/mooring-buoys-time-series-6200078.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='6200103' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/mooring-buoys-time-series-6200103.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='6200107' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/mooring-buoys-time-series-6200107.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='6200251' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/mooring-buoys-time-series-6200251.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='6200252' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/mooring-buoys-time-series-6200252.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='6200288' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/mooring-buoys-time-series-6200288.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='6200290' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/mooring-buoys-time-series-6200290.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='6200443' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/mooring-buoys-time-series-6200443.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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_20241212_143445_15126319/mooring-buoys-time-series-6200450.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='6201000' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/mooring-buoys-time-series-6201000.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='6201001' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/mooring-buoys-time-series-6201001.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='6201002' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/mooring-buoys-time-series-6201002.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='6201003' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/mooring-buoys-time-series-6201003.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='6201005' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/mooring-buoys-time-series-6201005.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='6201006' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/mooring-buoys-time-series-6201006.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='6201007' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/mooring-buoys-time-series-6201007.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='6201008' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/mooring-buoys-time-series-6201008.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='6201009' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/mooring-buoys-time-series-6201009.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='6201010' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/mooring-buoys-time-series-6201010.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='6201011' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/mooring-buoys-time-series-6201011.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='6201012' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/mooring-buoys-time-series-6201012.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='6201013' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/mooring-buoys-time-series-6201013.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='6201014' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/mooring-buoys-time-series-6201014.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='6201015' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/mooring-buoys-time-series-6201015.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='6201027' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/mooring-buoys-time-series-6201027.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='6201044' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/mooring-buoys-time-series-6201044.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='6201053' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/mooring-buoys-time-series-6201053.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='6201054' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/mooring-buoys-time-series-6201054.csv; -measure_qc=12578
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('12/12/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('12/11/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 <= 50.97 AND cl.lat_max >= 46.78 AND ((cl.long_min <= 3.28 AND cl.long_max >= -7.21) OR (cl.long_min <= MOD(3.28+360, 360) AND cl.long_max >= MOD(-7.21+360, 360)) OR (cl.long_min <= MOD(3.28-360, 360) AND cl.long_max >= MOD(-7.21-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 <= 50.97 AND l.latitude >= 46.78 AND ((l.longitude <= 3.28 AND l.longitude >= -7.21) OR (l.longitude <= MOD(3.28+360, 360) AND l.longitude >= MOD(-7.21+360, 360)) OR (l.longitude <= MOD(3.28-360, 360) AND l.longitude >= MOD(-7.21-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='EXMY2926' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241212_143445_15126319/mooring-buoys-time-series-EXMY2926.csv; -measure_qc=12578