SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1401603' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1401603.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1401752' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1401752.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1401765' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1401765.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1401813' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1401813.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1401816' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1401816.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1401823' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1401823.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1401829' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1401829.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1401832' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1401832.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1401833' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1401833.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1501741' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1501741.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1601532' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1601532.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1601574' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1601574.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1601598' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1601598.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1601625' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1601625.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1601630' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1601630.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1601639' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1601639.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1601648' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1601648.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1601655' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1601655.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1601662' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1601662.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1601665' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1601665.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1601730' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1601730.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1601732' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1601732.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1601734' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1601734.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1601735' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1601735.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1601736' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1601736.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1601752' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1601752.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1601761' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1601761.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1601762' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1601762.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1601807' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1601807.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1601808' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1601808.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1601809' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1601809.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1701574' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1701574.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1701585' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1701585.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1701660' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1701660.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1701680' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1701680.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1801757' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-1801757.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2302582' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-2302582.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2302584' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-2302584.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201819' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-3201819.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201833' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-3201833.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201869' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-3201869.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3301575' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-3301575.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3301577' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-3301577.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3301581' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-3301581.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3301582' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-3301582.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3301583' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-3301583.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3401599' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-3401599.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3401642' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-3401642.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3801657' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-3801657.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4201603' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-4201603.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4804015' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-4804015.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4804078' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-4804078.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5102606' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5102606.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5102689' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5102689.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5102776' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5102776.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5102779' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5102779.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5102816' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5102816.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5102844' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5102844.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5102846' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5102846.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5102849' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5102849.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5102850' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5102850.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5102851' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5102851.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5201735' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5201735.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5201749' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5201749.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5201773' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5201773.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5201776' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5201776.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5301646' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5301646.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401575' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5401575.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401581' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5401581.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401686' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5401686.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401699' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5401699.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401703' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5401703.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401704' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5401704.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401741' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5401741.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501640' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5501640.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501647' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5501647.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501652' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5501652.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501653' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5501653.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501661' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5501661.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501663' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5501663.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501665' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5501665.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501672' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5501672.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501673' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5501673.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501674' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5501674.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501675' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5501675.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501676' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5501676.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501677' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5501677.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501678' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5501678.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501679' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5501679.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501690' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5501690.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501691' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5501691.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501703' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5501703.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501704' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5501704.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501705' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5501705.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501706' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5501706.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501712' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5501712.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501735' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5501735.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5601561' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5601561.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5601562' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5601562.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5601564' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5601564.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5601579' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5601579.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5601624' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5601624.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5601640' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5601640.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5601686' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5601686.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5601690' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5601690.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5601691' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5601691.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5601698' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5601698.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5601752' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5601752.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5801984' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-5801984.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6102779' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-6102779.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6102780' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-6102780.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6301679' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-6301679.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6801889' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-6801889.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6801892' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-6801892.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7201512' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-7201512.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7301508' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-7301508.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7301532' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-7301532.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7401532' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/drifting-buoys-7401532.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2ICI4' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/tsg-2ICI4.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7JYD' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/tsg-7JYD.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7KAA' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/tsg-7KAA.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7KAC' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/tsg-7KAC.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='D5LS3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/tsg-D5LS3.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FAJ7028' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/tsg-FAJ7028.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FAJ8114' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/tsg-FAJ8114.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FASB' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/tsg-FASB.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FHQB' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/tsg-FHQB.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FMKV' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/tsg-FMKV.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FMNB' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/tsg-FMNB.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FNUR' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/tsg-FNUR.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='HORQ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/tsg-HORQ.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='VLMJ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/tsg-VLMJ.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='VMIC' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/tsg-VMIC.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='VMQ9273' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/tsg-VMQ9273.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='VNCF' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/tsg-VNCF.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='VRDE7' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/tsg-VRDE7.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='VROJ8' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/tsg-VROJ8.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='WDM5414' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/tsg-WDM5414.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='XPJ6VHP' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/tsg-XPJ6VHP.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='ZMFR' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/tsg-ZMFR.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='IF000611' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/mooring-buoys-time-series-IF000611.nc; -valid_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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.549 AND cl.lat_max >= -48.216 AND ((cl.long_min <= 173.728 AND cl.long_max >= 100.63) OR (cl.long_min <= MOD(173.728+360, 360) AND cl.long_max >= MOD(100.63+360, 360)) OR (cl.long_min <= MOD(173.728-360, 360) AND cl.long_max >= MOD(100.63-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.549 AND l.latitude >= -48.216 AND ((l.longitude <= 173.728 AND l.longitude >= 100.63) OR (l.longitude <= MOD(173.728+360, 360) AND l.longitude >= MOD(100.63+360, 360)) OR (l.longitude <= MOD(173.728-360, 360) AND l.longitude >= MOD(100.63-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='IF000619' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_040607_15076577/mooring-buoys-time-series-IF000619.nc; -valid_qc=12578