View Source

A healthy observing system is vital for NWP. Observations are allowed to be used once their quality and impact are judged satisfactory. However the observing system is continuously evolving and it is important to monitor the quality and availability events. An automatic warning system is operated by ECMWF to flag data events that can potentially impact the quality of the analysis. Once flagged, events are investigated by scientists to evaluate the root cause and the potential impact. Actions are triggered when necessary. This interface provides a high level view of the status of the various of the observing system used at ECMWF. It uses a traffic light system to indicate the absence or presence of warnings. Additional details about each warning is available when selecting the data type in question. The interface is accessing the events automatically from ECMWF's observation events database. The last 24 hours status is shown by default but users can adjust the period if needed.

For each flagged anomaly, the automatic checking system assigns a severity level depending on how far statistics are from the expected values. When an anomaly persists over many data assimilation cycles the severity level is adjusted to highlight persistence.

The severity level categories:

Symbol	Description
⛔⛔⛔	Persistent anomaly in the severe category
⛔	Severe anomaly
✋✋✋	Considerable persistent anomaly
✋	Considerable anomaly
ℹ	Slight anomaly
✅	No anomalies detected

Satellites and Conventional Stations

Status

Data Type

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         WHEN Severity="Severe" THEN '⛔'           WHEN Severity="Severely" THEN '⛔'
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') +  INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND metops_tbl.Reportype between 7001 and 7022  AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'     order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND  metops_tbl.Reportype between 7001 and 7022   AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'    order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity,FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         WHEN Severity="Severe" THEN '⛔'  WHEN Severity="Severely" THEN '⛔'
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND ( metops_tbl.Reportype between 8001 and 8061 or metops_tbl.Reportype in (8034, 8041, 8043, 8051, 8052))   AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'    order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND  (metops_tbl.Reportype between 8001 and 8061 or metops_tbl.Reportype in (8034, 8041, 8043, 8051, 8052))    AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'    order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         WHEN Severity="Severe" THEN '⛔'           WHEN Severity="Severely" THEN '⛔'
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND metops_tbl.Reportype between 1 and 25   AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'    order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND  metops_tbl.Reportype between 1 and 25   AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'    order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         WHEN Severity="Severe" THEN '⛔'           WHEN Severity="Severely" THEN '⛔'
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10) AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND metops_tbl.Reportype BETWEEN 1001 AND 1010  AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'    order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND metops_tbl.Reportype BETWEEN 1001 AND 1010  AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'    order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         WHEN Severity="Severe" THEN '⛔'           WHEN Severity="Severely" THEN '⛔'
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND ((metops_tbl.Reportype BETWEEN 3001 and 3005) OR (metops_tbl.Reportype BETWEEN 44001 and 44005))  AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'    order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND ((metops_tbl.Reportype BETWEEN 3001 and 3005) OR  (metops_tbl.Reportype BETWEEN 44001 and 44005))  AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'    order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         WHEN Severity="Severe" THEN '⛔'           WHEN Severity="Severely" THEN '⛔'
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND metops_tbl.Reportype=42001    AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'    order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND metops_tbl.Reportype=42001  AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'    order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         WHEN Severity="Severe" THEN '⛔'           WHEN Severity="Severely" THEN '⛔'
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" or Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND metops_tbl.Reportype in (36001,36002)  AND 
metops_tbl.Stream="$stream" AND Data_stream='normal' order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist',  
'Severely','Considerably','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND  metops_tbl.Reportype in (36001,36002)  AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'    order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         WHEN Severity="Severe" THEN '⛔'           WHEN Severity="Severely" THEN '⛔'
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND (  metops_tbl.Reportype between 10001 and 10014 OR metops_tbl.Reportype between 13001 and 13004 OR metops_tbl.Reportype between 24001 and 24004)  AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'    order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND ( metops_tbl.Reportype between 10001 and 10014 OR metops_tbl.Reportype between 13001 and 13004 OR metops_tbl.Reportype between 24001 and 24004)  AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'    order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         WHEN Severity="Severe" THEN '⛔'           WHEN Severity="Severely" THEN '⛔'
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND (metops_tbl.Reportype in (5024,5087,5089,11001,11002,11003,35005,35007,35011,35017))    AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'    order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND (metops_tbl.Reportype in (5024,5087,5089,11001,11002,11003,35005,35007,35011,35017))  AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'    order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         WHEN Severity="Severe" THEN '⛔'           WHEN Severity="Severely" THEN '⛔'
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND metops_tbl.Reportype=12001    AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'    order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND metops_tbl.Reportype=12001  AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'    order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         WHEN Severity="Severe" THEN '⛔'           WHEN Severity="Severely" THEN '⛔'
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND ((metops_tbl.Reportype between 5001 and 5018) or (metops_tbl.Reportype between 5057 and 5058) or metops_tbl.Reportype in (5062,5068) or  (metops_tbl.Reportype between 5073 and 5079)  or metops_tbl.Reportype in (5084,5085))    AND 
metops_tbl.Stream="$stream" AND Data_stream='normal' order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND ((metops_tbl.Reportype between 5001 and 5018) or (metops_tbl.Reportype between 5057 and 5058) or metops_tbl.Reportype in (5062,5068) or  (metops_tbl.Reportype between 5073 and 5079)  or metops_tbl.Reportype in (5084,5085))  AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'    order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         WHEN Severity="Severe" THEN '⛔'           WHEN Severity="Severely" THEN '⛔'
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND (metops_tbl.Reportype between 4002 and 4025)    AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'    order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND (metops_tbl.Reportype between 4002 and 4025)  AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'    order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         WHEN Severity="Severe" THEN '⛔'           WHEN Severity="Severely" THEN '⛔'
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND metops_tbl.Reportype in (9005, 9007, 9011)    AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'    order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND metops_tbl.Reportype in (9005, 9007, 9011)  AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'    order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         WHEN Severity="Severe" THEN '⛔'           WHEN Severity="Severely" THEN '⛔'
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND ( metops_tbl.Reportype in (26001, 26002) OR metops_tbl.Reportype in (57001,57002))    AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'    order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND ( metops_tbl.Reportype in (26001, 26002) OR  metops_tbl.Reportype in (57001,57002))  AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'    order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         WHEN Severity="Severe" THEN '⛔'           WHEN Severity="Severely" THEN '⛔'
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND ( metops_tbl.Reportype in (34001, 34002) or (metops_tbl.Reportype between 49001 and 50001))    AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'    order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image> WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from (select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10) AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND ( metops_tbl.Reportype in (34001, 34002) or (metops_tbl.Reportype between 49001 and 50001) )   AND metops_tbl.Stream="$stream" AND Data_stream='normal' order by Cycle desc, StatID,Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity ) x group by StatID, Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         WHEN Severity="Severe" THEN '⛔'           WHEN Severity="Severely" THEN '⛔'
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND metops_tbl.Reportype in (25001)  AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'    order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND metops_tbl.Reportype in (25001) AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'    order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         WHEN Severity="Severe" THEN '⛔'           WHEN Severity="Severely" THEN '⛔'
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND metops_tbl.Reportype in (45001)  AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'    order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND metops_tbl.Reportype in (45001) AND 
metops_tbl.Stream="$stream"  AND Data_stream='normal'    order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND metops_tbl.Reportype in (16026,16089) AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND StatID <> '999' AND StatID <> '999999' AND StatID <> ''   AND Severity='Severely_persistent' order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND metops_tbl.Reportype in (16026,16089) AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND StatID <> '999' AND StatID <> '999999' AND StatID <> ''  AND Severity='Severely_persistent'  order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND ( metops_tbl.Reportype in (16001,16002,16003,16058,16076) ) AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND StatID <> '999' AND StatID <> '999999' AND StatID <> ''  AND Severity='Severely_persistent'  order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND  (metops_tbl.Reportype in (16001,16002,16003,16058,16076))  AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND StatID <> '999' AND StatID <> '999999' AND StatID <> ''  AND Severity='Severely_persistent'  order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND ( metops_tbl.Reportype in (16006,16007,16008,16009,16074) )  AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND StatID <> '999' AND StatID <> '999999' AND StatID <> ''  AND Severity='Severely_persistent'  order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND  metops_tbl.Reportype in (16006,16007,16008,16009,16074)  AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND StatID <> '999' AND StatID <> '999999' AND StatID <> ''  AND Severity='Severely_persistent'  order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND ( metops_tbl.Reportype in (16019,16024,16025,16046) ) AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND StatID <> '999' AND StatID <> '999999' AND StatID <> ''  AND Severity='Severely_persistent'  order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND metops_tbl.Reportype in (16019,16024,16025,16046) AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND StatID <> '999' AND StatID <> '999999' AND StatID <> ''  AND Severity='Severely_persistent'  order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND  ( metops_tbl.Reportype in (16015,16016,16017,16018) )  AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND StatID <> '999' AND StatID <> '999999' AND StatID <> ''  AND Severity='Severely_persistent'  order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND metops_tbl.Reportype in (16015,16016,16017,16018) AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND StatID <> '999' AND StatID <> '999999' AND StatID <> ''  AND Severity='Severely_persistent'  order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND metops_tbl.Reportype in (16005,16010,16011,16083,16084) AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND StatID <> '999' AND StatID <> '999999' AND StatID <> ''  AND Severity='Severely_persistent'  order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND  metops_tbl.Reportype in (16005,16010,16011,16083,16084)  AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND StatID <> '999' AND StatID <> '999999' AND StatID <> ''  AND Severity='Severely_persistent'  order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND ( metops_tbl.Reportype in (16004,16065) ) AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND StatID <> '999' AND StatID <> '999999' AND StatID <> ''  AND Severity='Severely_persistent'  order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND ( metops_tbl.Reportype in (16004,16065) ) AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND StatID <> '999' AND StatID <> '999999' AND StatID <> ''  AND Severity='Severely_persistent'  order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND ( metops_tbl.Reportype in (16068,16069,16075,16013,16014) ) AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND StatID <> '999' AND StatID <> '999999' AND StatID <> ''  AND Severity='Severely_persistent'  order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND metops_tbl.Reportype in (16068,16069,16075,16013,16014) AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND StatID <> '999' AND StatID <> '999999' AND StatID <> ''  AND Severity='Severely_persistent'  order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND  ( metops_tbl.Reportype in (16067,16030) )  AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND StatID <> '999' AND StatID <> '999999' AND StatID <> ''  AND Severity='Severely_persistent'  order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND  ( metops_tbl.Reportype in (16067,16030) ) AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND StatID <> '999' AND StatID <> '999999' AND StatID <> ''  AND Severity='Severely_persistent'  order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND ( metops_tbl.Reportype in (16029,16066,16082,16088,16089) ) AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND StatID <> '999' AND StatID <> '999999' AND StatID <> ''  AND Severity='Severely_persistent'  order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND metops_tbl.Reportype in (16029,16066,16082,16088,16089) AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND StatID <> '999' AND StatID <> '999999' AND StatID <> ''  AND Severity='Severely_persistent'  order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
 WHEN Severity="Severe" THEN '⛔' WHEN Severity="Severely" THEN '⛔'          
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND ( metops_tbl.Reportype in (16021,16022,16023,16045) ) AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND StatID <> '999' AND StatID <> '999999' AND StatID <> ''  AND Severity='Severely_persistent'  order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND metops_tbl.Reportype in (16021,16022,16023,16045) AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND StatID <> '999' AND StatID <> '999999' AND StatID <> ''  AND Severity='Severely_persistent'  order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

