Skip navigation links

MySQL Forums :: Newbie :: mysql query


Advanced Search

mysql query
Posted by: asadilan indrabudi ()
Date: January 10, 2013 03:18PM

Hi All,

my attempted query:
select T1.testuniqueid ,max(T1.runNo) as maxRun from `ReconfigurableTester`.`simresult` group by T1.TestUniqueiD T1
inner join
(
select testuniqueid, sum(result),count(*), runNo, kount, timetaken from `reconfigurabletester`.`simresult` group by testuniqueid
) T2
on T2.testuniqueid = T1.testuniqueid and T1.maxRun = T2.runNo


my create table:


CREATE TABLE IF NOT EXISTS `simresult` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`testUniqueid` int(11) NOT NULL,
`startTime` datetime NOT NULL,
`endTime` datetime NOT NULL,
`result` int(11) NOT NULL COMMENT '0 - fail\n1 - pass',
`sim result id` int(11) NOT NULL COMMENT 'for further info, \nthe id of ',
`timeTaken` double NOT NULL,
`kount` int(11) NOT NULL COMMENT 'simulated time',
`version` int(11) NOT NULL,
`hostname` varchar(128) NOT NULL,
`req_simdllver` varchar(10) NOT NULL,
`runNo` int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10727 DEFAULT CHARSET=latin1;


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-- Dumping data for table reconfigurabletester.simresult: ~1,111 rows (approximately)
/*!40000 ALTER TABLE `simresult` DISABLE KEYS */;
INSERT INTO `simresult` (`id`, `testUniqueid`, `startTime`, `endTime`, `result`, `sim result id`, `timeTaken`, `kount`, `version`, `hostname`, `req_simdllver`, `runNo`) VALUES
INSERT INTO `simresult` (`id`, `testUniqueid`, `startTime`, `endTime`, `result`, `sim result id`, `timeTaken`, `kount`, `version`, `hostname`, `req_simdllver`, `runNo`) VALUES
(10329, 224, '2013-01-10 10:14:27', '2013-01-10 10:14:30', 1, 0, 3, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10330, 224, '2013-01-10 10:14:29', '2013-01-10 10:14:32', 1, 0, 3, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10331, 203, '2013-01-10 10:14:31', '2013-01-10 10:14:35', 1, 0, 4, 2001, 305173100, 'aindrabudi@mpdev14', '3.5.1500', 68),
(10332, 204, '2013-01-10 10:14:33', '2013-01-10 10:14:36', 1, 0, 3, 1801, 305173100, 'aindrabudi@mpdev14', '', 68),
(10333, 204, '2013-01-10 10:14:36', '2013-01-10 10:14:38', 1, 0, 2, 1801, 305173100, 'aindrabudi@mpdev14', '', 68),
(10334, 206, '2013-01-10 10:14:38', '2013-01-10 10:14:38', 1, 0, 0, 149, 305173100, 'aindrabudi@mpdev14', '3.5.1500', 68),
(10335, 206, '2013-01-10 10:14:40', '2013-01-10 10:14:41', 1, 0, 1, 149, 305173100, 'aindrabudi@mpdev14', '3.5.1500', 68),
(10336, 205, '2013-01-10 10:14:47', '2013-01-10 10:14:50', 0, 0, 3, 2338, 305173100, 'aindrabudi@mpdev14', '', 68),
(10337, 209, '2013-01-10 10:14:43', '2013-01-10 10:14:54', 1, 0, 11, 4001, 305173100, 'aindrabudi@mpdev14', '3.5.1500', 68),
(10338, 209, '2013-01-10 10:14:44', '2013-01-10 10:14:54', 1, 0, 10, 4001, 305173100, 'aindrabudi@mpdev14', '3.5.1500', 68),
(10339, 201, '2013-01-10 10:14:54', '2013-01-10 10:14:58', 1, 0, 4, 3001, 305173100, 'aindrabudi@mpdev14', '3.5.1500', 68),
(10340, 215, '2013-01-10 10:15:04', '2013-01-10 10:15:09', 1, 0, 5, 3001, 305173100, 'aindrabudi@mpdev14', '3.5.1353', 68),
(10341, 215, '2013-01-10 10:15:12', '2013-01-10 10:15:16', 1, 0, 4, 3001, 305173100, 'aindrabudi@mpdev14', '3.5.1353', 68),
(10342, 211, '2013-01-10 10:14:49', '2013-01-10 10:15:17', 1, 0, 28, 18001, 305173100, 'aindrabudi@mpdev14', '3.5.1500', 68),
(10343, 224, '2013-01-10 10:14:26', '2013-01-10 10:15:17', 1, 0, 51, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10344, 211, '2013-01-10 10:14:51', '2013-01-10 10:15:19', 1, 0, 28, 18001, 305173100, 'aindrabudi@mpdev14', '3.5.1500', 68),
(10345, 218, '2013-01-10 10:15:40', '2013-01-10 10:15:40', 0, 0, 0, -1, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10346, 218, '2013-01-10 10:15:43', '2013-01-10 10:15:44', 1, 0, 1, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10347, 221, '2013-01-10 10:14:58', '2013-01-10 10:15:48', 1, 0, 50, 18001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10348, 221, '2013-01-10 10:15:02', '2013-01-10 10:15:50', 1, 0, 48, 18001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10349, 219, '2013-01-10 10:15:55', '2013-01-10 10:15:58', 1, 0, 3, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10350, 219, '2013-01-10 10:15:55', '2013-01-10 10:15:59', 1, 0, 4, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10351, 219, '2013-01-10 10:15:57', '2013-01-10 10:16:00', 1, 0, 3, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10352, 220, '2013-01-10 10:16:10', '2013-01-10 10:16:13', 1, 0, 3, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10353, 220, '2013-01-10 10:16:10', '2013-01-10 10:16:14', 1, 0, 4, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10354, 214, '2013-01-10 10:16:15', '2013-01-10 10:16:16', 1, 0, 1, 98, 305173100, 'aindrabudi@mpdev14', '3.5.1510', 68),
(10355, 220, '2013-01-10 10:16:12', '2013-01-10 10:16:18', 1, 0, 6, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10356, 214, '2013-01-10 10:16:18', '2013-01-10 10:16:18', 1, 0, 0, 98, 305173100, 'aindrabudi@mpdev14', '3.5.1510', 68),
(10357, 225, '2013-01-10 10:16:21', '2013-01-10 10:16:21', 0, 0, 0, -1, 0, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10358, 229, '2013-01-10 10:16:30', '2013-01-10 10:16:30', 1, 0, 0, 101, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10359, 229, '2013-01-10 10:16:35', '2013-01-10 10:16:35', 1, 0, 0, 101, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10360, 213, '2013-01-10 10:14:56', '2013-01-10 10:16:39', 1, 0, 103, 29999, 29999, 'aindrabudi@mpdev14', '3.5.1500', 68),
(10361, 229, '2013-01-10 10:16:39', '2013-01-10 10:16:40', 1, 0, 1, 101, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10362, 225, '2013-01-10 10:16:20', '2013-01-10 10:16:47', 1, 0, 27, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10363, 225, '2013-01-10 10:16:24', '2013-01-10 10:16:48', 1, 0, 24, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10364, 225, '2013-01-10 10:16:25', '2013-01-10 10:16:49', 1, 0, 24, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10365, 228, '2013-01-10 10:16:49', '2013-01-10 10:16:49', 0, 0, 0, 22, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10366, 228, '2013-01-10 10:16:52', '2013-01-10 10:16:53', 0, 0, 1, 22, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10367, 230, '2013-01-10 10:16:53', '2013-01-10 10:16:54', 0, 0, 1, -1, 0, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10368, 230, '2013-01-10 10:16:55', '2013-01-10 10:16:56', 1, 0, 1, 101, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10369, 225, '2013-01-10 10:16:28', '2013-01-10 10:16:56', 1, 0, 28, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10370, 230, '2013-01-10 10:16:58', '2013-01-10 10:16:58', 1, 0, 0, 101, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10371, 231, '2013-01-10 10:16:59', '2013-01-10 10:16:59', 1, 0, 0, 101, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10372, 231, '2013-01-10 10:17:01', '2013-01-10 10:17:02', 1, 0, 1, 101, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10373, 231, '2013-01-10 10:17:04', '2013-01-10 10:17:04', 1, 0, 0, 101, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10374, 232, '2013-01-10 10:17:06', '2013-01-10 10:17:07', 1, 0, 1, 101, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10375, 232, '2013-01-10 10:17:09', '2013-01-10 10:17:09', 1, 0, 0, 101, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10376, 233, '2013-01-10 10:17:11', '2013-01-10 10:17:12', 1, 0, 1, 101, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10377, 233, '2013-01-10 10:17:14', '2013-01-10 10:17:14', 1, 0, 0, 101, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10378, 233, '2013-01-10 10:17:17', '2013-01-10 10:17:17', 1, 0, 0, 101, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10379, 235, '2013-01-10 10:17:19', '2013-01-10 10:17:23', 1, 0, 4, 2001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10380, 235, '2013-01-10 10:17:21', '2013-01-10 10:17:25', 1, 0, 4, 2001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10381, 227, '2013-01-10 10:16:44', '2013-01-10 10:17:25', 1, 0, 41, 18001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10382, 235, '2013-01-10 10:17:22', '2013-01-10 10:17:26', 1, 0, 4, 2001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10383, 227, '2013-01-10 10:16:45', '2013-01-10 10:17:27', 1, 0, 42, 18001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10384, 237, '2013-01-10 10:17:28', '2013-01-10 10:17:29', 1, 0, 1, 65, 305173100, 'aindrabudi@mpdev14', '3.5.1661', 68),
(10385, 232, '2013-01-10 10:17:09', '2013-01-10 10:17:36', 1, 0, 27, 101, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10386, 246, '2013-01-10 10:17:35', '2013-01-10 10:17:36', 1, 0, 1, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10387, 246, '2013-01-10 10:17:39', '2013-01-10 10:17:40', 1, 0, 1, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10388, 247, '2013-01-10 10:17:42', '2013-01-10 10:17:44', 1, 0, 2, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10389, 247, '2013-01-10 10:17:45', '2013-01-10 10:17:46', 1, 0, 1, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10390, 247, '2013-01-10 10:17:47', '2013-01-10 10:17:49', 1, 0, 2, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10391, 248, '2013-01-10 10:17:48', '2013-01-10 10:17:50', 1, 0, 2, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10392, 248, '2013-01-10 10:17:51', '2013-01-10 10:17:52', 1, 0, 1, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10393, 248, '2013-01-10 10:17:53', '2013-01-10 10:17:54', 1, 0, 1, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10394, 249, '2013-01-10 10:17:56', '2013-01-10 10:18:10', 1, 0, 14, 18001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10395, 249, '2013-01-10 10:17:57', '2013-01-10 10:18:12', 1, 0, 15, 18001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10396, 240, '2013-01-10 10:17:34', '2013-01-10 10:18:13', 1, 0, 39, 18001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10397, 249, '2013-01-10 10:18:00', '2013-01-10 10:18:14', 1, 0, 14, 18001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10398, 250, '2013-01-10 10:18:31', '2013-01-10 10:18:32', 1, 0, 1, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10399, 253, '2013-01-10 10:18:33', '2013-01-10 10:18:34', 1, 0, 1, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10400, 253, '2013-01-10 10:18:36', '2013-01-10 10:18:36', 1, 0, 0, 51, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10401, 253, '2013-01-10 10:18:39', '2013-01-10 10:18:39', 1, 0, 0, 51, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10402, 254, '2013-01-10 10:18:42', '2013-01-10 10:18:46', 1, 0, 4, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10403, 254, '2013-01-10 10:18:43', '2013-01-10 10:18:47', 1, 0, 4, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10404, 254, '2013-01-10 10:18:49', '2013-01-10 10:18:52', 1, 0, 3, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10405, 251, '2013-01-10 10:18:54', '2013-01-10 10:18:59', 1, 0, 5, 4500, 305173100, 'aindrabudi@mpdev14', '3.5.1707', 68),
(10406, 258, '2013-01-10 10:19:02', '2013-01-10 10:19:02', 1, 0, 0, 295, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10407, 258, '2013-01-10 10:19:06', '2013-01-10 10:19:06', 1, 0, 0, 290, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10408, 258, '2013-01-10 10:19:10', '2013-01-10 10:19:11', 1, 0, 1, 290, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10409, 260, '2013-01-10 10:19:15', '2013-01-10 10:19:18', 1, 0, 3, 3000, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10410, 260, '2013-01-10 10:19:21', '2013-01-10 10:19:24', 1, 0, 3, 3000, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10411, 260, '2013-01-10 10:19:26', '2013-01-10 10:19:29', 1, 0, 3, 3000, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10412, 261, '2013-01-10 10:19:32', '2013-01-10 10:19:35', 1, 0, 3, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10413, 261, '2013-01-10 10:19:37', '2013-01-10 10:19:40', 1, 0, 3, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10414, 212, '2013-01-10 10:14:25', '2013-01-10 10:19:44', 1, 0, 319, 29999, 29999, 'aindrabudi@mpdev14', '3.5.1500', 68),
(10415, 246, '2013-01-10 10:17:39', '2013-01-10 10:19:46', 1, 0, 127, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10416, 261, '2013-01-10 10:19:42', '2013-01-10 10:19:46', 1, 0, 4, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10417, 262, '2013-01-10 10:19:49', '2013-01-10 10:19:51', 1, 0, 2, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10418, 262, '2013-01-10 10:19:52', '2013-01-10 10:19:53', 1, 0, 1, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10419, 262, '2013-01-10 10:19:59', '2013-01-10 10:20:00', 1, 0, 1, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10420, 263, '2013-01-10 10:20:14', '2013-01-10 10:20:36', 1, 0, 22, 18000, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10421, 263, '2013-01-10 10:20:16', '2013-01-10 10:20:43', 1, 0, 27, 18000, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10422, 263, '2013-01-10 10:20:18', '2013-01-10 10:20:46', 1, 0, 28, 18000, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10423, 264, '2013-01-10 10:21:05', '2013-01-10 10:21:05', 0, 0, 0, -1, 0, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10424, 264, '2013-01-10 10:21:01', '2013-01-10 10:21:08', 1, 0, 7, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10425, 259, '2013-01-10 10:21:20', '2013-01-10 10:21:20', 0, 0, 0, -1, 0, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10426, 264, '2013-01-10 10:21:18', '2013-01-10 10:21:20', 1, 0, 2, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10427, 259, '2013-01-10 10:21:23', '2013-01-10 10:21:24', 1, 0, 1, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10428, 259, '2013-01-10 10:21:24', '2013-01-10 10:21:27', 1, 0, 3, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10429, 265, '2013-01-10 10:21:28', '2013-01-10 10:21:28', 0, 0, 0, -1, 0, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10430, 265, '2013-01-10 10:21:27', '2013-01-10 10:21:32', 1, 0, 5, 3000, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10431, 267, '2013-01-10 10:21:33', '2013-01-10 10:21:33', 0, 0, 0, -1, 0, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10432, 265, '2013-01-10 10:21:31', '2013-01-10 10:21:36', 1, 0, 5, 3000, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10433, 267, '2013-01-10 10:21:37', '2013-01-10 10:21:37', 0, 0, 0, -1, 0, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10434, 267, '2013-01-10 10:21:36', '2013-01-10 10:21:41', 1, 0, 5, 3000, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10435, 268, '2013-01-10 10:21:41', '2013-01-10 10:21:44', 1, 0, 3, 3000, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10436, 268, '2013-01-10 10:21:42', '2013-01-10 10:21:45', 1, 0, 3, 3000, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10437, 269, '2013-01-10 10:21:47', '2013-01-10 10:21:47', 0, 0, 0, -1, 0, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10438, 268, '2013-01-10 10:21:44', '2013-01-10 10:21:49', 1, 0, 5, 3000, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10439, 269, '2013-01-10 10:21:50', '2013-01-10 10:21:50', 1, 0, 0, 89, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10440, 269, '2013-01-10 10:21:53', '2013-01-10 10:21:53', 1, 0, 0, 89, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10441, 255, '2013-01-10 10:18:51', '2013-01-10 10:21:56', 1, 0, 185, 4000, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10442, 270, '2013-01-10 10:21:56', '2013-01-10 10:21:56', 0, 0, 0, -1, 0, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10443, 270, '2013-01-10 10:21:55', '2013-01-10 10:22:01', 1, 0, 6, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10444, 270, '2013-01-10 10:21:59', '2013-01-10 10:22:03', 1, 0, 4, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10445, 271, '2013-01-10 10:22:00', '2013-01-10 10:22:04', 1, 0, 4, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10446, 271, '2013-01-10 10:22:03', '2013-01-10 10:22:06', 1, 0, 3, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10447, 271, '2013-01-10 10:22:05', '2013-01-10 10:22:08', 1, 0, 3, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10448, 266, '2013-01-10 10:22:07', '2013-01-10 10:22:12', 1, 0, 5, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10449, 266, '2013-01-10 10:22:08', '2013-01-10 10:22:13', 1, 0, 5, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10450, 266, '2013-01-10 10:22:11', '2013-01-10 10:22:16', 1, 0, 5, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10451, 274, '2013-01-10 10:22:13', '2013-01-10 10:22:19', 1, 0, 6, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10452, 274, '2013-01-10 10:22:15', '2013-01-10 10:22:21', 1, 0, 6, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10453, 274, '2013-01-10 10:22:19', '2013-01-10 10:22:24', 1, 0, 5, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10454, 275, '2013-01-10 10:22:23', '2013-01-10 10:22:27', 1, 0, 4, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 68),
(10455, 224, '2013-01-10 10:23:56', '2013-01-10 10:27:27', 1, 0, 211, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10456, 224, '2013-01-10 10:23:58', '2013-01-10 10:27:57', 1, 0, 239, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10457, 215, '2013-01-10 10:24:34', '2013-01-10 10:28:39', 1, 0, 245, 3001, 305173100, 'aindrabudi@mpdev14', '3.5.1353', 69),
(10458, 215, '2013-01-10 10:24:37', '2013-01-10 10:28:49', 1, 0, 252, 3001, 305173100, 'aindrabudi@mpdev14', '3.5.1353', 69),
(10459, 224, '2013-01-10 10:23:54', '2013-01-10 10:28:56', 1, 0, 302, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10460, 201, '2013-01-10 10:24:22', '2013-01-10 10:29:20', 1, 0, 298, 3001, 305173100, 'aindrabudi@mpdev14', '3.5.1500', 69),
(10461, 205, '2013-01-10 10:24:15', '2013-01-10 10:30:04', 0, 0, 349, 2338, 305173100, 'aindrabudi@mpdev14', '', 69),
(10462, 219, '2013-01-10 10:28:06', '2013-01-10 10:32:25', 1, 0, 259, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10463, 215, '2013-01-10 10:27:31', '2013-01-10 10:32:51', 1, 0, 320, 3001, 305173100, 'aindrabudi@mpdev14', '3.5.1353', 69),
(10464, 219, '2013-01-10 10:28:55', '2013-01-10 10:33:03', 1, 0, 248, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10465, 220, '2013-01-10 10:29:25', '2013-01-10 10:33:23', 1, 0, 238, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10466, 219, '2013-01-10 10:28:45', '2013-01-10 10:33:35', 1, 0, 290, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10467, 229, '2013-01-10 10:33:32', '2013-01-10 10:34:08', 1, 0, 36, 101, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10468, 229, '2013-01-10 10:33:40', '2013-01-10 10:34:13', 1, 0, 33, 101, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10469, 220, '2013-01-10 10:29:02', '2013-01-10 10:34:19', 1, 0, 317, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10470, 220, '2013-01-10 10:30:10', '2013-01-10 10:34:40', 1, 0, 270, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10471, 229, '2013-01-10 10:34:11', '2013-01-10 10:34:45', 1, 0, 34, 101, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10472, 230, '2013-01-10 10:34:29', '2013-01-10 10:35:06', 1, 0, 37, 101, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10473, 230, '2013-01-10 10:34:26', '2013-01-10 10:35:08', 1, 0, 42, 101, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10474, 230, '2013-01-10 10:34:44', '2013-01-10 10:35:22', 1, 0, 38, 101, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10475, 231, '2013-01-10 10:34:50', '2013-01-10 10:35:27', 1, 0, 37, 101, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10476, 231, '2013-01-10 10:35:11', '2013-01-10 10:35:54', 1, 0, 43, 101, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10477, 231, '2013-01-10 10:35:14', '2013-01-10 10:35:55', 1, 0, 41, 101, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10478, 232, '2013-01-10 10:35:26', '2013-01-10 10:35:59', 1, 0, 33, 101, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10479, 233, '2013-01-10 10:37:07', '2013-01-10 10:37:07', 0, 0, 0, -1, 0, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10480, 232, '2013-01-10 10:35:31', '2013-01-10 10:37:14', 1, 0, 103, 101, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10481, 232, '2013-01-10 10:35:58', '2013-01-10 10:37:52', 1, 0, 114, 101, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10482, 233, '2013-01-10 10:37:10', '2013-01-10 10:37:54', 1, 0, 44, 101, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10483, 233, '2013-01-10 10:37:13', '2013-01-10 10:37:57', 1, 0, 44, 101, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10484, 237, '2013-01-10 10:38:02', '2013-01-10 10:38:42', 1, 0, 40, 65, 305173100, 'aindrabudi@mpdev14', '3.5.1661', 69),
(10485, 225, '2013-01-10 10:32:35', '2013-01-10 10:42:08', 0, 0, 573, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10486, 225, '2013-01-10 10:32:55', '2013-01-10 10:42:57', 0, 0, 602, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10487, 235, '2013-01-10 10:37:18', '2013-01-10 10:43:00', 1, 0, 342, 2001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10488, 225, '2013-01-10 10:33:08', '2013-01-10 10:43:04', 0, 0, 596, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10489, 235, '2013-01-10 10:38:00', '2013-01-10 10:43:55', 1, 0, 355, 2001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10490, 235, '2013-01-10 10:37:57', '2013-01-10 10:44:34', 1, 0, 397, 2001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10491, 246, '2013-01-10 10:43:04', '2013-01-10 10:44:46', 1, 0, 102, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10492, 246, '2013-01-10 10:43:13', '2013-01-10 10:44:54', 1, 0, 101, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10493, 246, '2013-01-10 10:43:08', '2013-01-10 10:45:02', 1, 0, 114, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10494, 247, '2013-01-10 10:44:00', '2013-01-10 10:45:58', 1, 0, 118, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10495, 247, '2013-01-10 10:44:51', '2013-01-10 10:46:52', 1, 0, 121, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10496, 247, '2013-01-10 10:44:40', '2013-01-10 10:47:13', 1, 0, 153, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10497, 248, '2013-01-10 10:45:07', '2013-01-10 10:47:14', 1, 0, 127, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10498, 248, '2013-01-10 10:45:00', '2013-01-10 10:47:36', 1, 0, 156, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10499, 248, '2013-01-10 10:46:03', '2013-01-10 10:49:03', 1, 0, 180, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10500, 250, '2013-01-10 10:47:45', '2013-01-10 10:50:11', 1, 0, 146, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10501, 250, '2013-01-10 10:49:08', '2013-01-10 10:51:55', 1, 0, 167, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10502, 250, '2013-01-10 10:50:17', '2013-01-10 10:52:50', 1, 0, 153, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10503, 253, '2013-01-10 10:52:56', '2013-01-10 10:53:43', 1, 0, 47, 51, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10504, 253, '2013-01-10 10:53:49', '2013-01-10 10:54:40', 1, 0, 51, 51, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10505, 253, '2013-01-10 10:52:01', '2013-01-10 10:55:16', 1, 0, 195, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10506, 254, '2013-01-10 10:54:46', '2013-01-10 11:02:10', 1, 0, 444, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10507, 254, '2013-01-10 10:55:21', '2013-01-10 11:03:20', 1, 0, 479, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10508, 258, '2013-01-10 11:03:34', '2013-01-10 11:05:22', 1, 0, 108, 295, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10509, 258, '2013-01-10 11:05:27', '2013-01-10 11:07:28', 1, 0, 121, 290, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10510, 258, '2013-01-10 11:07:37', '2013-01-10 11:09:22', 1, 0, 105, 290, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10511, 254, '2013-01-10 11:02:16', '2013-01-10 11:10:18', 1, 0, 482, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10512, 260, '2013-01-10 11:09:27', '2013-01-10 11:18:28', 1, 0, 541, 3000, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10513, 260, '2013-01-10 11:10:25', '2013-01-10 11:19:08', 1, 0, 523, 3000, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10514, 260, '2013-01-10 11:18:35', '2013-01-10 11:27:38', 1, 0, 543, 3000, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10515, 261, '2013-01-10 11:19:15', '2013-01-10 11:28:08', 1, 0, 533, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10516, 239, '2013-01-10 10:38:46', '2013-01-10 11:30:35', 1, 0, 3109, 18001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10517, 249, '2013-01-10 10:46:57', '2013-01-10 11:31:11', 1, 0, 2654, 18001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10518, 249, '2013-01-10 10:47:26', '2013-01-10 11:31:21', 1, 0, 2635, 18001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10519, 262, '2013-01-10 11:30:40', '2013-01-10 11:33:29', 1, 0, 169, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10520, 249, '2013-01-10 10:47:21', '2013-01-10 11:33:57', 1, 0, 2796, 18001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10521, 262, '2013-01-10 11:31:16', '2013-01-10 11:34:03', 1, 0, 167, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10522, 263, '2013-01-10 11:35:16', '2013-01-10 11:35:16', 0, 0, 0, -1, 0, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10523, 262, '2013-01-10 11:31:28', '2013-01-10 11:35:37', 1, 0, 249, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10524, 261, '2013-01-10 11:27:43', '2013-01-10 11:38:07', 1, 0, 624, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10525, 261, '2013-01-10 11:28:14', '2013-01-10 11:38:30', 1, 0, 616, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10526, 264, '2013-01-10 11:35:26', '2013-01-10 11:41:02', 1, 0, 336, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10527, 264, '2013-01-10 11:35:43', '2013-01-10 11:41:22', 1, 0, 339, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10528, 259, '2013-01-10 11:38:38', '2013-01-10 11:43:02', 1, 0, 264, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10529, 264, '2013-01-10 11:38:14', '2013-01-10 11:43:53', 1, 0, 339, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10530, 259, '2013-01-10 11:41:10', '2013-01-10 11:45:26', 1, 0, 256, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10531, 259, '2013-01-10 11:41:29', '2013-01-10 11:45:44', 1, 0, 255, 1001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10532, 265, '2013-01-10 11:43:09', '2013-01-10 11:46:53', 1, 0, 224, 3000, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10533, 265, '2013-01-10 11:43:58', '2013-01-10 11:47:28', 1, 0, 210, 3000, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10534, 240, '2013-01-10 10:42:13', '2013-01-10 11:47:46', 1, 0, 3933, 18001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10535, 265, '2013-01-10 11:45:32', '2013-01-10 11:48:54', 1, 0, 202, 3000, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10536, 267, '2013-01-10 11:45:50', '2013-01-10 11:49:12', 1, 0, 202, 3000, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10537, 267, '2013-01-10 11:47:00', '2013-01-10 11:50:32', 1, 0, 212, 3000, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10538, 267, '2013-01-10 11:47:33', '2013-01-10 11:51:18', 1, 0, 225, 3000, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10539, 269, '2013-01-10 11:50:39', '2013-01-10 11:52:10', 1, 0, 91, 92, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10540, 269, '2013-01-10 11:51:25', '2013-01-10 11:52:56', 1, 0, 91, 89, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10541, 269, '2013-01-10 11:52:18', '2013-01-10 11:53:55', 1, 0, 97, 89, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10542, 268, '2013-01-10 11:47:55', '2013-01-10 11:55:02', 1, 0, 427, 3000, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10543, 268, '2013-01-10 11:49:01', '2013-01-10 11:56:38', 1, 0, 457, 3000, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10544, 268, '2013-01-10 11:49:18', '2013-01-10 11:56:57', 1, 0, 459, 3000, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10545, 270, '2013-01-10 11:53:04', '2013-01-10 12:11:56', 1, 0, 1132, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10546, 263, '2013-01-10 11:33:34', '2013-01-10 12:12:15', 1, 0, 2321, 18000, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10547, 270, '2013-01-10 11:54:03', '2013-01-10 12:12:34', 1, 0, 1111, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10548, 270, '2013-01-10 11:55:09', '2013-01-10 12:13:56', 1, 0, 1127, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10549, 271, '2013-01-10 11:56:46', '2013-01-10 12:15:31', 1, 0, 1125, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10550, 271, '2013-01-10 11:57:05', '2013-01-10 12:15:56', 1, 0, 1131, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10551, 263, '2013-01-10 11:35:20', '2013-01-10 12:18:33', 1, 0, 2593, 18000, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10552, 266, '2013-01-10 12:12:22', '2013-01-10 12:23:29', 1, 0, 667, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10553, 266, '2013-01-10 12:12:46', '2013-01-10 12:24:09', 1, 0, 683, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10554, 274, '2013-01-10 12:15:39', '2013-01-10 12:25:21', 1, 0, 582, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10555, 266, '2013-01-10 12:14:03', '2013-01-10 12:25:23', 1, 0, 680, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10556, 274, '2013-01-10 12:16:04', '2013-01-10 12:25:35', 1, 0, 571, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10557, 256, '2013-01-10 12:25:36', '2013-01-10 12:28:50', 1, 0, 194, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10558, 256, '2013-01-10 12:25:53', '2013-01-10 12:29:16', 1, 0, 203, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10559, 274, '2013-01-10 12:18:41', '2013-01-10 12:29:45', 1, 0, 664, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10560, 271, '2013-01-10 12:12:04', '2013-01-10 12:30:57', 1, 0, 1133, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10561, 273, '2013-01-10 12:29:23', '2013-01-10 12:31:34', 1, 0, 131, 346, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10562, 256, '2013-01-10 12:28:58', '2013-01-10 12:32:33', 1, 0, 215, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10563, 273, '2013-01-10 12:29:59', '2013-01-10 12:32:43', 1, 0, 164, 328, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10564, 256, '2013-01-10 12:32:32', '2013-01-10 12:32:55', 1, 0, 23, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10565, 256, '2013-01-10 12:32:34', '2013-01-10 12:33:05', 1, 0, 31, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10566, 256, '2013-01-10 12:32:35', '2013-01-10 12:33:10', 1, 0, 35, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10567, 222, '2013-01-10 12:32:00', '2013-01-10 12:33:16', 1, 0, 76, 101, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10568, 256, '2013-01-10 12:32:38', '2013-01-10 12:33:17', 1, 0, 39, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10569, 256, '2013-01-10 12:32:40', '2013-01-10 12:33:21', 1, 0, 41, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10570, 256, '2013-01-10 12:32:43', '2013-01-10 12:33:22', 1, 0, 39, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10571, 256, '2013-01-10 12:32:46', '2013-01-10 12:33:26', 1, 0, 40, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10572, 273, '2013-01-10 12:31:05', '2013-01-10 12:33:32', 1, 0, 147, 328, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10573, 256, '2013-01-10 12:32:50', '2013-01-10 12:33:33', 1, 0, 43, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10574, 256, '2013-01-10 12:32:58', '2013-01-10 12:33:45', 1, 0, 47, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10575, 256, '2013-01-10 12:33:08', '2013-01-10 12:33:50', 1, 0, 42, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10576, 256, '2013-01-10 12:33:13', '2013-01-10 12:33:54', 1, 0, 41, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10577, 256, '2013-01-10 12:33:24', '2013-01-10 12:34:08', 1, 0, 44, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10578, 256, '2013-01-10 12:33:27', '2013-01-10 12:34:13', 1, 0, 46, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10579, 256, '2013-01-10 12:33:30', '2013-01-10 12:34:14', 1, 0, 44, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10580, 256, '2013-01-10 12:33:39', '2013-01-10 12:34:29', 1, 0, 50, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10581, 256, '2013-01-10 12:33:49', '2013-01-10 12:34:36', 1, 0, 47, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10582, 256, '2013-01-10 12:33:54', '2013-01-10 12:34:48', 1, 0, 54, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10583, 256, '2013-01-10 12:33:58', '2013-01-10 12:34:50', 1, 0, 52, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10584, 256, '2013-01-10 12:34:13', '2013-01-10 12:35:08', 1, 0, 55, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10585, 256, '2013-01-10 12:34:17', '2013-01-10 12:35:09', 1, 0, 52, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10586, 256, '2013-01-10 12:34:21', '2013-01-10 12:35:19', 1, 0, 58, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10587, 256, '2013-01-10 12:34:34', '2013-01-10 12:35:31', 1, 0, 57, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10588, 256, '2013-01-10 12:34:39', '2013-01-10 12:35:42', 1, 0, 63, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10589, 256, '2013-01-10 12:34:52', '2013-01-10 12:35:51', 1, 0, 59, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10590, 256, '2013-01-10 12:34:55', '2013-01-10 12:36:00', 1, 0, 65, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10591, 256, '2013-01-10 12:35:13', '2013-01-10 12:36:10', 1, 0, 57, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10592, 256, '2013-01-10 12:35:16', '2013-01-10 12:36:22', 1, 0, 66, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10593, 256, '2013-01-10 12:35:25', '2013-01-10 12:36:28', 1, 0, 63, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10594, 256, '2013-01-10 12:35:37', '2013-01-10 12:36:49', 1, 0, 72, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10595, 256, '2013-01-10 12:35:46', '2013-01-10 12:36:53', 1, 0, 67, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10596, 256, '2013-01-10 12:35:56', '2013-01-10 12:37:08', 1, 0, 72, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10597, 256, '2013-01-10 12:36:05', '2013-01-10 12:37:13', 1, 0, 68, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10598, 256, '2013-01-10 12:36:16', '2013-01-10 12:37:25', 1, 0, 69, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10599, 256, '2013-01-10 12:36:27', '2013-01-10 12:37:30', 1, 0, 63, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10600, 256, '2013-01-10 12:36:36', '2013-01-10 12:37:40', 1, 0, 64, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10601, 256, '2013-01-10 12:36:54', '2013-01-10 12:37:45', 1, 0, 51, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10602, 256, '2013-01-10 12:36:58', '2013-01-10 12:37:48', 1, 0, 50, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10603, 256, '2013-01-10 12:37:13', '2013-01-10 12:37:49', 1, 0, 36, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 70),
(10604, 275, '2013-01-10 12:23:36', '2013-01-10 12:38:17', 1, 0, 881, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10605, 275, '2013-01-10 12:25:28', '2013-01-10 12:39:36', 1, 0, 848, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 69),
(10606, 201, '2013-01-10 13:42:24', '2013-01-10 13:42:58', 1, 0, 34, 3001, 305172900, 'aindrabudi@mpdev14', '3.5.1500', 71),
(10607, 201, '2013-01-10 13:42:22', '2013-01-10 13:43:01', 1, 0, 39, 3001, 305172900, 'aindrabudi@mpdev14', '3.5.1500', 71),
(10608, 201, '2013-01-10 13:42:21', '2013-01-10 13:43:45', 1, 0, 84, 3001, 305172900, 'aindrabudi@mpdev14', '3.5.1500', 71),
(10609, 256, '2013-01-10 13:47:37', '2013-01-10 13:47:57', 1, 0, 20, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10610, 256, '2013-01-10 13:47:39', '2013-01-10 13:48:12', 1, 0, 33, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10611, 256, '2013-01-10 13:47:41', '2013-01-10 13:48:16', 1, 0, 35, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10612, 256, '2013-01-10 13:47:35', '2013-01-10 13:48:21', 1, 0, 46, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10613, 256, '2013-01-10 13:47:46', '2013-01-10 13:48:26', 1, 0, 40, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10614, 256, '2013-01-10 13:47:44', '2013-01-10 13:48:26', 1, 0, 42, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10615, 256, '2013-01-10 13:47:49', '2013-01-10 13:48:34', 1, 0, 45, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10616, 256, '2013-01-10 13:47:52', '2013-01-10 13:48:35', 1, 0, 43, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10617, 256, '2013-01-10 13:48:00', '2013-01-10 13:48:49', 1, 0, 49, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10618, 256, '2013-01-10 13:48:15', '2013-01-10 13:48:59', 1, 0, 44, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10619, 256, '2013-01-10 13:48:19', '2013-01-10 13:49:14', 1, 0, 55, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10620, 256, '2013-01-10 13:48:31', '2013-01-10 13:49:20', 1, 0, 49, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10621, 256, '2013-01-10 13:48:24', '2013-01-10 13:49:23', 1, 0, 59, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10622, 256, '2013-01-10 13:48:29', '2013-01-10 13:49:25', 1, 0, 56, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10623, 256, '2013-01-10 13:48:41', '2013-01-10 13:49:31', 1, 0, 50, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10624, 256, '2013-01-10 13:48:38', '2013-01-10 13:49:37', 1, 0, 59, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10625, 256, '2013-01-10 13:48:53', '2013-01-10 13:49:56', 1, 0, 63, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10626, 256, '2013-01-10 13:49:02', '2013-01-10 13:49:56', 1, 0, 54, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10627, 256, '2013-01-10 13:49:17', '2013-01-10 13:50:25', 1, 0, 68, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10628, 256, '2013-01-10 13:49:29', '2013-01-10 13:50:27', 1, 0, 58, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10629, 256, '2013-01-10 13:49:24', '2013-01-10 13:50:34', 1, 0, 70, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10630, 256, '2013-01-10 13:49:26', '2013-01-10 13:50:39', 1, 0, 73, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10631, 256, '2013-01-10 13:49:41', '2013-01-10 13:50:42', 1, 0, 61, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10632, 256, '2013-01-10 13:49:35', '2013-01-10 13:50:47', 1, 0, 72, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10633, 256, '2013-01-10 13:50:02', '2013-01-10 13:51:10', 1, 0, 68, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10634, 256, '2013-01-10 13:50:00', '2013-01-10 13:51:15', 1, 0, 75, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10635, 256, '2013-01-10 13:50:31', '2013-01-10 13:51:30', 1, 0, 59, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10636, 256, '2013-01-10 13:50:29', '2013-01-10 13:51:36', 1, 0, 67, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10637, 256, '2013-01-10 13:50:45', '2013-01-10 13:51:57', 1, 0, 72, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10638, 256, '2013-01-10 13:50:53', '2013-01-10 13:52:06', 1, 0, 73, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10639, 256, '2013-01-10 13:50:48', '2013-01-10 13:52:13', 1, 0, 85, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10640, 256, '2013-01-10 13:50:42', '2013-01-10 13:52:23', 1, 0, 101, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10641, 256, '2013-01-10 13:51:19', '2013-01-10 13:52:33', 1, 0, 74, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10642, 256, '2013-01-10 13:51:14', '2013-01-10 13:52:39', 1, 0, 85, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10643, 256, '2013-01-10 13:51:42', '2013-01-10 13:52:49', 1, 0, 67, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10644, 256, '2013-01-10 13:51:36', '2013-01-10 13:52:51', 1, 0, 75, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10645, 256, '2013-01-10 13:52:11', '2013-01-10 13:52:57', 1, 0, 46, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10646, 256, '2013-01-10 13:52:02', '2013-01-10 13:52:58', 1, 0, 56, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10647, 256, '2013-01-10 13:52:22', '2013-01-10 13:53:02', 1, 0, 40, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 72),
(10648, 276, '2013-01-10 13:55:09', '2013-01-10 13:55:13', 1, 0, 4, 3001, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 73),
(10649, 276, '2013-01-10 13:55:11', '2013-01-10 13:55:14', 1, 0, 3, 3001, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 73),
(10650, 276, '2013-01-10 13:55:08', '2013-01-10 13:56:33', 1, 0, 85, 3001, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 73),
(10651, 224, '2013-01-10 13:58:15', '2013-01-10 13:58:18', 1, 0, 3, 3001, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 74),
(10652, 224, '2013-01-10 13:58:17', '2013-01-10 13:58:20', 1, 0, 3, 3001, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 74),
(10653, 203, '2013-01-10 13:58:18', '2013-01-10 13:58:23', 1, 0, 5, 2001, 305172900, 'aindrabudi@mpdev14', '3.5.1500', 74),
(10654, 204, '2013-01-10 13:58:20', '2013-01-10 13:58:24', 1, 0, 4, 1801, 305172900, 'aindrabudi@mpdev14', '', 74),
(10655, 206, '2013-01-10 13:58:25', '2013-01-10 13:58:26', 0, 0, 1, 501, 305172900, 'aindrabudi@mpdev14', '3.5.1500', 74),
(10656, 204, '2013-01-10 13:58:23', '2013-01-10 13:58:27', 1, 0, 4, 1801, 305172900, 'aindrabudi@mpdev14', '', 74),
(10657, 206, '2013-01-10 13:58:27', '2013-01-10 13:58:29', 0, 0, 2, 501, 305172900, 'aindrabudi@mpdev14', '3.5.1500', 74),
(10658, 205, '2013-01-10 13:58:33', '2013-01-10 13:58:36', 0, 0, 3, 2338, 305172900, 'aindrabudi@mpdev14', '', 74),
(10659, 209, '2013-01-10 13:58:29', '2013-01-10 13:58:40', 1, 0, 11, 4001, 305172900, 'aindrabudi@mpdev14', '3.5.1500', 74),
(10660, 209, '2013-01-10 13:58:30', '2013-01-10 13:58:41', 1, 0, 11, 4001, 305172900, 'aindrabudi@mpdev14', '3.5.1500', 74),
(10661, 201, '2013-01-10 13:58:40', '2013-01-10 13:58:44', 1, 0, 4, 3001, 305172900, 'aindrabudi@mpdev14', '3.5.1500', 74),
(10662, 215, '2013-01-10 13:58:50', '2013-01-10 13:58:54', 1, 0, 4, 3001, 305172900, 'aindrabudi@mpdev14', '3.5.1353', 74),
(10663, 215, '2013-01-10 13:58:57', '2013-01-10 13:59:01', 1, 0, 4, 3001, 305172900, 'aindrabudi@mpdev14', '3.5.1353', 74),
(10664, 224, '2013-01-10 13:58:13', '2013-01-10 13:59:03', 1, 0, 50, 3001, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 74),
(10665, 211, '2013-01-10 13:58:35', '2013-01-10 13:59:05', 1, 0, 30, 18001, 305172900, 'aindrabudi@mpdev14', '3.5.1500', 74),
(10666, 218, '2013-01-10 13:59:05', '2013-01-10 13:59:06', 0, 0, 1, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 74),
(10667, 211, '2013-01-10 13:58:37', '2013-01-10 13:59:09', 1, 0, 32, 18001, 305172900, 'aindrabudi@mpdev14', '3.5.1500', 74),
(10668, 218, '2013-01-10 13:59:09', '2013-01-10 13:59:09', 0, 0, 0, 501, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 74),
(10669, 219, '2013-01-10 13:59:11', '2013-01-10 13:59:15', 1, 0, 4, 3001, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 74),
(10670, 219, '2013-01-10 13:59:13', '2013-01-10 13:59:17', 1, 0, 4, 3001, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 74),
(10671, 219, '2013-01-10 13:59:15', '2013-01-10 13:59:19', 1, 0, 4, 3001, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 74),
(10672, 220, '2013-01-10 13:59:18', '2013-01-10 13:59:22', 1, 0, 4, 3001, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 74),
(10673, 220, '2013-01-10 13:59:19', '2013-01-10 13:59:24', 1, 0, 5, 3001, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 74),
(10674, 220, '2013-01-10 13:59:22', '2013-01-10 13:59:27', 1, 0, 5, 3001, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 74),
(10675, 221, '2013-01-10 13:58:44', '2013-01-10 13:59:35', 1, 0, 51, 18001, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 74),
(10676, 221, '2013-01-10 13:58:47', '2013-01-10 13:59:39', 1, 0, 52, 18001, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 74),
(10677, 225, '2013-01-10 13:59:29', '2013-01-10 13:59:48', 0, 0, 19, 3001, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 74),
(10678, 215, '2013-01-10 13:59:04', '2013-01-10 13:59:53', 1, 0, 49, 3001, 305172900, 'aindrabudi@mpdev14', '3.5.1353', 74),
(10679, 225, '2013-01-10 13:59:38', '2013-01-10 13:59:57', 1, 0, 19, 3001, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 74),
(10680, 229, '2013-01-10 13:59:59', '2013-01-10 14:00:00', 1, 0, 1, 101, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 74),
(10681, 229, '2013-01-10 14:00:03', '2013-01-10 14:00:04', 1, 0, 1, 101, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 74),
(10682, 225, '2013-01-10 13:59:43', '2013-01-10 14:00:04', 1, 0, 21, 3001, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 74),
(10683, 229, '2013-01-10 14:00:08', '2013-01-10 14:00:08', 1, 0, 0, 101, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 74),
(10684, 225, '2013-01-10 13:59:50', '2013-01-10 14:00:14', 1, 0, 24, 3001, 305172900, 'aindrabudi@mpdev14', '0.0.0000', 74),
(10685, 256, '2013-01-10 14:04:01', '2013-01-10 14:04:28', 1, 0, 27, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10686, 256, '2013-01-10 14:04:03', '2013-01-10 14:04:31', 1, 0, 28, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10687, 256, '2013-01-10 14:04:08', '2013-01-10 14:04:39', 1, 0, 31, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10688, 256, '2013-01-10 14:04:05', '2013-01-10 14:04:43', 1, 0, 38, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10689, 256, '2013-01-10 14:04:00', '2013-01-10 14:04:44', 1, 0, 44, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10690, 256, '2013-01-10 14:04:14', '2013-01-10 14:04:54', 1, 0, 40, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10691, 256, '2013-01-10 14:04:11', '2013-01-10 14:04:55', 1, 0, 44, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10692, 256, '2013-01-10 14:04:16', '2013-01-10 14:05:03', 1, 0, 47, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10693, 256, '2013-01-10 14:04:34', '2013-01-10 14:05:18', 1, 0, 44, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10694, 256, '2013-01-10 14:04:31', '2013-01-10 14:05:20', 1, 0, 49, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10695, 256, '2013-01-10 14:04:44', '2013-01-10 14:05:38', 1, 0, 54, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10696, 256, '2013-01-10 14:04:48', '2013-01-10 14:05:43', 1, 0, 55, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10697, 256, '2013-01-10 14:04:58', '2013-01-10 14:05:45', 1, 0, 47, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10698, 256, '2013-01-10 14:04:46', '2013-01-10 14:05:48', 1, 0, 62, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10699, 256, '2013-01-10 14:05:01', '2013-01-10 14:05:56', 1, 0, 55, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10700, 256, '2013-01-10 14:05:08', '2013-01-10 14:06:02', 1, 0, 54, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10701, 256, '2013-01-10 14:05:21', '2013-01-10 14:06:24', 1, 0, 63, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10702, 256, '2013-01-10 14:05:24', '2013-01-10 14:06:27', 1, 0, 63, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10703, 256, '2013-01-10 14:05:42', '2013-01-10 14:06:41', 1, 0, 59, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10704, 256, '2013-01-10 14:05:46', '2013-01-10 14:06:50', 1, 0, 64, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10705, 256, '2013-01-10 14:05:54', '2013-01-10 14:07:01', 1, 0, 67, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10706, 256, '2013-01-10 14:06:01', '2013-01-10 14:07:10', 1, 0, 69, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10707, 256, '2013-01-10 14:05:51', '2013-01-10 14:07:10', 1, 0, 79, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10708, 256, '2013-01-10 14:06:08', '2013-01-10 14:07:13', 1, 0, 65, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10709, 256, '2013-01-10 14:06:32', '2013-01-10 14:07:38', 1, 0, 66, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10710, 256, '2013-01-10 14:06:29', '2013-01-10 14:07:41', 1, 0, 72, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10711, 256, '2013-01-10 14:06:54', '2013-01-10 14:07:56', 1, 0, 62, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10712, 256, '2013-01-10 14:06:47', '2013-01-10 14:08:02', 1, 0, 75, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10713, 256, '2013-01-10 14:07:06', '2013-01-10 14:08:29', 1, 0, 83, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10714, 256, '2013-01-10 14:07:20', '2013-01-10 14:08:31', 1, 0, 71, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10715, 256, '2013-01-10 14:07:14', '2013-01-10 14:08:38', 1, 0, 84, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10716, 256, '2013-01-10 14:07:17', '2013-01-10 14:08:41', 1, 0, 84, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10717, 256, '2013-01-10 14:07:45', '2013-01-10 14:08:53', 1, 0, 68, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10718, 256, '2013-01-10 14:07:42', '2013-01-10 14:09:02', 1, 0, 80, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10719, 256, '2013-01-10 14:08:07', '2013-01-10 14:09:11', 1, 0, 64, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10720, 256, '2013-01-10 14:08:00', '2013-01-10 14:09:13', 1, 0, 73, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10721, 256, '2013-01-10 14:08:36', '2013-01-10 14:09:22', 1, 0, 46, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10722, 256, '2013-01-10 14:08:34', '2013-01-10 14:09:24', 1, 0, 50, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10723, 256, '2013-01-10 14:08:44', '2013-01-10 14:09:35', 1, 0, 51, 501, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 75),
(10724, 276, '2013-01-10 14:14:22', '2013-01-10 14:14:25', 1, 0, 3, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 76),
(10725, 276, '2013-01-10 14:14:24', '2013-01-10 14:14:27', 1, 0, 3, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 76),
(10726, 276, '2013-01-10 14:14:21', '2013-01-10 14:15:45', 1, 0, 84, 3001, 305173100, 'aindrabudi@mpdev14', '0.0.0000', 76);
/*!40000 ALTER TABLE `simresult` ENABLE KEYS */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;


what i would like to have is to have east test uid return it sums for 1 run no(run no 5 or run no 7) and count how many testuid in a run no and display display testUID with the max run no of each test uid

eg:
test uid runNo sum(result) count()
201 7 3 7
202 5 2 5
203 67 7 10


Thanks,

Options: ReplyQuote


Subject Written By Posted
mysql query asadilan indrabudi 01/10/2013 03:18PM
Re: mysql query laptop alias 01/10/2013 05:05PM
Re: mysql query Phillip Ward 01/11/2013 08:06AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.