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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='3901219' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/argo-trajectory-3901219.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='3901601' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/argo-trajectory-3901601.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='3901603' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/argo-trajectory-3901603.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='3902495' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/argo-trajectory-3902495.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='4902467' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/argo-trajectory-4902467.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='4902481' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/argo-trajectory-4902481.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='4902608' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/argo-trajectory-4902608.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='4903258' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/argo-trajectory-4903258.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='4903377' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/argo-trajectory-4903377.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='6904231' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/argo-trajectory-6904231.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='7901027' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/argo-trajectory-7901027.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='1301812' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/drifting-buoys-1301812.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='4801771' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/drifting-buoys-4801771.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='5801972' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/drifting-buoys-5801972.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='2CXJVYJ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/tsg-2CXJVYJ.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='3E3536' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/tsg-3E3536.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='3ETV4' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/tsg-3ETV4.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='4ANFBRL' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/tsg-4ANFBRL.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='5LRUZ9T' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/tsg-5LRUZ9T.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='7KBS' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/tsg-7KBS.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='8VEUMXY' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/tsg-8VEUMXY.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='9BEUB6Y' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/tsg-9BEUB6Y.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='9HA2066' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/tsg-9HA2066.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='9HA5397' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/tsg-9HA5397.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='9HA5465' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/tsg-9HA5465.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='9V6210' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/tsg-9V6210.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='9V9450' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/tsg-9V9450.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='9V9791' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/tsg-9V9791.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='A8VP8' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/tsg-A8VP8.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='DBBT' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/tsg-DBBT.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='HPMEYWQ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/tsg-HPMEYWQ.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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_20240614_163500_15039541/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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='KZAMFKY' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/tsg-KZAMFKY.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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_20240614_163500_15039541/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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='NHXMUSA' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/tsg-NHXMUSA.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='PZBN6JW' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/tsg-PZBN6JW.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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_20240614_163500_15039541/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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='V7NB6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/tsg-V7NB6.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='V7NJ6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/tsg-V7NJ6.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='V7NK7' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/tsg-V7NK7.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='V7QJ3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/tsg-V7QJ3.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='V7UT9' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/tsg-V7UT9.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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_20240614_163500_15039541/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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='VROX8' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/tsg-VROX8.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='WARL' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/tsg-WARL.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='WTDF' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/tsg-WTDF.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='XJBI' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/tsg-XJBI.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='4400050' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/mooring-buoys-time-series-4400050.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='4400488' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/mooring-buoys-time-series-4400488.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='4400489' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/mooring-buoys-time-series-4400489.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='44007' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/mooring-buoys-time-series-44007.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='44013' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/mooring-buoys-time-series-44013.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='44018' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/mooring-buoys-time-series-44018.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='44027' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/mooring-buoys-time-series-44027.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='44029' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/mooring-buoys-time-series-44029.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='44030' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/mooring-buoys-time-series-44030.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='44032' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/mooring-buoys-time-series-44032.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='44033' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/mooring-buoys-time-series-44033.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='44034' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/mooring-buoys-time-series-44034.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='44037' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/mooring-buoys-time-series-44037.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='44073' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/mooring-buoys-time-series-44073.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='44090' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/mooring-buoys-time-series-44090.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='44098' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/mooring-buoys-time-series-44098.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='EXMF0038' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/mooring-buoys-time-series-EXMF0038.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='EXSH0089' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/mooring-buoys-time-series-EXSH0089.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='GBQN3' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/mooring-buoys-time-series-GBQN3.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='WEBM1' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/mooring-buoys-time-series-WEBM1.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('14/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 55.095 AND cl.lat_max >= 41.67 AND ((cl.long_min <= -50.493 AND cl.long_max >= -73.39) OR (cl.long_min <= MOD(-50.493+360, 360) AND cl.long_max >= MOD(-73.39+360, 360)) OR (cl.long_min <= MOD(-50.493-360, 360) AND cl.long_max >= MOD(-73.39-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 <= 55.095 AND l.latitude >= 41.67 AND ((l.longitude <= -50.493 AND l.longitude >= -73.39) OR (l.longitude <= MOD(-50.493+360, 360) AND l.longitude >= MOD(-73.39+360, 360)) OR (l.longitude <= MOD(-50.493-360, 360) AND l.longitude >= MOD(-73.39-360, 360)) ) ) 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='WEQM1' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240614_163500_15039541/mooring-buoys-time-series-WEQM1.csv; -measure_qc=12578