0
<strong><p align="center">Air Conditioner Data Update</p></strong><br> 

<?php
$host="localhost"; // Host name 
$username="root"; // Mysql username 
$password=""; // Mysql password 
$db_name="onm"; // Database name 
$tbl_name="sims_ac"; // Table name 

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");
 $a=$_REQUEST['a']; //Its getting value from previoes page
 echo $a; //its echoing value which I get from previous page.
//$a='1008'; // its static value this code work perfectly when I assign value like this, but not working when I get the value from previoes page.

$sql="SELECT * FROM $tbl_name WHERE mid(SiteID,7)='$a'";
$result=mysql_query($sql);

// Count table rows 
$count=mysql_num_rows($result);
?>
<table  width="500" border="0" cellspacing="1" cellpadding="0">
<form name="form1" method="post" action="sims_ac_update.php">
<tr> 
<td>
<table class="mytable" width="500" border="0" cellspacing="1" cellpadding="0">


<tr>
<td align="center"><strong>SiteId</strong></td>
<td align="center"><strong></strong></td>
<td align="center"><strong>AcMake</strong></td>
<td align="center"><strong>AcCapacity </strong></td>
<td align="center"><strong>AMP</strong></td>
<td align="center"><strong>qty</strong></td>


</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>

<td align="center"><? //$SiteId[]=$a; ?><? echo $a; ?></td>
<td align="center"><input name="SrNo[]" type="hidden" id="SrNo" value="<? echo $rows['SrNo']; ?>"></td>
<td align="center"><input name="AcMake[]" type="text" id="AcMake" value="<? echo $rows['AcMake']; ?>"></td>
<td align="center"><input name="AcCapacity[]" type="text" id="AcCapacity" value="<? echo $rows['AcCapacity']; ?>"></td>
<td align="center"><input name="AMP[]" type="text" id="AMP" value="<? echo $rows['AMP']; ?>"></td>
<td align="center"><input name="qty[]" type="text" id="qty" value="<? echo $rows['qty']; ?>"></td>
</tr>
<?php
}
?>
<tr>
<td colspan="4" align="center"><input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
</td>
</tr>
</form>
</table>
<?php
// Check if button name "Submit" is active, do this 
if($_REQUEST["Submit"]=="Submit")
{
for($i=0;$i<$count;$i++){

echo $a;
$b= $_POST['AcMake'][$i];
//echo $b;
$c= $_POST['AcCapacity'][$i];
//echo $c;
$d= $_POST['AMP'][$i];
//echo $d;
$e= $_POST['qty'][$i];
//echo $e;
$f= $_POST['SrNo'][$i];
//echo $f;
$query=mysql_query("UPDATE $tbl_name SET AcMake='$b', AcCapacity='$c', AMP='$d', qty='$e' WHERE mid(SiteId,7)='$a' AND SrNo='$f'");


}
}

if($quyery){
header("location:sims_ac_update.php");
}
mysql_close();
?>
2
Contributors
6
Replies
7
Views
7 Years
Discussion Span
Last Post by hemgoyal_1990
0

Change Your Line #65 from:

if($_REQUEST["Submit"]=="Submit")

With this One:

if (isset($_POST['Submit']))

Your Code will Work.

0

Change Your Line #65 from:

if($_REQUEST["Submit"]=="Submit")

With this One:

if (isset($_POST['Submit']))

Your Code will Work.

Here is my table and data please check its not working.

-- phpMyAdmin SQL Dump
-- version 3.1.3.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 21, 2009 at 05:29 PM
-- Server version: 5.1.33
-- PHP Version: 5.2.9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `onm`
--

-- --------------------------------------------------------

--
-- Table structure for table `sims_ac`
--

