Запросы 2TE25KM

+1_______________ExceedingTractiveCapacity (Превышена мощность тягового генератора)
При  SpeedEngine = "не 0" И PowerMeasured = "не 0" И CurrentCompressorMotor =  0 значение и
(PowerMeasured > 140 при PosKM = 1 ИЛИ PowerMeasured > 240 при PosKM = 2 ИЛИ
PowerMeasured > 345 при PosKM = 3 ИЛИ PowerMeasured > 590 при PosKM = 4 ИЛИ
PowerMeasured > 958 при PosKM = 5 ИЛИ PowerMeasured > 1130 при PosKM = 6 ИЛИ
PowerMeasured > 1233 при PosKM = 7 ИЛИ PowerMeasured > 1388 при PosKM = 8 ИЛИ
PowerMeasured > 1405 при PosKM = 9 ИЛИ PowerMeasured > 1515 при PosKM = 10 ИЛИ
PowerMeasured > 1688 при PosKM = 11 ИЛИ PowerMeasured > 1858 при PosKM = 12 ИЛИ
PowerMeasured > 2030 при PosKM = 13 ИЛИ PowerMeasured > 2157 при PosKM = 14 ИЛИ
PowerMeasured > 2283 при PosKM = 15)  на протяжении времени более 30 секунд

SELECT {select_fields},{SpeedEngine},{PowerMeasured},{CurrentCompressorMotor},{PosKM},
MAX(rule) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 30 FOLLOWING ) AS {rule_field}
FROM (
SELECT *,
  CASE
        WHEN sum_params_perform=31.0 THEN 1
        ELSE 0
    END
        rule
FROM (
SELECT *,
  SUM(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN 30 PRECEDING AND CURRENT ROW) AS sum_params_perform
FROM (
SELECT *,
	CASE
		WHEN CAST({SpeedEngine} AS FLOAT)!=0.0 AND CAST({CurrentCompressorMotor} AS FLOAT)=0.0 AND
		((CAST({PowerMeasured} AS FLOAT)>140.0 AND CAST({PosKM} AS FLOAT)=1.0) OR (CAST({PowerMeasured} AS FLOAT)>240.0 AND CAST({PosKM} AS FLOAT)=2.0) OR
		(CAST({PowerMeasured} AS FLOAT)>345.0 AND CAST({PosKM} AS FLOAT)=3.0) OR (CAST({PowerMeasured} AS FLOAT)>590.0 AND CAST({PosKM} AS FLOAT)=4.0) OR
		(CAST({PowerMeasured} AS FLOAT)>958.0 AND CAST({PosKM} AS FLOAT)=5.0) OR (CAST({PowerMeasured} AS FLOAT)>1130.0 AND CAST({PosKM} AS FLOAT)=6.0) OR
		(CAST({PowerMeasured} AS FLOAT)>1233.0 AND CAST({PosKM} AS FLOAT)=7.0) OR (CAST({PowerMeasured} AS FLOAT)>1388.0 AND CAST({PosKM} AS FLOAT)=8.0) OR
		(CAST({PowerMeasured} AS FLOAT)>1405.0 AND CAST({PosKM} AS FLOAT)=9.0) OR (CAST({PowerMeasured} AS FLOAT)>1515.0 AND CAST({PosKM} AS FLOAT)=10.0) OR
		(CAST({PowerMeasured} AS FLOAT)>1688.0 AND CAST({PosKM} AS FLOAT)=11.0) OR (CAST({PowerMeasured} AS FLOAT)>1858.0 AND CAST({PosKM} AS FLOAT)=12.0) OR
		(CAST({PowerMeasured} AS FLOAT)>2030.0 AND CAST({PosKM} AS FLOAT)=13.0) OR (CAST({PowerMeasured} AS FLOAT)>2157.0 AND CAST({PosKM} AS FLOAT)=14.0) OR
		(CAST({PowerMeasured} AS FLOAT)>2283.0 AND CAST({PosKM} AS FLOAT)=15.0)) THEN 1.0
		ELSE 0.0
	END
		params_perform
FROM  {table})))