SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1401768' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/drifting-buoys-1401768.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1601605' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/drifting-buoys-1601605.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1601633' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/drifting-buoys-1601633.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1601645' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/drifting-buoys-1601645.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_184058_15078263/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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1601652' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/drifting-buoys-1601652.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201688' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/drifting-buoys-3201688.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201690' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/drifting-buoys-3201690.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201692' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/drifting-buoys-3201692.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201696' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/drifting-buoys-3201696.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5102608' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/drifting-buoys-5102608.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5102720' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/drifting-buoys-5102720.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401544' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/drifting-buoys-5401544.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401626' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/drifting-buoys-5401626.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401687' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/drifting-buoys-5401687.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401688' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/drifting-buoys-5401688.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401689' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/drifting-buoys-5401689.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_184058_15078263/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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401745' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/drifting-buoys-5401745.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501527' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/drifting-buoys-5501527.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501534' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/drifting-buoys-5501534.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501566' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/drifting-buoys-5501566.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501620' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/drifting-buoys-5501620.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501639' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/drifting-buoys-5501639.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501650' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/drifting-buoys-5501650.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_184058_15078263/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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_184058_15078263/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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_184058_15078263/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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501664' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/drifting-buoys-5501664.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_184058_15078263/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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_184058_15078263/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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_184058_15078263/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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='D5PC7' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/tsg-D5PC7.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='D5RW8' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/tsg-D5RW8.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_184058_15078263/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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_184058_15078263/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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='SHIP' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/tsg-SHIP.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='V7DJ7' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/tsg-V7DJ7.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='V7IY5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/tsg-V7IY5.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_184058_15078263/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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_184058_15078263/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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_184058_15078263/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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_184058_15078263/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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='55027' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/mooring-buoys-time-series-55027.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='55028' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/mooring-buoys-time-series-55028.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='55029' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/mooring-buoys-time-series-55029.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='55030' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/mooring-buoys-time-series-55030.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='55032' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/mooring-buoys-time-series-55032.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='55033' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/mooring-buoys-time-series-55033.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='55036' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/mooring-buoys-time-series-55036.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='55038' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/mooring-buoys-time-series-55038.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/06/2021 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2021 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) 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.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='55045' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184058_15078263/mooring-buoys-time-series-55045.nc; -valid_qc=12578