Wrong result in Machine SCADA Expert SQL query.

[Anonymous user]

Hello

I am making a SQL query to a MySQL database. 

When I run the query in MySQL, I get the right result. 

When I send the SQL statement from Machine SCADA Expert, the result is not right. 
It is like the lase WHERE clause is ignored. 

This is the Query: 

SELECT SUM(Minute_In_State) From
   (SELECT
   Time_Stamp,
   State,
   TIMESTAMPDIFF(SECOND, LAG(Time_Stamp) OVER(ORDER BY Time_Stamp), Time_Stamp)
   AS Minute_In_State
   FROM db.xyz_1_state
   ORDER BY Time_Stamp) AS T
Where State = 1;

Any suggestion why the result is different, when sent from Machine SCADA Expert?

[BevanWeiss · Accepted solution]

This is the Geo SCADA Expert forum.  So you're not that likely to get great results looking for Machine SCADA Expert info here (since they are different products).

I think you wanted this forum instead: https://community.se.com/t5/Industry-Automation-and-Control/bd-p/industry-automation-control_forum

[Anonymous user]

Oh Ok. 

Thanks!!