Pickup City : --Select-- SELECT city_id,city_name FROM tbl_citynames WHERE city_id in (SELECT DISTINCT fromcity_id from tbl_tariffs where servicetype_id='12' and carmodel_id='8' and tar_id in (select tar_id from tbl_instrentslabprice)) ORDER BY city_nameAmritsar PunjabChandigarh Pickup Date : Duration : --Select-- SELECT RentslabId,Rentslab_name FROM tbl_rentdurations WHERE RentslabId in (SELECT DISTINCT RentslabId from tbl_instrentslabprice ) ORDER BY Rentslab_name4 Hours 40 Kms8 Hours 80 Kms Pickup Time : HR:MIN 00:0000:1500:3000:4501:0001:1501:3001:4502:0002:1502:3002:4503:0003:1503:3003:4504:0004:1504:3004:4505:0005:1505:3005:4506:0006:1506:3006:4507:0007:1507:3007:4508:0008:1508:3008:4509:0009:1509:3009:4510:0010:1510:3010:4511:0011:1511:3011:4512:0012:1512:3012:4513:0013:1513:3013:4514:0014:1514:3014:4515:0015:1515:3015:4516:0016:1516:3016:4517:0017:1517:3017:4518:0018:1518:3018:4519:0019:1519:3019:4520:0020:1520:3020:4521:0021:1521:3021:4522:0022:1522:3022:4523:0023:1523:3023:45
Pick Up From --Select-- SELECT loc_id,loc_name FROM tbl_locations WHERE loc_id in (SELECT DISTINCT fromloc_id from tbl_tariffs) ORDER BY loc_nameCHANDIGARH AIRPORT Pickup Date : Drop Off At --Select-- SELECT loc_id,loc_name FROM tbl_locations WHERE loc_id in (SELECT DISTINCT toloc_id from tbl_tariffs where toloc_id!='' and toloc_id='') ORDER BY loc_name Time : HR:MIN 00:0000:1500:3000:4501:0001:1501:3001:4502:0002:1502:3002:4503:0003:1503:3003:4504:0004:1504:3004:4505:0005:1505:3005:4506:0006:1506:3006:4507:0007:1507:3007:4508:0008:1508:3008:4509:0009:1509:3009:4510:0010:1510:3010:4511:0011:1511:3011:4512:0012:1512:3012:4513:0013:1513:3013:4514:0014:1514:3014:4515:0015:1515:3015:4516:0016:1516:3016:4517:0017:1517:3017:4518:0018:1518:3018:4519:0019:1519:3019:4520:0020:1520:3020:4521:0021:1521:3021:4522:0022:1522:3022:4523:0023:1523:3023:45
Pickup City : --Select-- SELECT city_id,city_name FROM tbl_citynames WHERE city_id in (SELECT DISTINCT fromcity_id from tbl_tariffs where servicetype_id='14' and carmodel_id='8') ORDER BY city_nameChandigarh Pickup Date : Drop Off City : --Select-- Pickup Time : HR:MIN 00:0000:1500:3000:4501:0001:1501:3001:4502:0002:1502:3002:4503:0003:1503:3003:4504:0004:1504:3004:4505:0005:1505:3005:4506:0006:1506:3006:4507:0007:1507:3007:4508:0008:1508:3008:4509:0009:1509:3009:4510:0010:1510:3010:4511:0011:1511:3011:4512:0012:1512:3012:4513:0013:1513:3013:4514:0014:1514:3014:4515:0015:1515:3015:4516:0016:1516:3016:4517:0017:1517:3017:4518:0018:1518:3018:4519:0019:1519:3019:4520:0020:1520:3020:4521:0021:1521:3021:4522:0022:1522:3022:4523:0023:1523:3023:45
Pickup City --Select-- SELECT city_id,city_name FROM tbl_citynames WHERE city_id in (SELECT DISTINCT fromcity_id from tbl_tariffs where servicetype_id='64' and carmodel_id='8') ORDER BY city_nameAmritsar PunjabChandigarh To SELECT city_name,city_name FROM tbl_citynames WHERE city_foroutstation=1 ORDER BY city_nameAgra, Uttar PradeshAjmer, RajasthanAligarh, Uttar PradeshAlmora, UttrakhandAlwar, RajasthanAmbala Cant HaryanaAmbala City, HaryanaAmloh, PunjabAmritsar PunjabAnanthnag, SrinagarBaddi, Himachal PradeshBageshwar, UttarakhandBanswara, RajasthanBaramulla, Jammu and KashmirBaran, RajasthanBarmer, RajasthanBarnala, PunjabBatala, PunjabBathinda, PunjabBharatgarh, PunjabBharatpur, RajasthanBhilwara, RajasthanBhiwani, HaryanaBikaner, RajasthanBilaspur, Himachal PradeshBudgam, Jammu and KashmirBundi, RajasthanChamba, Himachal PradeshChamoli, UttarakhandChampawat, UttarakhandChandigarhDalhousie, Himachal PradeshDehradun, UttarakhandDelhi NCRDeoprayag, UttarakhandDhanolti, UttarakhandDharampur, Himachal PradeshDharamshala Himachal PradeshDoda, Jammu and KashmirFaridabad, HaryanaFaridkot, PunjabFatehabad, HaryanaFatehgarh Sahib, PunjabFazilka, PunjabFirozabad, Uttar PradeshFirozpur, PunjabGajja, UttarakhandGhansali, UttarakhandGhaziabad, Uttar PradeshGobindgarh, PunjabGreater Noida, Uttar PradeshGurdaspur, PunjabGurgaon, HaryanaHamirpur, Himachal PradeshHaridwar, UttarakhandHissar, HaryanaHoshiarpur, PunjabJaipur, RajasthanJaisalmer, RajasthanJakhnidhar, UttarakhandJalandhar, PunjabJammu, Jammu and KashmirJhajjar, HaryanaJind, HaryanaJodhpur, RajasthanKaithal, HaryanaKalka StationKalpa, Himachal PradeshKandaghat, Himachal PradeshKANGRAKangra, Himachal PradeshKapurthala, PunjabKarauli, RajasthanKargil, Jammu and KashmirKarnal, HaryanaKasauli, Himachal PradeshKasol Himachal PradeshKathua, Jammu and KashmirKhanna, PunjabKhatu Shyam, RajasthanKinnaur, Himachal PradeshKota, RajasthanKufri, Himachal PradeshKullu Himachal PradeshKurali, MohaliKurukshetra, HaryanaLAHUL AND SPITI, HIMACHAL PRADESHLudhiana PunjabMahendragarh, HaryanaManali Himachal PradeshMandi, Himachal PradeshMandi, PunjabMansa, PunjabMashobra, Himachal PradeshMcLeod Ganj, Himachal PradeshMewat, HaryanaMoga, PunjabMorinda, PunjabMount Abu, RajasthanMussoorie, UttarakhandNagaur, RajasthanNainital, UttarakhandNakodar, PunjabNalagarh, Himachal PradeshNangal, PunjabNarkanda, Himachal PradeshNawanshahr, PunjabNew DelhiNoida, Uttar PradeshPali, RajasthanPalwal, HaryanaPanipat, HaryanaParwanoo, Himachal PradeshPathankot PunjabPatiala, PunjabPatti, PunjabPauri Garhwal, UttarakhandPhagwara, PunjabPhillaur, PunjabPINJORE GARDENPinjore, PanchkulaPithoragarh, UttarakhandPushkar, RajasthanRajpura, PunjabRajsamand, RajasthanRampur, Himachal PradeshRewari, HaryanaRishikesh, UttarakhandRohru, Himachal PradeshRohtak, HaryanaRudrapraya, UttarakhandRupnagar, PunjabSalasar, RajasthanSangla, Himachal PradeshSangrur, PunjabSawai Madhopur, RajasthanShimla Himachal PradeshShri Muktsar Sahib, PunjabSikar, RajasthanSirhind, PunjabSirmaur, Himachal PradeshSirohi, RajasthanSirsa, HaryanaSolan Himachal PradeshSonipat, HaryanaSrinagar, Jammu and KashmirSultanpur, PunjabSundernagar, Himachal PradeshTalwara, PunjabTarn Taran, PunjabTehri Garhwal, UttarakhandTonk, RajasthanUdaipur, RajasthanUdham Singh Nagar, UttarakhandUdhampur, Jammu and KashmirUna, Himachal PradeshUttarkashi, UttarakhandYamuna Nagar, HaryanaZira, Punjab Pickup Date : Pickup Time : HR:MIN 00:0000:1500:3000:4501:0001:1501:3001:4502:0002:1502:3002:4503:0003:1503:3003:4504:0004:1504:3004:4505:0005:1505:3005:4506:0006:1506:3006:4507:0007:1507:3007:4508:0008:1508:3008:4509:0009:1509:3009:4510:0010:1510:3010:4511:0011:1511:3011:4512:0012:1512:3012:4513:0013:1513:3013:4514:0014:1514:3014:4515:0015:1515:3015:4516:0016:1516:3016:4517:0017:1517:3017:4518:0018:1518:3018:4519:0019:1519:3019:4520:0020:1520:3020:4521:0021:1521:3021:4522:0022:1522:3022:4523:0023:1523:3023:45 Duration : --Select-- 1 Day 2 Days 3 Days 4 Days 5 Days 6 Days 7 Days 8 Days 9 Days 10 Days