CREATE TABLE IF NOT EXISTS `sims_ac` (
  `SrNo` int(11) NOT NULL AUTO_INCREMENT,
  `SiteID` varchar(11) NOT NULL,
  `region` varchar(10) NOT NULL,
  `AcMake` varchar(60) NOT NULL,
  `AcCapacity` varchar(10) NOT NULL,
  `IndoorNo` varchar(15) NOT NULL,
  `OutDoorNo` varchar(10) NOT NULL,
  `AMP` varchar(10) NOT NULL,
  `qty` int(5) NOT NULL,
  PRIMARY KEY (`SrNo`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1269 ;

--
-- Dumping data for table `sims_ac`
--

INSERT INTO `sims_ac` (`SrNo`, `SiteID`, `region`, `AcMake`, `AcCapacity`, `IndoorNo`, `OutDoorNo`, `AMP`, `qty`) VALUES
(1, 'S-KTR-0139', 'South', 'Haier', '18000', '60003845', '8400865', '9.1', 1),
(2, 'S-KTR-0139', 'South', 'Haier', '18000', '10000954', '8400327', '8.3', 1),
(3, 'S-HNS-1008', 'South', 'LG', '24000', '10029', '76778256', '11.6', 1),
(4, 'S-HNS-1008', 'South', 'LG', '24000', 'NIL', '605TAKK220', '11.5', 1),
(5, 'S-JHO-0257', 'South', 'Haier', '18000', '84T0116', 'AC82AP1731', '9.1', 1),
(6, 'S-JHO-0257', 'South', 'Haier', '18000', 'AC83H3167', 'H1634', '8.1', 1),
(7, 'S-NOR-0104', 'South', 'LG', '18000', 'CM210335', 'CM01825307', '9.1', 1),
(8, 'S-BNH-0135', 'South', 'LG', '18000', 'NA123548', 'NA89542', '5.2', 1),
(9, 'S-BNH-0135', 'South', 'Waves', '12000', 'NIL', 'NIL', '9.1', 1),
(10, 'S-HYD-0074', 'South', 'LG', '24000', '605TADR045870', 'NIL', '9.1', 1),
(11, 'S-HYD-0074', 'South', 'LG', '24000', '705NA789145', 'NIL', '9.1', 1),
(12, 'S-HYD-0074', 'South', 'Haier', '18000', '3H87542894', '100002530', '8.9', 1),
(13, 'MSC', 'South', 'Hitachi', '18000', '712258919', '88147929', '8.9', 1),
(14, 'MSC', 'South', 'Hitachi', '18000', '915226489', '55569821', '8.8', 1),
(15, 'MSC', 'South', 'Hitachi', '18000', '33254972', '33647892', '9.1', 1),
(16, 'S-HYD-0093', 'South', 'Haier', '18000', '300AC33', '60003976', '8.9', 1),
(17, 'S-HYD-0093', 'South', 'Mitsubishi', '24000', 'NIL', 'NIL', '11.6', 1),
(18, 'S-HYD-0184', 'South', 'LG', '24000', 'NA67882', 'NA67564', '11.4', 1),
(19, 'S-HYD-0184', 'South', 'LG', '24000', '803NA223597', 'NIL', '11.5', 1),
(20, 'S-HYD-1700', 'South', 'LG', '24000', '605TAVY54871', '608NA87962', '11.7', 1),
(21, 'S-HYD-1700', 'South', 'LG', '24000', '605TADR23501', '608NA00123', '11.8', 1),
(22, 'S-KIT-1480', 'South', 'LG', '24000', 'NIL', 'NA102246', '11.6', 1),
(23, 'S-KIT-1480', 'South', 'LG', '24000', 'NIL', 'NA02795', '11.8', 1),
(24, 'S-BHS-0974', 'South', 'LG', '24000', '410KABF0989', 'NA215L12', '11.8', 1),
(25, 'S-BHS-0974', 'South', 'LG', '24000', '410KASL00970', 'NA036521', '11.7', 1),
(26, 'S-HYD-1399', 'South', 'LG', '24000', 'NIL', 'NA12122457', '11.6', 1),
(27, 'S-HYD-1399', 'South', 'LG', '24000', '711NA14572', 'NA127583', '11.5', 1),
(28, 'S-HYD-0393', 'South', 'LG', '24000', '705NA 252489', 'NIL', '11.6', 1),
(29, 'S-HYD-0393', 'South', 'LG', '24000', '705NA252490', 'NIL', '11.4', 1),
(30, 'S-HYD-1397', 'South', 'LG', '24000', 'NA135678', 'NA023697', '1.5', 1),
(31, 'S-HYD-1397', 'South', 'LG', '24000', 'NA45890', 'NA02546', '11.4', 1),
(32, 'S-NOR-0349', 'South', 'LG', '24000', '410KA000850', 'NA22054', '6.1', 1),
(33, 'S-NOR-0349', 'South', 'LG', '24000', '705NA222154', 'NA225148', '5.7', 1),
(34, 'S-HYD-0075', 'South', 'LG', '18000', 'NIL', 'NIL', '9.1', 1),
(35, 'S-HYD-0075', 'South', 'Haier', '18000', '3539', 'NIL', '8.7', 1),
(36, 'S-HYD-1398', 'South', 'LG', '24000', '2145820', 'NA88932', '11.6', 1),
(37, 'S-KID-1471', 'South', 'LG', '24000', 'CM2245621', '10155612', '11.6', 1),
(38, 'S-KID-1471', 'South', 'LG', '24000', 'NIL', 'NA402265', '11.5', 1),
(39, 'S-HYD-0188', 'South', 'Haier', '18000', 'AC3H3652210002', 'NIL', '9.1', 1),
(40, 'S-HYD-0188', 'South', 'LG', '18000', 'NA25963331', 'NIL', '9.1', 1),
(41, 'S-KTR-0812', 'South', 'LG', '24000', 'NA66827', 'NA66827', '11.5', 1),
(42, 'S-KTR-0812', 'South', 'LG', '24000', '803NA029489', 'NIL', '11.5', 1),
(43, 'S-HBT-1404', 'South', 'LG', '24000', 'NA75663', 'NA213001', '11.7', 1),
(44, 'S-HBT-1404', 'South', 'LG', '24000', '2524', 'NA217589', '11.6', 1),
(45, 'S-HYD-0483', 'South', 'LG', '24000', '410KA000900', 'NA532165', '11.6', 1),
(46, 'S-HYD-0483', 'South', 'LG', '24000', '604TAUV09506', 'NA534321', '11.5', 1),
(47, 'S-HYD-0182', 'South', 'LG', '24000', 'NA11119493', 'NA120048', '11.9', 1),
(48, 'S-HYD-0182', 'South', 'LG', '24000', 'NA119471', 'NA120042', '11.5', 1),
(49, 'S-HNS-1410', 'South', 'LG', '24000', 'NIL', 'K836152341', '11.5', 1),
(50, 'S-HNS-1410', 'South', 'LG', '24000', 'CM252078C', 'NA24513', '11.4', 1),
(51, 'S-MRI-0254', 'South', 'LG', '18000', '803NA029419', 'NIL', '9.1', 1),
(52, 'S-MRI-0254', 'South', 'LG', '18000', '605TAVY04135', '608NA28659', '9.2', 1),
(53, 'S-TDM-0168', 'South', 'LG', '24000', 'NA66827', 'NA66827', '11.4', 1),
(54, 'S-TDM-0168', 'South', 'LG', '24000', '803NA029489', 'NIL', '11.5', 1),
(55, 'S-TDM-0100', 'South', 'LG', '18000', 'TASW01454', 'NA141943', '9.1', 1),
(56, 'S-TDM-0100', 'South', 'General', '24000', 'T042663', 'NIL', '11.6', 1),
(57, 'S-HYD-0312', 'South', 'LG', '24000', '101460', 'NIL', '9.4', 1),
(58, 'S-HYD-0312', 'South', 'LG', '24000', 'NA121317', 'NA121910', '9.1', 1),
(59, 'S-KID-1472', 'South', 'LG', '24000', '711NA111121', '21458932', '11.6', 1),
(60, 'S-KID-1472', 'South', 'LG', '24000', '604TAVY2223658', '11203555', '11.5', 1),
(61, 'S-MTI-0157', 'South', 'Sabro', '18000', 'NIL', 'NIL', '5.6', 1),
(62, 'S-MTI-0157', 'South', 'Sabro', '12000', 'NIL', 'NIL', '8.9', 1),
(63, 'S-HYD-1396', 'South', 'LG', '24000', '605TAVY04135', '608NA28659', '11.1', 1),
(64, 'S-HYD-1396', 'South', 'LG', '24000', '605TADR03426', '608NA28090', '11.5', 1),
(65, 'S-HYD-0393', 'South', 'LG', '24000', '705NA6589214', 'NIL', '11.4', 1),
(66, 'S-HYD-0393', 'South', 'LG', '24000', '705NA9658213', 'NIL', '11.4', 1),
(67, 'S-JCB-1010', 'South', 'Haier', '18000', 'AC83H000062', 'NIL', '8.9', 1),
(68, 'S-JCB-1010', 'South', 'LG', '18000', 'NA3633324', 'NA252871', '9.1', 1),
(69, 'S-KIT-1480', 'South', 'LG', '24000', 'NIL', 'NA102246', '11.7', 1),
(70, 'S-KIT-1480', 'South', 'LG', '24000', 'NIL', 'NA02795', '11.6', 1),
(71, 'S-JAT-1515', 'South', 'LG', '24000', '501KLM9825647', '505na20594', '11.3', 1),
(72, 'S-JAT-1515', 'South', 'LG', '24000', '705NA78209', 'NIL', '11.4', 1),
(73, 'S-DAR-1294', 'South', 'LG', '24000', 'NIL', '705NA88920', '11.4', 1),
(74, 'S-DAR-1294', 'South', 'LG', '24000', 'NIL', '705NA88920', '11.5', 1),
(75, 'S-MEH-1589', 'South', 'LG', '24000', '312004', '708NA01254', '11.4', 1),
(76, 'S-MEH-1589', 'South', 'LG', '24000', 'NIL', '708NA55800', '11.5', 1),
(77, 'S-NFZ-1329', 'South', 'LG', '24000', '806NA101416', '84000012', '11.6', 1),
(78, 'S-NFZ-1329', 'South', 'LG', '24000', '806NA101460', '604TALV540', '11.7', 1),
(79, 'S-BAC-0973', 'South', 'LG', '24000', 'NIL', '605NA15415', '11.6', 1),
(80, 'S-BAC-0973', 'South', 'LG', '24000', '605TAVY22547', '605NA25417', '11.4', 1),
(81, 'S-THS-1113', 'South', 'LG', '24000', 'NA23658', 'NIL', '11.5', 1),
(82, 'S-THS-1113', 'South', 'LG', '24000', 'NA212301', 'NIL', '11.5', 1),
(83, 'S-MOR-0158', 'South', 'LG', '24000', 'PK325461', 'NA96125', '11.6', 1),
(84, 'S-MOR-0158', 'South', 'LG', '24000', 'CM220357', 'NIL', '11.4', 1),
(85, 'S-HLA-0999', 'South', 'LG', '24000', 'NA22548', 'NA5789281', '11.7', 1),
(86, 'S-HLA-0999', 'South', 'LG', '24000', 'NA110039', 'NA5873156', '11.6', 1),
(87, 'S-SNN-1561', 'South', 'LG', '24000', 'NA548933', 'NIL', '11.4', 1),
(88, 'S-SNN-1561', 'South', 'LG', '24000', 'NA548934', 'NIL', '11.5', 1),
(89, 'S-BRR-1291', 'South', 'LG', '24000', '507NA0021', 'NA23589', '11.4', 1),
(90, 'S-BRR-1291', 'South', 'LG', '24000', '507NA0023', 'NA23568', '11.5', 1),
(91, 'S-NWB-0839', 'South', 'LG', '24000', '2589001', 'NA76221', '11.5', 1),
(92, 'S-NWB-0839', 'South', 'LG', '24000', '4582223', 'NA75880', '11.4', 1),
(93, 'S-SDP-0179', 'South', 'Haier', '18000', 'AC83H009825', 'NIL', '9.1', 1),
(94, 'S-SDP-0179', 'South', 'Haier', '18000', 'AC83H009826', 'NIL', '9.1', 1),
(95, 'S-NFZ-0321', 'South', 'Haier', '18000', 'H000098701', '2415891', '9.1', 1),
(96, 'S-NFZ-0321', 'South', 'Waves', '12000', 'NIL', 'NIL', '5.6', 1),
(97, 'S-NWB-0821', 'South', 'LG', '24000', '705NA582261', '2455612', '11.4', 1),
(98, 'S-NWB-0821', 'South', 'LG', '24000', '705NA235811', '2458221', '11.5', 1),
(99, 'S-SYD-0191', 'South', 'Sabro', '12000', 'NIL', 'NIL', '5.4', 1),
(100, 'S-SYD-0191', 'South', 'Sabro', '12000', 'NIL', 'NIL', '', 1),
(101, 'S-HLA-0144', 'South', 'Sabro', '12000', 'NIL', 'NIL', '5.6', 1),
(102, 'S-HLA-0144', 'South', 'Sabro', '12000', 'NIL', 'NIL', '5.4', 1),
(103, 'S-DLP-0983', 'South', 'LG', '24000', '705NA582296', '2246912', '11.4', 1),
(104, 'S-DLP-0983', 'South', 'LG', '24000', '705NA229851', '2246913', '11.5', 1),
(105, 'S-SWN-0138', 'South', 'LG', '18000', '806NA5822961', 'NIL', '9.1', 1),
(106, 'S-SWN-0138', 'South', 'Sabro', '12000', 'NIL', 'NIL', '5.4', 1),
(107, 'S-MHI-0259', 'South', 'LG', '24000', '705NA0021', '705NA5899', '11', 1),
(108, 'S-MHI-0259', 'South', 'Haier', '18000', 'ACH83000289', 'NIL', '9', 1),
(109, 'S-DON-0990', 'South', 'LG', '24000', '605NA5501', '605NA55698', '11.5', 1),
(110, 'S-DON-0990', 'South', 'LG', '24000', '605NA5502', '605NA89221', '13', 1),
(111, 'S-SUR-1089', 'South', 'LG', '24000', '6955248', 'NIL', '11.5', 1),
(112, 'S-SUR-1089', 'South', 'LG', '24000', '6312540', 'NIL', '11', 1),
(113, 'S-KMD-1033', 'South', 'LG', '24000', '5589213', 'NIL', '11', 1),
(114, 'S-KMD-1033', 'South', 'LG', '24000', '2564190', 'NIL', '12.8', 1),
(115, 'S-RWY-1212', 'South', 'LG', '24000', '806NA00231', '226980', '11.5', 1),
(116, 'S-RWY-1212', 'South', 'LG', '24000', '806NA00232', '125960', '12.3', 1),
(117, 'S-MGI-1048', 'South', 'LG', '24000', '64218900', 'NIL', '12.6', 1),
(118, 'S-MGI-1048', 'South', 'LG', '24000', '89563200', 'NIL', '13', 1),
(119, 'S-STB-0336', 'South', 'LG', '24000', '289463275', 'NIL', '11.5', 1),
(120, 'S-STB-0336', 'South', 'LG', '24000', '225496324', 'NA8956247', '10', 1),
(121, 'S-MPK-0818', 'South', 'LG', '24000', '705NA65022', '22159600', '11', 1),
(122, 'S-MPK-0818', 'South', 'LG', '24000', '705NA65023', '2215632', '12', 1),
(123, 'S-MPK-0819', 'South', 'LG', '24000', '22541369', 'NIL', '11.3', 1),
(124, 'S-MPK-0819', 'South', 'LG', '24000', '22145963', 'NIL', '12', 1),
(125, 'S-MPK-0095', 'South', 'LG', '24000', 'NA524890', 'NIL', '11.5', 1),
(126, 'S-MPK-0095', 'South', 'LG', '24000', 'NA524891', 'NIL', '12', 1),
(127, 'S-MPK-0096', 'South', 'LG', '24000', 'NIL', 'NIL', '12.3', 1),
(128, 'S-JDM-1414', 'South', 'LG', '24000', '806NA5899', '554890', '11', 1),
(129, 'S-JDM-1414', 'South', 'LG', '24000', '806NA00231', '589125', '10.6', 1),
(130, 'S-MGD-1500', 'South', 'LG', '24000', '5891254', 'NIL', '11.5', 1),
(131, 'S-MGD-1500', 'South', 'LG', '24000', '298225', 'NIL', '12', 1),
(132, 'S-MGD-1501', 'South', 'LG', '24000', '145269', '100269', '11.5', 1),
(133, 'S-MGD-1501', 'South', 'LG', '24000', '254892', '100258', '11', 1),
(134, 'S-IMK-1299', 'South', 'LG', '24000', '236591', 'NIL', '11', 1),
(135, 'S-DGT-0347', 'South', 'Haier', '18000', '3H3364', '3929', '7.6', 1),
(136, 'S-DGT-0347', 'South', 'Haier', '18000', '84T0116', '3372', '7.2', 1),
(137, 'S-KHI-0719', 'South', 'LG', '24000', 'NIL', '91330', '10.9', 1),
(138, 'S-KHI-0719', 'South', 'LG', '24000', 'NIL', '91325', '11.1', 1),
(139, 'S-KHI-0756', 'South', 'LG', '24000', '119484', 'NIL', '11.3', 1),
(140, 'S-KHI-0756', 'South', 'LG', '24000', '1194817', 'NIL', '10.1', 1),
(141, 'S-KHI-0089', 'South', 'Mitsubishi', '24000', '24004239T', '4005321', '11.8', 1),
(142, 'S-KHI-0089', 'South', 'Mitsubishi', '24000', '4004743T', '4003322T', '11.7', 1),
(143, 'S-KHI-0007', 'South', 'LG', '24000', '4290', 'NA023732', '', 1),
(144, 'S-KHI-0239', 'South', 'LG', '24000', 'NA109982', 'NA108733', '', 1),
(145, 'S-KHI-0239', 'South', 'LG', '24000', 'NA110039', 'NA108590', '11', 1),
(146, 'S-KHI-0763', 'South', 'LG', '24000', '1031', '121615', '10.9', 1),
(147, 'S-KHI-0763', 'South', 'LG', '24000', '93429', '120128', '10.7', 1),
(148, 'S-KHI-0759', 'South', 'LG', '24000', 'NIL', 'NA95517', '11.3', 1),
(149, 'S-KHI-0759', 'South', 'LG', '24000', 'NA91266', 'NA91266', '10.5', 1),
(150, 'S-KHI-1450', 'South', 'LG', '24000', 'NA099611', 'NIL', '11.2', 1),
(151, 'S-KHI-0232', 'South', 'LG', '18000', 'Z01611', '505NA565', '', 1),
(152, 'S-KHI-0232', 'South', 'LG', '18000', 'C12384', '503NA47499', '', 1),
(153, 'S-KHI-0004', 'South', 'LG', '24000', '5451', 'NA284773', '11.1', 1),
(154, 'S-KHI-0004', 'South', 'LG', '24000', '4468', 'NA284716', '10.8', 1),
(155, 'S-KHI-0653', 'South', 'LG', '24000', 'NA91703', 'NIL', '10.9', 1),
(156, 'S-KHI-0653', 'South', 'LG', '24000', 'NA93354', 'NA95444', '11.3', 1),
(157, 'S-KHI-0052', 'South', 'LG', '18000', '705NA77637', 'NIL', '9', 1),
(158, 'S-KHI-0052', 'South', 'Mitsubishi', '24000', '3001628T', '3001087', '12.3', 1),
(159, 'S-KHI-1435', 'South', 'LG', '24000', 'NA0342239', 'NIL', '10.4', 1),
(160, 'S-KHI-1435', 'South', 'LG', '24000', 'NA034243', 'NIL', '12.3', 1),
(161, 'S-KHI-0058', 'South', 'Haier', '18000', 'AC84P1083', 'NIL', '7.5', 1),
(162, 'S-KHI-0006', 'South', 'LG', '18000', 'NA77272', 'NA71385', '12.1', 1),
(163, 'S-KHI-0008', 'South', 'LG', '24000', 'AVY06631', 'NA284287', '11.3', 1),
(164, 'S-KHI-0008', 'South', 'LG', '24000', 'AYT03026', 'NA285937', '10.9', 1),
(165, 'S-KHI-0305', 'South', 'Haier', '18000', 'AC83H3167', '10003990', '8.1', 1),
(166, 'S-KHI-0305', 'South', 'Haier', '18000', 'AC83H1094', '10000017', '7.6', 1),
(167, 'S-KHI-0303', 'South', 'Sabro', '18000', '51058', '50241', '8.3', 1),
(168, 'S-KHI-0303', 'South', 'Haier', '18000', 'AC83H2277', '10000852', '7.9', 1),
(169, 'S-KHI-0070', 'South', 'LG', '18000', 'NA86198', 'NA81447', '11.4', 1),
(170, 'S-KHI-0070', 'South', 'Haier', '18000', 'AC83H2376', '10003991', '7.9', 1),
(171, 'S-KHI-0070', 'South', 'Haier', '18000', 'AC83H2481', '100041777', '', 1),
(172, 'S-KHI-0226', 'South', 'LG', '24000', '279', 'NA40165', '12.9', 1),
(173, 'S-KHI-0226', 'South', 'LG', '24000', '894', 'NA46925', '12.7', 1),
(174, 'S-KHI-0076', 'South', 'LG', '24000', '286', 'NA08884', '12.5', 1),
(175, 'S-KHI-0076', 'South', 'LG', '24000', '969', 'NA08996', '12.8', 1),
(176, 'S-KHI-0077', 'South', 'Pel', '24000', 'NIL', 'TD010804', '12.7', 1),
(177, 'S-KHI-0077', 'South', 'Pel', '23000', 'NIL', '10404', '10.6', 1),
(178, 'S-KHI-0894', 'South', 'LG', '24000', '707NA9691', 'NIL', '12.6', 1),
(179, 'S-KHI-0894', 'South', 'LG', '24000', '707NA91201', 'NIL', '12.8', 1),
(180, 'S-KHI-1448', 'South', 'LG', '24000', 'NA011295', 'CM230505', '11.5', 1),
(181, 'S-KHI-1448', 'South', 'LG', '24000', '11328', 'CM230506', '11.9', 1),
(182, 'S-KHI-1453', 'South', 'LG', '24000', 'NA011313', 'NIL', '10.8', 1),
(183, 'S-KHI-1453', 'South', 'LG', '24000', 'NA011294', 'NIL', '', 1),
(184, 'S-KHI-0233', 'South', 'Haier', '18000', '3111634', '3987', '7.5', 1),
(185, 'S-KHI-0233', 'South', 'Haier', '18000', '3H3476', '1000850', '7.1', 1),
(186, 'S-KHI-0413', 'South', 'LG', '24000', '605TAYV01906', '607NA14223', '13', 1),
(187, 'S-KHI-0413', 'South', 'LG', '24000', '604TAUL00518', '605NA14228', '12.7', 1),
(188, 'S-KHI-0307', 'South', 'LG', '24000', 'ANS01415', 'NA142326', '12.3', 1),
(189, 'S-KHI-0307', 'South', 'LG', '24000', 'TASW01454', 'NA141943', '', 1),
(190, 'S-KAJ-0968', 'South', 'LG', '24000', '712NA121341', '712NA12131', '', 1),
(191, 'S-KAJ-0968', 'South', 'LG', '24000', '801NA12195', '801NA12191', '', 1),
(192, 'S-KHI-1254', 'South', 'LG', '24000', '34057', 'NIL', '11.9', 1),
(193, 'S-KHI-1254', 'South', 'LG', '24000', 'NA034191', 'NIL', '12.1', 1),
(194, 'S-KHI-0219', 'South', 'Haier', '18000', 'H2202', 'NIL', '8.2', 1),
(195, 'S-KHI-0219', 'South', 'Haier', '18000', '3H2460', 'NIL', '8.4', 1),
(196, 'S-KHI-0065', 'South', 'Pel', '24000', 'NIL', 'NIL', '11.8', 1),
(197, 'S-KHI-0065', 'South', 'Haier', '18000', '3H3785', '1004019', '12', 1),
(198, 'S-KHI-0019', 'South', 'LG', '24000', '605TAWM00481', 'NA284117', '11.9', 1),
(199, 'S-KHI-0019', 'South', 'LG', '24000', '605TAXT00906', 'NA284181', '12', 1),
(200, 'S-KHI-0019', 'South', 'Sanyo', '24000', '281398', '228598', '11.9', 1),
(201, 'S-KHI-0369', 'South', 'LG', '24000', 'NA95539', 'NA95539', '12', 1),
(202, 'S-KHI-0369', 'South', 'LG', '24000', 'NA91372', 'NIL', '', 1),
(203, 'S-KHI-0443', 'South', 'LG', '24000', 'NA11119493', 'NA120048', '12.4', 1),
(204, 'S-KHI-0443', 'South', 'LG', '24000', 'NA119471', 'NA120042', '12.1', 1),
(205, 'S-KHI-0308', 'South', 'LG', '24000', 'KAF0075', 'NA66304', '9.3', 1),
(206, 'S-KHI-0308', 'South', 'Haier', '18000', '3H3782', '1000566', '7.6', 1),
(207, 'S-KHI-0026', 'South', 'Haier', '18000', '84PO0730', '60003841', '8.3', 1),
(208, 'S-KHI-0026', 'South', 'LG', '24000', '604TABNO1941', '607NA14308', '12.3', 1),
(209, 'S-KHI-0071', 'South', 'Haier', '18000', 'AC83H3990', '60004226', '8', 1),
(210, 'S-KHI-0071', 'South', 'Mitsubishi', '24000', '3001135', '3000941', '11.9', 1),
(211, 'S-KHI-0025', 'South', 'Haier', '18000', '10516482', '10000848', '7.9', 1),
(212, 'S-KHI-0025', 'South', 'Haier', '18000', '10516482', '10000593', '7.9', 1),
(213, 'S-KHI-0328', 'South', 'LG', '24000', 'NIL', '605TAEJ017', '12.3', 1),
(214, 'S-KHI-0328', 'South', 'LG', '24000', '605THQ00873', '607NA14221', '12', 1),
(215, 'S-KHI-0064', 'South', 'Pel', '24000', 'NIL', 'NIL', '11.8', 1),
(216, 'S-KHI-0083', 'South', 'LG', '18000', '705NA77709', '705NA71163', '8.3', 1),
(217, 'S-KHI-0083', 'South', 'LG', '24000', '410KABF0989', '412NA08971', '12.6', 1),
(218, 'S-KHI-0083', 'South', 'LG', '24000', '410KASL00830', '412NA08972', '12.3', 1),
(219, 'S-KHI-0010', 'South', 'LG', '24000', '605TAJD82644', '607NA14365', '12.5', 1),
(220, 'S-KHI-0010', 'South', 'LG', '24000', '605TAEJ0225', '607NA14367', '11.9', 1),
(221, 'S-KHI-0010', 'South', 'Mitsubishi', '24000', '300200', '3000783', '12', 1),
(222, 'S-KHI-0084', 'South', 'LG', '24000', '5410KA200829', '412NA09003', '11.9', 1),
(223, 'S-KHI-0084', 'South', 'LG', '24000', '410KA000900', '407NA58741', '12', 1),
(224, 'S-KHI-0129', 'South', 'Haier', '18000', '60003845', 'AC83040476', '7', 1),
(225, 'S-KHI-0129', 'South', 'Haier', '18000', '10000954', 'AC80H2002', '7.8', 1),
(226, 'S-KHI-0038', 'South', 'LG', '24000', '604TAUV09506', 'NIL', '12.9', 1),
(227, 'S-KHI-0038', 'South', 'LG', '24000', '605TARO66780', 'NIL', '13', 1),
(228, 'S-KHI-0038', 'South', 'Mitsubishi', '24000', '3001108T', '3000767', '12.6', 1),
(229, 'S-KHI-0643', 'South', 'LG', '24000', 'NIL', '804NA53612', '12', 1),
(230, 'S-KHI-0643', 'South', 'LG', '24000', 'NIL', '804NA05452', '12.3', 1),
(231, 'S-KHI-0212', 'South', 'LG', '24000', '501KAVH05919', '503NA45581', '9.6', 1),
(232, 'S-KHI-0212', 'South', 'LG', '24000', '501KAME04952', '503NA45823', '9.1', 1),
(233, 'S-KHI-0230', 'South', 'LG', '18000', '497', 'NAS65775', '12', 1),
(234, 'S-KHI-0230', 'South', 'LG', '18000', 'NA66827', 'NA66827', '12.6', 1),
(235, 'S-KHI-0630', 'South', 'LG', '24000', '803NA029489', 'NIL', '11.6', 1),
(236, 'S-KHI-0630', 'South', 'LG', '24000', '803NA029419', 'NIL', '12.9', 1),
(237, 'S-KHI-0051', 'South', 'LG', '24000', '605TAVY04135', '608NA28659', '11.7', 1),
(238, 'S-KHI-0051', 'South', 'LG', '24000', '605TADR03426', '608NA28090', '11.4', 1),
(239, 'S-KHI-0051', 'South', 'LG', '18000', '705NA78187', 'NIL', '9.3', 1),
(240, 'S-KHI-0051', 'South', 'LG', '18000', '705NA78209', '705NA7284', '8.8', 1),
(241, 'S-KHI-0079', 'South', 'Pel', '24000', 'PK0005090', 'PEL24', '11.5', 1),
(242, 'S-KHI-0079', 'South', 'Pel', '24000', '5091', 'PEL24', '11.1', 1),
(243, 'S-KHI-0044', 'South', 'Sanyo', '24000', '150571', 'NIL', '8.2', 1),
(244, 'S-KHI-0044', 'South', 'Sanyo', '24000', '225771', 'NIL', '11.7', 1),
(245, 'S-KHI-0044', 'South', 'LG', '24000', 'NA77698', 'NA240074', '11.9', 1),
(246, 'S-KHI-0078', 'South', 'Pel', '24000', '1011', 'NIL', '11.5', 1),
(247, 'S-KHI-0078', 'South', 'Pel', '24000', '0144-04', 'NIL', '0', 1),
(248, 'S-KHI-0054', 'South', 'LG', '18000', 'NIL', 'NA023', '8.2', 1),
(249, 'S-KHI-0054', 'South', 'LG', '24000', 'NIL', 'NA00214', '12.3', 1),
(250, 'S-KHI-0751', 'South', 'LG', '24000', '709NA110410', '709NA10904', '12.4', 1),
(251, 'S-KHI-0751', 'South', 'LG', '24000', '709NA109042', 'NIL', '12.5', 1),
(252, 'S-KHI-0717', 'South', 'LG', '24000', '712NA12099', '712NA12016', '12.4', 1),
(253, 'S-KHI-0717', 'South', 'LG', '24000', '801NA121858', '801NA12190', '12.6', 1),
(254, 'S-KHI-0632', 'South', 'LG', '24000', 'NA053612', 'NIL', '12.3', 1),
(255, 'S-JAI-1300', 'South', 'LG', '24000', 'NIL', '803NA01049', '13', 1),
(256, 'S-JAI-1300', 'South', 'LG', '24000', '803V0012295', '803NA01049', '13', 1),
(257, 'S-GDW-1389', 'South', 'LG', '24000', '805NA069132', 'NIL', '12.3', 1),
(258, 'S-GDW-1389', 'South', 'LG', '24000', '804NA053798', 'NIL', '12.7', 1),
(259, 'S-GOL-0197', 'South', 'Sabro', '12000', '20060769', '2006366', '6.3', 1),
(260, 'S-DKR-1328', 'South', 'LG', '24000', 'NIL', '803NA02901', '12.3', 1),
(261, 'S-DKR-1328', 'South', 'LG', '24000', 'NIL', '803NA029.4', '11.9', 1),
(262, 'S-SCH-1568', 'South', 'LG', '24000', '803NA028790', 'NIL', '12.5', 1),
(263, 'S-SCH-1568', 'South', 'LG', '24000', '803NA028562', 'NIL', '12.6', 1),
(264, 'S-HBT-1124', 'South', 'LG', '18000', '705NA73744', '705NA79288', '8.3', 1),
(265, 'S-HBT-1124', 'South', 'Waves', '18000', 'PK0024064', 'NIL', '7.9', 1),
(266, 'S-SJL-0264', 'South', 'LG', '24000', '803NA0028597', 'NIL', '12', 1),
(267, 'S-SJL-0264', 'South', 'LG', '24000', 'NIL', 'NIL', '12.3', 1),
(268, 'S-KHI-0122', 'South', 'LG', '24000', '100282', 'NA58541', '12.6', 1),
(269, 'S-KHI-0407', 'South', 'LG', '', '709NA10860', '709NA10891', '12', 1),
(270, 'S-KHI-0407', 'South', 'LG', '', '709NA108994', '709NA10817', '12', 1),
(271, 'S-KHI-0306', 'South', 'LG', '', '10721', '2578', '11.9', 1),
(272, 'S-KHI-0306', 'South', 'LG', '', '10567', '2570', '12', 1),
(273, 'S-KHI-0001', 'South', 'LG', '', '509TAEJ09644', '512NA15021', '12.3', 1),
(274, 'S-KHI-0001', 'South', 'Mitsubishi', '', '3000824', '3000059', '12.5', 1),
(275, 'S-THB-0128', 'South', 'LG', '', '401KLAG00167', '501NA24444', '12', 1),
(276, 'S-THB-0128', 'South', 'LG', '', '401KAM200571', '501NA24466', '12.3', 1),
(277, 'S-KHI-0241', 'South', 'LG', '', '605TAXT01538', '605TAKK011', '11.5', 1),
(278, 'S-KHI-0241', 'South', 'LG', '', '607NA142275', '607NA14223', '10.8', 1),
(279, 'S-KHI-0081', 'South', 'LG', '', 'B00716', '49812', '8.3', 1),
(280, 'S-KHI-0081', 'South', 'LG', '', 'P00364', '49830', '8', 1),
(281, 'S-KHI-0407', 'South', 'LG', '', 'NA108179', 'NIL', '12', 1),
(282, 'S-KHI-0407', 'South', 'LG', '', 'Na108160', 'NIL', '12.5', 1),
(283, 'S-KHI-0943', 'South', 'LG', '', 'NA121329', 'NIL', '12.8', 1),
(284, 'S-KHI-0943', 'South', 'LG', '', '121345', 'NIL', '12.3', 1),
(285, 'S-KHI-1352', 'South', 'LG', '', 'NA034188', 'NIL', '11.9', 1),
(286, 'S-KHI-1352', 'South', 'LG', '', 'NA034109', 'NIL', '12', 1),
(287, 'S-KHI-0020', 'South', 'LG', '', '605TAJP02308', '608NA28571', '12.3', 1),
(288, 'S-KHI-0020', 'South', 'Haier', '', '3H0870', 'NIL', '8.9', 1),
(289, 'N-JHL-8064', 'North', 'Mitsubishi', '24000', '', '', '', 2),
(290, 'N-MAN-8060', 'North', 'Mitsubishi', '24000', '', '', '', 2),
(291, 'N-RWT-8024', 'North', 'LG', '24000', '', '', '', 2),
(292, 'N-CHL-8053', 'North', 'LG', '24000', '', '', '', 2),
(293, 'N-SOH-8022', 'North', 'LG', '24000', '', '', '', 3),
(294, 'N-TAX-8054', 'North', 'Sabro', '24000', '', '', '', 2),
(295, 'N-ISB-8000', 'North', 'Sabro', '18000', '', '', '', 5),
(296, 'N-ISB-8001', 'North', 'LG', '24000', '', '', '', 2),
(297, 'N-ISB-8002', 'North', 'LG', '24000', '', '', '', 2),
(298, 'N-ISB-8003', 'North', 'Fijia', '24000', '', '', '', 2),
(299, 'N-ISB-8004', 'North', 'Haier', '18000', '', '', '', 3),
(300, 'N-ISB-8005', 'North', 'Haier', '18000', '', '', '', 2),
(301, 'N-ISB-8007', 'North', 'General', '24000', '', '', '', 2),
(302, 'N-ISB-8008', 'North', 'LG', '24000', '', '', '', 2),
(303, 'N-ISB-8009', 'North', 'LG', '24000', '', '', '', 2),
(304, 'N-ISB-8010', 'North', 'Haier', '18000', '', '', '', 15),
(305, 'N-ISB-8011', 'North', 'Sabro', '24000', '', '', '', 2),
(306, 'N-ISB-8012', 'North', 'Mitsubishi', '24000', '', '', '', 2),
(307, 'N-ISB-8013', 'North', 'Fijia', '24000', '', '', '', 2),
(308, 'N-ISB-8014', 'North', 'Sabro', '18000', '', '', '', 2),
(309, 'N-ISB-8015', 'North', 'Sabro', '24000', '', '', '', 2),
(310, 'N-ISB-8017', 'North', 'Mitsubishi', '24000', '', '', '', 2),
(311, 'N-ISB-8018', 'North', 'Pel', '24000', '', '', '', 2),
(312, 'N-ISB-8019', 'North', 'LG', '24000', '', '', '', 2),
(313, 'N-HTY-8030', 'North', 'General', '24000', '', '', '', 2),
(314, 'N-PSH-8025', 'North', 'Acson', '40000', '', '', '', 3),
(315, 'N-PSH-8026', 'North', 'Sabro', '24000', '', '', '', 3),
(316, 'N-PSH-8027', 'North', 'LG', '24000', '', '', '', 3),
(317, 'N-PSH-8028', 'North', 'LG', '24000', '', '', '', 2),
(318, 'N-PSH-8029', 'North', 'Sabro', '24000', '', '', '', 2),
(319, 'N-PSH-8031', 'North', 'Pel', '24000', '', '', '', 2),
(320, 'N-JHL-8020', 'North', 'Jia', '24000', '', '', '', 2),
(321, 'N-JHL-8021', 'North', 'LG', '24000', '', '', '', 3),
(322, 'N-MDN-8072', 'North', 'LG', '24000', '', '', '', 2),
(323, 'N-SWT-8070', 'North', 'LG', '24000', '', '', '', 2),
(324, 'N-ISB-8035', 'North', 'Pel', '24000', '', '', '', 2),
(325, 'N-ISB-8039', 'North', 'Pel', '24000', '', '', '', 2),
(326, 'N-ISB-8078', 'North', 'Pel', '24000', '', '', '', 2),
(327, 'N-ISB-8079', 'North', 'LG', '24000', '', '', '', 1),
(328, 'N-ISB-8042', 'North', 'Pel', '24000', '', '', '', 2),
(329, 'N-ISB-8038', 'North', 'Pel', '24000', '', '', '', 2),
(330, 'N-ISB-8134', 'North', 'Waves', '18000', '', '', '', 2),
(331, 'N-ISB-8016', 'North', 'Pel', '24000', '', '', '', 2),
(332, 'N-MAL-8049', 'North', 'Mitsubishi', '24000', '', '', '', 2),
(333, 'N-PSH-8065', 'North', 'Waves', '18000', '', '', '', 2),
(334, 'N-JHA-8077', 'North', 'Waves', '18000', '', '', '', 2),
(335, 'N-ISB-8034', 'North', 'Waves', '18000', '', '', '', 2),
(336, 'N-ISB-8032', 'North', 'Pel', '24000', '', '', '', 2),
(337, 'N-PSH-8066', 'North', 'Fijia', '18000', '', '', '', 2),
(338, 'N-TAX-8055', 'North', 'Sabro', '24000', '', '', '', 2),
(339, 'N-MNG-8085', 'North', 'Sabro', '24000', '', '', '', 2),
(340, 'N-SRM-8061', 'North', 'Haier', '18000', '', '', '', 2),
(341, 'N-ISB-8041', 'North', 'Pel', '24000', '', '', '', 2),
(342, 'N-ISB-8040', 'North', 'Pel', '24000', '', '', '', 2),
(343, 'N-ISB-8082', 'North', 'LG', '18000', '', '', '', 2),
(344, 'N-ISB-8033', 'North', 'LG', '18000', '', '', '', 2),
(345, 'N-ISB-8036', 'North', 'Waves', '18000', '', '', '', 2),
(346, 'N-SWT-8080', 'North', 'LG', '24000', '', '', '', 2),
(347, 'N-PSH-8115', 'North', 'LG', '18000', '', '', '', 2),
(348, 'N-PSH-8114', 'North', 'LG', '18000', '', '', '', 2),
(349, 'N-ABD-8169', 'North', 'Waves', '18000', '', '', '', 1),
(350, 'N-ISB-8130', 'North', 'LG', '18000', '', '', '', 2),
(351, 'N-CHL-8220', 'North', 'Waves', '18500', '', '', '', 2),
(352, 'N-ISB-8131', 'North', 'LG', '18000', '', '', '', 2),
(353, 'N-ISB-8129', 'North', 'LG', '18000', '', '', '', 2),
(354, 'N-TAX-8090', 'North', 'Waves', '18000', '', '', '', 2),
(355, 'N-PSH-8116', 'North', 'LG', '18000', '', '', '', 2),
(356, 'N-PSH-8136', 'North', 'LG', '18000', '', '', '', 2),
(357, 'N-PSH-8137', 'North', 'LG', '18000', '', '', '', 2),
(358, 'N-PSH-8200', 'North', 'LG', '18000', '', '', '', 2),
(359, 'N-PUB-8212', 'North', 'Haier', '18000', '', '', '', 2),
(360, 'N-PSH-8206', 'North', 'LG', '18000', '', '', '', 2),
(361, 'N-PSH-8117', 'North', 'LG', '18000', '', '', '', 2),
(362, 'N-MDN-8111', 'North', 'Waves', '18000', '', '', '', 5),
(363, 'N-NOW-8180', 'North', 'Haier', '24000', '', '', '', 2),
(364, 'N-DNA-8210', 'North', 'Fijia', '24000', '', '', '', 2),
(365, 'N-AKT-8219', 'North', 'LG', '18000', '', '', '', 2),
(366, 'N-NOW-8069', 'North', 'Sabro', '18000', '', '', '', 2),
(367, 'N-JHL-8102', 'North', 'LG', '24000', '', '', '', 5),
(368, 'N-MDN-8112', 'North', 'Waves', '18000', '', '', '', 2),
(369, 'N-MSR-8097', 'North', 'Waves', '18000', '', '', '', 2),
(370, 'N-DNA-8088', 'North', 'LG', '18000', '', '', '', 2),
(371, 'N-PSH-8201', 'North', 'LG', '18000', '', '', '', 2),
(372, 'N-MDN-8113', 'North', 'Waves', '18000', '', '', '', 2),
(373, 'N-ISB-8123', 'North', 'LG', '18000', '', '', '', 2),
(374, 'N-CHL-8172', 'North', 'LG', '18000', '', '', '', 2),
(375, 'N-CHL-8100', 'North', 'LG', '24000', '', '', '', 2),
(376, 'N-CHL-8171', 'North', 'LG', '18500', '', '', '', 2),
(377, 'N-ISB-8165', 'North', 'Sabro', '24000', '', '', '', 2),
(378, 'N-PSH-8207', 'North', 'LG', '18000', '', '', '', 2),
(379, 'N-TAX-8174', 'North', 'LG', '18500', '', '', '', 2),
(380, 'N-TRM-8216', 'North', 'LG', '24000', '', '', '', 2),
(381, 'N-MDN-8237', 'North', 'LG', '18000', '', '', '', 2),
(382, 'N-MDN-8239', 'North', 'Haier', '18000', '', '', '', 2),
(383, 'N-SWT-8106', 'North', 'LG', '24000', '', '', '', 2),
(384, 'N-PSH-8676', 'North', 'LG', '24000', '', '', '', 2),
(385, 'N-MSR-8092', 'North', 'LG', '18500', '', '', '', 2),
(386, 'N-LOR-8153', 'North', 'Fijia', '18000', '', '', '', 2),
(387, 'N-TKB-8093', 'North', 'Haier', '18000', '', '', '', 2),
(388, 'N-HTY-8243', 'North', 'Waves', '18000', '', '', '', 2),
(389, 'N-PSH-8227', 'North', 'Haier', '18000', '', '', '', 2),
(390, 'N-ISB-8128', 'North', 'LG', '18000', '', '', '', 2),
(391, 'N-PSH-8241', 'North', 'Waves', '18000', '', '', '', 2),
(392, 'N-JLL-8230', 'North', 'Haier', '18000', '', '', '', 2),
(393, 'N-PSH-8245', 'North', 'Haier', '18000', '', '', '', 2),
(394, 'N-RMB-8221', 'North', 'LG', '24000', '', '', '', 2),
(395, 'N-ISB-8166', 'North', 'LG', '24000', '', '', '', 2),
(396, 'N-BKT-8145', 'North', 'LG', '18000', '', '', '', 2),
(397, 'N-PLI-8242', 'North', 'Waves', '18000', '', '', '', 2),
(398, 'N-ABD-8191', 'North', 'LG', '18000', '', '', '', 2),
(399, 'N-PSH-8233', 'North', 'Haier', '18000', '', '', '', 2),
(400, 'N-ISB-8141', 'North', 'LG', '24000', '', '', '', 2),
(401, 'N-ISB-8187', 'North', 'LG', '24000', '', '', '', 2),
(402, 'N-ISB-8193', 'North', 'LG', '18000', '', '', '', 2),
(403, 'N-SZG-8249', 'North', 'Sabro', '18000', '', '', '', 2),
(404, 'N-SEW-8289', 'North', 'Haier', '18000', '', '', '', 2),
(405, 'N-MSK-8238', 'North', 'LG', '18000', '', '', '', 2),
(406, 'N-SAK-8290', 'North', 'Haier', '18000', '', '', '', 2),
(407, 'N-BDT-8147', 'North', 'LG', '24000', '', '', '', 2),
(408, 'N-DGR-8229', 'North', 'LG', '24000', '', '', '', 2),
(409, 'N-SWT-8182', 'North', 'LG', '24000', '', '', '', 2),
(410, 'N-ISB-8276', 'North', 'LG', '18000', '', '', '', 2),
(411, 'N-ISB-8309', 'North', 'LG', '24000', '', '', '', 2),
(412, 'N-ISB-8189', 'North', 'Haier', '18000', '', '', '', 2),
(413, 'N-CHL-8057', 'North', 'Haier', '18000', '', '', '', 2),
(414, 'N-ISB-8125', 'North', 'LG', '24000', '', '', '', 2),
(415, 'N-ISB-8306', 'North', 'LG', '24000', '', '', '', 2),
(416, 'N-ISB-8126', 'North', 'Sabro', '24000', '', '', '', 2),
(417, 'N-ISB-8127', 'North', 'Haier', '18000', '', '', '', 2),
(418, 'N-ISB-8133', 'North', 'LG', '24000', '', '', '', 2),
(419, 'N-PSH-8345', 'North', 'LG', '24000', '', '', '', 2),
(420, 'N-PIR-8244', 'North', 'LG', '24000', '', '', '', 2),
(421, 'N-ISB-8132', 'North', 'LG', '24000', '', '', '', 2),
(422, 'N-ISB-8277', 'North', 'Sabro', '12000', '', '', '', 2),
(423, 'N-JHL-8155', 'North', 'Sabro', '12000', '', '', '', 2),
(424, 'N-SWT-8226', 'North', 'LG', '24000', '', '', '', 2),
(425, 'N-ISB-8162', 'North', 'LG', '24000', '', '', '', 2),
(426, 'N-ABD-8340', 'North', 'LG', '24000', '', '', '', 2),
(427, 'N-NGM-8240', 'North', 'LG', '24000', '', '', '', 2),
(428, 'N-ISB-8264', 'North', 'LG', '24000', '', '', '', 2),
(429, 'N-KLM-8223', 'North', 'LG', '24000', '', '', '', 2),
(430, 'N-BRN-8224', 'North', 'LG', '24000', '', '', '', 2),
(431, 'N-ISB-8299', 'North', 'LG', '24000', '', '', '', 2),
(432, 'N-MLR-8236', 'North', 'LG', '24000', '', '', '', 2),
(433, 'N-JHL-8344', 'North', 'LG', '24000', '', '', '', 2),
(434, 'N-KWK-8232', 'North', 'LG', '24000', '', '', '', 2),
(435, 'N-PSH-8349', 'North', 'LG', '18000', '', '', '', 2),
(436, 'N-ISB-8270', 'North', 'LG', '24000', '', '', '', 2),
(437, 'N-ISB-9007', 'North', 'LG', '12000', '', '', '', 2),
(438, 'N-JHL-8152', 'North', 'LG', '18000', '', '', '', 2),
(439, 'N-CSS-8149', 'North', 'Haier', '18000', '', '', '', 2),
(440, 'N-PSH-8350', 'North', 'LG', '18000', '', '', '', 2),
(441, 'N-ISB-8300', 'North', 'LG', '24000', '', '', '', 2),
(442, 'N-ISB-8784', 'North', 'LG', '24000', '', '', '', 2),
(443, 'N-ISB-8321', 'North', 'LG', '24000', '', '', '', 2),
(444, 'N-MDN-8409', 'North', 'LG', '18000', '', '', '', 2),
(445, 'N-MIG-8420', 'North', 'LG', '24000', '', '', '', 2),
(446, 'N-ISB-8332', 'North', 'LG', '24000', '', '', '', 2),
(447, 'N-ISB-8814', 'North', 'LG', '24000', '', '', '', 2),
(448, 'N-MDN-8407', 'North', 'LG', '18000', '', '', '', 2),
(449, 'N-JRJ-8491', 'North', 'LG', '24000', '', '', '', 2),
(450, 'N-CHL-8910', 'North', 'LG', '24000', '', '', '', 2),
(451, 'N-JHL-8563', 'North', 'Sabro', '24000', '', '', '', 2),
(452, 'N-RHK-8669', 'North', 'LG', '24000', '', '', '', 2),
(453, 'N-JHL-8565', 'North', 'LG', '24000', '', '', '', 2),
(454, 'N-ISB-8773', 'North', 'LG', '24000', '', '', '', 2),
(455, 'N-PSH-8992', 'North', 'LG', '24000', '', '', '', 2),
(456, 'N-ISB-8821', 'North', 'LG', '24000', '', '', '', 2),
(457, 'N-ISB-8776', 'North', 'LG', '24000', '', '', '', 2),
(458, 'N-THN-8450', 'North', 'LG', '24000', '', '', '', 2),
(459, 'N-PSH-8594', 'North', 'LG', '24000', '', '', '', 2),
(460, 'N-ISB-8558', 'North', 'LG', '24000', '', '', '', 2),
(461, 'N-ISB-8167', 'North', 'LG', '24000', '', '', '', 2),
(462, 'N-PSH-8676', 'North', 'LG', '24000', '', '', '', 2),
(463, 'N-OGB-8159', 'North', 'LG', '24000', '', '', '', 2),
(464, 'N-ISB-8806', 'North', 'LG', '24000', '', '', '', 2),
(465, 'N-PSH-8574', 'North', 'LG', '24000', '', '', '', 2),
(466, 'N-ISB-8866', 'North', 'LG', '24000', '', '', '', 2),
(467, 'N-WAH-8615', 'North', 'Sabro', '24000', '', '', '', 2),
(468, 'N-TAX-8605', 'North', 'LG', '24000', '', '', '', 2),
(469, 'N-ISB-9069', 'North', 'Acson', '24000', '', '', '', 2),
(470, 'N-PSH-8978', 'North', 'LG', '24000', '', '', '', 2),
(471, 'N-SKJ-8720', 'North', 'LG', '24000', '', '', '', 2),
(472, 'N-SSZ-8995', 'North', 'LG', '24000', '', '', '', 2),
(473, 'N-PSH-8582', 'North', 'LG', '24000', '', '', '', 2),
(474, 'N-PSH-8588', 'North', 'LG', '24000', '', '', '', 2),
(475, 'N-ISB-8799', 'North', 'LG', '24000', '', '', '', 2),
(476, 'N-BNG-9024', 'North', 'LG', '24000', '', '', '', 2),
(477, 'N-ISB-9312', 'North', 'LG', '24000', '', '', '', 2),
(478, 'N-ISB-8861', 'North', 'LG', '24000', '', '', '', 2),
(479, 'N-IPY-9310', 'North', 'LG', '24000', '', '', '', 2),
(480, 'N-ISB-8873', 'North', 'LG', '24000', '', '', '', 2),
(481, 'N-ISB-8757', 'North', 'LG', '24000', '', '', '', 2),
(482, 'N-ISB-8777', 'North', 'LG', '24000', '', '', '', 2),
(483, 'N-ISB-8792', 'North', 'LG', '24000', '', '', '', 2),
(484, 'N-MLP-9228', 'North', 'LG', '24000', '', '', '', 2),
(485, 'N-ISB-9313', 'North', 'LG', '24000', '', '', '', 2),
(486, 'N-ABD-8536', 'North', 'LG', '24000', '', '', '', 2),
(487, 'N-HTR-8828', 'North', 'LG', '24000', '', '', '', 2),
(488, 'N-ISB-8795', 'North', 'LG', '24000', '', '', '', 2),
(489, 'N-ABD-8752', 'North', 'LG', '24000', '', '', '', 2),
(490, 'N-ABD-8748', 'North', 'LG', '24000', '', '', '', 2),
(491, 'N-RUR-9407', 'North', 'LG', '24000', '', '', '', 2),
(492, 'N-RUR-9414', 'North', 'LG', '24000', '', '', '', 2),
(493, 'N-ISB-8829', 'North', 'LG', '24000', '', '', '', 2),
(494, 'N-ISB-8789', 'North', 'LG', '24000', '', '', '', 2),
(495, 'N-HWY-9415', 'North', 'LG', '24000', '', '', '', 2),
(496, 'N-ISB-9178', 'North', 'Haier', '24000', '', '', '', 2),
(497, 'N-ISB-8790', 'North', 'LG', '24000', '', '', '', 2),
(498, 'N-MHW-8986', 'North', 'LG', '24000', '', '', '', 2),
(499, 'S-MAH-1495', 'South', '', '', '0', '0', '0', 1),
(500, 'S-MAH-1495', 'South', '', '', '0', '0', '0', 1),
(501, 'S-HYD-0183', 'South', '', '', '0', '0', '0', 1),
(502, 'S-HYD-0396', 'South', '', '', '0', '0', '0', 1),
(503, 'S-HYD-0396', 'South', '', '', '0', '0', '0', 1),
(504, 'S-MPM-0140', 'South', 'Haier', '18000', 'ACH830002010', '8892541', '9.1', 1),
(505, 'S-MPM-0140', 'South', 'Haier', '18000', 'ACH830002010', '8892541', '9.1', 1),
(506, 'S-LHN-1489', 'South', 'LG', '24000', '705NA245419', '224589', '11.4', 1),
(507, 'S-LHN-1489', 'South', 'LG', '24000', '705NA245419', '224589', '11.4', 1),
(508, 'S-HYD-0181', 'South', 'LG', '24000', 'CM23050C', 'CM0181780', '11.6', 1),
(509, 'S-HYD-0181', 'South', 'LG', '24000', 'CM23050C', 'CM0181780', '11.6', 1),
(510, 'S-HYD-0395', 'South', 'LG', '24000', 'NIL', 'NA123251', '11.4', 1),
(511, 'S-HYD-0395', 'South', 'LG', '24000', 'NIL', 'NA123251', '11.4', 1),
(512, 'S-HYD-0189', 'South', 'Haier', '18000', 'AD84A0348', 'NIL', '9.1', 1),
(513, 'S-HYD-0189', 'South', 'Haier', '18000', 'AD84A0348', 'NIL', '9.1', 1),
(514, 'S-HYD-0190', 'South', 'Haier', '18000', 'ACH8300215', 'NIL', '8.9', 1),
(515, 'S-HYD-0190', 'South', 'Haier', '18000', 'ACH8300215', 'NIL', '8.9', 1),
(516, 'S-JEK-1014', 'South', 'LG', '24000', '706NA65980', '589214', '11.6', 1),
(517, 'S-JEK-1014', 'South', 'LG', '24000', '706NA65980', '589214', '11.6', 1),
(518, 'S-NOR-0348', 'South', 'Waves', '12000', 'NIL', 'NL', '5.3', 1),
(519, 'S-NOR-0348', 'South', 'Waves', '12000', 'NIL', 'NL', '5.3', 1),
(520, 'S-TAT-1574', 'South', 'LG', '24000', '507NA2594', 'NIL', '11.5', 1),
(521, 'S-TAT-1574', 'South', 'LG', '24000', '507NA2594', 'NIL', '11.5', 1),
(522, 'S-SNG-1087', 'South', 'LG', '24000', 'NIL', 'NA8954317', '11.5', 1),
(523, 'S-SNG-1087', 'South', 'LG', '24000', 'NIL', 'NA8954317', '11.5', 1),
(524, 'S-JOL-1301', 'South', 'LG', '24000', 'CM6589157', 'NIL', '11.4', 1),
(525, 'S-JOL-1301', 'South', 'LG', '24000', 'CM6589157', 'NIL', '11.4', 1),
(526, 'S-HYD-0394', 'South', 'LG', '24000', 'NIL', 'NA122284', '11.4', 1),
(527, 'S-HYD-0394', 'South', 'LG', '24000', 'NIL', 'NA122284', '11.4', 1),
(528, 'S-NSH-1137', 'South', 'LG', '24000', 'NA607226581', 'NIL', '11.4', 1),
(529, 'S-NSH-1137', 'South', 'LG', '24000', 'NA607226581', 'NIL', '11.4', 1),
(530, 'S-KLR-1418', 'South', 'LG', '24000', 'NA36220', '2254136', '11.4', 1),
(531, 'S-KLR-1418', 'South', 'LG', '24000', 'NA36220', '2254136', '11.4', 1),
(532, 'S-SRD-0337', 'South', 'Haier', '18000', 'AC83H3695', 'NIL', '9.1', 1),
(533, 'S-SRD-0337', 'South', 'Haier', '18000', 'AC83H3695', 'NIL', '9.1', 1),
(534, 'S-KHI-0411', 'South', '', '', '', '', '', 1),
(535, 'S-KHI-0411', 'South', '', '', '', '', '', 1),
(536, 'S-KHI-0409', 'South', '', '', '', '', '', 1),
(537, 'S-KHI-0409', 'South', '', '', '', '', '', 1),
(538, 'S-KHI-0946', 'South', '', '', '', '', '', 1),
(539, 'S-KHI-0946', 'South', '', '', '', '', '', 1),
(540, 'S-KHI-0039', 'South', '', '', '', '', '', 1),
(541, 'S-KHI-0039', 'South', '', '', '', '', '', 1),
(542, 'S-KHI-0272', 'South', '', '', '', '', '', 1),
(543, 'S-KHI-0272', 'South', '', '', '', '', '', 1),
(544, 'S-SUK-0329', 'South', '', '', '', '', '', 1),
(545, 'S-SUK-0329', 'South', '', '', '', '', '', 1),
(546, 'S-KHI-0046', 'South', '', '', '', '', '', 1),
(547, 'S-KHI-0046', 'South', '', '', '', '', '', 1),
(548, 'S-KHI-1443', 'South', '', '', '', '', '', 1),
(549, 'S-KHI-1443', 'South', '', '', '', '', '', 1),
(550, 'S-KHI-2101', 'South', '', '', '', '', '', 1),
(551, 'S-KHI-2101', 'South', '', '', '', '', '', 1),
(552, 'S-KHI-0022', 'South', '', '', '', '', '', 1),
(553, 'S-KHI-0022', 'South', '', '', '', '', '', 1),
(554, 'S-KHI-0296', 'South', '', '', '', '', '', 1),
(555, 'S-KHI-0296', 'South', '', '', '', '', '', 1),
(556, 'S-KHI-0766', 'South', '', '', '', '', '', 1),
(557, 'S-KHI-0766', 'South', '', '', '', '', '', 1),
(558, 'S-KHI-0085', 'South', '', '', '', '', '', 1),
(559, 'S-KHI-0085', 'South', '', '', '', '', '', 1),
(560, 'S-KHI-0042', 'South', '', '', '', '', '', 1),
(561, 'S-KHI-0302', 'South', '', '', '', '', '', 1),
(562, 'S-KHI-0302', 'South', '', '', '', '', '', 1),
(563, 'S-KHI-0080', 'South', 'LG', '24000', '502KAJP0008', '502KADP022', '11.6', 1),
(564, 'S-KHI-0080', 'South', 'LG', '24000', '502KAJP0008', '502KADP022', '11.6', 1),
(565, 'S-KHI-0327', 'South', 'LG', '24000', '410KATM00497', 'NA65775', '7.1', 1),
(566, 'S-KHI-0327', 'South', 'LG', '24000', '410KATM00497', 'NA65775', '7.1', 1),
(567, 'S-KHI-0030', 'South', 'Haier', '18000', 'AC83H2543', '4200', '10.9', 1),
(568, 'S-KHI-0087', 'South', 'Haier', '18000', 'AZOUN050300AC83', 'NIL', '8.9', 1),
(569, 'S-KHI-0053', 'South', 'General', '24000', 'T112748', 'WTI24306', '13', 1),
(570, 'S-KHI-0053', 'South', 'General', '24000', 'T112748', 'WTI24306', '13', 1),
(571, 'S-KHI-1449', 'South', 'LG', '24000', 'NA0341166', 'NIL', '13.3', 1),
(572, 'S-KHI-1432', 'South', 'LG', '24000', 'NA034186', 'NIL', '12.9', 1),
(573, 'S-KHI-1432', 'South', 'LG', '24000', 'NA034186', 'NIL', '12.9', 1),
(574, 'S-KHI-0032', 'South', 'General', '24000', '2042809', 'TO42408', '13', 1),
(575, 'S-KHI-0032', 'South', 'General', '24000', '2042809', 'TO42408', '13', 1),
(576, 'S-KHI-0426', 'South', 'LG', '24000', 'NA00935', 'NIL', '12.9', 1),
(577, 'S-KHI-0426', 'South', 'LG', '24000', 'NA00935', 'NIL', '12.9', 1),
(578, 'S-KHI-1428', 'South', 'LG', '18000', '706NA85880', 'NIL', '8.3', 1),
(579, 'S-KHI-1428', 'South', 'LG', '18000', '706NA85880', 'NIL', '8.3', 1),
(580, 'S-KHI-0082', 'South', 'General', '24000', 'ASG240ABC-W', 'TO42342', '12.9', 1),
(581, 'S-KHI-0082', 'South', 'LG', '18000', '502KLSC01952', 'NIL', '12.9', 1),
(582, 'S-KHI-0783', 'South', 'LG', '24000', '806NA101918', 'NA102364', '12', 1),
(583, 'S-KHI-0783', 'South', 'LG', '24000', '806NA101918', 'NA102364', '12', 1),
(584, 'S-KHI-0376', 'South', 'LG', '24000', '12123', 'NA121344', '12.4', 1),
(585, 'S-KHI-0376', 'South', 'LG', '24000', '12123', 'NA121344', '12.4', 1),
(586, 'S-KHI-0775', 'South', 'LG', '24000', 'NA121191', 'NA121907', '12', 1),
(587, 'S-KHI-0775', 'South', 'LG', '24000', 'NA121191', 'NA121907', '12', 1),
(588, 'S-KHI-0067', 'South', 'Haier', '18000', 'AC83H3544', 'NIL', '7.4', 1),
(589, 'S-KHI-0067', 'South', 'Haier', '18000', 'AC83H3544', 'NIL', '7.4', 1),
(590, 'S-KHI-0231', 'South', 'LG', '24000', 'AEJ01916', 'NA141893', '13.1', 1),
(591, 'S-KHI-0231', 'South', 'LG', '24000', 'AEJ01916', 'NA141893', '13.1', 1),
(592, 'C-FSB-4245', 'Central-2', 'LG', '18000', '', '', '', 2),
(593, 'C-FSB-4249', 'Central-2', 'LG', '18000', '', '', '', 2),
(594, 'C-FSB-4990', 'Central-2', 'LG', '24000', '', '', '', 2),
(595, 'C-FSB-5001', 'Central-2', 'LG', '24000', '', '', '', 2),
(596, 'C-FSB-4257', 'Central-2', 'LG', '18000', '', '', '', 2),
(597, 'C-FSB-4695', 'Central-2', 'LG', '18000', '', '', '', 2),
(598, 'C-FSB-5401', 'Central-2', 'LG', '24000', '', '', '', 2),
(599, 'C-FSB-5405', 'Central-2', 'LG', '24000', '', '', '', 2),
(600, 'C-FSB-4247', 'Central-2', 'LG', '18000', '', '', '', 2),
(601, 'C-FSB-4705', 'Central-2', 'LG', '18000', '', '', '', 2),
(602, 'C-FSB-4703', 'Central-2', 'LG', '24000', '', '', '', 1),
(603, 'C-FSB-4706', 'Central-2', 'LG', '24000', '', '', '', 2),
(604, 'C-FSB-5381', 'Central-2', 'LG', '24000', '', '', '', 2),
(605, 'C-FSB-5394', 'Central-2', 'LG', '24000', '', '', '', 2),
(606, 'C-SRG-4116', 'Central-2', 'General', '24000', '', '', '', 2),
(607, 'C-SRG-4228', 'Central-2', 'Acson', '18000', '', '', '', 1),
(608, 'C-SRG-4782', 'Central-2', 'LG', '24000', '', '', '', 2),
(609, 'C-FSB-4254', 'Central-2', 'LG', '18000', '', '', '', 2),
(610, 'C-FSB-4701', 'Central-2', 'LG', '24000', '', '', '', 2),
(611, 'C-FSB-4998', 'Central-2', 'LG', '24000', '', '', '', 2),
(612, 'C-FSB-5421', 'Central-2', 'LG', '24000', '', '', '', 2),
(613, 'C-BHL-4180', 'Central-2', 'LG', '18000', '', '', '', 2),
(614, 'C-BLW-4439', 'Central-2', 'LG', '18000', '', '', '', 2),
(615, 'C-LHM-4570', 'Central-2', 'LG', '24000', '', '', '', 2),
(616, 'C-FSB-4250', 'Central-2', 'LG', '18000', '', '', '', 2),
(617, 'C-FSB-4700', 'Central-2', 'LG', '18000', '', '', '', 2),
(618, 'C-FSB-4709', 'Central-2', 'LG', '24000', '', '', '', 2),
(619, 'C-ADD-4485', 'Central-2', 'LG', '24000', '', '', '', 2),
(620, 'C-PUL-4571', 'Central-2', 'LG', '18000', '', '', '', 2),
(621, 'C-FSB-4704', 'Central-2', 'LG', '24000', '', '', '', 1),
(622, 'C-SRG-4226', 'Central-2', 'Mitsubishi', '18000', '', '', '', 1),
(623, 'C-SRG-4227', 'Central-2', 'LG', '18000', '', '', '', 2),
(624, 'C-SRG-4229', 'Central-2', 'Waves', '18000', '', '', '', 2),
(625, 'C-SRG-4367', 'Central-2', 'LG', '18000', '', '', '', 2),
(626, 'C-SCS-4469', 'Central-2', 'Waves', '18000', '', '', '', 2),
(627, 'C-SRG-6050', 'Central-2', 'LG', '24000', '', '', '', 2),
(628, 'C-FSB-4702', 'Central-2', 'LG', '18000', '', '', '', 2),
(629, 'C-FSB-4712', 'Central-2', 'LG', '18000', '', '', '', 2),
(630, 'C-FSB-4986', 'Central-2', 'LG', '24000', '', '', '', 2),
(631, 'C-SRG-4285', 'Central-2', 'Waves', '18000', '', '', '', 2),
(632, 'C-SRG-4781', 'Central-2', 'LG', '24000', '', '', '', 2),
(633, 'C-FSB-4051', 'Central-2', 'Mitsubishi', '24000', '', '', '', 2),
(634, 'C-FSB-4246', 'Central-2', 'LG', '18000', '', '', '', 1),
(635, 'C-FSB-4699', 'Central-2', 'LG', '24000', '', '', '', 2),
(636, 'C-FSB-4999', 'Central-2', 'LG', '24000', '', '', '', 2),
(637, 'C-FSB-5403', 'Central-2', 'LG', '24000', '', '', '', 2),
(638, 'C-FSB-5414', 'Central-2', 'LG', '24000', '', '', '', 2),
(639, 'C-FSB-4109', 'Central-2', 'LG', '24000', '', '', '', 2),
(640, 'C-FSB-4255', 'Central-2', 'LG', '18000', '', '', '', 2),
(641, 'C-FSB-6091', 'Central-2', 'LG', '24000', '', '', '', 2),
(642, 'C-FSB-6215', 'Central-2', 'LG', '24000', '', '', '', 2),
(643, 'C-FSB-6336', 'Central-2', 'LG', '24000', '', '', '', 2),
(644, 'C-FSB-4050', 'Central-2', 'LG', '24000', '', '', '', 2),
(645, 'C-FSB-4256', 'Central-2', 'Pel', '18000', '', '', '', 2),
(646, 'C-FSB-4696', 'Central-2', 'LG', '24000', '', '', '', 2),
(647, 'C-FSB-4981', 'Central-2', 'LG', '24000', '', '', '', 2),
(648, 'C-FSB-4984', 'Central-2', 'LG', '24000', '', '', '', 2),
(649, 'C-FSB-5378', 'Central-2', 'LG', '24000', '', '', '', 2),
(650, 'C-FSB-5383', 'Central-2', 'LG', '24000', '', '', '', 2),
(651, 'C-FSB-5384', 'Central-2', 'LG', '24000', '', '', '', 2),
(652, 'C-FSB-5391', 'Central-2', 'LG', '24000', '', '', '', 2),
(653, 'C-FSB-6062', 'Central-2', 'LG', '24000', '', '', '', 2),
(654, 'C-FSB-6063', 'Central-2', 'LG', '24000', '', '', '', 2),
(655, 'C-FSB-6202', 'Central-2', 'LG', '24000', '', '', '', 2),
(656, 'C-FSB-4053', 'Central-2', 'Sabro', '12000', '', '', '', 1),
(657, 'C-FSB-4707', 'Central-2', 'LG', '18000', '', '', '', 2),
(658, 'C-FSB-4708', 'Central-2', 'LG', '24000', '', '', '', 2),
(659, 'C-FSB-4711', 'Central-2', 'LG', '24000', '', '', '', 2),
(660, 'C-FSB-4995', 'Central-2', 'LG', '24000', '', '', '', 2),
(661, 'C-FSB-5387', 'Central-2', 'LG', '24000', '', '', '', 2),
(662, 'C-FSB-5388', 'Central-2', 'LG', '24000', '', '', '', 2),
(663, 'C-FSB-5389', 'Central-2', 'LG', '24000', '', '', '', 2),
(664, 'C-FSB-5393', 'Central-2', 'LG', '24000', '', '', '', 2),
(665, 'C-FSB-5404', 'Central-2', 'LG', '24000', '', '', '', 2),
(666, 'C-FSB-5407', 'Central-2', 'LG', '24000', '', '', '', 2),
(667, 'C-FSB-5417', 'Central-2', 'LG', '24000', '', '', '', 2),
(668, 'C-FSB-6061', 'Central-2', 'LG', '24000', '', '', '', 2),
(669, 'C-FSB-6346', 'Central-2', 'LG', '24000', '', '', '', 2),
(670, 'C-FSB-4049', 'Central-2', 'LG', '18000', '', '', '', 1),
(671, 'C-FSB-4052', 'Central-2', 'LG', '24000', '', '', '', 1),
(672, 'C-FSB-4693', 'Central-2', 'LG', '18000', '', '', '', 2),
(673, 'C-FSB-4697', 'Central-2', 'LG', '24000', '', '', '', 2),
(674, 'C-FSB-4710', 'Central-2', 'LG', '24000', '', '', '', 2),
(675, 'C-FSB-4970', 'Central-2', 'LG', '24000', '', '', '', 2),
(676, 'C-FSB-5370', 'Central-2', 'LG', '24000', '', '', '', 2),
(677, 'C-FSB-5373', 'Central-2', 'LG', '24000', '', '', '', 2),
(678, 'C-FSB-5420', 'Central-2', 'LG', '24000', '', '', '', 2),
(679, 'C-FSB-6337', 'Central-2', 'LG', '24000', '', '', '', 2),
(680, 'C-FSB-6342', 'Central-2', 'LG', '24000', '', '', '', 2),
(681, 'C-FSB-6347', 'Central-2', 'LG', '24000', '', '', '', 2),
(682, 'C-FSB-6350', 'Central-2', 'LG', '24000', '', '', '', 2),
(683, 'C-FSB-4997', 'Central-2', 'LG', '24000', '', '', '', 2),
(684, 'C-FSB-5376', 'Central-2', 'LG', '24000', '', '', '', 2),
(685, 'C-FSB-5396', 'Central-2', 'LG', '24000', '', '', '', 2),
(686, 'C-FSB-5397', 'Central-2', 'LG', '24000', '', '', '', 2),
(687, 'C-FSB-6115', 'Central-2', 'LG', '24000', '', '', '', 2),
(688, 'C-FSB-6217', 'Central-2', 'LG', '24000', '', '', '', 2),
(689, 'C-FSB-6322', 'Central-2', 'LG', '24000', '', '', '', 2),
(690, 'C-FSB-6338', 'Central-2', 'LG', '24000', '', '', '', 2),
(691, 'C-FSB-6340', 'Central-2', 'LG', '24000', '', '', '', 2),
(692, 'C-FSB-6343', 'Central-2', 'LG', '24000', '', '', '', 2),
(693, 'C-FSB-6344', 'Central-2', 'LG', '24000', '', '', '', 2),
(694, 'C-FSB-4971', 'Central-2', 'LG', '24000', '', '', '', 2),
(695, 'C-FSB-5382', 'Central-2', 'LG', '24000', '', '', '', 2),
(696, 'C-FSB-4047', 'Central-2', 'General', '24000', '', '', '', 1),
(697, 'C-FSB-6177', 'Central-2', 'LG', '24000', '', '', '', 2),
(698, 'C-FSB-5182', 'Central-2', 'LG', '24000', '', '', '', 2),
(699, 'C-FSB-6064', 'Central-2', 'LG', '24000', '', '', '', 2),
(700, 'C-FSB-5380', 'Central-2', 'LG', '24000', '', '', '', 2),
(701, 'C-FSB-4048', 'Central-2', 'Mitsubishi', '24000', '', '', '', 8),
(702, 'C-JHG-4112', 'Central-2', 'Mitsubishi', '24000', '', '', '', 1),
(703, 'C-JHG-4222', 'Central-2', 'LG', '18000', '', '', '', 2),
(704, 'C-JHG-4390', 'Central-2', 'LG', '18000', '', '', '', 1),
(705, 'C-JHG-4820', 'Central-2', 'LG', '24000', '', '', '', 2),
(706, 'C-JHG-5368', 'Central-2', 'LG', '24000', '', '', '', 2),
(707, 'C-JHG-4113', 'Central-2', 'LG', '24000', '', '', '', 2),
(708, 'C-JHG-4193', 'Central-2', 'LG', '18000', '', '', '', 2),
(709, 'C-JHG-4391', 'Central-2', 'Sabro', '18000', '', '', '', 2),
(710, 'C-JHG-6870', 'Central-2', 'LG', '24000', '', '', '', 2),
(711, 'C-MLT-4056', 'Central-3', 'LG', '24000', '', '', '', 3),
(712, 'C-MLT-4094', 'Central-3', 'LG', '18000', '', '', '', 1),
(713, 'C-MLT-4279', 'Central-3', 'LG', '24000', '', '', '', 2),
(714, 'C-MLT-5303', 'Central-3', 'LG', '24000', '', '', '', 2),
(715, 'C-BRW-4207', 'Central-1', 'Waves', '18000', '', '', '', 2),
(716, 'C-GAM-4234', 'Central-1', 'LG', '18000', '', '', '', 2),
(717, 'C-BRW-4478', 'Central-1', 'Mitsubishi', '24000', '', '', '', 2),
(718, 'C-SKF-4576', 'Central-1', 'Sabro', '18000', '', '', '', 2),
(719, 'C-KWN-5848', 'Central-1', 'LG', '24000', '', '', '', 2),
(720, 'C-DGK-4208', 'Central-3', 'Waves', '18000', '', '', '', 2),
(721, 'C-MLT-4280', 'Central-3', 'LG', '24000', '', '', '', 1),
(722, 'C-MLT-4471', 'Central-3', 'LG', '24000', '', '', '', 2),
(723, 'C-MLT-4979', 'Central-3', 'LG', '24000', '', '', '', 2),
(724, 'C-MLT-5281', 'Central-3', 'LG', '24000', '', '', '', 2),
(725, 'C-MLT-5284', 'Central-3', 'LG', '24000', '', '', '', 2),
(726, 'C-MLT-5286', 'Central-3', 'LG', '24000', '', '', '', 2),
(727, 'C-MLT-5310', 'Central-3', 'LG', '24000', '', '', '', 2),
(728, 'C-MIA-5852', 'Central-1', 'LG', '24000', '', '', '', 2),
(729, 'C-SWL-6545', 'Central-1', 'LG', '24000', '', '', '', 2),
(730, 'C-MLS-4189', 'Central-3', 'Sabro', '24000', '', '', '', 1),
(731, 'C-DGK-4104', 'Central-3', 'LG', '18000', '', '', '', 1),
(732, 'C-KCT-4379', 'Central-3', 'Sabro', '18000', '', '', '', 2),
(733, 'C-MLT-4740', 'Central-3', 'LG', '18000', '', '', '', 2),
(734, 'C-MLT-5287', 'Central-3', 'LG', '24000', '', '', '', 2),
(735, 'C-MLT-5290', 'Central-3', 'LG', '24000', '', '', '', 2),
(736, 'C-MLT-5316', 'Central-3', 'LG', '24000', '', '', '', 2),
(737, 'C-MLT-5322', 'Central-3', 'LG', '24000', '', '', '', 2),
(738, 'C-MLT-5323', 'Central-3', 'LG', '24000', '', '', '', 2),
(739, 'C-MLT-5324', 'Central-3', 'LG', '24000', '', '', '', 2),
(740, 'C-VHR-4100', 'Central-3', 'LG', '24000', '', '', '', 1),
(741, 'C-VHR-4214', 'Central-3', 'Waves', '18000', '', '', '', 1);
INSERT INTO `sims_ac` (`SrNo`, `SiteID`, `region`, `AcMake`, `AcCapacity`, `IndoorNo`, `OutDoorNo`, `AMP`, `qty`) VALUES
(742, 'C-66', 'Central-3', 'LG', '18000', '', '', '', 1),
(743, 'C-BLP-4230', 'Central-3', 'Sabro', '12000', '', '', '', 1),
(744, 'C-BLP-5255', 'Central-3', 'LG', '24000', '', '', '', 2),
(745, 'C-BLP-5256', 'Central-3', 'LG', '24000', '', '', '', 2),
(746, 'C-BLP-6184', 'Central-3', 'LG', '24000', '', '', '', 2),
(747, 'C-BLP-6328', 'Central-3', 'LG', '24000', '', '', '', 2),
(748, 'C-MLT-4281', 'Central-3', 'Waves', '18000', '', '', '', 2),
(749, 'C-MLT-4327', 'Central-3', 'LG', '24000', '', '', '', 2),
(750, 'C-MLT-4736', 'Central-3', 'LG', '24000', '', '', '', 2),
(751, 'C-MLT-5270', 'Central-3', 'LG', '24000', '', '', '', 2),
(752, 'C-MLT-5294', 'Central-3', 'LG', '24000', '', '', '', 2),
(753, 'C-MLT-5320', 'Central-3', 'LG', '24000', '', '', '', 2),
(754, 'C-MLT-5325', 'Central-3', 'LG', '24000', '', '', '', 2),
(755, 'C-MLT-5328', 'Central-3', 'LG', '24000', '', '', '', 2),
(756, 'C-MLT-5328', 'Central-3', 'LG', '24000', '', '', '', 2),
(757, 'C-BLP-4102', 'Central-3', 'Mitsubishi', '18000', '', '', '', 1),
(758, 'C-BLP-6087', 'Central-3', 'LG', '24000', '', '', '', 2),
(759, 'C-BLP-6302', 'Central-3', 'LG', '24000', '', '', '', 2),
(760, 'C-MLT-4276', 'Central-3', 'Waves', '18000', '', '', '', 2),
(761, 'C-MLT-5274', 'Central-3', 'LG', '24000', '', '', '', 2),
(762, 'C-MLT-5275', 'Central-3', 'LG', '24000', '', '', '', 2),
(763, 'C-MLT-5278', 'Central-3', 'LG', '24000', '', '', '', 2),
(764, 'C-MLT-5283', 'Central-3', 'LG', '24000', '', '', '', 2),
(765, 'C-MLT-5329', 'Central-3', 'LG', '24000', '', '', '', 2),
(766, 'C-MLT-5338', 'Central-3', 'LG', '24000', '', '', '', 2),
(767, 'C-BLP-4101', 'Central-3', 'Sabro', '24000', '', '', '', 1),
(768, 'C-BLP-4231', 'Central-3', 'LG', '18000', '', '', '', 2),
(769, 'C-BLP-4232', 'Central-3', 'LG', '24000', '', '', '', 1),
(770, 'C-BLP-4793', 'Central-3', 'LG', '24000', '', '', '', 2),
(771, 'C-BLP-5249', 'Central-3', 'LG', '24000', '', '', '', 2),
(772, 'C-MLT-4059', 'Central-3', 'LG', '24000', '', '', '', 2),
(773, 'C-MLT-4277', 'Central-3', 'Waves', '18000', '', '', '', 2),
(774, 'C-MLT-4278', 'Central-3', 'LG', '24000', '', '', '', 1),
(775, 'C-MLT-4283', 'Central-3', 'Waves', '18000', '', '', '', 2),
(776, 'C-MLT-4472', 'Central-3', 'LG', '18000', '', '', '', 2),
(777, 'C-MLT-4978', 'Central-3', 'LG', '24000', '', '', '', 2),
(778, 'C-MLT-5288', 'Central-3', 'LG', '24000', '', '', '', 2),
(779, 'C-MLT-5308', 'Central-3', 'LG', '24000', '', '', '', 2),
(780, 'C-MLT-5319', 'Central-3', 'LG', '24000', '', '', '', 2),
(781, 'C-MLT-5332', 'Central-3', 'LG', '24000', '', '', '', 2),
(782, 'C-MLT-5337', 'Central-3', 'LG', '24000', '', '', '', 2),
(783, 'C-MLT-4055', 'Central-3', 'LG', '24000', '', '', '', 2),
(784, 'C-MLT-4282', 'Central-3', 'Waves', '18000', '', '', '', 2),
(785, 'C-MLT-4284', 'Central-3', 'Waves', '24000', '', '', '', 2),
(786, 'C-MLT-5291', 'Central-3', 'LG', '24000', '', '', '', 2),
(787, 'C-MLT-5306', 'Central-3', 'LG', '24000', '', '', '', 2),
(788, 'C-MLT-5317', 'Central-3', 'LG', '24000', '', '', '', 2),
(789, 'C-RYK-4212', 'Central-3', 'LG', '18000', '', '', '', 3),
(790, 'C-SQD-4237', 'Central-3', 'LG', '18000', '', '', '', 2),
(791, 'C-ADS-4388', 'Central-3', 'LG', '18000', '', '', '', 2),
(792, 'C-DGK-4475', 'Central-3', 'LG', '18000', '', '', '', 1),
(793, 'C-MLT-5273', 'Central-3', 'LG', '24000', '', '', '', 2),
(794, 'C-MLT-5277', 'Central-3', 'LG', '24000', '', '', '', 2),
(795, 'C-MLT-5295', 'Central-3', 'LG', '24000', '', '', '', 2),
(796, 'C-MLT-5302', 'Central-3', 'LG', '24000', '', '', '', 2),
(797, 'C-MLT-5315', 'Central-3', 'LG', '24000', '', '', '', 2),
(798, 'C-MLT-5339', 'Central-3', 'LG', '24000', '', '', '', 2),
(799, 'C-RYK-4098', 'Central-3', 'LG', '18000', '', '', '', 2),
(800, 'C-RYK-4235', 'Central-3', 'LG', '18000', '', '', '', 2),
(801, 'C-KOS-4378', 'Central-3', 'LG', '18000', '', '', '', 2),
(802, 'C-SHW-4413', 'Central-3', 'LG', '18000', '', '', '', 2),
(803, 'C-IQA-4918', 'Central-3', 'LG', '18000', '', '', '', 2),
(804, 'C-RYK-6164', 'Central-3', 'LG', '18000', '', '', '', 2),
(805, 'C-MLT-4738', 'Central-3', 'LG', '18000', '', '', '', 2),
(806, 'C-MLT-4974', 'Central-3', 'LG', '24000', '', '', '', 2),
(807, 'C-MLT-5184', 'Central-3', 'LG', '24000', '', '', '', 2),
(808, 'C-MLT-5289', 'Central-3', 'LG', '24000', '', '', '', 2),
(809, 'C-MLT-5293', 'Central-3', 'LG', '24000', '', '', '', 2),
(810, 'C-MLT-5298', 'Central-3', 'LG', '24000', '', '', '', 2),
(811, 'C-MLT-5333', 'Central-3', 'LG', '24000', '', '', '', 2),
(812, 'C-MLT-5342', 'Central-3', 'LG', '24000', '', '', '', 2),
(813, 'C-MLT-6661', 'Central-3', 'Mitsubishi', '24000', '', '', '', 4),
(814, 'C-MLT-4980', 'Central-3', 'LG', '24000', '', '', '', 2),
(815, 'C-MLT-5300', 'Central-3', 'LG', '24000', '', '', '', 2),
(816, 'C-MLT-4733', 'Central-3', 'LG', '24000', '', '', '', 2),
(817, 'MSC-60', 'Central-3', 'Sabro', '', '', '', '', 5),
(818, 'C-MLT-4054', 'Central-3', 'General', '24000', '', '', '', 2),
(819, 'C-MLT-4057', 'Central-3', 'LG', '24000', '', '', '', 2),
(820, 'C-VHR-4914', 'Central-3', 'LG', '24000', '', '', '', 2),
(821, 'C-LHR-4037', 'Central-1', 'Pel', '24000', '', '', '', 2),
(822, 'C-LHR-4028', 'Central-1', 'Acson', '24000', '', '', '', 2),
(823, 'C-LHR-4033', 'Central-1', 'LG', '18000', '', '', '', 2),
(824, 'C-LHR-4023', 'Central-1', 'Mitsubishi', '24000', '', '', '', 2),
(825, 'C-LHR-4071', 'Central-1', 'LG', '24000', '', '', '', 2),
(826, 'C-LHR-4064', 'Central-1', 'Pel', '24000', '', '', '', 2),
(827, 'C-LHR-4062', 'Central-1', 'Pel', '24000', '', '', '', 1),
(828, 'C-LHR-4061', 'Central-1', 'Pel', '24000', '', '', '', 2),
(829, 'C-LHR-4516', 'Central-1', 'Waves', '18000', '', '', '', 1),
(830, 'C-LHR-4125', 'Central-1', 'Waves', '18000', '', '', '', 2),
(831, 'C-LHR-4361', 'Central-1', 'LG', '18000', '', '', '', 2),
(832, 'C-LHR-4308', 'Central-1', 'Waves', '24000', '', '', '', 2),
(833, 'C-LHR-4347', 'Central-1', 'LG', '18000', '', '', '', 2),
(834, 'C-LHR-4362', 'Central-1', 'LG', '24000', '', '', '', 2),
(835, 'C-LHR-4302', 'Central-1', 'LG', '24000', '', '', '', 2),
(836, 'C-LHR-4549', 'Central-1', 'LG', '18000', '', '', '', 2),
(837, 'C-LHR-4607', 'Central-1', 'LG', '18000', '', '', '', 2),
(838, 'C-LHR-4544', 'Central-1', 'LG', '18000', '', '', '', 1),
(839, 'C-LHR-4131', 'Central-1', 'LG', '24000', '', '', '', 2),
(840, 'C-LHR-4612', 'Central-1', 'LG', '24000', '', '', '', 2),
(841, 'C-LHR-4592', 'Central-1', 'LG', '24000', '', '', '', 2),
(842, 'C-LHR-5487', 'Central-1', 'LG', '24000', '', '', '', 2),
(843, 'C-LHR-6160', 'Central-1', 'LG', '24000', '', '', '', 2),
(844, 'C-LHR-5488', 'Central-1', 'LG', '24000', '', '', '', 2),
(845, 'C-LHR-5445', 'Central-1', 'LG', '24000', '', '', '', 2),
(846, 'C-LHR-6354', 'Central-1', 'LG', '24000', '', '', '', 2),
(847, 'C-LHR-5482', 'Central-1', 'Pel', '24000', '', '', '', 2),
(848, 'C-LHR-5506', 'Central-1', 'LG', '24000', '', '', '', 2),
(849, 'C-LHR-4002', 'Central-1', 'Fujia', '24000', '', '', '', 2),
(850, 'C-LHR-4008', 'Central-1', 'Mitsubishi', '24000', '', '', '', 3),
(851, 'C-LHR-4010', 'Central-1', 'Mitsubishi', '24000', '', '', '', 3),
(852, 'C-LHR-4024', 'Central-1', 'Faulty', '24000', '', '', '', 2),
(853, 'C-LHR-4030', 'Central-1', 'Acson', '24000', '', '', '', 2),
(854, 'C-LHR-4031', 'Central-1', 'General', '24000', '', '', '', 1),
(855, 'C-LHR-4069', 'Central-1', 'LG', '24000', '', '', '', 3),
(856, 'C-LHR-4132', 'Central-1', 'Waves', '18000', '', '', '', 2),
(857, 'C-LHR-4001', 'Central-1', 'Mitsubishi', '24000', '', '', '', 2),
(858, 'C-LHR-4309', 'Central-1', 'LG', '18000', '', '', '', 2),
(859, 'C-LHR-4349', 'Central-1', 'LG', '18000', '', '', '', 2),
(860, 'C-LHR-4563', 'Central-1', 'Mitsubishi', '24000', '', '', '', 2),
(861, 'C-LHR-4348', 'Central-1', 'LG', '18000', '', '', '', 2),
(862, 'C-LHR-4305', 'Central-1', 'Waves', '18000', '', '', '', 2),
(863, 'C-LHR-4301', 'Central-1', 'Sabro', '18000', '', '', '', 2),
(864, 'C-LHR-4006', 'Central-1', 'Mitsubishi', '24000', '', '', '', 2),
(865, 'C-LHR-4007', 'Central-1', 'Fujia', '24000', '', '', '', 1),
(866, 'C-LHR-4009', 'Central-1', 'General', '24000', '', '', '', 1),
(867, 'C-LHR-4022', 'Central-1', 'LG', '24000', '', '', '', 2),
(868, 'C-LHR-4551', 'Central-1', 'LG', '18000', '', '', '', 2),
(869, 'C-LHR-4620', 'Central-1', 'LG', '24000', '', '', '', 2),
(870, 'C-LHR-4640', 'Central-1', 'LG', '24000', '', '', '', 2),
(871, 'C-LHR-4651', 'Central-1', 'LG', '18000', '', '', '', 2),
(872, 'C-LHR-4619', 'Central-1', 'LG', '18000', '', '', '', 2),
(873, 'C-LHR-5029', 'Central-1', 'LG', '24000', '', '', '', 2),
(874, 'C-LHR-5425', 'Central-1', 'LG', '24000', '', '', '', 2),
(875, 'C-LHR-6211', 'Central-1', 'LG', '24000', '', '', '', 2),
(876, 'C-LHR-5012', 'Central-1', 'LG', '24000', '', '', '', 2),
(877, 'C-LHR-6356', 'Central-1', 'LG', '24000', '', '', '', 2),
(878, 'C-LHR-6375', 'Central-1', 'LG', '24000', '', '', '', 2),
(879, 'C-LHR-6357', 'Central-1', 'LG', '24000', '', '', '', 2),
(880, 'C-LHR-5454', 'Central-1', 'LG', '24000', '', '', '', 2),
(881, 'C-LHR-5451', 'Central-1', 'LG', '24000', '', '', '', 2),
(882, 'C-LHR-6355', 'Central-1', 'LG', '24000', '', '', '', 2),
(883, 'C-LHR-5450', 'Central-1', 'LG', '24000', '', '', '', 2),
(884, 'C-LHR-6361', 'Central-1', 'LG', '24000', '', '', '', 2),
(885, 'C-LHR-4552', 'Central-1', 'LG', '24000', '', '', '', 2),
(886, 'C-LHR-4011', 'Central-1', 'Mitsubishi', '18000', '', '', '', 4),
(887, 'C-LHR-4013', 'Central-1', 'Acson', '24000', '', '', '', 2),
(888, 'C-LHR-4012', 'Central-1', 'LG', '24000', '', '', '', 2),
(889, 'C-LHR-4126', 'Central-1', 'Waves', '24000', '', '', '', 2),
(890, 'C-LHR-4065', 'Central-1', 'LG', '18000', '', '', '', 2),
(891, 'C-LHR-4341', 'Central-1', 'Waves', '18000', '', '', '', 2),
(892, 'C-LHR-4306', 'Central-1', 'LG', '18000', '', '', '', 2),
(893, 'C-LHR-4299', 'Central-1', 'LG', '24000', '', '', '', 2),
(894, 'C-LHR-4618', 'Central-1', 'LG', '18000', '', '', '', 2),
(895, 'C-LHR-5518', 'Central-1', 'LG', '24000', '', '', '', 2),
(896, 'C-LHR-6201', 'Central-1', 'LG', '24000', '', '', '', 2),
(897, 'C-LHR-5468', 'Central-1', 'LG', '24000', '', '', '', 2),
(898, 'C-LHR-5049', 'Central-1', 'LG', '24000', '', '', '', 2),
(899, 'C-LHR-5511', 'Central-1', 'LG', '24000', '', '', '', 2),
(900, 'C-LHR-5514', 'Central-1', 'LG', '24000', '', '', '', 2),
(901, 'C-LHR-6351', 'Central-1', 'LG', '24000', '', '', '', 2),
(902, 'C-LHR-5456', 'Central-1', 'LG', '24000', '', '', '', 2),
(903, 'C-LHR-6372', 'Central-1', 'LG', '24000', '', '', '', 2),
(904, 'C-LHR-5486', 'Central-1', 'LG', '24000', '', '', '', 2),
(905, 'C-LHR-5032', 'Central-1', 'LG', '24000', '', '', '', 2),
(906, 'C-LHR-4017', 'Central-1', 'Fujia', '24000', '', '', '', 1),
(907, 'C-LHR-4020', 'Central-1', 'Acson', '24000', '', '', '', 2),
(908, 'C-LHR-4034', 'Central-1', 'Mitsubishi', '24000', '', '', '', 1),
(909, 'C-LHR-4035', 'Central-1', 'Mitsubishi', '24000', '', '', '', 2),
(910, 'C-LHR-4016', 'Central-1', 'Mitsubishi', '24000', '', '', '', 1),
(911, 'C-LHR-4070', 'Central-1', 'Faulty', '24000', '', '', '', 2),
(912, 'C-LHR-4298', 'Central-1', 'LG', '18000', '', '', '', 2),
(913, 'C-LHR-4561', 'Central-1', 'LG', '18000', '', '', '', 2),
(914, 'C-LHR-4452', 'Central-1', 'LG', '24000', '', '', '', 2),
(915, 'C-LHR-4641', 'Central-1', 'LG', '24000', '', '', '', 2),
(916, 'C-LHR-4558', 'Central-1', 'LG', '24000', '', '', '', 2),
(917, 'C-LHR-4638', 'Central-1', 'LG', '24000', '', '', '', 2),
(918, 'C-LHR-4287', 'Central-1', 'LG', '18000', '', '', '', 2),
(919, 'C-LHR-4295', 'Central-1', 'LG', '24000', '', '', '', 2),
(920, 'C-LHR-5458', 'Central-1', 'LG', '24000', '', '', '', 2),
(921, 'C-LHR-5465', 'Central-1', 'LG', '24000', '', '', '', 2),
(922, 'C-LHR-6378', 'Central-1', 'LG', '24000', '', '', '', 2),
(923, 'C-LHR-5481', 'Central-1', 'LG', '24000', '', '', '', 2),
(924, 'C-LHR-5470', 'Central-1', 'LG', '24000', '', '', '', 2),
(925, 'C-LHR-5471', 'Central-1', 'LG', '24000', '', '', '', 2),
(926, 'C-GRN-4087', 'Central-1', 'LG', '24000', '', '', '', 2),
(927, 'C-GRN-4515', 'Central-1', 'LG', '24000', '', '', '', 2),
(928, 'C-GRN-4089', 'Central-1', 'Waves', '18000', '', '', '', 2),
(929, 'C-GRN-4040', 'Central-1', 'LG', '24000', '', '', '', 3),
(930, 'C-GRN-4265', 'Central-1', 'Waves', '18000', '', '', '', 2),
(931, 'C-GRN-4266', 'Central-1', 'Waves', '18000', '', '', '', 2),
(932, 'C-GRN-4267', 'Central-1', 'LG', '24000', '', '', '', 2),
(933, 'C-GRN-4334', 'Central-1', 'Waves', '18000', '', '', '', 2),
(934, 'C-GRN-4268', 'Central-1', 'Waves', '18000', '', '', '', 2),
(935, 'C-GRN-4270', 'Central-1', 'Waves', '18000', '', '', '', 2),
(936, 'C-GRN-4269', 'Central-1', 'LG', '18000', '', '', '', 2),
(937, 'C-GRN-4088', 'Central-1', 'LG', '24000', '', '', '', 2),
(938, 'C-GRN-5624', 'Central-1', 'LG', '24000', '', '', '', 2),
(939, 'C-GRN-5192', 'Central-1', 'LG', '24000', '', '', '', 2),
(940, 'C-GRN-5617', 'Central-1', 'LG', '24000', '', '', '', 2),
(941, 'C-GRN-5594', 'Central-1', 'LG', '24000', '', '', '', 2),
(942, 'C-GRN-5162', 'Central-1', 'LG', '18000', '', '', '', 2),
(943, 'C-GRN-5622', 'Central-1', 'LG', '24000', '', '', '', 2),
(944, 'C-GRN-5621', 'Central-1', 'LG', '24000', '', '', '', 2),
(945, 'C-GRN-4773', 'Central-1', 'LG', '24000', '', '', '', 2),
(946, 'C-GRN-5631', 'Central-1', 'LG', '24000', '', '', '', 2),
(947, 'C-GRN-5602', 'Central-1', 'LG', '24000', '', '', '', 2),
(948, 'C-GRN-5224', 'Central-1', 'LG', '24000', '', '', '', 2),
(949, 'C-GRN-5636', 'Central-1', 'LG', '24000', '', '', '', 2),
(950, 'C-GRN-5595', 'Central-1', 'LG', '24000', '', '', '', 2),
(951, 'C-GRN-5618', 'Central-1', 'LG', '24000', '', '', '', 2),
(952, 'C-LHR-4000', 'Central-1', 'Fujia', '24000', '', '', '', 2),
(953, 'C-LHR-4005', 'Central-1', 'Mitsubishi', '24000', '', '', '', 3),
(954, 'C-LHR-4014', 'Central-1', 'Faulty', '24000', '', '', '', 2),
(955, 'C-LHR-4015', 'Central-1', 'LG', '24000', '', '', '', 2),
(956, 'C-LHR-4021', 'Central-1', 'Acson', '24000', '', '', '', 2),
(957, 'C-LHR-4029', 'Central-1', 'Faulty', '24000', '', '', '', 2),
(958, 'C-LHR-4032', 'Central-1', 'LG', '24000', '', '', '', 2),
(959, 'C-LHR-4066', 'Central-1', 'Pel', '24000', '', '', '', 2),
(960, 'C-LHR-4130', 'Central-1', 'LG', '24000', '', '', '', 2),
(961, 'C-LHR-4314', 'Central-1', 'LG', '24000', '', '', '', 2),
(962, 'C-LHR-4312', 'Central-1', 'LG', '24000', '', '', '', 2),
(963, 'C-LHR-4622', 'Central-1', 'LG', '18000', '', '', '', 2),
(964, 'C-LHR-4623', 'Central-1', 'LG', '18000', '', '', '', 2),
(965, 'C-LHR-4605', 'Central-1', 'LG', '18000', '', '', '', 2),
(966, 'C-LHR-4604', 'Central-1', 'LG', '24000', '', '', '', 2),
(967, 'C-LHR-5543', 'Central-1', 'LG', '24000', '', '', '', 2),
(968, 'C-LHR-5455', 'Central-1', 'LG', '24000', '', '', '', 2),
(969, 'C-LHR-5523', 'Central-1', 'LG', '24000', '', '', '', 2),
(970, 'C-LHR-5058', 'Central-1', 'LG', '24000', '', '', '', 2),
(971, 'C-LHR-5044', 'Central-1', 'LG', '24000', '', '', '', 2),
(972, 'C-LHR-5440', 'Central-1', 'LG', '24000', '', '', '', 2),
(973, 'C-LHR-5547', 'Central-1', 'LG', '24000', '', '', '', 2),
(974, 'C-LHR-4542', 'Central-1', 'LG', '24000', '', '', '', 2),
(975, 'C-GRN-4774', 'Central-1', 'LG', '18000', '', '', '', 2),
(976, 'C-GRN-4041', 'Central-1', 'Mitsubishi', '24000', '', '', '', 1),
(977, 'C-GRN-4419', 'Central-1', 'Waves', '18000', '', '', '', 2),
(978, 'C-GRN-4420', 'Central-1', 'Waves', '18000', '', '', '', 2),
(979, 'C-GRN-4272', 'Central-1', 'LG', '18000', '', '', '', 2),
(980, 'C-GRN-4273', 'Central-1', 'Waves', '18000', '', '', '', 2),
(981, 'C-GRN-4336', 'Central-1', 'Waves', '18000', '', '', '', 2),
(982, 'C-GRN-4337', 'Central-1', 'LG', '18000', '', '', '', 2),
(983, 'C-GRN-5612', 'Central-1', 'LG', '24000', '', '', '', 2),
(984, 'C-GRN-5616', 'Central-1', 'LG', '24000', '', '', '', 2),
(985, 'C-GRN-5627', 'Central-1', 'LG', '24000', '', '', '', 2),
(986, 'C-GRN-5222', 'Central-1', 'LG', '24000', '', '', '', 2),
(987, 'C-GRN-4767', 'Central-1', 'LG', '24000', '', '', '', 2),
(988, 'C-GRN-5159', 'Central-1', 'LG', '24000', '', '', '', 2),
(989, 'C-GRN-6070', 'Central-1', 'LG', '24000', '', '', '', 2),
(990, 'C-GRN-5603', 'Central-1', 'LG', '24000', '', '', '', 2),
(991, 'C-GRN-5223', 'Central-1', 'LG', '24000', '', '', '', 2),
(992, 'C-GRN-5605', 'Central-1', 'LG', '24000', '', '', '', 2),
(993, 'C-GRN-5613', 'Central-1', 'LG', '24000', '', '', '', 2),
(994, 'C-GRN-5601', 'Central-1', 'LG', '24000', '', '', '', 2),
(995, 'C-GRN-5597', 'Central-1', 'LG', '24000', '', '', '', 2),
(996, 'C-GRN-5599', 'Central-1', 'LG', '24000', '', '', '', 2),
(997, 'C-GRN-6383', 'Central-1', 'LG', '24000', '', '', '', 2),
(998, 'C-GRN-5608', 'Central-1', 'LG', '18000', '', '', '', 2),
(999, 'C-RYK-5808', 'Central-1', 'LG', '24000', '', '', '', 2),
(1000, 'C-LHR-4018', 'Central-1', 'LG', '24000', '', '', '', 3),
(1001, 'C-LHR-5555', 'Central-1', 'Acson', '24000', '', '', '', 2),
(1002, 'C-LHR-6186', 'Central-1', 'LG', '24000', '', '', '', 2),
(1003, 'C-LHR-5513', 'Central-1', 'LG', '24000', '', '', '', 2),
(1004, 'C-GRN-5615', 'Central-1', 'LG', '24000', '', '', '', 3),
(1005, 'C-LHR-5473', 'Central-1', 'LG', '24000', '', '', '', 2),
(1006, 'C-LHR-5424', 'Central-1', 'LG', '24000', '', '', '', 2),
(1007, 'C-LHR-6367', 'Central-1', 'LG', '24000', '', '', '', 2),
(1008, 'C-LHR-6758', 'Central-1', 'LG', '24000', '', '', '', 2),
(1009, 'C-LHR-6736', 'Central-1', 'LG', '24000', '', '', '', 2),
(1010, 'C-LHR-6683', 'Central-1', 'LG', '24000', '', '', '', 2),
(1011, 'C-LHR5434', 'Central-1', 'LG', '24000', '', '', '', 2),
(1012, 'C-GRN-7231', 'Central-1', 'LG', '24000', '', '', '', 2),
(1013, 'C-GRN-7249', 'Central-1', 'LG', '24000', '', '', '', 2),
(1014, 'C-GRN-6745', 'Central-1', 'LG', '24000', '', '', '', 2),
(1015, 'C-GRN-7232', 'Central-1', 'LG', '24000', '', '', '', 2),
(1016, 'C-LHR-5592', 'Central-1', 'Mitsubishi', '24000', '', '', '', 2),
(1017, 'C-LHR-5499', 'Central-1', 'LG', '24000', '', '', '', 2),
(1018, 'C-GRN-7235', 'Central-1', 'Mitsubishi', '24000', '', '', '', 2),
(1019, 'C-GRN-5633', 'Central-1', 'LG', '24000', '', '', '', 2),
(1020, 'C-LHR-5466', 'Central-1', 'LG', '24000', '', '', '', 2),
(1021, 'C-LHR-5571', 'Central-1', 'LG', '24000', '', '', '', 2),
(1022, 'C-LHR-4343', 'Central-1', 'LG', '18000', '', '', '', 2),
(1023, 'C-LHR-5522', 'Central-1', 'LG', '24000', '', '', '', 2),
(1024, 'C-LHR-4019', 'Central-1', 'LG', '24000', '', '', '', 3),
(1025, 'C-KMK-4044', 'Central-1', 'LG', '24000', '', '', '', 2),
(1026, 'C-GKK-4145', 'Central-1', 'Waves', '18000', '', '', '', 2),
(1027, 'C-KMK-4217', 'Central-1', 'Waves', '18000', '', '', '', 2),
(1028, 'C-QDS-4143', 'Central-1', 'Waves', '18000', '', '', '', 2),
(1029, 'C-SDK-4417', 'Central-1', 'Waves', '18000', '', '', '', 2),
(1030, 'C-KKY-4238', 'Central-1', 'Sabro', '18000', '', '', '', 2),
(1031, 'C-KNA-4447', 'Central-1', 'Waves', '18000', '', '', '', 2),
(1032, 'C-AHN-4335', 'Central-1', 'Waves', '18000', '', '', '', 2),
(1033, 'C-EMD-4382', 'Central-1', 'LG', '18000', '', '', '', 2),
(1034, 'C-APC-4146', 'Central-1', 'Sabro', '18000', '', '', '', 2),
(1035, 'C-LHR-4350', 'Central-1', 'LG', '24000', '', '', '', 2),
(1036, 'C-KOL-4498', 'Central-1', 'LG', '18000', '', '', '', 2),
(1037, 'C-NKR-4501', 'Central-1', 'LG', '18000', '', '', '', 2),
(1038, 'C-NVK-4468', 'Central-1', '', '24000', '', '', '', 2),
(1039, 'C-LHR-4559', 'Central-1', 'LG', '18000', '', '', '', 2),
(1040, 'C-LHR-4562', 'Central-1', 'LG', '24000', '', '', '', 2),
(1041, 'C-LHR-4300', 'Central-1', 'LG', '18000', '', '', '', 2),
(1042, 'C-DHK-4510', 'Central-1', 'LG', '18000', '', '', '', 2),
(1043, 'C-QMS-5630', 'Central-1', 'LG', '24000', '', '', '', 2),
(1044, 'C-MRN-5625', 'Central-1', '', '24000', '', '', '', 2),
(1045, 'C-LHR-6142', 'Central-1', 'LG', '24000', '', '', '', 2),
(1046, 'C-LHR-5505', 'Central-1', 'LG', '24000', '', '', '', 2),
(1047, 'C-LHR-5013', 'Central-1', 'LG', '24000', '', '', '', 2),
(1048, 'C-LHR-5034', 'Central-1', 'LG', '24000', '', '', '', 2),
(1049, 'C-LHR-5568', 'Central-1', 'LG', '24000', '', '', '', 2),
(1050, 'C-LHR-5442', 'Central-1', 'LG', '24000', '', '', '', 2),
(1051, 'C-LHR-4303', 'Central-1', 'LG', '24000', '', '', '', 2),
(1052, 'C-GRN-6382', 'Central-1', 'LG', '24000', '', '', '', 2),
(1053, 'C-GRN-4769', 'Central-1', 'LG', '24000', '', '', '', 2),
(1054, 'C-AWA-5629', 'Central-1', 'LG', '24000', '', '', '', 2),
(1055, 'C-LHR-4621', 'Central-1', 'LG', '24000', '', '', '', 2),
(1056, 'C-LHR-5490', 'Central-1', 'LG', '24000', '', '', '', 2),
(1057, 'C-GRN-5598', 'Central-1', 'LG', '24000', '', '', '', 2),
(1058, 'C-LHR-6364', 'Central-1', 'LG', '24000', '', '', '', 2),
(1059, 'C-LHR-5554', 'Central-1', 'LG', '24000', '', '', '', 2),
(1060, 'C-LHR-5484', 'Central-1', 'LG', '24000', '', '', '', 2),
(1061, 'C-LHR-5011', 'Central-1', 'LG', '24000', '', '', '', 2),
(1062, 'C-GRN-5131', 'Central-1', 'LG', '24000', '', '', '', 2),
(1063, 'C-LHR-5452', 'Central-1', 'LG', '24000', '', '', '', 2),
(1064, 'C-LHR-5046', 'Central-1', 'LG', '24000', '', '', '', 2),
(1065, 'C-LHR-6682', 'Central-1', 'LG', '24000', '', '', '', 2),
(1066, 'C-LHR-6686', 'Central-1', 'LG', '24000', '', '', '', 2),
(1067, 'C-LHR6688', 'Central-1', 'LG', '24000', '', '', '', 2),
(1068, 'C-KMK-6013', 'Central-1', 'LG', '18000', '', '', '', 2),
(1069, 'C-LHR-5510', 'Central-1', 'LG', '24000', '', '', '', 2),
(1070, 'C-LHR-5512', 'Central-1', 'Mitsubishi', '24000', '', '', '', 2),
(1071, 'C-LHR-5483', 'Central-1', 'Mitsubishi', '24000', '', '', '', 2),
(1072, 'C-LHR-7349', 'Central-1', 'Mitsubishi', '24000', '', '', '', 2),
(1073, 'C-GRN-6692', 'Central-1', 'LG', '24000', '', '', '', 2),
(1074, 'C-LHR-5557', 'Central-1', 'LG', '24000', '', '', '', 2),
(1075, 'C-LHR-7348', 'Central-1', 'Mitsubishi', '24000', '', '', '', 2),
(1076, 'C-LHR-5476', 'Central-1', 'Mitsubishi', '24000', '', '', '', 2),
(1077, 'C-GRN-7239', 'Central-1', '', '24000', '', '', '', 2),
(1078, 'C-LHR-6687', 'Central-1', 'Mitsubishi', '24000', '', '', '', 2),
(1079, 'C-LHR-6362', 'Central-1', 'LG', '24000', '', '', '', 2),
(1080, 'C-GRN-7252', 'Central-1', 'Mitsubishi', '24000', '', '', '', 2),
(1081, 'C-GRN-7236', 'Central-1', 'Mitsubishi', '24000', '', '', '', 2),
(1082, 'C-LHR-5453', 'Central-1', 'LG', '24000', '', '', '', 2),
(1083, 'C-BKE-5600', 'Central-1', 'Mitsubishi', '24000', '', '', '', 2),
(1084, 'C-LHR-6188', 'Central-1', 'Mitsubishi', '24000', '', '', '', 2),
(1085, 'C-GRN-5191', 'Central-1', 'Mitsubishi', '24000', '', '', '', 2),
(1086, 'C-GRN-7237', 'Central-1', 'Mitsubishi', '24000', '', '', '', 2),
(1087, 'C-GHA-4424', 'Central-1', 'Sabro', '18000', '', '', '', 2),
(1088, 'C-SWL-4077', 'Central-1', 'LG', '18000', '', '', '', 2),
(1089, 'C-SWL-4376', 'Central-1', 'Waves', '18000', '', '', '', 2),
(1090, 'C-SWL-4076', 'Central-1', 'LG', '24000', '', '', '', 3),
(1091, 'C-MCH-4155', 'Central-1', 'Waves', '18000', '', '', '', 2),
(1092, 'C-KSW-4428', 'Central-1', 'LG', '18000', '', '', '', 2),
(1093, 'C-HPP-4434', 'Central-1', 'LG', '18000', '', '', '', 2),
(1094, 'C-HPP-4435', 'Central-1', 'Waves', '18000', '', '', '', 2),
(1095, 'C-CHH-4177', 'Central-1', 'LG', '18000', '', '', '', 2),
(1096, 'C-ADK-4406', 'Central-1', 'LG', '18000', '', '', '', 2),
(1097, 'C-SWL-5354', 'Central-1', 'LG', '24000', '', '', '', 2),
(1098, 'C-SWL-5238', 'Central-1', 'LG', '24000', '', '', '', 2),
(1099, 'C-SWL-5356', 'Central-1', 'LG', '24000', '', '', '', 2),
(1100, 'C-SWL-5360', 'Central-1', 'LG', '24000', '', '', '', 2),
(1101, 'C-SWL-5357', 'Central-1', 'LG', '24000', '', '', '', 2),
(1102, 'C-SWL-5345', 'Central-1', 'LG', '24000', '', '', '', 2),
(1103, 'C-SWL-5355', 'Central-1', 'LG', '24000', '', '', '', 2),
(1104, 'C-SWL-5353', 'Central-1', 'LG', '24000', '', '', '', 2),
(1105, 'C-CHW-7616', 'Central-1', 'Mitsubishi', '24000', '', '', '', 2),
(1106, 'C-RUR-6938', 'Central-1', 'Mitsubishi', '24000', '', '', '', 2),
(1107, 'C-CHW-6942', 'Central-1', 'Mitsubishi', '24000', '', '', '', 2),
(1108, 'C-LHR-7359', 'Central-1', 'Mitsubishi', '24000', '', '', '', 2),
(1109, 'Co-Location', 'Central-1', 'Mitsubishi', '24000', '', '', '', 2),
(1110, 'C-66', 'Central-1', 'LG', '18000', '', '', '', 1),
(1111, 'C-66', 'Central-1', 'Sabro', '24000', '', '', '', 1),
(1112, 'C-VHR-4214', 'Central-3', 'Waves', '18000', '', '', '', 1),
(1113, 'C-DGK-4475', 'Central-3', 'National', '18000', '', '', '', 1),
(1114, 'C-DGK-4475', 'Central-3', 'National', '18000', '', '', '', 1),
(1115, 'C-DGK-4475', 'Central-3', 'National', '24000', '', '', '', 1),
(1116, 'C-SRG-4228', 'Central-2', 'Acson', '18000', '', '', '', 1),
(1117, 'C-SRG-4228', 'Central-2', 'Acson', '18000', '', '', '', 1),
(1118, 'C-SRG-4228', 'Central-2', 'Acson', '18000', '', '', '', 1),
(1119, 'C-SRG-4228', 'Central-2', 'LG', '24000', '', '', '', 1),
(1120, 'C-DGK-4104', 'Central-3', 'Waves', '24000', '', '', '', 1),
(1121, 'C-BLP-4230', 'Central-3', 'LG', '24000', '', '', '', 1),
(1122, 'N-ABD-8169', 'North', 'Waves', '18000', '', '', '', 1),
(1123, 'N-ABD-8169', 'North', 'Waves', '18000', '', '', '', 1),
(1124, 'N-ABD-8169', 'North', 'Waves', '18000', '', '', '', 1),
(1125, 'N-ABD-8169', 'North', 'LG', '24000', '', '', '', 1),
(1126, 'C-FSB-4049', 'Central-2', 'Pel', '24000', '', '', '', 1),
(1127, 'C-FSB-4246', 'Central-2', 'LG', '24000', '', '', '', 1),
(1128, 'C-BLP-4232', 'Central-3', 'LG', '18000', '', '', '', 1),
(1129, 'C-BLP-4101', 'Central-3', 'Sabro', '18000', '', '', '', 1),
(1130, 'C-BLP-4101', 'Central-3', 'LG', '18000', '', '', '', 1),
(1131, 'C-MLS-4189', 'Central-3', 'LG', '18000', '', '', '', 1),
(1132, 'C-MLT-4278', 'Central-3', 'Waves', '18000', '', '', '', 1),
(1133, 'C-LHR-4027', 'Central-1', 'LG', '24000', '', '', '', 1),
(1134, 'C-GRN-4087', 'Central-1', 'Mitsubishi', '24000', '', '', '', 2),
(1135, 'C-VHR-4100', 'Central-3', 'Mitsubishi', '24000', '', '', '', 2),
(1136, 'C-LHR-4021', 'Central-1', 'LG', '24000', '', '', '', 1),
(1137, 'C-LHR-4013', 'Central-1', 'LG', '24000', '', '', '', 1),
(1138, 'C-SRG-4116', 'Central-2', 'Mitsubishi', '24000', '', '', '', 2),
(1139, 'C-FSB-4047', 'Central-2', 'Sanyo', '24000', '', '', '', 1),
(1140, 'N-ISB-8010', 'North', 'LG', '18000', '', '', '', 5),
(1141, 'N-ISB-8010', 'North', 'Acson', '18000', '', '', '', 10),
(1142, 'N-ISB-8010', 'North', 'Pel', '18000', '', '', '', 3),
(1143, 'C-FSB-4254', 'Central-2', 'Sabro', '18000', '', '', '', 1),
(1144, 'C-MLT-4094', 'Central-3', 'Waves', '18000', '', '', '', 1),
(1145, 'C-MLT-4055', 'Central-3', 'Mitsubishi', '24000', '', '', '', 1),
(1146, 'C-FSB-4703', 'Central-2', 'Pel', '24000', '', '', '', 1),
(1147, 'C-JHG-4390', 'Central-2', 'Sabro', '18000', '', '', '', 1),
(1148, 'N-TAX-8054', 'North', 'GENERAL', '24000', '', '', '', 1),
(1149, 'C-MLT-4059', 'Central-3', 'Pel', '24000', '', '', '', 1),
(1150, 'C-LHR-4034', 'Central-1', 'LG', '24000', '', '', '', 1),
(1151, 'C-MLT-4280', 'Central-3', 'Waves', '24000', '', '', '', 1),
(1152, 'C-MLT-4057', 'Central-3', 'Mitsubishi', '24000', '', '', '', 1),
(1153, 'C-LHR-4033', 'Central-1', 'ACSON', '24000', '', '', '', 1),
(1154, 'C-BLP-4102', 'Central-3', 'LG', '18000', '', '', '', 2),
(1155, 'MSC-60', 'Central-1', 'LG', '', '', '', '', 5),
(1156, 'MSC-60', 'Central-1', 'Acson', '', '', '', '', 5),
(1157, 'MSC-60', 'Central-1', 'National', '', '', '', '', 4),
(1158, 'C-LHR-4023', 'Central-1', 'Waves', '24000', '', '', '', 1),
(1159, 'N-ISB-8079', 'North', 'PEL', '24000', '', '', '', 1),
(1160, 'C-LHR-4071', 'Central-1', 'Mitsubishi', '24000', '', '', '', 1),
(1161, 'C-LHR-5513', 'Central-1', 'Mitsubishi', '24000', '', '', '', 2),
(1162, 'C-RYK-4098', 'Central-3', 'Mitsubishi', '18000', '', '', '', 1),
(1163, 'C-RYK-4098', 'Central-3', 'Sabro', '18000', '', '', '', 1),
(1164, 'C-RYK-4212', 'Central-3', 'Sabro', '18000', '', '', '', 3),
(1165, 'C-BRW-4478', 'Central-1', 'LG', '24000', '', '', '', 1),
(1166, 'C-FSB-4048', 'Central-2', 'Acson', '24000', '', '', '', 8),
(1167, 'C-JHG-4112', 'Central-2', 'LG', '24000', '', '', '', 1),
(1168, 'C-SRG-4226', 'Central-2', 'LG', '18000', '', '', '', 1),
(1169, 'C-LHR-4544', 'Central-1', 'JetCool', '18000', '', '', '', 1),
(1170, 'C-MBN-4200', 'Central-1', 'LG', '18000', '', '', '', 2),
(1171, 'C-MKW-4165', 'Central-1', 'LG', '18000', '', '', '', 2),
(1172, 'C-MON-4500', 'Central-1', 'LG', '18000', '', '', '', 2),
(1173, 'C-MBN-5606', 'Central-1', 'LG', '24000', '', '', '', 2),
(1174, 'C-LHR-5489', 'Central-1', 'LG', '24000', '', '', '', 2),
(1175, 'C-LHR-5480', 'Central-1', 'LG', '24000', '', '', '', 2),
(1176, 'C-OKA-4115', 'Central-1', 'Sabro', '18000', '', '', '', 2),
(1177, 'C-GYW-4437', 'Central-1', 'LG', '18000', '', '', '', 2),
(1178, 'C-RNK-4170', 'Central-1', 'Waves', '18000', '', '', '', 2),
(1179, 'C-OKA-4114', 'Central-1', 'LG', '24000', '', '', '', 3),
(1180, 'C-OKA-4225', 'Central-1', 'Sabro', '18000', '', '', '', 2),
(1181, 'C-OKA-4224', 'Central-1', 'LG', '18000', '', '', '', 2),
(1182, 'C-LHR-5010', 'Central-1', 'LG', '24000', '', '', '', 2),
(1183, 'C-GRN-5160', 'Central-1', 'LG', '24000', '', '', '', 1),
(1184, 'C-SLK-4203', 'Central-1', 'Sabro', '18000', '', '', '', 2),
(1185, 'C-SLK-5164', 'Central-1', 'LG', '24000', '', '', '', 2),
(1186, 'C-SLK-4081', 'Central-1', 'LG', '18000', '', '', '', 2),
(1187, 'C-SLK-5094', 'Central-1', 'LG', '24000', '', '', '', 2),
(1188, 'C-GRN-6386', 'Central-1', 'LG', '24000', '', '', '', 2),
(1189, 'B47', 'Central-1', 'LG', '24000', '', '', '', 6),
(1190, 'C-MLT-5305', 'Central-3', 'LG', '24000', '', '', '', 2),
(1191, 'C-BWG-4205', 'Central-1', 'LG', '18000', '', '', '', 2),
(1192, 'C-BWG-5685', 'Central-1', 'LG', '24000', '', '', '', 2),
(1193, 'C-KBS-4264', 'Central-1', 'LG', '18000', '', '', '', 2),
(1194, 'C-BWG-4411', 'Central-1', 'LG', '18000', '', '', '', 2),
(1195, 'C-BWG-5241', 'Central-1', 'LG', '24000', '', '', '', 2),
(1196, 'C-BWG-5684', 'Central-1', 'LG', '24000', '', '', '', 2),
(1197, 'C-CHS-4136', 'Central-3', 'LG', '18000', '', '', '', 2),
(1198, 'C-SLK-4324', 'Central-1', 'LG', '18000', '', '', '', 2),
(1199, 'C-SLK-4079', 'Central-1', 'LG', '24000', '', '', '', 3),
(1200, 'C-SLK-5649', 'Central-1', 'LG', '24000', '', '', '', 2),
(1201, 'C-SLK-5093', 'Central-1', 'LG', '24000', '', '', '', 2),
(1202, 'C-SLK-5642', 'Central-1', 'LG', '24000', '', '', '', 2),
(1203, 'C-SLK-5105', 'Central-1', 'LG', '24000', '', '', '', 2),
(1204, 'C-BWG-4095', 'Central-1', 'LG', '24000', '', '', '', 2),
(1205, 'C-SLK-5106', 'Central-1', 'LG', '24000', '', '', '', 2),
(1206, 'C-SLK-5645', 'Central-1', 'LG', '24000', '', '', '', 2),
(1207, 'C-SLK-5643', 'Central-1', 'LG', '24000', '', '', '', 1),
(1208, 'C-SLK-5166', 'Central-1', 'LG', '18000', '', '', '', 2),
(1209, 'C-SLK-5225', 'Central-1', 'LG', '24000', '', '', '', 2),
(1210, 'C-WBT-5243', 'Central-1', 'LG', '18000', '', '', '', 2),
(1211, 'C-SLK-5104', 'Central-1', 'LG', '24000', '', '', '', 2),
(1212, 'C-SLK-4321', 'Central-1', 'Waves', '18000', '', '', '', 2),
(1213, 'C-GJT-4369', 'Central-1', 'LG', '18000', '', '', '', 1),
(1214, 'C-GJT-4633', 'Central-1', 'Acson', '18000', '', '', '', 2),
(1215, 'C-GJT-4330', 'Central-1', 'LG', '24000', '', '', '', 2),
(1216, 'C-GJT-4331', 'Central-1', 'Sabro', '18000', '', '', '', 2),
(1217, 'C-GJT-4634', 'Central-1', 'LG', '18000', '', '', '', 2),
(1218, 'C-GJT-4630', 'Central-1', 'LG', '18000', '', '', '', 2),
(1219, 'C-GJT-4197', 'Central-1', 'LG', '18000', '', '', '', 2),
(1220, 'C-GJT-4333', 'Central-1', 'LG', '18000', '', '', '', 2),
(1221, 'C-GJT-6069', 'Central-1', 'LG', '24000', '', '', '', 2),
(1222, 'C-GJT-4091', 'Central-1', 'LG', '24000', '', '', '', 3),
(1223, 'C-LHR-5059', 'Central-1', 'LG', '24000', '', '', '', 2),
(1224, 'M-40', 'Central-1', 'Acson', '48000', '', '', '', 10),
(1225, 'C-LHR-5447', 'Central-1', 'LG', '24000', '', '', '', 2),
(1226, 'C-DNG-4397', 'Central-1', 'Waves', '18000', '', '', '', 2),
(1227, 'C-LHR-4027', 'Central-1', 'Acson', '24000', '', '', '', 2),
(1228, 'C-DGA-4147', 'Central-1', 'LG', '18000', '', '', '', 2),
(1229, 'C-PLA-4339', 'Central-1', 'LG', '18000', '', '', '', 2),
(1230, 'C-PHA-4957', 'Central-1', 'LG', '24000', '', '', '', 2),
(1231, 'C-GRN-4770', 'Central-1', 'LG', '24000', '', '', '', 2),
(1232, 'C-SLK-5644', 'Central-1', 'LG', '24000', '', '', '', 2),
(1233, 'C-SLK-4323', 'Central-1', 'LG', '18000', '', '', '', 2),
(1234, 'C-SLK-4080', 'Central-1', 'LG', '24000', '', '', '', 2),
(1235, 'C-SLK-4402', 'Central-1', 'Waves', '18000', '', '', '', 2),
(1236, 'C-SLK-4082', 'Central-1', 'LG', '24000', '', '', '', 2),
(1237, 'M-40', 'Central-1', 'Mitsubishi', '48000', '', '', '', 5),
(1238, 'M-40', 'Central-1', 'PEL', '24000', '', '', '', 5),
(1239, 'M-40', 'Central-1', 'LG', '24000', '', '', '', 3),
(1240, 'C-BWG-4095', 'Central-1', 'Mitsubishi', '24000', '', '', '', 1),
(1241, 'C-BWG-4095', 'Central-1', 'Sabro', '24000', '', '', '', 1),
(1242, 'C-SLK-4079', 'Central-1', 'Acson', '24000', '', '', '', 2),
(1243, 'C-SLK-4080', 'Central-1', 'Mitsubishi', '24000', '', '', '', 1),
(1244, 'C-SLK-4323', 'Central-1', 'Sabro', '18000', '', '', '', 1),
(1245, 'C-GJT-4369', 'Central-1', 'Waves', '18000', '', '', '', 1),
(1246, 'C-LHR-4015', 'Central-1', 'Mitsubishi', '24000', '', '', '', 1),
(1247, 'C-LHR-4001', 'Central-1', 'General', '24000', '', '', '', 1),
(1248, 'C-LHR-4012 ', 'Central-1', 'Fujia', '24000', '', '', '', 1),
(1249, 'C-LHR-4012 ', 'Central-1', 'Mitsubishi', '24000', '', '', '', 1),
(1250, 'C-LHR-4002', 'Central-1', 'Mitsubishi', '24000', '', '', '', 1),
(1251, 'C-KMK-4044', 'Central-1', 'Sabro', '24000', '', '', '', 1),
(1252, 'C-LHR-4017', 'Central-1', 'Mitsubishi', '24000', '', '', '', 1),
(1253, 'C-LHR-4016', 'Central-1', 'Sabro', '24000', '', '', '', 1),
(1254, 'C-LHR-4126', 'Central-1', 'LG', '24000', '', '', '', 1),
(1255, 'C-LHR-4031', 'Central-1', 'Fujia', '24000', '', '', '', 1),
(1256, 'C-LHR-4000', 'Central-1', 'Mitsubishi', '24000', '', '', '', 1),
(1257, 'C-LHR-4009', 'Central-1', 'Mitsubishi', '24000', '', '', '', 1),
(1258, 'C-LHR-4006', 'Central-1', 'Fujia', '24000', '', '', '', 1),
(1259, 'C-LHR-4006', 'Central-1', 'Sabro', '24000', '', '', '', 1),
(1260, 'C-LHR-4022', 'Central-1', 'Mitsubishi', '24000', '', '', '', 1),
(1261, 'C-LHR-4007', 'Central-1', 'Mitsubishi', '24000', '', '', '', 1),
(1262, 'C-LHR-5555', 'Central-1', 'Acson', '48000', '', '', '', 1),
(1263, 'C-LHR-4062', 'Central-1', 'Pel', '18000', '', '', '', 1),
(1264, 'C-MLT-4977', 'Central-3', 'Pel', '18000', '', '', '', 2),
(1265, 'C-MLT-5307', 'Central-3', 'Pel', '18000', '', '', '', 2),
(1266, 'C-MLT-5271', 'Central-3', 'Pel', '18000', '', '', '', 2),
(1267, 'C-MLT-5342', 'Central-3', 'Pel', '18000', '', '', '', 1),
(1268, 'C-MLT-5327', 'Central-3', 'Pel', '18000', '', '', '', 1);
0

I have Fix Your Code Please Use Below Code:

<strong><p align="center">Air Conditioner Data Update</p></strong><br> 
 
<?php
$host="localhost"; // Host name 
$username="username"; // Mysql username 
$password="pass"; // Mysql password 
$db_name="dbname"; // Database name 
$tbl_name="sims_ac"; // Table name 
 
// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");
 $a=$_REQUEST['a']; //Its getting value from previoes page
 echo $a; //its echoing value which I get from previous page.
//$a='1008'; // its static value this code work perfectly when I assign value like this, but not working when I get the value from previoes page.
 
$sql="SELECT * FROM $tbl_name WHERE mid(SiteID,7)='$a'";
$result=mysql_query($sql);
 
// Count table rows 
$count=mysql_num_rows($result);
?>
<table  width="500" border="0" cellspacing="1" cellpadding="0">
<form name="form1" method="post" action="sims_ac_update.php">
<tr> 
<td>
<table class="mytable" width="500" border="0" cellspacing="1" cellpadding="0">
 
 
<tr>
<td align="center"><strong>SiteId</strong></td>
<td align="center"><strong></strong></td>
<td align="center"><strong>AcMake</strong></td>
<td align="center"><strong>AcCapacity </strong></td>
<td align="center"><strong>AMP</strong></td>
<td align="center"><strong>qty</strong></td>
 
 
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
 
<td align="center"><? //$SiteId[]=$a; ?><? echo $a; ?></td>
<td align="center"><input name="SrNo[]" type="hidden" id="SrNo" value="<? echo $rows['SrNo']; ?>"></td>
<td align="center"><input name="AcMake[]" type="text" id="AcMake" value="<? echo $rows['AcMake']; ?>"></td>
<td align="center"><input name="AcCapacity[]" type="text" id="AcCapacity" value="<? echo $rows['AcCapacity']; ?>"></td>
<td align="center"><input name="AMP[]" type="text" id="AMP" value="<? echo $rows['AMP']; ?>"></td>
<td align="center"><input name="qty[]" type="text" id="qty" value="<? echo $rows['qty']; ?>"></td>
</tr>
<?php
}
?>
<tr>
<td colspan="4" align="center"><input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
</td>
</tr>
</form>
</table>
<?php
// Check if button name "Submit" is active, do this 
if (isset($_POST['Submit']))
{
for($i=0;$i<$count;$i++){
 
echo $a;
$b= $_POST['AcMake'][$i];
//echo $b;
$c= $_POST['AcCapacity'][$i];
//echo $c;
$d= $_POST['AMP'][$i];
//echo $d;
$e= $_POST['qty'][$i];
//echo $e;
$f= $_POST['SrNo'][$i];
//echo $f;
$query=mysql_query("UPDATE $tbl_name SET AcMake='$b', AcCapacity='$c', AMP='$d', qty='$e' WHERE mid(SiteId,7)='$a' AND SrNo='$f'");
 
 
}
echo "<script lang='javascript'>
window.location.href='sims_ac_update.php';
</script>";
}
 
if($quyery){
header("location:sims_ac_update.php");
}
mysql_close();
?>

I have insert a javascript that refresh your page after inserting updating any value. please find demo.
The above Code is Work Fine for me. You may Look a Demo Here:
http://www.kuchamancity.com/test/sims_ac_update.php

0

there is a same problem
for example if i want to update id 0139
when I press submit it will show result like demo instead of updating.

0

I have a page search.php and I write 0139
there are only 2 records in table whrer id contains 0139
now its show 2 records in fields.
but when I update its shows many records and not update properly.
even in your demo same proble occurs.
please put a search.php for finding result.

0

Could you paste Your search.php page code so i will review it.
and also please tell me that the above code will work fine or not?

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.