
UPDATE `#__js_job_fieldsordering` SET `cannotsearch`='0', `search_visitor` = '1', `search_user` = '1' WHERE `id`='337';

INSERT INTO `#__js_job_config` (`configname`, `configvalue`, `configfor`) VALUES ('show_total_number_of_jobs','1','job');
INSERT INTO `#__js_job_config` (`configname`, `configvalue`, `configfor`) VALUES ('vis_jobsbycities','1','jscontrolpanel');
INSERT INTO `#__js_job_config` (`configname`, `configvalue`, `configfor`) VALUES ('jobsbycities','1','jscontrolpanel');
INSERT INTO `#__js_job_config` (`configname`, `configvalue`, `configfor`) VALUES ('jobsbycities_jobcount','1','default');
INSERT INTO `#__js_job_config` (`configname`, `configvalue`, `configfor`) VALUES ('jobsbycities_countryname','1','default');

INSERT INTO `#__js_job_slug` (`id`, `slug`, `defaultslug`, `filename`, `description`, `status`) VALUES (64, 'jobs-by-cities', 'jobs-by-cities', 'jobsbycities', 'slug for jobs by cities page', 1);

REPLACE INTO `#__js_job_config` (`configname`, `configvalue`, `configfor`) VALUES ('productcode','jsjobs','default');
REPLACE INTO `#__js_job_config` (`configname`, `configvalue`, `configfor`) VALUES ('versioncode','1.0.7','default');

