-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `tripyork-task`
--

-- --------------------------------------------------------

--
-- Table structure for table `hotels`
--

CREATE TABLE `hotels` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `chain_id` int(10) UNSIGNED DEFAULT NULL,
  `chain_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `facilities` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hotel_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hotel_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hotel_id` int(10) UNSIGNED DEFAULT NULL,
  `hotel_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hotel_post_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image_id` int(10) UNSIGNED DEFAULT NULL,
  `images` text COLLATE utf8mb4_unicode_ci,
  `latitude` double UNSIGNED DEFAULT NULL,
  `longitude` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `min_rate` double UNSIGNED DEFAULT NULL,
  `place_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `place_id` int(10) UNSIGNED DEFAULT NULL,
  `place_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `place_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `popularity` int(10) UNSIGNED DEFAULT NULL,
  `property_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `property_type_id` int(10) UNSIGNED DEFAULT NULL,
  `star_rating` int(10) UNSIGNED DEFAULT NULL,
  `state_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state_place_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state_place_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `themes` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trademarked` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hotels`
--

INSERT INTO `hotels` (`id`, `chain_id`, `chain_name`, `country_code`, `country_filename`, `country_name`, `currency_code`, `facilities`, `hotel_address`, `hotel_filename`, `hotel_id`, `hotel_name`, `hotel_post_code`, `image_id`, `images`, `latitude`, `longitude`, `min_rate`, `place_filename`, `place_id`, `place_name`, `place_type`, `popularity`, `property_type`, `property_type_id`, `star_rating`, `state_name`, `state_place_filename`, `state_place_id`, `themes`, `trademarked`, `created_at`, `updated_at`) VALUES
(1, NULL, NULL, 'BS', 'Bahamas', 'The Bahamas', 'BSD', '40|51|52|53|56|202|210|211|242|253|298|299', 'Pelican Shores Road', 'Pelican_Beach_Villas', 1040890, 'Pelican Beach Villas', NULL, 286949691, '286949691|286949651|286949652|286949653|286949654|286949655|286949656|286949657|286949658|286949659|286949660|286949661|286949662|286949663|286949664|286949665|286949666|286949667|286949668|286949669|286949670|286949671|286949672|286949673|286949674|286949675|286949676|286949677|286949678|286949679|286949680|286949681|286949682|286949683|286949684|286949685|286949686|286949687|286949688|286949689|286949690|286949692|286949693|286949694|286949695|286949696|286949697|286949698', 26.55082, '-77.057928000000', NULL, 'Marsh_Harbour', 16150, 'Marsh Harbour', 'Town', 272694, NULL, 20, 3, NULL, NULL, NULL, '10', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(2, NULL, NULL, 'BS', 'Bahamas', 'The Bahamas', 'BSD', '7|13|21|34|40|41|51|53|56|59|202|222|242|253|281|299', 'Green Turtle Cay', 'Bluff_House_Beach_Resort_Marina', 1040891, 'Bluff House Beach Resort & Marina', NULL, 286048158, '286048158|286048129|286048130|286048131|286048132|286048133|286048134|286048135|286048136|286048137|286048138|286048139|286048140|286048141|286048142|286048143|286048144|286048145|286048146|286048147|286048148|286048149|286048150|286048151|286048152|286048153|286048154|286048155|286048156|286048157|286048159|286048160', 26.7766056, '-77.339937300000', NULL, 'Green_Turtle_Cay', 249026, 'Green Turtle Cay', 'Island', 243457, NULL, 7, 3, NULL, NULL, NULL, '1', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(3, NULL, NULL, 'BS', 'Bahamas', 'The Bahamas', 'BSD', '4|5|7|9|20|23|59|62|64|66|74|96|100|122|193|202|210|211|225|256', 'Bay Street. Marsh Harbour', 'Abaco_Beach_Resort_Boat_Harbour', 1040892, 'Abaco Beach Resort & Boat Harbour', NULL, 412989228, '412989228|412989229|356349297|412989232|356349302|412989235|412989240|412989243|412989251|412989256', 26.545326, '-77.048860000000', 351.0801, 'Marsh_Harbour', 16150, 'Marsh Harbour', 'Town', 167235, NULL, 7, 3, NULL, NULL, NULL, '1|13|14', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(4, NULL, NULL, 'GB', 'United_Kingdom', 'United Kingdom', 'GBP', '2|6|14|17|18|19|22|29|31|34|47|49|51|53|56|60|136|154|191|202|253|281', '43-45 Market Street', 'Aberdeen_Douglas_Hotel', 1040894, 'Aberdeen Douglas Hotel', NULL, 616810852, '616810852|553053280|553053279|553053285|595377010|595376988|595376989|595377006|595377007|595376992|595377003|595376994|595376996|595376998|595376999|595377009|607844961|553053267|616810846|616810847|553053270|616810848|553053284|616810849|553053273|616810850|553053282|553053274|553053271|616810851|553053286|553053278|553053251|553053269|616810853|553053266|553053262|553053263|616810854|616810855|553053252|553053275|616810856|616810857|616810858|616810859|553053255|616810860|566073127|607844960|616810861|553053254|605446272|553053253|595377011|553053268|616810862|553053283|553053272|616810863', 57.146203, '-2.095948000000', 77.1463, 'Aberdeen', 129745, 'Aberdeen', 'City', 14415, NULL, 0, 3, NULL, NULL, NULL, '2|6|7|13|16', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(5, 2228, 'OYO', 'GB', 'United_Kingdom', 'United Kingdom', 'GBP', '17|18|22|60|136|202|253|255|299', '1 Great Northern Road', 'Northern_Hotel_Aberdeen', 1040896, 'Northern Hotel Aberdeen', 'AB24 3PS', 578360082, '578360082|578360086|578360088|578360089|578360090|578360091|578360092|578360093|578360094|578360095|578360096|578360097|578360098|578360099|578360100|578360101|581290172|581290173|581290174|581290175', 57.1622125, '-2.116486100000', 55.318, 'Aberdeen', 129745, 'Aberdeen', 'City', 199572, NULL, 0, 3, NULL, NULL, NULL, '6', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(6, 197, 'Copthorne Hotels', 'GB', 'United_Kingdom', 'United Kingdom', 'GBP', '2|8|11|17|18|19|22|34|41|47|49|51|53|56|136|139|202|243|253|270|299', '122 Huntly Street', 'Copthorne_Hotel_Aberdeen', 1040900, 'Copthorne Hotel Aberdeen', 'AB10 1SU', 598012401, '598012401|603229815|534706763|603229101|603229102|603229103|603229104|534706761|543541510|534706770|598012403|598012409|603229105|603229106|603229107|603229108|603229109|603229110|603229111|598012402|598012404|598012405|598012406|598012407|598012408|543541509|598012410|543541512|543541513|598012411|543541506|543541508|534706774|534706775', 57.1461844, '-2.112113000000', 61.5566, 'Aberdeen', 129745, 'Aberdeen', 'City', 22637, NULL, 0, 4, NULL, NULL, NULL, '16', 'True', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(7, 2, 'Best Western', 'GB', 'United_Kingdom', 'United Kingdom', 'GBP', '39|53|202|210|211|212|253|299', 'Stirling Street', 'Carmelite_Hotel_BW_Signature_Collection', 1040903, 'Carmelite Hotel BW Signature Collection', NULL, 602460088, '602460088|602460089|602460090|602460091|602460092|602460093|602460094|602460095|602460096|602460097|602460098|602460099|602460100|602460101|602460102|602460103|602460104|602460105|602460106|602460107|602460108|602460109|602460110|602460111', 57.145914, '-2.097550000000', 55.0759, 'Aberdeen', 129745, 'Aberdeen', 'City', 34401, NULL, 0, 3, NULL, NULL, NULL, '2|6|7|10|17', 'True', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(8, 466, 'Marriott Hotels & Resorts', 'GB', 'United_Kingdom', 'United Kingdom', 'GBP', '1|2|3|4|5|6|7|15|17|19|20|21|30|31|33|34|35|41|46|49|51|53|56|60|136|141|202|209|221|240|243|255|259|270', 'Overton Circle-Dyce', 'Aberdeen_Marriott_Hotel', 1040906, 'Aberdeen Marriott Hotel', NULL, 609618234, '609618234|609618216|609618217|609618218|609618219|609618220|609618221|609618215|609618222|609618223|609618224|609618225|609618226|609618227|609618228|609618229|609618230|609618231|609618232|609618233', 57.1998749, '-2.183626900000', 85.7643, 'Aberdeen', 129745, 'Aberdeen', 'City', 55001, NULL, 0, 4, NULL, NULL, NULL, '8|10', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(9, NULL, NULL, 'GB', 'United_Kingdom', 'United Kingdom', 'GBP', '11|14|17|20|34|56|60|191|209|210|211', '59-63 Queens Road', 'The_Chester_Hotel', 1040908, 'The Chester Hotel', NULL, 608636673, '608636673|608636674|608636675|608636676|608636677|608636678|608636679|608636680|608636681|608636682|608636683|608636684|608636685|608636686', 57.1411018, '-2.137200100000', 115.5051, 'Aberdeen', 129745, 'Aberdeen', 'City', 1286301, NULL, 0, 4, NULL, NULL, NULL, '13', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(10, NULL, NULL, 'GB', 'United_Kingdom', 'United Kingdom', 'GBP', '14|15|22|34|40|47|49|50|51|52|53|56|136|191|202|209|230|281|298', '6 Union Grove', 'Skene_House_Hotels_Holburn', 1040909, 'Skene House Hotels - Holburn', NULL, 583112460, '583112460|583112429|583112454|583112446|583112439|583112437|598366317|583112453|583112458|583112444|583112450|583112443|598366319|583112455|583112461|583112447|583112434|583112436|583112433|583112456|583112457|583112462|583112430|583112463|583112448|583112459|583112449|583112445|583112438|598366318|583112432|583112451|583112440|583112431|583112435', 57.1404228, '-2.121098000000', NULL, 'Aberdeen', 129745, 'Aberdeen', 'City', 51009, NULL, 33, 4, NULL, NULL, NULL, '5|6|7|13', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(11, NULL, NULL, 'GB', 'United_Kingdom', 'United Kingdom', 'GBP', '2|6|14|18|19|20|22|30|34|47|49|53|60|136|191|202|210|211|230|232|255|281', '96 Rosemount Viaduct', 'Skene_House_Hotels_Rosemount', 1040910, 'Skene House Hotels - Rosemount', NULL, 552674483, '552674483|602416935|597069684|552674444|597069714|597069688|597069709|597069707|597069702|597069712|597069696|616779602|616779603|597069692|602416936|597069705|597069700|597069697|597069710|597069713|597069703|597069686|552674472|552674462|597069711|597069691|552674465|597069685|597069693|597069687|597069695|597069715|597069690|597069704|597069706|597069699|597069708|552674421|597069689|616779604|602416937|597069698|602416938|597069701', 57.148922, '-2.109872100000', NULL, 'Aberdeen', 129745, 'Aberdeen', 'City', 18118, NULL, 33, 4, NULL, NULL, NULL, '2|5|6|7|9|13', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(12, NULL, NULL, 'DE', 'Germany', 'Germany', 'EUR', '7|14|17|30|34|35|117|191|193|198|199|202|243|253|270', 'Adenauerallee 209', 'Art_Hotel_Aachen', 1040847, 'Art Hotel Aachen', NULL, 598786704, '598786704|598786705|368422356|368422359|368422358|368422355|368422360|368422370|368422364|368422373|368422375|368422376|368422377|368422378|368422379|368422357|368422361|368422368|368422372|598786706|368422367|368422362|368422369|368422363|368422371|368422365|368422354|368422366|368422374|368422380', 50.754561, '6.103624000000', 56.6137, 'Aachen', 22898, 'Aachen', 'City', 31438, NULL, 0, 3, 'North Rhine-Westphalia', 'North_Rhine_Westphalia', '125873', '13|14', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(13, 351, 'Ibis', 'DE', 'Germany', 'Germany', 'EUR', '1|8|10|15|17|18|21|30|35|41|47|49|53|56|60|136|181|202|209|210|211|212|243|253', 'Zollernstrasse 2', 'Ibis_Aachen_Hauptbahnhof', 1040848, 'Ibis Aachen Hauptbahnhof', NULL, 598027009, '598027009|598027008|595111252|595111253|595111254|598027010|595111251|543961358|595111250|598027011|598027012|595111261|598027013|595111255|547300085|595111262|595111263|595111256|595111264|598027014|547300077|547300078|595111257|595111258|595111265|595111259|595111266|547300083|595111267|595111260|595111268|595111269|595111270|595111271|598027015|598027016|598027017|598027018|595111272|543961361|595111273|547300087|598027019|547300088|547300089|543961363|543961360|547300090|595111274|595111275', 50.769268, '6.095584000000', 59.2077, 'Aachen', 22898, 'Aachen', 'City', 25698, NULL, 0, 2, 'North Rhine-Westphalia', 'North_Rhine_Westphalia', '125873', '5|6|7', 'True', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(14, NULL, NULL, 'DE', 'Germany', 'Germany', 'EUR', '2|5|7|9|11|13|17|19|22|30|35|39|40|53|60|136|141|193|202|243|254', 'Am Branderhof 101', 'Art_Hotel_Superior', 1040849, 'Art Hotel Superior', NULL, 609729992, '609729992|609729924|609729925|609729926|609729927|609729928|609729929|609729930|609729931|609729932|609729933|609729934|609729935|609729936|609729937|609729938|609729939|609729940|609729941|609729942|609729943|609729944|609729945|609729946|609729947|609729948|609729949|609729950|609729951|609729952|609729953|609729954|609729955|609729956|609729957|609729958|609729959|609729960|609729961|609729962|609729963|609729964|609729965|609729966|609729967|609729968|609729969|609729970|609729971|609729972|609729973|609729974|609729975|609729976|609729977|609729978|609729979|609729980|609729981|609729982|609729983|609729984|609729985|609729986|609729987|609729988|609729989|609729990|609729991|609729993|609729994|609729995|609729996|609729997', 50.759538, '6.105659000000', 59.3096, 'Aachen', 22898, 'Aachen', 'City', 18722, NULL, 0, 4, 'North Rhine-Westphalia', 'North_Rhine_Westphalia', '125873', '8|9|10|12|13|14', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(15, NULL, NULL, 'DE', 'Germany', 'Germany', 'EUR', '5|7|13|14|17|18|30|35|56|60|64|117|141|191|240|243|256|270|278', 'Adele Weidtman Strasse 87-93', 'Hotel_Rosenpark_Laurensberg', 1040850, 'Hotel Rosenpark Laurensberg', NULL, 368422466, '368422466|368422475|368422485|368422471|368422477|368422476|368422470|368422469|368422467|368422481|368422472|368422486|368422484|368422474|368422483|368422473|368422482|368422468', 50.800734, '6.065533000000', 75.4849, 'Aachen', 22898, 'Aachen', 'City', 82368, NULL, 0, 3, 'North Rhine-Westphalia', 'North_Rhine_Westphalia', '125873', '13|14|17', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(16, NULL, NULL, 'DE', 'Germany', 'Germany', 'EUR', '17|22|39|53|56|60|62|139|202|209|210|211|212|299', 'Passstrasse 2a', 'Hotel_Granus', 1040851, 'Hotel Granus', NULL, 368422730, '368422730|368422731|368422732|368422716|368422728|368422715|368422725|368422724|368422714|368422717|368425674|368425673|368422726|368422727|368422720|368422722|368422723|368422721|368422713|368422729|368425672|368425675|368425676', 50.779264, '6.098405000000', 94.675, 'Aachen', 22898, 'Aachen', 'City', 73001, NULL, 0, 3, 'North Rhine-Westphalia', 'North_Rhine_Westphalia', '125873', '5|6|7|14', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(17, NULL, NULL, 'DE', 'Germany', 'Germany', 'EUR', '17|53|202|255|259|270|299', 'Friedlandstrasse 20', 'Bestprice_Hotel_Aachen_City', 1040852, 'Bestprice Hotel Aachen City', NULL, 589088733, '589088733|589088734|589088735|589088736|589088737|589088738|589088739|589088740|589088741|589088742|589088743|589088744|589088745|589088746', 50.767363, '6.086764000000', 51.2339, 'Aachen', 22898, 'Aachen', 'City', 435708, NULL, 0, 3, 'North Rhine-Westphalia', 'North_Rhine_Westphalia', '125873', '3|5|6|7', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(18, NULL, NULL, 'DE', 'Germany', 'Germany', 'EUR', '1|2|4|5|6|7|8|13|15|17|18|19|21|22|31|33|34|39|49|53|56|139|141|193|202|203|210|211|221|253|270|299', 'Monheimsallee 52', 'Parkhotel_Quellenhof_Aachen', 1040853, 'Parkhotel Quellenhof Aachen', NULL, 592619143, '592619143|592619144|592619145|592619146|592619147|592619148|592619149|592619150|592619151|592619152|592619153|592619154|592619155|592619156|592619157|592619158|592619159', 50.7814537, '6.090672100000', 167.1571, 'Aachen', 22898, 'Aachen', 'City', 19342, NULL, 0, 5, 'North Rhine-Westphalia', 'North_Rhine_Westphalia', '125873', '2|5|6|7|8|10|12|14|17', 'True', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(19, NULL, NULL, 'DE', 'Germany', 'Germany', 'EUR', '2|5|17|34|39|40|53|56|66|202|209|299', 'Turmstrasse 174', 'Hotel_Baccara', 1040854, 'Hotel Baccara', NULL, 616693328, '616693328|616693327|616693329|616693330|616693331|602392877|616693332|616693333|602392873|616693334|616693335|616693336|616693337|616693338|616693339|616693340|616693341|616693342|602392876|616693343|616693344|616693345|616693346|616693347|616693348|602392875|602392874|616693349', 50.77671, '6.072901000000', 80.2896, 'Aachen', 22898, 'Aachen', 'City', 252403, NULL, 0, 3, 'North Rhine-Westphalia', 'North_Rhine_Westphalia', '125873', '5|6|7', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(20, NULL, NULL, 'DE', 'Germany', 'Germany', 'EUR', '5|6|34|49|66|104|139|278', 'Raafstrasse 76-80', 'Hotel_Zur_Heide', 1040855, 'Hotel Zur Heide', NULL, 297742096, '297742096|297742064|297742065|297742066|297742067|297742068|297742069|297742070|297742071|297742072|297742073|297742074|297742075|297742076|297742077|297742078|297742079|297742080|297742081|297742082|297742083|297742084|297742085|297742086|297742087|297742088|297742089|297742090|297742091|297742092|297742093|297742094|297742095|297742097|297742098', 50.715484, '6.131145000000', 88.6648, 'Aachen', 22898, 'Aachen', 'City', 144854, NULL, 16, 1, 'North Rhine-Westphalia', 'North_Rhine_Westphalia', '125873', '7|15', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(21, 2, 'Best Western', 'DE', 'Germany', 'Germany', 'EUR', '1|2|8|11|17|20|21|31|34|39|41|43|47|49|51|53|56|57|64|136|253|257|258|270|298', 'Jülicher Strasse 1', 'Best_Western_Hotel_Royal_Aachen', 1040863, 'Best Western Hotel Royal Aachen', NULL, 368423059, '368423059|368423064|368423073|368423068|368423066|368423077|368423075|368423063|368423083|368423088|368423092|368423069|368423062|368423084|368423086|368423078|368423090|368423067|368423091|368423070|368423072|368423065|368423061|368423060|368423079|368423076|368423074|368423071|368423080|368423081|368423082|368423085|368423087|368423089|368423093|368423094|384906369', 50.778519, '6.095237000000', 129.8625, 'Aachen', 22898, 'Aachen', 'City', 118203, NULL, 0, 4, 'North Rhine-Westphalia', 'North_Rhine_Westphalia', '125873', '5|6|7', 'True', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(22, NULL, NULL, 'DE', 'Germany', 'Germany', 'EUR', '2|3|4|5|18|19|22|30|31|33|41|49|53|56|60|66|117|136|141|202|209|243|254|255|270|278|281', 'Stuttgarter Strasse 45-47', 'City_Hotel_Antik', 1040870, 'City Hotel Antik', NULL, 384592978, '384592978|384592979|384592980|384592981|384592982|384592983|384592984|384592985|384592986|384592987|384592988|384592989|384592993|384592994|384592990|384592995|384592992', 48.8346214, '10.091509800000', 95.1142, 'Aalen', 145659, 'Aalen', 'Town', 165414, NULL, 0, 3, 'Baden-Wurttemberg', 'Baden_Wurttemberg', '1447', '5|6|7', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(23, NULL, NULL, 'BS', 'Bahamas', 'The Bahamas', 'BSD', '7|13|20|23|40|41|52|56|82|96|100|189|202|210|211|212|242|281|299', 'PO Box 22275', 'Bahama_Beach_Club_Resort', 1040887, 'Bahama Beach Club Resort', NULL, 138325426, '138325426|138325381|138325383|138325387|138325390|138325391|138325396|138325397|138325399|138325402|138325404|138325409|138325411|138325414|138325416|138325418|138325420', 26.6759388, '-77.276245500000', NULL, 'Green_Turtle_Cay', 249026, 'Green Turtle Cay', 'Island', 215591, NULL, 7, 4, NULL, NULL, NULL, NULL, 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(24, NULL, NULL, 'BS', 'Bahamas', 'The Bahamas', 'BSD', '5|7|11|13|15|21|22|34|46|47|51|64|74|96|100|141|202|222|255|257|281|299', 'Green Turtle Cay', 'Green_Turtle_Club_Resort_Marina', 1040889, 'Green Turtle Club Resort & Marina', NULL, 611805532, '611805532|611805405|611805406|611805407|611805408|611805409|611805512|611805513|611805514|611805515|611805516|611805517|611805518|611805519|611805520|611805521|611805522|611805523|611805524|611805525|611805526|611805527|611805528|611805529|611805530|611805531|611805533|611805534|611805535|611805536|611805537|611805538|611805539|611805540|611805541|611805542|611805543|611805544|611805545|611805546|611805547|611805548|611805549|611805550|611805551|611805552|553346272|553346276|553346266|553346286|553346278|553346253|553346284|553346259|553346296|553346279|553346274|553346256|553346264|553346258|553346265|553346289|553346277|553346273|553346287|553346260|553346262|553346288|553346271|553346285|553346257|553346267|553346297|553346283|553346270|553346294|553346255|553346263|553346295|553346269|553346261|553346290|553346293|553346291|553346275|553346280|553346254|553346281|553346292|553346282|553346268|553346252', 26.7819934, '-77.335940200000', 328.4676, 'Green_Turtle_Cay', 249026, 'Green Turtle Cay', 'Island', 257992, NULL, 7, 3, NULL, NULL, NULL, '10|17', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(25, NULL, NULL, 'ES', 'Spain', 'Spain', 'EUR', '1|2|3|4|5|7|11|13|17|18|19|20|21|22|30|33|34|39|40|49|53|56|60|104|136|141|189|202|229|240|243|255|281', 'Avenida Fernández Latorre 45', 'Hotel_Plaza_A_Coruna', 1040825, 'Hotel Plaza A Coruna', NULL, 595208290, '595208290|552712634|601001951|601001934|595208284|601001949|601001930|601001938|601001924|601001942|601001953|601001925|601001926|598531234|601001944|601001927|552712654|598531235|604325776|601001931|601001937|601001935|601001945|601001956|601001940|601001948|601001921|601001928|601001941|601001952|601001939|601001947|601001922|601001932|601001943|601001929|601001936|552712632|601001919|552712655|601001933|617038777|601001950|601001946|595208283|601001954|601001923|601001920', 43.356142, '-8.404471000000', 58.4828, 'A_Coruna', 154259, 'A Coruna', 'City', 24842, NULL, 0, 3, NULL, NULL, NULL, '2|5|10|12', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(26, NULL, NULL, 'DE', 'Germany', 'Germany', 'EUR', '17|22|34|56|202|270|299', 'Saarstrasse 108', 'Hotel_Lousberg', 1040834, 'Hotel Lousberg', NULL, 581486864, '581486864|581486853|581486832|581486863|581486866|598916149|598916146|581486849|598916151|581486865|598916150|598916143|581486854|581486824|598916147|581486852|581486847|581486860|581486862|581486855|598916148|581486851|581486861|581486826|598916145|598916142|581486830|598916144|598916141|581486831|581486825|581486850|581486829', 50.781928, '6.088150000000', 83.8721, 'Aachen', 22898, 'Aachen', 'City', 153888, NULL, 0, 3, 'North Rhine-Westphalia', 'North_Rhine_Westphalia', '125873', '5|6|7', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(27, 407, 'Mercure', 'DE', 'Germany', 'Germany', 'EUR', '1|3|5|7|8|17|18|19|20|21|31|34|35|39|40|41|45|47|49|51|53|56|104|117|136|141|189|202|210|211|212|221|222|243|253|255|259|270', 'Joseph Von Goerres Strasse 27', 'Mercure_Aachen_Europaplatz', 1040835, 'Mercure Aachen Europaplatz', NULL, 594514771, '594514771|594514772|594514764|594514773|594514763|594514774|594514775|594514776|594514777', 50.7813301, '6.107090000000', 70.4706, 'Aachen', 22898, 'Aachen', 'City', 58412, NULL, 0, 3, 'North Rhine-Westphalia', 'North_Rhine_Westphalia', '125873', '2|13|14', 'True', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(28, NULL, NULL, 'DE', 'Germany', 'Germany', 'EUR', '17|47|53|56|117|136|202|210|211|255|259|270|278|299', 'Seilgraben 2', 'Minx_CityHotels', 1040836, 'Minx - CityHotels', NULL, 553223169, '553223169|553223150|553223156|553223154|553223147|553223161|553223166|553223146|553223162|553223157|553223151|553223155|553223165|553223152|553223160|553223159|553223149|553223148|553223153|553223158|553223164|553223145|553223168|553223163|553223167', 50.778041, '6.088062000000', 75.0056, 'Aachen', 22898, 'Aachen', 'City', 159228, NULL, 0, 2, 'North Rhine-Westphalia', 'North_Rhine_Westphalia', '125873', '5|6|7', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(29, 406, 'Novotel', 'DE', 'Germany', 'Germany', 'EUR', '1|2|4|5|8|9|13|17|19|21|31|33|39|41|45|47|51|53|56|136|141|194|202|209|210|211|212|243|270', 'Peterstrasse 66', 'Novotel_Aachen_City', 1040837, 'Novotel Aachen City', NULL, 589089792, '589089792|589089793|589089794|589089795|589089796|589089797|589089798|589089799|589089800|589089801|589089802|589089803|589089804|589089805|589089806|589089807|589089808|589089809|589089810|589089811|589089812|589089813|589089814|589089815|589089816|589089817|589089818', 50.777684, '6.092076000000', 101.2456, 'Aachen', 22898, 'Aachen', 'City', 15852, NULL, 0, 4, 'North Rhine-Westphalia', 'North_Rhine_Westphalia', '125873', '5|6|7', 'True', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(30, 88, 'TOP Hotels', 'DE', 'Germany', 'Germany', 'EUR', '3|4|7|17|18|22|23|30|31|35|53|66|102|103|107|117|193|202|210|211|221|243|253|254|264', 'Adenauerallee 215', 'TOP_Hotel_Buschhausen', 1040838, 'TOP Hotel Buschhausen', NULL, 604208887, '604208887|581619765|581619751|581619757|581619752|604208884|581619749|604208868|604208858|604208860|604208878|604208859|604208865|581619764|581619761|604208861|604208862|604208871|604208873|581619753|581619763|604208877|604208879|604208875|604208885|581619750|604208886|604208883|616706884|604208866|604208881|604208870|616706885|616706886|604208864|604208872|604208874|604208882|581619768|604208869|604208876|616706887|604208867|604208863', 50.754094, '6.103221000000', 43.1342, 'Aachen', 22898, 'Aachen', 'City', 119353, NULL, 0, 3, 'North Rhine-Westphalia', 'North_Rhine_Westphalia', '125873', NULL, 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(31, NULL, NULL, 'DE', 'Germany', 'Germany', 'EUR', '2|5|7|8|49|53|66|117|202|210|211|299', 'Schleidener Strasse 132', 'Brunnenhof_Aachen', 1040839, 'Brunnenhof Aachen', NULL, 368421467, '368421467|368421466|368421468|368421469|368421470|368421471|368421472|368421464|368421473|368421474|368421475|368421476|368421477|368421463|368421462|368421465', 50.7076025, '6.182737900000', 65.8995, 'Aachen', 22898, 'Aachen', 'City', 204222, NULL, 0, 3, 'North Rhine-Westphalia', 'North_Rhine_Westphalia', '125873', '6|7', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(32, NULL, NULL, 'DE', 'Germany', 'Germany', 'EUR', '9|13|17|18|20|22|30|33|39|47|53|56|60|62|117|136|141|202|243|253|259|264|270|278|299', 'Juelicher Strasse 91A', 'Hotel_Krone_Aachen_City_Eurogress', 1040840, 'Hotel Krone Aachen City Eurogress', NULL, 552678904, '552678904|552678865|552678882|552678851|552678902|552678908|552678894|552678885|552678863|552678899|552678868|552678855|552678906|552678860|600910682|552678898|552678896|552678848|552678905|552678846|552678907|552678901|552678858|552678854|552678847|552678845|552678895|552678888|552678850|552678872|552678897|552678893|552678890|552678903|552678859|552678877|600910679|552678879|552678887|552678881|552678870|552678900|552678864|600910681|552678874|552678873|552678849|552678869|552678856|552678884|552678867|552678876|552678862|552678892|552678891|552678889|552678875|552678852|552678866|552678853|552678886|552678883|552678878|552678857', 50.780331, '6.100893000000', 39.9231, 'Aachen', 22898, 'Aachen', 'City', 42986, NULL, 0, 3, 'North Rhine-Westphalia', 'North_Rhine_Westphalia', '125873', '5|6|7', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(33, 407, 'Mercure', 'DE', 'Germany', 'Germany', 'EUR', '1|7|8|10|13|15|17|18|19|20|21|22|31|33|35|38|41|45|46|47|53|56|64|98|99|107|136|141|181|185|202|209|222|223|257|259', 'Peterstrasse 1', 'Mercure_Hotel_Aachen_Am_Dom', 1040841, 'Mercure Hotel Aachen Am Dom', NULL, 598036289, '598036289|598036290|598036291|598036292|598036293|598036294|598036295|517031451|517031453|517031454|517031455|598036296|598036297|598036298|598036299|598036300|598036301|517031456', 50.775225, '6.088152000000', 69.4781, 'Aachen', 22898, 'Aachen', 'City', 15358, NULL, 0, 4, 'North Rhine-Westphalia', 'North_Rhine_Westphalia', '125873', '5|6|7|13|14', 'True', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(34, 2017, 'Leonardo', 'DE', 'Germany', 'Germany', 'EUR', '3|5|13|15|17|21|22|39|49|53|136|202|243|259|264', 'Krefelder Strasse 221', 'Leonardo_Hotel_Aachen', 1040842, 'Leonardo Hotel Aachen', NULL, 609584985, '609584985|609584953|609584954|609584955|609584956|609584957|609584958|609584959|609584960|609584961|609584962|609584963|609584964|609584965|609584966|609584967|609584968|609584969|609584970|609584971|609584972|609584973|609584974|609584975|609584976|609584977|609584978|609584979|609584980|609584981|609584982|609584983|609584984|609584986|609584987|609584988|609584989|609584990|609584991|609584992|609584993|609584994|609584995|609584996', 50.796146, '6.102532000000', 65.9503, 'Aachen', 22898, 'Aachen', 'City', 28463, NULL, 0, 4, 'North Rhine-Westphalia', 'North_Rhine_Westphalia', '125873', NULL, 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(35, 454, 'Ibis Styles', 'DE', 'Germany', 'Germany', 'EUR', '6|8|17|21|22|41|45|47|49|53|56|202|253|259|270|299', 'Juelicher Strasse 10-12', 'Ibis_Styles_Hotel_Aachen_City', 1040843, 'Ibis Styles Hotel Aachen City', NULL, 598290493, '598290493|581391282|581391258|581391286|581391257|581391285|581391251|581391256|581391252|581391262|581391271|581391283|581391270|585313612|585313615|585313618|585313616|585313613|589209419|589209418|589209420|598290523|598290511|598290522|598290499|598290506|598290500|598290498|598290513|598290501|598290508|598290497|598290495|598290507|598290514|598290503|598290512|598290504|598290509|598290496|598290494|598290502|607864411|607864409|607864412|607864410', 50.778504, '6.096039000000', NULL, 'Aachen', 22898, 'Aachen', 'City', 9289, NULL, 0, 2, 'North Rhine-Westphalia', 'North_Rhine_Westphalia', '125873', '2|6|17', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(36, NULL, NULL, 'DE', 'Germany', 'Germany', 'EUR', '8|9|11|17|19|20|30|47|53|56|60|136|139|209|253|270|278', 'Büchel 32 / Buchkremerstrasse', 'Aquis_Grana_City_Hotel', 1040844, 'Aquis Grana City Hotel', NULL, 368422069, '368422069|368422066|368422068|368422071|368422065|368422074|368422078|368422085|368422086|368422087|368422088|368422090|368422091|368422075|368422073|368422072|368422070|368422067|368422064|368422063|368422062|368422081|368422080|368422079|368422077|368422076|368422082|368422083|368422084|368422089|368422092', 50.775659, '6.086097000000', 137.7899, 'Aachen', 22898, 'Aachen', 'City', 25002, NULL, 0, 4, 'North Rhine-Westphalia', 'North_Rhine_Westphalia', '125873', '5|6|7', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(37, NULL, NULL, 'DE', 'Germany', 'Germany', 'EUR', '4|5|7|8|17|34|47|66|107|117|136|202|210|211|243|253|278|299', 'Franzstrasse 21-23', 'Hotel_Benelux', 1040845, 'Hotel Benelux', NULL, 368421900, '368421900|368421902|368421927|368421928|368421908|368421896|368421915|368421914|368421926|368421909|368421912|368421907|368421913|368421906|368421910|368421899|368421903|368421901|368421898|368421904|368421905|368421925|368421930|368421922|368421923|368421924|368421921|368421929|368421920|368421911', 50.771018, '6.084843000000', NULL, 'Aachen', 22898, 'Aachen', 'City', 71729, NULL, 0, 3, 'North Rhine-Westphalia', 'North_Rhine_Westphalia', '125873', '5|6|7|17', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(38, 351, 'Ibis', 'DE', 'Germany', 'Germany', 'EUR', '1|5|8|10|15|17|18|30|31|33|35|41|47|53|56|60|99|136|181|202|243|253|255|281', 'Friedland Strasse 6-8', 'Ibis_Aachen_Marschiertor_Aix_La_Chapelle', 1040846, 'Ibis Aachen Marschiertor - Aix-La-Chapelle', NULL, 598022301, '598022301|598022302|598022303|598022304|690558082|691174432|594501700|594501697|594501692|594501703|594501696|594501699|594501691|691174433|594501698|594501705|594501695|594501706|594501707|690558080|690558081|691174430|691174431|598022305|691174435|598022306|594501708|594501701|594501709|594501694', 50.7677994, '6.085800200000', 62.8801, 'Aachen', 22898, 'Aachen', 'City', 28034, NULL, 0, 2, 'North Rhine-Westphalia', 'North_Rhine_Westphalia', '125873', '5|6|7', 'True', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(39, NULL, NULL, 'ES', 'Spain', 'Spain', 'EUR', '1|2|5|10|13|17|18|19|20|22|39|49|53|60|136|141|181|253', 'Avda. Pedro Barrie de la Maza, 29', 'Hotel_Riazor_A_Coruna', 1040796, 'Hotel Riazor A Coruna', NULL, 556133723, '556133723|597114164|597114165|597114166|597114167|597114168|556133710|556133689|598370867|556133692|556133720|556133718|556133697|616780963|556133684|556133708|556133712|616780964|598370847|556133706|556133721|598370856|598370852|556133698|556133686|556133725|556133724|556133707|598370860|598370858|598370866|556133683|556133696|616780965|556133688|556133682|556133726|616780966|598370849|598370894|556133705|598370854|556133704|598370893|616780967|598370862|556133709|598370892|556133722|598370864|556133711', 43.3683994, '-8.408929300000', 66.1152, 'A_Coruna', 154259, 'A Coruna', 'City', 14777, NULL, 0, 3, NULL, NULL, NULL, '1|2|5|6|7', 'True', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(40, 1341, 'Pousadas de Compostela', 'ES', 'Spain', 'Spain', 'EUR', '7|13|17|18|21|31|34|39|41|49|56|60|66|202|240|253', 'Piñon s/n 0', 'Hotel_Pazo_de_Lestrove', 1040805, 'Hotel Pazo de Lestrove', NULL, 286074393, '286074393|286074370|286074371|286074372|286074373|286074374|286074375|286074376|286074377|286074378|286074379|286074380|286074381|286074382|286074383|286074384|286074385|286074386|286074387|286074388|286074389|286074390|286074391|286074392|286074394', 42.7316399, '-8.670219400000', NULL, 'Dodro', 40199, 'Dodro', 'Town', 284426, NULL, 26, 4, NULL, NULL, NULL, '7|8|14|15|16|18', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(41, 1822, 'Hesperia', 'ES', 'Spain', 'Spain', 'EUR', '2|4|5|8|17|18|21|22|33|34|39|47|53|56|60|92|139|202|252|253', 'Juan Florez 16', 'Hesperia_A_Coruna_Centro', 1040808, 'Hesperia A Coruna Centro', NULL, 589708555, '589708555|589708511|589708514|589708512|589708520|589708542|579890039|589708546|589708515|589708523|589708543|589708554|579890042|589708535|589708527|589708518|589708540|589708538|589708510|589708533|589708551|589708545|589708556|589708548|589708544|579890084|589708547|589708530|589708552|589708519|589708513|589708516|589708521|589708557|589708534|589708558|607745058|589708525|589708541|589708517|589708531|589708549|589708529|589708526|589708539|589708553|589708524|589708532|589708522|589708536|589708528|589708550|589708537', 43.366169, '-8.408539000000', 81.7537, 'A_Coruna', 154259, 'A Coruna', 'City', 23845, NULL, 0, 4, NULL, NULL, NULL, '1|2|5|6|10|12', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(42, NULL, NULL, 'ES', 'Spain', 'Spain', 'EUR', '13|33|40|52|56|98|99|202|210|211|229|299', 'Paseo Maritimo, s/n', 'Hotel_Alda_Sada_Marina', 1040811, 'Hotel Alda Sada Marina', NULL, 522650255, '522650255|522650256|522650257|522650258|522650259|522650260|522650261|522650262|522650263|522650264|522650265|522650266', 43.3525895, '-8.253879700000', 42.1147, 'Sada_Galicia', 40268, 'Sada', 'Town', 623167, NULL, 0, 2, NULL, NULL, NULL, '1|6|9', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(43, 1820, 'NH Collection', 'ES', 'Spain', 'Spain', 'EUR', '2|4|5|6|7|12|14|17|18|19|20|21|22|23|33|34|35|40|47|49|56|60|62|66|92|95|104|139|189|191|202|220|223|253|264', 'Paseo del Parrote 2-4', 'NH_Collection_A_Coruna_Finisterre', 1040813, 'NH Collection A Coruna Finisterre', NULL, 609395899, '609395899|609395889|609395890|609395891|609395892|609395893|609395894|609395895|609395896|609395897|609395898|609395900|609395901|609395902|609395903|609395904|609395905|609395906|609395907|609395908|609395909|609395910|609395911|609395912|609395913|609395914|609395915|609395916|609395917|609395918', 43.369674, '-8.394338000000', 87.0952, 'A_Coruna', 154259, 'A Coruna', 'City', 19785, NULL, 0, 5, NULL, NULL, NULL, '6|7|8|9|10|13|14', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(44, 457, 'Meliá Hotels & Resorts', 'ES', 'Spain', 'Spain', 'EUR', '2|5|6|11|12|13|17|21|22|34|35|39|41|45|47|49|53|56|60|62|96|136|141|202|209|210|211|212|214|243|255|264', 'Avenida Pedro Barrie De La Maza, 1', 'Melia_Maria_Pita', 1040814, 'Melia Maria Pita', '15003', 583026753, '583026753|583026814|583026797|583026795|583026794|583026773|583026779|583026799|583026767|583026774|583026763|583026770|583026765|583026759|583026785|583026802|583026809|583026775|583026806|583026788|583026780|583026808|583026754|583026798|583026760|583026812|583026768|583026810|583026756|583026803|583026783|583026805|583026784|583026758|583026801|583026793|583026813|583026761|583026789|583026777|583026757|583026762|583026782|583026786|583026778|583026807|583026776|583026772|583026781|583026766|583026790|583026771|583026787|583026804|583026764|583026791|583026755|583026811|583026800|583026769|583026796|583026792', 43.37551, '-8.403125000000', 91.6156, 'A_Coruna', 154259, 'A Coruna', 'City', 9716, NULL, 0, 4, NULL, NULL, NULL, '6|12', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(45, 401, 'Zenit Hoteles', 'ES', 'Spain', 'Spain', 'EUR', '1|2|5|11|13|17|18|19|21|22|30|33|34|39|43|49|53|56|60|62|136|139|202|253|255|270|281', 'Comandante Fontanes 19', 'Zenit_Coruna', 1040816, 'Zenit Coruna', '15003', 552904067, '552904067|552904048|552904055|552904056|552904044|583223296|552904051|583223298|583223294|552904065|552904063|552904068|552904047|552904053|583223295|583223302|552904054|583223301|552904064|552904046|583223299|583223305|552904057|583223292|552904045|583223304|583223291|552904049|552904059|583223293|552904061|552904066|583223300|552904058|583223297|552904060|552904052|583223303|552904062|552904050', 43.36891, '-8.406723000000', 61.023, 'A_Coruna', 154259, 'A Coruna', 'City', 28043, NULL, 0, 4, NULL, NULL, NULL, '1|5|6|7', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(46, 398, 'Eurostars Hotels', 'ES', 'Spain', 'Spain', 'EUR', '2|4|11|13|17|18|19|20|21|22|33|34|39|53|56|62|136|139|141|202|253|299', 'Calle Juana De Vega 7', 'Eurostars_Blue_Coruna', 1040818, 'Eurostars Blue Coruna', '15004', 232246918, '232246918|232246919|595069400|595069401|232246920|595069402|232246900|232246903|232246915|595069403|232246908|232246907|232246911', 43.3664565, '-8.405413100000', 67.6968, 'A_Coruna', 154259, 'A Coruna', 'City', 11296, NULL, 0, 4, NULL, NULL, NULL, '6', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(47, 398, 'Eurostars Hotels', 'ES', 'Spain', 'Spain', 'EUR', '2|5|11|15|18|21|22|34|40|41|45|49|51|53|56|139|202|253|295|299', 'Avda. do Porto da Coruña 4', 'Eurostars_Atlantico', 1040819, 'Eurostars Atlantico', '15006', 530844855, '530844855|530931628|530844856|530931692|530931689|530931690|530931691|530931696|530931697|530931698|530931627|530931693|530931699|530931700|530931701|530931702|530931703|530931704|530931705|530931706|530931707|530931708|530931629|530844857|530931630|530931709|530931710|530931711|530931712|530931713|530844853|530844854|530931714|530687063|530931715|530931631|551032775|551032776|551032778|551032779|551032780|551032781|551032782|530931632|530687062|530931717|551032777|551032774', 43.3682828, '-8.400819100000', 64.3522, 'A_Coruna', 154259, 'A Coruna', 'City', 16274, NULL, 0, 4, NULL, NULL, NULL, '2|7|8', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(48, NULL, NULL, 'ES', 'Spain', 'Spain', 'EUR', '3|13|17|21|30|34|39|45|47|53|117|136|141|210|211|212|253|255', 'Av Ernesto Che Guevara 81C', 'Hotel_El_Pescador_Oleiros', 1040820, 'Hotel El Pescador Oleiros', NULL, 388573943, '388573943|388573975|388574015|388574030|388573958|388574049|388573961|388573883|388573894|388573983|388573896|388573952|388574003|388573904|388574019|388573864|388574062|388574043|388573970|388573913|388573994|388573989|388573868|388573930|388574059|388573885|388573872|388573965|388573907|388573927|388574008|388573890|388573917|388573939|388573979|388574024|388573875|388573934|388574034|388573900|388573947|388573922|388574070', 43.337403, '-8.373231000000', 46.6492, 'Oleiros', 40198, 'Oleiros', 'Town', 119879, NULL, 0, 1, NULL, NULL, NULL, '1|9', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(49, NULL, NULL, 'ES', 'Spain', 'Spain', 'EUR', '4|5|7|23|31|33|35|51|53|60|66|117|141|189|193|202|221|222|225|240|255', 'Pazo Do Rio 16', 'Hotel_Pazo_do_Rio', 1040821, 'Hotel Pazo do Rio', NULL, 620377408, '620377408|620377389|620377390|620377391|620377392|620377393|620377394|620377395|620377396|620377397|620377398|620377399|620377400|620377401|620377402|620377403|620377404|620377405|620377406|620377409|620377410|620377411|620377412|620377413|620377414|620377415|620377416|620377417|620377418|620377419|620377420|620377421|620377422|620377423|620377424|620377425|620377426', 43.330296, '-8.357684000000', 74.2847, 'Oleiros', 40198, 'Oleiros', 'Town', 212617, NULL, 9, 4, NULL, NULL, NULL, '8|9|10|13|14|15|16|17|18', 'True', '2023-02-21 13:22:24', '2023-02-21 13:22:24'),
(50, NULL, NULL, 'ES', 'Spain', 'Spain', 'EUR', '2|3|4|5|10|11|13|17|18|19|21|22|34|35|39|47|49|53|136|141|181|189|193|202|243|253|255', 'C/ Alvaro Cunqueiro 1', 'Hotel_Avenida_A_Coruna', 1040823, 'Hotel Avenida A Coruna', NULL, 115116191, '115116191|115116038|115116045|115116049|115116056|115116061|115116065|115116071|115116079|115116083|115116090|115116098|115116104|115116109|115116114|115116118|115116125|115116129|115116132|115116135|115116137|115116141|115116147|115116152|115116155|115116159|115116164|115116166|115116169|115116172|115116177|115116180|115116183|115116186|115116190', 43.34799, '-8.408310000000', 58.2737, 'A_Coruna', 154259, 'A Coruna', 'City', 40453, NULL, 0, 3, NULL, NULL, NULL, '2|3|6|9|12', 'False', '2023-02-21 13:22:24', '2023-02-21 13:22:24');

-- --------------------------------------------------------

--
-- Table structure for table `logs`
--

CREATE TABLE `logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_ip` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `data` json NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `logs`
--

INSERT INTO `logs` (`id`, `user_ip`, `data`, `type`, `created_at`, `updated_at`) VALUES
(1, '127.0.0.1', '[{\"city\": \"Aberdeen\", \"city_id\": 129745, \"popular_hotel\": {\"min_rate\": 115.5051, \"hotel_name\": \"The Chester Hotel\"}, \"cheapest_hotel\": {\"min_rate\": 55.0759, \"hotel_name\": \"Carmelite Hotel BW Signature Collection\"}}]', 'search_hotel', '2023-02-21 21:46:14', '2023-02-21 21:46:14'),
(2, '127.0.0.1', '[{\"city\": \"Aberdeen\", \"city_id\": 129745, \"popular_hotel\": {\"min_rate\": 115.5051, \"hotel_name\": \"The Chester Hotel\"}, \"cheapest_hotel\": {\"min_rate\": 55.0759, \"hotel_name\": \"Carmelite Hotel BW Signature Collection\"}}]', 'search_hotel', '2023-02-21 21:46:27', '2023-02-21 21:46:27'),
(3, '127.0.0.1', '[{\"city\": \"Aberdeen\", \"city_id\": 129745, \"popular_hotel\": {\"min_rate\": 115.5051, \"hotel_name\": \"The Chester Hotel\"}, \"cheapest_hotel\": {\"min_rate\": 55.0759, \"hotel_name\": \"Carmelite Hotel BW Signature Collection\"}}]', 'search_hotel', '2023-02-21 21:46:30', '2023-02-21 21:46:30'),
(4, '127.0.0.1', '[{\"city\": \"Aberdeen\", \"city_id\": 129745, \"popular_hotel\": {\"min_rate\": 115.5051, \"hotel_name\": \"The Chester Hotel\"}, \"cheapest_hotel\": {\"min_rate\": 55.0759, \"hotel_name\": \"Carmelite Hotel BW Signature Collection\"}}]', 'search_hotel', '2023-02-21 21:46:33', '2023-02-21 21:46:33'),
(5, '127.0.0.1', '[{\"city\": \"Aberdeen\", \"city_id\": 129745, \"popular_hotel\": {\"min_rate\": 115.5051, \"hotel_name\": \"The Chester Hotel\"}, \"cheapest_hotel\": {\"min_rate\": 55.0759, \"hotel_name\": \"Carmelite Hotel BW Signature Collection\"}}]', 'search_hotel', '2023-02-21 21:46:34', '2023-02-21 21:46:34'),
(6, '127.0.0.1', '[{\"city\": \"Aberdeen\", \"city_id\": 129745, \"popular_hotel\": {\"min_rate\": 115.5051, \"hotel_name\": \"The Chester Hotel\"}, \"cheapest_hotel\": {\"min_rate\": 55.0759, \"hotel_name\": \"Carmelite Hotel BW Signature Collection\"}}]', 'search_hotel', '2023-02-21 21:49:26', '2023-02-21 21:49:26'),
(7, '127.0.0.1', '[{\"city\": \"Aberdeen\", \"city_id\": 129745, \"popular_hotel\": {\"min_rate\": 115.5051, \"hotel_name\": \"The Chester Hotel\"}, \"cheapest_hotel\": {\"min_rate\": 55.0759, \"hotel_name\": \"Carmelite Hotel BW Signature Collection\"}}]', 'search_hotel', '2023-02-21 21:49:29', '2023-02-21 21:49:29'),
(8, '127.0.0.1', '[{\"city\": \"Aberdeen\", \"city_id\": 129745, \"popular_hotel\": {\"min_rate\": 115.5051, \"hotel_name\": \"The Chester Hotel\"}, \"cheapest_hotel\": {\"min_rate\": 55.0759, \"hotel_name\": \"Carmelite Hotel BW Signature Collection\"}}]', 'search_hotel', '2023-02-21 21:49:29', '2023-02-21 21:49:29'),
(9, '127.0.0.1', '[{\"city\": \"Aberdeen\", \"city_id\": 129745, \"popular_hotel\": {\"min_rate\": 115.5051, \"hotel_name\": \"The Chester Hotel\"}, \"cheapest_hotel\": {\"min_rate\": 55.0759, \"hotel_name\": \"Carmelite Hotel BW Signature Collection\"}}]', 'search_hotel', '2023-02-21 21:49:30', '2023-02-21 21:49:30'),
(10, '127.0.0.1', '[{\"city\": \"Aberdeen\", \"city_id\": 129745, \"popular_hotel\": {\"min_rate\": 115.5051, \"hotel_name\": \"The Chester Hotel\"}, \"cheapest_hotel\": {\"min_rate\": 55.0759, \"hotel_name\": \"Carmelite Hotel BW Signature Collection\"}}]', 'search_hotel', '2023-02-21 21:49:30', '2023-02-21 21:49:30'),
(11, '127.0.0.1', '[{\"city\": \"Aberdeen\", \"city_id\": 129745, \"popular_hotel\": {\"min_rate\": 115.5051, \"hotel_name\": \"The Chester Hotel\"}, \"cheapest_hotel\": {\"min_rate\": 55.0759, \"hotel_name\": \"Carmelite Hotel BW Signature Collection\"}}]', 'search_hotel', '2023-02-21 21:50:27', '2023-02-21 21:50:27'),
(12, '127.0.0.1', '[{\"city\": \"Aberdeen\", \"city_id\": 129745, \"popular_hotel\": {\"min_rate\": 115.5051, \"hotel_name\": \"The Chester Hotel\"}, \"cheapest_hotel\": {\"min_rate\": 55.0759, \"hotel_name\": \"Carmelite Hotel BW Signature Collection\"}}]', 'search_hotel', '2023-02-21 21:50:30', '2023-02-21 21:50:30'),
(13, '127.0.0.1', '[{\"city\": \"Aberdeen\", \"city_id\": 129745, \"popular_hotel\": {\"min_rate\": 115.5051, \"hotel_name\": \"The Chester Hotel\"}, \"cheapest_hotel\": {\"min_rate\": 55.0759, \"hotel_name\": \"Carmelite Hotel BW Signature Collection\"}}]', 'search_hotel', '2023-02-21 22:14:00', '2023-02-21 22:14:00'),
(14, '127.0.0.1', '[{\"city\": \"A Coruna\", \"city_id\": 154259, \"popular_hotel\": {\"min_rate\": 58.2737, \"hotel_name\": \"Hotel Avenida A Coruna\"}, \"cheapest_hotel\": {\"min_rate\": 58.2737, \"hotel_name\": \"Hotel Avenida A Coruna\"}}, {\"city\": \"Aachen\", \"city_id\": 22898, \"popular_hotel\": {\"min_rate\": 51.2339, \"hotel_name\": \"Bestprice Hotel Aachen City\"}, \"cheapest_hotel\": {\"min_rate\": 39.9231, \"hotel_name\": \"Hotel Krone Aachen City Eurogress\"}}, {\"city\": \"Aalen\", \"city_id\": 145659, \"popular_hotel\": {\"min_rate\": 95.1142, \"hotel_name\": \"City Hotel Antik\"}, \"cheapest_hotel\": {\"min_rate\": 95.1142, \"hotel_name\": \"City Hotel Antik\"}}, {\"city\": \"Aberdeen\", \"city_id\": 129745, \"popular_hotel\": {\"min_rate\": 115.5051, \"hotel_name\": \"The Chester Hotel\"}, \"cheapest_hotel\": {\"min_rate\": 55.0759, \"hotel_name\": \"Carmelite Hotel BW Signature Collection\"}}, {\"city\": \"Green Turtle Cay\", \"city_id\": 249026, \"popular_hotel\": {\"min_rate\": 328.4676, \"hotel_name\": \"Green Turtle Club Resort & Marina\"}, \"cheapest_hotel\": {\"min_rate\": 328.4676, \"hotel_name\": \"Green Turtle Club Resort & Marina\"}}, {\"city\": \"Marsh Harbour\", \"city_id\": 16150, \"popular_hotel\": {\"min_rate\": 351.0801, \"hotel_name\": \"Abaco Beach Resort & Boat Harbour\"}, \"cheapest_hotel\": {\"min_rate\": 351.0801, \"hotel_name\": \"Abaco Beach Resort & Boat Harbour\"}}, {\"city\": \"Sada\", \"city_id\": 40268, \"popular_hotel\": {\"min_rate\": 42.1147, \"hotel_name\": \"Hotel Alda Sada Marina\"}, \"cheapest_hotel\": {\"min_rate\": 42.1147, \"hotel_name\": \"Hotel Alda Sada Marina\"}}]', 'search_hotel', '2023-02-21 22:14:12', '2023-02-21 22:14:12'),
(15, '127.0.0.1', '[{\"city\": \"A Coruna\", \"city_id\": 154259, \"popular_hotel\": {\"min_rate\": 58.2737, \"hotel_name\": \"Hotel Avenida A Coruna\"}, \"cheapest_hotel\": {\"min_rate\": 58.2737, \"hotel_name\": \"Hotel Avenida A Coruna\"}}, {\"city\": \"Aachen\", \"city_id\": 22898, \"popular_hotel\": {\"min_rate\": 51.2339, \"hotel_name\": \"Bestprice Hotel Aachen City\"}, \"cheapest_hotel\": {\"min_rate\": 39.9231, \"hotel_name\": \"Hotel Krone Aachen City Eurogress\"}}, {\"city\": \"Aalen\", \"city_id\": 145659, \"popular_hotel\": {\"min_rate\": 95.1142, \"hotel_name\": \"City Hotel Antik\"}, \"cheapest_hotel\": {\"min_rate\": 95.1142, \"hotel_name\": \"City Hotel Antik\"}}, {\"city\": \"Aberdeen\", \"city_id\": 129745, \"popular_hotel\": {\"min_rate\": 115.5051, \"hotel_name\": \"The Chester Hotel\"}, \"cheapest_hotel\": {\"min_rate\": 55.0759, \"hotel_name\": \"Carmelite Hotel BW Signature Collection\"}}, {\"city\": \"Green Turtle Cay\", \"city_id\": 249026, \"popular_hotel\": {\"min_rate\": 328.4676, \"hotel_name\": \"Green Turtle Club Resort & Marina\"}, \"cheapest_hotel\": {\"min_rate\": 328.4676, \"hotel_name\": \"Green Turtle Club Resort & Marina\"}}, {\"city\": \"Marsh Harbour\", \"city_id\": 16150, \"popular_hotel\": {\"min_rate\": 351.0801, \"hotel_name\": \"Abaco Beach Resort & Boat Harbour\"}, \"cheapest_hotel\": {\"min_rate\": 351.0801, \"hotel_name\": \"Abaco Beach Resort & Boat Harbour\"}}, {\"city\": \"Sada\", \"city_id\": 40268, \"popular_hotel\": {\"min_rate\": 42.1147, \"hotel_name\": \"Hotel Alda Sada Marina\"}, \"cheapest_hotel\": {\"min_rate\": 42.1147, \"hotel_name\": \"Hotel Alda Sada Marina\"}}]', 'search_hotel', '2023-02-21 22:19:21', '2023-02-21 22:19:21');

-- --------------------------------------------------------

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(43, '2014_10_12_000000_create_users_table', 1),
(44, '2023_02_20_172500_create_hotels_table', 1),
(45, '2023_02_21_231542_create_logs_table', 2);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `hotels`
--
ALTER TABLE `hotels`
  ADD PRIMARY KEY (`id`),
  ADD KEY `hotels_place_name_index` (`place_name`);

--
-- Indexes for table `logs`
--
ALTER TABLE `logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `hotels`
--
ALTER TABLE `hotels`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;

--
-- AUTO_INCREMENT for table `logs`
--
ALTER TABLE `logs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;
COMMIT;

