Find the acceptance rate of requests which is defined as the ratio of accepted contacts vs all contacts. Multiply the ratio by 100 to get the rate.
table name: airbnb_contacts
Solution:
select 100.0* count(ts_accepted_at)/count(*) as acceptanceRate from airbnb_contacts;
Output:
SQL Script:
USE [StrataScratch]
GO
CREATE TABLE [dbo].[airbnb_contacts](
[id_guest] [varchar](50) NULL,
[id_host] [varchar](50) NULL,
[id_listing] [varchar](50) NULL,
[ts_contact_at] [datetime] NULL,
[ts_reply_at] [datetime] NULL,
[ts_accepted_at] [datetime] NULL,
[ts_booking_at] [datetime] NULL,
[ds_checkin] [datetime] NULL,
[ds_checkout] [datetime] NULL,
[n_guests] [int] NULL,
[n_messages] [int] NULL
) ON [PRIMARY]
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'86b39b70-965b-479d-a0b0-719b195acea2', N'1dfb22ec-c20e-4bf9-b161-1607afa25c5a', N'd668de42-122a-45cd-b91f-91a70895f902', CAST(N'2014-04-18T09:32:23.000' AS DateTime), CAST(N'2014-04-18T09:39:06.000' AS DateTime), NULL, NULL, CAST(N'2014-12-31T00:00:00.000' AS DateTime), CAST(N'2015-01-02T00:00:00.000' AS DateTime), 7, 5)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'14f943bb-74e9-458b-be55-203dc7220688', N'3347390d-8670-4870-9dab-da30f3700141', N'14c47fb8-e831-4044-9674-9b3fd0499193', CAST(N'2014-10-06T06:55:45.000' AS DateTime), CAST(N'2014-10-06T10:06:38.000' AS DateTime), CAST(N'2014-10-06T10:06:38.000' AS DateTime), CAST(N'2014-10-06T10:06:38.000' AS DateTime), CAST(N'2014-11-03T00:00:00.000' AS DateTime), CAST(N'2014-11-07T00:00:00.000' AS DateTime), 2, 8)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'425aa1ed-82ab-4ecf-b62f-d61e1848706d', N'02cafb86-5445-45cc-80f2-405291578356', N'c5a4a913-a094-4a9d-82e2-0b2d4f9d9eeb', CAST(N'2014-10-04T05:02:39.000' AS DateTime), CAST(N'2014-10-04T23:10:01.000' AS DateTime), NULL, NULL, CAST(N'2014-11-02T00:00:00.000' AS DateTime), CAST(N'2014-11-09T00:00:00.000' AS DateTime), 2, 2)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'bb490ede-8a70-4d61-a2e8-625855a393e2', N'f49c3095-58de-4b8d-9d5b-3bfceceb47d8', N'27f4b429-d544-464f-b4b5-3c09fd5992e7', CAST(N'2014-08-31T11:46:11.000' AS DateTime), CAST(N'2014-08-31T16:48:28.000' AS DateTime), NULL, NULL, CAST(N'2014-11-03T00:00:00.000' AS DateTime), CAST(N'2014-11-07T00:00:00.000' AS DateTime), 2, 5)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'b2fda15a-89bb-4e6e-ae81-8b21598e2482', N'71f1d49e-2ff4-4d72-b8e6-fd4c67feaa74', N'95fb78ca-8e6e-436a-9830-949d995ad14f', CAST(N'2014-10-08T15:07:56.000' AS DateTime), CAST(N'2014-10-08T15:32:12.000' AS DateTime), CAST(N'2014-10-08T15:32:12.000' AS DateTime), CAST(N'2014-10-08T22:21:41.000' AS DateTime), CAST(N'2014-11-06T00:00:00.000' AS DateTime), CAST(N'2014-11-09T00:00:00.000' AS DateTime), 2, 10)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'b8831610-31f2-4c58-8ada-63b3601ca476', N'bdd8a691-31e2-48d8-b526-6a75a4363b89', N'9633168d-9834-4887-af97-6af7db1d96ab', CAST(N'2014-10-14T04:05:14.000' AS DateTime), CAST(N'2014-10-14T08:48:41.000' AS DateTime), CAST(N'2014-10-14T08:48:41.000' AS DateTime), NULL, CAST(N'2014-11-07T00:00:00.000' AS DateTime), CAST(N'2014-11-29T00:00:00.000' AS DateTime), 2, 17)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'136c10f8-af53-4e5a-a5b3-d9c9c495b166', N'6dc86890-53d7-4d06-b767-5e117762d76b', N'2e6adb00-a660-465e-a85e-c8e341a5fb2f', CAST(N'2014-12-06T20:24:54.000' AS DateTime), CAST(N'2014-12-06T20:49:00.000' AS DateTime), CAST(N'2014-12-06T20:51:56.000' AS DateTime), CAST(N'2014-12-06T20:51:56.000' AS DateTime), CAST(N'2014-12-12T00:00:00.000' AS DateTime), CAST(N'2014-12-14T00:00:00.000' AS DateTime), 2, 13)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'9a45a950-b4f7-4f16-abe6-f9286abf2641', N'beeab7c3-ab4e-45d7-bde9-978de0fd8d57', N'c318d3e3-b36e-43b8-9b0c-3400cbca3895', CAST(N'2014-10-11T21:15:30.000' AS DateTime), CAST(N'2014-10-12T09:17:14.000' AS DateTime), NULL, NULL, CAST(N'2014-10-24T00:00:00.000' AS DateTime), CAST(N'2014-10-27T00:00:00.000' AS DateTime), 1, 3)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'1759c05e-f12a-4eaa-8059-3bcaca443c88', N'200a661e-2758-45e9-8bcc-42e32342e6bd', N'e465ef3d-3c26-4c46-b515-4b24d10bcdf8', CAST(N'2014-10-31T12:40:58.000' AS DateTime), CAST(N'2014-10-31T12:55:50.000' AS DateTime), NULL, NULL, CAST(N'2014-10-31T00:00:00.000' AS DateTime), CAST(N'2014-11-02T00:00:00.000' AS DateTime), 2, 3)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'126ed661-fa20-4041-ac16-ec118bbcce3b', N'a33e4240-6a0c-47b4-b866-45f9b5952c18', N'2d77af55-7f10-41d6-93da-383cf59082b6', CAST(N'2014-10-03T12:02:49.000' AS DateTime), CAST(N'2014-10-03T12:05:25.000' AS DateTime), NULL, NULL, CAST(N'2014-10-25T00:00:00.000' AS DateTime), CAST(N'2014-10-29T00:00:00.000' AS DateTime), 4, 2)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'924f864f-db83-4945-9a65-cf42a657ca68', N'7c0b097b-ea7c-4ea2-967a-8fe38fce6e95', N'f63e28a2-0f72-4b3e-8b5c-46284455ff9a', CAST(N'2014-10-21T20:57:44.000' AS DateTime), CAST(N'2014-10-21T21:12:25.000' AS DateTime), CAST(N'2014-10-23T21:04:47.000' AS DateTime), NULL, CAST(N'2014-11-09T00:00:00.000' AS DateTime), CAST(N'2014-11-15T00:00:00.000' AS DateTime), 3, 4)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'bd8f3dd6-fecc-479a-a88f-1d0049600e9f', N'd73772a8-efa3-445c-b9c2-0498fea9815f', N'5236a962-7989-4563-9d86-b3c5e5af4d6a', CAST(N'2014-10-09T07:46:25.000' AS DateTime), CAST(N'2014-10-09T08:04:13.000' AS DateTime), CAST(N'2014-10-09T08:04:13.000' AS DateTime), CAST(N'2014-10-09T09:30:18.000' AS DateTime), CAST(N'2014-10-10T00:00:00.000' AS DateTime), CAST(N'2014-10-12T00:00:00.000' AS DateTime), 2, 10)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'679d857b-08b8-4748-b703-86735aa42296', N'd7789520-e8d7-498b-88c4-e997da9b208c', N'7d051fe3-84d3-4234-a4cc-1f278f6bb068', CAST(N'2014-10-11T10:37:00.000' AS DateTime), CAST(N'2014-10-11T22:30:00.000' AS DateTime), NULL, NULL, CAST(N'2014-11-03T00:00:00.000' AS DateTime), CAST(N'2014-11-06T00:00:00.000' AS DateTime), 2, 4)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'673af82f-6a4d-4fd5-8485-4459670da9bc', N'fbab6ead-973c-4d1a-937c-0413c7d24fe7', N'c0a416ea-4260-409b-99e1-d2788d7e6308', CAST(N'2014-10-06T15:15:36.000' AS DateTime), CAST(N'2014-10-06T15:32:51.000' AS DateTime), CAST(N'2014-10-06T15:33:58.000' AS DateTime), CAST(N'2014-10-06T15:33:58.000' AS DateTime), CAST(N'2014-11-02T00:00:00.000' AS DateTime), CAST(N'2014-11-06T00:00:00.000' AS DateTime), 1, 7)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'b8285e97-9f11-4aec-bb05-e21f612ee41f', N'368e3d3c-1870-434e-99df-ff446daeecfa', N'50c63bda-8be1-4afa-96d0-91b0f277a9ac', CAST(N'2014-10-01T09:43:32.000' AS DateTime), CAST(N'2014-10-01T23:55:30.000' AS DateTime), NULL, NULL, CAST(N'2014-10-03T00:00:00.000' AS DateTime), CAST(N'2014-10-05T00:00:00.000' AS DateTime), 2, 3)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'6cbb33d1-6ecc-4f74-8b6a-a43d07d484b6', N'2b83ac1b-735f-41a6-ab9b-38bba7726051', N'fa2c5f7e-4139-4a63-91f7-49422e0d6c03', CAST(N'2014-10-01T15:43:25.000' AS DateTime), CAST(N'2014-10-02T08:22:22.000' AS DateTime), NULL, NULL, CAST(N'2014-10-04T00:00:00.000' AS DateTime), CAST(N'2014-10-07T00:00:00.000' AS DateTime), 3, 4)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'8375dde4-0de9-402c-8833-2127c1504601', N'a33e4240-6a0c-47b4-b866-45f9b5952c18', N'6cd0a8f1-396f-4d52-bc10-954f6c173dd0', CAST(N'2014-10-06T06:00:34.000' AS DateTime), CAST(N'2014-10-06T17:38:57.000' AS DateTime), NULL, NULL, CAST(N'2014-10-11T00:00:00.000' AS DateTime), CAST(N'2014-10-12T00:00:00.000' AS DateTime), 1, 7)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'a9f7ffb1-4970-492b-b448-4bd9d0fbeef3', N'0a62668d-ade2-4bf9-8b36-93923456378a', N'f8323e26-3c34-4034-a651-e54fbc45804b', CAST(N'2014-08-09T09:47:01.000' AS DateTime), CAST(N'2014-08-09T19:26:25.000' AS DateTime), NULL, NULL, CAST(N'2015-03-15T00:00:00.000' AS DateTime), CAST(N'2015-03-18T00:00:00.000' AS DateTime), 4, 4)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'bdaf2e68-86dd-40d9-a5a1-9cc95ea25d91', N'39436382-00ef-46ef-9768-1e611ae62857', N'98076842-d35e-4e94-a8e7-3440e31c7f8b', CAST(N'2014-10-12T09:14:35.000' AS DateTime), CAST(N'2014-10-12T09:21:19.000' AS DateTime), CAST(N'2014-10-12T09:21:24.000' AS DateTime), CAST(N'2014-10-12T10:11:00.000' AS DateTime), CAST(N'2014-10-16T00:00:00.000' AS DateTime), CAST(N'2014-10-19T00:00:00.000' AS DateTime), 1, 16)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'fad1a097-a511-4f44-a603-6a271c1f159e', N'66de508e-271c-4e97-8fc7-fa8d9ecf5018', N'b2601e35-4b68-4dfb-8669-256268ecd5a2', CAST(N'2014-10-04T18:58:12.000' AS DateTime), CAST(N'2014-10-05T09:49:56.000' AS DateTime), CAST(N'2014-10-05T09:49:56.000' AS DateTime), CAST(N'2014-10-05T11:21:05.000' AS DateTime), CAST(N'2014-10-05T00:00:00.000' AS DateTime), CAST(N'2014-10-06T00:00:00.000' AS DateTime), 2, 6)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'0a8e121b-c09c-4de1-abcc-81bce87de29e', N'becd48ad-623e-4821-9538-e9d8f84f1cac', N'dbf20ee5-e592-4659-a651-f05c10771c12', CAST(N'2014-10-13T21:07:44.000' AS DateTime), CAST(N'2014-10-13T21:12:25.000' AS DateTime), NULL, NULL, CAST(N'2014-12-19T00:00:00.000' AS DateTime), CAST(N'2014-12-20T00:00:00.000' AS DateTime), 2, 2)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'3e6c2466-74fe-44c0-a6f3-dda79755d30a', N'd5bf9afd-9572-4f60-955e-02706cc7130a', N'9005ae0c-4117-4cd8-b528-565cf891e4a6', CAST(N'2014-10-09T21:43:41.000' AS DateTime), CAST(N'2014-10-10T00:03:18.000' AS DateTime), NULL, NULL, CAST(N'2015-02-26T00:00:00.000' AS DateTime), CAST(N'2015-03-03T00:00:00.000' AS DateTime), 4, 5)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'845e3c1d-6c06-4ef2-ade5-7eecefb56fbe', N'eeaa1426-9aa2-4aac-850a-5fff4c677003', N'ac403a7c-10a9-4ef5-a828-98916195295f', CAST(N'2014-10-10T14:24:38.000' AS DateTime), CAST(N'2014-10-10T17:15:02.000' AS DateTime), CAST(N'2014-10-10T17:15:02.000' AS DateTime), NULL, CAST(N'2014-10-24T00:00:00.000' AS DateTime), CAST(N'2014-10-30T00:00:00.000' AS DateTime), 1, 9)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'598f8459-96f6-4400-8bce-1474757dd589', N'b441cc5d-0e8c-40b9-87a8-ae22ac8bbbd0', N'6b329786-9ff6-487e-bdca-fcedf5d4979f', CAST(N'2014-10-03T14:42:31.000' AS DateTime), CAST(N'2014-10-03T14:47:51.000' AS DateTime), NULL, NULL, CAST(N'2015-03-12T00:00:00.000' AS DateTime), CAST(N'2015-03-19T00:00:00.000' AS DateTime), 2, 3)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'ea445eea-3fac-4edd-b1d6-569f57f6abe4', N'64c5fd69-6246-49b7-a6a2-2b0b2ee06861', N'df45861e-a23b-427e-8bd3-cca7db90af02', CAST(N'2014-10-13T09:44:31.000' AS DateTime), NULL, NULL, NULL, CAST(N'2014-10-24T00:00:00.000' AS DateTime), CAST(N'2014-10-27T00:00:00.000' AS DateTime), 4, 1)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'e8e41881-d3bf-4f1e-b55e-6052eae23ef6', N'0e21af37-499c-499c-b5ab-c15d031ec152', N'fa7e4beb-d2f4-41d5-aa4d-f426652a3cfd', CAST(N'2014-10-15T13:04:35.000' AS DateTime), CAST(N'2014-10-16T10:24:51.000' AS DateTime), NULL, NULL, CAST(N'2014-12-30T00:00:00.000' AS DateTime), CAST(N'2015-01-09T00:00:00.000' AS DateTime), 6, 3)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'6133fb99-2391-4d4b-a077-bae40581f925', N'95234c4d-2aed-4e19-bb81-980d4fb38d58', N'4b836492-d214-4108-b7dd-f96c815920f0', CAST(N'2014-10-06T21:29:16.000' AS DateTime), CAST(N'2014-10-06T21:37:13.000' AS DateTime), CAST(N'2014-10-07T02:38:51.000' AS DateTime), CAST(N'2014-10-07T02:38:51.000' AS DateTime), CAST(N'2014-10-31T00:00:00.000' AS DateTime), CAST(N'2014-11-03T00:00:00.000' AS DateTime), 2, 16)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'c0075f4f-0cb0-489b-9f12-bf1dff573488', N'356e59fd-45d1-483b-ae8c-df4b7cd43fbd', N'79313e9e-371a-4c27-92ed-f2104e7ba9eb', CAST(N'2014-09-26T13:27:45.000' AS DateTime), CAST(N'2014-09-26T17:27:41.000' AS DateTime), NULL, NULL, CAST(N'2014-10-03T00:00:00.000' AS DateTime), CAST(N'2014-10-04T00:00:00.000' AS DateTime), 4, 3)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'02f0a750-34da-4268-94e8-f1a371f0460e', N'beeab7c3-ab4e-45d7-bde9-978de0fd8d57', N'c318d3e3-b36e-43b8-9b0c-3400cbca3895', CAST(N'2014-10-08T14:03:00.000' AS DateTime), CAST(N'2014-10-08T15:12:38.000' AS DateTime), CAST(N'2014-10-09T07:53:14.000' AS DateTime), NULL, CAST(N'2014-11-11T00:00:00.000' AS DateTime), CAST(N'2014-11-19T00:00:00.000' AS DateTime), 2, 4)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'94139517-e7e9-4afb-8b5d-bb6f306bf751', N'8d31dbce-fc8e-4c25-9f9b-758684a5941d', N'90d312e0-86a1-46b1-bb65-52eef939ca1f', CAST(N'2014-10-10T10:59:43.000' AS DateTime), CAST(N'2014-10-10T11:03:07.000' AS DateTime), CAST(N'2014-10-10T11:53:19.000' AS DateTime), CAST(N'2014-10-10T11:53:19.000' AS DateTime), CAST(N'2014-10-17T00:00:00.000' AS DateTime), CAST(N'2014-10-19T00:00:00.000' AS DateTime), 2, 15)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'd61d88ae-7910-4832-8116-aab4603ab3b0', N'a84fd08c-8bda-45d6-af26-033408ddbafc', N'78775b1b-3040-4505-b0c8-e7aadc91e82f', CAST(N'2014-10-08T19:28:36.000' AS DateTime), CAST(N'2014-10-08T19:33:52.000' AS DateTime), CAST(N'2014-10-08T19:33:54.000' AS DateTime), NULL, CAST(N'2014-11-13T00:00:00.000' AS DateTime), CAST(N'2014-11-18T00:00:00.000' AS DateTime), 4, 5)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'0f4ea370-702c-4f08-a00d-98e67c2a3574', N'5ccbd667-e9e4-4c34-839e-fb438d797925', N'547d204f-631f-4adc-b163-43dbc5850438', CAST(N'2014-10-04T20:48:37.000' AS DateTime), CAST(N'2014-10-05T10:52:25.000' AS DateTime), CAST(N'2014-10-05T10:52:25.000' AS DateTime), CAST(N'2014-10-05T11:47:38.000' AS DateTime), CAST(N'2014-10-10T00:00:00.000' AS DateTime), CAST(N'2014-10-13T00:00:00.000' AS DateTime), 6, 4)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'4de8c8ea-728a-467a-aa69-4800e8880c95', N'8aa37f14-6862-431e-8c39-5b8bac54c0ab', N'cc37c3f3-78a6-4336-9fda-25911dfee592', CAST(N'2014-10-08T12:45:09.000' AS DateTime), CAST(N'2014-10-08T17:24:30.000' AS DateTime), CAST(N'2014-10-08T17:24:30.000' AS DateTime), NULL, CAST(N'2014-11-25T00:00:00.000' AS DateTime), CAST(N'2015-01-19T00:00:00.000' AS DateTime), 2, 2)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'91c2a883-04e3-4bbb-a7bb-620531318ab1', N'b58d6d66-ae95-46df-8aa4-85f4577cff5d', N'f3dc4c11-2283-4deb-b8f2-f2808b0a50b3', CAST(N'2014-10-12T08:34:00.000' AS DateTime), CAST(N'2014-10-12T08:42:42.000' AS DateTime), CAST(N'2014-10-12T08:42:42.000' AS DateTime), CAST(N'2014-10-12T11:58:54.000' AS DateTime), CAST(N'2014-12-26T00:00:00.000' AS DateTime), CAST(N'2014-12-29T00:00:00.000' AS DateTime), 4, 17)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'ebe81cf8-6037-43f2-81d2-fd386f5da74f', N'2d4515a5-8839-4898-b6a0-c443ac5ea688', N'e84f2eee-c61c-428a-8f73-2bf4c0d16fcb', CAST(N'2014-10-06T20:49:18.000' AS DateTime), CAST(N'2014-10-06T20:57:05.000' AS DateTime), NULL, NULL, CAST(N'2014-10-10T00:00:00.000' AS DateTime), CAST(N'2014-10-13T00:00:00.000' AS DateTime), 3, 3)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'2889fccc-37ab-4a66-8d64-41b31314c7fc', N'a91caa70-830c-43d7-b265-886664c2b4c3', N'56642738-e6a0-47b3-8777-a363109df22f', CAST(N'2014-10-08T22:16:52.000' AS DateTime), CAST(N'2014-10-09T10:10:59.000' AS DateTime), CAST(N'2014-10-09T10:10:59.000' AS DateTime), CAST(N'2014-10-09T11:16:40.000' AS DateTime), CAST(N'2014-10-31T00:00:00.000' AS DateTime), CAST(N'2014-11-03T00:00:00.000' AS DateTime), 2, 5)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'6c541a87-d864-4de8-ae05-70ae57b50976', N'b881e451-c805-4363-8eaa-597dd0ffde31', N'42cd81d5-a79a-44f1-8303-10ed1679e8a3', CAST(N'2014-10-03T18:25:01.000' AS DateTime), CAST(N'2014-10-03T18:40:04.000' AS DateTime), CAST(N'2014-10-03T18:42:57.000' AS DateTime), CAST(N'2014-10-03T18:42:57.000' AS DateTime), CAST(N'2014-10-16T00:00:00.000' AS DateTime), CAST(N'2014-10-22T00:00:00.000' AS DateTime), 1, 13)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'eb3500c2-b0b9-4753-8ab3-3fad4d5777f1', N'86b39b70-965b-479d-a0b0-719b195acea2', N'3f005d10-34a4-4e97-9d70-8b4ba29a5241', CAST(N'2014-10-14T22:40:11.000' AS DateTime), CAST(N'2014-10-15T22:22:49.000' AS DateTime), NULL, NULL, CAST(N'2014-11-08T00:00:00.000' AS DateTime), CAST(N'2014-11-09T00:00:00.000' AS DateTime), 5, 2)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'd418a1ab-b181-40a7-90fe-7216e40dc354', N'4d90d993-7ce5-4df3-9df9-a81f3a46a1d4', N'2a3b9159-28d4-475d-81b1-4500b292b9dd', CAST(N'2014-08-27T16:39:30.000' AS DateTime), CAST(N'2014-08-27T22:31:20.000' AS DateTime), CAST(N'2014-08-27T22:31:20.000' AS DateTime), CAST(N'2014-08-28T17:33:01.000' AS DateTime), CAST(N'2014-10-22T00:00:00.000' AS DateTime), CAST(N'2014-10-28T00:00:00.000' AS DateTime), 2, 8)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'ffc234be-ca13-4bcb-a472-1c136b800891', N'ab4811a4-39a6-43ec-95dd-03253825fa4b', N'34e2543c-7f95-4fd1-b534-a178403a3942', CAST(N'2014-10-08T19:21:42.000' AS DateTime), CAST(N'2014-10-09T06:03:33.000' AS DateTime), NULL, NULL, CAST(N'2014-10-09T00:00:00.000' AS DateTime), CAST(N'2014-10-17T00:00:00.000' AS DateTime), 1, 3)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'5c4b64d5-4869-4a02-b36c-c451758559e0', N'71874f06-e0be-4da5-ac2c-0dc6560785f3', N'4d50ecc0-6474-432f-954f-4a4273dc67ce', CAST(N'2014-10-14T09:53:38.000' AS DateTime), CAST(N'2014-10-14T10:00:42.000' AS DateTime), NULL, NULL, CAST(N'2014-11-27T00:00:00.000' AS DateTime), CAST(N'2014-11-30T00:00:00.000' AS DateTime), 2, 6)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'a09bf912-b21d-4859-b194-8512c30695f6', N'64facbb7-f52c-4794-a666-76b5b00a816f', N'653b5372-0a5c-4aa6-8959-17a7e4f06206', CAST(N'2014-10-12T22:56:36.000' AS DateTime), CAST(N'2014-10-13T05:44:08.000' AS DateTime), NULL, NULL, CAST(N'2014-10-18T00:00:00.000' AS DateTime), CAST(N'2014-10-22T00:00:00.000' AS DateTime), 1, 4)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'8af13d02-bd2c-40fd-afd7-e4fe3a6a622e', N'05c39598-4a49-4bb6-96ed-ed8007108aa1', N'45b001f4-3593-4b25-aed3-896e8e78fdd3', CAST(N'2014-10-03T09:46:04.000' AS DateTime), CAST(N'2014-10-03T10:11:52.000' AS DateTime), NULL, NULL, CAST(N'2014-11-07T00:00:00.000' AS DateTime), CAST(N'2014-11-12T00:00:00.000' AS DateTime), 2, 6)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'996d1871-8986-481b-8bbf-1a1420c68c90', N'bcdf2edf-7745-4c10-9057-0fef65784fcb', N'1ece748f-de7c-4aa5-ab46-fce8024b7759', CAST(N'2014-11-11T21:28:49.000' AS DateTime), CAST(N'2014-11-12T01:10:18.000' AS DateTime), NULL, NULL, CAST(N'2015-03-12T00:00:00.000' AS DateTime), CAST(N'2015-03-19T00:00:00.000' AS DateTime), 4, 2)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'9b145027-2723-4c5f-988c-b5118c899912', N'0c02268a-c84e-4a0f-904b-7cf61dcd208d', N'619e2ded-b985-4130-a3d1-f840170ebc27', CAST(N'2014-10-06T14:06:07.000' AS DateTime), CAST(N'2014-10-06T16:47:43.000' AS DateTime), CAST(N'2014-10-06T16:47:43.000' AS DateTime), CAST(N'2014-10-18T10:54:58.000' AS DateTime), CAST(N'2014-12-04T00:00:00.000' AS DateTime), CAST(N'2014-12-08T00:00:00.000' AS DateTime), 2, 15)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'f1877c99-430e-41e1-818a-713ff82f09da', N'7019fd3f-e1e8-47fe-b0ea-91a1dae98cf8', N'6bdfbdc2-0a6d-47e4-bd2e-ca7dfa59a40d', CAST(N'2014-11-02T15:49:56.000' AS DateTime), CAST(N'2014-11-02T15:54:39.000' AS DateTime), CAST(N'2014-11-02T15:54:39.000' AS DateTime), NULL, CAST(N'2014-11-20T00:00:00.000' AS DateTime), CAST(N'2014-11-24T00:00:00.000' AS DateTime), 2, 3)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'29ef2346-5fda-45d7-b4ed-eb34967a62b3', N'4d90d993-7ce5-4df3-9df9-a81f3a46a1d4', N'2a3b9159-28d4-475d-81b1-4500b292b9dd', CAST(N'2014-10-03T19:42:06.000' AS DateTime), CAST(N'2014-10-03T20:24:14.000' AS DateTime), CAST(N'2014-10-03T20:24:19.000' AS DateTime), CAST(N'2014-10-06T16:38:43.000' AS DateTime), CAST(N'2014-11-08T00:00:00.000' AS DateTime), CAST(N'2014-11-10T00:00:00.000' AS DateTime), 2, 9)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'8d23aa41-c77c-4bbe-98bc-66abecfefbfe', N'f86bc9ab-e199-4254-8609-fd67d6aaed42', N'28caf371-6d1d-4e06-aaf1-e660966ac7a1', CAST(N'2014-10-08T18:41:44.000' AS DateTime), CAST(N'2014-10-08T19:11:56.000' AS DateTime), NULL, NULL, CAST(N'2014-11-03T00:00:00.000' AS DateTime), CAST(N'2014-11-07T00:00:00.000' AS DateTime), 1, 5)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'aa9cf5bf-5667-4212-8018-1cb8beee530e', N'f60dc357-73da-467e-9da2-f256f162c1b4', N'7fe426b4-e166-4c91-97ca-af9f5b9f0c0c', CAST(N'2014-10-03T17:51:58.000' AS DateTime), CAST(N'2014-10-03T17:51:58.000' AS DateTime), CAST(N'2014-10-03T17:51:58.000' AS DateTime), CAST(N'2014-10-03T17:51:58.000' AS DateTime), CAST(N'2014-11-14T00:00:00.000' AS DateTime), CAST(N'2014-11-16T00:00:00.000' AS DateTime), 2, 8)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'd528e24b-7c1f-446f-9bb0-a4ecb77c3acd', N'570ebf8a-6594-4511-91ea-0f9227124e47', N'f916ba84-966c-4abf-bfe6-35e6a9e4643b', CAST(N'2014-10-06T15:04:02.000' AS DateTime), CAST(N'2014-10-06T15:37:14.000' AS DateTime), CAST(N'2014-10-07T09:11:00.000' AS DateTime), NULL, CAST(N'2014-11-27T00:00:00.000' AS DateTime), CAST(N'2014-11-30T00:00:00.000' AS DateTime), 2, 5)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'1a66fe1c-fea6-4ec6-96c4-3ea3e0c7815e', N'684ffeb7-7a7b-4cbd-8f93-00e274dac37c', N'63097ab2-97d0-437c-864c-774a4e9603bb', CAST(N'2014-11-17T12:51:51.000' AS DateTime), CAST(N'2014-11-17T13:34:56.000' AS DateTime), CAST(N'2014-11-17T13:34:56.000' AS DateTime), NULL, CAST(N'2015-03-15T00:00:00.000' AS DateTime), CAST(N'2015-03-18T00:00:00.000' AS DateTime), 6, 4)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'f54989cf-459b-409d-be6a-9534a53cc4a9', N'8d31dbce-fc8e-4c25-9f9b-758684a5941d', N'90d312e0-86a1-46b1-bb65-52eef939ca1f', CAST(N'2014-10-07T22:53:39.000' AS DateTime), CAST(N'2014-10-08T11:22:26.000' AS DateTime), NULL, NULL, CAST(N'2014-11-03T00:00:00.000' AS DateTime), CAST(N'2014-11-07T00:00:00.000' AS DateTime), 1, 4)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'2acf0e64-9da0-47c9-b0f9-1eceab379f84', N'498a28e2-6b3c-4759-9cf8-7c5a1ba7268f', N'dbbbdb7d-529a-425f-a847-2e298c3484e0', CAST(N'2014-10-03T16:23:20.000' AS DateTime), CAST(N'2014-10-04T07:34:27.000' AS DateTime), NULL, NULL, CAST(N'2014-10-04T00:00:00.000' AS DateTime), CAST(N'2014-10-06T00:00:00.000' AS DateTime), 1, 3)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'3c3ec192-acd7-4c91-8e82-18cff7d859ec', N'ee55912a-88a0-414d-aed7-7f15ce527232', N'71bca3ca-cbbf-4496-b35b-15dcc39552da', CAST(N'2014-10-02T12:38:02.000' AS DateTime), CAST(N'2014-10-03T14:49:27.000' AS DateTime), NULL, NULL, CAST(N'2014-10-24T00:00:00.000' AS DateTime), CAST(N'2014-10-26T00:00:00.000' AS DateTime), 2, 4)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'a03f86ca-5c44-4e66-8695-71c380cfc48b', N'45619500-e25e-41ce-add4-91420758203d', N'ae5a71d5-1434-4ee1-b81e-1745585596d6', CAST(N'2014-10-10T18:23:55.000' AS DateTime), CAST(N'2014-10-10T19:16:39.000' AS DateTime), NULL, NULL, CAST(N'2014-10-11T00:00:00.000' AS DateTime), CAST(N'2014-10-12T00:00:00.000' AS DateTime), 1, 4)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'20418fda-ffb2-46a3-9581-863725497c05', N'f89f3083-3ecf-431d-bd94-c6a390175796', N'c0a229e0-4712-4be1-91ff-53daeb0b73ae', CAST(N'2014-12-09T18:54:08.000' AS DateTime), CAST(N'2014-12-10T09:49:08.000' AS DateTime), NULL, NULL, CAST(N'2015-03-13T00:00:00.000' AS DateTime), CAST(N'2015-03-17T00:00:00.000' AS DateTime), 3, 4)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'5ed478e0-eae9-4537-826a-04ec779c1fd2', N'86b39b70-965b-479d-a0b0-719b195acea2', N'd2c8c59e-4d49-421b-9984-96957104862e', CAST(N'2014-10-05T19:23:03.000' AS DateTime), CAST(N'2014-10-05T21:15:28.000' AS DateTime), NULL, NULL, CAST(N'2014-10-07T00:00:00.000' AS DateTime), CAST(N'2014-12-21T00:00:00.000' AS DateTime), 1, 9)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'70180687-5888-4946-9578-83ab678cb997', N'ff4ee77c-3baa-49e4-9ee3-51add94b6b50', N'f242de54-802c-4f1f-b907-bf695163aa1f', CAST(N'2014-10-07T16:41:53.000' AS DateTime), CAST(N'2014-10-08T20:44:07.000' AS DateTime), NULL, NULL, CAST(N'2014-11-02T00:00:00.000' AS DateTime), CAST(N'2014-11-03T00:00:00.000' AS DateTime), 1, 8)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'9e5e2865-f257-4d19-9f79-9388ae925ad7', N'0749a8a5-9ced-42f7-94ba-f0b3a61928d6', N'fae2775e-024f-4c60-89b9-fd4d4119bba5', CAST(N'2014-10-14T22:54:16.000' AS DateTime), CAST(N'2014-10-15T11:02:04.000' AS DateTime), NULL, NULL, CAST(N'2014-10-31T00:00:00.000' AS DateTime), CAST(N'2014-11-01T00:00:00.000' AS DateTime), 1, 3)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'176a2fb8-1de3-483a-92a3-34a826a91f5a', N'78f31441-4c00-4c6f-b8fc-b163f0bc9878', N'6618cbda-eecf-48c6-ad94-dfe99248a7e5', CAST(N'2014-10-09T21:37:09.000' AS DateTime), CAST(N'2014-10-10T00:30:27.000' AS DateTime), NULL, NULL, CAST(N'2014-11-07T00:00:00.000' AS DateTime), CAST(N'2014-11-09T00:00:00.000' AS DateTime), 2, 5)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'67c4e87c-8a8f-4da4-a965-b89c9d74666b', N'82992868-442b-4c6e-8926-b2ec6724520e', N'e502da32-dfc6-4f40-bba2-80f326d7dbf7', CAST(N'2014-09-21T16:45:43.000' AS DateTime), CAST(N'2014-09-21T16:52:11.000' AS DateTime), NULL, NULL, CAST(N'2014-12-05T00:00:00.000' AS DateTime), CAST(N'2014-12-08T00:00:00.000' AS DateTime), 2, 2)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'7424d151-b449-40e1-9e8f-c258289c581c', N'beeab7c3-ab4e-45d7-bde9-978de0fd8d57', N'c318d3e3-b36e-43b8-9b0c-3400cbca3895', CAST(N'2014-10-11T14:57:40.000' AS DateTime), CAST(N'2014-10-13T07:24:13.000' AS DateTime), CAST(N'2014-10-13T07:24:13.000' AS DateTime), NULL, CAST(N'2014-10-29T00:00:00.000' AS DateTime), CAST(N'2014-11-05T00:00:00.000' AS DateTime), 1, 2)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'15eb6f98-98ee-491e-8eeb-b5e2c61bfd8a', N'1a162837-bd2e-4cf3-b498-70f122f8e278', N'ef78de5e-c0c2-47b5-9f90-8d508ada4aa8', CAST(N'2014-09-30T07:54:26.000' AS DateTime), NULL, NULL, NULL, CAST(N'2014-10-17T00:00:00.000' AS DateTime), CAST(N'2014-10-19T00:00:00.000' AS DateTime), 1, 2)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'd328a4a0-df5f-4851-a864-a8845b45c1e0', N'd4fac41a-cfb0-4440-8f5f-cc71d69900bf', N'4054beed-b863-4ccf-8dd0-ef70317133f3', CAST(N'2014-10-12T11:10:13.000' AS DateTime), CAST(N'2014-10-12T11:18:11.000' AS DateTime), CAST(N'2014-10-12T11:18:33.000' AS DateTime), CAST(N'2014-10-12T11:18:33.000' AS DateTime), CAST(N'2014-10-24T00:00:00.000' AS DateTime), CAST(N'2014-10-29T00:00:00.000' AS DateTime), 1, 15)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'eda96881-7b23-413a-9f6f-b45dc9fe2a5b', N'300bb97d-ee7e-40df-93b8-d4ae133566d8', N'0caa7b1b-f1a3-4ebc-af8d-38400272b980', CAST(N'2014-10-05T18:57:16.000' AS DateTime), CAST(N'2014-10-05T19:40:07.000' AS DateTime), NULL, NULL, CAST(N'2015-06-12T00:00:00.000' AS DateTime), CAST(N'2015-06-14T00:00:00.000' AS DateTime), 4, 5)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'882f3764-05cc-436a-b23b-93fea22ea847', N'570ebf8a-6594-4511-91ea-0f9227124e47', N'f916ba84-966c-4abf-bfe6-35e6a9e4643b', CAST(N'2014-10-14T09:23:15.000' AS DateTime), CAST(N'2014-10-14T18:41:07.000' AS DateTime), CAST(N'2014-10-14T18:41:24.000' AS DateTime), CAST(N'2014-10-15T20:59:11.000' AS DateTime), CAST(N'2014-10-19T00:00:00.000' AS DateTime), CAST(N'2014-10-21T00:00:00.000' AS DateTime), 2, 19)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'6cb23070-821b-467d-b4d0-af04645a0703', N'8e78ca63-5473-4b4c-a7fc-6d112de50a46', N'd0babecd-86bf-48c8-9aeb-dde877c62c37', CAST(N'2014-10-07T13:38:42.000' AS DateTime), CAST(N'2014-10-08T10:05:46.000' AS DateTime), NULL, NULL, CAST(N'2014-10-31T00:00:00.000' AS DateTime), CAST(N'2014-11-03T00:00:00.000' AS DateTime), 2, 2)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'e3cdd90a-8097-4220-9722-2b914d761a84', N'ff3fe9f4-ec5f-4ca3-8ec3-6147f9589d91', N'81dd195e-f6e3-46e5-a282-dbb786b0904b', CAST(N'2014-10-12T15:09:31.000' AS DateTime), CAST(N'2014-10-12T17:19:59.000' AS DateTime), CAST(N'2014-10-12T17:19:59.000' AS DateTime), NULL, CAST(N'2014-11-06T00:00:00.000' AS DateTime), CAST(N'2014-11-07T00:00:00.000' AS DateTime), 1, 4)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'5c4b64d5-4869-4a02-b36c-c451758559e0', N'd5bf9afd-9572-4f60-955e-02706cc7130a', N'5a218b22-2de4-4e7d-a2ed-7ad1cd4d4167', CAST(N'2014-10-14T09:55:40.000' AS DateTime), NULL, NULL, NULL, CAST(N'2014-11-27T00:00:00.000' AS DateTime), CAST(N'2014-11-30T00:00:00.000' AS DateTime), 2, 2)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'eaa8118b-aba6-4c25-96cd-c72f01d6b063', N'd00b32e3-11ee-4f76-a5b4-a7f036ea6b10', N'ae78cc6b-db95-481e-90a6-1737fa2fafce', CAST(N'2014-10-14T02:29:03.000' AS DateTime), CAST(N'2014-10-14T06:52:42.000' AS DateTime), CAST(N'2014-10-14T14:44:13.000' AS DateTime), NULL, CAST(N'2014-10-18T00:00:00.000' AS DateTime), CAST(N'2014-10-20T00:00:00.000' AS DateTime), 2, 6)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'62d09c95-c3d2-44e6-9081-a3485618227d', N'c4988f29-6ab6-4afb-9c4c-1e8ae41524d2', N'44770890-bdfe-49df-bdd9-28e19eafee23', CAST(N'2014-10-04T12:43:01.000' AS DateTime), CAST(N'2014-10-05T10:49:16.000' AS DateTime), CAST(N'2014-10-05T10:49:16.000' AS DateTime), CAST(N'2014-10-05T10:49:16.000' AS DateTime), CAST(N'2014-10-25T00:00:00.000' AS DateTime), CAST(N'2014-11-01T00:00:00.000' AS DateTime), 4, 20)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'5dacf820-a573-4ce2-9fd8-0d7ed979b822', N'f17ab24c-54cf-4370-bc2d-7d3cb6d42e41', N'24162baf-eb46-41af-9b64-ad421c4c7d4e', CAST(N'2014-10-14T20:45:21.000' AS DateTime), CAST(N'2014-10-15T06:29:09.000' AS DateTime), CAST(N'2014-10-15T06:29:09.000' AS DateTime), CAST(N'2014-10-15T06:29:09.000' AS DateTime), CAST(N'2014-10-17T00:00:00.000' AS DateTime), CAST(N'2014-10-21T00:00:00.000' AS DateTime), 3, 11)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'70a2c590-f854-4ca6-adf5-03fc081cfddf', N'd5ab6ad0-b01b-46b3-8cb8-c3417c437da2', N'78628904-496a-4f46-b899-07e36751d04b', CAST(N'2014-10-10T23:14:47.000' AS DateTime), CAST(N'2014-10-10T23:20:04.000' AS DateTime), NULL, NULL, CAST(N'2014-10-11T00:00:00.000' AS DateTime), CAST(N'2014-10-15T00:00:00.000' AS DateTime), 3, 4)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'02f0a750-34da-4268-94e8-f1a371f0460e', N'56e66e3a-0336-4a33-86bd-5485cc1ed58f', N'e5cfd6a7-8688-4ba6-bd79-d4c0c6472369', CAST(N'2014-10-08T13:55:15.000' AS DateTime), CAST(N'2014-10-09T00:07:52.000' AS DateTime), CAST(N'2014-10-09T00:07:52.000' AS DateTime), NULL, CAST(N'2014-11-11T00:00:00.000' AS DateTime), CAST(N'2014-11-19T00:00:00.000' AS DateTime), 2, 4)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'a1a53da7-7a33-4693-8568-1d7f2cd32e31', N'85f8ce6b-236c-4613-9d9b-6b088a6e61a3', N'f2cdaa1e-4a63-4e57-908a-196393a25246', CAST(N'2014-10-11T10:24:35.000' AS DateTime), CAST(N'2014-10-11T11:10:57.000' AS DateTime), NULL, NULL, CAST(N'2014-10-20T00:00:00.000' AS DateTime), CAST(N'2014-10-22T00:00:00.000' AS DateTime), 4, 4)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'8375dde4-0de9-402c-8833-2127c1504601', N'2e2865d6-7471-4ff1-b4cd-7f9a794d7267', N'297c3163-464e-4780-85c5-86cfb7eb1f40', CAST(N'2014-10-05T21:55:02.000' AS DateTime), CAST(N'2014-10-05T22:27:35.000' AS DateTime), NULL, NULL, CAST(N'2014-10-11T00:00:00.000' AS DateTime), CAST(N'2014-10-12T00:00:00.000' AS DateTime), 1, 4)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'4995debc-b753-4401-b556-a2bcbb897eba', N'c6874ea0-3dc7-418c-b1c2-2716e60db5bb', N'02f872a9-ea88-439f-a7e3-6154af90e3ee', CAST(N'2014-10-01T19:55:06.000' AS DateTime), CAST(N'2014-10-04T06:52:15.000' AS DateTime), NULL, NULL, CAST(N'2014-10-24T00:00:00.000' AS DateTime), CAST(N'2014-10-29T00:00:00.000' AS DateTime), 6, 2)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'125242de-91b4-43bd-a926-75ae4b7a9322', N'85ececde-963c-4947-8c80-fd27de5a46a8', N'068de3fc-7217-45f0-a00a-1222e6db11bb', CAST(N'2014-09-16T15:33:05.000' AS DateTime), CAST(N'2014-09-16T16:13:33.000' AS DateTime), NULL, NULL, CAST(N'2014-10-22T00:00:00.000' AS DateTime), CAST(N'2014-10-26T00:00:00.000' AS DateTime), 3, 9)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'f5ba8f82-682e-4ec9-9c6e-cedc2cd628ca', N'6b4dcfe4-43cd-476f-946a-26fa7889f031', N'd88bbd8e-57b1-4eb7-a8bd-adc6f36e1785', CAST(N'2014-10-01T13:17:18.000' AS DateTime), NULL, NULL, NULL, CAST(N'2014-11-19T00:00:00.000' AS DateTime), CAST(N'2014-11-22T00:00:00.000' AS DateTime), 2, 2)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'4ec2c8ec-9325-4b66-a370-820a56fbd1a3', N'7dcda8cb-7734-4394-a5c3-3876ab961804', N'bb38698e-25cb-4f54-878e-74ac66788a06', CAST(N'2014-10-14T13:41:18.000' AS DateTime), CAST(N'2014-10-14T16:38:19.000' AS DateTime), NULL, NULL, CAST(N'2014-10-15T00:00:00.000' AS DateTime), CAST(N'2014-10-17T00:00:00.000' AS DateTime), 1, 5)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'ca6a9321-d7f9-42e9-aeb1-5d1832034da0', N'c85e97c3-6c63-4a8c-90a3-5353f187d1a8', N'59762fcf-afa1-4eef-9bf1-7a2a5bfa938f', CAST(N'2014-10-07T19:59:54.000' AS DateTime), CAST(N'2014-10-08T07:26:18.000' AS DateTime), NULL, NULL, CAST(N'2014-10-17T00:00:00.000' AS DateTime), CAST(N'2014-10-20T00:00:00.000' AS DateTime), 2, 8)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'7e309181-e61e-426b-baef-dd031d5660d3', N'd12165bf-ce52-4415-9bfe-4d236d2ae857', N'29ec63ab-d1f2-4396-b393-2fede0b4e518', CAST(N'2014-10-08T12:35:06.000' AS DateTime), CAST(N'2014-10-08T12:37:05.000' AS DateTime), CAST(N'2014-10-08T12:37:05.000' AS DateTime), CAST(N'2014-10-08T12:37:05.000' AS DateTime), CAST(N'2014-10-27T00:00:00.000' AS DateTime), CAST(N'2014-11-02T00:00:00.000' AS DateTime), 2, 8)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'e079182c-7628-4f49-8301-29ff8b4938ec', N'c7a43e26-a4f6-4449-95e2-740cb585f5e8', N'84052f3d-47a5-41d5-b7f4-8fbd1977d582', CAST(N'2014-09-30T21:37:11.000' AS DateTime), CAST(N'2014-10-01T06:36:06.000' AS DateTime), NULL, NULL, CAST(N'2014-10-01T00:00:00.000' AS DateTime), CAST(N'2014-10-02T00:00:00.000' AS DateTime), 2, 2)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'3e6fbc52-3e54-4a74-9ca1-7ce13048aab7', N'86b39b70-965b-479d-a0b0-719b195acea2', N'e5dd99cd-ad45-409b-ac13-ab9a576a41a3', CAST(N'2014-10-28T04:13:28.000' AS DateTime), CAST(N'2014-10-28T23:22:50.000' AS DateTime), NULL, NULL, CAST(N'2015-01-03T00:00:00.000' AS DateTime), CAST(N'2015-01-08T00:00:00.000' AS DateTime), 2, 4)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'e764ddb5-126e-4474-8e4e-4bdc330b51d1', N'd4c7b020-ed6a-410f-992c-1c86b17f918e', N'aa045c11-b971-4821-b14e-fbd427b9cf9f', CAST(N'2014-10-03T13:35:28.000' AS DateTime), CAST(N'2014-10-04T15:11:21.000' AS DateTime), NULL, NULL, CAST(N'2014-10-11T00:00:00.000' AS DateTime), CAST(N'2014-10-24T00:00:00.000' AS DateTime), 1, 2)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'b6a8b1f9-5b40-4edd-91f3-ee522b0f9e5b', N'f7b9943a-f401-488c-84d3-56676d9d8efd', N'a4fd2f41-b8b6-4dc4-9556-0cdd28d36034', CAST(N'2014-11-07T20:45:23.000' AS DateTime), CAST(N'2014-11-08T08:44:11.000' AS DateTime), NULL, NULL, CAST(N'2014-12-27T00:00:00.000' AS DateTime), CAST(N'2015-01-03T00:00:00.000' AS DateTime), 5, 7)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'b91e6323-bd26-4172-9070-1a4993fdc397', N'9b304b8e-12e2-4af3-ab98-62bdeb06c3e3', N'572a3057-ef3b-48ef-9cf6-a0891fcc351d', CAST(N'2014-10-14T08:23:26.000' AS DateTime), CAST(N'2014-10-14T16:59:06.000' AS DateTime), NULL, NULL, CAST(N'2014-10-16T00:00:00.000' AS DateTime), CAST(N'2014-10-18T00:00:00.000' AS DateTime), 2, 4)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'b3e35a8f-5503-4d78-adb8-7693097dfca7', N'42bae547-e5d9-4614-8f47-c4ede1036371', N'441c44cd-3fe7-4a40-8547-468ccfbb6fd8', CAST(N'2014-10-19T13:59:30.000' AS DateTime), CAST(N'2014-10-20T17:16:09.000' AS DateTime), NULL, NULL, CAST(N'2014-11-03T00:00:00.000' AS DateTime), CAST(N'2014-11-07T00:00:00.000' AS DateTime), 2, 2)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'e0d259e6-1b67-4964-a6dc-e8a8c69d3e01', N'becd48ad-623e-4821-9538-e9d8f84f1cac', N'e9f7ef72-286d-4ca5-be32-f9bbcd238270', CAST(N'2014-10-19T14:47:58.000' AS DateTime), CAST(N'2014-10-19T15:00:13.000' AS DateTime), CAST(N'2014-10-19T15:00:13.000' AS DateTime), NULL, CAST(N'2014-11-16T00:00:00.000' AS DateTime), CAST(N'2014-11-17T00:00:00.000' AS DateTime), 2, 4)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'67aece73-e112-4e9e-9e05-8a2a94b003b9', N'd5ab6ad0-b01b-46b3-8cb8-c3417c437da2', N'68e80a2a-f921-4a05-b2bd-a766362bd324', CAST(N'2014-10-11T15:19:37.000' AS DateTime), CAST(N'2014-10-12T22:05:09.000' AS DateTime), NULL, NULL, CAST(N'2014-11-09T00:00:00.000' AS DateTime), CAST(N'2014-11-23T00:00:00.000' AS DateTime), 2, 8)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'be8a5e0c-e3fb-4517-a799-e1ed8a05b6e6', N'40dcd83f-2732-4414-8f38-e0ca131e9677', N'db25a5a7-0675-4045-9433-fe23409a5a5d', CAST(N'2014-10-12T13:49:40.000' AS DateTime), CAST(N'2014-10-13T06:08:57.000' AS DateTime), NULL, NULL, CAST(N'2014-10-16T00:00:00.000' AS DateTime), CAST(N'2014-10-20T00:00:00.000' AS DateTime), 2, 2)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'72f07b78-99e1-46ac-8452-19dd2053eca3', N'4b506f77-378a-4634-b26a-b94bf72dd95f', N'66329697-0f5e-4aa5-8f4a-1c09090db3d4', CAST(N'2014-10-14T18:55:36.000' AS DateTime), CAST(N'2014-10-14T19:23:25.000' AS DateTime), CAST(N'2014-10-15T22:10:35.000' AS DateTime), NULL, CAST(N'2014-10-30T00:00:00.000' AS DateTime), CAST(N'2014-11-02T00:00:00.000' AS DateTime), 3, 5)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'b11cd744-101d-409b-9a55-7e151f2e79d5', N'c6874ea0-3dc7-418c-b1c2-2716e60db5bb', N'c782ee0f-58bf-4454-a87e-b391fab04ea2', CAST(N'2014-10-02T15:44:11.000' AS DateTime), NULL, NULL, NULL, CAST(N'2014-10-03T00:00:00.000' AS DateTime), CAST(N'2014-10-05T00:00:00.000' AS DateTime), 1, 1)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'18d343e3-0ef0-4bb7-8cd9-b83d3fbbb82f', N'883613d4-e3a3-4aaf-973c-070a85605aaa', N'6a7a6ef5-b169-4f6c-8952-e0e309d90199', CAST(N'2014-11-03T09:13:16.000' AS DateTime), CAST(N'2014-11-03T09:21:04.000' AS DateTime), CAST(N'2014-11-03T09:21:04.000' AS DateTime), NULL, CAST(N'2014-11-08T00:00:00.000' AS DateTime), CAST(N'2014-11-10T00:00:00.000' AS DateTime), 2, 2)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'f4602827-8672-4545-8887-43702f8c7ecc', N'19fc6fce-5b98-459c-ada0-513e5aee963e', N'16cee446-da3d-45c5-8422-5b0f24007c82', CAST(N'2014-10-02T21:26:50.000' AS DateTime), CAST(N'2014-10-02T21:26:50.000' AS DateTime), CAST(N'2014-10-02T21:26:50.000' AS DateTime), CAST(N'2014-10-02T21:26:50.000' AS DateTime), CAST(N'2014-10-08T00:00:00.000' AS DateTime), CAST(N'2014-10-12T00:00:00.000' AS DateTime), 2, 7)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'6a8cf97f-8a77-4b55-b79a-b560bca414a4', N'bf16e655-3249-401b-837b-91d78cd82cdb', N'bc026dd6-76f6-4d9b-8e58-5b86e68f07c5', CAST(N'2014-09-11T18:51:30.000' AS DateTime), CAST(N'2014-09-11T20:47:38.000' AS DateTime), NULL, NULL, CAST(N'2014-11-07T00:00:00.000' AS DateTime), CAST(N'2014-11-10T00:00:00.000' AS DateTime), 2, 10)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'882f3764-05cc-436a-b23b-93fea22ea847', N'6bbb88ca-db66-48c5-9c4b-862f7706284a', N'2b983216-a194-454c-a4a9-e5db51622e88', CAST(N'2014-10-14T09:25:14.000' AS DateTime), NULL, NULL, NULL, CAST(N'2014-10-19T00:00:00.000' AS DateTime), CAST(N'2014-10-21T00:00:00.000' AS DateTime), 2, 1)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'0187b377-ad1c-4da4-8a17-568b2c9098f4', N'ee55912a-88a0-414d-aed7-7f15ce527232', N'71bca3ca-cbbf-4496-b35b-15dcc39552da', CAST(N'2014-10-02T22:55:35.000' AS DateTime), CAST(N'2014-10-03T06:33:24.000' AS DateTime), NULL, NULL, CAST(N'2015-03-18T00:00:00.000' AS DateTime), CAST(N'2015-03-20T00:00:00.000' AS DateTime), 1, 2)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'25cfc206-89aa-4e63-b2f4-3cbb8631d9fb', N'a6ae621a-72e7-4d11-94b2-4968260cbe6c', N'43b66fc6-c43b-4dd7-992b-7695e2aad765', CAST(N'2014-10-05T23:42:00.000' AS DateTime), CAST(N'2014-10-06T09:17:30.000' AS DateTime), NULL, NULL, CAST(N'2014-10-10T00:00:00.000' AS DateTime), CAST(N'2014-10-12T00:00:00.000' AS DateTime), 2, 8)
GO
INSERT [dbo].[airbnb_contacts] ([id_guest], [id_host], [id_listing], [ts_contact_at], [ts_reply_at], [ts_accepted_at], [ts_booking_at], [ds_checkin], [ds_checkout], [n_guests], [n_messages]) VALUES (N'37a63847-b09a-4f32-81a5-97cfb8e84c6d', N'8a429bd7-b9a7-4d5a-a007-5d99aff3dcec', N'51a240bc-93eb-46e5-b90a-09ad59edcfc6', CAST(N'2014-10-02T14:39:32.000' AS DateTime), CAST(N'2014-10-05T13:34:26.000' AS DateTime), NULL, NULL, CAST(N'2015-03-11T00:00:00.000' AS DateTime), CAST(N'2015-03-19T00:00:00.000' AS DateTime), 2, 2)
GO