DROP TABLE IF EXISTS `transactions`; CREATE TABLE `transactions` ( `ID` bigint(20) NOT NULL, `subclass` varchar(20) NOT NULL, `offline` bit(1) DEFAULT NULL, `type` int(11) DEFAULT NULL, `authorized` bit(1) DEFAULT NULL, `state_code` int(11) DEFAULT NULL, `auth_name` varchar(10) DEFAULT NULL, `reversed` bit(1) DEFAULT NULL, `reversable` bit(1) DEFAULT NULL, `trace` int(11) DEFAULT NULL, `date` datetime DEFAULT NULL, `retriable` bit(1) DEFAULT NULL, `amount` decimal(15,3) DEFAULT NULL, `ticket` bigint(20) DEFAULT NULL, `batch_id` bigint(20) DEFAULT NULL, `acquirer_terminal` bigint(20) DEFAULT NULL, `product_code` int(11) DEFAULT NULL, `original_transaction_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `idx_transactions2` (`acquirer_terminal`,`reversable`,`reversed`,`state_code`,`authorized`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; --disable_query_log INSERT INTO `transactions` VALUES (203871,'TRANSACTION','\0',10,'',3,NULL,'\0','',1,'2009-03-05 17:51:57','\0','1.000',1,15846,34007,0,NULL),(203908,'TRANSACTION','\0',10,'',3,NULL,'\0','',2,'2009-03-05 17:52:57','\0','1.000',2,15846,34007,0,NULL),(203929,'TRANSACTION','\0',10,'',3,NULL,'\0','',3,'2009-03-05 17:53:49','\0','1.000',3,15846,34007,0,NULL),(203951,'TRANSACTION','\0',10,'',3,NULL,'\0','',4,'2009-03-05 17:54:32','\0','1.000',4,15846,34007,0,NULL),(204107,'TRANSACTION','\0',10,'',3,NULL,'\0','',5,'2009-03-05 18:00:15','\0','1.000',5,15846,34007,0,NULL),(204139,'TRANSACTION','\0',11,'',3,NULL,'\0','',6,'2009-03-05 18:01:24','\0','1.000',6,15846,34007,0,NULL),(237501,'TRANSACTION','\0',3,'\0',2,NULL,'\0','\0',7,'2009-03-09 09:47:01','\0','1.000',7,15846,34007,0,NULL),(237509,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',8,'2009-03-09 09:47:38','\0','1.000',7,15846,34007,0,NULL),(237522,'TRANSACTION','\0',10,'',3,NULL,'\0','',9,'2009-03-09 09:48:15','\0','1.000',7,15846,34007,0,NULL),(237579,'TRANSACTION','\0',3,'\0',2,NULL,'\0','\0',10,'2009-03-09 09:51:54','\0','1.000',8,15846,34007,0,NULL),(237594,'TRANSACTION','\0',10,'',3,NULL,'\0','',11,'2009-03-09 09:52:34','\0','1.000',8,15846,34007,0,NULL),(238860,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',12,'2009-03-09 10:50:34','\0','1.000',9,15846,34007,0,NULL),(238881,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',13,'2009-03-09 10:51:31','\0','1.000',9,15846,34007,0,NULL),(238894,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',14,'2009-03-09 10:52:11','\0','1.000',9,15846,34007,0,NULL),(238907,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',15,'2009-03-09 10:52:58','\0','1.000',9,15846,34007,0,NULL),(239694,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',16,'2009-03-09 11:29:23','\0','1.000',9,15846,34007,0,NULL),(239699,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',17,'2009-03-09 11:29:51','\0','1.000',9,15846,34007,0,NULL),(239711,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',18,'2009-03-09 11:30:23','\0','1.000',9,15846,34007,0,NULL),(239730,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',19,'2009-03-09 11:31:20','\0','1.000',9,15846,34007,0,NULL),(239736,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',20,'2009-03-09 11:31:46','\0','1.000',9,15846,34007,0,NULL),(239966,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',21,'2009-03-09 11:42:31','\0','1.000',9,15846,34007,0,NULL),(240485,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',22,'2009-03-09 12:09:22','\0','1.000',9,15846,34007,0,NULL),(240523,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',23,'2009-03-09 12:11:18','\0','1.000',9,15846,34007,0,NULL),(240538,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',24,'2009-03-09 12:12:07','\0','1.000',9,15846,34007,0,NULL),(240546,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',25,'2009-03-09 12:12:40','\0','1.000',9,15846,34007,0,NULL),(240636,'TRANSACTION','\0',3,'\0',2,NULL,'\0','\0',26,'2009-03-09 12:16:15','\0','1.000',9,15846,34007,0,NULL),(240677,'TRANSACTION','\0',3,'\0',2,NULL,'\0','\0',27,'2009-03-09 12:17:53','\0','1.000',9,15846,34007,0,NULL),(241979,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',28,'2009-03-09 13:24:53','\0','1.000',9,15846,34007,0,NULL),(242093,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',29,'2009-03-09 13:29:34','\0','1.000',9,15846,34007,0,NULL),(242106,'TRANSACTION','\0',10,'',3,NULL,'\0','',30,'2009-03-09 13:30:06','\0','1.000',9,15846,34007,0,NULL),(242167,'TRANSACTION','\0',10,'',3,NULL,'\0','',31,'2009-03-09 13:32:31','\0','1.000',10,15846,34007,0,NULL),(242196,'TRANSACTION','\0',10,'',3,NULL,'\0','',32,'2009-03-09 13:33:57','\0','1.000',11,15846,34007,0,NULL),(242218,'TRANSACTION','\0',10,'',3,NULL,'\0','',33,'2009-03-09 13:35:23','\0','1.000',12,15846,34007,0,NULL),(242243,'TRANSACTION','\0',10,'',3,NULL,'\0','',34,'2009-03-09 13:36:43','\0','1.000',13,15846,34007,0,NULL),(242273,'TRANSACTION','\0',10,'',3,NULL,'\0','',35,'2009-03-09 13:38:08','\0','1.000',14,15846,34007,0,NULL),(242308,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',36,'2009-03-09 13:40:08','\0','1.000',15,15846,34007,0,NULL),(242323,'TRANSACTION','\0',10,'',3,NULL,'\0','',37,'2009-03-09 13:40:52','\0','1.000',15,15846,34007,0,NULL),(242375,'TRANSACTION','\0',10,'',3,NULL,'\0','',38,'2009-03-09 13:43:00','\0','1.000',16,15846,34007,0,NULL),(242406,'TRANSACTION','\0',10,'',3,NULL,'\0','',39,'2009-03-09 13:44:32','\0','1.000',17,15846,34007,0,NULL),(242455,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',40,'2009-03-09 13:46:27','\0','1.000',18,15846,34007,0,NULL),(242470,'TRANSACTION','\0',10,'',3,NULL,'\0','',41,'2009-03-09 13:47:12','\0','1.000',18,15846,34007,0,NULL),(242513,'TRANSACTION','\0',10,'',3,NULL,'\0','',42,'2009-03-09 13:49:00','\0','1.000',19,15846,34007,0,NULL),(242882,'TRANSACTION','\0',10,'',3,NULL,'\0','',43,'2009-03-09 14:06:10','\0','1.000',20,15846,34007,0,NULL),(242937,'TRANSACTION','\0',10,'',3,NULL,'\0','',44,'2009-03-09 14:08:38','\0','1.000',21,15846,34007,0,NULL),(243046,'TRANSACTION','\0',10,'',3,NULL,'\0','',45,'2009-03-09 14:13:19','\0','1.000',22,15846,34007,0,NULL),(243115,'TRANSACTION','\0',10,'',3,NULL,'\0','',46,'2009-03-09 14:16:04','\0','1.000',23,15846,34007,0,NULL),(243145,'TRANSACTION','\0',10,'',3,NULL,'\0','',47,'2009-03-09 14:17:35','\0','1.000',24,15846,34007,0,NULL),(243188,'TRANSACTION','\0',10,'',3,NULL,'\0','',48,'2009-03-09 14:19:20','\0','1.000',25,15846,34007,0,NULL),(243224,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',49,'2009-03-09 14:20:45','\0','1.000',26,15846,34007,0,NULL),(243230,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',50,'2009-03-09 14:21:05','\0','1.000',26,15846,34007,0,NULL),(243239,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',51,'2009-03-09 14:21:29','\0','1.000',26,15846,34007,0,NULL),(243249,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',52,'2009-03-09 14:21:59','\0','1.000',26,15846,34007,0,NULL),(243287,'TRANSACTION','\0',10,'',3,NULL,'\0','',53,'2009-03-09 14:24:05','\0','1.000',26,15846,34007,0,NULL),(243330,'TRANSACTION','\0',10,'',3,NULL,'\0','',54,'2009-03-09 14:25:34','\0','1.000',27,15846,34007,0,NULL),(243361,'TRANSACTION','\0',10,'',3,NULL,'\0','',55,'2009-03-09 14:26:51','\0','1.000',28,15846,34007,0,NULL),(243391,'TRANSACTION','\0',10,'',3,NULL,'\0','',56,'2009-03-09 14:28:16','\0','1.000',29,15846,34007,0,NULL),(243485,'TRANSACTION','\0',10,'',3,NULL,'\0','',57,'2009-03-09 14:31:29','\0','1.000',30,15846,34007,0,NULL),(243526,'TRANSACTION','\0',10,'',3,NULL,'\0','',58,'2009-03-09 14:33:01','\0','1.000',31,15846,34007,0,NULL),(243647,'TRANSACTION','\0',10,'',3,NULL,'\0','',59,'2009-03-09 14:37:56','\0','1.000',32,15846,34007,0,NULL),(243694,'TRANSACTION','\0',10,'',3,NULL,'\0','',60,'2009-03-09 14:39:38','\0','1.000',33,15846,34007,0,NULL),(243800,'TRANSACTION','\0',10,'',3,NULL,'\0','',61,'2009-03-09 14:44:02','\0','1.000',34,15846,34007,0,NULL),(243839,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',62,'2009-03-09 14:45:27','\0','1.000',35,15846,34007,0,NULL),(243855,'TRANSACTION','\0',10,'',3,NULL,'\0','',63,'2009-03-09 14:45:57','\0','1.000',35,15846,34007,0,NULL),(243905,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',64,'2009-03-09 14:47:46','\0','1.000',36,15846,34007,0,NULL),(243913,'TRANSACTION','\0',10,'',3,NULL,'\0','',65,'2009-03-09 14:48:04','\0','1.000',36,15846,34007,0,NULL),(243951,'TRANSACTION','\0',10,'',3,NULL,'\0','',66,'2009-03-09 14:49:20','\0','1.000',37,15846,34007,0,NULL),(243999,'TRANSACTION','\0',10,'',3,NULL,'\0','',67,'2009-03-09 14:50:42','\0','1.000',38,15846,34007,0,NULL),(244027,'TRANSACTION','\0',10,'',3,NULL,'\0','',68,'2009-03-09 14:51:57','\0','1.000',39,15846,34007,0,NULL),(244056,'TRANSACTION','\0',10,'',3,NULL,'\0','',69,'2009-03-09 14:53:17','\0','1.000',40,15846,34007,0,NULL),(244144,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',70,'2009-03-09 14:56:37','\0','1.000',41,15846,34007,0,NULL),(244158,'TRANSACTION','\0',10,'',3,NULL,'\0','',71,'2009-03-09 14:57:14','\0','1.000',41,15846,34007,0,NULL),(244259,'TRANSACTION','\0',10,'',3,NULL,'\0','',72,'2009-03-09 15:01:33','\0','1.000',42,15846,34007,0,NULL),(244308,'TRANSACTION','\0',10,'',3,NULL,'\0','',73,'2009-03-09 15:03:25','\0','1.000',43,15846,34007,0,NULL),(244335,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',74,'2009-03-09 15:04:51','\0','1.000',44,15846,34007,0,NULL),(244355,'TRANSACTION','\0',10,'',3,NULL,'\0','',75,'2009-03-09 15:05:39','\0','1.000',44,15846,34007,0,NULL),(244383,'TRANSACTION','\0',10,'',3,NULL,'\0','',76,'2009-03-09 15:07:03','\0','1.000',45,15846,34007,0,NULL),(244507,'TRANSACTION','\0',10,'',3,NULL,'\0','',77,'2009-03-09 15:12:06','\0','1.000',46,15846,34007,0,NULL),(244587,'TRANSACTION','\0',10,'',3,NULL,'\0','',78,'2009-03-09 15:15:15','\0','1.000',47,15846,34007,0,NULL),(244633,'TRANSACTION','\0',10,'',3,NULL,'\0','',79,'2009-03-09 15:16:52','\0','1.000',48,15846,34007,0,NULL),(244671,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',80,'2009-03-09 15:18:24','\0','1.000',49,15846,34007,0,NULL),(244678,'TRANSACTION','\0',10,'',3,NULL,'\0','',81,'2009-03-09 15:18:43','\0','1.000',49,15846,34007,0,NULL),(244716,'TRANSACTION','\0',10,'',3,NULL,'\0','',82,'2009-03-09 15:20:28','\0','1.000',50,15846,34007,0,NULL),(244754,'TRANSACTION','\0',10,'',3,NULL,'\0','',83,'2009-03-09 15:22:02','\0','1.000',51,15846,34007,0,NULL),(244817,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',84,'2009-03-09 15:24:01','\0','1.000',52,15846,34007,0,NULL),(244829,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',85,'2009-03-09 15:24:36','\0','1.000',52,15846,34007,0,NULL),(244854,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',86,'2009-03-09 15:25:12','\0','1.000',52,15846,34007,0,NULL),(244887,'TRANSACTION','\0',10,'',3,NULL,'\0','',87,'2009-03-09 15:26:23','\0','1.000',52,15846,34007,0,NULL),(244920,'TRANSACTION','\0',10,'',3,NULL,'\0','',88,'2009-03-09 15:27:32','\0','1.000',53,15846,34007,0,NULL),(244966,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',89,'2009-03-09 15:28:46','\0','1.000',54,15846,34007,0,NULL),(244978,'TRANSACTION','\0',10,'',3,NULL,'\0','',90,'2009-03-09 15:29:15','\0','1.000',54,15846,34007,0,NULL),(245021,'TRANSACTION','\0',10,'',3,NULL,'\0','',91,'2009-03-09 15:30:57','\0','1.000',55,15846,34007,0,NULL),(245085,'TRANSACTION','\0',10,'',3,NULL,'\0','',92,'2009-03-09 15:33:04','\0','1.000',56,15846,34007,0,NULL),(245117,'TRANSACTION','\0',10,'',3,NULL,'\0','',93,'2009-03-09 15:34:13','\0','1.000',57,15846,34007,0,NULL),(245152,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',94,'2009-03-09 15:35:43','\0','1.000',58,15846,34007,0,NULL),(245164,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',95,'2009-03-09 15:36:12','\0','1.000',58,15846,34007,0,NULL),(245181,'TRANSACTION','\0',10,'',3,NULL,'\0','',96,'2009-03-09 15:36:47','\0','1.000',58,15846,34007,0,NULL),(245230,'TRANSACTION','\0',10,'',3,NULL,'\0','',97,'2009-03-09 15:38:15','\0','1.000',59,15846,34007,0,NULL),(245291,'TRANSACTION','\0',10,'',3,NULL,'\0','',98,'2009-03-09 15:40:20','\0','1.000',60,15846,34007,0,NULL),(245315,'TRANSACTION','\0',10,'',3,NULL,'\0','',99,'2009-03-09 15:41:34','\0','1.000',61,15846,34007,0,NULL),(245360,'TRANSACTION','\0',10,'',3,NULL,'\0','',100,'2009-03-09 15:43:07','\0','1.000',62,15846,34007,0,NULL),(245395,'TRANSACTION','\0',10,'',3,NULL,'\0','',101,'2009-03-09 15:44:22','\0','1.000',63,15846,34007,0,NULL),(245425,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',102,'2009-03-09 15:45:45','\0','1.000',64,15846,34007,0,NULL),(245509,'TRANSACTION','\0',10,'',3,NULL,'\0','',103,'2009-03-09 15:48:38','\0','1.000',64,15846,34007,0,NULL),(245555,'TRANSACTION','\0',10,'',3,NULL,'\0','',104,'2009-03-09 15:49:57','\0','1.000',65,15846,34007,0,NULL),(245588,'TRANSACTION','\0',10,'',3,NULL,'\0','',105,'2009-03-09 15:51:15','\0','1.000',66,15846,34007,0,NULL),(245629,'TRANSACTION','\0',10,'',3,NULL,'\0','',106,'2009-03-09 15:52:42','\0','1.000',67,15846,34007,0,NULL),(245674,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',107,'2009-03-09 15:54:18','\0','1.000',68,15846,34007,0,NULL),(245695,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',108,'2009-03-09 15:54:54','\0','1.000',68,15846,34007,0,NULL),(245780,'TRANSACTION','\0',10,'',3,NULL,'\0','',109,'2009-03-09 15:58:05','\0','1.000',68,15846,34007,0,NULL),(245829,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',110,'2009-03-09 15:59:31','\0','1.000',69,15846,34007,0,NULL),(245859,'TRANSACTION','\0',10,'',3,NULL,'\0','',111,'2009-03-09 16:00:32','\0','1.000',69,15846,34007,0,NULL),(245891,'TRANSACTION','\0',10,'',3,NULL,'\0','',112,'2009-03-09 16:01:54','\0','1.000',70,15846,34007,0,NULL),(245928,'TRANSACTION','\0',10,'',3,NULL,'\0','',113,'2009-03-09 16:03:31','\0','1.000',71,15846,34007,0,NULL),(245975,'TRANSACTION','\0',10,'',3,NULL,'\0','',114,'2009-03-09 16:05:06','\0','1.000',72,15846,34007,0,NULL),(246024,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',115,'2009-03-09 16:06:54','\0','1.000',73,15846,34007,0,NULL),(246032,'TRANSACTION','\0',10,'',3,NULL,'\0','',116,'2009-03-09 16:07:25','\0','1.000',73,15846,34007,0,NULL),(246073,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',117,'2009-03-09 16:08:46','\0','1.000',74,15846,34007,0,NULL),(246085,'TRANSACTION','\0',3,'\0',2,NULL,'\0','\0',118,'2009-03-09 16:09:03','\0','1.000',74,15846,34007,0,NULL),(246098,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',119,'2009-03-09 16:09:31','\0','1.000',74,15846,34007,0,NULL),(246110,'TRANSACTION','\0',10,'',3,NULL,'\0','',120,'2009-03-09 16:09:55','\0','1.000',74,15846,34007,0,NULL),(246156,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',121,'2009-03-09 16:11:24','\0','1.000',75,15846,34007,0,NULL),(246174,'TRANSACTION','\0',10,'',3,NULL,'\0','',122,'2009-03-09 16:12:14','\0','1.000',75,15846,34007,0,NULL),(246377,'TRANSACTION','\0',3,'\0',2,NULL,'\0','\0',123,'2009-03-09 16:19:38','\0','1.000',76,15846,34007,0,NULL),(246397,'TRANSACTION','\0',10,'',3,NULL,'\0','',124,'2009-03-09 16:20:24','\0','1.000',76,15846,34007,0,NULL),(246556,'TRANSACTION','\0',10,'',3,NULL,'\0','',125,'2009-03-09 16:26:32','\0','1.000',77,15846,34007,0,NULL),(246763,'TRANSACTION','\0',10,'',3,NULL,'\0','',126,'2009-03-09 16:34:29','\0','1.000',78,15846,34007,0,NULL),(247524,'TRANSACTION','\0',10,'',3,NULL,'\0','',127,'2009-03-09 17:02:13','\0','1.000',79,15846,34007,0,NULL),(247709,'TRANSACTION','\0',10,'',3,NULL,'\0','',128,'2009-03-09 17:08:24','\0','1.000',80,15846,34007,0,NULL),(254095,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',129,'2009-03-10 09:48:18','\0','1.000',81,15846,34007,0,NULL),(254160,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',130,'2009-03-10 09:50:49','\0','1.000',81,15846,34007,0,NULL),(254231,'TRANSACTION','\0',10,'',3,NULL,'\0','',131,'2009-03-10 09:54:38','\0','1.000',81,15846,34007,0,NULL),(254858,'TRANSACTION','\0',10,'',3,NULL,'\0','',132,'2009-03-10 10:23:09','\0','1.000',82,15846,34007,0,NULL),(255018,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',133,'2009-03-10 10:29:48','\0','1.000',83,15846,34007,0,NULL),(255026,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',134,'2009-03-10 10:30:09','\0','1.000',83,15846,34007,0,NULL),(255032,'TRANSACTION','\0',10,'',3,NULL,'\0','',135,'2009-03-10 10:30:26','\0','1.000',83,15846,34007,0,NULL),(255350,'TRANSACTION','\0',10,'',3,NULL,'\0','',136,'2009-03-10 10:44:20','\0','1.000',84,15846,34007,0,NULL),(257665,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',137,'2009-03-10 12:44:53','\0','1.000',85,15846,34007,0,NULL),(257677,'TRANSACTION','\0',10,'',3,NULL,'\0','',138,'2009-03-10 12:45:20','\0','1.000',87,15846,34007,0,NULL),(258230,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',139,'2009-03-10 13:13:58','\0','1.000',88,15846,34007,0,NULL),(258248,'TRANSACTION','\0',10,'',3,NULL,'\0','',140,'2009-03-10 13:14:24','\0','1.000',90,15846,34007,0,NULL),(258275,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',141,'2009-03-10 13:15:46','\0','1.000',91,15846,34007,0,NULL),(258285,'TRANSACTION','\0',10,'',3,NULL,'\0','',142,'2009-03-10 13:16:11','\0','1.000',93,15846,34007,0,NULL),(258330,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',143,'2009-03-10 13:17:52','\0','1.000',94,15846,34007,0,NULL),(258351,'TRANSACTION','\0',10,'',3,NULL,'\0','',144,'2009-03-10 13:18:21','\0','1.000',96,15846,34007,0,NULL),(258378,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',145,'2009-03-10 13:19:44','\0','1.000',97,15846,34007,0,NULL),(258389,'TRANSACTION','\0',10,'',3,NULL,'\0','',146,'2009-03-10 13:20:08','\0','1.000',99,15846,34007,0,NULL),(258533,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',147,'2009-03-10 13:26:52','\0','1.000',100,15846,34007,0,NULL),(258540,'TRANSACTION','\0',10,'',3,NULL,'\0','',148,'2009-03-10 13:27:18','\0','1.000',102,15846,34007,0,NULL),(258578,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',149,'2009-03-10 13:28:39','\0','1.000',103,15846,34007,0,NULL),(258593,'TRANSACTION','\0',10,'',3,NULL,'\0','',150,'2009-03-10 13:29:07','\0','1.000',105,15846,34007,0,NULL),(258845,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',151,'2009-03-10 13:40:37','\0','1.000',106,15846,34007,0,NULL),(258854,'TRANSACTION','\0',10,'',3,NULL,'\0','',152,'2009-03-10 13:40:57','\0','1.000',108,15846,34007,0,NULL),(259224,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',153,'2009-03-10 13:59:05','\0','1.000',109,15846,34007,0,NULL),(259231,'TRANSACTION','\0',10,'',3,NULL,'\0','',154,'2009-03-10 13:59:28','\0','1.000',111,15846,34007,0,NULL),(259408,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',155,'2009-03-10 14:07:31','\0','1.000',112,15846,34007,0,NULL),(259422,'TRANSACTION','\0',10,'',2,NULL,'','',156,'2009-03-10 14:08:04','\0','1.000',114,15846,34007,0,NULL),(259449,'TRANSACTION','\0',10,'',3,NULL,'\0','',157,'2009-03-10 14:09:09','\0','1.000',114,15846,34007,0,NULL),(259476,'TRANSACTION','\0',10,'',2,NULL,'\0','',158,'2009-03-10 14:10:31','\0','1.000',115,15846,34007,0,NULL),(259490,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',159,'2009-03-10 14:11:02','\0','1.000',115,15846,34007,0,NULL),(259502,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',160,'2009-03-10 14:11:21','\0','1.000',115,15846,34007,0,NULL),(259514,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',161,'2009-03-10 14:11:59','\0','1.000',117,15846,34007,0,NULL),(259535,'TRANSACTION','\0',3,'',2,NULL,'\0','\0',162,'2009-03-10 14:13:04','\0','1.000',119,15846,34007,0,NULL),(259546,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',163,'2009-03-10 14:13:30','\0','1.000',120,15846,34007,0,NULL),(259558,'TRANSACTION','\0',10,'',2,NULL,'\0','',164,'2009-03-10 14:13:54','\0','1.000',122,15846,34007,0,NULL),(259574,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',165,'2009-03-10 14:14:35','\0','1.000',122,15846,34007,0,NULL),(259584,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',166,'2009-03-10 14:15:00','\0','1.000',122,15846,34007,0,NULL),(259625,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',167,'2009-03-10 14:16:51','\0','1.000',122,15846,34007,0,NULL),(259644,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',168,'2009-03-10 14:18:11','\0','1.000',122,15846,34007,0,NULL),(259697,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',169,'2009-03-10 14:20:49','\0','1.000',122,15846,34007,0,NULL),(259712,'TRANSACTION','\0',10,'',3,NULL,'\0','',170,'2009-03-10 14:21:18','\0','1.000',124,15846,34007,0,NULL),(259754,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',171,'2009-03-10 14:22:42','\0','1.000',125,15846,34007,0,NULL),(259766,'TRANSACTION','\0',10,'',2,NULL,'\0','',172,'2009-03-10 14:23:04','\0','1.000',127,15846,34007,0,NULL),(259790,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',173,'2009-03-10 14:23:47','\0','1.000',127,15846,34007,0,NULL),(259817,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',174,'2009-03-10 14:24:32','\0','1.000',127,15846,34007,0,NULL),(259961,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',175,'2009-03-10 14:30:55','\0','1.000',127,15846,34007,0,NULL),(260062,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',176,'2009-03-10 14:35:18','\0','1.000',127,15846,34007,0,NULL),(260073,'TRANSACTION','\0',10,'',3,NULL,'\0','',177,'2009-03-10 14:35:49','\0','1.000',129,15846,34007,0,NULL),(260104,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',178,'2009-03-10 14:37:06','\0','1.000',130,15846,34007,0,NULL),(260111,'TRANSACTION','\0',10,'',3,NULL,'\0','',179,'2009-03-10 14:37:28','\0','1.000',132,15846,34007,0,NULL),(260162,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',180,'2009-03-10 14:39:27','\0','1.000',133,15846,34007,0,NULL),(260169,'TRANSACTION','\0',10,'',3,NULL,'\0','',181,'2009-03-10 14:39:54','\0','1.000',135,15846,34007,0,NULL),(260197,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',182,'2009-03-10 14:41:12','\0','1.000',136,15846,34007,0,NULL),(260208,'TRANSACTION','\0',10,'',2,NULL,'\0','',183,'2009-03-10 14:41:36','\0','1.000',138,15846,34007,0,NULL),(260226,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',184,'2009-03-10 14:42:31','\0','1.000',138,15846,34007,0,NULL),(260241,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',185,'2009-03-10 14:43:04','\0','1.000',138,15846,34007,0,NULL),(260308,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',186,'2009-03-10 14:46:41','\0','1.000',138,15846,34007,0,NULL),(260399,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',187,'2009-03-10 14:50:45','\0','1.000',138,15846,34007,0,NULL),(260408,'TRANSACTION','\0',10,'',3,NULL,'\0','',188,'2009-03-10 14:51:12','\0','1.000',140,15846,34007,0,NULL),(260445,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',189,'2009-03-10 14:53:06','\0','1.000',141,15846,34007,0,NULL),(260450,'TRANSACTION','\0',10,'',2,NULL,'\0','',190,'2009-03-10 14:53:28','\0','1.000',143,15846,34007,0,NULL),(260467,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',191,'2009-03-10 14:54:13','\0','1.000',143,15846,34007,0,NULL),(260492,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',192,'2009-03-10 14:55:45','\0','1.000',143,15846,34007,0,NULL),(260614,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',193,'2009-03-10 15:00:29','\0','1.000',143,15846,34007,0,NULL),(260628,'TRANSACTION','\0',10,'',3,NULL,'\0','',194,'2009-03-10 15:00:52','\0','1.000',145,15846,34007,0,NULL),(260653,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',195,'2009-03-10 15:02:35','\0','1.000',146,15846,34007,0,NULL),(260658,'TRANSACTION','\0',10,'',3,NULL,'\0','',196,'2009-03-10 15:02:58','\0','1.000',148,15846,34007,0,NULL),(260678,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',197,'2009-03-10 15:04:15','\0','1.000',149,15846,34007,0,NULL),(260682,'TRANSACTION','\0',10,'',3,NULL,'\0','',198,'2009-03-10 15:04:41','\0','1.000',151,15846,34007,0,NULL),(260796,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',199,'2009-03-10 15:10:02','\0','1.000',152,15846,34007,0,NULL),(260810,'TRANSACTION','\0',10,'',3,NULL,'\0','',200,'2009-03-10 15:10:41','\0','1.000',154,15846,34007,0,NULL),(260873,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',201,'2009-03-10 15:12:31','\0','1.000',155,15846,34007,0,NULL),(260884,'TRANSACTION','\0',10,'',3,NULL,'\0','',202,'2009-03-10 15:12:57','\0','1.000',157,15846,34007,0,NULL),(260961,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',203,'2009-03-10 15:15:39','\0','1.000',158,15846,34007,0,NULL),(260973,'TRANSACTION','\0',10,'',3,NULL,'\0','',204,'2009-03-10 15:16:01','\0','1.000',160,15846,34007,0,NULL),(261040,'TRANSACTION','\0',10,'',3,NULL,'\0','',205,'2009-03-10 15:19:13','\0','1.000',161,15846,34007,0,NULL),(261198,'TRANSACTION','\0',10,'',3,NULL,'\0','',206,'2009-03-10 15:26:30','\0','1.000',162,15846,34007,0,NULL),(261230,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',207,'2009-03-10 15:28:03','\0','1.000',163,15846,34007,0,NULL),(261245,'TRANSACTION','\0',10,'',3,NULL,'\0','',208,'2009-03-10 15:28:40','\0','1.000',165,15846,34007,0,NULL),(261287,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',209,'2009-03-10 15:30:05','\0','1.000',166,15846,34007,0,NULL),(261300,'TRANSACTION','\0',10,'',3,NULL,'\0','',210,'2009-03-10 15:30:33','\0','1.000',168,15846,34007,0,NULL),(261380,'TRANSACTION','\0',3,'',2,NULL,'\0','\0',211,'2009-03-10 15:33:32','\0','1.000',169,15846,34007,0,NULL),(261401,'TRANSACTION','\0',3,'',2,NULL,'\0','\0',212,'2009-03-10 15:34:03','\0','1.000',170,15846,34007,0,NULL),(261410,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',213,'2009-03-10 15:34:41','\0','1.000',171,15846,34007,0,NULL),(261417,'TRANSACTION','\0',10,'',3,NULL,'\0','',214,'2009-03-10 15:35:03','\0','1.000',173,15846,34007,0,NULL),(261650,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',215,'2009-03-10 15:44:06','\0','1.000',174,15846,34007,0,NULL),(261661,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',216,'2009-03-10 15:44:29','\0','1.000',174,15846,34007,0,NULL),(261681,'TRANSACTION','\0',10,'',3,NULL,'\0','',217,'2009-03-10 15:45:07','\0','1.000',176,15846,34007,0,NULL),(261707,'TRANSACTION','\0',3,'\0',2,NULL,'\0','\0',218,'2009-03-10 15:46:23','\0','1.000',177,15846,34007,0,NULL),(261714,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',219,'2009-03-10 15:46:43','\0','1.000',177,15846,34007,0,NULL),(261724,'TRANSACTION','\0',10,'',3,NULL,'\0','',220,'2009-03-10 15:47:09','\0','1.000',179,15846,34007,0,NULL),(261768,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',221,'2009-03-10 15:48:49','\0','1.000',180,15846,34007,0,NULL),(261780,'TRANSACTION','\0',10,'',3,NULL,'\0','',222,'2009-03-10 15:49:10','\0','1.000',182,15846,34007,0,NULL),(261810,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',223,'2009-03-10 15:50:27','\0','1.000',183,15846,34007,0,NULL),(261818,'TRANSACTION','\0',10,'',3,NULL,'\0','',224,'2009-03-10 15:50:48','\0','1.000',185,15846,34007,0,NULL),(262630,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',225,'2009-03-10 16:25:21','\0','1.000',186,15846,34007,0,NULL),(262639,'TRANSACTION','\0',10,'',3,NULL,'\0','',226,'2009-03-10 16:25:43','\0','1.000',188,15846,34007,0,NULL),(262733,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',227,'2009-03-10 16:29:54','\0','1.000',189,15846,34007,0,NULL),(262739,'TRANSACTION','\0',10,'',3,NULL,'\0','',228,'2009-03-10 16:30:14','\0','1.000',191,15846,34007,0,NULL),(262879,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',229,'2009-03-10 16:36:41','\0','1.000',192,15846,34007,0,NULL),(262888,'TRANSACTION','\0',10,'',3,NULL,'\0','',230,'2009-03-10 16:37:03','\0','1.000',194,15846,34007,0,NULL),(262916,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',231,'2009-03-10 16:38:13','\0','1.000',195,15846,34007,0,NULL),(262924,'TRANSACTION','\0',10,'',3,NULL,'\0','',232,'2009-03-10 16:38:32','\0','1.000',197,15846,34007,0,NULL),(263096,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',233,'2009-03-10 16:45:18','\0','1.000',198,15846,34007,0,NULL),(263106,'TRANSACTION','\0',10,'',3,NULL,'\0','',234,'2009-03-10 16:45:37','\0','1.000',200,15846,34007,0,NULL),(263357,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',235,'2009-03-10 16:56:03','\0','1.000',201,15846,34007,0,NULL),(263365,'TRANSACTION','\0',10,'',3,NULL,'\0','',236,'2009-03-10 16:56:22','\0','1.000',203,15846,34007,0,NULL),(263696,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',237,'2009-03-10 17:11:30','\0','1.000',204,15846,34007,0,NULL),(263711,'TRANSACTION','\0',10,'',3,NULL,'\0','',238,'2009-03-10 17:11:56','\0','1.000',206,15846,34007,0,NULL),(263823,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',239,'2009-03-10 17:16:06','\0','1.000',207,15846,34007,0,NULL),(263827,'TRANSACTION','\0',10,'',3,NULL,'\0','',240,'2009-03-10 17:16:26','\0','1.000',209,15846,34007,0,NULL),(264027,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',241,'2009-03-10 17:26:07','\0','1.000',210,15846,34007,0,NULL),(264038,'TRANSACTION','\0',10,'',3,NULL,'\0','',242,'2009-03-10 17:26:30','\0','1.000',212,15846,34007,0,NULL),(264064,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',243,'2009-03-10 17:28:01','\0','1.000',213,15846,34007,0,NULL),(264076,'TRANSACTION','\0',10,'',3,NULL,'\0','',244,'2009-03-10 17:28:22','\0','1.000',215,15846,34007,0,NULL),(264260,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',245,'2009-03-10 17:35:41','\0','1.000',216,15846,34007,0,NULL),(264271,'TRANSACTION','\0',10,'',3,NULL,'\0','',246,'2009-03-10 17:36:05','\0','1.000',218,15846,34007,0,NULL),(264847,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',247,'2009-03-10 18:01:54','\0','1.000',219,15846,34007,0,NULL),(264856,'TRANSACTION','\0',10,'',3,NULL,'\0','',248,'2009-03-10 18:02:19','\0','1.000',221,15846,34007,0,NULL),(265287,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',249,'2009-03-10 18:21:03','\0','1.000',222,15846,34007,0,NULL),(265300,'TRANSACTION','\0',10,'\0',2,NULL,'\0','',250,'2009-03-10 18:21:45','\0','1.000',222,15846,34007,0,NULL),(265547,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',251,'2009-03-10 18:31:33','\0','1.000',222,15846,34007,0,NULL),(265554,'TRANSACTION','\0',10,'',3,NULL,'\0','',252,'2009-03-10 18:31:58','\0','1.000',224,15846,34007,0,NULL),(266514,'TRANSACTION','\0',3,'',3,NULL,'\0','\0',253,'2009-03-10 19:11:51','\0','1.000',225,15846,34007,0,NULL),(266524,'TRANSACTION','\0',10,'',3,NULL,'\0','',254,'2009-03-10 19:12:27','\0','1.000',227,15846,34007,0,NULL),(267590,'TRANSACTION','\0',6,'\0',2,NULL,'\0','\0',255,'2009-03-10 20:39:08','\0','1.000',NULL,15846,34007,0,NULL),(267591,'TRANSACTION','\0',6,'',2,NULL,'\0','\0',256,'2009-03-10 20:39:09','\0','1.000',NULL,15846,34007,0,NULL); --enable_query_log SELECT ID, reversed FROM transactions where acquirer_terminal='34007' and reversed=0 and reversable=1 and ((state_code=1) or (state_code=2 and authorized=1)); SELECT ID, reversed FROM transactions where acquirer_terminal='34007' and reversed<>1 and reversable=1 and ((state_code=1) or (state_code=2 and authorized=1));