Conventional Over Large Areas

Status

Data Type

select CASE WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' WHEN Severity="Severe" THEN '⛔' WHEN Severity="Severely" THEN '⛔' WHEN Severity="Considerable" THEN '✋' WHEN Severity="Considerably" THEN '✋' WHEN Severity="Slightly" THEN 'ℹ' WHEN Severity="Slight" THEN 'ℹ' END from (select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10) AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND AlarmGroup in ("synop","rh2m") AND metops_tbl.Stream="$stream" AND Data_stream='normal' AND (StatID='999' OR StatID='' OR StatID='999999') AND Area!="" order by Cycle desc, StatID,Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity ) x group by StatID, Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND AlarmGroup in ("synop","rh2m") AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND (StatID='999' OR StatID='' OR StatID='999999') AND Area!="" order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity, Area order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         WHEN Severity="Severe" THEN '⛔'           WHEN Severity="Severely" THEN '⛔'         
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND AlarmGroup="ship" AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND (StatID='999' OR StatID='' OR StatID='999999')  AND Area!="" order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity, Area  order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10) AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND AlarmGroup="ship" AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND (StatID='999' OR StatID='' OR StatID='999999')  AND Area!="" order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity, Area  order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         WHEN Severity="Severe" THEN '⛔'           WHEN Severity="Severely" THEN '⛔'         
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND ( metops_tbl.Reportype in (16019,16024,16046) ) AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND (StatID='999' OR StatID='' OR StatID='999999') AND Area!="" order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity, Area order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND  metops_tbl.Reportype in (16019,16024,16046) AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND (StatID='999' OR StatID='' OR StatID='999999') AND Area!=""   order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity, Area order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         WHEN Severity="Severe" THEN '⛔'           WHEN Severity="Severely" THEN '⛔'         
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND  ( metops_tbl.Reportype in (16015,16016,16017,16018) )  AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND (StatID='999' OR StatID='' OR StatID='999999') AND Area!="" order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity, Area order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND ( metops_tbl.Reportype in (16015,16016,16017,16018) ) AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND (StatID='999' OR StatID='' OR StatID='999999') AND Area!="" order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity, Area order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         WHEN Severity="Severe" THEN '⛔'           WHEN Severity="Severely" THEN '⛔'         
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND AlarmGroup="buoy"  AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND (StatID='999' OR StatID='' OR StatID='999999') AND Area!=""  order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity, Area order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND AlarmGroup="buoy" AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND (StatID='999' OR StatID='' OR StatID='999999') AND Area!="" order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity, Area order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         WHEN Severity="Severe" THEN '⛔'           WHEN Severity="Severely" THEN '⛔'         
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND AlarmGroup="metar" AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND (StatID='999' OR StatID='' OR StatID='999999') AND Area!=""  order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity, Area order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND AlarmGroup="metar" AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND (StatID='999' OR StatID='' OR StatID='999999') AND Area!="" order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity, Area order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         WHEN Severity="Severe" THEN '⛔'           WHEN Severity="Severely" THEN '⛔'         
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND  AlarmGroup="pilot" AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND (StatID='999' OR StatID='' OR StatID='999999')  AND Area!="" order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity, Area order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND  AlarmGroup="pilot" AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND (StatID='999' OR StatID='' OR StatID='999999') AND Area!="" order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2,Severity,Area order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         WHEN Severity="Severe" THEN '⛔'           WHEN Severity="Severely" THEN '⛔'         
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
ELSE '<span class="status-macro aui-lozenge aui-lozenge-success">✓</span>' 
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND AlarmGroup="airep" AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  and (StatID='999' OR StatID='' OR StatID='999999') AND Area!="" order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity, Area order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND AlarmGroup="airep" AND 
metops_tbl.Stream="$stream" AND Data_stream='normal' AND (StatID='999' OR StatID='' OR StatID='999999') AND Area!=""  order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity, Area order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         WHEN Severity="Severe" THEN '⛔'           WHEN Severity="Severely" THEN '⛔'         
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND  ( metops_tbl.Reportype in (16030,16067) )  AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND (StatID='999' OR StatID='' OR StatID='999999')  order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND ( metops_tbl.Reportype in (16030,16067) ) AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND (StatID='999' OR StatID='' OR StatID='999999')  order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         WHEN Severity="Severe" THEN '⛔'           WHEN Severity="Severely" THEN '⛔'         
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
END from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND  (AlarmGroup="amdar" OR metops_tbl.Reportype in (16066)) AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND (StatID='999' OR StatID='' OR StatID='999999')  order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity, Area order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image> WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from (select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10) AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND (AlarmGroup="amdar" OR metops_tbl.Reportype in (16066))AND metops_tbl.Stream="$stream" AND Data_stream='normal' AND (StatID='999' OR StatID='' OR StatID='999999')  AND Area!="" order by Cycle desc, StatID,Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity ) x group by StatID, Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity, Area order BY FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle

