Query for PSNM returned no results
Query for AHMD returned no results
Query for HUAN returned no results
Query for DJON returned no results
The following query for ESOI returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM ESOI_ori WHERE start_date_time >='2001-04-18 01:00:00' AND start_date_time < '2001-04-18 12:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC
Query for TSMB returned no results
The following query for ATHN returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM ATHN_ori WHERE start_date_time >='2001-04-18 01:00:00' AND start_date_time < '2001-04-18 12:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC
The following query for MXCO returned 132 rows
SELECT start_date_time,measured_corr_for_efficiency AS corr_for_efficiency FROM MXCO_ori WHERE start_date_time >='2001-04-18 01:00:00' AND start_date_time < '2001-04-18 12:00:00' ORDER BY start_date_time ASC
Query for ARNM returned no results
Query for NANM returned no results
Query for PTFM returned no results
Query for CALM returned no results
The following query for ROME returned 132 rows
SELECT start_date_time,measured_corr_for_efficiency AS corr_for_efficiency FROM ROME_ori WHERE start_date_time >='2001-04-18 01:00:00' AND start_date_time < '2001-04-18 12:00:00' ORDER BY start_date_time ASC
Query for AATA returned no results
The following query for AATB returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM AATB_ori WHERE start_date_time >='2001-04-18 01:00:00' AND start_date_time < '2001-04-18 12:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC
Query for BKSN returned no results
Query for HRMS returned no results
Query for JUNG returned no results
Query for JUNG1 returned no results
Query for ZUGS returned no results
Query for UFSZ returned no results
The following query for LMKS returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM LMKS_ori WHERE start_date_time >='2001-04-18 01:00:00' AND start_date_time < '2001-04-18 12:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC
Query for IRK2 returned no results
Query for IRK3 returned no results
Query for IRKT returned no results
The following query for DRBS returned 44 rows
SELECT start_date_time,measured_corr_for_efficiency AS corr_for_efficiency FROM DRBS_ori WHERE start_date_time >='2001-04-18 01:00:00' AND start_date_time < '2001-04-18 12:00:00' ORDER BY start_date_time ASC
Query for CLMX returned no results
Query for NVBK returned no results
Query for MCRL returned no results
The following query for MOSC returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM MOSC_ori WHERE start_date_time >='2001-04-18 01:00:00' AND start_date_time < '2001-04-18 12:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC
The following query for NEWK returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM NEWK_ori WHERE start_date_time >='2001-04-18 01:00:00' AND start_date_time < '2001-04-18 12:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC
The following query for KIEL returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM KIEL_ori WHERE start_date_time >='2001-04-18 01:00:00' AND start_date_time < '2001-04-18 12:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC
Query for KIEL2 returned no results
Query for MGDN returned no results
Query for KGSN returned no results
The following query for YKTK returned 132 rows
SELECT start_date_time,measured_corr_for_efficiency AS corr_for_efficiency FROM YKTK_ori WHERE start_date_time >='2001-04-18 01:00:00' AND start_date_time < '2001-04-18 12:00:00' ORDER BY start_date_time ASC
The following query for KERG returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM KERG_ori WHERE start_date_time >='2001-04-18 01:00:00' AND start_date_time < '2001-04-18 12:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC
The following query for CALG returned 132 rows
SELECT start_date_time,measured_corr_for_efficiency AS corr_for_efficiency FROM CALG_ori WHERE start_date_time >='2001-04-18 01:00:00' AND start_date_time < '2001-04-18 12:00:00' ORDER BY start_date_time ASC
The following query for OULU returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(subq.start_date_time))+86400*(TO_DAYS(subq.start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(subq.corr_for_efficiency) AS corr_for_efficiency FROM (SELECT o.start_date_time, CASE WHEN r.start_date_time IS NULL THEN o.measured_corr_for_efficiency ELSE r.revised_corr_for_efficiency END AS corr_for_efficiency FROM OULU_ori o LEFT JOIN OULU_rev r ON o.start_date_time = r.start_date_time WHERE o.start_date_time >= '2001-04-18 01:00:00' AND o.start_date_time < '2001-04-18 12:00:00' ORDER BY start_date_time ASC) AS subq GROUP BY FLOOR((TIME_TO_SEC(TIME(subq.start_date_time))+86400*TO_DAYS(subq.start_date_time))/(60*2)) ORDER BY start_date_time ASC
Query for SANB returned no results
Query for SNAE returned no results
The following query for APTY returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM APTY_ori WHERE start_date_time >='2001-04-18 01:00:00' AND start_date_time < '2001-04-18 12:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC
Query for NRLK returned no results
The following query for TXBY returned 132 rows
SELECT start_date_time,measured_corr_for_efficiency AS corr_for_efficiency FROM TXBY_ori WHERE start_date_time >='2001-04-18 01:00:00' AND start_date_time < '2001-04-18 12:00:00' ORDER BY start_date_time ASC
The following query for FSMT returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM FSMT_ori WHERE start_date_time >='2001-04-18 01:00:00' AND start_date_time < '2001-04-18 12:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC
Query for INVK returned no results
Query for JBGO returned no results
The following query for MCMU returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM MCMU_ori WHERE start_date_time >='2001-04-18 01:00:00' AND start_date_time < '2001-04-18 12:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC
The following query for NAIN returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM NAIN_ori WHERE start_date_time >='2001-04-18 01:00:00' AND start_date_time < '2001-04-18 12:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC
The following query for PWNK returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM PWNK_ori WHERE start_date_time >='2001-04-18 01:00:00' AND start_date_time < '2001-04-18 12:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC
Query for THUL returned no results
Query for MWSB returned no results
Query for MWSN returned no results
Query for NEU3 returned no results
The following query for SOPB returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM SOPB_ori WHERE start_date_time >='2001-04-18 01:00:00' AND start_date_time < '2001-04-18 12:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC
The following query for SOPO returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM SOPO_ori WHERE start_date_time >='2001-04-18 01:00:00' AND start_date_time < '2001-04-18 12:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC
Query for MRNY returned no results
Query for DOMB returned no results
Query for DOMC returned no results
The following query for TERA returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM TERA_ori WHERE start_date_time >='2001-04-18 01:00:00' AND start_date_time < '2001-04-18 12:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC