mysql> use modbus;
Database changed
mysql> WHERE itemX + LAG(itemX) OVER (ORDER BY timestamp ASC) = 1;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE itemX + LAG(itemX) OVER (ORDER BY timestamp ASC) = 1' at line 1
mysql>

mysql> SHOW CREATE TABLE data;
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                                                                                                                                                                                   |
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| data  | CREATE TABLE `data` (
  `DATA_TIME_STAMP` datetime DEFAULT NULL,
  `ITEM1` tinyint(1) DEFAULT NULL,
  `ITEM2` tinyint(1) DEFAULT NULL,
  `ITEM3` tinyint(1) DEFAULT NULL,
  `ITEM4` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci |
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)

mysql>