UPDATE `med_hotel` SET `manifest` = '360' WHERE `code`='BDJ2' and `med_hotel_no`='506'<br>UPDATE `med_hotel` SET `manifest` = '5' WHERE `code`='BDJ3' and `med_hotel_no`='206'<br>UPDATE `med_hotel` SET `manifest` = '353' WHERE `code`='BDJ3' and `med_hotel_no`='420'<br>UPDATE `med_hotel` SET `manifest` = '360' WHERE `code`='BDJ4' and `med_hotel_no`='421'<br>UPDATE `med_hotel` SET `manifest` = '11' WHERE `code`='BDJ6' and `med_hotel_no`='223'<br>UPDATE `med_hotel` SET `manifest` = '270' WHERE `code`='BDJ6' and `med_hotel_no`='511'<br>UPDATE `med_hotel` SET `manifest` = '79' WHERE `code`='BDJ6' and `med_hotel_no`='518'<br>UPDATE `med_hotel` SET `manifest` = '360' WHERE `code`='BDJ8' and `med_hotel_no`='406'<br>UPDATE `med_hotel` SET `manifest` = '160' WHERE `code`='BDJ10' and `med_hotel_no`='413'<br>UPDATE `med_hotel` SET `manifest` = '200' WHERE `code`='BDJ10' and `med_hotel_no`='414'<br>UPDATE `med_hotel` SET `manifest` = '354' WHERE `code`='BDJ11' and `med_hotel_no`='419'<br>UPDATE `med_hotel` SET `manifest` = '360' WHERE `code`='BDJ13' and `med_hotel_no`='521'<br>UPDATE `med_hotel` SET `manifest` = '358' WHERE `code`='BDJ17' and `med_hotel_no`='401'<br>UPDATE `med_hotel` SET `manifest` = '347' WHERE `code`='BDJ19' and `med_hotel_no`='523'<br>UPDATE `med_hotel` SET `manifest` = '179' WHERE `code`='BPN1' and `med_hotel_no`='306'<br>UPDATE `med_hotel` SET `manifest` = '180' WHERE `code`='BPN1' and `med_hotel_no`='425'<br>UPDATE `med_hotel` SET `manifest` = '32' WHERE `code`='BPN4' and `med_hotel_no`='206'<br>UPDATE `med_hotel` SET `manifest` = '157' WHERE `code`='BPN4' and `med_hotel_no`='325'<br>UPDATE `med_hotel` SET `manifest` = '169' WHERE `code`='BPN4' and `med_hotel_no`='411'<br>UPDATE `med_hotel` SET `manifest` = '1' WHERE `code`='BPN8' and `med_hotel_no`='303'<br>UPDATE `med_hotel` SET `manifest` = '359' WHERE `code`='BPN8' and `med_hotel_no`='422'<br>UPDATE `med_hotel` SET `manifest` = '357' WHERE `code`='BPN9' and `med_hotel_no`='313'<br>UPDATE `med_hotel` SET `manifest` = '356' WHERE `code`='BPN13' and `med_hotel_no`='410'<br>UPDATE `med_hotel` SET `manifest` = '353' WHERE `code`='BPN14' and `med_hotel_no`='422'<br>UPDATE `med_hotel` SET `manifest` = '356' WHERE `code`='BPN15' and `med_hotel_no`='419'<br>UPDATE `med_hotel` SET `manifest` = '440' WHERE `code`='BTH5' and `med_hotel_no`='413'<br>UPDATE `med_hotel` SET `manifest` = '444' WHERE `code`='BTH6' and `med_hotel_no`='419'<br>UPDATE `med_hotel` SET `manifest` = '197' WHERE `code`='BTH7' and `med_hotel_no`='110'<br>UPDATE `med_hotel` SET `manifest` = '213' WHERE `code`='BTH7' and `med_hotel_no`='119'<br>UPDATE `med_hotel` SET `manifest` = '33' WHERE `code`='BTH7' and `med_hotel_no`='419'<br>UPDATE `med_hotel` SET `manifest` = '85' WHERE `code`='BTH10' and `med_hotel_no`='206'<br>UPDATE `med_hotel` SET `manifest` = '106' WHERE `code`='BTH10' and `med_hotel_no`='309'<br>UPDATE `med_hotel` SET `manifest` = '250' WHERE `code`='BTH10' and `med_hotel_no`='408'<br>UPDATE `med_hotel` SET `manifest` = '273' WHERE `code`='BTH11' and `med_hotel_no`='517'<br>UPDATE `med_hotel` SET `manifest` = '172' WHERE `code`='BTH11' and `med_hotel_no`='522'<br>UPDATE `med_hotel` SET `manifest` = '441' WHERE `code`='BTH13' and `med_hotel_no`='410'<br>UPDATE `med_hotel` SET `manifest` = '1' WHERE `code`='BTH16' and `med_hotel_no`='308'<br>UPDATE `med_hotel` SET `manifest` = '437' WHERE `code`='BTH16' and `med_hotel_no`='403'<br>UPDATE `med_hotel` SET `manifest` = '351' WHERE `code`='BTH18' and `med_hotel_no`='418'<br>UPDATE `med_hotel` SET `manifest` = '321' WHERE `code`='BTH25' and `med_hotel_no`='115'<br>UPDATE `med_hotel` SET `manifest` = '61' WHERE `code`='BTH25' and `med_hotel_no`='405'<br>UPDATE `med_hotel` SET `manifest` = '253' WHERE `code`='BTJ3' and `med_hotel_no`='422'<br>UPDATE `med_hotel` SET `manifest` = '139' WHERE `code`='BTJ3' and `med_hotel_no`='505'<br>UPDATE `med_hotel` SET `manifest` = '252' WHERE `code`='BTJ11' and `med_hotel_no`='422'<br>UPDATE `med_hotel` SET `manifest` = '141' WHERE `code`='BTJ11' and `med_hotel_no`='505'<br>UPDATE `med_hotel` SET `manifest` = '194' WHERE `code`='BTJ12' and `med_hotel_no`='208'<br>UPDATE `med_hotel` SET `manifest` = '197' WHERE `code`='BTJ12' and `med_hotel_no`='523'<br>UPDATE `med_hotel` SET `manifest` = '125' WHERE `code`='BTJ13' and `med_hotel_no`='403'<br>UPDATE `med_hotel` SET `manifest` = '261' WHERE `code`='BTJ13' and `med_hotel_no`='414'<br>UPDATE `med_hotel` SET `manifest` = '283' WHERE `code`='JKB3' and `med_hotel_no`='512'<br>UPDATE `med_hotel` SET `manifest` = '110' WHERE `code`='JKB3' and `med_hotel_no`='514'<br>UPDATE `med_hotel` SET `manifest` = '160' WHERE `code`='JKB4' and `med_hotel_no`='522'<br>UPDATE `med_hotel` SET `manifest` = '228' WHERE `code`='JKB4' and `med_hotel_no`='523'<br>UPDATE `med_hotel` SET `manifest` = '392' WHERE `code`='JKB11' and `med_hotel_no`='426'<br>UPDATE `med_hotel` SET `manifest` = '18' WHERE `code`='JKB13' and `med_hotel_no`='324'<br>UPDATE `med_hotel` SET `manifest` = '105' WHERE `code`='JKB13' and `med_hotel_no`='403'<br>UPDATE `med_hotel` SET `manifest` = '262' WHERE `code`='JKB13' and `med_hotel_no`='414'<br>UPDATE `med_hotel` SET `manifest` = '388' WHERE `code`='JKB14' and `med_hotel_no`='521'<br>UPDATE `med_hotel` SET `manifest` = '388' WHERE `code`='JKB23' and `med_hotel_no`='425'<br>UPDATE `med_hotel` SET `manifest` = '444' WHERE `code`='JKG3' and `med_hotel_no`='514'<br>UPDATE `med_hotel` SET `manifest` = '52' WHERE `code`='JKG4' and `med_hotel_no`='206'<br>UPDATE `med_hotel` SET `manifest` = '391' WHERE `code`='JKG4' and `med_hotel_no`='404'<br>UPDATE `med_hotel` SET `manifest` = '440' WHERE `code`='JKG5' and `med_hotel_no`='522'<br>UPDATE `med_hotel` SET `manifest` = '440' WHERE `code`='JKG6' and `med_hotel_no`='412'<br>UPDATE `med_hotel` SET `manifest` = '380' WHERE `code`='JKG9' and `med_hotel_no`='423'<br>UPDATE `med_hotel` SET `manifest` = '64' WHERE `code`='JKG9' and `med_hotel_no`='516'<br>UPDATE `med_hotel` SET `manifest` = '443' WHERE `code`='JKG10' and `med_hotel_no`='411'<br>UPDATE `med_hotel` SET `manifest` = '210' WHERE `code`='JKG15' and `med_hotel_no`='320'<br>UPDATE `med_hotel` SET `manifest` = '193' WHERE `code`='JKG15' and `med_hotel_no`='403'<br>UPDATE `med_hotel` SET `manifest` = '38' WHERE `code`='JKG15' and `med_hotel_no`='416'<br>UPDATE `med_hotel` SET `manifest` = '445' WHERE `code`='JKG16' and `med_hotel_no`='412'<br>UPDATE `med_hotel` SET `manifest` = '445' WHERE `code`='JKG17' and `med_hotel_no`='523'<br>UPDATE `med_hotel` SET `manifest` = '441' WHERE `code`='JKG19' and `med_hotel_no`='504'<br>UPDATE `med_hotel` SET `manifest` = '194' WHERE `code`='JKG20' and `med_hotel_no`='208'<br>UPDATE `med_hotel` SET `manifest` = '199' WHERE `code`='JKG20' and `med_hotel_no`='523'<br>UPDATE `med_hotel` SET `manifest` = '126' WHERE `code`='JKG21' and `med_hotel_no`='504'<br>UPDATE `med_hotel` SET `manifest` = '315' WHERE `code`='JKG21' and `med_hotel_no`='506'<br>UPDATE `med_hotel` SET `manifest` = '167' WHERE `code`='JKG23' and `med_hotel_no`='418'<br>UPDATE `med_hotel` SET `manifest` = '223' WHERE `code`='JKG23' and `med_hotel_no`='419'<br>UPDATE `med_hotel` SET `manifest` = '1' WHERE `code`='JKG26' and `med_hotel_no`='0'<br>UPDATE `med_hotel` SET `manifest` = '425' WHERE `code`='JKG26' and `med_hotel_no`='301'<br>UPDATE `med_hotel` SET `manifest` = '18' WHERE `code`='JKG26' and `med_hotel_no`='519'<br>UPDATE `med_hotel` SET `manifest` = '98' WHERE `code`='JKG30' and `med_hotel_no`='324'<br>UPDATE `med_hotel` SET `manifest` = '289' WHERE `code`='JKG30' and `med_hotel_no`='410'<br>UPDATE `med_hotel` SET `manifest` = '366' WHERE `code`='JKG32' and `med_hotel_no`='418'<br>UPDATE `med_hotel` SET `manifest` = '444' WHERE `code`='JKS5' and `med_hotel_no`='419'<br>UPDATE `med_hotel` SET `manifest` = '443' WHERE `code`='JKS6' and `med_hotel_no`='516'<br>UPDATE `med_hotel` SET `manifest` = '440' WHERE `code`='JKS8' and `med_hotel_no`='514'<br>UPDATE `med_hotel` SET `manifest` = '445' WHERE `code`='JKS11' and `med_hotel_no`='522'<br>UPDATE `med_hotel` SET `manifest` = '440' WHERE `code`='JKS15' and `med_hotel_no`='412'<br>UPDATE `med_hotel` SET `manifest` = '84' WHERE `code`='JKS17' and `med_hotel_no`='405'<br>UPDATE `med_hotel` SET `manifest` = '358' WHERE `code`='JKS17' and `med_hotel_no`='412'<br>UPDATE `med_hotel` SET `manifest` = '137' WHERE `code`='JKS28' and `med_hotel_no`='412'<br>UPDATE `med_hotel` SET `manifest` = '445' WHERE `code`='KJT2' and `med_hotel_no`='514'<br>UPDATE `med_hotel` SET `manifest` = '444' WHERE `code`='KJT8' and `med_hotel_no`='523'<br>UPDATE `med_hotel` SET `manifest` = '442' WHERE `code`='KJT10' and `med_hotel_no`='502'<br>UPDATE `med_hotel` SET `manifest` = '445' WHERE `code`='KJT12' and `med_hotel_no`='503'<br>UPDATE `med_hotel` SET `manifest` = '64' WHERE `code`='KJT16' and `med_hotel_no`='206'<br>UPDATE `med_hotel` SET `manifest` = '21' WHERE `code`='KJT16' and `med_hotel_no`='314'<br>UPDATE `med_hotel` SET `manifest` = '360' WHERE `code`='KJT16' and `med_hotel_no`='411'<br>UPDATE `med_hotel` SET `manifest` = '277' WHERE `code`='KJT17' and `med_hotel_no`='313'<br>UPDATE `med_hotel` SET `manifest` = '164' WHERE `code`='KJT17' and `med_hotel_no`='425'<br>UPDATE `med_hotel` SET `manifest` = '363' WHERE `code`='KJT19' and `med_hotel_no`='412'<br>UPDATE `med_hotel` SET `manifest` = '82' WHERE `code`='KJT19' and `med_hotel_no`='413'<br>UPDATE `med_hotel` SET `manifest` = '180' WHERE `code`='KJT20' and `med_hotel_no`='306'<br>UPDATE `med_hotel` SET `manifest` = '263' WHERE `code`='KJT20' and `med_hotel_no`='414'<br>UPDATE `med_hotel` SET `manifest` = '444' WHERE `code`='KJT22' and `med_hotel_no`='515'<br>UPDATE `med_hotel` SET `manifest` = '442' WHERE `code`='KJT28' and `med_hotel_no`='520'<br>UPDATE `med_hotel` SET `manifest` = '200' WHERE `code`='KJT31' and `med_hotel_no`='323'<br>UPDATE `med_hotel` SET `manifest` = '241' WHERE `code`='KJT31' and `med_hotel_no`='417'<br>UPDATE `med_hotel` SET `manifest` = '31' WHERE `code`='KJT32' and `med_hotel_no`='404'<br>UPDATE `med_hotel` SET `manifest` = '411' WHERE `code`='KJT32' and `med_hotel_no`='405'<br>UPDATE `med_hotel` SET `manifest` = '380' WHERE `code`='KJT33' and `med_hotel_no`='322'<br>UPDATE `med_hotel` SET `manifest` = '60' WHERE `code`='KJT33' and `med_hotel_no`='410'<br>UPDATE `med_hotel` SET `manifest` = '436' WHERE `code`='KJT35' and `med_hotel_no`='504'<br>UPDATE `med_hotel` SET `manifest` = '126' WHERE `code`='KJT37' and `med_hotel_no`='504'<br>UPDATE `med_hotel` SET `manifest` = '317' WHERE `code`='KJT37' and `med_hotel_no`='506'<br>UPDATE `med_hotel` SET `manifest` = '439' WHERE `code`='KJT38' and `med_hotel_no`='412'<br>UPDATE `med_hotel` SET `manifest` = '1' WHERE `code`='KJT40' and `med_hotel_no`='0'<br>UPDATE `med_hotel` SET `manifest` = '60' WHERE `code`='KJT40' and `med_hotel_no`='304'<br>UPDATE `med_hotel` SET `manifest` = '211' WHERE `code`='KJT40' and `med_hotel_no`='308'<br>UPDATE `med_hotel` SET `manifest` = '32' WHERE `code`='KJT40' and `med_hotel_no`='412'<br>UPDATE `med_hotel` SET `manifest` = '358' WHERE `code`='KNO5' and `med_hotel_no`='504'<br>UPDATE `med_hotel` SET `manifest` = '106' WHERE `code`='KNO9' and `med_hotel_no`='222'<br>UPDATE `med_hotel` SET `manifest` = '253' WHERE `code`='KNO9' and `med_hotel_no`='223'<br>UPDATE `med_hotel` SET `manifest` = '358' WHERE `code`='KNO12' and `med_hotel_no`='506'<br>UPDATE `med_hotel` SET `manifest` = '359' WHERE `code`='KNO13' and `med_hotel_no`='504'<br>UPDATE `med_hotel` SET `manifest` = '190' WHERE `code`='KNO15' and `med_hotel_no`='409'<br>UPDATE `med_hotel` SET `manifest` = '170' WHERE `code`='KNO15' and `med_hotel_no`='415'<br>UPDATE `med_hotel` SET `manifest` = '5' WHERE `code`='LOP5' and `med_hotel_no`='0'<br>UPDATE `med_hotel` SET `manifest` = '89' WHERE `code`='LOP5' and `med_hotel_no`='208'<br>UPDATE `med_hotel` SET `manifest` = '100' WHERE `code`='LOP5' and `med_hotel_no`='213'<br>UPDATE `med_hotel` SET `manifest` = '199' WHERE `code`='LOP5' and `med_hotel_no`='512'<br>UPDATE `med_hotel` SET `manifest` = '3' WHERE `code`='LOP9' and `med_hotel_no`='404'<br>UPDATE `med_hotel` SET `manifest` = '348' WHERE `code`='LOP9' and `med_hotel_no`='405'<br>UPDATE `med_hotel` SET `manifest` = '42' WHERE `code`='LOP9' and `med_hotel_no`='410'<br>UPDATE `med_hotel` SET `manifest` = '351' WHERE `code`='LOP14' and `med_hotel_no`='415'<br>UPDATE `med_hotel` SET `manifest` = '36' WHERE `code`='LOP14' and `med_hotel_no`='426'<br>UPDATE `med_hotel` SET `manifest` = '366' WHERE `code`='LOP15' and `med_hotel_no`='523'<br>UPDATE `med_hotel` SET `manifest` = '121' WHERE `code`='PDG3' and `med_hotel_no`='505'<br>UPDATE `med_hotel` SET `manifest` = '269' WHERE `code`='PDG3' and `med_hotel_no`='506'<br>UPDATE `med_hotel` SET `manifest` = '387' WHERE `code`='PDG4' and `med_hotel_no`='410'<br>UPDATE `med_hotel` SET `manifest` = '393' WHERE `code`='PDG5' and `med_hotel_no`='419'<br>UPDATE `med_hotel` SET `manifest` = '68' WHERE `code`='PDG6' and `med_hotel_no`='325'<br>UPDATE `med_hotel` SET `manifest` = '325' WHERE `code`='PDG6' and `med_hotel_no`='407'<br>UPDATE `med_hotel` SET `manifest` = '245' WHERE `code`='PDG9' and `med_hotel_no`='308'<br>UPDATE `med_hotel` SET `manifest` = '144' WHERE `code`='PDG9' and `med_hotel_no`='317'<br>UPDATE `med_hotel` SET `manifest` = '387' WHERE `code`='PDG12' and `med_hotel_no`='426'<br>UPDATE `med_hotel` SET `manifest` = '444' WHERE `code`='PLM3' and `med_hotel_no`='522'<br>UPDATE `med_hotel` SET `manifest` = '444' WHERE `code`='PLM8' and `med_hotel_no`='514'<br>UPDATE `med_hotel` SET `manifest` = '252' WHERE `code`='PLM9' and `med_hotel_no`='512'<br>UPDATE `med_hotel` SET `manifest` = '187' WHERE `code`='PLM9' and `med_hotel_no`='523'<br>UPDATE `med_hotel` SET `manifest` = '329' WHERE `code`='PLM16' and `med_hotel_no`='116'<br>UPDATE `med_hotel` SET `manifest` = '26' WHERE `code`='PLM16' and `med_hotel_no`='410'<br>UPDATE `med_hotel` SET `manifest` = '359' WHERE `code`='SOC8' and `med_hotel_no`='418'<br>UPDATE `med_hotel` SET `manifest` = '84' WHERE `code`='SOC10' and `med_hotel_no`='213'<br>UPDATE `med_hotel` SET `manifest` = '276' WHERE `code`='SOC10' and `med_hotel_no`='501'<br>UPDATE `med_hotel` SET `manifest` = '80' WHERE `code`='SOC12' and `med_hotel_no`='313'<br>UPDATE `med_hotel` SET `manifest` = '279' WHERE `code`='SOC12' and `med_hotel_no`='401'<br>UPDATE `med_hotel` SET `manifest` = '18' WHERE `code`='SOC14' and `med_hotel_no`='208'<br>UPDATE `med_hotel` SET `manifest` = '175' WHERE `code`='SOC14' and `med_hotel_no`='414'<br>UPDATE `med_hotel` SET `manifest` = '167' WHERE `code`='SOC14' and `med_hotel_no`='415'<br>UPDATE `med_hotel` SET `manifest` = '360' WHERE `code`='SOC16' and `med_hotel_no`='415'<br>UPDATE `med_hotel` SET `manifest` = '360' WHERE `code`='SOC18' and `med_hotel_no`='420'<br>UPDATE `med_hotel` SET `manifest` = '357' WHERE `code`='SOC19' and `med_hotel_no`='421'<br>UPDATE `med_hotel` SET `manifest` = '358' WHERE `code`='SOC20' and `med_hotel_no`='421'<br>UPDATE `med_hotel` SET `manifest` = '243' WHERE `code`='SOC22' and `med_hotel_no`='405'<br>UPDATE `med_hotel` SET `manifest` = '117' WHERE `code`='SOC22' and `med_hotel_no`='416'<br>UPDATE `med_hotel` SET `manifest` = '360' WHERE `code`='SOC33' and `med_hotel_no`='418'<br>UPDATE `med_hotel` SET `manifest` = '86' WHERE `code`='SOC34' and `med_hotel_no`='314'<br>UPDATE `med_hotel` SET `manifest` = '84' WHERE `code`='SOC34' and `med_hotel_no`='321'<br>UPDATE `med_hotel` SET `manifest` = '190' WHERE `code`='SOC34' and `med_hotel_no`='501'<br>UPDATE `med_hotel` SET `manifest` = '80' WHERE `code`='SOC35' and `med_hotel_no`='313'<br>UPDATE `med_hotel` SET `manifest` = '279' WHERE `code`='SOC35' and `med_hotel_no`='401'<br>UPDATE `med_hotel` SET `manifest` = '359' WHERE `code`='SOC39' and `med_hotel_no`='509'<br>UPDATE `med_hotel` SET `manifest` = '356' WHERE `code`='SOC40' and `med_hotel_no`='415'<br>UPDATE `med_hotel` SET `manifest` = '214' WHERE `code`='SOC41' and `med_hotel_no`='109'<br>UPDATE `med_hotel` SET `manifest` = '145' WHERE `code`='SOC41' and `med_hotel_no`='407'<br>UPDATE `med_hotel` SET `manifest` = '175' WHERE `code`='SOC42' and `med_hotel_no`='414'<br>UPDATE `med_hotel` SET `manifest` = '167' WHERE `code`='SOC42' and `med_hotel_no`='415'<br>UPDATE `med_hotel` SET `manifest` = '18' WHERE `code`='SOC42' and `med_hotel_no`='426'<br>UPDATE `med_hotel` SET `manifest` = '84' WHERE `code`='SOC43' and `med_hotel_no`='426'<br>UPDATE `med_hotel` SET `manifest` = '274' WHERE `code`='SOC43' and `med_hotel_no`='505'<br>UPDATE `med_hotel` SET `manifest` = '356' WHERE `code`='SOC44' and `med_hotel_no`='410'<br>UPDATE `med_hotel` SET `manifest` = '354' WHERE `code`='SOC46' and `med_hotel_no`='410'<br>UPDATE `med_hotel` SET `manifest` = '1' WHERE `code`='SOC46' and `med_hotel_no`='514'<br>UPDATE `med_hotel` SET `manifest` = '50' WHERE `code`='SOC47' and `med_hotel_no`='505'<br>UPDATE `med_hotel` SET `manifest` = '308' WHERE `code`='SOC47' and `med_hotel_no`='506'<br>UPDATE `med_hotel` SET `manifest` = '359' WHERE `code`='SOC48' and `med_hotel_no`='505'<br>UPDATE `med_hotel` SET `manifest` = '358' WHERE `code`='SOC50' and `med_hotel_no`='409'<br>UPDATE `med_hotel` SET `manifest` = '357' WHERE `code`='SOC52' and `med_hotel_no`='514'<br>UPDATE `med_hotel` SET `manifest` = '357' WHERE `code`='SOC53' and `med_hotel_no`='401'<br>UPDATE `med_hotel` SET `manifest` = '358' WHERE `code`='SOC55' and `med_hotel_no`='419'<br>UPDATE `med_hotel` SET `manifest` = '2' WHERE `code`='SOC57' and `med_hotel_no`='0'<br>UPDATE `med_hotel` SET `manifest` = '223' WHERE `code`='SOC57' and `med_hotel_no`='308'<br>UPDATE `med_hotel` SET `manifest` = '131' WHERE `code`='SOC57' and `med_hotel_no`='523'<br>UPDATE `med_hotel` SET `manifest` = '360' WHERE `code`='SOC61' and `med_hotel_no`='519'<br>UPDATE `med_hotel` SET `manifest` = '313' WHERE `code`='SOC64' and `med_hotel_no`='312'<br>UPDATE `med_hotel` SET `manifest` = '44' WHERE `code`='SOC64' and `med_hotel_no`='519'<br>UPDATE `med_hotel` SET `manifest` = '357' WHERE `code`='SOC67' and `med_hotel_no`='508'<br>UPDATE `med_hotel` SET `manifest` = '358' WHERE `code`='SOC72' and `med_hotel_no`='513'<br>UPDATE `med_hotel` SET `manifest` = '50' WHERE `code`='SOC73' and `med_hotel_no`='505'<br>UPDATE `med_hotel` SET `manifest` = '310' WHERE `code`='SOC73' and `med_hotel_no`='506'<br>UPDATE `med_hotel` SET `manifest` = '360' WHERE `code`='SOC74' and `med_hotel_no`='505'<br>UPDATE `med_hotel` SET `manifest` = '354' WHERE `code`='SOC75' and `med_hotel_no`='409'<br>UPDATE `med_hotel` SET `manifest` = '190' WHERE `code`='SOC77' and `med_hotel_no`='409'<br>UPDATE `med_hotel` SET `manifest` = '167' WHERE `code`='SOC77' and `med_hotel_no`='415'<br>UPDATE `med_hotel` SET `manifest` = '360' WHERE `code`='SOC78' and `med_hotel_no`='514'<br>UPDATE `med_hotel` SET `manifest` = '354' WHERE `code`='SOC80' and `med_hotel_no`='419'<br>UPDATE `med_hotel` SET `manifest` = '2' WHERE `code`='SOC81' and `med_hotel_no`='0'<br>UPDATE `med_hotel` SET `manifest` = '336' WHERE `code`='SOC81' and `med_hotel_no`='311'<br>UPDATE `med_hotel` SET `manifest` = '16' WHERE `code`='SOC81' and `med_hotel_no`='412'<br>UPDATE `med_hotel` SET `manifest` = '380' WHERE `code`='SUB2' and `med_hotel_no`='401'<br>UPDATE `med_hotel` SET `manifest` = '380' WHERE `code`='SUB4' and `med_hotel_no`='418'<br>UPDATE `med_hotel` SET `manifest` = '250' WHERE `code`='SUB8' and `med_hotel_no`='202'<br>UPDATE `med_hotel` SET `manifest` = '130' WHERE `code`='SUB8' and `med_hotel_no`='501'<br>UPDATE `med_hotel` SET `manifest` = '212' WHERE `code`='SUB9' and `med_hotel_no`='320'<br>UPDATE `med_hotel` SET `manifest` = '168' WHERE `code`='SUB9' and `med_hotel_no`='403'<br>UPDATE `med_hotel` SET `manifest` = '168' WHERE `code`='SUB12' and `med_hotel_no`='202'<br>UPDATE `med_hotel` SET `manifest` = '212' WHERE `code`='SUB12' and `med_hotel_no`='410'<br>UPDATE `med_hotel` SET `manifest` = '84' WHERE `code`='SUB17' and `med_hotel_no`='426'<br>UPDATE `med_hotel` SET `manifest` = '294' WHERE `code`='SUB17' and `med_hotel_no`='505'<br>UPDATE `med_hotel` SET `manifest` = '210' WHERE `code`='SUB19' and `med_hotel_no`='504'<br>UPDATE `med_hotel` SET `manifest` = '170' WHERE `code`='SUB19' and `med_hotel_no`='505'<br>UPDATE `med_hotel` SET `manifest` = '380' WHERE `code`='SUB20' and `med_hotel_no`='412'<br>UPDATE `med_hotel` SET `manifest` = '91' WHERE `code`='SUB21' and `med_hotel_no`='413'<br>UPDATE `med_hotel` SET `manifest` = '288' WHERE `code`='SUB21' and `med_hotel_no`='414'<br>UPDATE `med_hotel` SET `manifest` = '150' WHERE `code`='SUB24' and `med_hotel_no`='118'<br>UPDATE `med_hotel` SET `manifest` = '230' WHERE `code`='SUB24' and `med_hotel_no`='119'<br>UPDATE `med_hotel` SET `manifest` = '379' WHERE `code`='SUB25' and `med_hotel_no`='421'<br>UPDATE `med_hotel` SET `manifest` = '3' WHERE `code`='SUB27' and `med_hotel_no`='205'<br>UPDATE `med_hotel` SET `manifest` = '375' WHERE `code`='SUB27' and `med_hotel_no`='516'<br>UPDATE `med_hotel` SET `manifest` = '310' WHERE `code`='SUB28' and `med_hotel_no`='325'<br>UPDATE `med_hotel` SET `manifest` = '68' WHERE `code`='SUB28' and `med_hotel_no`='407'<br>UPDATE `med_hotel` SET `manifest` = '259' WHERE `code`='SUB31' and `med_hotel_no`='115'<br>UPDATE `med_hotel` SET `manifest` = '120' WHERE `code`='SUB31' and `med_hotel_no`='416'<br>UPDATE `med_hotel` SET `manifest` = '380' WHERE `code`='SUB37' and `med_hotel_no`='401'<br>UPDATE `med_hotel` SET `manifest` = '380' WHERE `code`='SUB38' and `med_hotel_no`='418'<br>UPDATE `med_hotel` SET `manifest` = '130' WHERE `code`='SUB41' and `med_hotel_no`='501'<br>UPDATE `med_hotel` SET `manifest` = '250' WHERE `code`='SUB41' and `med_hotel_no`='511'<br>UPDATE `med_hotel` SET `manifest` = '380' WHERE `code`='SUB42' and `med_hotel_no`='404'<br>UPDATE `med_hotel` SET `manifest` = '102' WHERE `code`='SUB45' and `med_hotel_no`='317'<br>UPDATE `med_hotel` SET `manifest` = '278' WHERE `code`='SUB45' and `med_hotel_no`='522'<br>UPDATE `med_hotel` SET `manifest` = '168' WHERE `code`='SUB46' and `med_hotel_no`='217'<br>UPDATE `med_hotel` SET `manifest` = '212' WHERE `code`='SUB46' and `med_hotel_no`='410'<br>UPDATE `med_hotel` SET `manifest` = '168' WHERE `code`='SUB49' and `med_hotel_no`='407'<br>UPDATE `med_hotel` SET `manifest` = '209' WHERE `code`='SUB49' and `med_hotel_no`='425'<br>UPDATE `med_hotel` SET `manifest` = '379' WHERE `code`='SUB50' and `med_hotel_no`='509'<br>UPDATE `med_hotel` SET `manifest` = '380' WHERE `code`='SUB53' and `med_hotel_no`='507'<br>UPDATE `med_hotel` SET `manifest` = '212' WHERE `code`='SUB54' and `med_hotel_no`='407'<br>UPDATE `med_hotel` SET `manifest` = '168' WHERE `code`='SUB54' and `med_hotel_no`='425'<br>UPDATE `med_hotel` SET `manifest` = '380' WHERE `code`='SUB55' and `med_hotel_no`='413'<br>UPDATE `med_hotel` SET `manifest` = '3' WHERE `code`='SUB56' and `med_hotel_no`='0'<br>UPDATE `med_hotel` SET `manifest` = '206' WHERE `code`='SUB56' and `med_hotel_no`='504'<br>UPDATE `med_hotel` SET `manifest` = '169' WHERE `code`='SUB56' and `med_hotel_no`='505'<br>UPDATE `med_hotel` SET `manifest` = '378' WHERE `code`='SUB57' and `med_hotel_no`='512'<br>UPDATE `med_hotel` SET `manifest` = '380' WHERE `code`='SUB60' and `med_hotel_no`='322'<br>UPDATE `med_hotel` SET `manifest` = '338' WHERE `code`='SUB62' and `med_hotel_no`='324'<br>UPDATE `med_hotel` SET `manifest` = '1' WHERE `code`='SUB62' and `med_hotel_no`='414'<br>UPDATE `med_hotel` SET `manifest` = '40' WHERE `code`='SUB62' and `med_hotel_no`='426'<br>UPDATE `med_hotel` SET `manifest` = '379' WHERE `code`='SUB65' and `med_hotel_no`='413'<br>UPDATE `med_hotel` SET `manifest` = '105' WHERE `code`='SUB68' and `med_hotel_no`='512'<br>UPDATE `med_hotel` SET `manifest` = '273' WHERE `code`='SUB68' and `med_hotel_no`='514'<br>UPDATE `med_hotel` SET `manifest` = '1' WHERE `code`='SUB71' and `med_hotel_no`='210'<br>UPDATE `med_hotel` SET `manifest` = '376' WHERE `code`='SUB71' and `med_hotel_no`='419'<br>UPDATE `med_hotel` SET `manifest` = '323' WHERE `code`='SUB73' and `med_hotel_no`='207'<br>UPDATE `med_hotel` SET `manifest` = '54' WHERE `code`='SUB73' and `med_hotel_no`='418'<br>UPDATE `med_hotel` SET `manifest` = '378' WHERE `code`='SUB74' and `med_hotel_no`='501'<br>UPDATE `med_hotel` SET `manifest` = '40' WHERE `code`='SUB77' and `med_hotel_no`='501'<br>UPDATE `med_hotel` SET `manifest` = '337' WHERE `code`='SUB77' and `med_hotel_no`='507'<br>UPDATE `med_hotel` SET `manifest` = '380' WHERE `code`='SUB85' and `med_hotel_no`='510'<br>UPDATE `med_hotel` SET `manifest` = '378' WHERE `code`='SUB90' and `med_hotel_no`='508'<br>UPDATE `med_hotel` SET `manifest` = '378' WHERE `code`='SUB92' and `med_hotel_no`='512'<br>UPDATE `med_hotel` SET `manifest` = '155' WHERE `code`='SUB96' and `med_hotel_no`='511'<br>UPDATE `med_hotel` SET `manifest` = '221' WHERE `code`='SUB96' and `med_hotel_no`='515'<br>UPDATE `med_hotel` SET `manifest` = '378' WHERE `code`='SUB99' and `med_hotel_no`='413'<br>UPDATE `med_hotel` SET `manifest` = '105' WHERE `code`='SUB104' and `med_hotel_no`='512'<br>UPDATE `med_hotel` SET `manifest` = '269' WHERE `code`='SUB104' and `med_hotel_no`='514'<br>UPDATE `med_hotel` SET `manifest` = '379' WHERE `code`='SUB106' and `med_hotel_no`='419'<br>UPDATE `med_hotel` SET `manifest` = '376' WHERE `code`='SUB109' and `med_hotel_no`='501'<br>UPDATE `med_hotel` SET `manifest` = '340' WHERE `code`='SUB113' and `med_hotel_no`='426'<br>UPDATE `med_hotel` SET `manifest` = '39' WHERE `code`='SUB113' and `med_hotel_no`='501'<br>UPDATE `med_hotel` SET `manifest` = '393' WHERE `code`='UPG2' and `med_hotel_no`='507'<br>UPDATE `med_hotel` SET `manifest` = '125' WHERE `code`='UPG5' and `med_hotel_no`='404'<br>UPDATE `med_hotel` SET `manifest` = '268' WHERE `code`='UPG5' and `med_hotel_no`='405'<br>UPDATE `med_hotel` SET `manifest` = '11' WHERE `code`='UPG6' and `med_hotel_no`='324'<br>UPDATE `med_hotel` SET `manifest` = '382' WHERE `code`='UPG6' and `med_hotel_no`='403'<br>UPDATE `med_hotel` SET `manifest` = '393' WHERE `code`='UPG8' and `med_hotel_no`='426'<br>UPDATE `med_hotel` SET `manifest` = '392' WHERE `code`='UPG9' and `med_hotel_no`='102'<br>UPDATE `med_hotel` SET `manifest` = '393' WHERE `code`='UPG13' and `med_hotel_no`='416'<br>UPDATE `med_hotel` SET `manifest` = '36' WHERE `code`='UPG18' and `med_hotel_no`='324'<br>UPDATE `med_hotel` SET `manifest` = '357' WHERE `code`='UPG18' and `med_hotel_no`='403'<br>UPDATE `med_hotel` SET `manifest` = '126' WHERE `code`='UPG19' and `med_hotel_no`='505'<br>UPDATE `med_hotel` SET `manifest` = '264' WHERE `code`='UPG19' and `med_hotel_no`='506'<br>UPDATE `med_hotel` SET `manifest` = '8' WHERE `code`='UPG21' and `med_hotel_no`='0'<br>UPDATE `med_hotel` SET `manifest` = '47' WHERE `code`='UPG21' and `med_hotel_no`='201'<br>UPDATE `med_hotel` SET `manifest` = '147' WHERE `code`='UPG21' and `med_hotel_no`='507'<br>UPDATE `med_hotel` SET `manifest` = '189' WHERE `code`='UPG21' and `med_hotel_no`='512'<br>UPDATE `med_hotel` SET `manifest` = '393' WHERE `code`='UPG26' and `med_hotel_no`='425'<br>UPDATE `med_hotel` SET `manifest` = '1' WHERE `code`='UPG27' and `med_hotel_no`='0'<br>UPDATE `med_hotel` SET `manifest` = '100' WHERE `code`='UPG27' and `med_hotel_no`='306'<br>UPDATE `med_hotel` SET `manifest` = '290' WHERE `code`='UPG27' and `med_hotel_no`='401'<br>UPDATE `med_hotel` SET `manifest` = '391' WHERE `code`='UPG36' and `med_hotel_no`='403'<br>UPDATE `med_hotel` SET `manifest` = '35' WHERE `code`='UPG37' and `med_hotel_no`='318'<br>UPDATE `med_hotel` SET `manifest` = '357' WHERE `code`='UPG37' and `med_hotel_no`='415'<br>UPDATE `med_hotel` SET `manifest` = '101' WHERE `code`='UPG39' and `med_hotel_no`='306'<br>UPDATE `med_hotel` SET `manifest` = '289' WHERE `code`='UPG39' and `med_hotel_no`='401'<br>UPDATE `med_hotel` SET `manifest` = '168' WHERE `code`='UPG42' and `med_hotel_no`='418'<br>UPDATE `med_hotel` SET `manifest` = '221' WHERE `code`='UPG42' and `med_hotel_no`='419'<br>UPDATE `med_hotel` SET `manifest` = '209' WHERE `code`='UPG43' and `med_hotel_no`='304'<br>UPDATE `med_hotel` SET `manifest` = '36' WHERE `code`='UPG43' and `med_hotel_no`='412'<br>UPDATE `med_hotel` SET `manifest` = '355' WHERE `code`='YIA5' and `med_hotel_no`='102'<br>UPDATE `med_hotel` SET `manifest` = '4' WHERE `code`='YIA5' and `med_hotel_no`='405'<br>UPDATE `med_hotel` SET `manifest` = '360' WHERE `code`='YIA10' and `med_hotel_no`='424'<br>UPDATE `med_hotel` SET `manifest` = '357' WHERE `code`='YIA13' and `med_hotel_no`='514'<br>UPDATE `med_hotel` SET `manifest` = '164' WHERE `code`='YIA15' and `med_hotel_no`='425'<br>UPDATE `med_hotel` SET `manifest` = '194' WHERE `code`='YIA15' and `med_hotel_no`='507'<br>UPDATE `med_hotel` SET `manifest` = '359' WHERE `code`='YIA16' and `med_hotel_no`='519'<br>UPDATE `med_hotel` SET `manifest` = '90' WHERE `code`='YIA17' and `med_hotel_no`='301'<br>UPDATE `med_hotel` SET `manifest` = '265' WHERE `code`='YIA17' and `med_hotel_no`='520'<br>UPDATE `med_hotel` SET `manifest` = '202' WHERE `code`='YIA19' and `med_hotel_no`='215'<br>UPDATE `med_hotel` SET `manifest` = '156' WHERE `code`='YIA19' and `med_hotel_no`='515'<br>UPDATE `med_hotel` SET `manifest` = '160' WHERE `code`='YIA21' and `med_hotel_no`='413'<br>UPDATE `med_hotel` SET `manifest` = '195' WHERE `code`='YIA21' and `med_hotel_no`='414'<br>UPDATE `med_hotel` SET `manifest` = '357' WHERE `code`='YIA22' and `med_hotel_no`='514'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='BDJ6' and med_hotel_no='511'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='BPN1' and med_hotel_no='425'<br>UPDATE `med_hotel` SET `wafat` = '2' WHERE `code`='BTH5' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='BTH10' and med_hotel_no='309'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='BTH10' and med_hotel_no='408'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='BTJ11' and med_hotel_no='422'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='JKB14' and med_hotel_no='521'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='JKG5' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='JKG9' and med_hotel_no='423'<br>UPDATE `med_hotel` SET `wafat` = '2' WHERE `code`='JKG15' and med_hotel_no='320'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='JKG15' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='JKG16' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='JKG17' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='JKG19' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='JKS5' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `wafat` = '2' WHERE `code`='JKS8' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='JKS11' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='KJT10' and med_hotel_no='502'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='KJT12' and med_hotel_no='503'<br>UPDATE `med_hotel` SET `wafat` = '2' WHERE `code`='KJT19' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `wafat` = '2' WHERE `code`='KJT20' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `wafat` = '2' WHERE `code`='KJT28' and med_hotel_no='520'<br>UPDATE `med_hotel` SET `wafat` = '2' WHERE `code`='KNO5' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='KNO9' and med_hotel_no='223'<br>UPDATE `med_hotel` SET `wafat` = '2' WHERE `code`='LOP9' and med_hotel_no='405'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='LOP9' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='PDG3' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `wafat` = '2' WHERE `code`='PDG4' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `wafat` = '2' WHERE `code`='PLM9' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='SOC8' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='SOC10' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='SOC12' and med_hotel_no='313'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='SOC12' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='SOC16' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='SOC19' and med_hotel_no='421'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='SOC22' and med_hotel_no='405'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='SOC52' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='SOC61' and med_hotel_no='519'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='SOC67' and med_hotel_no='508'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='SUB8' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='SUB20' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='SUB28' and med_hotel_no='325'<br>UPDATE `med_hotel` SET `wafat` = '2' WHERE `code`='SUB31' and med_hotel_no='416'<br>UPDATE `med_hotel` SET `wafat` = '2' WHERE `code`='SUB37' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `wafat` = '2' WHERE `code`='SUB38' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='SUB41' and med_hotel_no='511'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='SUB55' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='SUB65' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='UPG2' and med_hotel_no='507'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='UPG5' and med_hotel_no='404'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='UPG8' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='UPG13' and med_hotel_no='416'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='UPG18' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='UPG19' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='YIA5' and med_hotel_no='102'<br>UPDATE `med_hotel` SET `j_L` = '168' WHERE `code`='BDJ2' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `j_P` = '192' WHERE `code`='BDJ2' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `j_L` = '2' WHERE `code`='BDJ3' and med_hotel_no='206'<br>UPDATE `med_hotel` SET `j_P` = '3' WHERE `code`='BDJ3' and med_hotel_no='206'<br>UPDATE `med_hotel` SET `j_L` = '150' WHERE `code`='BDJ3' and med_hotel_no='420'<br>UPDATE `med_hotel` SET `j_P` = '203' WHERE `code`='BDJ3' and med_hotel_no='420'<br>UPDATE `med_hotel` SET `j_L` = '159' WHERE `code`='BDJ4' and med_hotel_no='421'<br>UPDATE `med_hotel` SET `j_P` = '201' WHERE `code`='BDJ4' and med_hotel_no='421'<br>UPDATE `med_hotel` SET `j_L` = '2' WHERE `code`='BDJ6' and med_hotel_no='223'<br>UPDATE `med_hotel` SET `j_P` = '9' WHERE `code`='BDJ6' and med_hotel_no='223'<br>UPDATE `med_hotel` SET `j_L` = '127' WHERE `code`='BDJ6' and med_hotel_no='511'<br>UPDATE `med_hotel` SET `j_P` = '143' WHERE `code`='BDJ6' and med_hotel_no='511'<br>UPDATE `med_hotel` SET `j_L` = '38' WHERE `code`='BDJ6' and med_hotel_no='518'<br>UPDATE `med_hotel` SET `j_P` = '41' WHERE `code`='BDJ6' and med_hotel_no='518'<br>UPDATE `med_hotel` SET `j_L` = '149' WHERE `code`='BDJ8' and med_hotel_no='406'<br>UPDATE `med_hotel` SET `j_P` = '211' WHERE `code`='BDJ8' and med_hotel_no='406'<br>UPDATE `med_hotel` SET `j_L` = '68' WHERE `code`='BDJ10' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `j_P` = '92' WHERE `code`='BDJ10' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `j_L` = '83' WHERE `code`='BDJ10' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `j_P` = '117' WHERE `code`='BDJ10' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `j_L` = '154' WHERE `code`='BDJ11' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `j_P` = '200' WHERE `code`='BDJ11' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `j_L` = '158' WHERE `code`='BDJ13' and med_hotel_no='521'<br>UPDATE `med_hotel` SET `j_P` = '202' WHERE `code`='BDJ13' and med_hotel_no='521'<br>UPDATE `med_hotel` SET `j_L` = '163' WHERE `code`='BDJ17' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `j_P` = '195' WHERE `code`='BDJ17' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `j_L` = '146' WHERE `code`='BDJ19' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `j_P` = '201' WHERE `code`='BDJ19' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `j_L` = '83' WHERE `code`='BPN1' and med_hotel_no='306'<br>UPDATE `med_hotel` SET `j_P` = '96' WHERE `code`='BPN1' and med_hotel_no='306'<br>UPDATE `med_hotel` SET `j_L` = '70' WHERE `code`='BPN1' and med_hotel_no='425'<br>UPDATE `med_hotel` SET `j_P` = '110' WHERE `code`='BPN1' and med_hotel_no='425'<br>UPDATE `med_hotel` SET `j_L` = '14' WHERE `code`='BPN4' and med_hotel_no='206'<br>UPDATE `med_hotel` SET `j_P` = '18' WHERE `code`='BPN4' and med_hotel_no='206'<br>UPDATE `med_hotel` SET `j_L` = '63' WHERE `code`='BPN4' and med_hotel_no='325'<br>UPDATE `med_hotel` SET `j_P` = '94' WHERE `code`='BPN4' and med_hotel_no='325'<br>UPDATE `med_hotel` SET `j_L` = '70' WHERE `code`='BPN4' and med_hotel_no='411'<br>UPDATE `med_hotel` SET `j_P` = '99' WHERE `code`='BPN4' and med_hotel_no='411'<br>UPDATE `med_hotel` SET `j_P` = '1' WHERE `code`='BPN8' and med_hotel_no='303'<br>UPDATE `med_hotel` SET `j_L` = '130' WHERE `code`='BPN8' and med_hotel_no='422'<br>UPDATE `med_hotel` SET `j_P` = '229' WHERE `code`='BPN8' and med_hotel_no='422'<br>UPDATE `med_hotel` SET `j_L` = '140' WHERE `code`='BPN9' and med_hotel_no='313'<br>UPDATE `med_hotel` SET `j_P` = '217' WHERE `code`='BPN9' and med_hotel_no='313'<br>UPDATE `med_hotel` SET `j_L` = '115' WHERE `code`='BPN13' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `j_P` = '241' WHERE `code`='BPN13' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `j_L` = '142' WHERE `code`='BPN14' and med_hotel_no='422'<br>UPDATE `med_hotel` SET `j_P` = '211' WHERE `code`='BPN14' and med_hotel_no='422'<br>UPDATE `med_hotel` SET `j_L` = '150' WHERE `code`='BPN15' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `j_P` = '206' WHERE `code`='BPN15' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `j_L` = '207' WHERE `code`='BTH5' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `j_P` = '233' WHERE `code`='BTH5' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `j_L` = '187' WHERE `code`='BTH6' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `j_P` = '257' WHERE `code`='BTH6' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `j_L` = '85' WHERE `code`='BTH7' and med_hotel_no='110'<br>UPDATE `med_hotel` SET `j_P` = '112' WHERE `code`='BTH7' and med_hotel_no='110'<br>UPDATE `med_hotel` SET `j_L` = '92' WHERE `code`='BTH7' and med_hotel_no='119'<br>UPDATE `med_hotel` SET `j_P` = '121' WHERE `code`='BTH7' and med_hotel_no='119'<br>UPDATE `med_hotel` SET `j_L` = '17' WHERE `code`='BTH7' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `j_P` = '16' WHERE `code`='BTH7' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `j_L` = '37' WHERE `code`='BTH10' and med_hotel_no='206'<br>UPDATE `med_hotel` SET `j_P` = '48' WHERE `code`='BTH10' and med_hotel_no='206'<br>UPDATE `med_hotel` SET `j_L` = '48' WHERE `code`='BTH10' and med_hotel_no='309'<br>UPDATE `med_hotel` SET `j_P` = '58' WHERE `code`='BTH10' and med_hotel_no='309'<br>UPDATE `med_hotel` SET `j_L` = '116' WHERE `code`='BTH10' and med_hotel_no='408'<br>UPDATE `med_hotel` SET `j_P` = '134' WHERE `code`='BTH10' and med_hotel_no='408'<br>UPDATE `med_hotel` SET `j_L` = '126' WHERE `code`='BTH11' and med_hotel_no='517'<br>UPDATE `med_hotel` SET `j_P` = '147' WHERE `code`='BTH11' and med_hotel_no='517'<br>UPDATE `med_hotel` SET `j_L` = '79' WHERE `code`='BTH11' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `j_P` = '93' WHERE `code`='BTH11' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `j_L` = '194' WHERE `code`='BTH13' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `j_P` = '247' WHERE `code`='BTH13' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `j_L` = '1' WHERE `code`='BTH16' and med_hotel_no='308'<br>UPDATE `med_hotel` SET `j_L` = '203' WHERE `code`='BTH16' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `j_P` = '234' WHERE `code`='BTH16' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `j_L` = '164' WHERE `code`='BTH18' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `j_P` = '187' WHERE `code`='BTH18' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `j_L` = '139' WHERE `code`='BTH25' and med_hotel_no='115'<br>UPDATE `med_hotel` SET `j_P` = '182' WHERE `code`='BTH25' and med_hotel_no='115'<br>UPDATE `med_hotel` SET `j_L` = '30' WHERE `code`='BTH25' and med_hotel_no='405'<br>UPDATE `med_hotel` SET `j_P` = '31' WHERE `code`='BTH25' and med_hotel_no='405'<br>UPDATE `med_hotel` SET `j_L` = '100' WHERE `code`='BTJ3' and med_hotel_no='422'<br>UPDATE `med_hotel` SET `j_P` = '153' WHERE `code`='BTJ3' and med_hotel_no='422'<br>UPDATE `med_hotel` SET `j_L` = '57' WHERE `code`='BTJ3' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `j_P` = '82' WHERE `code`='BTJ3' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `j_L` = '113' WHERE `code`='BTJ11' and med_hotel_no='422'<br>UPDATE `med_hotel` SET `j_P` = '139' WHERE `code`='BTJ11' and med_hotel_no='422'<br>UPDATE `med_hotel` SET `j_L` = '53' WHERE `code`='BTJ11' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `j_P` = '88' WHERE `code`='BTJ11' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `j_L` = '76' WHERE `code`='BTJ12' and med_hotel_no='208'<br>UPDATE `med_hotel` SET `j_P` = '118' WHERE `code`='BTJ12' and med_hotel_no='208'<br>UPDATE `med_hotel` SET `j_L` = '79' WHERE `code`='BTJ12' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `j_P` = '118' WHERE `code`='BTJ12' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `j_L` = '43' WHERE `code`='BTJ13' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `j_P` = '82' WHERE `code`='BTJ13' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `j_L` = '97' WHERE `code`='BTJ13' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `j_P` = '164' WHERE `code`='BTJ13' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `j_L` = '125' WHERE `code`='JKB3' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `j_P` = '158' WHERE `code`='JKB3' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `j_L` = '48' WHERE `code`='JKB3' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `j_P` = '62' WHERE `code`='JKB3' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `j_L` = '73' WHERE `code`='JKB4' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `j_P` = '87' WHERE `code`='JKB4' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `j_L` = '101' WHERE `code`='JKB4' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `j_P` = '127' WHERE `code`='JKB4' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `j_L` = '190' WHERE `code`='JKB11' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `j_P` = '202' WHERE `code`='JKB11' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `j_L` = '6' WHERE `code`='JKB13' and med_hotel_no='324'<br>UPDATE `med_hotel` SET `j_P` = '12' WHERE `code`='JKB13' and med_hotel_no='324'<br>UPDATE `med_hotel` SET `j_L` = '45' WHERE `code`='JKB13' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `j_P` = '60' WHERE `code`='JKB13' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `j_L` = '118' WHERE `code`='JKB13' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `j_P` = '144' WHERE `code`='JKB13' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `j_L` = '179' WHERE `code`='JKB14' and med_hotel_no='521'<br>UPDATE `med_hotel` SET `j_P` = '209' WHERE `code`='JKB14' and med_hotel_no='521'<br>UPDATE `med_hotel` SET `j_L` = '173' WHERE `code`='JKB23' and med_hotel_no='425'<br>UPDATE `med_hotel` SET `j_P` = '215' WHERE `code`='JKB23' and med_hotel_no='425'<br>UPDATE `med_hotel` SET `j_L` = '183' WHERE `code`='JKG3' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `j_P` = '261' WHERE `code`='JKG3' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `j_L` = '18' WHERE `code`='JKG4' and med_hotel_no='206'<br>UPDATE `med_hotel` SET `j_P` = '34' WHERE `code`='JKG4' and med_hotel_no='206'<br>UPDATE `med_hotel` SET `j_L` = '158' WHERE `code`='JKG4' and med_hotel_no='404'<br>UPDATE `med_hotel` SET `j_P` = '233' WHERE `code`='JKG4' and med_hotel_no='404'<br>UPDATE `med_hotel` SET `j_L` = '190' WHERE `code`='JKG5' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `j_P` = '250' WHERE `code`='JKG5' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `j_L` = '187' WHERE `code`='JKG6' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `j_P` = '253' WHERE `code`='JKG6' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `j_L` = '182' WHERE `code`='JKG9' and med_hotel_no='423'<br>UPDATE `med_hotel` SET `j_P` = '198' WHERE `code`='JKG9' and med_hotel_no='423'<br>UPDATE `med_hotel` SET `j_L` = '26' WHERE `code`='JKG9' and med_hotel_no='516'<br>UPDATE `med_hotel` SET `j_P` = '38' WHERE `code`='JKG9' and med_hotel_no='516'<br>UPDATE `med_hotel` SET `j_L` = '209' WHERE `code`='JKG10' and med_hotel_no='411'<br>UPDATE `med_hotel` SET `j_P` = '234' WHERE `code`='JKG10' and med_hotel_no='411'<br>UPDATE `med_hotel` SET `j_L` = '93' WHERE `code`='JKG15' and med_hotel_no='320'<br>UPDATE `med_hotel` SET `j_P` = '117' WHERE `code`='JKG15' and med_hotel_no='320'<br>UPDATE `med_hotel` SET `j_L` = '93' WHERE `code`='JKG15' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `j_P` = '100' WHERE `code`='JKG15' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `j_L` = '18' WHERE `code`='JKG15' and med_hotel_no='416'<br>UPDATE `med_hotel` SET `j_P` = '20' WHERE `code`='JKG15' and med_hotel_no='416'<br>UPDATE `med_hotel` SET `j_L` = '208' WHERE `code`='JKG16' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `j_P` = '237' WHERE `code`='JKG16' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `j_L` = '204' WHERE `code`='JKG17' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `j_P` = '241' WHERE `code`='JKG17' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `j_L` = '208' WHERE `code`='JKG19' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `j_P` = '233' WHERE `code`='JKG19' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `j_L` = '85' WHERE `code`='JKG20' and med_hotel_no='208'<br>UPDATE `med_hotel` SET `j_P` = '109' WHERE `code`='JKG20' and med_hotel_no='208'<br>UPDATE `med_hotel` SET `j_L` = '87' WHERE `code`='JKG20' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `j_P` = '112' WHERE `code`='JKG20' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `j_L` = '61' WHERE `code`='JKG21' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `j_P` = '65' WHERE `code`='JKG21' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `j_L` = '133' WHERE `code`='JKG21' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `j_P` = '182' WHERE `code`='JKG21' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `j_L` = '75' WHERE `code`='JKG23' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `j_P` = '92' WHERE `code`='JKG23' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `j_L` = '93' WHERE `code`='JKG23' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `j_P` = '130' WHERE `code`='JKG23' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `j_P` = '1' WHERE `code`='JKG26' and med_hotel_no='0'<br>UPDATE `med_hotel` SET `j_L` = '191' WHERE `code`='JKG26' and med_hotel_no='301'<br>UPDATE `med_hotel` SET `j_P` = '234' WHERE `code`='JKG26' and med_hotel_no='301'<br>UPDATE `med_hotel` SET `j_L` = '8' WHERE `code`='JKG26' and med_hotel_no='519'<br>UPDATE `med_hotel` SET `j_P` = '10' WHERE `code`='JKG26' and med_hotel_no='519'<br>UPDATE `med_hotel` SET `j_L` = '45' WHERE `code`='JKG30' and med_hotel_no='324'<br>UPDATE `med_hotel` SET `j_P` = '53' WHERE `code`='JKG30' and med_hotel_no='324'<br>UPDATE `med_hotel` SET `j_L` = '129' WHERE `code`='JKG30' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `j_P` = '160' WHERE `code`='JKG30' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `j_L` = '146' WHERE `code`='JKG32' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `j_P` = '220' WHERE `code`='JKG32' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `j_L` = '192' WHERE `code`='JKS5' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `j_P` = '252' WHERE `code`='JKS5' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `j_L` = '196' WHERE `code`='JKS6' and med_hotel_no='516'<br>UPDATE `med_hotel` SET `j_P` = '247' WHERE `code`='JKS6' and med_hotel_no='516'<br>UPDATE `med_hotel` SET `j_L` = '184' WHERE `code`='JKS8' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `j_P` = '256' WHERE `code`='JKS8' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `j_L` = '193' WHERE `code`='JKS11' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `j_P` = '252' WHERE `code`='JKS11' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `j_L` = '210' WHERE `code`='JKS15' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `j_P` = '230' WHERE `code`='JKS15' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `j_L` = '34' WHERE `code`='JKS17' and med_hotel_no='405'<br>UPDATE `med_hotel` SET `j_P` = '50' WHERE `code`='JKS17' and med_hotel_no='405'<br>UPDATE `med_hotel` SET `j_L` = '154' WHERE `code`='JKS17' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `j_P` = '204' WHERE `code`='JKS17' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `j_L` = '64' WHERE `code`='JKS28' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `j_P` = '73' WHERE `code`='JKS28' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `j_L` = '190' WHERE `code`='KJT2' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `j_P` = '255' WHERE `code`='KJT2' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `j_L` = '207' WHERE `code`='KJT8' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `j_P` = '237' WHERE `code`='KJT8' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `j_L` = '192' WHERE `code`='KJT10' and med_hotel_no='502'<br>UPDATE `med_hotel` SET `j_P` = '250' WHERE `code`='KJT10' and med_hotel_no='502'<br>UPDATE `med_hotel` SET `j_L` = '218' WHERE `code`='KJT12' and med_hotel_no='503'<br>UPDATE `med_hotel` SET `j_P` = '227' WHERE `code`='KJT12' and med_hotel_no='503'<br>UPDATE `med_hotel` SET `j_L` = '36' WHERE `code`='KJT16' and med_hotel_no='206'<br>UPDATE `med_hotel` SET `j_P` = '28' WHERE `code`='KJT16' and med_hotel_no='206'<br>UPDATE `med_hotel` SET `j_L` = '9' WHERE `code`='KJT16' and med_hotel_no='314'<br>UPDATE `med_hotel` SET `j_P` = '12' WHERE `code`='KJT16' and med_hotel_no='314'<br>UPDATE `med_hotel` SET `j_L` = '162' WHERE `code`='KJT16' and med_hotel_no='411'<br>UPDATE `med_hotel` SET `j_P` = '198' WHERE `code`='KJT16' and med_hotel_no='411'<br>UPDATE `med_hotel` SET `j_L` = '126' WHERE `code`='KJT17' and med_hotel_no='313'<br>UPDATE `med_hotel` SET `j_P` = '151' WHERE `code`='KJT17' and med_hotel_no='313'<br>UPDATE `med_hotel` SET `j_L` = '77' WHERE `code`='KJT17' and med_hotel_no='425'<br>UPDATE `med_hotel` SET `j_P` = '87' WHERE `code`='KJT17' and med_hotel_no='425'<br>UPDATE `med_hotel` SET `j_L` = '156' WHERE `code`='KJT19' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `j_P` = '207' WHERE `code`='KJT19' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `j_L` = '34' WHERE `code`='KJT19' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `j_P` = '48' WHERE `code`='KJT19' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `j_L` = '81' WHERE `code`='KJT20' and med_hotel_no='306'<br>UPDATE `med_hotel` SET `j_P` = '99' WHERE `code`='KJT20' and med_hotel_no='306'<br>UPDATE `med_hotel` SET `j_L` = '118' WHERE `code`='KJT20' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `j_P` = '145' WHERE `code`='KJT20' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `j_L` = '201' WHERE `code`='KJT22' and med_hotel_no='515'<br>UPDATE `med_hotel` SET `j_P` = '243' WHERE `code`='KJT22' and med_hotel_no='515'<br>UPDATE `med_hotel` SET `j_L` = '208' WHERE `code`='KJT28' and med_hotel_no='520'<br>UPDATE `med_hotel` SET `j_P` = '234' WHERE `code`='KJT28' and med_hotel_no='520'<br>UPDATE `med_hotel` SET `j_L` = '100' WHERE `code`='KJT31' and med_hotel_no='323'<br>UPDATE `med_hotel` SET `j_P` = '100' WHERE `code`='KJT31' and med_hotel_no='323'<br>UPDATE `med_hotel` SET `j_L` = '113' WHERE `code`='KJT31' and med_hotel_no='417'<br>UPDATE `med_hotel` SET `j_P` = '128' WHERE `code`='KJT31' and med_hotel_no='417'<br>UPDATE `med_hotel` SET `j_L` = '15' WHERE `code`='KJT32' and med_hotel_no='404'<br>UPDATE `med_hotel` SET `j_P` = '16' WHERE `code`='KJT32' and med_hotel_no='404'<br>UPDATE `med_hotel` SET `j_L` = '188' WHERE `code`='KJT32' and med_hotel_no='405'<br>UPDATE `med_hotel` SET `j_P` = '223' WHERE `code`='KJT32' and med_hotel_no='405'<br>UPDATE `med_hotel` SET `j_L` = '176' WHERE `code`='KJT33' and med_hotel_no='322'<br>UPDATE `med_hotel` SET `j_P` = '204' WHERE `code`='KJT33' and med_hotel_no='322'<br>UPDATE `med_hotel` SET `j_L` = '30' WHERE `code`='KJT33' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `j_P` = '30' WHERE `code`='KJT33' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `j_L` = '190' WHERE `code`='KJT35' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `j_P` = '246' WHERE `code`='KJT35' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `j_L` = '56' WHERE `code`='KJT37' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `j_P` = '70' WHERE `code`='KJT37' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `j_L` = '127' WHERE `code`='KJT37' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `j_P` = '190' WHERE `code`='KJT37' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `j_L` = '194' WHERE `code`='KJT38' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `j_P` = '245' WHERE `code`='KJT38' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `j_P` = '1' WHERE `code`='KJT40' and med_hotel_no='0'<br>UPDATE `med_hotel` SET `j_L` = '27' WHERE `code`='KJT40' and med_hotel_no='304'<br>UPDATE `med_hotel` SET `j_P` = '33' WHERE `code`='KJT40' and med_hotel_no='304'<br>UPDATE `med_hotel` SET `j_L` = '92' WHERE `code`='KJT40' and med_hotel_no='308'<br>UPDATE `med_hotel` SET `j_P` = '119' WHERE `code`='KJT40' and med_hotel_no='308'<br>UPDATE `med_hotel` SET `j_L` = '13' WHERE `code`='KJT40' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `j_P` = '19' WHERE `code`='KJT40' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `j_L` = '142' WHERE `code`='KNO5' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `j_P` = '216' WHERE `code`='KNO5' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `j_L` = '38' WHERE `code`='KNO9' and med_hotel_no='222'<br>UPDATE `med_hotel` SET `j_P` = '68' WHERE `code`='KNO9' and med_hotel_no='222'<br>UPDATE `med_hotel` SET `j_L` = '110' WHERE `code`='KNO9' and med_hotel_no='223'<br>UPDATE `med_hotel` SET `j_P` = '143' WHERE `code`='KNO9' and med_hotel_no='223'<br>UPDATE `med_hotel` SET `j_L` = '152' WHERE `code`='KNO12' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `j_P` = '206' WHERE `code`='KNO12' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `j_L` = '150' WHERE `code`='KNO13' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `j_P` = '209' WHERE `code`='KNO13' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `j_L` = '67' WHERE `code`='KNO15' and med_hotel_no='409'<br>UPDATE `med_hotel` SET `j_P` = '123' WHERE `code`='KNO15' and med_hotel_no='409'<br>UPDATE `med_hotel` SET `j_L` = '81' WHERE `code`='KNO15' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `j_P` = '89' WHERE `code`='KNO15' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `j_L` = '4' WHERE `code`='LOP5' and med_hotel_no='0'<br>UPDATE `med_hotel` SET `j_P` = '1' WHERE `code`='LOP5' and med_hotel_no='0'<br>UPDATE `med_hotel` SET `j_L` = '40' WHERE `code`='LOP5' and med_hotel_no='208'<br>UPDATE `med_hotel` SET `j_P` = '49' WHERE `code`='LOP5' and med_hotel_no='208'<br>UPDATE `med_hotel` SET `j_L` = '43' WHERE `code`='LOP5' and med_hotel_no='213'<br>UPDATE `med_hotel` SET `j_P` = '57' WHERE `code`='LOP5' and med_hotel_no='213'<br>UPDATE `med_hotel` SET `j_L` = '91' WHERE `code`='LOP5' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `j_P` = '108' WHERE `code`='LOP5' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `j_P` = '3' WHERE `code`='LOP9' and med_hotel_no='404'<br>UPDATE `med_hotel` SET `j_L` = '176' WHERE `code`='LOP9' and med_hotel_no='405'<br>UPDATE `med_hotel` SET `j_P` = '172' WHERE `code`='LOP9' and med_hotel_no='405'<br>UPDATE `med_hotel` SET `j_L` = '23' WHERE `code`='LOP9' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `j_P` = '19' WHERE `code`='LOP9' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `j_L` = '195' WHERE `code`='LOP14' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `j_P` = '156' WHERE `code`='LOP14' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `j_L` = '15' WHERE `code`='LOP14' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `j_P` = '21' WHERE `code`='LOP14' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `j_L` = '181' WHERE `code`='LOP15' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `j_P` = '185' WHERE `code`='LOP15' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `j_L` = '46' WHERE `code`='PDG3' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `j_P` = '75' WHERE `code`='PDG3' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `j_L` = '106' WHERE `code`='PDG3' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `j_P` = '163' WHERE `code`='PDG3' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `j_L` = '169' WHERE `code`='PDG4' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `j_P` = '218' WHERE `code`='PDG4' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `j_L` = '164' WHERE `code`='PDG5' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `j_P` = '229' WHERE `code`='PDG5' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `j_L` = '27' WHERE `code`='PDG6' and med_hotel_no='325'<br>UPDATE `med_hotel` SET `j_P` = '41' WHERE `code`='PDG6' and med_hotel_no='325'<br>UPDATE `med_hotel` SET `j_L` = '121' WHERE `code`='PDG6' and med_hotel_no='407'<br>UPDATE `med_hotel` SET `j_P` = '204' WHERE `code`='PDG6' and med_hotel_no='407'<br>UPDATE `med_hotel` SET `j_L` = '87' WHERE `code`='PDG9' and med_hotel_no='308'<br>UPDATE `med_hotel` SET `j_P` = '158' WHERE `code`='PDG9' and med_hotel_no='308'<br>UPDATE `med_hotel` SET `j_L` = '61' WHERE `code`='PDG9' and med_hotel_no='317'<br>UPDATE `med_hotel` SET `j_P` = '83' WHERE `code`='PDG9' and med_hotel_no='317'<br>UPDATE `med_hotel` SET `j_L` = '151' WHERE `code`='PDG12' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `j_P` = '236' WHERE `code`='PDG12' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `j_L` = '200' WHERE `code`='PLM3' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `j_P` = '244' WHERE `code`='PLM3' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `j_L` = '205' WHERE `code`='PLM8' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `j_P` = '239' WHERE `code`='PLM8' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `j_L` = '121' WHERE `code`='PLM9' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `j_P` = '131' WHERE `code`='PLM9' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `j_L` = '75' WHERE `code`='PLM9' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `j_P` = '112' WHERE `code`='PLM9' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `j_L` = '150' WHERE `code`='PLM16' and med_hotel_no='116'<br>UPDATE `med_hotel` SET `j_P` = '179' WHERE `code`='PLM16' and med_hotel_no='116'<br>UPDATE `med_hotel` SET `j_L` = '10' WHERE `code`='PLM16' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `j_P` = '16' WHERE `code`='PLM16' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `j_L` = '164' WHERE `code`='SOC8' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `j_P` = '195' WHERE `code`='SOC8' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `j_L` = '34' WHERE `code`='SOC10' and med_hotel_no='213'<br>UPDATE `med_hotel` SET `j_P` = '50' WHERE `code`='SOC10' and med_hotel_no='213'<br>UPDATE `med_hotel` SET `j_L` = '127' WHERE `code`='SOC10' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `j_P` = '149' WHERE `code`='SOC10' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `j_L` = '31' WHERE `code`='SOC12' and med_hotel_no='313'<br>UPDATE `med_hotel` SET `j_P` = '49' WHERE `code`='SOC12' and med_hotel_no='313'<br>UPDATE `med_hotel` SET `j_L` = '130' WHERE `code`='SOC12' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `j_P` = '149' WHERE `code`='SOC12' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `j_L` = '10' WHERE `code`='SOC14' and med_hotel_no='208'<br>UPDATE `med_hotel` SET `j_P` = '8' WHERE `code`='SOC14' and med_hotel_no='208'<br>UPDATE `med_hotel` SET `j_L` = '77' WHERE `code`='SOC14' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `j_P` = '98' WHERE `code`='SOC14' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `j_L` = '73' WHERE `code`='SOC14' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `j_P` = '94' WHERE `code`='SOC14' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `j_L` = '168' WHERE `code`='SOC16' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `j_P` = '192' WHERE `code`='SOC16' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `j_L` = '166' WHERE `code`='SOC18' and med_hotel_no='420'<br>UPDATE `med_hotel` SET `j_P` = '194' WHERE `code`='SOC18' and med_hotel_no='420'<br>UPDATE `med_hotel` SET `j_L` = '165' WHERE `code`='SOC19' and med_hotel_no='421'<br>UPDATE `med_hotel` SET `j_P` = '192' WHERE `code`='SOC19' and med_hotel_no='421'<br>UPDATE `med_hotel` SET `j_L` = '156' WHERE `code`='SOC20' and med_hotel_no='421'<br>UPDATE `med_hotel` SET `j_P` = '202' WHERE `code`='SOC20' and med_hotel_no='421'<br>UPDATE `med_hotel` SET `j_L` = '111' WHERE `code`='SOC22' and med_hotel_no='405'<br>UPDATE `med_hotel` SET `j_P` = '132' WHERE `code`='SOC22' and med_hotel_no='405'<br>UPDATE `med_hotel` SET `j_L` = '58' WHERE `code`='SOC22' and med_hotel_no='416'<br>UPDATE `med_hotel` SET `j_P` = '59' WHERE `code`='SOC22' and med_hotel_no='416'<br>UPDATE `med_hotel` SET `j_L` = '157' WHERE `code`='SOC33' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `j_P` = '203' WHERE `code`='SOC33' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `j_L` = '38' WHERE `code`='SOC34' and med_hotel_no='314'<br>UPDATE `med_hotel` SET `j_P` = '48' WHERE `code`='SOC34' and med_hotel_no='314'<br>UPDATE `med_hotel` SET `j_L` = '36' WHERE `code`='SOC34' and med_hotel_no='321'<br>UPDATE `med_hotel` SET `j_P` = '48' WHERE `code`='SOC34' and med_hotel_no='321'<br>UPDATE `med_hotel` SET `j_L` = '82' WHERE `code`='SOC34' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `j_P` = '108' WHERE `code`='SOC34' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `j_L` = '39' WHERE `code`='SOC35' and med_hotel_no='313'<br>UPDATE `med_hotel` SET `j_P` = '41' WHERE `code`='SOC35' and med_hotel_no='313'<br>UPDATE `med_hotel` SET `j_L` = '134' WHERE `code`='SOC35' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `j_P` = '145' WHERE `code`='SOC35' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `j_L` = '154' WHERE `code`='SOC39' and med_hotel_no='509'<br>UPDATE `med_hotel` SET `j_P` = '205' WHERE `code`='SOC39' and med_hotel_no='509'<br>UPDATE `med_hotel` SET `j_L` = '161' WHERE `code`='SOC40' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `j_P` = '195' WHERE `code`='SOC40' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `j_L` = '90' WHERE `code`='SOC41' and med_hotel_no='109'<br>UPDATE `med_hotel` SET `j_P` = '124' WHERE `code`='SOC41' and med_hotel_no='109'<br>UPDATE `med_hotel` SET `j_L` = '67' WHERE `code`='SOC41' and med_hotel_no='407'<br>UPDATE `med_hotel` SET `j_P` = '78' WHERE `code`='SOC41' and med_hotel_no='407'<br>UPDATE `med_hotel` SET `j_L` = '84' WHERE `code`='SOC42' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `j_P` = '91' WHERE `code`='SOC42' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `j_L` = '78' WHERE `code`='SOC42' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `j_P` = '89' WHERE `code`='SOC42' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `j_L` = '9' WHERE `code`='SOC42' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `j_P` = '9' WHERE `code`='SOC42' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `j_L` = '41' WHERE `code`='SOC43' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `j_P` = '43' WHERE `code`='SOC43' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `j_L` = '118' WHERE `code`='SOC43' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `j_P` = '156' WHERE `code`='SOC43' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `j_L` = '167' WHERE `code`='SOC44' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `j_P` = '189' WHERE `code`='SOC44' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `j_L` = '168' WHERE `code`='SOC46' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `j_P` = '186' WHERE `code`='SOC46' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `j_P` = '1' WHERE `code`='SOC46' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `j_L` = '22' WHERE `code`='SOC47' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `j_P` = '28' WHERE `code`='SOC47' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `j_L` = '141' WHERE `code`='SOC47' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `j_P` = '167' WHERE `code`='SOC47' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `j_L` = '159' WHERE `code`='SOC48' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `j_P` = '200' WHERE `code`='SOC48' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `j_L` = '152' WHERE `code`='SOC50' and med_hotel_no='409'<br>UPDATE `med_hotel` SET `j_P` = '206' WHERE `code`='SOC50' and med_hotel_no='409'<br>UPDATE `med_hotel` SET `j_L` = '156' WHERE `code`='SOC52' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `j_P` = '201' WHERE `code`='SOC52' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `j_L` = '157' WHERE `code`='SOC53' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `j_P` = '200' WHERE `code`='SOC53' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `j_L` = '163' WHERE `code`='SOC55' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `j_P` = '195' WHERE `code`='SOC55' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `j_L` = '1' WHERE `code`='SOC57' and med_hotel_no='0'<br>UPDATE `med_hotel` SET `j_P` = '1' WHERE `code`='SOC57' and med_hotel_no='0'<br>UPDATE `med_hotel` SET `j_L` = '100' WHERE `code`='SOC57' and med_hotel_no='308'<br>UPDATE `med_hotel` SET `j_P` = '123' WHERE `code`='SOC57' and med_hotel_no='308'<br>UPDATE `med_hotel` SET `j_L` = '61' WHERE `code`='SOC57' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `j_P` = '70' WHERE `code`='SOC57' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `j_L` = '165' WHERE `code`='SOC61' and med_hotel_no='519'<br>UPDATE `med_hotel` SET `j_P` = '195' WHERE `code`='SOC61' and med_hotel_no='519'<br>UPDATE `med_hotel` SET `j_L` = '149' WHERE `code`='SOC64' and med_hotel_no='312'<br>UPDATE `med_hotel` SET `j_P` = '164' WHERE `code`='SOC64' and med_hotel_no='312'<br>UPDATE `med_hotel` SET `j_L` = '17' WHERE `code`='SOC64' and med_hotel_no='519'<br>UPDATE `med_hotel` SET `j_P` = '27' WHERE `code`='SOC64' and med_hotel_no='519'<br>UPDATE `med_hotel` SET `j_L` = '162' WHERE `code`='SOC67' and med_hotel_no='508'<br>UPDATE `med_hotel` SET `j_P` = '195' WHERE `code`='SOC67' and med_hotel_no='508'<br>UPDATE `med_hotel` SET `j_L` = '174' WHERE `code`='SOC72' and med_hotel_no='513'<br>UPDATE `med_hotel` SET `j_P` = '184' WHERE `code`='SOC72' and med_hotel_no='513'<br>UPDATE `med_hotel` SET `j_L` = '28' WHERE `code`='SOC73' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `j_P` = '22' WHERE `code`='SOC73' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `j_L` = '136' WHERE `code`='SOC73' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `j_P` = '174' WHERE `code`='SOC73' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `j_L` = '165' WHERE `code`='SOC74' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `j_P` = '195' WHERE `code`='SOC74' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `j_L` = '168' WHERE `code`='SOC75' and med_hotel_no='409'<br>UPDATE `med_hotel` SET `j_P` = '186' WHERE `code`='SOC75' and med_hotel_no='409'<br>UPDATE `med_hotel` SET `j_L` = '91' WHERE `code`='SOC77' and med_hotel_no='409'<br>UPDATE `med_hotel` SET `j_P` = '99' WHERE `code`='SOC77' and med_hotel_no='409'<br>UPDATE `med_hotel` SET `j_L` = '78' WHERE `code`='SOC77' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `j_P` = '89' WHERE `code`='SOC77' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `j_L` = '163' WHERE `code`='SOC78' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `j_P` = '197' WHERE `code`='SOC78' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `j_L` = '163' WHERE `code`='SOC80' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `j_P` = '191' WHERE `code`='SOC80' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `j_P` = '2' WHERE `code`='SOC81' and med_hotel_no='0'<br>UPDATE `med_hotel` SET `j_L` = '149' WHERE `code`='SOC81' and med_hotel_no='311'<br>UPDATE `med_hotel` SET `j_P` = '187' WHERE `code`='SOC81' and med_hotel_no='311'<br>UPDATE `med_hotel` SET `j_L` = '9' WHERE `code`='SOC81' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `j_P` = '7' WHERE `code`='SOC81' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `j_L` = '186' WHERE `code`='SUB2' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `j_P` = '194' WHERE `code`='SUB2' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `j_L` = '178' WHERE `code`='SUB4' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `j_P` = '202' WHERE `code`='SUB4' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `j_L` = '120' WHERE `code`='SUB8' and med_hotel_no='202'<br>UPDATE `med_hotel` SET `j_P` = '130' WHERE `code`='SUB8' and med_hotel_no='202'<br>UPDATE `med_hotel` SET `j_L` = '67' WHERE `code`='SUB8' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `j_P` = '63' WHERE `code`='SUB8' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `j_L` = '108' WHERE `code`='SUB9' and med_hotel_no='320'<br>UPDATE `med_hotel` SET `j_P` = '104' WHERE `code`='SUB9' and med_hotel_no='320'<br>UPDATE `med_hotel` SET `j_L` = '77' WHERE `code`='SUB9' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `j_P` = '91' WHERE `code`='SUB9' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `j_L` = '74' WHERE `code`='SUB12' and med_hotel_no='202'<br>UPDATE `med_hotel` SET `j_P` = '94' WHERE `code`='SUB12' and med_hotel_no='202'<br>UPDATE `med_hotel` SET `j_L` = '97' WHERE `code`='SUB12' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `j_P` = '115' WHERE `code`='SUB12' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `j_L` = '37' WHERE `code`='SUB17' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `j_P` = '47' WHERE `code`='SUB17' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `j_L` = '138' WHERE `code`='SUB17' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `j_P` = '156' WHERE `code`='SUB17' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `j_L` = '92' WHERE `code`='SUB19' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `j_P` = '118' WHERE `code`='SUB19' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `j_L` = '76' WHERE `code`='SUB19' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `j_P` = '94' WHERE `code`='SUB19' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `j_L` = '174' WHERE `code`='SUB20' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `j_P` = '206' WHERE `code`='SUB20' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `j_L` = '42' WHERE `code`='SUB21' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `j_P` = '49' WHERE `code`='SUB21' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `j_L` = '138' WHERE `code`='SUB21' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `j_P` = '150' WHERE `code`='SUB21' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `j_L` = '71' WHERE `code`='SUB24' and med_hotel_no='118'<br>UPDATE `med_hotel` SET `j_P` = '79' WHERE `code`='SUB24' and med_hotel_no='118'<br>UPDATE `med_hotel` SET `j_L` = '100' WHERE `code`='SUB24' and med_hotel_no='119'<br>UPDATE `med_hotel` SET `j_P` = '130' WHERE `code`='SUB24' and med_hotel_no='119'<br>UPDATE `med_hotel` SET `j_L` = '182' WHERE `code`='SUB25' and med_hotel_no='421'<br>UPDATE `med_hotel` SET `j_P` = '197' WHERE `code`='SUB25' and med_hotel_no='421'<br>UPDATE `med_hotel` SET `j_L` = '2' WHERE `code`='SUB27' and med_hotel_no='205'<br>UPDATE `med_hotel` SET `j_P` = '1' WHERE `code`='SUB27' and med_hotel_no='205'<br>UPDATE `med_hotel` SET `j_L` = '170' WHERE `code`='SUB27' and med_hotel_no='516'<br>UPDATE `med_hotel` SET `j_P` = '205' WHERE `code`='SUB27' and med_hotel_no='516'<br>UPDATE `med_hotel` SET `j_L` = '149' WHERE `code`='SUB28' and med_hotel_no='325'<br>UPDATE `med_hotel` SET `j_P` = '161' WHERE `code`='SUB28' and med_hotel_no='325'<br>UPDATE `med_hotel` SET `j_L` = '31' WHERE `code`='SUB28' and med_hotel_no='407'<br>UPDATE `med_hotel` SET `j_P` = '37' WHERE `code`='SUB28' and med_hotel_no='407'<br>UPDATE `med_hotel` SET `j_L` = '118' WHERE `code`='SUB31' and med_hotel_no='115'<br>UPDATE `med_hotel` SET `j_P` = '141' WHERE `code`='SUB31' and med_hotel_no='115'<br>UPDATE `med_hotel` SET `j_L` = '57' WHERE `code`='SUB31' and med_hotel_no='416'<br>UPDATE `med_hotel` SET `j_P` = '63' WHERE `code`='SUB31' and med_hotel_no='416'<br>UPDATE `med_hotel` SET `j_L` = '175' WHERE `code`='SUB37' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `j_P` = '205' WHERE `code`='SUB37' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `j_L` = '183' WHERE `code`='SUB38' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `j_P` = '197' WHERE `code`='SUB38' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `j_L` = '66' WHERE `code`='SUB41' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `j_P` = '64' WHERE `code`='SUB41' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `j_L` = '110' WHERE `code`='SUB41' and med_hotel_no='511'<br>UPDATE `med_hotel` SET `j_P` = '140' WHERE `code`='SUB41' and med_hotel_no='511'<br>UPDATE `med_hotel` SET `j_L` = '182' WHERE `code`='SUB42' and med_hotel_no='404'<br>UPDATE `med_hotel` SET `j_P` = '198' WHERE `code`='SUB42' and med_hotel_no='404'<br>UPDATE `med_hotel` SET `j_L` = '45' WHERE `code`='SUB45' and med_hotel_no='317'<br>UPDATE `med_hotel` SET `j_P` = '57' WHERE `code`='SUB45' and med_hotel_no='317'<br>UPDATE `med_hotel` SET `j_L` = '132' WHERE `code`='SUB45' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `j_P` = '146' WHERE `code`='SUB45' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `j_L` = '76' WHERE `code`='SUB46' and med_hotel_no='217'<br>UPDATE `med_hotel` SET `j_P` = '92' WHERE `code`='SUB46' and med_hotel_no='217'<br>UPDATE `med_hotel` SET `j_L` = '93' WHERE `code`='SUB46' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `j_P` = '119' WHERE `code`='SUB46' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `j_L` = '85' WHERE `code`='SUB49' and med_hotel_no='407'<br>UPDATE `med_hotel` SET `j_P` = '83' WHERE `code`='SUB49' and med_hotel_no='407'<br>UPDATE `med_hotel` SET `j_L` = '94' WHERE `code`='SUB49' and med_hotel_no='425'<br>UPDATE `med_hotel` SET `j_P` = '115' WHERE `code`='SUB49' and med_hotel_no='425'<br>UPDATE `med_hotel` SET `j_L` = '179' WHERE `code`='SUB50' and med_hotel_no='509'<br>UPDATE `med_hotel` SET `j_P` = '200' WHERE `code`='SUB50' and med_hotel_no='509'<br>UPDATE `med_hotel` SET `j_L` = '165' WHERE `code`='SUB53' and med_hotel_no='507'<br>UPDATE `med_hotel` SET `j_P` = '215' WHERE `code`='SUB53' and med_hotel_no='507'<br>UPDATE `med_hotel` SET `j_L` = '93' WHERE `code`='SUB54' and med_hotel_no='407'<br>UPDATE `med_hotel` SET `j_P` = '119' WHERE `code`='SUB54' and med_hotel_no='407'<br>UPDATE `med_hotel` SET `j_L` = '82' WHERE `code`='SUB54' and med_hotel_no='425'<br>UPDATE `med_hotel` SET `j_P` = '86' WHERE `code`='SUB54' and med_hotel_no='425'<br>UPDATE `med_hotel` SET `j_L` = '168' WHERE `code`='SUB55' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `j_P` = '212' WHERE `code`='SUB55' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `j_L` = '3' WHERE `code`='SUB56' and med_hotel_no='0'<br>UPDATE `med_hotel` SET `j_L` = '82' WHERE `code`='SUB56' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `j_P` = '124' WHERE `code`='SUB56' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `j_L` = '72' WHERE `code`='SUB56' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `j_P` = '97' WHERE `code`='SUB56' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `j_L` = '175' WHERE `code`='SUB57' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `j_P` = '203' WHERE `code`='SUB57' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `j_L` = '173' WHERE `code`='SUB60' and med_hotel_no='322'<br>UPDATE `med_hotel` SET `j_P` = '207' WHERE `code`='SUB60' and med_hotel_no='322'<br>UPDATE `med_hotel` SET `j_L` = '136' WHERE `code`='SUB62' and med_hotel_no='324'<br>UPDATE `med_hotel` SET `j_P` = '202' WHERE `code`='SUB62' and med_hotel_no='324'<br>UPDATE `med_hotel` SET `j_L` = '1' WHERE `code`='SUB62' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `j_L` = '16' WHERE `code`='SUB62' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `j_P` = '24' WHERE `code`='SUB62' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `j_L` = '176' WHERE `code`='SUB65' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `j_P` = '203' WHERE `code`='SUB65' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `j_L` = '49' WHERE `code`='SUB68' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `j_P` = '56' WHERE `code`='SUB68' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `j_L` = '136' WHERE `code`='SUB68' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `j_P` = '137' WHERE `code`='SUB68' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `j_P` = '1' WHERE `code`='SUB71' and med_hotel_no='210'<br>UPDATE `med_hotel` SET `j_L` = '176' WHERE `code`='SUB71' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `j_P` = '200' WHERE `code`='SUB71' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `j_L` = '160' WHERE `code`='SUB73' and med_hotel_no='207'<br>UPDATE `med_hotel` SET `j_P` = '163' WHERE `code`='SUB73' and med_hotel_no='207'<br>UPDATE `med_hotel` SET `j_L` = '24' WHERE `code`='SUB73' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `j_P` = '30' WHERE `code`='SUB73' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `j_L` = '175' WHERE `code`='SUB74' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `j_P` = '203' WHERE `code`='SUB74' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `j_L` = '20' WHERE `code`='SUB77' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `j_P` = '20' WHERE `code`='SUB77' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `j_L` = '164' WHERE `code`='SUB77' and med_hotel_no='507'<br>UPDATE `med_hotel` SET `j_P` = '173' WHERE `code`='SUB77' and med_hotel_no='507'<br>UPDATE `med_hotel` SET `j_L` = '192' WHERE `code`='SUB85' and med_hotel_no='510'<br>UPDATE `med_hotel` SET `j_P` = '188' WHERE `code`='SUB85' and med_hotel_no='510'<br>UPDATE `med_hotel` SET `j_L` = '190' WHERE `code`='SUB90' and med_hotel_no='508'<br>UPDATE `med_hotel` SET `j_P` = '188' WHERE `code`='SUB90' and med_hotel_no='508'<br>UPDATE `med_hotel` SET `j_L` = '185' WHERE `code`='SUB92' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `j_P` = '193' WHERE `code`='SUB92' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `j_L` = '76' WHERE `code`='SUB96' and med_hotel_no='511'<br>UPDATE `med_hotel` SET `j_P` = '79' WHERE `code`='SUB96' and med_hotel_no='511'<br>UPDATE `med_hotel` SET `j_L` = '109' WHERE `code`='SUB96' and med_hotel_no='515'<br>UPDATE `med_hotel` SET `j_P` = '112' WHERE `code`='SUB96' and med_hotel_no='515'<br>UPDATE `med_hotel` SET `j_L` = '162' WHERE `code`='SUB99' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `j_P` = '216' WHERE `code`='SUB99' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `j_L` = '55' WHERE `code`='SUB104' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `j_P` = '50' WHERE `code`='SUB104' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `j_L` = '120' WHERE `code`='SUB104' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `j_P` = '149' WHERE `code`='SUB104' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `j_L` = '185' WHERE `code`='SUB106' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `j_P` = '194' WHERE `code`='SUB106' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `j_L` = '180' WHERE `code`='SUB109' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `j_P` = '196' WHERE `code`='SUB109' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `j_L` = '155' WHERE `code`='SUB113' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `j_P` = '185' WHERE `code`='SUB113' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `j_L` = '22' WHERE `code`='SUB113' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `j_P` = '17' WHERE `code`='SUB113' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `j_L` = '110' WHERE `code`='UPG2' and med_hotel_no='507'<br>UPDATE `med_hotel` SET `j_P` = '283' WHERE `code`='UPG2' and med_hotel_no='507'<br>UPDATE `med_hotel` SET `j_L` = '36' WHERE `code`='UPG5' and med_hotel_no='404'<br>UPDATE `med_hotel` SET `j_P` = '89' WHERE `code`='UPG5' and med_hotel_no='404'<br>UPDATE `med_hotel` SET `j_L` = '81' WHERE `code`='UPG5' and med_hotel_no='405'<br>UPDATE `med_hotel` SET `j_P` = '187' WHERE `code`='UPG5' and med_hotel_no='405'<br>UPDATE `med_hotel` SET `j_L` = '4' WHERE `code`='UPG6' and med_hotel_no='324'<br>UPDATE `med_hotel` SET `j_P` = '7' WHERE `code`='UPG6' and med_hotel_no='324'<br>UPDATE `med_hotel` SET `j_L` = '121' WHERE `code`='UPG6' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `j_P` = '261' WHERE `code`='UPG6' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `j_L` = '102' WHERE `code`='UPG8' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `j_P` = '291' WHERE `code`='UPG8' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `j_L` = '136' WHERE `code`='UPG9' and med_hotel_no='102'<br>UPDATE `med_hotel` SET `j_P` = '256' WHERE `code`='UPG9' and med_hotel_no='102'<br>UPDATE `med_hotel` SET `j_L` = '179' WHERE `code`='UPG13' and med_hotel_no='416'<br>UPDATE `med_hotel` SET `j_P` = '214' WHERE `code`='UPG13' and med_hotel_no='416'<br>UPDATE `med_hotel` SET `j_L` = '18' WHERE `code`='UPG18' and med_hotel_no='324'<br>UPDATE `med_hotel` SET `j_P` = '18' WHERE `code`='UPG18' and med_hotel_no='324'<br>UPDATE `med_hotel` SET `j_L` = '110' WHERE `code`='UPG18' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `j_P` = '247' WHERE `code`='UPG18' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `j_L` = '42' WHERE `code`='UPG19' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `j_P` = '84' WHERE `code`='UPG19' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `j_L` = '88' WHERE `code`='UPG19' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `j_P` = '176' WHERE `code`='UPG19' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `j_L` = '8' WHERE `code`='UPG21' and med_hotel_no='0'<br>UPDATE `med_hotel` SET `j_L` = '11' WHERE `code`='UPG21' and med_hotel_no='201'<br>UPDATE `med_hotel` SET `j_P` = '36' WHERE `code`='UPG21' and med_hotel_no='201'<br>UPDATE `med_hotel` SET `j_L` = '45' WHERE `code`='UPG21' and med_hotel_no='507'<br>UPDATE `med_hotel` SET `j_P` = '102' WHERE `code`='UPG21' and med_hotel_no='507'<br>UPDATE `med_hotel` SET `j_L` = '54' WHERE `code`='UPG21' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `j_P` = '135' WHERE `code`='UPG21' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `j_L` = '160' WHERE `code`='UPG26' and med_hotel_no='425'<br>UPDATE `med_hotel` SET `j_P` = '233' WHERE `code`='UPG26' and med_hotel_no='425'<br>UPDATE `med_hotel` SET `j_L` = '1' WHERE `code`='UPG27' and med_hotel_no='0'<br>UPDATE `med_hotel` SET `j_L` = '35' WHERE `code`='UPG27' and med_hotel_no='306'<br>UPDATE `med_hotel` SET `j_P` = '65' WHERE `code`='UPG27' and med_hotel_no='306'<br>UPDATE `med_hotel` SET `j_L` = '116' WHERE `code`='UPG27' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `j_P` = '174' WHERE `code`='UPG27' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `j_L` = '139' WHERE `code`='UPG36' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `j_P` = '252' WHERE `code`='UPG36' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `j_L` = '16' WHERE `code`='UPG37' and med_hotel_no='318'<br>UPDATE `med_hotel` SET `j_P` = '19' WHERE `code`='UPG37' and med_hotel_no='318'<br>UPDATE `med_hotel` SET `j_L` = '113' WHERE `code`='UPG37' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `j_P` = '244' WHERE `code`='UPG37' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `j_L` = '32' WHERE `code`='UPG39' and med_hotel_no='306'<br>UPDATE `med_hotel` SET `j_P` = '69' WHERE `code`='UPG39' and med_hotel_no='306'<br>UPDATE `med_hotel` SET `j_L` = '97' WHERE `code`='UPG39' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `j_P` = '192' WHERE `code`='UPG39' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `j_L` = '60' WHERE `code`='UPG42' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `j_P` = '108' WHERE `code`='UPG42' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `j_L` = '93' WHERE `code`='UPG42' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `j_P` = '128' WHERE `code`='UPG42' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `j_L` = '78' WHERE `code`='UPG43' and med_hotel_no='304'<br>UPDATE `med_hotel` SET `j_P` = '131' WHERE `code`='UPG43' and med_hotel_no='304'<br>UPDATE `med_hotel` SET `j_L` = '16' WHERE `code`='UPG43' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `j_P` = '20' WHERE `code`='UPG43' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `j_L` = '171' WHERE `code`='YIA5' and med_hotel_no='102'<br>UPDATE `med_hotel` SET `j_P` = '184' WHERE `code`='YIA5' and med_hotel_no='102'<br>UPDATE `med_hotel` SET `j_P` = '4' WHERE `code`='YIA5' and med_hotel_no='405'<br>UPDATE `med_hotel` SET `j_L` = '166' WHERE `code`='YIA10' and med_hotel_no='424'<br>UPDATE `med_hotel` SET `j_P` = '194' WHERE `code`='YIA10' and med_hotel_no='424'<br>UPDATE `med_hotel` SET `j_L` = '190' WHERE `code`='YIA13' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `j_P` = '167' WHERE `code`='YIA13' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `j_L` = '76' WHERE `code`='YIA15' and med_hotel_no='425'<br>UPDATE `med_hotel` SET `j_P` = '88' WHERE `code`='YIA15' and med_hotel_no='425'<br>UPDATE `med_hotel` SET `j_L` = '95' WHERE `code`='YIA15' and med_hotel_no='507'<br>UPDATE `med_hotel` SET `j_P` = '99' WHERE `code`='YIA15' and med_hotel_no='507'<br>UPDATE `med_hotel` SET `j_L` = '155' WHERE `code`='YIA16' and med_hotel_no='519'<br>UPDATE `med_hotel` SET `j_P` = '204' WHERE `code`='YIA16' and med_hotel_no='519'<br>UPDATE `med_hotel` SET `j_L` = '41' WHERE `code`='YIA17' and med_hotel_no='301'<br>UPDATE `med_hotel` SET `j_P` = '49' WHERE `code`='YIA17' and med_hotel_no='301'<br>UPDATE `med_hotel` SET `j_L` = '124' WHERE `code`='YIA17' and med_hotel_no='520'<br>UPDATE `med_hotel` SET `j_P` = '141' WHERE `code`='YIA17' and med_hotel_no='520'<br>UPDATE `med_hotel` SET `j_L` = '95' WHERE `code`='YIA19' and med_hotel_no='215'<br>UPDATE `med_hotel` SET `j_P` = '107' WHERE `code`='YIA19' and med_hotel_no='215'<br>UPDATE `med_hotel` SET `j_L` = '75' WHERE `code`='YIA19' and med_hotel_no='515'<br>UPDATE `med_hotel` SET `j_P` = '81' WHERE `code`='YIA19' and med_hotel_no='515'<br>UPDATE `med_hotel` SET `j_L` = '71' WHERE `code`='YIA21' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `j_P` = '89' WHERE `code`='YIA21' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `j_L` = '95' WHERE `code`='YIA21' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `j_P` = '100' WHERE `code`='YIA21' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `j_L` = '179' WHERE `code`='YIA22' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `j_P` = '178' WHERE `code`='YIA22' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `lan_L` = '28' WHERE `code`='BDJ2' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `lan_P` = '28' WHERE `code`='BDJ2' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `lan_L` = '34' WHERE `code`='BDJ3' and med_hotel_no='420'<br>UPDATE `med_hotel` SET `lan_P` = '41' WHERE `code`='BDJ3' and med_hotel_no='420'<br>UPDATE `med_hotel` SET `lan_L` = '28' WHERE `code`='BDJ4' and med_hotel_no='421'<br>UPDATE `med_hotel` SET `lan_P` = '34' WHERE `code`='BDJ4' and med_hotel_no='421'<br>UPDATE `med_hotel` SET `lan_L` = '35' WHERE `code`='BDJ6' and med_hotel_no='511'<br>UPDATE `med_hotel` SET `lan_L` = '11' WHERE `code`='BDJ6' and med_hotel_no='518'<br>UPDATE `med_hotel` SET `lan_P` = '4' WHERE `code`='BDJ6' and med_hotel_no='223'<br>UPDATE `med_hotel` SET `lan_P` = '33' WHERE `code`='BDJ6' and med_hotel_no='511'<br>UPDATE `med_hotel` SET `lan_P` = '13' WHERE `code`='BDJ6' and med_hotel_no='518'<br>UPDATE `med_hotel` SET `lan_L` = '43' WHERE `code`='BDJ8' and med_hotel_no='406'<br>UPDATE `med_hotel` SET `lan_P` = '53' WHERE `code`='BDJ8' and med_hotel_no='406'<br>UPDATE `med_hotel` SET `lan_L` = '23' WHERE `code`='BDJ10' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `lan_L` = '26' WHERE `code`='BDJ10' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `lan_P` = '16' WHERE `code`='BDJ10' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `lan_P` = '31' WHERE `code`='BDJ10' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `lan_L` = '39' WHERE `code`='BDJ11' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `lan_P` = '58' WHERE `code`='BDJ11' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `lan_L` = '51' WHERE `code`='BDJ13' and med_hotel_no='521'<br>UPDATE `med_hotel` SET `lan_P` = '52' WHERE `code`='BDJ13' and med_hotel_no='521'<br>UPDATE `med_hotel` SET `lan_L` = '41' WHERE `code`='BDJ17' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `lan_P` = '56' WHERE `code`='BDJ17' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `lan_L` = '34' WHERE `code`='BDJ19' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `lan_P` = '52' WHERE `code`='BDJ19' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `lan_L` = '32' WHERE `code`='BPN1' and med_hotel_no='306'<br>UPDATE `med_hotel` SET `lan_L` = '29' WHERE `code`='BPN1' and med_hotel_no='425'<br>UPDATE `med_hotel` SET `lan_P` = '19' WHERE `code`='BPN1' and med_hotel_no='306'<br>UPDATE `med_hotel` SET `lan_P` = '37' WHERE `code`='BPN1' and med_hotel_no='425'<br>UPDATE `med_hotel` SET `lan_L` = '7' WHERE `code`='BPN4' and med_hotel_no='206'<br>UPDATE `med_hotel` SET `lan_L` = '23' WHERE `code`='BPN4' and med_hotel_no='325'<br>UPDATE `med_hotel` SET `lan_L` = '30' WHERE `code`='BPN4' and med_hotel_no='411'<br>UPDATE `med_hotel` SET `lan_P` = '9' WHERE `code`='BPN4' and med_hotel_no='206'<br>UPDATE `med_hotel` SET `lan_P` = '30' WHERE `code`='BPN4' and med_hotel_no='325'<br>UPDATE `med_hotel` SET `lan_P` = '34' WHERE `code`='BPN4' and med_hotel_no='411'<br>UPDATE `med_hotel` SET `lan_L` = '44' WHERE `code`='BPN8' and med_hotel_no='422'<br>UPDATE `med_hotel` SET `lan_P` = '1' WHERE `code`='BPN8' and med_hotel_no='303'<br>UPDATE `med_hotel` SET `lan_P` = '67' WHERE `code`='BPN8' and med_hotel_no='422'<br>UPDATE `med_hotel` SET `lan_L` = '53' WHERE `code`='BPN9' and med_hotel_no='313'<br>UPDATE `med_hotel` SET `lan_P` = '59' WHERE `code`='BPN9' and med_hotel_no='313'<br>UPDATE `med_hotel` SET `lan_L` = '37' WHERE `code`='BPN13' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `lan_P` = '68' WHERE `code`='BPN13' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `lan_L` = '48' WHERE `code`='BPN14' and med_hotel_no='422'<br>UPDATE `med_hotel` SET `lan_P` = '43' WHERE `code`='BPN14' and med_hotel_no='422'<br>UPDATE `med_hotel` SET `lan_L` = '51' WHERE `code`='BPN15' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `lan_P` = '62' WHERE `code`='BPN15' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `lan_L` = '71' WHERE `code`='BTH5' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `lan_P` = '76' WHERE `code`='BTH5' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `lan_L` = '68' WHERE `code`='BTH6' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `lan_P` = '101' WHERE `code`='BTH6' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `lan_L` = '36' WHERE `code`='BTH7' and med_hotel_no='110'<br>UPDATE `med_hotel` SET `lan_L` = '30' WHERE `code`='BTH7' and med_hotel_no='119'<br>UPDATE `med_hotel` SET `lan_L` = '5' WHERE `code`='BTH7' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `lan_P` = '35' WHERE `code`='BTH7' and med_hotel_no='110'<br>UPDATE `med_hotel` SET `lan_P` = '36' WHERE `code`='BTH7' and med_hotel_no='119'<br>UPDATE `med_hotel` SET `lan_P` = '3' WHERE `code`='BTH7' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `lan_L` = '18' WHERE `code`='BTH10' and med_hotel_no='206'<br>UPDATE `med_hotel` SET `lan_L` = '19' WHERE `code`='BTH10' and med_hotel_no='309'<br>UPDATE `med_hotel` SET `lan_L` = '46' WHERE `code`='BTH10' and med_hotel_no='408'<br>UPDATE `med_hotel` SET `lan_P` = '22' WHERE `code`='BTH10' and med_hotel_no='206'<br>UPDATE `med_hotel` SET `lan_P` = '15' WHERE `code`='BTH10' and med_hotel_no='309'<br>UPDATE `med_hotel` SET `lan_P` = '47' WHERE `code`='BTH10' and med_hotel_no='408'<br>UPDATE `med_hotel` SET `lan_L` = '37' WHERE `code`='BTH11' and med_hotel_no='517'<br>UPDATE `med_hotel` SET `lan_L` = '28' WHERE `code`='BTH11' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `lan_P` = '34' WHERE `code`='BTH11' and med_hotel_no='517'<br>UPDATE `med_hotel` SET `lan_P` = '30' WHERE `code`='BTH11' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `lan_L` = '75' WHERE `code`='BTH13' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `lan_P` = '93' WHERE `code`='BTH13' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `lan_L` = '1' WHERE `code`='BTH16' and med_hotel_no='308'<br>UPDATE `med_hotel` SET `lan_L` = '62' WHERE `code`='BTH16' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `lan_P` = '72' WHERE `code`='BTH16' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `lan_L` = '53' WHERE `code`='BTH18' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `lan_P` = '52' WHERE `code`='BTH18' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `lan_L` = '38' WHERE `code`='BTH25' and med_hotel_no='115'<br>UPDATE `med_hotel` SET `lan_L` = '10' WHERE `code`='BTH25' and med_hotel_no='405'<br>UPDATE `med_hotel` SET `lan_P` = '46' WHERE `code`='BTH25' and med_hotel_no='115'<br>UPDATE `med_hotel` SET `lan_P` = '5' WHERE `code`='BTH25' and med_hotel_no='405'<br>UPDATE `med_hotel` SET `lan_L` = '53' WHERE `code`='BTJ3' and med_hotel_no='422'<br>UPDATE `med_hotel` SET `lan_L` = '22' WHERE `code`='BTJ3' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `lan_P` = '77' WHERE `code`='BTJ3' and med_hotel_no='422'<br>UPDATE `med_hotel` SET `lan_P` = '36' WHERE `code`='BTJ3' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `lan_L` = '48' WHERE `code`='BTJ11' and med_hotel_no='422'<br>UPDATE `med_hotel` SET `lan_L` = '20' WHERE `code`='BTJ11' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `lan_P` = '39' WHERE `code`='BTJ11' and med_hotel_no='422'<br>UPDATE `med_hotel` SET `lan_P` = '40' WHERE `code`='BTJ11' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `lan_L` = '31' WHERE `code`='BTJ12' and med_hotel_no='208'<br>UPDATE `med_hotel` SET `lan_L` = '25' WHERE `code`='BTJ12' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `lan_P` = '49' WHERE `code`='BTJ12' and med_hotel_no='208'<br>UPDATE `med_hotel` SET `lan_P` = '45' WHERE `code`='BTJ12' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `lan_L` = '17' WHERE `code`='BTJ13' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `lan_L` = '44' WHERE `code`='BTJ13' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `lan_P` = '33' WHERE `code`='BTJ13' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `lan_P` = '90' WHERE `code`='BTJ13' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `lan_L` = '45' WHERE `code`='JKB3' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `lan_L` = '15' WHERE `code`='JKB3' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `lan_P` = '57' WHERE `code`='JKB3' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `lan_P` = '17' WHERE `code`='JKB3' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `lan_L` = '25' WHERE `code`='JKB4' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `lan_L` = '42' WHERE `code`='JKB4' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `lan_P` = '28' WHERE `code`='JKB4' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `lan_P` = '36' WHERE `code`='JKB4' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `lan_L` = '62' WHERE `code`='JKB11' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `lan_P` = '60' WHERE `code`='JKB11' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `lan_L` = '3' WHERE `code`='JKB13' and med_hotel_no='324'<br>UPDATE `med_hotel` SET `lan_L` = '23' WHERE `code`='JKB13' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `lan_L` = '57' WHERE `code`='JKB13' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `lan_P` = '4' WHERE `code`='JKB13' and med_hotel_no='324'<br>UPDATE `med_hotel` SET `lan_P` = '25' WHERE `code`='JKB13' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `lan_P` = '66' WHERE `code`='JKB13' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `lan_L` = '61' WHERE `code`='JKB14' and med_hotel_no='521'<br>UPDATE `med_hotel` SET `lan_P` = '68' WHERE `code`='JKB14' and med_hotel_no='521'<br>UPDATE `med_hotel` SET `lan_L` = '70' WHERE `code`='JKB23' and med_hotel_no='425'<br>UPDATE `med_hotel` SET `lan_P` = '78' WHERE `code`='JKB23' and med_hotel_no='425'<br>UPDATE `med_hotel` SET `lan_L` = '69' WHERE `code`='JKG3' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `lan_P` = '90' WHERE `code`='JKG3' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `lan_L` = '11' WHERE `code`='JKG4' and med_hotel_no='206'<br>UPDATE `med_hotel` SET `lan_L` = '54' WHERE `code`='JKG4' and med_hotel_no='404'<br>UPDATE `med_hotel` SET `lan_P` = '12' WHERE `code`='JKG4' and med_hotel_no='206'<br>UPDATE `med_hotel` SET `lan_P` = '79' WHERE `code`='JKG4' and med_hotel_no='404'<br>UPDATE `med_hotel` SET `lan_L` = '74' WHERE `code`='JKG5' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `lan_P` = '98' WHERE `code`='JKG5' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `lan_L` = '68' WHERE `code`='JKG6' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `lan_P` = '81' WHERE `code`='JKG6' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `lan_L` = '72' WHERE `code`='JKG9' and med_hotel_no='423'<br>UPDATE `med_hotel` SET `lan_L` = '11' WHERE `code`='JKG9' and med_hotel_no='516'<br>UPDATE `med_hotel` SET `lan_P` = '68' WHERE `code`='JKG9' and med_hotel_no='423'<br>UPDATE `med_hotel` SET `lan_P` = '17' WHERE `code`='JKG9' and med_hotel_no='516'<br>UPDATE `med_hotel` SET `lan_L` = '95' WHERE `code`='JKG10' and med_hotel_no='411'<br>UPDATE `med_hotel` SET `lan_P` = '91' WHERE `code`='JKG10' and med_hotel_no='411'<br>UPDATE `med_hotel` SET `lan_L` = '42' WHERE `code`='JKG15' and med_hotel_no='320'<br>UPDATE `med_hotel` SET `lan_L` = '42' WHERE `code`='JKG15' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `lan_L` = '4' WHERE `code`='JKG15' and med_hotel_no='416'<br>UPDATE `med_hotel` SET `lan_P` = '53' WHERE `code`='JKG15' and med_hotel_no='320'<br>UPDATE `med_hotel` SET `lan_P` = '41' WHERE `code`='JKG15' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `lan_P` = '7' WHERE `code`='JKG15' and med_hotel_no='416'<br>UPDATE `med_hotel` SET `lan_L` = '80' WHERE `code`='JKG16' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `lan_P` = '73' WHERE `code`='JKG16' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `lan_L` = '95' WHERE `code`='JKG17' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `lan_P` = '108' WHERE `code`='JKG17' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `lan_L` = '107' WHERE `code`='JKG19' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `lan_P` = '123' WHERE `code`='JKG19' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `lan_L` = '21' WHERE `code`='JKG20' and med_hotel_no='208'<br>UPDATE `med_hotel` SET `lan_L` = '10' WHERE `code`='JKG20' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `lan_P` = '30' WHERE `code`='JKG20' and med_hotel_no='208'<br>UPDATE `med_hotel` SET `lan_P` = '17' WHERE `code`='JKG20' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `lan_L` = '35' WHERE `code`='JKG21' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `lan_L` = '62' WHERE `code`='JKG21' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `lan_P` = '33' WHERE `code`='JKG21' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `lan_P` = '68' WHERE `code`='JKG21' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `lan_L` = '31' WHERE `code`='JKG23' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `lan_L` = '30' WHERE `code`='JKG23' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `lan_P` = '41' WHERE `code`='JKG23' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `lan_P` = '41' WHERE `code`='JKG23' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `lan_L` = '35' WHERE `code`='JKG26' and med_hotel_no='301'<br>UPDATE `med_hotel` SET `lan_L` = '4' WHERE `code`='JKG26' and med_hotel_no='519'<br>UPDATE `med_hotel` SET `lan_P` = '51' WHERE `code`='JKG26' and med_hotel_no='301'<br>UPDATE `med_hotel` SET `lan_P` = '6' WHERE `code`='JKG26' and med_hotel_no='519'<br>UPDATE `med_hotel` SET `lan_L` = '14' WHERE `code`='JKG30' and med_hotel_no='324'<br>UPDATE `med_hotel` SET `lan_L` = '41' WHERE `code`='JKG30' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `lan_P` = '24' WHERE `code`='JKG30' and med_hotel_no='324'<br>UPDATE `med_hotel` SET `lan_P` = '55' WHERE `code`='JKG30' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `lan_L` = '62' WHERE `code`='JKG32' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `lan_P` = '96' WHERE `code`='JKG32' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `lan_L` = '90' WHERE `code`='JKS5' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `lan_P` = '110' WHERE `code`='JKS5' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `lan_L` = '89' WHERE `code`='JKS6' and med_hotel_no='516'<br>UPDATE `med_hotel` SET `lan_P` = '95' WHERE `code`='JKS6' and med_hotel_no='516'<br>UPDATE `med_hotel` SET `lan_L` = '87' WHERE `code`='JKS8' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `lan_P` = '105' WHERE `code`='JKS8' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `lan_L` = '80' WHERE `code`='JKS11' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `lan_P` = '106' WHERE `code`='JKS11' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `lan_L` = '72' WHERE `code`='JKS15' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `lan_P` = '76' WHERE `code`='JKS15' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `lan_L` = '13' WHERE `code`='JKS17' and med_hotel_no='405'<br>UPDATE `med_hotel` SET `lan_L` = '52' WHERE `code`='JKS17' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `lan_P` = '19' WHERE `code`='JKS17' and med_hotel_no='405'<br>UPDATE `med_hotel` SET `lan_P` = '63' WHERE `code`='JKS17' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `lan_L` = '21' WHERE `code`='JKS28' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `lan_P` = '24' WHERE `code`='JKS28' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `lan_L` = '81' WHERE `code`='KJT2' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `lan_P` = '103' WHERE `code`='KJT2' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `lan_L` = '90' WHERE `code`='KJT8' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `lan_P` = '103' WHERE `code`='KJT8' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `lan_L` = '68' WHERE `code`='KJT10' and med_hotel_no='502'<br>UPDATE `med_hotel` SET `lan_P` = '84' WHERE `code`='KJT10' and med_hotel_no='502'<br>UPDATE `med_hotel` SET `lan_L` = '78' WHERE `code`='KJT12' and med_hotel_no='503'<br>UPDATE `med_hotel` SET `lan_P` = '59' WHERE `code`='KJT12' and med_hotel_no='503'<br>UPDATE `med_hotel` SET `lan_L` = '8' WHERE `code`='KJT16' and med_hotel_no='206'<br>UPDATE `med_hotel` SET `lan_L` = '1' WHERE `code`='KJT16' and med_hotel_no='314'<br>UPDATE `med_hotel` SET `lan_L` = '70' WHERE `code`='KJT16' and med_hotel_no='411'<br>UPDATE `med_hotel` SET `lan_P` = '5' WHERE `code`='KJT16' and med_hotel_no='206'<br>UPDATE `med_hotel` SET `lan_P` = '4' WHERE `code`='KJT16' and med_hotel_no='314'<br>UPDATE `med_hotel` SET `lan_P` = '83' WHERE `code`='KJT16' and med_hotel_no='411'<br>UPDATE `med_hotel` SET `lan_L` = '41' WHERE `code`='KJT17' and med_hotel_no='313'<br>UPDATE `med_hotel` SET `lan_L` = '25' WHERE `code`='KJT17' and med_hotel_no='425'<br>UPDATE `med_hotel` SET `lan_P` = '50' WHERE `code`='KJT17' and med_hotel_no='313'<br>UPDATE `med_hotel` SET `lan_P` = '32' WHERE `code`='KJT17' and med_hotel_no='425'<br>UPDATE `med_hotel` SET `lan_L` = '48' WHERE `code`='KJT19' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `lan_L` = '10' WHERE `code`='KJT19' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `lan_P` = '59' WHERE `code`='KJT19' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `lan_P` = '15' WHERE `code`='KJT19' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `lan_L` = '26' WHERE `code`='KJT20' and med_hotel_no='306'<br>UPDATE `med_hotel` SET `lan_L` = '52' WHERE `code`='KJT20' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `lan_P` = '33' WHERE `code`='KJT20' and med_hotel_no='306'<br>UPDATE `med_hotel` SET `lan_P` = '54' WHERE `code`='KJT20' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `lan_L` = '79' WHERE `code`='KJT22' and med_hotel_no='515'<br>UPDATE `med_hotel` SET `lan_P` = '103' WHERE `code`='KJT22' and med_hotel_no='515'<br>UPDATE `med_hotel` SET `lan_L` = '67' WHERE `code`='KJT28' and med_hotel_no='520'<br>UPDATE `med_hotel` SET `lan_P` = '58' WHERE `code`='KJT28' and med_hotel_no='520'<br>UPDATE `med_hotel` SET `lan_L` = '52' WHERE `code`='KJT31' and med_hotel_no='323'<br>UPDATE `med_hotel` SET `lan_L` = '56' WHERE `code`='KJT31' and med_hotel_no='417'<br>UPDATE `med_hotel` SET `lan_P` = '41' WHERE `code`='KJT31' and med_hotel_no='323'<br>UPDATE `med_hotel` SET `lan_P` = '61' WHERE `code`='KJT31' and med_hotel_no='417'<br>UPDATE `med_hotel` SET `lan_L` = '3' WHERE `code`='KJT32' and med_hotel_no='404'<br>UPDATE `med_hotel` SET `lan_L` = '62' WHERE `code`='KJT32' and med_hotel_no='405'<br>UPDATE `med_hotel` SET `lan_P` = '2' WHERE `code`='KJT32' and med_hotel_no='404'<br>UPDATE `med_hotel` SET `lan_P` = '69' WHERE `code`='KJT32' and med_hotel_no='405'<br>UPDATE `med_hotel` SET `lan_L` = '45' WHERE `code`='KJT33' and med_hotel_no='322'<br>UPDATE `med_hotel` SET `lan_L` = '10' WHERE `code`='KJT33' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `lan_P` = '33' WHERE `code`='KJT33' and med_hotel_no='322'<br>UPDATE `med_hotel` SET `lan_P` = '10' WHERE `code`='KJT33' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `lan_L` = '56' WHERE `code`='KJT35' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `lan_P` = '67' WHERE `code`='KJT35' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `lan_L` = '19' WHERE `code`='KJT37' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `lan_L` = '40' WHERE `code`='KJT37' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `lan_P` = '16' WHERE `code`='KJT37' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `lan_P` = '50' WHERE `code`='KJT37' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `lan_L` = '57' WHERE `code`='KJT38' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `lan_P` = '65' WHERE `code`='KJT38' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `lan_L` = '12' WHERE `code`='KJT40' and med_hotel_no='304'<br>UPDATE `med_hotel` SET `lan_L` = '38' WHERE `code`='KJT40' and med_hotel_no='308'<br>UPDATE `med_hotel` SET `lan_L` = '4' WHERE `code`='KJT40' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `lan_P` = '16' WHERE `code`='KJT40' and med_hotel_no='304'<br>UPDATE `med_hotel` SET `lan_P` = '41' WHERE `code`='KJT40' and med_hotel_no='308'<br>UPDATE `med_hotel` SET `lan_P` = '4' WHERE `code`='KJT40' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `lan_L` = '44' WHERE `code`='KNO5' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `lan_P` = '82' WHERE `code`='KNO5' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `lan_L` = '8' WHERE `code`='KNO9' and med_hotel_no='222'<br>UPDATE `med_hotel` SET `lan_L` = '33' WHERE `code`='KNO9' and med_hotel_no='223'<br>UPDATE `med_hotel` SET `lan_P` = '34' WHERE `code`='KNO9' and med_hotel_no='222'<br>UPDATE `med_hotel` SET `lan_P` = '55' WHERE `code`='KNO9' and med_hotel_no='223'<br>UPDATE `med_hotel` SET `lan_L` = '46' WHERE `code`='KNO12' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `lan_P` = '71' WHERE `code`='KNO12' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `lan_L` = '55' WHERE `code`='KNO13' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `lan_P` = '76' WHERE `code`='KNO13' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `lan_L` = '31' WHERE `code`='KNO15' and med_hotel_no='409'<br>UPDATE `med_hotel` SET `lan_L` = '31' WHERE `code`='KNO15' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `lan_P` = '51' WHERE `code`='KNO15' and med_hotel_no='409'<br>UPDATE `med_hotel` SET `lan_P` = '29' WHERE `code`='KNO15' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `lan_L` = '2' WHERE `code`='LOP5' and med_hotel_no='0'<br>UPDATE `med_hotel` SET `lan_L` = '16' WHERE `code`='LOP5' and med_hotel_no='208'<br>UPDATE `med_hotel` SET `lan_L` = '16' WHERE `code`='LOP5' and med_hotel_no='213'<br>UPDATE `med_hotel` SET `lan_L` = '35' WHERE `code`='LOP5' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `lan_P` = '1' WHERE `code`='LOP5' and med_hotel_no='0'<br>UPDATE `med_hotel` SET `lan_P` = '19' WHERE `code`='LOP5' and med_hotel_no='208'<br>UPDATE `med_hotel` SET `lan_P` = '19' WHERE `code`='LOP5' and med_hotel_no='213'<br>UPDATE `med_hotel` SET `lan_P` = '40' WHERE `code`='LOP5' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `lan_L` = '69' WHERE `code`='LOP9' and med_hotel_no='405'<br>UPDATE `med_hotel` SET `lan_L` = '11' WHERE `code`='LOP9' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `lan_P` = '2' WHERE `code`='LOP9' and med_hotel_no='404'<br>UPDATE `med_hotel` SET `lan_P` = '66' WHERE `code`='LOP9' and med_hotel_no='405'<br>UPDATE `med_hotel` SET `lan_P` = '6' WHERE `code`='LOP9' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `lan_L` = '95' WHERE `code`='LOP14' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `lan_L` = '8' WHERE `code`='LOP14' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `lan_P` = '76' WHERE `code`='LOP14' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `lan_P` = '11' WHERE `code`='LOP14' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `lan_L` = '69' WHERE `code`='LOP15' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `lan_P` = '73' WHERE `code`='LOP15' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `lan_L` = '29' WHERE `code`='PDG3' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `lan_L` = '72' WHERE `code`='PDG3' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `lan_P` = '42' WHERE `code`='PDG3' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `lan_P` = '99' WHERE `code`='PDG3' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `lan_L` = '95' WHERE `code`='PDG4' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `lan_P` = '105' WHERE `code`='PDG4' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `lan_L` = '80' WHERE `code`='PDG5' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `lan_P` = '132' WHERE `code`='PDG5' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `lan_L` = '9' WHERE `code`='PDG6' and med_hotel_no='325'<br>UPDATE `med_hotel` SET `lan_L` = '61' WHERE `code`='PDG6' and med_hotel_no='407'<br>UPDATE `med_hotel` SET `lan_P` = '18' WHERE `code`='PDG6' and med_hotel_no='325'<br>UPDATE `med_hotel` SET `lan_P` = '101' WHERE `code`='PDG6' and med_hotel_no='407'<br>UPDATE `med_hotel` SET `lan_L` = '24' WHERE `code`='PDG9' and med_hotel_no='308'<br>UPDATE `med_hotel` SET `lan_L` = '6' WHERE `code`='PDG9' and med_hotel_no='317'<br>UPDATE `med_hotel` SET `lan_P` = '50' WHERE `code`='PDG9' and med_hotel_no='308'<br>UPDATE `med_hotel` SET `lan_P` = '15' WHERE `code`='PDG9' and med_hotel_no='317'<br>UPDATE `med_hotel` SET `lan_L` = '65' WHERE `code`='PDG12' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `lan_P` = '110' WHERE `code`='PDG12' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `lan_L` = '91' WHERE `code`='PLM3' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `lan_P` = '87' WHERE `code`='PLM3' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `lan_L` = '71' WHERE `code`='PLM8' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `lan_P` = '66' WHERE `code`='PLM8' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `lan_L` = '50' WHERE `code`='PLM9' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `lan_L` = '31' WHERE `code`='PLM9' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `lan_P` = '46' WHERE `code`='PLM9' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `lan_P` = '48' WHERE `code`='PLM9' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `lan_L` = '55' WHERE `code`='PLM16' and med_hotel_no='116'<br>UPDATE `med_hotel` SET `lan_L` = '3' WHERE `code`='PLM16' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `lan_P` = '69' WHERE `code`='PLM16' and med_hotel_no='116'<br>UPDATE `med_hotel` SET `lan_P` = '3' WHERE `code`='PLM16' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `lan_L` = '72' WHERE `code`='SOC8' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `lan_P` = '62' WHERE `code`='SOC8' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `lan_L` = '11' WHERE `code`='SOC10' and med_hotel_no='213'<br>UPDATE `med_hotel` SET `lan_L` = '57' WHERE `code`='SOC10' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `lan_P` = '22' WHERE `code`='SOC10' and med_hotel_no='213'<br>UPDATE `med_hotel` SET `lan_P` = '69' WHERE `code`='SOC10' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `lan_L` = '13' WHERE `code`='SOC12' and med_hotel_no='313'<br>UPDATE `med_hotel` SET `lan_L` = '42' WHERE `code`='SOC12' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `lan_P` = '18' WHERE `code`='SOC12' and med_hotel_no='313'<br>UPDATE `med_hotel` SET `lan_P` = '48' WHERE `code`='SOC12' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `lan_L` = '2' WHERE `code`='SOC14' and med_hotel_no='208'<br>UPDATE `med_hotel` SET `lan_L` = '26' WHERE `code`='SOC14' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `lan_L` = '25' WHERE `code`='SOC14' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `lan_P` = '1' WHERE `code`='SOC14' and med_hotel_no='208'<br>UPDATE `med_hotel` SET `lan_P` = '32' WHERE `code`='SOC14' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `lan_P` = '33' WHERE `code`='SOC14' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `lan_L` = '89' WHERE `code`='SOC16' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `lan_P` = '78' WHERE `code`='SOC16' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `lan_L` = '71' WHERE `code`='SOC18' and med_hotel_no='420'<br>UPDATE `med_hotel` SET `lan_P` = '74' WHERE `code`='SOC18' and med_hotel_no='420'<br>UPDATE `med_hotel` SET `lan_L` = '79' WHERE `code`='SOC19' and med_hotel_no='421'<br>UPDATE `med_hotel` SET `lan_P` = '84' WHERE `code`='SOC19' and med_hotel_no='421'<br>UPDATE `med_hotel` SET `lan_L` = '66' WHERE `code`='SOC20' and med_hotel_no='421'<br>UPDATE `med_hotel` SET `lan_P` = '69' WHERE `code`='SOC20' and med_hotel_no='421'<br>UPDATE `med_hotel` SET `lan_L` = '51' WHERE `code`='SOC22' and med_hotel_no='405'<br>UPDATE `med_hotel` SET `lan_L` = '31' WHERE `code`='SOC22' and med_hotel_no='416'<br>UPDATE `med_hotel` SET `lan_P` = '55' WHERE `code`='SOC22' and med_hotel_no='405'<br>UPDATE `med_hotel` SET `lan_P` = '33' WHERE `code`='SOC22' and med_hotel_no='416'<br>UPDATE `med_hotel` SET `lan_L` = '70' WHERE `code`='SOC33' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `lan_P` = '74' WHERE `code`='SOC33' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `lan_L` = '18' WHERE `code`='SOC34' and med_hotel_no='314'<br>UPDATE `med_hotel` SET `lan_L` = '14' WHERE `code`='SOC34' and med_hotel_no='321'<br>UPDATE `med_hotel` SET `lan_L` = '38' WHERE `code`='SOC34' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `lan_P` = '18' WHERE `code`='SOC34' and med_hotel_no='314'<br>UPDATE `med_hotel` SET `lan_P` = '18' WHERE `code`='SOC34' and med_hotel_no='321'<br>UPDATE `med_hotel` SET `lan_P` = '42' WHERE `code`='SOC34' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `lan_L` = '11' WHERE `code`='SOC35' and med_hotel_no='313'<br>UPDATE `med_hotel` SET `lan_L` = '54' WHERE `code`='SOC35' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `lan_P` = '10' WHERE `code`='SOC35' and med_hotel_no='313'<br>UPDATE `med_hotel` SET `lan_P` = '42' WHERE `code`='SOC35' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `lan_L` = '48' WHERE `code`='SOC39' and med_hotel_no='509'<br>UPDATE `med_hotel` SET `lan_P` = '66' WHERE `code`='SOC39' and med_hotel_no='509'<br>UPDATE `med_hotel` SET `lan_L` = '63' WHERE `code`='SOC40' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `lan_P` = '77' WHERE `code`='SOC40' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `lan_L` = '30' WHERE `code`='SOC41' and med_hotel_no='109'<br>UPDATE `med_hotel` SET `lan_L` = '30' WHERE `code`='SOC41' and med_hotel_no='407'<br>UPDATE `med_hotel` SET `lan_P` = '42' WHERE `code`='SOC41' and med_hotel_no='109'<br>UPDATE `med_hotel` SET `lan_P` = '25' WHERE `code`='SOC41' and med_hotel_no='407'<br>UPDATE `med_hotel` SET `lan_L` = '32' WHERE `code`='SOC42' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `lan_L` = '30' WHERE `code`='SOC42' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `lan_L` = '3' WHERE `code`='SOC42' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `lan_P` = '30' WHERE `code`='SOC42' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `lan_P` = '33' WHERE `code`='SOC42' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `lan_P` = '2' WHERE `code`='SOC42' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `lan_L` = '8' WHERE `code`='SOC43' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `lan_L` = '43' WHERE `code`='SOC43' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `lan_P` = '9' WHERE `code`='SOC43' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `lan_P` = '51' WHERE `code`='SOC43' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `lan_L` = '85' WHERE `code`='SOC44' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `lan_P` = '91' WHERE `code`='SOC44' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `lan_L` = '70' WHERE `code`='SOC46' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `lan_P` = '64' WHERE `code`='SOC46' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `lan_P` = '1' WHERE `code`='SOC46' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `lan_L` = '1' WHERE `code`='SOC47' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `lan_L` = '39' WHERE `code`='SOC47' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `lan_P` = '2' WHERE `code`='SOC47' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `lan_P` = '37' WHERE `code`='SOC47' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `lan_L` = '75' WHERE `code`='SOC48' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `lan_P` = '82' WHERE `code`='SOC48' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `lan_L` = '64' WHERE `code`='SOC50' and med_hotel_no='409'<br>UPDATE `med_hotel` SET `lan_P` = '81' WHERE `code`='SOC50' and med_hotel_no='409'<br>UPDATE `med_hotel` SET `lan_L` = '56' WHERE `code`='SOC52' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `lan_P` = '66' WHERE `code`='SOC52' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `lan_L` = '63' WHERE `code`='SOC53' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `lan_P` = '69' WHERE `code`='SOC53' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `lan_L` = '83' WHERE `code`='SOC55' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `lan_P` = '90' WHERE `code`='SOC55' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `lan_L` = '82' WHERE `code`='SOC61' and med_hotel_no='519'<br>UPDATE `med_hotel` SET `lan_P` = '89' WHERE `code`='SOC61' and med_hotel_no='519'<br>UPDATE `med_hotel` SET `lan_L` = '58' WHERE `code`='SOC64' and med_hotel_no='312'<br>UPDATE `med_hotel` SET `lan_L` = '7' WHERE `code`='SOC64' and med_hotel_no='519'<br>UPDATE `med_hotel` SET `lan_P` = '68' WHERE `code`='SOC64' and med_hotel_no='312'<br>UPDATE `med_hotel` SET `lan_P` = '10' WHERE `code`='SOC64' and med_hotel_no='519'<br>UPDATE `med_hotel` SET `lan_L` = '75' WHERE `code`='SOC67' and med_hotel_no='508'<br>UPDATE `med_hotel` SET `lan_P` = '86' WHERE `code`='SOC67' and med_hotel_no='508'<br>UPDATE `med_hotel` SET `lan_L` = '76' WHERE `code`='SOC72' and med_hotel_no='513'<br>UPDATE `med_hotel` SET `lan_P` = '76' WHERE `code`='SOC72' and med_hotel_no='513'<br>UPDATE `med_hotel` SET `lan_L` = '11' WHERE `code`='SOC73' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `lan_L` = '67' WHERE `code`='SOC73' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `lan_P` = '8' WHERE `code`='SOC73' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `lan_P` = '82' WHERE `code`='SOC73' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `lan_L` = '69' WHERE `code`='SOC74' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `lan_P` = '74' WHERE `code`='SOC74' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `lan_L` = '87' WHERE `code`='SOC75' and med_hotel_no='409'<br>UPDATE `med_hotel` SET `lan_P` = '84' WHERE `code`='SOC75' and med_hotel_no='409'<br>UPDATE `med_hotel` SET `lan_L` = '52' WHERE `code`='SOC77' and med_hotel_no='409'<br>UPDATE `med_hotel` SET `lan_L` = '52' WHERE `code`='SOC77' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `lan_P` = '49' WHERE `code`='SOC77' and med_hotel_no='409'<br>UPDATE `med_hotel` SET `lan_P` = '46' WHERE `code`='SOC77' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `lan_L` = '84' WHERE `code`='SOC78' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `lan_P` = '89' WHERE `code`='SOC78' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `lan_L` = '82' WHERE `code`='SOC80' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `lan_P` = '73' WHERE `code`='SOC80' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `lan_L` = '83' WHERE `code`='SOC81' and med_hotel_no='311'<br>UPDATE `med_hotel` SET `lan_L` = '6' WHERE `code`='SOC81' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `lan_P` = '1' WHERE `code`='SOC81' and med_hotel_no='0'<br>UPDATE `med_hotel` SET `lan_P` = '87' WHERE `code`='SOC81' and med_hotel_no='311'<br>UPDATE `med_hotel` SET `lan_P` = '3' WHERE `code`='SOC81' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `lan_L` = '40' WHERE `code`='SUB2' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `lan_P` = '43' WHERE `code`='SUB2' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `lan_L` = '73' WHERE `code`='SUB4' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `lan_P` = '74' WHERE `code`='SUB4' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `lan_L` = '32' WHERE `code`='SUB8' and med_hotel_no='202'<br>UPDATE `med_hotel` SET `lan_L` = '18' WHERE `code`='SUB8' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `lan_P` = '30' WHERE `code`='SUB8' and med_hotel_no='202'<br>UPDATE `med_hotel` SET `lan_P` = '13' WHERE `code`='SUB8' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `lan_L` = '41' WHERE `code`='SUB9' and med_hotel_no='320'<br>UPDATE `med_hotel` SET `lan_L` = '31' WHERE `code`='SUB9' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `lan_P` = '24' WHERE `code`='SUB9' and med_hotel_no='320'<br>UPDATE `med_hotel` SET `lan_P` = '33' WHERE `code`='SUB9' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `lan_L` = '30' WHERE `code`='SUB12' and med_hotel_no='202'<br>UPDATE `med_hotel` SET `lan_L` = '39' WHERE `code`='SUB12' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `lan_P` = '41' WHERE `code`='SUB12' and med_hotel_no='202'<br>UPDATE `med_hotel` SET `lan_P` = '41' WHERE `code`='SUB12' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `lan_L` = '14' WHERE `code`='SUB17' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `lan_L` = '56' WHERE `code`='SUB17' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `lan_P` = '17' WHERE `code`='SUB17' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `lan_P` = '60' WHERE `code`='SUB17' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `lan_L` = '37' WHERE `code`='SUB19' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `lan_L` = '37' WHERE `code`='SUB19' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `lan_P` = '54' WHERE `code`='SUB19' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `lan_P` = '39' WHERE `code`='SUB19' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `lan_L` = '99' WHERE `code`='SUB20' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `lan_P` = '102' WHERE `code`='SUB20' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `lan_L` = '23' WHERE `code`='SUB21' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `lan_L` = '79' WHERE `code`='SUB21' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `lan_P` = '26' WHERE `code`='SUB21' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `lan_P` = '76' WHERE `code`='SUB21' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `lan_L` = '37' WHERE `code`='SUB24' and med_hotel_no='118'<br>UPDATE `med_hotel` SET `lan_L` = '47' WHERE `code`='SUB24' and med_hotel_no='119'<br>UPDATE `med_hotel` SET `lan_P` = '42' WHERE `code`='SUB24' and med_hotel_no='118'<br>UPDATE `med_hotel` SET `lan_P` = '57' WHERE `code`='SUB24' and med_hotel_no='119'<br>UPDATE `med_hotel` SET `lan_L` = '98' WHERE `code`='SUB25' and med_hotel_no='421'<br>UPDATE `med_hotel` SET `lan_P` = '88' WHERE `code`='SUB25' and med_hotel_no='421'<br>UPDATE `med_hotel` SET `lan_L` = '1' WHERE `code`='SUB27' and med_hotel_no='205'<br>UPDATE `med_hotel` SET `lan_L` = '73' WHERE `code`='SUB27' and med_hotel_no='516'<br>UPDATE `med_hotel` SET `lan_P` = '1' WHERE `code`='SUB27' and med_hotel_no='205'<br>UPDATE `med_hotel` SET `lan_P` = '76' WHERE `code`='SUB27' and med_hotel_no='516'<br>UPDATE `med_hotel` SET `lan_L` = '67' WHERE `code`='SUB28' and med_hotel_no='325'<br>UPDATE `med_hotel` SET `lan_L` = '8' WHERE `code`='SUB28' and med_hotel_no='407'<br>UPDATE `med_hotel` SET `lan_P` = '48' WHERE `code`='SUB28' and med_hotel_no='325'<br>UPDATE `med_hotel` SET `lan_P` = '13' WHERE `code`='SUB28' and med_hotel_no='407'<br>UPDATE `med_hotel` SET `lan_L` = '53' WHERE `code`='SUB31' and med_hotel_no='115'<br>UPDATE `med_hotel` SET `lan_L` = '26' WHERE `code`='SUB31' and med_hotel_no='416'<br>UPDATE `med_hotel` SET `lan_P` = '62' WHERE `code`='SUB31' and med_hotel_no='115'<br>UPDATE `med_hotel` SET `lan_P` = '23' WHERE `code`='SUB31' and med_hotel_no='416'<br>UPDATE `med_hotel` SET `lan_L` = '71' WHERE `code`='SUB37' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `lan_P` = '77' WHERE `code`='SUB37' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `lan_L` = '83' WHERE `code`='SUB38' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `lan_P` = '78' WHERE `code`='SUB38' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `lan_L` = '33' WHERE `code`='SUB41' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `lan_L` = '66' WHERE `code`='SUB41' and med_hotel_no='511'<br>UPDATE `med_hotel` SET `lan_P` = '15' WHERE `code`='SUB41' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `lan_P` = '55' WHERE `code`='SUB41' and med_hotel_no='511'<br>UPDATE `med_hotel` SET `lan_L` = '74' WHERE `code`='SUB42' and med_hotel_no='404'<br>UPDATE `med_hotel` SET `lan_P` = '58' WHERE `code`='SUB42' and med_hotel_no='404'<br>UPDATE `med_hotel` SET `lan_L` = '6' WHERE `code`='SUB45' and med_hotel_no='317'<br>UPDATE `med_hotel` SET `lan_L` = '15' WHERE `code`='SUB45' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `lan_P` = '4' WHERE `code`='SUB45' and med_hotel_no='317'<br>UPDATE `med_hotel` SET `lan_P` = '18' WHERE `code`='SUB45' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `lan_L` = '38' WHERE `code`='SUB46' and med_hotel_no='217'<br>UPDATE `med_hotel` SET `lan_L` = '32' WHERE `code`='SUB46' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `lan_P` = '36' WHERE `code`='SUB46' and med_hotel_no='217'<br>UPDATE `med_hotel` SET `lan_P` = '37' WHERE `code`='SUB46' and med_hotel_no='410'<br>UPDATE `med_hotel` SET `lan_L` = '35' WHERE `code`='SUB49' and med_hotel_no='407'<br>UPDATE `med_hotel` SET `lan_L` = '24' WHERE `code`='SUB49' and med_hotel_no='425'<br>UPDATE `med_hotel` SET `lan_P` = '22' WHERE `code`='SUB49' and med_hotel_no='407'<br>UPDATE `med_hotel` SET `lan_P` = '29' WHERE `code`='SUB49' and med_hotel_no='425'<br>UPDATE `med_hotel` SET `lan_L` = '59' WHERE `code`='SUB50' and med_hotel_no='509'<br>UPDATE `med_hotel` SET `lan_P` = '63' WHERE `code`='SUB50' and med_hotel_no='509'<br>UPDATE `med_hotel` SET `lan_L` = '52' WHERE `code`='SUB53' and med_hotel_no='507'<br>UPDATE `med_hotel` SET `lan_P` = '63' WHERE `code`='SUB53' and med_hotel_no='507'<br>UPDATE `med_hotel` SET `lan_L` = '29' WHERE `code`='SUB54' and med_hotel_no='407'<br>UPDATE `med_hotel` SET `lan_L` = '25' WHERE `code`='SUB54' and med_hotel_no='425'<br>UPDATE `med_hotel` SET `lan_P` = '30' WHERE `code`='SUB54' and med_hotel_no='407'<br>UPDATE `med_hotel` SET `lan_P` = '24' WHERE `code`='SUB54' and med_hotel_no='425'<br>UPDATE `med_hotel` SET `lan_L` = '45' WHERE `code`='SUB55' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `lan_P` = '54' WHERE `code`='SUB55' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `lan_L` = '1' WHERE `code`='SUB56' and med_hotel_no='0'<br>UPDATE `med_hotel` SET `lan_L` = '23' WHERE `code`='SUB56' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `lan_L` = '20' WHERE `code`='SUB56' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `lan_P` = '36' WHERE `code`='SUB56' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `lan_P` = '25' WHERE `code`='SUB56' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `lan_L` = '65' WHERE `code`='SUB57' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `lan_P` = '65' WHERE `code`='SUB57' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `lan_L` = '53' WHERE `code`='SUB60' and med_hotel_no='322'<br>UPDATE `med_hotel` SET `lan_P` = '63' WHERE `code`='SUB60' and med_hotel_no='322'<br>UPDATE `med_hotel` SET `lan_L` = '54' WHERE `code`='SUB62' and med_hotel_no='324'<br>UPDATE `med_hotel` SET `lan_L` = '1' WHERE `code`='SUB62' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `lan_L` = '6' WHERE `code`='SUB62' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `lan_P` = '71' WHERE `code`='SUB62' and med_hotel_no='324'<br>UPDATE `med_hotel` SET `lan_P` = '10' WHERE `code`='SUB62' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `lan_L` = '59' WHERE `code`='SUB65' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `lan_P` = '59' WHERE `code`='SUB65' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `lan_L` = '11' WHERE `code`='SUB68' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `lan_L` = '48' WHERE `code`='SUB68' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `lan_P` = '12' WHERE `code`='SUB68' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `lan_P` = '46' WHERE `code`='SUB68' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `lan_L` = '68' WHERE `code`='SUB71' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `lan_P` = '1' WHERE `code`='SUB71' and med_hotel_no='210'<br>UPDATE `med_hotel` SET `lan_P` = '64' WHERE `code`='SUB71' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `lan_L` = '54' WHERE `code`='SUB73' and med_hotel_no='207'<br>UPDATE `med_hotel` SET `lan_L` = '2' WHERE `code`='SUB73' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `lan_P` = '42' WHERE `code`='SUB73' and med_hotel_no='207'<br>UPDATE `med_hotel` SET `lan_P` = '8' WHERE `code`='SUB73' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `lan_L` = '46' WHERE `code`='SUB74' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `lan_P` = '54' WHERE `code`='SUB74' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `lan_L` = '8' WHERE `code`='SUB77' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `lan_L` = '50' WHERE `code`='SUB77' and med_hotel_no='507'<br>UPDATE `med_hotel` SET `lan_P` = '4' WHERE `code`='SUB77' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `lan_P` = '50' WHERE `code`='SUB77' and med_hotel_no='507'<br>UPDATE `med_hotel` SET `lan_L` = '72' WHERE `code`='SUB85' and med_hotel_no='510'<br>UPDATE `med_hotel` SET `lan_P` = '50' WHERE `code`='SUB85' and med_hotel_no='510'<br>UPDATE `med_hotel` SET `lan_L` = '60' WHERE `code`='SUB90' and med_hotel_no='508'<br>UPDATE `med_hotel` SET `lan_P` = '45' WHERE `code`='SUB90' and med_hotel_no='508'<br>UPDATE `med_hotel` SET `lan_L` = '64' WHERE `code`='SUB92' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `lan_P` = '58' WHERE `code`='SUB92' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `lan_L` = '29' WHERE `code`='SUB96' and med_hotel_no='511'<br>UPDATE `med_hotel` SET `lan_L` = '50' WHERE `code`='SUB96' and med_hotel_no='515'<br>UPDATE `med_hotel` SET `lan_P` = '19' WHERE `code`='SUB96' and med_hotel_no='511'<br>UPDATE `med_hotel` SET `lan_P` = '41' WHERE `code`='SUB96' and med_hotel_no='515'<br>UPDATE `med_hotel` SET `lan_L` = '57' WHERE `code`='SUB99' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `lan_P` = '63' WHERE `code`='SUB99' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `lan_L` = '28' WHERE `code`='SUB104' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `lan_L` = '59' WHERE `code`='SUB104' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `lan_P` = '20' WHERE `code`='SUB104' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `lan_P` = '61' WHERE `code`='SUB104' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `lan_L` = '94' WHERE `code`='SUB106' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `lan_P` = '92' WHERE `code`='SUB106' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `lan_L` = '77' WHERE `code`='SUB109' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `lan_P` = '88' WHERE `code`='SUB109' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `lan_L` = '68' WHERE `code`='SUB113' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `lan_L` = '8' WHERE `code`='SUB113' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `lan_P` = '72' WHERE `code`='SUB113' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `lan_P` = '8' WHERE `code`='SUB113' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `lan_L` = '22' WHERE `code`='UPG2' and med_hotel_no='507'<br>UPDATE `med_hotel` SET `lan_P` = '35' WHERE `code`='UPG2' and med_hotel_no='507'<br>UPDATE `med_hotel` SET `lan_L` = '10' WHERE `code`='UPG5' and med_hotel_no='404'<br>UPDATE `med_hotel` SET `lan_L` = '28' WHERE `code`='UPG5' and med_hotel_no='405'<br>UPDATE `med_hotel` SET `lan_P` = '25' WHERE `code`='UPG5' and med_hotel_no='404'<br>UPDATE `med_hotel` SET `lan_P` = '45' WHERE `code`='UPG5' and med_hotel_no='405'<br>UPDATE `med_hotel` SET `lan_L` = '3' WHERE `code`='UPG6' and med_hotel_no='324'<br>UPDATE `med_hotel` SET `lan_L` = '40' WHERE `code`='UPG6' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `lan_P` = '3' WHERE `code`='UPG6' and med_hotel_no='324'<br>UPDATE `med_hotel` SET `lan_P` = '50' WHERE `code`='UPG6' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `lan_L` = '38' WHERE `code`='UPG8' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `lan_P` = '74' WHERE `code`='UPG8' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `lan_L` = '39' WHERE `code`='UPG9' and med_hotel_no='102'<br>UPDATE `med_hotel` SET `lan_P` = '63' WHERE `code`='UPG9' and med_hotel_no='102'<br>UPDATE `med_hotel` SET `lan_L` = '75' WHERE `code`='UPG13' and med_hotel_no='416'<br>UPDATE `med_hotel` SET `lan_P` = '80' WHERE `code`='UPG13' and med_hotel_no='416'<br>UPDATE `med_hotel` SET `lan_L` = '8' WHERE `code`='UPG18' and med_hotel_no='324'<br>UPDATE `med_hotel` SET `lan_L` = '39' WHERE `code`='UPG18' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `lan_P` = '3' WHERE `code`='UPG18' and med_hotel_no='324'<br>UPDATE `med_hotel` SET `lan_P` = '68' WHERE `code`='UPG18' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `lan_L` = '19' WHERE `code`='UPG19' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `lan_L` = '30' WHERE `code`='UPG19' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `lan_P` = '24' WHERE `code`='UPG19' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `lan_P` = '42' WHERE `code`='UPG19' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `lan_L` = '2' WHERE `code`='UPG21' and med_hotel_no='0'<br>UPDATE `med_hotel` SET `lan_L` = '7' WHERE `code`='UPG21' and med_hotel_no='201'<br>UPDATE `med_hotel` SET `lan_L` = '21' WHERE `code`='UPG21' and med_hotel_no='507'<br>UPDATE `med_hotel` SET `lan_L` = '22' WHERE `code`='UPG21' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `lan_P` = '11' WHERE `code`='UPG21' and med_hotel_no='201'<br>UPDATE `med_hotel` SET `lan_P` = '32' WHERE `code`='UPG21' and med_hotel_no='507'<br>UPDATE `med_hotel` SET `lan_P` = '43' WHERE `code`='UPG21' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `lan_L` = '52' WHERE `code`='UPG26' and med_hotel_no='425'<br>UPDATE `med_hotel` SET `lan_P` = '70' WHERE `code`='UPG26' and med_hotel_no='425'<br>UPDATE `med_hotel` SET `lan_L` = '1' WHERE `code`='UPG27' and med_hotel_no='0'<br>UPDATE `med_hotel` SET `lan_L` = '8' WHERE `code`='UPG27' and med_hotel_no='306'<br>UPDATE `med_hotel` SET `lan_L` = '45' WHERE `code`='UPG27' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `lan_P` = '15' WHERE `code`='UPG27' and med_hotel_no='306'<br>UPDATE `med_hotel` SET `lan_P` = '45' WHERE `code`='UPG27' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `lan_L` = '56' WHERE `code`='UPG36' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `lan_P` = '74' WHERE `code`='UPG36' and med_hotel_no='403'<br>UPDATE `med_hotel` SET `lan_L` = '5' WHERE `code`='UPG37' and med_hotel_no='318'<br>UPDATE `med_hotel` SET `lan_L` = '48' WHERE `code`='UPG37' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `lan_P` = '5' WHERE `code`='UPG37' and med_hotel_no='318'<br>UPDATE `med_hotel` SET `lan_P` = '71' WHERE `code`='UPG37' and med_hotel_no='415'<br>UPDATE `med_hotel` SET `lan_L` = '17' WHERE `code`='UPG39' and med_hotel_no='306'<br>UPDATE `med_hotel` SET `lan_L` = '41' WHERE `code`='UPG39' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `lan_P` = '14' WHERE `code`='UPG39' and med_hotel_no='306'<br>UPDATE `med_hotel` SET `lan_P` = '63' WHERE `code`='UPG39' and med_hotel_no='401'<br>UPDATE `med_hotel` SET `lan_L` = '19' WHERE `code`='UPG42' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `lan_L` = '23' WHERE `code`='UPG42' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `lan_P` = '31' WHERE `code`='UPG42' and med_hotel_no='418'<br>UPDATE `med_hotel` SET `lan_P` = '29' WHERE `code`='UPG42' and med_hotel_no='419'<br>UPDATE `med_hotel` SET `lan_L` = '26' WHERE `code`='UPG43' and med_hotel_no='304'<br>UPDATE `med_hotel` SET `lan_L` = '10' WHERE `code`='UPG43' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `lan_P` = '35' WHERE `code`='UPG43' and med_hotel_no='304'<br>UPDATE `med_hotel` SET `lan_P` = '5' WHERE `code`='UPG43' and med_hotel_no='412'<br>UPDATE `med_hotel` SET `lan_L` = '78' WHERE `code`='YIA5' and med_hotel_no='102'<br>UPDATE `med_hotel` SET `lan_P` = '75' WHERE `code`='YIA5' and med_hotel_no='102'<br>UPDATE `med_hotel` SET `lan_P` = '1' WHERE `code`='YIA5' and med_hotel_no='405'<br>UPDATE `med_hotel` SET `lan_L` = '80' WHERE `code`='YIA10' and med_hotel_no='424'<br>UPDATE `med_hotel` SET `lan_P` = '72' WHERE `code`='YIA10' and med_hotel_no='424'<br>UPDATE `med_hotel` SET `lan_L` = '105' WHERE `code`='YIA13' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `lan_P` = '91' WHERE `code`='YIA13' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `lan_L` = '43' WHERE `code`='YIA15' and med_hotel_no='425'<br>UPDATE `med_hotel` SET `lan_L` = '57' WHERE `code`='YIA15' and med_hotel_no='507'<br>UPDATE `med_hotel` SET `lan_P` = '45' WHERE `code`='YIA15' and med_hotel_no='425'<br>UPDATE `med_hotel` SET `lan_P` = '59' WHERE `code`='YIA15' and med_hotel_no='507'<br>UPDATE `med_hotel` SET `lan_L` = '81' WHERE `code`='YIA16' and med_hotel_no='519'<br>UPDATE `med_hotel` SET `lan_P` = '103' WHERE `code`='YIA16' and med_hotel_no='519'<br>UPDATE `med_hotel` SET `lan_L` = '21' WHERE `code`='YIA17' and med_hotel_no='301'<br>UPDATE `med_hotel` SET `lan_L` = '57' WHERE `code`='YIA17' and med_hotel_no='520'<br>UPDATE `med_hotel` SET `lan_P` = '19' WHERE `code`='YIA17' and med_hotel_no='301'<br>UPDATE `med_hotel` SET `lan_P` = '67' WHERE `code`='YIA17' and med_hotel_no='520'<br>UPDATE `med_hotel` SET `lan_L` = '40' WHERE `code`='YIA19' and med_hotel_no='215'<br>UPDATE `med_hotel` SET `lan_L` = '31' WHERE `code`='YIA19' and med_hotel_no='515'<br>UPDATE `med_hotel` SET `lan_P` = '41' WHERE `code`='YIA19' and med_hotel_no='215'<br>UPDATE `med_hotel` SET `lan_P` = '36' WHERE `code`='YIA19' and med_hotel_no='515'<br>UPDATE `med_hotel` SET `lan_L` = '34' WHERE `code`='YIA21' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `lan_L` = '40' WHERE `code`='YIA21' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `lan_P` = '33' WHERE `code`='YIA21' and med_hotel_no='413'<br>UPDATE `med_hotel` SET `lan_P` = '39' WHERE `code`='YIA21' and med_hotel_no='414'<br>UPDATE `med_hotel` SET `lan_L` = '102' WHERE `code`='YIA22' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `lan_P` = '78' WHERE `code`='YIA22' and med_hotel_no='514'<br>