select CASE
         WHEN Severity="Severely_persistent" THEN '⛔⛔⛔' WHEN Severity="Considerably_persist" THEN '✋✋✋' 
         WHEN Severity="Severe" THEN '⛔'           WHEN Severity="Severely" THEN '⛔'         
         WHEN Severity="Considerable" THEN '✋'           WHEN Severity="Considerably" THEN '✋'
         WHEN Severity="Slightly" THEN 'ℹ'           WHEN Severity="Slight" THEN 'ℹ'
 END  from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND AlarmGroup="Radiosondes"  AND metops_tbl.Reportype not in (16019,16024,16025,16046) AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND (StatID='999' OR StatID='' OR StatID='999999') and Area!=""   order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity, Area order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle  LIMIT 1

select Cycle as 'Date/Time',DataLongName as 'Report Description',Type_event as 'Event Type',Obs_quantity as 'Anomaly 
Type',Severity,NbrPastOccurences as 'Alarm Frequency',REPLACE(Area, 'WMO BLOCK', '<ac:image ac:alt="" ac:height="15" ac:thumbnail="true"><ri:url ri:value="https://confluence.ecmwf.int/download/attachments/228860513/WMO_BLOCKS.gif"/></ac:image>  WMO BLOCK') as Area,Reportype as 'Report Type',CASE WHEN (Plot="none") THEN "N/A" ELSE CONCAT('<ac:image ac:alt="" ac:height="38" ac:thumbnail="true"><ri:url ri:value="https://charts.ecmwf.int/opencharts-api/v1/packages/satellite_alerts/products/satellite_alert/get/?alert=',TRIM(REPLACE(Plot, '\n', '')),'"/></ac:image>') END as Plot from 
(select * from metops_tbl WHERE  id=1 AND  Severity in ('Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') AND metops_tbl.Cycle >SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + 
 INTERVAL $period hour + 0,1,10) AND metops_tbl.Cycle <=SUBSTRING(CONCAT("$date"," ","$cycle",':00:00') + INTERVAL 0 hour + 0,1,10)  AND SUBSTRING(metops_tbl.Cycle,9,10) in ($s2) AND  AlarmGroup="Radiosondes" AND  metops_tbl.Reportype not in (16019,16024,16025,16046)  AND 
metops_tbl.Stream="$stream" AND Data_stream='normal'  AND (StatID='999' OR StatID='' OR StatID='999999') AND Area!="" order by Cycle desc, StatID,Reportype, 
Obs_quantity, varno, Vertco1,Vertco2, Severity  ) x group by StatID, 
Reportype, Obs_quantity, varno, Vertco1,Vertco2, Severity, Area order BY 
FIELD(Severity, 'Severely_persistent','Considerably_persist', 'Severely','Severe','Considerably','Considerable','Slightly','Slight') ASC, Severity,Cycle