UPDATE `med_hotel` SET `dirawat` = '2' WHERE `code`='BDJ6' and med_hotel_no='511'<br>UPDATE `med_hotel` SET `dirawat` = '1' WHERE `code`='BDJ6' and med_hotel_no='518'<br>UPDATE `med_hotel` SET `dirawat` = '2' WHERE `code`='BDJ19' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `dirawat` = '2' WHERE `code`='BTJ3' and med_hotel_no='422'<br>UPDATE `med_hotel` SET `dirawat` = '1' WHERE `code`='BTJ3' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `dirawat` = '1' WHERE `code`='BTJ11' and med_hotel_no='422'<br>UPDATE `med_hotel` SET `dirawat` = '2' WHERE `code`='BTJ11' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `dirawat` = '2' WHERE `code`='BTJ12' and med_hotel_no='208'<br>UPDATE `med_hotel` SET `dirawat` = '5' WHERE `code`='JKB3' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `dirawat` = '6' WHERE `code`='JKB14' and med_hotel_no='521'<br>UPDATE `med_hotel` SET `dirawat` = '2' WHERE `code`='JKG3' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `dirawat` = '3' WHERE `code`='JKG5' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `dirawat` = '3' WHERE `code`='JKG9' and med_hotel_no='423'<br>UPDATE `med_hotel` SET `dirawat` = '3' WHERE `code`='JKG17' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `dirawat` = '5' WHERE `code`='JKG19' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `dirawat` = '1' WHERE `code`='JKG20' and med_hotel_no='208'<br>UPDATE `med_hotel` SET `dirawat` = '1' WHERE `code`='JKG20' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `dirawat` = '1' WHERE `code`='JKG21' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `dirawat` = '2' WHERE `code`='JKG26' and med_hotel_no='301'<br>UPDATE `med_hotel` SET `dirawat` = '2' WHERE `code`='JKS8' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `dirawat` = '2' WHERE `code`='KJT8' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `dirawat` = '2' WHERE `code`='KJT22' and med_hotel_no='515'<br>UPDATE `med_hotel` SET `dirawat` = '2' WHERE `code`='KJT28' and med_hotel_no='520'<br>UPDATE `med_hotel` SET `dirawat` = '1' WHERE `code`='KJT35' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `dirawat` = '1' WHERE `code`='KNO12' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `dirawat` = '1' WHERE `code`='KNO13' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `dirawat` = '1' WHERE `code`='LOP5' and med_hotel_no='213'<br>UPDATE `med_hotel` SET `dirawat` = '3' WHERE `code`='LOP5' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `dirawat` = '1' WHERE `code`='LOP15' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `dirawat` = '2' WHERE `code`='PDG3' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `dirawat` = '5' WHERE `code`='PDG3' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `dirawat` = '3' WHERE `code`='PLM3' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `dirawat` = '2' WHERE `code`='PLM8' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `dirawat` = '3' WHERE `code`='PLM9' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `dirawat` = '2' WHERE `code`='SOC10' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `dirawat` = '1' WHERE `code`='SOC39' and med_hotel_no='509'<br>UPDATE `med_hotel` SET `dirawat` = '1' WHERE `code`='SOC47' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `dirawat` = '4' WHERE `code`='SOC47' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `dirawat` = '2' WHERE `code`='SOC52' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `dirawat` = '1' WHERE `code`='SOC57' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `dirawat` = '2' WHERE `code`='SOC61' and med_hotel_no='519'<br>UPDATE `med_hotel` SET `dirawat` = '1' WHERE `code`='SOC67' and med_hotel_no='508'<br>UPDATE `med_hotel` SET `dirawat` = '1' WHERE `code`='SOC72' and med_hotel_no='513'<br>UPDATE `med_hotel` SET `dirawat` = '1' WHERE `code`='SOC73' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `dirawat` = '2' WHERE `code`='SOC74' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `dirawat` = '3' WHERE `code`='SOC78' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `dirawat` = '2' WHERE `code`='SUB8' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `dirawat` = '1' WHERE `code`='SUB17' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `dirawat` = '1' WHERE `code`='SUB27' and med_hotel_no='516'<br>UPDATE `med_hotel` SET `dirawat` = '2' WHERE `code`='SUB41' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `dirawat` = '1' WHERE `code`='SUB41' and med_hotel_no='511'<br>UPDATE `med_hotel` SET `dirawat` = '1' WHERE `code`='SUB45' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `dirawat` = '2' WHERE `code`='SUB50' and med_hotel_no='509'<br>UPDATE `med_hotel` SET `dirawat` = '1' WHERE `code`='SUB53' and med_hotel_no='507'<br>UPDATE `med_hotel` SET `dirawat` = '2' WHERE `code`='SUB57' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `dirawat` = '1' WHERE `code`='SUB68' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `dirawat` = '1' WHERE `code`='SUB74' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `dirawat` = '1' WHERE `code`='SUB85' and med_hotel_no='510'<br>UPDATE `med_hotel` SET `dirawat` = '1' WHERE `code`='SUB90' and med_hotel_no='508'<br>UPDATE `med_hotel` SET `dirawat` = '2' WHERE `code`='SUB109' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `dirawat` = '3' WHERE `code`='UPG2' and med_hotel_no='507'<br>UPDATE `med_hotel` SET `dirawat` = '1' WHERE `code`='UPG21' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `dirawat` = '10' WHERE `code`='YIA13' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `dirawat` = '5' WHERE `code`='YIA16' and med_hotel_no='519'<br>UPDATE `med_hotel` SET `dirawat` = '2' WHERE `code`='YIA19' and med_hotel_no='215'<br>UPDATE `med_hotel` SET `dirawat` = '2' WHERE `code`='YIA19' and med_hotel_no='515'<br>UPDATE `med_hotel` SET `dirawat` = '1' 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`='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` = '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` = '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`='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`='PDG3' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `wafat` = '2' WHERE `code`='PLM9' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='SOC10' and med_hotel_no='501'<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`='SUB41' and med_hotel_no='511'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='UPG2' and med_hotel_no='507'<br>UPDATE `med_hotel` SET `wafat` = '1' WHERE `code`='UPG19' and med_hotel_no='506'<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`='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` = '128' WHERE `code`='BDJ6' and med_hotel_no='511'<br>UPDATE `med_hotel` SET `j_P` = '142' 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` = '158' WHERE `code`='BDJ13' and med_hotel_no='521'<br>UPDATE `med_hotel` SET `j_P` = '201' WHERE `code`='BDJ13' and med_hotel_no='521'<br>UPDATE `med_hotel` SET `j_P` = '1' WHERE `code`='BDJ17' and med_hotel_no='521'<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` = '127' WHERE `code`='BTH11' and med_hotel_no='517'<br>UPDATE `med_hotel` SET `j_P` = '146' 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` = '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` = '126' WHERE `code`='JKB3' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `j_P` = '157' 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` = '103' WHERE `code`='JKB4' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `j_P` = '125' WHERE `code`='JKB4' and med_hotel_no='523'<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` = '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` = '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` = '181' WHERE `code`='JKG9' and med_hotel_no='423'<br>UPDATE `med_hotel` SET `j_P` = '199' 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` = '203' WHERE `code`='JKG17' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `j_P` = '242' 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_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` = '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` = '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` = '208' WHERE `code`='KJT8' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `j_P` = '236' 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` = '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` = '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` = '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` = '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` = '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_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` = '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` = '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` = '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` = '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` = '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` = '119' WHERE `code`='SOC43' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `j_P` = '155' WHERE `code`='SOC43' and med_hotel_no='505'<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` = '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` = '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` = '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` = '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` = '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` = '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` = '171' WHERE `code`='SUB27' and med_hotel_no='516'<br>UPDATE `med_hotel` SET `j_P` = '204' WHERE `code`='SUB27' and med_hotel_no='516'<br>UPDATE `med_hotel` SET `j_L` = '65' WHERE `code`='SUB41' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `j_P` = '65' 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` = '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` = '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` = '164' WHERE `code`='SUB53' and med_hotel_no='507'<br>UPDATE `med_hotel` SET `j_P` = '216' WHERE `code`='SUB53' and med_hotel_no='507'<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` = '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_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` = '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` = '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` = '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` = '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` = '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` = '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` = '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` = '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` = '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` = '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` = '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` = '44' 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` = '34' WHERE `code`='JKB4' and med_hotel_no='523'<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` = '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` = '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` = '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` = '94' WHERE `code`='JKG17' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `lan_P` = '109' 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` = '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` = '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` = '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` = '91' WHERE `code`='KJT8' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `lan_P` = '102' 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` = '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` = '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` = '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` = '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` = '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`='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` = '28' 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` = '43' 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` = '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` = '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` = '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` = '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` = '8' WHERE `code`='SOC43' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `lan_L` = '44' 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` = '50' WHERE `code`='SOC43' and med_hotel_no='505'<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` = '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` = '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` = '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` = '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` = '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` = '1' WHERE `code`='SUB27' and med_hotel_no='205'<br>UPDATE `med_hotel` SET `lan_L` = '74' 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` = '75' WHERE `code`='SUB27' and med_hotel_no='516'<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` = '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` = '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` = '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` = '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` = '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` = '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` = '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` = '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` = '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` = '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>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='BDJ2' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='BDJ2' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='BDJ6' and med_hotel_no='511'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='BDJ6' and med_hotel_no='511'<br>UPDATE `med_hotel` SET `ptg_L` = '4' WHERE `code`='BDJ13' and med_hotel_no='521'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='BDJ19' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='BDJ19' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `ptg_L` = '2' WHERE `code`='BTH11' and med_hotel_no='517'<br>UPDATE `med_hotel` SET `ptg_P` = '2' WHERE `code`='BTH11' and med_hotel_no='517'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='BTJ3' and med_hotel_no='422'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='BTJ3' and med_hotel_no='422'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='BTJ11' and med_hotel_no='422'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='BTJ11' and med_hotel_no='422'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='BTJ12' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='BTJ12' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `ptg_L` = '2' WHERE `code`='JKB3' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `ptg_P` = '2' WHERE `code`='JKB3' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `ptg_L` = '2' WHERE `code`='JKB4' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `ptg_P` = '2' WHERE `code`='JKB4' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='JKB14' and med_hotel_no='521'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='JKB14' and med_hotel_no='521'<br>UPDATE `med_hotel` SET `ptg_L` = '1' WHERE `code`='JKG3' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `ptg_P` = '3' WHERE `code`='JKG3' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='JKG5' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='JKG5' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `ptg_L` = '2' WHERE `code`='JKG9' and med_hotel_no='423'<br>UPDATE `med_hotel` SET `ptg_P` = '2' WHERE `code`='JKG9' and med_hotel_no='423'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='JKG17' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='JKG17' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `ptg_L` = '2' WHERE `code`='JKG19' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `ptg_P` = '2' WHERE `code`='JKG19' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `ptg_L` = '1' WHERE `code`='JKG20' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `ptg_P` = '3' WHERE `code`='JKG20' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='JKG21' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='JKG21' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `ptg_L` = '2' WHERE `code`='JKG26' and med_hotel_no='301'<br>UPDATE `med_hotel` SET `ptg_P` = '2' WHERE `code`='JKG26' and med_hotel_no='301'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='JKS6' and med_hotel_no='516'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='JKS6' and med_hotel_no='516'<br>UPDATE `med_hotel` SET `ptg_L` = '2' WHERE `code`='JKS8' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `ptg_P` = '2' WHERE `code`='JKS8' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `ptg_L` = '1' WHERE `code`='JKS11' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `ptg_P` = '3' WHERE `code`='JKS11' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='KJT2' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='KJT2' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='KJT8' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='KJT8' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='KJT10' and med_hotel_no='502'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='KJT10' and med_hotel_no='502'<br>UPDATE `med_hotel` SET `ptg_L` = '4' WHERE `code`='KJT12' and med_hotel_no='503'<br>UPDATE `med_hotel` SET `ptg_L` = '1' WHERE `code`='KJT22' and med_hotel_no='515'<br>UPDATE `med_hotel` SET `ptg_P` = '3' WHERE `code`='KJT22' and med_hotel_no='515'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='KJT28' and med_hotel_no='520'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='KJT28' and med_hotel_no='520'<br>UPDATE `med_hotel` SET `ptg_L` = '2' WHERE `code`='KJT35' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `ptg_P` = '2' WHERE `code`='KJT35' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `ptg_L` = '1' WHERE `code`='KJT37' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `ptg_P` = '3' WHERE `code`='KJT37' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='KNO5' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='KNO5' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='KNO12' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='KNO12' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `ptg_L` = '2' WHERE `code`='KNO13' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `ptg_P` = '2' WHERE `code`='KNO13' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='LOP5' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='LOP5' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='LOP15' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='LOP15' and med_hotel_no='523'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='PDG3' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='PDG3' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `ptg_L` = '2' WHERE `code`='PLM3' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `ptg_P` = '2' WHERE `code`='PLM3' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='PLM8' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='PLM8' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `ptg_L` = '2' WHERE `code`='PLM9' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `ptg_P` = '2' WHERE `code`='PLM9' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `ptg_L` = '2' WHERE `code`='SOC10' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `ptg_P` = '2' WHERE `code`='SOC10' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='SOC34' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='SOC34' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='SOC39' and med_hotel_no='509'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='SOC39' and med_hotel_no='509'<br>UPDATE `med_hotel` SET `ptg_L` = '1' WHERE `code`='SOC43' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `ptg_P` = '3' WHERE `code`='SOC43' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='SOC47' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='SOC47' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `ptg_L` = '1' WHERE `code`='SOC48' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `ptg_P` = '3' WHERE `code`='SOC48' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='SOC52' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='SOC52' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `ptg_L` = '1' WHERE `code`='SOC57' and med_hotel_no='308'<br>UPDATE `med_hotel` SET `ptg_P` = '3' WHERE `code`='SOC57' and med_hotel_no='308'<br>UPDATE `med_hotel` SET `ptg_L` = '2' WHERE `code`='SOC61' and med_hotel_no='519'<br>UPDATE `med_hotel` SET `ptg_P` = '2' WHERE `code`='SOC61' and med_hotel_no='519'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='SOC64' and med_hotel_no='312'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='SOC64' and med_hotel_no='312'<br>UPDATE `med_hotel` SET `ptg_L` = '1' WHERE `code`='SOC67' and med_hotel_no='508'<br>UPDATE `med_hotel` SET `ptg_P` = '3' WHERE `code`='SOC67' and med_hotel_no='508'<br>UPDATE `med_hotel` SET `ptg_L` = '1' WHERE `code`='SOC72' and med_hotel_no='513'<br>UPDATE `med_hotel` SET `ptg_P` = '2' WHERE `code`='SOC72' and med_hotel_no='513'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='SOC73' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='SOC73' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `ptg_L` = '1' WHERE `code`='SOC74' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `ptg_P` = '3' WHERE `code`='SOC74' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `ptg_L` = '4' WHERE `code`='SOC78' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `ptg_L` = '2' WHERE `code`='SUB8' and med_hotel_no='202'<br>UPDATE `med_hotel` SET `ptg_P` = '2' WHERE `code`='SUB8' and med_hotel_no='202'<br>UPDATE `med_hotel` SET `ptg_L` = '2' WHERE `code`='SUB17' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `ptg_P` = '2' WHERE `code`='SUB17' and med_hotel_no='505'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='SUB19' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='SUB19' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='SUB27' and med_hotel_no='516'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='SUB27' and med_hotel_no='516'<br>UPDATE `med_hotel` SET `ptg_L` = '1' WHERE `code`='SUB41' and med_hotel_no='511'<br>UPDATE `med_hotel` SET `ptg_P` = '3' WHERE `code`='SUB41' and med_hotel_no='511'<br>UPDATE `med_hotel` SET `ptg_L` = '2' WHERE `code`='SUB45' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `ptg_P` = '2' WHERE `code`='SUB45' and med_hotel_no='522'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='SUB50' and med_hotel_no='509'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='SUB50' and med_hotel_no='509'<br>UPDATE `med_hotel` SET `ptg_L` = '2' WHERE `code`='SUB53' and med_hotel_no='507'<br>UPDATE `med_hotel` SET `ptg_P` = '2' WHERE `code`='SUB53' and med_hotel_no='507'<br>UPDATE `med_hotel` SET `ptg_L` = '2' WHERE `code`='SUB56' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `ptg_P` = '2' WHERE `code`='SUB56' and med_hotel_no='504'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='SUB57' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='SUB57' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='SUB68' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='SUB68' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='SUB74' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='SUB74' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `ptg_L` = '4' WHERE `code`='SUB77' and med_hotel_no='507'<br>UPDATE `med_hotel` SET `ptg_L` = '2' WHERE `code`='SUB85' and med_hotel_no='510'<br>UPDATE `med_hotel` SET `ptg_P` = '2' WHERE `code`='SUB85' and med_hotel_no='510'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='SUB90' and med_hotel_no='508'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='SUB90' and med_hotel_no='508'<br>UPDATE `med_hotel` SET `ptg_L` = '2' WHERE `code`='SUB92' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `ptg_P` = '2' WHERE `code`='SUB92' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `ptg_L` = '4' WHERE `code`='SUB96' and med_hotel_no='515'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='SUB104' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='SUB104' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `ptg_L` = '2' WHERE `code`='SUB109' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `ptg_P` = '2' WHERE `code`='SUB109' and med_hotel_no='501'<br>UPDATE `med_hotel` SET `ptg_L` = '1' WHERE `code`='SUB113' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `ptg_P` = '3' WHERE `code`='SUB113' and med_hotel_no='426'<br>UPDATE `med_hotel` SET `ptg_L` = '1' WHERE `code`='UPG2' and med_hotel_no='507'<br>UPDATE `med_hotel` SET `ptg_P` = '3' WHERE `code`='UPG2' and med_hotel_no='507'<br>UPDATE `med_hotel` SET `ptg_L` = '2' WHERE `code`='UPG19' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `ptg_P` = '2' WHERE `code`='UPG19' and med_hotel_no='506'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='UPG21' and med_hotel_no='0'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='UPG21' and med_hotel_no='512'<br>UPDATE `med_hotel` SET `ptg_L` = '2' WHERE `code`='YIA13' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `ptg_P` = '2' WHERE `code`='YIA13' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='YIA15' and med_hotel_no='507'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='YIA15' and med_hotel_no='507'<br>UPDATE `med_hotel` SET `ptg_L` = '2' WHERE `code`='YIA16' and med_hotel_no='519'<br>UPDATE `med_hotel` SET `ptg_P` = '2' WHERE `code`='YIA16' and med_hotel_no='519'<br>UPDATE `med_hotel` SET `ptg_L` = '3' WHERE `code`='YIA17' and med_hotel_no='520'<br>UPDATE `med_hotel` SET `ptg_P` = '1' WHERE `code`='YIA17' and med_hotel_no='520'<br>UPDATE `med_hotel` SET `ptg_L` = '1' WHERE `code`='YIA19' and med_hotel_no='215'<br>UPDATE `med_hotel` SET `ptg_P` = '3' WHERE `code`='YIA19' and med_hotel_no='215'<br>UPDATE `med_hotel` SET `ptg_L` = '2' WHERE `code`='YIA22' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `ptg_P` = '2' WHERE `code`='YIA22' and med_hotel_no='514'<br>UPDATE `med_hotel` SET `syarikah` = 'BTG' WHERE `emb`='BDJ'<br>UPDATE `med_hotel` SET `syarikah` = 'BTG' WHERE `emb`='BTH'<br>UPDATE `med_hotel` SET `syarikah` = 'RKN' WHERE `emb`='BTJ'<br>UPDATE `med_hotel` SET `syarikah` = 'RKN' WHERE `emb`='JKB'<br>UPDATE `med_hotel` SET `syarikah` = 'BTG' WHERE `emb`='JKG'<br>UPDATE `med_hotel` SET `syarikah` = 'RKN' WHERE `emb`='JKS'<br>UPDATE `med_hotel` SET `syarikah` = 'RKN' WHERE `emb`='KJT'<br>UPDATE `med_hotel` SET `syarikah` = 'RKN' WHERE `emb`='KNO'<br>UPDATE `med_hotel` SET `syarikah` = 'BTG' WHERE `emb`='LOP'<br>UPDATE `med_hotel` SET `syarikah` = 'BTG' WHERE `emb`='PDG'<br>UPDATE `med_hotel` SET `syarikah` = 'RKN' WHERE `emb`='PLM'<br>UPDATE `med_hotel` SET `syarikah` = 'RKN' WHERE `emb`='SOC'<br>UPDATE `med_hotel` SET `syarikah` = 'BTG' WHERE `emb`='SUB'<br>UPDATE `med_hotel` SET `syarikah` = 'RKN' WHERE `emb`='UPG'<br>UPDATE `med_hotel` SET `syarikah` = 'BTG' WHERE `emb`='YIA'<br>