UPDATE `#__js_job_cities` set latitude = '24.8614622' ,longitude = '67.0099388' WHERE id = 69785; 
UPDATE `#__js_job_cities` set latitude = '31.5546061' ,longitude = '74.3571581' WHERE id = 69786; 
UPDATE `#__js_job_cities` set latitude = '31.4187142' ,longitude = '73.0791073' WHERE id = 69787; 
UPDATE `#__js_job_cities` set latitude = '33.598394' ,longitude = '73.0441352' WHERE id = 69788; 
UPDATE `#__js_job_cities` set latitude = '30.1983807' ,longitude = '71.4687028' WHERE id = 69789; 
UPDATE `#__js_job_cities` set latitude = '25.3817509' ,longitude = '68.3693897' WHERE id = 69790; 
UPDATE `#__js_job_cities` set latitude = '32.1543783' ,longitude = '74.1842254' WHERE id = 69791; 
UPDATE `#__js_job_cities` set latitude = '34.0149748' ,longitude = '71.5804899' WHERE id = 69792; 
UPDATE `#__js_job_cities` set latitude = '30.1829713' ,longitude = '66.998734' WHERE id = 69793; 
UPDATE `#__js_job_cities` set latitude = '33.5145095' ,longitude = '73.8993095' WHERE id = 69794; 
UPDATE `#__js_job_cities` set latitude = '33.7293882' ,longitude = '73.0931461' WHERE id = 69795; 
UPDATE `#__js_job_cities` set latitude = '29.3957215' ,longitude = '71.6833331' WHERE id = 69796; 
UPDATE `#__js_job_cities` set latitude = '32.0837411' ,longitude = '72.6718596' WHERE id = 69797; 
UPDATE `#__js_job_cities` set latitude = '32.4924769' ,longitude = '74.5310403' WHERE id = 69798; 
UPDATE `#__js_job_cities` set latitude = '27.7066038' ,longitude = '68.8481971' WHERE id = 69799; 
UPDATE `#__js_job_cities` set latitude = '27.563994' ,longitude = '68.2151309' WHERE id = 69800; 
UPDATE `#__js_job_cities` set latitude = '31.7166617' ,longitude = '73.9850243' WHERE id = 69801; 
UPDATE `#__js_job_cities` set latitude = '32.9816247' ,longitude = '74.0711359' WHERE id = 69802; 
UPDATE `#__js_job_cities` set latitude = '31.2654657' ,longitude = '72.3123725' WHERE id = 69803; 
UPDATE `#__js_job_cities` set latitude = '32.5711443' ,longitude = '74.075005' WHERE id = 69804; 
UPDATE `#__js_job_cities` set latitude = '34.2001138' ,longitude = '72.0508013' WHERE id = 69805; 
UPDATE `#__js_job_cities` set latitude = '31.1164769' ,longitude = '74.4493744' WHERE id = 69806; 
UPDATE `#__js_job_cities` set latitude = '30.0324857' ,longitude = '70.6402456' WHERE id = 69807; 
UPDATE `#__js_job_cities` set latitude = '30.6611813' ,longitude = '73.1085756' WHERE id = 69808; 
UPDATE `#__js_job_cities` set latitude = '26.2442211' ,longitude = '68.4100338' WHERE id = 69809; 
UPDATE `#__js_job_cities` set latitude = '34.7717466' ,longitude = '72.3601512' WHERE id = 69810; 
UPDATE `#__js_job_cities` set latitude = '30.8090496' ,longitude = '73.4508207' WHERE id = 69811; 
UPDATE `#__js_job_cities` set latitude = '25.5291051' ,longitude = '69.0135706' WHERE id = 69812; 
UPDATE `#__js_job_cities` set latitude = '31.7285872' ,longitude = '72.9814877' WHERE id = 69813; 
UPDATE `#__js_job_cities` set latitude = '31.9755071' ,longitude = '74.223802' WHERE id = 69814; 
UPDATE `#__js_job_cities` set latitude = '28.3083941' ,longitude = '70.133673' WHERE id = 69815; 
UPDATE `#__js_job_cities` set latitude = '30.1577112' ,longitude = '72.6739675' WHERE id = 69816; 
UPDATE `#__js_job_cities` set latitude = '28.2829348' ,longitude = '68.4364877' WHERE id = 69817; 
UPDATE `#__js_job_cities` set latitude = '30.0736087' ,longitude = '71.1804988' WHERE id = 69818; 
UPDATE `#__js_job_cities` set latitude = '31.8024737' ,longitude = '74.2590148' WHERE id = 69819; 
UPDATE `#__js_job_cities` set latitude = '32.9405479' ,longitude = '73.7276293' WHERE id = 69820; 
UPDATE `#__js_job_cities` set latitude = '27.9570397' ,longitude = '68.637993' WHERE id = 69821; 
UPDATE `#__js_job_cities` set latitude = '32.0716989' ,longitude = '73.6857291' WHERE id = 69822; 
UPDATE `#__js_job_cities` set latitude = '33.5834014' ,longitude = '71.4332193' WHERE id = 69823; 
UPDATE `#__js_job_cities` set latitude = '28.6491211' ,longitude = '70.6514213' WHERE id = 69824; 
UPDATE `#__js_job_cities` set latitude = '26.7340581' ,longitude = '67.7794817' WHERE id = 69825; 
UPDATE `#__js_job_cities` set latitude = '31.1467905' ,longitude = '72.6852207' WHERE id = 69826; 
UPDATE `#__js_job_cities` set latitude = '32.5881687' ,longitude = '73.4973431' WHERE id = 69827; 
UPDATE `#__js_job_cities` set latitude = '25.4570396' ,longitude = '68.7214593' WHERE id = 69828; 
UPDATE `#__js_job_cities` set latitude = '32.334984' ,longitude = '74.3528822' WHERE id = 69829; 
UPDATE `#__js_job_cities` set latitude = '30.3524565' ,longitude = '73.3885526' WHERE id = 69830; 
UPDATE `#__js_job_cities` set latitude = '29.9991825' ,longitude = '73.2588441' WHERE id = 69831; 
UPDATE `#__js_job_cities` set latitude = '25.7685204' ,longitude = '68.6625448' WHERE id = 69832; 
UPDATE `#__js_job_cities` set latitude = '27.5299523' ,longitude = '68.7581419' WHERE id = 69833; 
UPDATE `#__js_job_cities` set latitude = '29.9092481' ,longitude = '73.0529761' WHERE id = 69834; 
UPDATE `#__js_job_cities` set latitude = '31.3328773' ,longitude = '73.4175824' WHERE id = 69835; 
UPDATE `#__js_job_cities` set latitude = '29.1411551' ,longitude = '71.2577233' WHERE id = 69836; 
UPDATE `#__js_job_cities` set latitude = '30.0452462' ,longitude = '72.3488721' WHERE id = 69837; 
UPDATE `#__js_job_cities` set latitude = '30.7221821' ,longitude = '72.6446829' WHERE id = 69838; 
UPDATE `#__js_job_cities` set latitude = '30.4615356' ,longitude = '70.9695403' WHERE id = 69839; 
UPDATE `#__js_job_cities` set latitude = '32.3054193' ,longitude = '72.3482384' WHERE id = 69840; 
UPDATE `#__js_job_cities` set latitude = '32.4386254' ,longitude = '74.1169906' WHERE id = 69841; 
UPDATE `#__js_job_cities` set latitude = '31.8423621' ,longitude = '70.8952337' WHERE id = 69842; 
UPDATE `#__js_job_cities` set latitude = '32.9310991' ,longitude = '72.8550863' WHERE id = 69843; 
UPDATE `#__js_job_cities` set latitude = '34.1164164' ,longitude = '72.4642776' WHERE id = 69844; 
UPDATE `#__js_job_cities` set latitude = '29.5363422' ,longitude = '71.6317359' WHERE id = 69845; 
UPDATE `#__js_job_cities` set latitude = '34.0055051' ,longitude = '72.0082966' WHERE id = 69846; 
UPDATE `#__js_job_cities` set latitude = '34.1494329' ,longitude = '71.7427812' WHERE id = 69847; 
UPDATE `#__js_job_cities` set latitude = '32.6494831' ,longitude = '74.0553484' WHERE id = 69848; 
UPDATE `#__js_job_cities` set latitude = '32.5788912' ,longitude = '71.560526' WHERE id = 69849; 
UPDATE `#__js_job_cities` set latitude = '30.907255' ,longitude = '66.4509585' WHERE id = 69850; 
UPDATE `#__js_job_cities` set latitude = '28.2425261' ,longitude = '69.183451' WHERE id = 69851; 
UPDATE `#__js_job_cities` set latitude = '29.690255' ,longitude = '72.5382293' WHERE id = 69852; 
UPDATE `#__js_job_cities` set latitude = '30.2978601' ,longitude = '73.0582368' WHERE id = 69853; 
UPDATE `#__js_job_cities` set latitude = '31.205974' ,longitude = '73.9418603' WHERE id = 69854; 
UPDATE `#__js_job_cities` set latitude = '33.7687344' ,longitude = '72.362147' WHERE id = 69855; 
UPDATE `#__js_job_cities` set latitude = '30.5391319' ,longitude = '72.6919814' WHERE id = 69856; 
UPDATE `#__js_job_cities` set latitude = '31.6265504' ,longitude = '71.0616623' WHERE id = 69857; 
UPDATE `#__js_job_cities` set latitude = '32.8269819' ,longitude = '73.8459847' WHERE id = 69858; 
UPDATE `#__js_job_cities` set latitude = '30.9647503' ,longitude = '70.9399349' WHERE id = 69859; 
UPDATE `#__js_job_cities` set latitude = '27.5859189' ,longitude = '68.0060183' WHERE id = 69860; 
UPDATE `#__js_job_cities` set latitude = '26.6591938' ,longitude = '68.0060183' WHERE id = 69861; 
UPDATE `#__js_job_cities` set latitude = '30.4361208' ,longitude = '72.3488721' WHERE id = 69862; 
UPDATE `#__js_job_cities` set latitude = '26.0080546' ,longitude = '63.0383059' WHERE id = 69863; 
UPDATE `#__js_job_cities` set latitude = '27.848312' ,longitude = '67.9106318' WHERE id = 69864; 
UPDATE `#__js_job_cities` set latitude = '32.275141' ,longitude = '72.9047136' WHERE id = 69865; 
UPDATE `#__js_job_cities` set latitude = '30.6673293' ,longitude = '73.6595075' WHERE id = 69866; 
UPDATE `#__js_job_cities` set latitude = '24.6557191' ,longitude = '68.837241' WHERE id = 69867; 
UPDATE `#__js_job_cities` set latitude = '27.8144456' ,longitude = '69.1089444' WHERE id = 69868; 
UPDATE `#__js_job_cities` set latitude = '25.3540609' ,longitude = '68.2683443' WHERE id = 69869; 
UPDATE `#__js_job_cities` set latitude = '25.1228751' ,longitude = '68.5350842' WHERE id = 69870; 
UPDATE `#__js_job_cities` set latitude = '29.612972' ,longitude = '73.1408613' WHERE id = 69871; 
UPDATE `#__js_job_cities` set latitude = '31.0249269' ,longitude = '73.8479317' WHERE id = 69872; 
UPDATE `#__js_job_cities` set latitude = '29.6437628' ,longitude = '71.9164217' WHERE id = 69873; 
UPDATE `#__js_job_cities` set latitude = '33.2512989' ,longitude = '73.3060197' WHERE id = 69874; 
UPDATE `#__js_job_cities` set latitude = '28.4922222' ,longitude = '64.69' WHERE id = 69875; 
UPDATE `#__js_job_cities` set latitude = '31.7451915' ,longitude = '73.8330844' WHERE id = 69876; 
UPDATE `#__js_job_cities` set latitude = '30.9726705' ,longitude = '72.4849861' WHERE id = 69877; 
UPDATE `#__js_job_cities` set latitude = '32.0994756' ,longitude = '74.8747353' WHERE id = 69878; 
UPDATE `#__js_job_cities` set latitude = '30.8318336' ,longitude = '72.0764437' WHERE id = 69879; 
UPDATE `#__js_job_cities` set latitude = '25.9268081' ,longitude = '68.6260691' WHERE id = 69880; 
UPDATE `#__js_job_cities` set latitude = '34.2185757' ,longitude = '71.5545911' WHERE id = 69881; 
UPDATE `#__js_job_cities` set latitude = '34.3338823' ,longitude = '73.2010622' WHERE id = 69882; 
UPDATE `#__js_job_cities` set latitude = '29.8764183' ,longitude = '71.3171162' WHERE id = 69883; 
UPDATE `#__js_job_cities` set latitude = '33.4687969' ,longitude = '72.1182872' WHERE id = 69884; 
UPDATE `#__js_job_cities` set latitude = '32.7037264' ,longitude = '73.9585169' WHERE id = 69885; 
UPDATE `#__js_job_cities` set latitude = '29.8042254' ,longitude = '72.1740413' WHERE id = 69886; 
UPDATE `#__js_job_cities` set latitude = '32.2642802' ,longitude = '75.1598723' WHERE id = 69887; 
UPDATE `#__js_job_cities` set latitude = '28.0006901' ,longitude = '69.3189399' WHERE id = 69888; 
UPDATE `#__js_job_cities` set latitude = '29.5395519' ,longitude = '67.8759078' WHERE id = 69889; 
UPDATE `#__js_job_cities` set latitude = '29.6459464' ,longitude = '70.5919357' WHERE id = 69890; 
UPDATE `#__js_job_cities` set latitude = '32.4785685' ,longitude = '74.3528822' WHERE id = 69891; 
UPDATE `#__js_job_cities` set latitude = '26.0444193' ,longitude = '68.9538789' WHERE id = 69892; 
UPDATE `#__js_job_cities` set latitude = '30.7355827' ,longitude = '73.8213213' WHERE id = 69893; 
UPDATE `#__js_job_cities` set latitude = '30.4010623' ,longitude = '71.8630625' WHERE id = 69894; 
UPDATE `#__js_job_cities` set latitude = '30.9673834' ,longitude = '73.9741874' WHERE id = 69895; 
UPDATE `#__js_job_cities` set latitude = '31.713381' ,longitude = '73.373016' WHERE id = 69896; 
UPDATE `#__js_job_cities` set latitude = '33.9959837' ,longitude = '72.9367618' WHERE id = 69897; 
UPDATE `#__js_job_cities` set latitude = '31.4507815' ,longitude = '73.7036514' WHERE id = 69898; 
UPDATE `#__js_job_cities` set latitude = '32.2639737' ,longitude = '74.6693186' WHERE id = 69899; 
UPDATE `#__js_job_cities` set latitude = '25.1986951' ,longitude = '62.3213153' WHERE id = 69900; 
UPDATE `#__js_job_cities` set latitude = '29.1017686' ,longitude = '70.3244659' WHERE id = 69901; 
UPDATE `#__js_job_cities` set latitude = '27.675196' ,longitude = '68.9003075' WHERE id = 69902; 
UPDATE `#__js_job_cities` set latitude = '31.3412607' ,longitude = '69.4486593' WHERE id = 69903; 
UPDATE `#__js_job_cities` set latitude = '25.0467638' ,longitude = '68.6558788' WHERE id = 69904; 
UPDATE `#__js_job_cities` set latitude = '33.8567701' ,longitude = '73.7588945' WHERE id = 69905; 
UPDATE `#__js_job_cities` set latitude = '32.2920892' ,longitude = '72.1919614' WHERE id = 69906; 
UPDATE `#__js_job_cities` set latitude = '28.0208426' ,longitude = '69.552937' WHERE id = 69907; 
UPDATE `#__js_job_cities` set latitude = '32.989724' ,longitude = '70.6038334' WHERE id = 69908; 
UPDATE `#__js_job_cities` set latitude = '31.8427075' ,longitude = '71.4358733' WHERE id = 69909; 
UPDATE `#__js_job_cities` set latitude = '25.8167566' ,longitude = '68.4233593' WHERE id = 69910; 
UPDATE `#__js_job_cities` set latitude = '27.8025876' ,longitude = '68.2892117' WHERE id = 69911; 
UPDATE `#__js_job_cities` set latitude = '32.2899398' ,longitude = '72.271908' WHERE id = 69913; 
UPDATE `#__js_job_cities` set latitude = '34.6137694' ,longitude = '71.9282781' WHERE id = 69914; 
UPDATE `#__js_job_cities` set latitude = '31.1687588' ,longitude = '74.1006772' WHERE id = 69915; 
UPDATE `#__js_job_cities` set latitude = '31.373857' ,longitude = '74.3675446' WHERE id = 69916; 
UPDATE `#__js_job_cities` set latitude = '32.1913216' ,longitude = '74.2324224' WHERE id = 69917; 
UPDATE `#__js_job_cities` set latitude = '33.8194868' ,longitude = '72.6890255' WHERE id = 69918; 
UPDATE `#__js_job_cities` set latitude = '32.9298214' ,longitude = '72.4198967' WHERE id = 69919; 
UPDATE `#__js_job_cities` set latitude = '30.7059921' ,longitude = '70.6484471' WHERE id = 69920; 
UPDATE `#__js_job_cities` set latitude = '24.7469887' ,longitude = '67.9255357' WHERE id = 69921; 
UPDATE `#__js_job_cities` set latitude = '32.9002189' ,longitude = '73.7590686' WHERE id = 69922; 
UPDATE `#__js_job_cities` set latitude = '28.1792746' ,longitude = '68.04477' WHERE id = 69923; 
UPDATE `#__js_job_cities` set latitude = '33.8558023' ,longitude = '72.3944135' WHERE id = 69924; 
UPDATE `#__js_job_cities` set latitude = '25.3614443' ,longitude = '69.7435857' WHERE id = 69925; 
UPDATE `#__js_job_cities` set latitude = '30.5779666' ,longitude = '73.8360251' WHERE id = 69926; 
UPDATE `#__js_job_cities` set latitude = '26.4234157' ,longitude = '67.8629399' WHERE id = 69927; 
UPDATE `#__js_job_cities` set latitude = '31.9661054' ,longitude = '73.977126' WHERE id = 69928; 
UPDATE `#__js_job_cities` set latitude = '29.193053' ,longitude = '72.8574558' WHERE id = 69929; 
UPDATE `#__js_job_cities` set latitude = '34.0465833' ,longitude = '73.1438116' WHERE id = 69930; 
UPDATE `#__js_job_cities` set latitude = '32.6417589' ,longitude = '73.7213063' WHERE id = 69931; 
UPDATE `#__js_job_cities` set latitude = '32.1581941' ,longitude = '74.115187' WHERE id = 69932; 
UPDATE `#__js_job_cities` set latitude = '34.0194023' ,longitude = '72.9135734' WHERE id = 69933; 
UPDATE `#__js_job_cities` set latitude = '31.1141733' ,longitude = '74.4292967' WHERE id = 69934; 
UPDATE `#__js_job_cities` set latitude = '32.2142959' ,longitude = '70.3777302' WHERE id = 69935; 
UPDATE `#__js_job_cities` set latitude = '32.1900283' ,longitude = '73.0257691' WHERE id = 69936; 
UPDATE `#__js_job_cities` set latitude = '31.0368217' ,longitude = '73.1379109' WHERE id = 69937; 
UPDATE `#__js_job_cities` set latitude = '30.7513979' ,longitude = '73.0294589' WHERE id = 69938; 
UPDATE `#__js_job_cities` set latitude = '30.3740712' ,longitude = '68.5902973' WHERE id = 69939; 
UPDATE `#__js_job_cities` set latitude = '29.5052835' ,longitude = '71.2220832' WHERE id = 69940; 
UPDATE `#__js_job_cities` set latitude = '34.0113944' ,longitude = '71.7941607' WHERE id = 69941; 
UPDATE `#__js_job_cities` set latitude = '31.5673242' ,longitude = '73.1828061' WHERE id = 69942; 
UPDATE `#__js_job_cities` set latitude = '30.8800345' ,longitude = '73.6003308' WHERE id = 69943; 
UPDATE `#__js_job_cities` set latitude = '34.0751141' ,longitude = '71.9875531' WHERE id = 69944; 
UPDATE `#__js_job_cities` set latitude = '32.6044506' ,longitude = '70.9130684' WHERE id = 69945; 
UPDATE `#__js_job_cities` set latitude = '34.065904' ,longitude = '72.6358134' WHERE id = 69946; 
UPDATE `#__js_job_cities` set latitude = '33.528665' ,longitude = '71.067605' WHERE id = 69947; 
UPDATE `#__js_job_cities` set latitude = '27.6321715' ,longitude = '68.5962593' WHERE id = 69948; 
UPDATE `#__js_job_cities` set latitude = '32.4525158' ,longitude = '71.4833652' WHERE id = 69949; 
UPDATE `#__js_job_cities` set latitude = '30.7654756' ,longitude = '72.4343685' WHERE id = 69950; 
UPDATE `#__js_job_cities` set latitude = '31.5215898' ,longitude = '73.2602441' WHERE id = 69951; 
UPDATE `#__js_job_cities` set latitude = '27.102101' ,longitude = '68.4150795' WHERE id = 69952; 
UPDATE `#__js_job_cities` set latitude = '31.8950469' ,longitude = '73.2706389' WHERE id = 69953; 
UPDATE `#__js_job_cities` set latitude = '32.5498983' ,longitude = '73.20281' WHERE id = 69954; 
UPDATE `#__js_job_cities` set latitude = '33.1796667' ,longitude = '72.7643901' WHERE id = 69955; 
UPDATE `#__js_job_cities` set latitude = '32.5498983' ,longitude = '73.20281' WHERE id = 69956; 
UPDATE `#__js_job_cities` set latitude = '28.2396296' ,longitude = '68.7755104' WHERE id = 69957; 
UPDATE `#__js_job_cities` set latitude = '33.2451991' ,longitude = '72.2659868' WHERE id = 69958; 
UPDATE `#__js_job_cities` set latitude = '28.8136245' ,longitude = '70.5145939' WHERE id = 69959; 
UPDATE `#__js_job_cities` set latitude = '29.8045422' ,longitude = '71.7405672' WHERE id = 69960; 
UPDATE `#__js_job_cities` set latitude = '27.352443' ,longitude = '68.5206879' WHERE id = 69961; 
UPDATE `#__js_job_cities` set latitude = '28.4323282' ,longitude = '69.5916659' WHERE id = 69962; 
UPDATE `#__js_job_cities` set latitude = '29.3881554' ,longitude = '70.9190132' WHERE id = 69963; 
UPDATE `#__js_job_cities` set latitude = '27.6670437' ,longitude = '68.3637381' WHERE id = 69964; 
UPDATE `#__js_job_cities` set latitude = '25.281566' ,longitude = '63.4036287' WHERE id = 69965; 
UPDATE `#__js_job_cities` set latitude = '31.8665471' ,longitude = '73.5019838' WHERE id = 69966; 
UPDATE `#__js_job_cities` set latitude = '32.630728' ,longitude = '73.0117665' WHERE id = 69968; 
UPDATE `#__js_job_cities` set latitude = '30.7287704' ,longitude = '72.661514' WHERE id = 69969; 
UPDATE `#__js_job_cities` set latitude = '31.4632106' ,longitude = '74.103441' WHERE id = 69970; 
UPDATE `#__js_job_cities` set latitude = '25.1511235' ,longitude = '69.1119247' WHERE id = 69971; 
UPDATE `#__js_job_cities` set latitude = '32.4816761' ,longitude = '72.9076669' WHERE id = 69972; 
UPDATE `#__js_job_cities` set latitude = '26.1520262' ,longitude = '68.2683443' WHERE id = 69973; 
UPDATE `#__js_job_cities` set latitude = '25.4298913' ,longitude = '68.5426011' WHERE id = 69974; 
UPDATE `#__js_job_cities` set latitude = '31.2456587' ,longitude = '74.2128875' WHERE id = 69975; 
UPDATE `#__js_job_cities` set latitude = '31.8233973' ,longitude = '72.8072342' WHERE id = 69976; 
UPDATE `#__js_job_cities` set latitude = '28.5812029' ,longitude = '65.422281' WHERE id = 69977; 
UPDATE `#__js_job_cities` set latitude = '27.175294' ,longitude = '67.8152491' WHERE id = 69978; 
UPDATE `#__js_job_cities` set latitude = '31.8315' ,longitude = '73.6241855' WHERE id = 69979; 
UPDATE `#__js_job_cities` set latitude = '27.0922441' ,longitude = '67.7347735' WHERE id = 69980; 
UPDATE `#__js_job_cities` set latitude = '35.1976595' ,longitude = '71.8749209' WHERE id = 69981; 
UPDATE `#__js_job_cities` set latitude = '28.1371171' ,longitude = '69.0821211' WHERE id = 69982; 
UPDATE `#__js_job_cities` set latitude = '34.3008142' ,longitude = '71.6525026' WHERE id = 69983; 
UPDATE `#__js_job_cities` set latitude = '34.2204177' ,longitude = '71.4430876' WHERE id = 69984; 
UPDATE `#__js_job_cities` set latitude = '34.6855556' ,longitude = '73.2611111' WHERE id = 69985; 
UPDATE `#__js_job_cities` set latitude = '30.1598144' ,longitude = '73.5682467' WHERE id = 69986; 
UPDATE `#__js_job_cities` set latitude = '30.8361718' ,longitude = '71.9030828' WHERE id = 69987; 
UPDATE `#__js_job_cities` set latitude = '32.7340812' ,longitude = '73.9315733' WHERE id = 69988; 
UPDATE `#__js_job_cities` set latitude = '29.7984166' ,longitude = '66.8469103' WHERE id = 69989; 
UPDATE `#__js_job_cities` set latitude = '25.8241828' ,longitude = '69.3756586' WHERE id = 69990; 
UPDATE `#__js_job_cities` set latitude = '31.4729556' ,longitude = '74.4195864' WHERE id = 69991; 
UPDATE `#__js_job_cities` set latitude = '29.2931391' ,longitude = '70.452117' WHERE id = 69992; 
UPDATE `#__js_job_cities` set latitude = '30.5239319' ,longitude = '72.2393399' WHERE id = 69993; 
UPDATE `#__js_job_cities` set latitude = '32.531894' ,longitude = '73.9741874' WHERE id = 69994; 
UPDATE `#__js_job_cities` set latitude = '32.3594749' ,longitude = '72.623987' WHERE id = 69995; 
UPDATE `#__js_job_cities` set latitude = '27.3799987' ,longitude = '67.915103' WHERE id = 69996; 
UPDATE `#__js_job_cities` set latitude = '29.5558052' ,longitude = '66.0195894' WHERE id = 69997; 
UPDATE `#__js_job_cities` set latitude = '27.042879' ,longitude = '67.853367' WHERE id = 69998; 
UPDATE `#__js_job_cities` set latitude = '31.2179046' ,longitude = '72.9962491' WHERE id = 69999; 
UPDATE `#__js_job_cities` set latitude = '31.8248489' ,longitude = '72.5411869' WHERE id = 70000; 
UPDATE `#__js_job_cities` set latitude = '27.0587825' ,longitude = '68.2117046' WHERE id = 70001; 
UPDATE `#__js_job_cities` set latitude = '34.0548135' ,longitude = '72.467236' WHERE id = 70002; 
UPDATE `#__js_job_cities` set latitude = '25.1772515' ,longitude = '69.5648538' WHERE id = 70003; 
UPDATE `#__js_job_cities` set latitude = '29.0303612' ,longitude = '66.5878767' WHERE id = 70004; 
UPDATE `#__js_job_cities` set latitude = '32.8718898' ,longitude = '71.569428' WHERE id = 70005; 
UPDATE `#__js_job_cities` set latitude = '32.2416242' ,longitude = '72.1090303' WHERE id = 70006; 
UPDATE `#__js_job_cities` set latitude = '33.9101872' ,longitude = '72.4938607' WHERE id = 70007; 
UPDATE `#__js_job_cities` set latitude = '29.7472966' ,longitude = '73.2440996' WHERE id = 70008; 
UPDATE `#__js_job_cities` set latitude = '34.0057866' ,longitude = '71.9296662' WHERE id = 70009; 
UPDATE `#__js_job_cities` set latitude = '31.22331' ,longitude = '70.95005' WHERE id = 70010; 
UPDATE `#__js_job_cities` set latitude = '27.3395429' ,longitude = '68.7065547' WHERE id = 70011; 
UPDATE `#__js_job_cities` set latitude = '32.0974997' ,longitude = '71.5439451' WHERE id = 70012; 
UPDATE `#__js_job_cities` set latitude = '33.9077736' ,longitude = '73.3914997' WHERE id = 70013; 
UPDATE `#__js_job_cities` set latitude = '29.476868' ,longitude = '73.0464309' WHERE id = 70014; 
UPDATE `#__js_job_cities` set latitude = '30.6844519' ,longitude = '71.7652137' WHERE id = 70015; 
UPDATE `#__js_job_cities` set latitude = '32.4217135' ,longitude = '73.5770801' WHERE id = 70016; 
UPDATE `#__js_job_cities` set latitude = '29.1257774' ,longitude = '71.7513816' WHERE id = 70017; 
UPDATE `#__js_job_cities` set latitude = '31.2205548' ,longitude = '74.2560806' WHERE id = 70018; 
UPDATE `#__js_job_cities` set latitude = '31.5398053' ,longitude = '73.8330844' WHERE id = 70019; 
UPDATE `#__js_job_cities` set latitude = '30.5842128' ,longitude = '66.9958226' WHERE id = 70020; 
UPDATE `#__js_job_cities` set latitude = '30.4273414' ,longitude = '73.0434794' WHERE id = 70021; 
UPDATE `#__js_job_cities` set latitude = '32.3445875' ,longitude = '74.7059059' WHERE id = 70022; 
UPDATE `#__js_job_cities` set latitude = '28.1659641' ,longitude = '69.7316714' WHERE id = 70023; 
UPDATE `#__js_job_cities` set latitude = '24.7400111' ,longitude = '69.7983444' WHERE id = 70024; 
UPDATE `#__js_job_cities` set latitude = '34' ,longitude = '72.1333329' WHERE id = 70025; 
UPDATE `#__js_job_cities` set latitude = '32.3401285' ,longitude = '74.9062622' WHERE id = 70026; 
UPDATE `#__js_job_cities` set latitude = '28.5521456' ,longitude = '70.4699683' WHERE id = 70027; 
UPDATE `#__js_job_cities` set latitude = '32.0433183' ,longitude = '74.2560806' WHERE id = 70028; 
UPDATE `#__js_job_cities` set latitude = '33.5896138' ,longitude = '73.3885526' WHERE id = 70029; 
UPDATE `#__js_job_cities` set latitude = '27.2847838' ,longitude = '68.5071364' WHERE id = 70030; 
UPDATE `#__js_job_cities` set latitude = '31.9328279' ,longitude = '70.4610427' WHERE id = 70031; 
UPDATE `#__js_job_cities` set latitude = '27.2105474' ,longitude = '68.4159067' WHERE id = 70032; 
UPDATE `#__js_job_cities` set latitude = '24.854836' ,longitude = '69.4099249' WHERE id = 70033; 
UPDATE `#__js_job_cities` set latitude = '32.5883708' ,longitude = '73.0434794' WHERE id = 70034; 
UPDATE `#__js_job_cities` set latitude = '30.7678277' ,longitude = '74.1210597' WHERE id = 70035; 
UPDATE `#__js_job_cities` set latitude = '31.8248486' ,longitude = '72.5151944' WHERE id = 70036; 
UPDATE `#__js_job_cities` set latitude = '32.5877557' ,longitude = '74.4965215' WHERE id = 70037; 
UPDATE `#__js_job_cities` set latitude = '26.1543553' ,longitude = '68.6505791' WHERE id = 70038; 
UPDATE `#__js_job_cities` set latitude = '24.8883678' ,longitude = '68.8139269' WHERE id = 70039; 
UPDATE `#__js_job_cities` set latitude = '26.7757114' ,longitude = '68.2951738' WHERE id = 70040; 
UPDATE `#__js_job_cities` set latitude = '25.289933' ,longitude = '69.2490136' WHERE id = 70041; 
UPDATE `#__js_job_cities` set latitude = '30.2911176' ,longitude = '71.6719869' WHERE id = 70042; 
UPDATE `#__js_job_cities` set latitude = '26.2267942' ,longitude = '66.3110971' WHERE id = 70043; 
UPDATE `#__js_job_cities` set latitude = '25.5048266' ,longitude = '69.5693225' WHERE id = 70044; 
UPDATE `#__js_job_cities` set latitude = '34.3596867' ,longitude = '73.471054' WHERE id = 70045; 
UPDATE `#__js_job_cities` set latitude = '29.9206348' ,longitude = '71.1626756' WHERE id = 70046; 
UPDATE `#__js_job_cities` set latitude = '32.8230028' ,longitude = '70.7822635' WHERE id = 70047; 
UPDATE `#__js_job_cities` set latitude = '24.7403038' ,longitude = '67.5842645' WHERE id = 70048; 
UPDATE `#__js_job_cities` set latitude = '25.8020588' ,longitude = '68.4919235' WHERE id = 70049; 
UPDATE `#__js_job_cities` set latitude = '25.597796' ,longitude = '68.4442267' WHERE id = 70050; 
UPDATE `#__js_job_cities` set latitude = '27.6501099' ,longitude = '68.0393671' WHERE id = 70051; 
UPDATE `#__js_job_cities` set latitude = '27.4476667' ,longitude = '67.7943847' WHERE id = 70052; 
UPDATE `#__js_job_cities` set latitude = '33.3876953' ,longitude = '71.3408707' WHERE id = 70053; 
UPDATE `#__js_job_cities` set latitude = '31.9885417' ,longitude = '74.6605365' WHERE id = 70054; 
UPDATE `#__js_job_cities` set latitude = '33.4364645' ,longitude = '72.0171862' WHERE id = 70055; 
UPDATE `#__js_job_cities` set latitude = '29.0351582' ,longitude = '69.1596093' WHERE id = 70057; 
UPDATE `#__js_job_cities` set latitude = '26.9426981' ,longitude = '68.1163126' WHERE id = 70058; 
UPDATE `#__js_job_cities` set latitude = '26.8462951' ,longitude = '68.1252555' WHERE id = 70059; 
UPDATE `#__js_job_cities` set latitude = '29.5599903' ,longitude = '70.3747545' WHERE id = 70060; 
UPDATE `#__js_job_cities` set latitude = '26.4545363' ,longitude = '68.3190222' WHERE id = 70061; 
UPDATE `#__js_job_cities` set latitude = '32.4293472' ,longitude = '74.3635275' WHERE id = 70062; 
UPDATE `#__js_job_cities` set latitude = '32.1056403' ,longitude = '70.9722619' WHERE id = 70063; 
UPDATE `#__js_job_cities` set latitude = '26.5566671' ,longitude = '67.719871' WHERE id = 70064; 
UPDATE `#__js_job_cities` set latitude = '29.8645414' ,longitude = '67.3294806' WHERE id = 70065; 
UPDATE `#__js_job_cities` set latitude = '27.1984727' ,longitude = '67.9534808' WHERE id = 70066; 
UPDATE `#__js_job_cities` set latitude = '25.8014437' ,longitude = '66.6206225' WHERE id = 70067; 
UPDATE `#__js_job_cities` set latitude = '31.9750078' ,longitude = '73.6032755' WHERE id = 70068; 
UPDATE `#__js_job_cities` set latitude = '25.0472733' ,longitude = '61.7458759' WHERE id = 70069; 
UPDATE `#__js_job_cities` set latitude = '26.6930979' ,longitude = '67.6155573' WHERE id = 70070; 
UPDATE `#__js_job_cities` set latitude = '25.5114274' ,longitude = '69.7823059' WHERE id = 70071; 
UPDATE `#__js_job_cities` set latitude = '25.1242171' ,longitude = '68.8913654' WHERE id = 70072; 
UPDATE `#__js_job_cities` set latitude = '33.1007838' ,longitude = '73.6514134' WHERE id = 70073; 
UPDATE `#__js_job_cities` set latitude = '31.5675547' ,longitude = '72.6565084' WHERE id = 70074; 
UPDATE `#__js_job_cities` set latitude = '29.5756193' ,longitude = '71.0209738' WHERE id = 70075; 
UPDATE `#__js_job_cities` set latitude = '25.957297' ,longitude = '68.8898751' WHERE id = 70076; 
UPDATE `#__js_job_cities` set latitude = '32.465509' ,longitude = '74.1856472' WHERE id = 70077; 
UPDATE `#__js_job_cities` set latitude = '32.9623645' ,longitude = '71.5471724' WHERE id = 70078; 
UPDATE `#__js_job_cities` set latitude = '26.03067' ,longitude = '68.8079041' WHERE id = 70079; 
UPDATE `#__js_job_cities` set latitude = '32.8432577' ,longitude = '71.359738' WHERE id = 70080; 
UPDATE `#__js_job_cities` set latitude = '32.7760323' ,longitude = '72.7008489' WHERE id = 70081; 
UPDATE `#__js_job_cities` set latitude = '24.3967645' ,longitude = '67.9911139' WHERE id = 70082; 
UPDATE `#__js_job_cities` set latitude = '32.2773356' ,longitude = '71.5545911' WHERE id = 70083; 
UPDATE `#__js_job_cities` set latitude = '30.5975528' ,longitude = '71.9727354' WHERE id = 70084; 
UPDATE `#__js_job_cities` set latitude = '32.7227733' ,longitude = '72.9844401' WHERE id = 70085; 
UPDATE `#__js_job_cities` set latitude = '29.479429' ,longitude = '67.6399' WHERE id = 70086; 
UPDATE `#__js_job_cities` set latitude = '31.7812058' ,longitude = '71.1032591' WHERE id = 70087; 
UPDATE `#__js_job_cities` set latitude = '30.5683543' ,longitude = '70.9365945' WHERE id = 70088; 
UPDATE `#__js_job_cities` set latitude = '27.9065243' ,longitude = '68.5157718' WHERE id = 70089; 
UPDATE `#__js_job_cities` set latitude = '27.753545' ,longitude = '68.4516583' WHERE id = 70090; 
UPDATE `#__js_job_cities` set latitude = '27.371442' ,longitude = '68.0999173' WHERE id = 70091; 
UPDATE `#__js_job_cities` set latitude = '27.3076123' ,longitude = '68.4024919' WHERE id = 70092; 
UPDATE `#__js_job_cities` set latitude = '28.8854045' ,longitude = '64.3963673' WHERE id = 70093; 
UPDATE `#__js_job_cities` set latitude = '26.4944244' ,longitude = '67.9732288' WHERE id = 70094; 
UPDATE `#__js_job_cities` set latitude = '29.0444314' ,longitude = '67.8241911' WHERE id = 70095; 
UPDATE `#__js_job_cities` set latitude = '32.3272407' ,longitude = '73.7794679' WHERE id = 70096; 
UPDATE `#__js_job_cities` set latitude = '32.8124916' ,longitude = '74.090226' WHERE id = 70097; 
UPDATE `#__js_job_cities` set latitude = '32.2866118' ,longitude = '72.4302529' WHERE id = 70098; 
UPDATE `#__js_job_cities` set latitude = '24.7887164' ,longitude = '68.9655333' WHERE id = 70099; 
UPDATE `#__js_job_cities` set latitude = '34.4406901' ,longitude = '73.2205065' WHERE id = 70100; 
UPDATE `#__js_job_cities` set latitude = '33.1104787' ,longitude = '71.0913748' WHERE id = 70101; 
UPDATE `#__js_job_cities` set latitude = '28.0592418' ,longitude = '67.9791769' WHERE id = 70102; 
UPDATE `#__js_job_cities` set latitude = '27.848942' ,longitude = '68.6998301' WHERE id = 70103; 
UPDATE `#__js_job_cities` set latitude = '25.1163445' ,longitude = '66.7278021' WHERE id = 70104; 
UPDATE `#__js_job_cities` set latitude = '28.4901014' ,longitude = '66.2634928' WHERE id = 70105; 
UPDATE `#__js_job_cities` set latitude = '28.6794257' ,longitude = '69.9609892' WHERE id = 70106; 
UPDATE `#__js_job_cities` set latitude = '25.2665929' ,longitude = '64.6095785' WHERE id = 70107; 
UPDATE `#__js_job_cities` set latitude = '25.293292' ,longitude = '68.8138658' WHERE id = 70108; 
UPDATE `#__js_job_cities` set latitude = '32.199328' ,longitude = '74.6502902' WHERE id = 70109; 
UPDATE `#__js_job_cities` set latitude = '24.7013799' ,longitude = '70.1783251' WHERE id = 70110; 
UPDATE `#__js_job_cities` set latitude = '30.9909796' ,longitude = '70.5153376' WHERE id = 70111; 
UPDATE `#__js_job_cities` set latitude = '26.910384' ,longitude = '68.1863546' WHERE id = 70112; 
UPDATE `#__js_job_cities` set latitude = '25.3097741' ,longitude = '69.0478462' WHERE id = 70113; 
UPDATE `#__js_job_cities` set latitude = '32.4074383' ,longitude = '74.1416127' WHERE id = 70114; 
UPDATE `#__js_job_cities` set latitude = '33.1925909' ,longitude = '73.1379109' WHERE id = 70115; 
UPDATE `#__js_job_cities` set latitude = '24.465469' ,longitude = '69.5827286' WHERE id = 70116; 
UPDATE `#__js_job_cities` set latitude = '29.8975881' ,longitude = '69.2490136' WHERE id = 70117; 
UPDATE `#__js_job_cities` set latitude = '30.0999687' ,longitude = '67.9434205' WHERE id = 70118; 
UPDATE `#__js_job_cities` set latitude = '31.8176025' ,longitude = '73.9212858' WHERE id = 70119; 
UPDATE `#__js_job_cities` set latitude = '27.1129952' ,longitude = '67.9575794' WHERE id = 70120; 
UPDATE `#__js_job_cities` set latitude = '31.3821495' ,longitude = '71.4477469' WHERE id = 70121; 
UPDATE `#__js_job_cities` set latitude = '33.7601226' ,longitude = '72.4339514' WHERE id = 70122; 
UPDATE `#__js_job_cities` set latitude = '27.7589814' ,longitude = '68.0924649' WHERE id = 70123; 
UPDATE `#__js_job_cities` set latitude = '30.7750133' ,longitude = '70.9368469' WHERE id = 70124; 
UPDATE `#__js_job_cities` set latitude = '26.150341' ,longitude = '68.7169879' WHERE id = 70125; 
UPDATE `#__js_job_cities` set latitude = '25.7868964' ,longitude = '68.8064137' WHERE id = 70126; 
UPDATE `#__js_job_cities` set latitude = '35.920154' ,longitude = '74.3080126' WHERE id = 70127; 
UPDATE `#__js_job_cities` set latitude = '32.4389602' ,longitude = '74.2692839' WHERE id = 70128; 
UPDATE `#__js_job_cities` set latitude = '28.242434' ,longitude = '68.779462' WHERE id = 70129; 
UPDATE `#__js_job_cities` set latitude = '27.183333' ,longitude = '68.6333329' WHERE id = 70130; 
UPDATE `#__js_job_cities` set latitude = '24.3552401' ,longitude = '68.2668538' WHERE id = 70131; 
UPDATE `#__js_job_cities` set latitude = '24.8810774' ,longitude = '67.0316723' WHERE id = 70132; 
UPDATE `#__js_job_cities` set latitude = '26.6842052' ,longitude = '68.2832496' WHERE id = 70133; 
UPDATE `#__js_job_cities` set latitude = '28.5188198' ,longitude = '68.5411106' WHERE id = 70134; 
UPDATE `#__js_job_cities` set latitude = '33.4248352' ,longitude = '70.7376623' WHERE id = 70135; 
UPDATE `#__js_job_cities` set latitude = '24.7304503' ,longitude = '68.2594012' WHERE id = 70136; 
UPDATE `#__js_job_cities` set latitude = '26.0382473' ,longitude = '68.1341985' WHERE id = 70137; 
UPDATE `#__js_job_cities` set latitude = '25.2841367' ,longitude = '69.3935368' WHERE id = 70138; 
UPDATE `#__js_job_cities` set latitude = '29.8972421' ,longitude = '69.5276135' WHERE id = 70139; 
UPDATE `#__js_job_cities` set latitude = '26.5862194' ,longitude = '68.3011359' WHERE id = 70140; 
UPDATE `#__js_job_cities` set latitude = '26.1322972' ,longitude = '81.8572681' WHERE id = 70141; 
UPDATE `#__js_job_cities` set latitude = '24.5473691' ,longitude = '67.6259883' WHERE id = 70142; 
UPDATE `#__js_job_cities` set latitude = '27.9383133' ,longitude = '69.3190425' WHERE id = 70143; 
UPDATE `#__js_job_cities` set latitude = '27.7559788' ,longitude = '68.7497777' WHERE id = 70144; 
UPDATE `#__js_job_cities` set latitude = '26.8813924' ,longitude = '67.6826153' WHERE id = 70145; 
UPDATE `#__js_job_cities` set latitude = '24.9845653' ,longitude = '68.8541063' WHERE id = 70146; 
UPDATE `#__js_job_cities` set latitude = '34.2203425' ,longitude = '72.2639358' WHERE id = 70147; 
UPDATE `#__js_job_cities` set latitude = '26.2955335' ,longitude = '68.6290501' WHERE id = 70148; 
UPDATE `#__js_job_cities` set latitude = '25.7982864' ,longitude = '69.0687093' WHERE id = 70149; 
UPDATE `#__js_job_cities` set latitude = '24.4808475' ,longitude = '68.9852555' WHERE id = 70150; 
UPDATE `#__js_job_cities` set latitude = '25.4356826' ,longitude = '68.332437' WHERE id = 70152; 
UPDATE `#__js_job_cities` set latitude = '25.5105787' ,longitude = '69.3756586' WHERE id = 70153; 
UPDATE `#__js_job_cities` set latitude = '30.1522019' ,longitude = '68.5783733' WHERE id = 70154; 
UPDATE `#__js_job_cities` set latitude = '25.0681398' ,longitude = '69.6437982' WHERE id = 70155; 
UPDATE `#__js_job_cities` set latitude = '24.8050055' ,longitude = '68.6052022' WHERE id = 70156; 
UPDATE `#__js_job_cities` set latitude = '32.7884623' ,longitude = '73.8227917' WHERE id = 70157; 
UPDATE `#__js_job_cities` set latitude = '24.866667' ,longitude = '68.333333' WHERE id = 70158; 
UPDATE `#__js_job_cities` set latitude = '33.537239' ,longitude = '70.3435088' WHERE id = 70159; 
UPDATE `#__js_job_cities` set latitude = '33.0073' ,longitude = '70.0652004' WHERE id = 70160; 
UPDATE `#__js_job_cities` set latitude = '33.8225317' ,longitude = '71.8904844' WHERE id = 70161; 
UPDATE `#__js_job_cities` set latitude = '24.1299447' ,longitude = '67.453141' WHERE id = 70162; 
UPDATE `#__js_job_cities` set latitude = '25.995584' ,longitude = '69.199842' WHERE id = 70163; 
UPDATE `#__js_job_cities` set latitude = '34.0909899' ,longitude = '71.1457517' WHERE id = 70164; 
UPDATE `#__js_job_cities` set latitude = '32.3006562' ,longitude = '69.5797495' WHERE id = 70165; 
UPDATE `#__js_job_cities` set latitude = '35.2900896' ,longitude = '75.6453431' WHERE id = 70166; 
UPDATE `#__js_job_cities` set latitude = '30.7877207' ,longitude = '70.8676441' WHERE id = 70167; 
UPDATE `#__js_job_cities` set latitude = '28.0209905' ,longitude = '67.9210645' WHERE id = 70168; 
UPDATE `#__js_job_cities` set latitude = '30.7530953' ,longitude = '70.8655074' WHERE id = 70169; 
UPDATE `#__js_job_cities` set latitude = '34.8644422' ,longitude = '-89.860363' WHERE id = 70172; 
UPDATE `#__js_job_cities` set latitude = '26.155163' ,longitude = '68.3484602' WHERE id = 70173; 
UPDATE `#__js_job_cities` set latitude = '25.2739885' ,longitude = '68.4869861' WHERE id = 70175; 
UPDATE `#__js_job_cities` set latitude = '35.8522867' ,longitude = '71.7871069' WHERE id = 76854; 
UPDATE `#__js_job_cities` set latitude = '33.1737486' ,longitude = '70.401907' WHERE id = 76855; 
 UPDATE `#__js_job_cities` set latitude = '33.2451991' ,longitude = '72.2659868' WHERE id = 76856; 
 UPDATE `#__js_job_cities` set latitude = '35.4920326' ,longitude = '72.5204827' WHERE id = 76857; 
 UPDATE `#__js_job_cities` set latitude = '29.9132123' ,longitude = '66.4956023' WHERE id = 76858; 
 UPDATE `#__js_job_cities` set latitude = '33.2536611' ,longitude = '70.4967441' WHERE id = 76860; 
 UPDATE `#__js_job_cities` set latitude = '30.3829282' ,longitude = '67.7243417' WHERE id = 76861;