-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathdatabase.sql
214 lines (188 loc) · 48.7 KB
/
database.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Mar 25, 2024 at 11:19 AM
-- Server version: 10.4.28-MariaDB
-- PHP Version: 8.2.4
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `mmt_scraped`
--
-- --------------------------------------------------------
--
-- Table structure for table `bookings`
--
CREATE TABLE `bookings` (
`id` int(100) NOT NULL,
`hotel_id` int(100) NOT NULL,
`duration` int(10) NOT NULL,
`total_price` bigint(255) NOT NULL,
`checkin_time` varchar(20) NOT NULL,
`checkout_time` varchar(20) NOT NULL,
`checkin_date` date NOT NULL,
`checkout_date` date NOT NULL,
`first_name` varchar(255) NOT NULL,
`last_name` varchar(255) NOT NULL,
`dob` date NOT NULL,
`gender` varchar(100) NOT NULL,
`phone` bigint(255) NOT NULL,
`email` varchar(255) NOT NULL,
`payment_status` tinyint(1) NOT NULL,
`rzp_id` varchar(255) NOT NULL,
`payment_id` varchar(255) NOT NULL,
`status` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Table structure for table `hotels`
--
CREATE TABLE `hotels` (
`id` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`url` varchar(500) NOT NULL,
`image1` varchar(255) NOT NULL,
`image2` varchar(255) NOT NULL,
`image3` varchar(255) NOT NULL,
`location` varchar(255) NOT NULL,
`landmark` varchar(255) DEFAULT NULL,
`ratingtext` varchar(100) NOT NULL,
`rating` varchar(100) NOT NULL,
`price` bigint(100) DEFAULT NULL,
`original_price` bigint(100) NOT NULL,
`taxes` varchar(30) NOT NULL,
`status` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `hotels`
--
INSERT INTO `hotels` (`id`, `name`, `url`, `image1`, `image2`, `image3`, `location`, `landmark`, `ratingtext`, `rating`, `price`, `original_price`, `taxes`, `status`) VALUES
(1, 'Hotel J.D Residency', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=202111161831301538&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.12376&lng=72.84652&locusId=CTBOM&locusType=city&rank=61®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=5663146014084367987', 'https://r1imghtlak.mmtcdn.com/e0a187008e3311ec97250a58a9feac02.jpg', 'https://r1imghtlak.mmtcdn.com/cd439f648e2811ecb27e0a58a9feac02.jpg', 'https://r1imghtlak.mmtcdn.com/11bb98e08e2911ecbc9d0a58a9feac02.jpg', 'Amboli', NULL, 'Very Good', '3.5', 1317, 2738, '352', 1),
(2, 'Hotel Sai Residency', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=202401241713389766&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.10199&lng=72.88999&locusId=CTBOM&locusType=city&rank=71®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=-1389695393982449646', 'https://r1imghtlak.mmtcdn.com/697c5320c19011ee97bb0a58a9feac02.jfif', 'https://r1imghtlak.mmtcdn.com/6a12911ec19011eebc8d0a58a9feac02.jfif', 'https://r1imghtlak.mmtcdn.com/ea121e42ca6011ee89ee0a58a9feac02.jpeg', 'Asalpha', NULL, 'Very Good', '4', 1439, 2499, '350', 1),
(3, 'Hotel Beverly Palace', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=202401121235381539&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.07775&lng=72.86182&locusId=CTBOM&locusType=city&rank=81®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=2341242862751645048', 'https://r1imghtlak.mmtcdn.com/5d86bbdec03f11eea04b0a58a9feac02.png', 'https://r1imghtlak.mmtcdn.com/5c855a89-c5d2-4a80-88d9-b03f01968128.jpg', 'https://r1imghtlak.mmtcdn.com/eef9b384c04211ee802d0a58a9feac02.jpg', 'Near Mumbai Airport', NULL, 'Very Good', '3.6', 1572, 4000, '382', 1),
(4, 'Qubestay Airport Capsule Hostel | Rooms & Dorms', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=201810221331074219&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.107&lng=72.89&locusId=CTBOM&locusType=city&rank=91®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&viewType=BUDGET&mtkeys=-1584701038254532847', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/201810221331074219-f26a0cb0119111ec99de0a58a9feac02.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/201810221331074219-b2fdfe9c119111ec8ef60a58a9feac02.jpg', 'https://r1imghtlak.mmtcdn.com/c27e8cea119d11ec98470a58a9feac02.jpg', 'Andheri East', NULL, 'Very Good', '3.7', 1185, 1498, '322', 1),
(5, 'Aralia International Airport Mumbai', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=202304281919162464&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.11746&lng=72.88344&locusId=CTBOM&locusType=city&rank=101®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=-9071280930278309867', 'https://r1imghtlak.mmtcdn.com/79789adc3fee11eea43c0a58a9feac02.jpeg', 'https://r1imghtlak.mmtcdn.com/941678f63fde11eea4f90a58a9feac02.jpg', 'https://r1imghtlak.mmtcdn.com/943434fe3fde11eead540a58a9feac02.jpg', 'Andheri East', NULL, 'Very Good', '3.8', 1814, 3500, '504', 1),
(6, 'Hotel Park View, Andheri West', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=200708061207461754&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.11368&lng=72.84476&locusId=CTBOM&locusType=city&rank=102®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=2575700138581283945', 'https://r1imghtlak.mmtcdn.com/e5ed8756f52411e7a7ea0a4cef95d023.jpg', 'https://r1imghtlak.mmtcdn.com/66101476084711eaa01b0242ac110006.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/200708061207461754-209833b4260c11e5a23a001ec9b85d13.jpg', 'Andheri', NULL, 'Very Good', '3.9', 1911, 2500, '428', 1),
(7, 'Quaint Suites', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=202108031151062317&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.10799&lng=72.88928&locusId=CTBOM&locusType=city&rank=111®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=1866975274984436663', 'https://r1imghtlak.mmtcdn.com/0a822054304011ec9c680a58a9feac02.jpg', 'https://r1imghtlak.mmtcdn.com/6aecd812303b11ec8e600a58a9feac02.jpg', 'https://r1imghtlak.mmtcdn.com/c14b71c0335811edb0720a58a9feac02.jpg', 'Andheri East', NULL, 'Very Good', '3.6', 1760, 2500, '449', 1),
(8, 'Welcome Hotel', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=201906011346018639&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=18.93877&lng=72.83701&locusId=CTBOM&locusType=city&rank=112®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&viewType=PREMIUM&mtkeys=7146592070034969102', 'https://r1imghtlak.mmtcdn.com/ae9d739e4cb911ea9cc00242ac110002.jpg', 'https://r1imghtlak.mmtcdn.com/34206322844311e982410242ac110002.jpg', 'https://r1imghtlak.mmtcdn.com/be3832508ad311ea852b0242ac110002.jpg', 'South Mumbai', NULL, 'Very Good', '3.7', 1944, 2400, '240', 1),
(9, 'Hotel Zillion Executive', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=202310231301179271&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.07557&lng=72.87855&locusId=CTBOM&locusType=city&rank=121®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=-8473390482490089955', 'https://r1imghtlak.mmtcdn.com/bbdbfc1c7eef11ee82530a58a9feac02.jpg', 'https://r1imghtlak.mmtcdn.com/256c40287ee711eea0a30a58a9feac02.jpg', 'https://r1imghtlak.mmtcdn.com/440c9de47ef011ee8de80a58a9feac02.jpg', 'Near Mumbai Airport', NULL, 'Very Good', '3.6', 1215, 2550, '283', 1),
(10, 'Hotel Al Moazin', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=201603211852409180&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=18.95512&lng=72.83646&locusId=CTBOM&locusType=city&rank=130®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&viewType=BUDGET&mtkeys=3447726425189755274', 'https://r1imghtlak.mmtcdn.com/ad13cf70cd3411ecba740a58a9feac02.jpg', 'https://r1imghtlak.mmtcdn.com/317614c0cd3611ec8c570a58a9feac02.jpg', 'https://r1imghtlak.mmtcdn.com/a955bdbacd3611ec85ea0a58a9feac02.jpg', 'Mandvi', NULL, 'Very Good', '3.6', 2385, 3000, '634', 1),
(11, 'Hotel Golden Palms', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=201906191717039877&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.13253&lng=72.84784&locusId=CTBOM&locusType=city&rank=140®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=-8164141582286793376', 'https://r1imghtlak.mmtcdn.com/6242c6ce1fdd11ea8c450242ac110002.jpg', 'https://r1imghtlak.mmtcdn.com/976073cc200611eb9d9e0242ac110003.jpg', 'https://r1imghtlak.mmtcdn.com/fc7868f67b8811e9a0710242ac110003.jpg', 'Jogeshwari West', NULL, 'Very Good', '3.7', 2448, 6000, '624', 1),
(12, 'DawnsMelody', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=202305282109393197&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.06589&lng=72.82533&locusId=CTBOM&locusType=city&rank=150®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=-5849610501980349725', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/room-imgs/202305282109393197-7077062-29a74625-23e5-41be-8a24-b35ffde58d4a.jpg', 'https://r1imghtlak.mmtcdn.com/a4fe9f7e-fddd-43a5-8ba0-23697dc04f0d.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/202305282109393197-c28a6543-98ed-4a6b-a7ee-da0367bcce80.jpg', 'Bandra West', NULL, 'Excellent', '4.3', 2672, 3300, '627', 1),
(13, 'Hotel Solitaire', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=200801161515082971&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.109&lng=72.85658&locusId=CTBOM&locusType=city&rank=151®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=242319757165323824', 'https://r1imghtlak.mmtcdn.com/116e9df6536411e7a6830a4cef95d023.jpg', 'https://r1imghtlak.mmtcdn.com/627f0814746d11ecb2770a58a9feac02.jpg', 'https://r1imghtlak.mmtcdn.com/6010c5d6746d11ecbead0a58a9feac02.jpg', 'Near Mumbai Airport', NULL, 'Very Good', '3.5', 2679, 3600, '605', 1),
(14, 'AK Fort Inn', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=202301252155048921&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=18.93452&lng=72.8371&locusId=CTBOM&locusType=city&rank=160®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=-7759390827548274409', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/202301252155048921-403ef0e2513a11ee9b590a58a9feac02.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/202301252155048921-3f1a727c513a11eebab70a58a9feac02.jpg', 'https://r1imghtlak.mmtcdn.com/3fe394d6513a11ee80670a58a9feac02.jpg', 'South Mumbai', NULL, 'Very Good', '3.8', 2432, 3500, '575', 1),
(15, 'Hotel Leafio', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=201703201940521184&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.10218&lng=72.88627&locusId=CTBOM&locusType=city&rank=170®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&viewType=BUDGET&mtkeys=559572509870625454', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/201703201940521184-2aed06061a0b11e79c7e0a209fbd0127.jpg', 'https://r1imghtlak.mmtcdn.com/24594cb20f7c11e7b9010a209fbd0127.png', 'https://r1imghtlak.mmtcdn.com/69084928539f11e7a0e9025f77df004f.jpg', 'Near Mumbai Airport', NULL, 'Very Good', '3.5', 2499, 3124, '300', 1),
(16, 'Pinaki Comfort Stay Vile Parle', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=202207111832096133&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.09866&lng=72.85055&locusId=CTBOM&locusType=city&rank=180®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=7654439328785554011', 'https://r1imghtlak.mmtcdn.com/fb104faa-7580-4e1d-97fa-4463d8ba637c.jpeg', 'https://r1imghtlak.mmtcdn.com/3408c076-ccb7-4e47-8796-0d84dfc78613.JPG', 'https://r1imghtlak.mmtcdn.com/8633cdac011811edb2e70a58a9feac02.jpg', 'Near Mumbai Airport', NULL, 'Very Good', '3.9', 2774, 3400, '581', 1),
(17, 'Hotel Broadway Colaba', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=200806171448125968&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=18.92253&lng=72.8316&locusId=CTBOM&locusType=city&rank=190®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&viewType=BUDGET&mtkeys=-7953961703230109184', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/200806171448125968-e26f71c2b43e11e98da602b35a64fa92.jpg', 'https://r1imghtlak.mmtcdn.com/b7ecf2645b6d11e98d040242ac110003.jpg', 'https://r1imghtlak.mmtcdn.com/9d1b1b2cccc511e9b3f10242ac110003.jpeg', 'Colaba', NULL, 'Very Good', '3.6', 3078, 3800, '752', 1),
(18, 'Hotel Airport International', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=200710191121036433&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.0964&lng=72.8542&locusId=CTBOM&locusType=city&rank=200®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=-7805681632438428495', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/200710191121036433-c1dd460a520411e5859136cfdd80c293.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/200710191121036433-8d8b43ce520511e5b4a9001ec9b85d13.jpg', 'https://r1imghtlak.mmtcdn.com/179e57f8536311e78be90a4cef95d023.jpg', 'Near Mumbai Airport', NULL, 'Very Good', '3.7', 3255, 3500, '665', 1),
(19, 'Hotel Karl Residency', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=200701111049355260&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.11199&lng=72.84447&locusId=CTBOM&locusType=city&rank=210®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=382106240217289309', 'https://r1imghtlak.mmtcdn.com/mdl07gv2gl01f0gjeq595akr006s.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/200701111049355260-86c65b00b1e711e9b3e10242ac140005.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/200701111049355260-8efd1ed0b1e711e9b3e10242ac140005.jpg', 'Andheri', NULL, 'Very Good', '3.8', 3348, 3600, '684', 1),
(20, 'Hotel Karan Palace', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=201112141823141254&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.16357&lng=72.85116&locusId=CTBOM&locusType=city&rank=211®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=-279469252642249119', 'https://r1imghtlak.mmtcdn.com/5654684edc8011e5af695ee5da2daa2a.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/201112141823141254-7147e4121f9611e4b79df67d89ce50a3.jpg', 'https://r1imghtlak.mmtcdn.com/03ee384a303711e691b90015c5f4277e.jfif', 'Goregaon', NULL, 'Very Good', '3.9', 3364, 4000, '804', 1),
(21, 'Lemon Tree Premier, Mumbai International Airport, Mumbai', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=201905141416461036&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.10772&lng=72.88197&locusId=CTBOM&locusType=city&rank=220®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&viewType=PREMIUM&mtkeys=-7411744072458369148', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/201905141416461036-4caffe7697ee11eda7bf0a58a9feac02.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/201905141416461036-53b47bca97ee11eda6150a58a9feac02.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/201905141416461036-99b31c50464311eda2a20a58a9feac02.jpg', 'Near Mumbai Airport', NULL, 'Very Good', '4.2', 3134, 4500, '1323', 1),
(22, 'Rajhans Hotel', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=201304131102196210&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.06219&lng=72.90012&locusId=CTBOM&locusType=city&rank=221®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=-5385621910601471088', 'https://r1imghtlak.mmtcdn.com/86fe9a085b6f11e8bb350224510f5e5b.jpg', 'https://r1imghtlak.mmtcdn.com/4ce5a7e468a711e4a0aa32e76f7e45c9.jfif', 'https://r1imghtlak.mmtcdn.com/638e7b6e3f0511e893ee0224510f5e5b.jpg', 'Chembur', NULL, 'Very Good', '3.8', 3600, 4300, '813', 1),
(23, 'Apex Beacon Hotel', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=202301251621122171&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.10557&lng=72.86197&locusId=CTBOM&locusType=city&rank=230®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=-1957278964199850610', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/202301251621122171-e104b3c0af6b11ed997c0a58a9feac02.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/202301251621122171-330244a8af6c11edbd950a58a9feac02.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/202301251621122171-35692b80af6c11ed9e4c0a58a9feac02.jpg', 'Near Mumbai Airport', NULL, 'Very Good', '4.2', 3307, 4500, '684', 1),
(24, 'Hotel Metro Palace', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=200701291547518343&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.0562&lng=72.83433&locusId=CTBOM&locusType=city&rank=240®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=-480409575758242119', 'https://r1imghtlak.mmtcdn.com/9c7d5c36dbb211e6bd3c02bf5ac07431.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/200701291547518343-l9ho373o2t5nj8v10ul1rvk0004s.jpg', 'https://r1imghtlak.mmtcdn.com/f43b5338dbb211e6aa340224510f5e5b.jpg', 'Bandra West', NULL, 'Very Good', '3.6', 3729, 5220, '965', 1),
(25, 'The Byke Delotel', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=201908262331019953&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.23069&lng=72.85555&locusId=CTBOM&locusType=city&rank=241®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&viewType=BUDGET&mtkeys=7036694052871481230', 'https://r1imghtlak.mmtcdn.com/6909f0f6dd8a11ebb0c00242ac110003.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/201908262331019953-0173eb9cdd8d11eb98d90242ac110003.jpg', 'https://r1imghtlak.mmtcdn.com/554465ce786c11ecaeb70a58a9feac02.jpg', 'Borivali West', NULL, 'Very Good', '3.7', NULL, 3800, '456', 1),
(26, 'Baba Homes Near International Airport', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=202012021246284348&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.11613&lng=72.85688&locusId=CTBOM&locusType=city&rank=250®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&viewType=BUDGET&mtkeys=8493948260351837264', 'https://r1imghtlak.mmtcdn.com/039995ea33c711ebb1560242ac110004.jpg', 'https://r1imghtlak.mmtcdn.com/17db0b0633c711eba8410242ac110002.jpg', 'https://r1imghtlak.mmtcdn.com/214bf43e33c711eb946f0242ac110002.jpg', 'Andheri East', NULL, 'Very Good', '3.7', 3906, 4200, '924', 1),
(27, 'La Hotel Metro', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=20140124114028822&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.06048&lng=72.87272&locusId=CTBOM&locusType=city&rank=251®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=-2509414863745999510', 'https://r1imghtlak.mmtcdn.com/528825eca47a11edbe260a58a9feac02.png', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/20140124114028822-ea1186aaeebf11ebb6fa0a58a9feac02.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/20140124114028822-b8307e02eebf11eba1ca0a58a9feac02.jpg', 'Kurla West', NULL, 'Very Good', '3.8', 3999, 4300, '817', 1),
(28, 'Comfortstay Pvt. Ltd.', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=201403091732384323&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.13126&lng=72.87122&locusId=CTBOM&locusType=city&rank=260®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=5669337515305571563', 'https://r1imghtlak.mmtcdn.com/c1ca7ec27e1611e7b2b5025f77df004f.jpg', 'https://r1imghtlak.mmtcdn.com/c1c7329e7e1611e7a27e0a4cef95d023.jpg', 'https://r1imghtlak.mmtcdn.com/c258af4e7e1611e7a27e0a4cef95d023.jpg', 'Jogeshwari East', NULL, 'Very Good', '3.9', 4034, 5300, '1166', 1),
(29, 'Hotel Lords', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=201903131235186445&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=18.93595&lng=72.83768&locusId=CTBOM&locusType=city&rank=261®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&viewType=BUDGET&mtkeys=-6146247380885500236', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/201903131235186445-7e43fe466ddc11e996a40242ac110002.jpg', 'https://r1imghtlak.mmtcdn.com/3d4a237e3e6711e9b8ea0242ac110002.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/201903131235186445-9aed471e6ddc11e9a1710242ac110002.jpg', 'South Mumbai', NULL, 'Very Good', '3.6', 4102, 6300, '838', 1),
(30, 'Hotel Manama', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=200701101631373674&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=18.93972&lng=72.83858&locusId=CTBOM&locusType=city&rank=270®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&viewType=BUDGET&mtkeys=498176573400111934', 'https://r1imghtlak.mmtcdn.com/db60674a718011e7ae3b025f77df004f.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/200701101631373674-e2c7855ab25f11e99f2f0242ac140003.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/200701101631373674-cc4b6184b25f11e99f2f0242ac140003.jpg', 'South Mumbai', NULL, 'Very Good', '3.5', 3664, 4600, '904', 1),
(31, 'Hotel Bindra\'s Supremacy', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=201909261619093669&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.12216&lng=72.86613&locusId=CTBOM&locusType=city&rank=280®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=109308144878887748', 'https://r1imghtlak.mmtcdn.com/d62538086da611ea98850242ac110003.jpg', 'https://r1imghtlak.mmtcdn.com/7869d3d2cdf311ebb7550242ac110002.jpg', 'https://r1imghtlak.mmtcdn.com/e98e6b42-64f8-47ea-ab60-42b6beeb3007.jpg', 'Andheri East', NULL, 'Very Good', '4', 4522, 6720, '1081', 1),
(32, 'Hotel Parle International', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=200703161231099195&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.10119&lng=72.84513&locusId=CTBOM&locusType=city&rank=290®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=5193691828522819461', 'https://r1imghtlak.mmtcdn.com/eadd8fe0-2ba8-4ea4-9a1a-8cb1edef14e9.jpeg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/200703161231099195-bea87a86098111eda2040a58a9feac02.jpg', 'https://r1imghtlak.mmtcdn.com/06ab0f4f-c5f0-4bc6-89d3-c0a6119747f7.jpeg', 'Near Mumbai Airport', NULL, 'Very Good', '3.7', 4258, 5800, '927', 1),
(33, 'West End Hotel', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=20070725131729887&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=18.94065&lng=72.82755&locusId=CTBOM&locusType=city&rank=291®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=3402867384977012206', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/20070725131729887-8aed4e52448a11e993190242ac110005.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/20070725131729887-8ccdcd80448c11e9bcfb0242ac110005.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/20070725131729887-ac5c4512448e11e997f70242ac110003.jpg', 'South Mumbai', NULL, 'Very Good', '3.8', 4261, 7000, '1213', 1),
(34, 'HOTEL KOHINOOR PARK', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=12614626831837293&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.01585&lng=72.828&locusId=CTBOM&locusType=city&rank=300®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=-5577788463374419109', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/12614626831837293-9cf4c2e22e0f11ee99b40a58a9feac02.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/12614626831837293-b696f42cca7211ee94120a58a9feac02.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/12614626831837293-76853a36d3a711e9b5f80242ac110002.jpg', 'South Mumbai', NULL, 'Very Good', '3.8', 3956, 18500, '1355', 1),
(35, 'Indie Stays', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=201905161415014422&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.07131&lng=72.86445&locusId=CTBOM&locusType=city&rank=301®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=-4916194637788897087', 'https://r1imghtlak.mmtcdn.com/f1f7284a82cc11e998340242ac110004.jpg', 'https://r1imghtlak.mmtcdn.com/038a67f881e611e9a3cb0242ac110006.jpg', 'https://r1imghtlak.mmtcdn.com/73d47564ece211e9aa380242ac110003.jpg', 'Bandra Kurla Complex', NULL, 'Very Good', '3.9', 4061, 5999, '950', 1),
(36, 'Hotel Heritage (Formerly known as Comfort Inn Heritage)', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=20071011144006487&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=18.97633&lng=72.83423&locusId=CTBOM&locusType=city&rank=310®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=8385797879259167845', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/20071011144006487-2a0cef2875b511e9b60c0242ac110004.jpg', 'https://r1imghtlak.mmtcdn.com/b409fa6cebeb11e881dd0242ac110002.jpg', 'https://r1imghtlak.mmtcdn.com/d1d8838801a911e8a7d602755708f0b3.jpg', 'South Mumbai', NULL, 'Very Good', '3.8', 4650, 5528, '1012', 1),
(37, 'Lemon Tree Premier Malad Mumbai', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=202309300912389249&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.17862&lng=72.83428&locusId=CTBOM&locusType=city&rank=311®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=-2734542775105973528', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/202309300912389249-8ec0e1fe-044b-4f45-9afb-d5e080e6a974.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/202309300912389249-51caebee-d152-42f9-b0c8-68b80e83fa94.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/202309300912389249-62997e98-eeb7-4830-b78a-575ea2c7151d.jpg', 'Malad', NULL, 'Very Good', '3.8', 4780, 8749, '1929', 1),
(38, 'ibis Mumbai Vikhroli - An Accor Brand', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=202109301930541946&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.12005&lng=72.92549&locusId=CTBOM&locusType=city&rank=320®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=4941868464078066183', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/202109301930541946-17c1d01a205611eca2660a58a9feac02.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/202109301930541946-7ffdc05c581011ec990a0a58a9feac02.jpg', 'https://r1imghtlak.mmtcdn.com/a3e01e5a8b2a11ec84490a58a9feac02.jpg', 'Vikhroli West', NULL, 'Very Good', '3.9', NULL, 5500, '660', 1),
(39, 'Lalco Residency | Service Apartment with Pool', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=201012152040593054&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.13888&lng=72.86663&locusId=CTBOM&locusType=city&rank=321®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=6122424015741548818', 'https://r1imghtlak.mmtcdn.com/3b710c52070011e7a2f30a209fbd0127.jpg', 'https://r1imghtlak.mmtcdn.com/1da54b166dc211e6ba3b001ec9b85d13.jpg', 'https://r1imghtlak.mmtcdn.com/cc67732e768e11e78aa20224510f5e5b.jpg', 'Andheri East', NULL, 'Very Good', '4', 5505, 8395, '1292', 1),
(40, 'Hotel Bawa Regency', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=201101120945152713&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.01404&lng=72.84367&locusId=CTBOM&locusType=city&rank=330®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=4791101669737761177', 'https://r1imghtlak.mmtcdn.com/ff45c9f0565511ee908c0a58a9feac02.jpg', 'https://r1imghtlak.mmtcdn.com/da583bf4372b11eda11f0a58a9feac02.jpg', 'https://r1imghtlak.mmtcdn.com/67a0c0fc372811ed83de0a58a9feac02.jpg', 'South Mumbai', NULL, 'Very Good', '4.1', NULL, 5750, '690', 1),
(41, 'Anantha Executive Suites', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=201410211150087280&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.13843&lng=72.93047&locusId=CTBOM&locusType=city&rank=331®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=2649063383069328157', 'https://r1imghtlak.mmtcdn.com/8919b608ced311ebb3a40242ac110003.jpg', 'https://r1imghtlak.mmtcdn.com/892991d6ced311eb8b620242ac110003.jpg', 'https://r1imghtlak.mmtcdn.com/a4bb057eced311ebb8ed0242ac110002.jpg', 'Kanjurmarg West', NULL, 'Very Good', '4', 5780, 6215, '1181', 1),
(42, 'Sarkar Chamber 3', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=202304051749191078&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.0562&lng=72.83391&locusId=CTBOM&locusType=city&rank=340®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=3489685718028493684', 'https://r1imghtlak.mmtcdn.com/d18b0b72-c3d7-49c9-96d0-798baeae27e3.webp', 'https://r1imghtlak.mmtcdn.com/96779c60-6278-4cb7-8632-adc27cf60da5.webp', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/room-imgs/202304051749191078-6946276-500e5416-524f-4524-870c-6c2b00a21ee9.jpg', 'Bandra West', NULL, 'Very Good', '4', 5642, 8000, '1277', 1),
(43, 'The Fern Shelter Resort Palghar', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=202304051848281896&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTPGG&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.61255&lng=72.91267&locusId=CTBOM&locusType=city&rank=341®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=3326542244573512616', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/202304051848281896-bbd587a6f8a311edaf490a58a9feac02.jpg', 'https://r1imghtlak.mmtcdn.com/4f868276d3b411ed88df0a58a9feac02.jpg', 'https://r1imghtlak.mmtcdn.com/a0ebe67ad3b311eda3780a58a9feac02.jpg', 'In Palghar', NULL, 'Excellent', '4.3', 6017, 9199, '1258', 1),
(44, 'Ibis Mumbai Airport - An Accor Brand', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=201104181849173183&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.09653&lng=72.85331&locusId=CTBOM&locusType=city&rank=350®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&viewType=PREMIUM&mtkeys=-6785126068544307726', 'https://r1imghtlak.mmtcdn.com/87ce55e4824a11e786b20a4cef95d023.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/201104181849173183-b3e579ccd02511e7a41d02edef3c3f98.jpg', 'https://r1imghtlak.mmtcdn.com/aabf6db2d02511e7aede0a337eb60284.jfif', 'Near Mumbai Airport', NULL, 'Very Good', '3.6', NULL, 5799, '696', 1),
(45, 'The Orchid Hotel Mumbai Vile Parle', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=20070418200017894&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.09715&lng=72.8547&locusId=CTBOM&locusType=city&rank=351®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&viewType=PREMIUM&mtkeys=-8526757130730118131', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/20070418200017894-92cb6404639411ea9f8f0242ac110005.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/20070418200017894-f7c10964b25b11e78f8102755708f0b3.jpg', 'https://r1imghtlak.mmtcdn.com/df1cbb06b25b11e7aedf02f506bf1356.jpg', 'Near Mumbai Airport', NULL, 'Very Good', '4', 6499, 8124, '780', 1),
(46, 'Aurika, Mumbai Skycity - Luxury by Lemon Tree Hotels', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=202308241203592886&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.10348&lng=72.86259&locusId=CTBOM&locusType=city&rank=360®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&viewType=LUXE&mtkeys=-6046176741368761906', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/202308241203592886-b5f3cfef-aa5e-4186-a161-26a14c7b4bc4.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/202308241203592886-53e5591c854011ee8a170a58a9feac02.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/202308241203592886-28f537047a3211eea2ff0a58a9feac02.jpg', 'Near Mumbai Airport', NULL, 'Very Good', '4.2', 6153, 7999, '2888', 1),
(47, 'Maxxvalue Apartment Hiranandani Powai A', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=202303301459199491&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.11707&lng=72.91017&locusId=CTBOM&locusType=city&rank=361®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=-1777425752247566853', 'https://r1imghtlak.mmtcdn.com/3f1f66ef-408e-4af6-8638-49a5dadbece3.jpg', 'https://r1imghtlak.mmtcdn.com/945a2317-344f-4268-9a22-6947a5f88cfc.jpg', 'https://r1imghtlak.mmtcdn.com/1fbfaaa9-157f-4ac2-82db-6225be63cb0f.jpg', 'Powai', NULL, 'Very Good', '3.7', 6795, 7499, '900', 1),
(48, 'Hotel Godwin', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=200701101227074979&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=18.91954&lng=72.82973&locusId=CTBOM&locusType=city&rank=370®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=-2130195969447284447', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/200701101227074979-1b72892a8c4211e9898a0242ac110003.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/200701101227074979-e22226368c4011e9b7f70242ac110003.jpg', 'https://r1imghtlak.mmtcdn.com/d3c315e260ad11e881a002f1ccfb6150.jpg', 'Colaba', NULL, 'Very Good', '3.8', 4119, 5400, '841', 1),
(49, 'Ascot Hotel Colaba', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=202112241730592174&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=18.9191&lng=72.82996&locusId=CTBOM&locusType=city&rank=375®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=2532617148755921742', 'https://r1imghtlak.mmtcdn.com/c1008288a48211ec9f330a58a9feac02.jpg', 'https://r1imghtlak.mmtcdn.com/086386ec585111eeb45d0a58a9feac02.jpg', 'https://r1imghtlak.mmtcdn.com/0879ebd0585111ee952d0a58a9feac02.jpg', 'Colaba', NULL, 'Excellent', '4.5', 7208, 9568, '1938', 1),
(50, 'The Mirador', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=200701101027047664&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.11134&lng=72.8604&locusId=CTBOM&locusType=city&rank=376®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&viewType=PREMIUM&mtkeys=-2439557971554924354', 'https://r1imghtlak.mmtcdn.com/882d6606beb911ebbd500242ac110003.jpg', 'https://r1imghtlak.mmtcdn.com/be46b102beb911ebb5c20242ac110002.jfif', 'https://r1imghtlak.mmtcdn.com/8ee1efb6717f11e7900a025f77df004f.jpg', 'Near Mumbai Airport', NULL, 'Very Good', '3.8', NULL, 7250, '870', 1),
(51, 'Hotel Kohinoor Elite', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=201106121030265508&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.07987&lng=72.8846&locusId=CTBOM&locusType=city&rank=377®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=1877854307140666340', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/201106121030265508-cd311204-0865-4c25-9454-0fce3f57e4b1.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/201106121030265508-0b59814e-09ed-4534-86c3-4bc9a4e09ffb.jpg', 'https://r1imghtlak.mmtcdn.com/d3093916208c11eea85c0a58a9feac02.jpg', 'Near Mumbai Airport', NULL, 'Very Good', '4.1', NULL, 7300, '876', 1),
(52, 'Theory9 | Premium Serviced Apartments, Khar', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=201806201336495028&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.06785&lng=72.8381&locusId=CTBOM&locusType=city&rank=378®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=-8768917807099326240', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/201806201336495028-d15468e8946a11ec93ec0a58a9feac02.jpg', 'https://r1imghtlak.mmtcdn.com/bf6245b6d11711e892860242ac110003.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/room-imgs/201806201336495028-3065690-fd05c6fc9a9011e9ae6e0242ac110003.jpg', 'Khar West', NULL, 'Very Good', '4.2', 7979, 8399, '1436', 1),
(53, 'Meluha - The Fern', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=201103131349186890&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.1177&lng=72.91087&locusId=CTBOM&locusType=city&rank=379®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&viewType=PREMIUM&mtkeys=-6885976037483584062', 'https://r1imghtlak.mmtcdn.com/qlh0j89put6tl7pr4t3vo14f0054.jpg', 'https://r1imghtlak.mmtcdn.com/cscv0rqgv55mb36f2aoocef10014.jpg', 'https://r1imghtlak.mmtcdn.com/f1bd0ae2f69211e7bb02025f77df004f.jpg', 'Powai', NULL, 'Excellent', '4.4', 8348, 10000, '2250', 1),
(54, 'Grand Residency Hotel and Serviced Apartments', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=200812181556001969&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.06194&lng=72.83249&locusId=CTBOM&locusType=city&rank=380®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=-8436970318351624456', 'https://r1imghtlak.mmtcdn.com/c118efd2536d11e7889b025f77df004f.jpg', 'https://r1imghtlak.mmtcdn.com/c7ddcee601be11e8a8b802c0ffdf47b0.jfif', 'https://r1imghtlak.mmtcdn.com/e3f4e8d4e4a911e899070242ac110003.jpg', 'Bandra West', NULL, 'Very Good', '4', 7467, 12350, '2007', 1),
(55, 'Sun-N-Sand', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=200704092047307700&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.10976&lng=72.82439&locusId=CTBOM&locusType=city&rank=390®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&viewType=PREMIUM&mtkeys=919868145748393582', 'https://r1imghtlak.mmtcdn.com/58ea7d68d47911eb9a330242ac110002.jpg', 'https://r1imghtlak.mmtcdn.com/10b301f853a111e7a366025f77df004f.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/200704092047307700-3t7mkce4f15vt64re6ieljg6001u.jpg', 'Juhu', NULL, 'Very Good', '4.2', 8181, 9000, '2250', 1),
(56, 'OSI Apartments Bandra West', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=202103111431265125&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.05502&lng=72.83707&locusId=CTBOM&locusType=city&rank=391®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=-8988716788419751907', 'https://r1imghtlak.mmtcdn.com/42d9ac6c822e11eb9f470242ac110002.jpg', 'https://r1imghtlak.mmtcdn.com/42c8d31a822e11eb82b10242ac110002.jpg', 'https://r1imghtlak.mmtcdn.com/42d10d96822e11eb8b040242ac110003.jpg', 'Bandra West', NULL, 'Very Good', '4', 8202, 9000, '2250', 1),
(57, 'Ramada Plaza By Wyndham Palm Grove, Juhu, Mumbai', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=200703221754425607&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.09875&lng=72.82703&locusId=CTBOM&locusType=city&rank=400®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&viewType=PREMIUM&mtkeys=8101475501622692978', 'https://r1imghtlak.mmtcdn.com/d154bc84f52311e78080025f77df004f.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/200703221754425607-ea8b444614e111eeab770a58a9feac02.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/200703221754425607-e9cb88fe14e111ee979f0a58a9feac02.jpg', 'Juhu', NULL, 'Very Good', '4.1', 8630, 14383, '1553', 1),
(58, 'Novotel Mumbai International Airport', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=202211131045515112&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.11014&lng=72.87423&locusId=CTBOM&locusType=city&rank=401®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&viewType=PREMIUM&mtkeys=2503822207535345220', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/202211131045515112-0b133018930d11eda0690a58a9feac02.jpg', 'https://r1imghtlak.mmtcdn.com/0105f2de626811ed9de80a58a9feac02.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/202211131045515112-98184948c55e11eda4dd0a58a9feac02.jpg', 'Near Mumbai Airport', NULL, 'Excellent', '4.4', NULL, 8999, '1620', 1),
(59, 'ITC Grand Central - A Luxury Collection Hotel', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=201310261601384953&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=18.99824&lng=72.83823&locusId=CTBOM&locusType=city&rank=410®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&viewType=LUXE&mtkeys=-4386703227034339709', 'https://r1imghtlak.mmtcdn.com/752adab2727e11ea81e60242ac110002.jpg', 'https://r1imghtlak.mmtcdn.com/873aad94f6c611e780c8025f77df004f.jpg', 'https://r1imghtlak.mmtcdn.com/94r0pmtlv97sdaffshj7t6770011.jpg', 'South Mumbai', NULL, 'Excellent', '4.5', NULL, 9775, '1760', 1),
(60, 'Grand Hyatt Mumbai', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=201012191348155792&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.07741&lng=72.85118&locusId=CTBOM&locusType=city&rank=411®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&viewType=LUXE&mtkeys=-888839906751642625', 'https://r1imghtlak.mmtcdn.com/06f579d204f611ed850e0a58a9feac02.jpg', 'https://r1imghtlak.mmtcdn.com/4f92799ea8c011ebaddf0242ac110002.jpg', 'https://r1imghtlak.mmtcdn.com/985d80ce708911e78913025f77df004f.jpg', 'Near Mumbai Airport', NULL, 'Excellent', '4.3', NULL, 10000, '1800', 1),
(61, 'Intercontinental Marine Drive', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=200908131144551680&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=18.93505&lng=72.82407&locusId=CTBOM&locusType=city&rank=420®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&viewType=LUXE&mtkeys=-1476688234630123171', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/200908131144551680-0d98e97a923f11eb80da0242ac110002.jpg', 'https://r1imghtlak.mmtcdn.com/f04dc08e923e11eb8c7d0242ac110003.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/200908131144551680-0339d2749abd11ebac5a0242ac110004.jpg', 'Churchgate', NULL, 'Excellent', '4.4', NULL, 11750, '2115', 1),
(62, 'President, Mumbai - IHCL SeleQtions', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=200901081442472303&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=18.91475&lng=72.82076&locusId=CTBOM&locusType=city&rank=421®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&viewType=PREMIUM&mtkeys=-8853210955904267046', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/200901081442472303-ae1860c05ca611eb8a9c0242ac110003.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/200901081442472303-90e6d1521fb911ee90d30a58a9feac02.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/200901081442472303-268ec87020ab11eab13a0242ac11000f.jpg', 'South Mumbai', NULL, 'Excellent', '4.4', NULL, 12500, '2250', 1),
(63, 'Aashiyaanaa - The Palace | 1 BHK Villa', 'https://www.makemytrip.com/hotels/hotel-details?hotelId=201803281835056710&_uCurrency=INR&checkin=03242024&checkout=03252024&city=CTBOM&country=IN&filterData=USER_RATING_MMT_BRAND%7C3.5&lat=19.16866&lng=72.79095&locusId=CTBOM&locusType=city&rank=429®ionNearByExp=3&roomStayQualifier=2e0e&rsc=1e2e0e&searchText=Mumbai&sort=price-asc&mtkeys=7576618078062762254', 'https://r1imghtlak.mmtcdn.com/d35471aefafe11e9baf50242ac110002.jpg', 'https://r2imghtlak.mmtcdn.com/r2-mmt-htl-image/htl-imgs/201803281835056710-9716581c738111ec95110a58a9feac02.jpg', 'https://r1imghtlak.mmtcdn.com/aa9e7e544b2711ed935f0a58a9feac02.jpg', 'Madh', NULL, 'Very Good', '4', 26852, 28000, '5040', 1);
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` int(100) NOT NULL,
`first_name` varchar(255) DEFAULT NULL,
`last_name` varchar(255) DEFAULT NULL,
`phone` varchar(255) DEFAULT NULL,
`email` varchar(255) NOT NULL,
`password` varchar(500) DEFAULT NULL,
`role` varchar(255) NOT NULL DEFAULT 'User',
`status` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `first_name`, `last_name`, `phone`, `email`, `password`, `role`, `status`) VALUES
(1, 'Harsh', 'Vishwakarma', '9930546775', 'vishwakarmaharsh24@gmail.com', '$2y$10$uJDDUio3fLuw0V2FSq/v7OAb/KRfQLZS9aSn8JR0uWkC9G.DUA67q', 'Admin', 1);
--
-- Indexes for dumped tables
--
--
-- Indexes for table `bookings`
--
ALTER TABLE `bookings`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `hotels`
--
ALTER TABLE `hotels`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `bookings`
--
ALTER TABLE `bookings`
MODIFY `id` int(100) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `hotels`
--
ALTER TABLE `hotels`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;