-
Notifications
You must be signed in to change notification settings - Fork 0
/
data-testKL.sql
300 lines (288 loc) · 169 KB
/
data-testKL.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
USE [kinhluan.gb]
GO
SET IDENTITY_INSERT [dbo].[gb_Users] ON
INSERT [dbo].[gb_Users] ([UserID], [SiteID], [Name], [LoginName], [Email], [LoweredEmail], [PasswordQuestion], [PasswordAnswer], [Gender], [ProfileApproved], [RegisterConfirmGuid], [ApprovedForForums], [Trusted], [DisplayInMemberList], [WebSiteURL], [Country], [State], [Occupation], [Interests], [MSN], [Yahoo], [AIM], [ICQ], [TotalPosts], [AvatarUrl], [TimeOffsetHours], [Signature], [DateCreated], [UserGuid], [Skin], [IsDeleted], [LastActivityDate], [LastLoginDate], [LastPasswordChangedDate], [LastLockoutDate], [FailedPasswordAttemptCount], [FailedPwdAttemptWindowStart], [FailedPwdAnswerAttemptCount], [FailedPwdAnswerWindowStart], [IsLockedOut], [MobilePIN], [PasswordSalt], [Comment], [OpenIDURI], [WindowsLiveID], [SiteGuid], [TotalRevenue], [FirstName], [LastName], [Pwd], [MustChangePwd], [NewEmail], [EditorPreference], [EmailChangeGuid], [TimeZoneId], [PasswordResetGuid], [RolesChanged], [AuthorBio]) VALUES (1, 1, N'Admin', N'admin', N'admin@canhcam.vn', N'admin@canhcam.vn', N'What''s the meaning of life?', N'...', N'M ', 1, NULL, 1, 0, 1, N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'', 0, N'', CAST(0x0000A16900939735 AS DateTime), N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', N'', 0, CAST(0x0000A7C900A59C98 AS DateTime), CAST(0x0000A7C9009DF4C6 AS DateTime), CAST(0x0000A4060091B95E AS DateTime), NULL, 0, CAST(0x0000A3FA00B87432 AS DateTime), 0, NULL, 0, NULL, N'', N'71cc9f66-2325-4adb-a4d6-1aedf30d556a', N'', N'', N'd61fe7b9-1caa-4c2d-afc1-d4fc174631c9', CAST(0.0000 AS Decimal(15, 4)), N'', N'', N'admin', 0, N'', N'', N'00000000-0000-0000-0000-000000000000', N'SE Asia Standard Time', N'00000000-0000-0000-0000-000000000000', 0, N'')
INSERT [dbo].[gb_Users] ([UserID], [SiteID], [Name], [LoginName], [Email], [LoweredEmail], [PasswordQuestion], [PasswordAnswer], [Gender], [ProfileApproved], [RegisterConfirmGuid], [ApprovedForForums], [Trusted], [DisplayInMemberList], [WebSiteURL], [Country], [State], [Occupation], [Interests], [MSN], [Yahoo], [AIM], [ICQ], [TotalPosts], [AvatarUrl], [TimeOffsetHours], [Signature], [DateCreated], [UserGuid], [Skin], [IsDeleted], [LastActivityDate], [LastLoginDate], [LastPasswordChangedDate], [LastLockoutDate], [FailedPasswordAttemptCount], [FailedPwdAttemptWindowStart], [FailedPwdAnswerAttemptCount], [FailedPwdAnswerWindowStart], [IsLockedOut], [MobilePIN], [PasswordSalt], [Comment], [OpenIDURI], [WindowsLiveID], [SiteGuid], [TotalRevenue], [FirstName], [LastName], [Pwd], [MustChangePwd], [NewEmail], [EditorPreference], [EmailChangeGuid], [TimeZoneId], [PasswordResetGuid], [RolesChanged], [AuthorBio]) VALUES (8, 1, N'Quan-ly-noi-dung', N'Quan-ly-noi-dung', N'qlnd@canhcam.vn', N'qlnd@canhcam.vn', N'What''s the meaning of life?', N'...', N' ', 1, NULL, 1, 0, 1, N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'', 0, N'', CAST(0x0000A58700394541 AS DateTime), N'1cf98719-188e-4b36-a88f-4561eea0af01', N'', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, N'', N'', N'', N'', N'd61fe7b9-1caa-4c2d-afc1-d4fc174631c9', CAST(0.0000 AS Decimal(15, 4)), N'', N'', N'qlnd', 0, N'', N'', N'00000000-0000-0000-0000-000000000000', N'SE Asia Standard Time', N'00000000-0000-0000-0000-000000000000', 1, N'')
INSERT [dbo].[gb_Users] ([UserID], [SiteID], [Name], [LoginName], [Email], [LoweredEmail], [PasswordQuestion], [PasswordAnswer], [Gender], [ProfileApproved], [RegisterConfirmGuid], [ApprovedForForums], [Trusted], [DisplayInMemberList], [WebSiteURL], [Country], [State], [Occupation], [Interests], [MSN], [Yahoo], [AIM], [ICQ], [TotalPosts], [AvatarUrl], [TimeOffsetHours], [Signature], [DateCreated], [UserGuid], [Skin], [IsDeleted], [LastActivityDate], [LastLoginDate], [LastPasswordChangedDate], [LastLockoutDate], [FailedPasswordAttemptCount], [FailedPwdAttemptWindowStart], [FailedPwdAnswerAttemptCount], [FailedPwdAnswerWindowStart], [IsLockedOut], [MobilePIN], [PasswordSalt], [Comment], [OpenIDURI], [WindowsLiveID], [SiteGuid], [TotalRevenue], [FirstName], [LastName], [Pwd], [MustChangePwd], [NewEmail], [EditorPreference], [EmailChangeGuid], [TimeZoneId], [PasswordResetGuid], [RolesChanged], [AuthorBio]) VALUES (9, 1, N'Tri Test', N'Tri-Test', N'tritest@gmail.com', N'tritest@gmail.com', N'', N'', N' ', 1, NULL, 1, 0, 1, N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'', 0, N'', CAST(0x0000A7C400A30AB0 AS DateTime), N'dfbf253e-0983-44df-875a-313bc61513d4', N'', 0, CAST(0x0000A7CC00A014A5 AS DateTime), NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, N'', N'6d491a70-dd3e-4b01-97bf-8268d12fe24f', N'', N'', N'd61fe7b9-1caa-4c2d-afc1-d4fc174631c9', CAST(0.0000 AS Decimal(15, 4)), N'Test', N'Tri', N'123', 0, N'', N'', N'00000000-0000-0000-0000-000000000000', N'SE Asia Standard Time', N'00000000-0000-0000-0000-000000000000', 0, N'')
INSERT [dbo].[gb_Users] ([UserID], [SiteID], [Name], [LoginName], [Email], [LoweredEmail], [PasswordQuestion], [PasswordAnswer], [Gender], [ProfileApproved], [RegisterConfirmGuid], [ApprovedForForums], [Trusted], [DisplayInMemberList], [WebSiteURL], [Country], [State], [Occupation], [Interests], [MSN], [Yahoo], [AIM], [ICQ], [TotalPosts], [AvatarUrl], [TimeOffsetHours], [Signature], [DateCreated], [UserGuid], [Skin], [IsDeleted], [LastActivityDate], [LastLoginDate], [LastPasswordChangedDate], [LastLockoutDate], [FailedPasswordAttemptCount], [FailedPwdAttemptWindowStart], [FailedPwdAnswerAttemptCount], [FailedPwdAnswerWindowStart], [IsLockedOut], [MobilePIN], [PasswordSalt], [Comment], [OpenIDURI], [WindowsLiveID], [SiteGuid], [TotalRevenue], [FirstName], [LastName], [Pwd], [MustChangePwd], [NewEmail], [EditorPreference], [EmailChangeGuid], [TimeZoneId], [PasswordResetGuid], [RolesChanged], [AuthorBio]) VALUES (10, 1, N'Khanh Ngo', N'Khanh-Ngo', N'khanhngo@gmail.com', N'khanhngo@gmail.com', N'', N'', N' ', 1, NULL, 1, 0, 1, N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'', 0, N'', CAST(0x0000A7C5006A5FA7 AS DateTime), N'51b925d5-d8fe-452d-97c7-5b6c07d085d6', N'', 0, CAST(0x0000A7C5006B5519 AS DateTime), NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, N'', N'', N'', N'', N'd61fe7b9-1caa-4c2d-afc1-d4fc174631c9', CAST(0.0000 AS Decimal(15, 4)), N'Ngo', N'Khanh', N'123', 0, N'', N'', N'00000000-0000-0000-0000-000000000000', N'SE Asia Standard Time', N'00000000-0000-0000-0000-000000000000', 0, N'')
INSERT [dbo].[gb_Users] ([UserID], [SiteID], [Name], [LoginName], [Email], [LoweredEmail], [PasswordQuestion], [PasswordAnswer], [Gender], [ProfileApproved], [RegisterConfirmGuid], [ApprovedForForums], [Trusted], [DisplayInMemberList], [WebSiteURL], [Country], [State], [Occupation], [Interests], [MSN], [Yahoo], [AIM], [ICQ], [TotalPosts], [AvatarUrl], [TimeOffsetHours], [Signature], [DateCreated], [UserGuid], [Skin], [IsDeleted], [LastActivityDate], [LastLoginDate], [LastPasswordChangedDate], [LastLockoutDate], [FailedPasswordAttemptCount], [FailedPwdAttemptWindowStart], [FailedPwdAnswerAttemptCount], [FailedPwdAnswerWindowStart], [IsLockedOut], [MobilePIN], [PasswordSalt], [Comment], [OpenIDURI], [WindowsLiveID], [SiteGuid], [TotalRevenue], [FirstName], [LastName], [Pwd], [MustChangePwd], [NewEmail], [EditorPreference], [EmailChangeGuid], [TimeZoneId], [PasswordResetGuid], [RolesChanged], [AuthorBio]) VALUES (11, 1, N'Sang Sang', N'Sang-Sang', N'sang@gmail.com', N'sang@gmail.com', N'', N'', N' ', 1, NULL, 1, 0, 1, N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'', 0, N'', CAST(0x0000A7C5006B6E5A AS DateTime), N'197ca7e1-d2ca-4f10-87f8-893e77394eb4', N'', 0, CAST(0x0000A7C9009D7140 AS DateTime), NULL, NULL, CAST(0x0000A7C8004E52B5 AS DateTime), 0, NULL, 0, NULL, 0, NULL, N'', N'', N'', N'', N'd61fe7b9-1caa-4c2d-afc1-d4fc174631c9', CAST(0.0000 AS Decimal(15, 4)), N'Sang', N'Sang', N'123', 0, N'', N'', N'00000000-0000-0000-0000-000000000000', N'SE Asia Standard Time', N'00000000-0000-0000-0000-000000000000', 0, N'')
INSERT [dbo].[gb_Users] ([UserID], [SiteID], [Name], [LoginName], [Email], [LoweredEmail], [PasswordQuestion], [PasswordAnswer], [Gender], [ProfileApproved], [RegisterConfirmGuid], [ApprovedForForums], [Trusted], [DisplayInMemberList], [WebSiteURL], [Country], [State], [Occupation], [Interests], [MSN], [Yahoo], [AIM], [ICQ], [TotalPosts], [AvatarUrl], [TimeOffsetHours], [Signature], [DateCreated], [UserGuid], [Skin], [IsDeleted], [LastActivityDate], [LastLoginDate], [LastPasswordChangedDate], [LastLockoutDate], [FailedPasswordAttemptCount], [FailedPwdAttemptWindowStart], [FailedPwdAnswerAttemptCount], [FailedPwdAnswerWindowStart], [IsLockedOut], [MobilePIN], [PasswordSalt], [Comment], [OpenIDURI], [WindowsLiveID], [SiteGuid], [TotalRevenue], [FirstName], [LastName], [Pwd], [MustChangePwd], [NewEmail], [EditorPreference], [EmailChangeGuid], [TimeZoneId], [PasswordResetGuid], [RolesChanged], [AuthorBio]) VALUES (12, 1, N'Tri Tri', N'Tri-Tri', N'tri@gmail.com', N'tri@gmail.com', N'', N'', N' ', 1, NULL, 1, 0, 1, N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'', 0, N'', CAST(0x0000A7C5006BEF99 AS DateTime), N'50903e5c-6cce-4ffe-8a4b-8837b1189c2f', N'', 0, CAST(0x0000A7C9009D847D AS DateTime), NULL, NULL, CAST(0x0000A7C9003B77AC AS DateTime), 0, NULL, 0, NULL, 0, NULL, N'', N'', N'', N'', N'd61fe7b9-1caa-4c2d-afc1-d4fc174631c9', CAST(0.0000 AS Decimal(15, 4)), N'Tri', N'Tri', N'123', 0, N'', N'', N'00000000-0000-0000-0000-000000000000', N'SE Asia Standard Time', N'00000000-0000-0000-0000-000000000000', 0, N'')
INSERT [dbo].[gb_Users] ([UserID], [SiteID], [Name], [LoginName], [Email], [LoweredEmail], [PasswordQuestion], [PasswordAnswer], [Gender], [ProfileApproved], [RegisterConfirmGuid], [ApprovedForForums], [Trusted], [DisplayInMemberList], [WebSiteURL], [Country], [State], [Occupation], [Interests], [MSN], [Yahoo], [AIM], [ICQ], [TotalPosts], [AvatarUrl], [TimeOffsetHours], [Signature], [DateCreated], [UserGuid], [Skin], [IsDeleted], [LastActivityDate], [LastLoginDate], [LastPasswordChangedDate], [LastLockoutDate], [FailedPasswordAttemptCount], [FailedPwdAttemptWindowStart], [FailedPwdAnswerAttemptCount], [FailedPwdAnswerWindowStart], [IsLockedOut], [MobilePIN], [PasswordSalt], [Comment], [OpenIDURI], [WindowsLiveID], [SiteGuid], [TotalRevenue], [FirstName], [LastName], [Pwd], [MustChangePwd], [NewEmail], [EditorPreference], [EmailChangeGuid], [TimeZoneId], [PasswordResetGuid], [RolesChanged], [AuthorBio]) VALUES (13, 1, N'Khanh Khanh', N'Khanh-Khanh', N'khanh@gmail.com', N'khanh@gmail.com', N'', N'', N' ', 1, NULL, 1, 0, 1, N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'', 0, N'', CAST(0x0000A7C500762321 AS DateTime), N'1043fd68-bb63-42e5-bee9-0cf0b230f07b', N'', 0, CAST(0x0000A7C500A85F69 AS DateTime), NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, N'', N'', N'', N'', N'd61fe7b9-1caa-4c2d-afc1-d4fc174631c9', CAST(0.0000 AS Decimal(15, 4)), N'Khanh', N'Khanh', N'123', 0, N'', N'', N'00000000-0000-0000-0000-000000000000', N'SE Asia Standard Time', N'00000000-0000-0000-0000-000000000000', 0, N'')
INSERT [dbo].[gb_Users] ([UserID], [SiteID], [Name], [LoginName], [Email], [LoweredEmail], [PasswordQuestion], [PasswordAnswer], [Gender], [ProfileApproved], [RegisterConfirmGuid], [ApprovedForForums], [Trusted], [DisplayInMemberList], [WebSiteURL], [Country], [State], [Occupation], [Interests], [MSN], [Yahoo], [AIM], [ICQ], [TotalPosts], [AvatarUrl], [TimeOffsetHours], [Signature], [DateCreated], [UserGuid], [Skin], [IsDeleted], [LastActivityDate], [LastLoginDate], [LastPasswordChangedDate], [LastLockoutDate], [FailedPasswordAttemptCount], [FailedPwdAttemptWindowStart], [FailedPwdAnswerAttemptCount], [FailedPwdAnswerWindowStart], [IsLockedOut], [MobilePIN], [PasswordSalt], [Comment], [OpenIDURI], [WindowsLiveID], [SiteGuid], [TotalRevenue], [FirstName], [LastName], [Pwd], [MustChangePwd], [NewEmail], [EditorPreference], [EmailChangeGuid], [TimeZoneId], [PasswordResetGuid], [RolesChanged], [AuthorBio]) VALUES (14, 1, N'diệu', N'diệu', N'minhdieu@canhcam.vn', N'minhdieu@canhcam.vn', N'', N'', N' ', 1, NULL, 1, 0, 1, N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'', 0, N'', CAST(0x0000A7C500A45F15 AS DateTime), N'f10b512e-1a72-4df0-a6fe-de73acfe22c5', N'', 0, CAST(0x0000A7C500A826DC AS DateTime), NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, N'', N'', N'', N'', N'd61fe7b9-1caa-4c2d-afc1-d4fc174631c9', CAST(0.0000 AS Decimal(15, 4)), N'diệu', N'', N'123', 0, N'', N'', N'00000000-0000-0000-0000-000000000000', N'SE Asia Standard Time', N'00000000-0000-0000-0000-000000000000', 0, N'')
INSERT [dbo].[gb_Users] ([UserID], [SiteID], [Name], [LoginName], [Email], [LoweredEmail], [PasswordQuestion], [PasswordAnswer], [Gender], [ProfileApproved], [RegisterConfirmGuid], [ApprovedForForums], [Trusted], [DisplayInMemberList], [WebSiteURL], [Country], [State], [Occupation], [Interests], [MSN], [Yahoo], [AIM], [ICQ], [TotalPosts], [AvatarUrl], [TimeOffsetHours], [Signature], [DateCreated], [UserGuid], [Skin], [IsDeleted], [LastActivityDate], [LastLoginDate], [LastPasswordChangedDate], [LastLockoutDate], [FailedPasswordAttemptCount], [FailedPwdAttemptWindowStart], [FailedPwdAnswerAttemptCount], [FailedPwdAnswerWindowStart], [IsLockedOut], [MobilePIN], [PasswordSalt], [Comment], [OpenIDURI], [WindowsLiveID], [SiteGuid], [TotalRevenue], [FirstName], [LastName], [Pwd], [MustChangePwd], [NewEmail], [EditorPreference], [EmailChangeGuid], [TimeZoneId], [PasswordResetGuid], [RolesChanged], [AuthorBio]) VALUES (16, 1, N'Nguyen Kinh Luan', N'Nguyen-Kinh-Luan', N'nkinhluan@gmail.com', N'nkinhluan@gmail.com', N'', N'', N' ', 1, NULL, 1, 0, 1, N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'', 0, N'', CAST(0x0000A7CA002AC768 AS DateTime), N'bc5ae996-0f3e-42cc-a5e7-baa4ce48f86c', N'', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, N'', N'', N'', N'', N'd61fe7b9-1caa-4c2d-afc1-d4fc174631c9', CAST(0.0000 AS Decimal(15, 4)), N'Luan', N'NguyenKinh', N'luan561561', 0, N'', N'', N'00000000-0000-0000-0000-000000000000', N'SE Asia Standard Time', N'00000000-0000-0000-0000-000000000000', 0, N'')
SET IDENTITY_INSERT [dbo].[gb_Users] OFF
SET IDENTITY_INSERT [dbo].[gb_News] ON
INSERT [dbo].[gb_News] ([NewsID], [SiteID], [ZoneID], [Title], [SubTitle], [Url], [Code], [OpenInNewWindow], [IncludeInSearch], [IncludeInSiteMap], [IncludeInFeed], [BriefContent], [FullContent], [NewsType], [Position], [ShowOption], [IsPublished], [StartDate], [EndDate], [DisplayOrder], [Viewed], [IsDeleted], [AllowCommentsForDays], [CommentCount], [MetaTitle], [MetaKeywords], [MetaDescription], [AdditionalMetaTags], [CompiledMeta], [FileAttachment], [NewsGuid], [UserGuid], [CreatedUtc], [LastModUtc], [LastModUserGuid], [StateID], [ApprovedUtc], [ApprovedUserGuid], [ApprovedBy], [RejectedNotes]) VALUES (9, 1, 2, N'Tầm nhìn sứ mệnh', N'', N'~/tam-nhin-su-menh-1', N'', 0, 1, 1, 1, N'', N'<div class="tamnhin_wrap">
<div class="col-sm6L">
<div class="bg-tamnhin">
<div class="bg-title-frame-tamnhin">
<div class="border-title-tamnhin">Tầm nhìn</div>
</div>
<div class="body-tamnhin">
<span class="border-body-tamnhin"></span>
<span class="ngtop"></span>
<div class="text-tamnhin">
Trở thành ngân hàng được khách hàng lựa chọn hàng đầu của Việt Nam trong lĩnh vực dịch vụ khách hàng dành cho khách hàng cá nhân và khách hàng doanh nghiệp
</div>
<span class="ngunder"></span>
</div>
</div>
<div class="emptyframe">
<span class="border-empty">
</span></div>
<div class="img-tamnhin nomarginbt">
<img alt="" src="/Data/Sites/1/media/img-bank2.jpg" />
</div>
</div>
<div class="col-sm6R">
<div class="img-tamnhin">
<img alt="" src="/Data/Sites/1/media/img-bank.png" />
</div>
<span class="emptyframe2"></span>
<div class="bg-title-frame-tamnhin marT15">
<div class="border-title-tamnhin">Sứ mệnh</div>
</div>
<div class="body-tamnhin2">
<span class="ngtop"></span>
<div class="text-tamnhin">
Ngân hàng Kiên Long luôn chấp hành tốt mọi chủ trương chính sách của Nhà nước. Thực hiện tốt nghĩa vụ thuế, tham gia bảo hiểm y tế, bảo hiểm xã hội theo đúng quy định của pháp luật.
</div>
<span class="ngunder"></span>
</div>
</div>
<div class="clear"></div>
</div>
<!-- history_wrap-->', 0, 0, 0, 1, CAST(0x0000A33A00AE2220 AS DateTime), NULL, 0, 34, 1, 90, 0, N'', N'', N'', N'', N'', N'', N'f5fcac90-2a00-4ab5-ac1b-abdc90481cb6', N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', CAST(0x0000A33A00AE6B69 AS DateTime), CAST(0x0000A36300AEF2A3 AS DateTime), N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', 4, CAST(0x0000A355013C2FEA AS DateTime), N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', N'admin@canhcam.vn', NULL)
INSERT [dbo].[gb_News] ([NewsID], [SiteID], [ZoneID], [Title], [SubTitle], [Url], [Code], [OpenInNewWindow], [IncludeInSearch], [IncludeInSiteMap], [IncludeInFeed], [BriefContent], [FullContent], [NewsType], [Position], [ShowOption], [IsPublished], [StartDate], [EndDate], [DisplayOrder], [Viewed], [IsDeleted], [AllowCommentsForDays], [CommentCount], [MetaTitle], [MetaKeywords], [MetaDescription], [AdditionalMetaTags], [CompiledMeta], [FileAttachment], [NewsGuid], [UserGuid], [CreatedUtc], [LastModUtc], [LastModUserGuid], [StateID], [ApprovedUtc], [ApprovedUserGuid], [ApprovedBy], [RejectedNotes]) VALUES (10, 1, 45, N'Test', N'', N'~/test', N'', 0, 1, 1, 1, N'Test123123', N'asfasdf', 0, 0, 0, 1, CAST(0x0000A34D007E57C0 AS DateTime), NULL, 0, 24, 1, 90, 0, N'', N'', N'', N'', N'', N'', N'10dee897-b747-4de4-9685-b399e56a0f2e', N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', CAST(0x0000A34D007E931A AS DateTime), CAST(0x0000A36800712520 AS DateTime), N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', 4, CAST(0x0000A35501219576 AS DateTime), N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', N'admin@canhcam.vn', NULL)
INSERT [dbo].[gb_News] ([NewsID], [SiteID], [ZoneID], [Title], [SubTitle], [Url], [Code], [OpenInNewWindow], [IncludeInSearch], [IncludeInSiteMap], [IncludeInFeed], [BriefContent], [FullContent], [NewsType], [Position], [ShowOption], [IsPublished], [StartDate], [EndDate], [DisplayOrder], [Viewed], [IsDeleted], [AllowCommentsForDays], [CommentCount], [MetaTitle], [MetaKeywords], [MetaDescription], [AdditionalMetaTags], [CompiledMeta], [FileAttachment], [NewsGuid], [UserGuid], [CreatedUtc], [LastModUtc], [LastModUserGuid], [StateID], [ApprovedUtc], [ApprovedUserGuid], [ApprovedBy], [RejectedNotes]) VALUES (14, 1, 3, N'Bài viết 1', N'', N'~/bai-viet-1', N'', 0, 1, 1, 1, N'', N'', 0, 0, 0, 1, CAST(0x0000A36A0084A8F0 AS DateTime), NULL, 0, 18, 1, 90, 0, N'', N'', N'', N'', N'', N'', N'd4d778dd-ff2f-4a68-afbb-a3b38f46a727', N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', CAST(0x0000A36A0084F210 AS DateTime), CAST(0x0000A36A009D5BD5 AS DateTime), N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[gb_News] ([NewsID], [SiteID], [ZoneID], [Title], [SubTitle], [Url], [Code], [OpenInNewWindow], [IncludeInSearch], [IncludeInSiteMap], [IncludeInFeed], [BriefContent], [FullContent], [NewsType], [Position], [ShowOption], [IsPublished], [StartDate], [EndDate], [DisplayOrder], [Viewed], [IsDeleted], [AllowCommentsForDays], [CommentCount], [MetaTitle], [MetaKeywords], [MetaDescription], [AdditionalMetaTags], [CompiledMeta], [FileAttachment], [NewsGuid], [UserGuid], [CreatedUtc], [LastModUtc], [LastModUserGuid], [StateID], [ApprovedUtc], [ApprovedUserGuid], [ApprovedBy], [RejectedNotes]) VALUES (15, 1, 3, N'san pham', N'', N'~/san-pham-3', N'', 0, 1, 1, 1, N'', N'', 0, 0, 0, 1, CAST(0x0000A36A011F0490 AS DateTime), NULL, 0, 3, 1, 90, 0, N'', N'', N'', N'', N'', N'', N'9793ce13-1490-443d-9d8a-c73ca2ff527a', N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', CAST(0x0000A36A011F2816 AS DateTime), CAST(0x0000A42D0067E251 AS DateTime), N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[gb_News] ([NewsID], [SiteID], [ZoneID], [Title], [SubTitle], [Url], [Code], [OpenInNewWindow], [IncludeInSearch], [IncludeInSiteMap], [IncludeInFeed], [BriefContent], [FullContent], [NewsType], [Position], [ShowOption], [IsPublished], [StartDate], [EndDate], [DisplayOrder], [Viewed], [IsDeleted], [AllowCommentsForDays], [CommentCount], [MetaTitle], [MetaKeywords], [MetaDescription], [AdditionalMetaTags], [CompiledMeta], [FileAttachment], [NewsGuid], [UserGuid], [CreatedUtc], [LastModUtc], [LastModUserGuid], [StateID], [ApprovedUtc], [ApprovedUserGuid], [ApprovedBy], [RejectedNotes]) VALUES (16, 1, 3, N'25252523525', N'', N'~/25252523525', N'', 0, 1, 1, 1, N'', N'', 0, 0, 0, 1, CAST(0x0000A36A011F0490 AS DateTime), NULL, 0, 1, 1, 90, 0, N'', N'', N'', N'', N'', N'', N'cc3eaac3-a616-46df-8b1f-b2b74e1e4c58', N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', CAST(0x0000A36A011F341D AS DateTime), CAST(0x0000A36B00F9CB74 AS DateTime), N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[gb_News] ([NewsID], [SiteID], [ZoneID], [Title], [SubTitle], [Url], [Code], [OpenInNewWindow], [IncludeInSearch], [IncludeInSiteMap], [IncludeInFeed], [BriefContent], [FullContent], [NewsType], [Position], [ShowOption], [IsPublished], [StartDate], [EndDate], [DisplayOrder], [Viewed], [IsDeleted], [AllowCommentsForDays], [CommentCount], [MetaTitle], [MetaKeywords], [MetaDescription], [AdditionalMetaTags], [CompiledMeta], [FileAttachment], [NewsGuid], [UserGuid], [CreatedUtc], [LastModUtc], [LastModUserGuid], [StateID], [ApprovedUtc], [ApprovedUserGuid], [ApprovedBy], [RejectedNotes]) VALUES (17, 1, 2, N'About us', N'', N'~/about-us-2', N'', 0, 0, 0, 0, N'', N'<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Sequi debitis, expedita officiis velit tenetur facilis, quod cupiditate perferendis beatae, nobis harum ipsum necessitatibus quis hic quaerat! Nemo possimus placeat ea!
</p>
<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Accusamus, laborum, rem! Modi deleniti eius, facere inventore itaque iusto quae ipsum doloribus ex cumque! Sunt veritatis consequatur doloribus! Recusandae aliquam culpa cum ex itaque enim, minus eum reprehenderit vel debitis nisi totam, deleniti nam modi minima quidem. Quibusdam autem, velit ipsum.
</p>
<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Architecto voluptas repellendus at ipsam similique corporis magni repellat voluptates inventore, qui.</p>', 0, 0, 0, 0, CAST(0x0000A7B00052F260 AS DateTime), NULL, 0, 1, 1, 90, 0, N'', N'', N'', N'', N'', N'', N'826b6558-d337-4324-b5af-6eff88d80891', N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', CAST(0x0000A7B00053AC1A AS DateTime), CAST(0x0000A7C9008CEAEF AS DateTime), N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[gb_News] ([NewsID], [SiteID], [ZoneID], [Title], [SubTitle], [Url], [Code], [OpenInNewWindow], [IncludeInSearch], [IncludeInSiteMap], [IncludeInFeed], [BriefContent], [FullContent], [NewsType], [Position], [ShowOption], [IsPublished], [StartDate], [EndDate], [DisplayOrder], [Viewed], [IsDeleted], [AllowCommentsForDays], [CommentCount], [MetaTitle], [MetaKeywords], [MetaDescription], [AdditionalMetaTags], [CompiledMeta], [FileAttachment], [NewsGuid], [UserGuid], [CreatedUtc], [LastModUtc], [LastModUserGuid], [StateID], [ApprovedUtc], [ApprovedUserGuid], [ApprovedBy], [RejectedNotes]) VALUES (18, 1, 2, N'Some facts about us', N'', N'~/some-facts-about-us', N'', 0, 0, 0, 0, N'', N'<div class="row">
<div class="col-xs-12 col-sm-6 col-lg-3">
<figure>
<div class="icon"><em class="fa fa-file-text" aria-hidden="true"></em></div>
<figcaption>
<h5 class="counter">9568</h5>
<h6>posts</h6>
</figcaption>
</figure>
</div>
<div class="col-xs-12 col-sm-6 col-lg-3">
<figure>
<div class="icon"><em class="fa fa-user" aria-hidden="true"></em></div>
<figcaption>
<h5 class="counter">695</h5>
<h6>Author</h6>
</figcaption>
</figure>
</div>
<div class="col-xs-12 col-sm-6 col-lg-3">
<figure>
<div class="icon"><em class="fa fa-thumbs-up" aria-hidden="true"></em></div>
<figcaption>
<h5 class="counter">100</h5>
<h6>Million likes</h6>
</figcaption>
</figure>
</div>
<div class="col-xs-12 col-sm-6 col-lg-3">
<figure>
<div class="icon"><em class="fa fa-comments" aria-hidden="true"></em></div>
<figcaption>
<h5 class="counter">99999</h5>
<h6>Comment</h6>
</figcaption>
</figure>
</div>
</div>', 0, 0, 0, 0, CAST(0x0000A7B00053C550 AS DateTime), NULL, 0, 0, 1, 90, 0, N'', N'', N'', N'', N'', N'', N'5d7520ff-2032-4696-af4b-7c755be8d31c', N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', CAST(0x0000A7B0005D7D03 AS DateTime), CAST(0x0000A7C400A0D093 AS DateTime), N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[gb_News] ([NewsID], [SiteID], [ZoneID], [Title], [SubTitle], [Url], [Code], [OpenInNewWindow], [IncludeInSearch], [IncludeInSiteMap], [IncludeInFeed], [BriefContent], [FullContent], [NewsType], [Position], [ShowOption], [IsPublished], [StartDate], [EndDate], [DisplayOrder], [Viewed], [IsDeleted], [AllowCommentsForDays], [CommentCount], [MetaTitle], [MetaKeywords], [MetaDescription], [AdditionalMetaTags], [CompiledMeta], [FileAttachment], [NewsGuid], [UserGuid], [CreatedUtc], [LastModUtc], [LastModUserGuid], [StateID], [ApprovedUtc], [ApprovedUserGuid], [ApprovedBy], [RejectedNotes]) VALUES (19, 1, 2, N'Vision & Mission', N'', N'~/vision-mission', N'', 0, 0, 0, 0, N'', N'<div class="content">
<div class="row">
<div class="col-sm-6">
<div class="vision">
<figure class="text-center"><em class="fa fa-paper-plane-o" aria-hidden="true"></em>
<figcaption>
<h3>Vision</h3>
<div class="desc"> Lorem ipsum dolor sit amet, consectetur adipisicing elit. Distinctio, harum maxime veniam ex culpa quia, consequuntur. Ab voluptatibus quam, consectetur.</div>
</figcaption>
</figure>
</div>
</div>
<div class="col-sm-6">
<div class="vision">
<figure class="text-center"><em class="fa fa-users" aria-hidden="true"></em>
<figcaption>
<h3>Mission</h3>
<div class="desc"> Lorem ipsum dolor sit amet, consectetur adipisicing elit. Praesentium quas placeat, similique dolores perspiciatis ipsam illo sint odio dolorum! Ipsum. </div>
</figcaption>
</figure>
</div>
</div>
</div>
</div>', 0, 0, 0, 0, CAST(0x0000A7B0005D6240 AS DateTime), NULL, 0, 0, 1, 90, 0, N'', N'', N'', N'', N'', N'', N'0732def5-5376-49db-b9f9-14bcf363adb9', N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', CAST(0x0000A7B0005E3A5C AS DateTime), CAST(0x0000A7C400A0D093 AS DateTime), N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[gb_News] ([NewsID], [SiteID], [ZoneID], [Title], [SubTitle], [Url], [Code], [OpenInNewWindow], [IncludeInSearch], [IncludeInSiteMap], [IncludeInFeed], [BriefContent], [FullContent], [NewsType], [Position], [ShowOption], [IsPublished], [StartDate], [EndDate], [DisplayOrder], [Viewed], [IsDeleted], [AllowCommentsForDays], [CommentCount], [MetaTitle], [MetaKeywords], [MetaDescription], [AdditionalMetaTags], [CompiledMeta], [FileAttachment], [NewsGuid], [UserGuid], [CreatedUtc], [LastModUtc], [LastModUserGuid], [StateID], [ApprovedUtc], [ApprovedUserGuid], [ApprovedBy], [RejectedNotes]) VALUES (20, 1, 85, N'Nguyen Kinh Luan', N'June 19, 2017', N'~/nguyen-kinh-luan', N'', 0, 0, 0, 0, N'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Delectus eos aliquid, sunt, illum tempora maiores. Architecto perferendis ipsum cumque quam amet nihil id dolor nisi debitis reprehenderit, earum, ipsam similique possimus. Vel a vero corporis consequuntur itaque, veritatis quia, in voluptate iure voluptas fugit quasi id nesciunt. Obcaecati, dolorum, blanditiis.', N'', 0, 0, 0, 0, CAST(0x0000A7B000662C40 AS DateTime), NULL, 0, 0, 1, 90, 0, N'', N'', N'', N'', N'', N'', N'20b230b7-025e-4dfc-a5c9-f1d5ebb22489', N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', CAST(0x0000A7B0006740FD AS DateTime), CAST(0x0000A7C400A0D093 AS DateTime), N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[gb_News] ([NewsID], [SiteID], [ZoneID], [Title], [SubTitle], [Url], [Code], [OpenInNewWindow], [IncludeInSearch], [IncludeInSiteMap], [IncludeInFeed], [BriefContent], [FullContent], [NewsType], [Position], [ShowOption], [IsPublished], [StartDate], [EndDate], [DisplayOrder], [Viewed], [IsDeleted], [AllowCommentsForDays], [CommentCount], [MetaTitle], [MetaKeywords], [MetaDescription], [AdditionalMetaTags], [CompiledMeta], [FileAttachment], [NewsGuid], [UserGuid], [CreatedUtc], [LastModUtc], [LastModUserGuid], [StateID], [ApprovedUtc], [ApprovedUserGuid], [ApprovedBy], [RejectedNotes]) VALUES (21, 1, 85, N'Nguyen Kinh Luan', N'June 19, 2017', N'~/nguyen-kinh-luan-1', N'', 0, 0, 0, 0, N'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Delectus eos aliquid, sunt, illum tempora maiores. Architecto perferendis ipsum cumque quam amet nihil id dolor nisi debitis reprehenderit, earum, ipsam similique possimus. Vel a vero corporis consequuntur itaque, veritatis quia, in voluptate iure voluptas fugit quasi id nesciunt. Obcaecati, dolorum, blanditiis.', N'', 0, 0, 0, 0, CAST(0x0000A7B000674580 AS DateTime), NULL, 0, 0, 1, 90, 0, N'', N'', N'', N'', N'', N'', N'6d6fe248-0a4f-435b-95fe-c5ad00918139', N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', CAST(0x0000A7B000677D95 AS DateTime), CAST(0x0000A7C400A0D08F AS DateTime), N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[gb_News] ([NewsID], [SiteID], [ZoneID], [Title], [SubTitle], [Url], [Code], [OpenInNewWindow], [IncludeInSearch], [IncludeInSiteMap], [IncludeInFeed], [BriefContent], [FullContent], [NewsType], [Position], [ShowOption], [IsPublished], [StartDate], [EndDate], [DisplayOrder], [Viewed], [IsDeleted], [AllowCommentsForDays], [CommentCount], [MetaTitle], [MetaKeywords], [MetaDescription], [AdditionalMetaTags], [CompiledMeta], [FileAttachment], [NewsGuid], [UserGuid], [CreatedUtc], [LastModUtc], [LastModUserGuid], [StateID], [ApprovedUtc], [ApprovedUserGuid], [ApprovedBy], [RejectedNotes]) VALUES (22, 1, 85, N'Nguyen Kinh Luan', N'June 19, 2017', N'~/nguyen-kinh-luan-2', N'', 0, 0, 0, 0, N'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Delectus eos aliquid, sunt, illum tempora maiores. Architecto perferendis ipsum cumque quam amet nihil id dolor nisi debitis reprehenderit, earum, ipsam similique possimus. Vel a vero corporis consequuntur itaque, veritatis quia, in voluptate iure voluptas fugit quasi id nesciunt. Obcaecati, dolorum, blanditiis.', N'', 0, 0, 0, 0, CAST(0x0000A7B000674580 AS DateTime), NULL, 0, 0, 1, 90, 0, N'', N'', N'', N'', N'', N'', N'7d12fe5a-1b18-4082-9604-39efadd2b06e', N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', CAST(0x0000A7B0006791C2 AS DateTime), CAST(0x0000A7C400A0D08F AS DateTime), N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[gb_News] ([NewsID], [SiteID], [ZoneID], [Title], [SubTitle], [Url], [Code], [OpenInNewWindow], [IncludeInSearch], [IncludeInSiteMap], [IncludeInFeed], [BriefContent], [FullContent], [NewsType], [Position], [ShowOption], [IsPublished], [StartDate], [EndDate], [DisplayOrder], [Viewed], [IsDeleted], [AllowCommentsForDays], [CommentCount], [MetaTitle], [MetaKeywords], [MetaDescription], [AdditionalMetaTags], [CompiledMeta], [FileAttachment], [NewsGuid], [UserGuid], [CreatedUtc], [LastModUtc], [LastModUserGuid], [StateID], [ApprovedUtc], [ApprovedUserGuid], [ApprovedBy], [RejectedNotes]) VALUES (23, 1, 85, N'Nguyen Kinh Luan', N'June 19, 2017', N'~/nguyen-kinh-luan-3', N'', 0, 0, 0, 0, N'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Delectus eos aliquid, sunt, illum tempora maiores. Architecto perferendis ipsum cumque quam amet nihil id dolor nisi debitis reprehenderit, earum, ipsam similique possimus. Vel a vero corporis consequuntur itaque, veritatis quia, in voluptate iure voluptas fugit quasi id nesciunt. Obcaecati, dolorum, blanditiis.', N'', 0, 0, 0, 0, CAST(0x0000A7B000678BD0 AS DateTime), NULL, 0, 1, 1, 90, 0, N'', N'', N'', N'', N'', N'', N'f07ef287-f0bd-494f-801c-10c9bcd554d2', N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', CAST(0x0000A7B00067A198 AS DateTime), CAST(0x0000A7C9008CDFE7 AS DateTime), N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[gb_News] ([NewsID], [SiteID], [ZoneID], [Title], [SubTitle], [Url], [Code], [OpenInNewWindow], [IncludeInSearch], [IncludeInSiteMap], [IncludeInFeed], [BriefContent], [FullContent], [NewsType], [Position], [ShowOption], [IsPublished], [StartDate], [EndDate], [DisplayOrder], [Viewed], [IsDeleted], [AllowCommentsForDays], [CommentCount], [MetaTitle], [MetaKeywords], [MetaDescription], [AdditionalMetaTags], [CompiledMeta], [FileAttachment], [NewsGuid], [UserGuid], [CreatedUtc], [LastModUtc], [LastModUserGuid], [StateID], [ApprovedUtc], [ApprovedUserGuid], [ApprovedBy], [RejectedNotes]) VALUES (24, 1, 86, N'World’s Best Eco Friendly Destination Worth Visiting in 2017', N'', N'~/worlds-best-eco-friendly-destination-worth-visiting-in-2017', N'', 0, 0, 0, 0, N'<img alt="" src="/Data/Sites/1/media/news/banner.jpg" />', N'<div class="content">
<p class="first"> Lorem ipsum dolor sit amet, consectetur adipisicing elit. Rerum consectetur provident rem magni delectus facilis, iure eius ipsam quibusdam, aut incidunt soluta? Quis aliquid corrupti asperiores, non accusamus dolores nisi error a temporibus. Quis voluptatibus ex neque, eius corporis fuga consequuntur harum, totam deleniti, alias maxime facilis magni vel praesentium numquam ratione cumque accusamus labore culpa at aliquid. Laboriosam perspiciatis laudantium debitis nam deleniti doloremque quaerat iusto tempora dolorum? Ipsa, quidem! Nobis autem iure velit accusantium et recusandae nulla accusamus!</p>
<figure class="clearfix">
<figcaption>
<div class="content">
<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Dolore dolorem reprehenderit adipisci saepe beatae nisi, atque perferendis aliquam illo perspiciatis eos voluptatem laborum doloremque maxime, ea sunt natus distinctio exercitationem, error porro impedit dolorum tenetur. </p>
</div>
</figcaption>
<div class="aboutimg"><img alt="" src="/Data/Sites/1/media/news/dt1.jpg" />
</div>
</figure>
<p class="ps"><em class="fa fa-quote-left" aria-hidden="true"></em> Lorem ipsum dolor sit amet, consectetur adipisicing elit. Placeat cupiditate voluptates quibusdam quae explicabo pariatur tempore, aliquid ipsa.<em class="fa fa-quote-right" aria-hidden="true"></em></p>
<figure class="fix">
<div class="aboutimg"><img alt="" src="/Data/Sites/1/media/news/dt2.jpg" />
</div>
<figcaption>
<div class="content">
<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Dolore dolorem reprehenderit adipisci saepe beatae nisi, atque perferendis aliquam illo perspiciatis eos voluptatem laborum doloremque maxime, ea sunt natus distinctio exercitationem, error porro impedit dolorum tenetur. </p>
</div>
</figcaption>
</figure>
</div>', 0, 0, 0, 0, CAST(0x0000A7B00068A510 AS DateTime), NULL, 0, 8, 1, 90, 0, N'', N'', N'', N'', N'', N'', N'8f560f37-d769-48ae-8c20-ad7bf148563a', N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', CAST(0x0000A7B0006E3724 AS DateTime), CAST(0x0000A7C9008D7FEA AS DateTime), N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[gb_News] ([NewsID], [SiteID], [ZoneID], [Title], [SubTitle], [Url], [Code], [OpenInNewWindow], [IncludeInSearch], [IncludeInSiteMap], [IncludeInFeed], [BriefContent], [FullContent], [NewsType], [Position], [ShowOption], [IsPublished], [StartDate], [EndDate], [DisplayOrder], [Viewed], [IsDeleted], [AllowCommentsForDays], [CommentCount], [MetaTitle], [MetaKeywords], [MetaDescription], [AdditionalMetaTags], [CompiledMeta], [FileAttachment], [NewsGuid], [UserGuid], [CreatedUtc], [LastModUtc], [LastModUserGuid], [StateID], [ApprovedUtc], [ApprovedUserGuid], [ApprovedBy], [RejectedNotes]) VALUES (25, 1, 2, N'Great Places to Visit in London', N'', N'~/great-places-to-visit-in-london', N'', 0, 1, 1, 1, N'', N'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Rerum consectetur provident rem magni delectus facilis, iure eius ipsam quibusdam, aut incidunt soluta? Quis aliquid corrupti asperiores, non accusamus dolores nisi error a temporibus. Quis voluptatibus ex neque, eius corporis fuga consequuntur harum, totam deleniti, alias maxime facilis magni vel praesentium numquam ratione cumque accusamus labore culpa at aliquid. Laboriosam perspiciatis laudantium debitis nam deleniti doloremque quaerat iusto tempora dolorum? Ipsa, quidem! Nobis autem iure velit accusantium et recusandae nulla accusamus!
Lorem ipsum dolor sit amet, consectetur adipisicing elit. Dolore dolorem reprehenderit adipisci saepe beatae nisi, atque perferendis aliquam illo perspiciatis eos voluptatem laborum doloremque maxime, ea sunt natus distinctio exercitationem, error porro impedit dolorum tenetur.
Lorem ipsum dolor sit amet, consectetur adipisicing elit. Placeat cupiditate voluptates quibusdam quae explicabo pariatur tempore, aliquid ipsa.
Lorem ipsum dolor sit amet, consectetur adipisicing elit. Dolore dolorem reprehenderit adipisci saepe beatae nisi, atque perferendis aliquam illo perspiciatis eos voluptatem laborum doloremque maxime, ea sunt natus distinctio exercitationem, error porro impedit dolorum tenetur.', 0, 0, 0, 1, CAST(0x0000A7C400A93080 AS DateTime), NULL, 0, 133, 0, 60, 0, N'', N'', N'', N'', N'', N'', N'9fa68ad6-64b8-4af8-86b4-8ca2ffb3e703', N'dfbf253e-0983-44df-875a-313bc61513d4', CAST(0x0000A7C400A93A51 AS DateTime), CAST(0x0000A7CC00A0003A AS DateTime), N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', -1, CAST(0x0000A7C600477517 AS DateTime), N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', N'Admin', NULL)
INSERT [dbo].[gb_News] ([NewsID], [SiteID], [ZoneID], [Title], [SubTitle], [Url], [Code], [OpenInNewWindow], [IncludeInSearch], [IncludeInSiteMap], [IncludeInFeed], [BriefContent], [FullContent], [NewsType], [Position], [ShowOption], [IsPublished], [StartDate], [EndDate], [DisplayOrder], [Viewed], [IsDeleted], [AllowCommentsForDays], [CommentCount], [MetaTitle], [MetaKeywords], [MetaDescription], [AdditionalMetaTags], [CompiledMeta], [FileAttachment], [NewsGuid], [UserGuid], [CreatedUtc], [LastModUtc], [LastModUserGuid], [StateID], [ApprovedUtc], [ApprovedUserGuid], [ApprovedBy], [RejectedNotes]) VALUES (26, 1, -1, N'World’s Best Eco Friendly Destination Worth Visiting in 2017', N'', N'', N'', 0, 1, 1, 1, N'<img alt="" src="http://kinhluan.canhcam.gb/Data/Sites/1/media/news/banner.jpg" style="box-sizing: border-box; border: 0px; vertical-align: middle; color: #333333; font-family: Roboto, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;" />', N'<p class="first" style="box-sizing: border-box; margin: 0px 0px 10px; color: #333333; font-family: Roboto, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration-style: initial; text-decoration-color: initial;">Lorem ipsum dolor sit amet, consectetur adipisicing elit. Rerum consectetur provident rem magni delectus facilis, iure eius ipsam quibusdam, aut incidunt soluta? Quis aliquid corrupti asperiores, non accusamus dolores nisi error a temporibus. Quis voluptatibus ex neque, eius corporis fuga consequuntur harum, totam deleniti, alias maxime facilis magni vel praesentium numquam ratione cumque accusamus labore culpa at aliquid. Laboriosam perspiciatis laudantium debitis nam deleniti doloremque quaerat iusto tempora dolorum? Ipsa, quidem! Nobis autem iure velit accusantium et recusandae nulla accusamus!</p>
<figure class="clearfix" style="box-sizing: border-box; display: block; margin: 0px; color: #333333; font-family: Roboto, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration-style: initial; text-decoration-color: initial;"><figcaption style="box-sizing: border-box; display: block;">
<div class="content" style="box-sizing: border-box;">
<p style="box-sizing: border-box; margin: 0px 0px 10px;">Lorem ipsum dolor sit amet, consectetur adipisicing elit. Dolore dolorem reprehenderit adipisci saepe beatae nisi, atque perferendis aliquam illo perspiciatis eos voluptatem laborum doloremque maxime, ea sunt natus distinctio exercitationem, error porro impedit dolorum tenetur.</p>
</div>
</figcaption>
<div class="aboutimg" style="box-sizing: border-box;"><img alt="" src="http://kinhluan.canhcam.gb/Data/Sites/1/media/news/dt1.jpg" style="box-sizing: border-box; border: 0px; vertical-align: middle;" /></div>
</figure>
<p class="ps" style="box-sizing: border-box; margin: 0px 0px 10px; color: #333333; font-family: Roboto, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration-style: initial; text-decoration-color: initial;"><em class="fa fa-quote-left" aria-hidden="true" style="box-sizing: border-box; display: inline-block; font-family: FontAwesome; font-style: normal; font-weight: normal; line-height: 1; -webkit-font-smoothing: antialiased;"></em><span> </span>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Placeat cupiditate voluptates quibusdam quae explicabo pariatur tempore, aliquid ipsa.<em class="fa fa-quote-right" aria-hidden="true" style="box-sizing: border-box; display: inline-block; font-family: FontAwesome; font-style: normal; font-weight: normal; line-height: 1; -webkit-font-smoothing: antialiased;"></em></p>
<figure class="fix" style="box-sizing: border-box; display: block; margin: 0px; color: #333333; font-family: Roboto, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration-style: initial; text-decoration-color: initial;">
<div class="aboutimg" style="box-sizing: border-box;"><img alt="" src="http://kinhluan.canhcam.gb/Data/Sites/1/media/news/dt2.jpg" style="box-sizing: border-box; border: 0px; vertical-align: middle;" /></div>
<figcaption style="box-sizing: border-box; display: block;">
<div class="content" style="box-sizing: border-box;">
<p style="box-sizing: border-box; margin: 0px 0px 10px;">Lorem ipsum dolor sit amet, consectetur adipisicing elit. Dolore dolorem reprehenderit adipisci saepe beatae nisi, atque perferendis aliquam illo perspiciatis eos voluptatem laborum doloremque maxime, ea sunt natus distinctio exercitationem, error porro impedit dolorum tenetur.</p>
</div>
</figcaption></figure>', 0, 0, 0, 1, CAST(0x0000A7C5006AC2D7 AS DateTime), NULL, 0, 10, 0, 60, 0, N'', N'', N'', N'', N'', N'', N'743d969a-8b54-4fe1-b05c-4b9f7c1ecbcb', N'51b925d5-d8fe-452d-97c7-5b6c07d085d6', CAST(0x0000A7C5006AC2D7 AS DateTime), CAST(0x0000A7CA002EF37A AS DateTime), N'51b925d5-d8fe-452d-97c7-5b6c07d085d6', -1, CAST(0x0000A7C600477517 AS DateTime), N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', N'Admin', NULL)
INSERT [dbo].[gb_News] ([NewsID], [SiteID], [ZoneID], [Title], [SubTitle], [Url], [Code], [OpenInNewWindow], [IncludeInSearch], [IncludeInSiteMap], [IncludeInFeed], [BriefContent], [FullContent], [NewsType], [Position], [ShowOption], [IsPublished], [StartDate], [EndDate], [DisplayOrder], [Viewed], [IsDeleted], [AllowCommentsForDays], [CommentCount], [MetaTitle], [MetaKeywords], [MetaDescription], [AdditionalMetaTags], [CompiledMeta], [FileAttachment], [NewsGuid], [UserGuid], [CreatedUtc], [LastModUtc], [LastModUserGuid], [StateID], [ApprovedUtc], [ApprovedUserGuid], [ApprovedBy], [RejectedNotes]) VALUES (27, 1, -1, N'World’s Best Eco Friendly Destination Worth Visiting in 2017', N'', N'', N'', 0, 1, 1, 1, N'<span style="font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration-style: initial; text-decoration-color: initial; float: none; display: inline !important; font-family: Roboto, sans-serif; color: #333333;">Lorem ipsum dolor sit amet, consectetur adipisicing elit. Rerum consectetur provident rem magni delectus facilis, iure eius ipsam quibusdam, aut incidunt soluta? Quis aliquid corrupti asperiores, non accusamus dolores nisi error a temporibus. Quis voluptatibus ex neque, eius corporis fuga consequuntur harum, totam deleniti, alias maxime facilis magni vel praesentium numquam ratione cumque accusamus labore culpa at aliquid. Laboriosam perspiciatis laudantium debitis nam deleniti doloremque quaerat iusto tempora dolorum? Ipsa, quidem! Nobis autem iure velit accusantium et recusandae nulla accusamus!</span>', N'<p class="first" style="box-sizing: border-box; margin: 0px 0px 10px; color: #333333; font-family: Roboto, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration-style: initial; text-decoration-color: initial; text-align: left;">Lorem ipsum dolor sit amet, consectetur adipisicing elit. Rerum consectetur provident rem magni delectus facilis, iure eius ipsam quibusdam, aut incidunt soluta? Quis aliquid corrupti asperiores, non accusamus dolores nisi error a temporibus. Quis voluptatibus ex neque, eius corporis fuga consequuntur harum, totam deleniti, alias maxime facilis magni vel praesentium numquam ratione cumque accusamus labore culpa at aliquid. Laboriosam perspiciatis laudantium debitis nam deleniti doloremque quaerat iusto tempora dolorum? Ipsa, quidem! Nobis autem iure velit accusantium et recusandae nulla accusamus!</p>
<figure class="clearfix" style="box-sizing: border-box; display: block; margin: 0px; color: #333333; font-family: Roboto, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration-style: initial; text-decoration-color: initial;"><figcaption style="box-sizing: border-box; display: block;">
<div class="content" style="box-sizing: border-box;">
<p style="box-sizing: border-box; margin: 0px 0px 10px;">Lorem ipsum dolor sit amet, consectetur adipisicing elit. Dolore dolorem reprehenderit adipisci saepe beatae nisi, atque perferendis aliquam illo perspiciatis eos voluptatem laborum doloremque maxime, ea sunt natus distinctio exercitationem, error porro impedit dolorum tenetur.</p>
</div>
</figcaption>
<div class="aboutimg" style="box-sizing: border-box;"><img alt="" src="http://kinhluan.canhcam.gb/Data/Sites/1/media/news/dt1.jpg" style="box-sizing: border-box; border: 0px; vertical-align: middle;" /></div>
</figure>
<p class="ps" style="box-sizing: border-box; margin: 0px 0px 10px; color: #333333; font-family: Roboto, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration-style: initial; text-decoration-color: initial; text-align: left;"><em class="fa fa-quote-left" aria-hidden="true" style="box-sizing: border-box; display: inline-block; font-family: FontAwesome; font-style: normal; font-weight: normal; line-height: 1; -webkit-font-smoothing: antialiased;"></em><span> </span>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Placeat cupiditate voluptates quibusdam quae explicabo pariatur tempore, aliquid ipsa.<em class="fa fa-quote-right" aria-hidden="true" style="box-sizing: border-box; display: inline-block; font-family: FontAwesome; font-style: normal; font-weight: normal; line-height: 1; -webkit-font-smoothing: antialiased;"></em></p>
<figure class="fix" style="box-sizing: border-box; display: block; margin: 0px; color: #333333; font-family: Roboto, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration-style: initial; text-decoration-color: initial;">
<div class="aboutimg" style="box-sizing: border-box;"><img alt="" src="http://kinhluan.canhcam.gb/Data/Sites/1/media/news/dt2.jpg" style="box-sizing: border-box; border: 0px; vertical-align: middle;" /></div>
<figcaption style="box-sizing: border-box; display: block;">
<div class="content" style="box-sizing: border-box;">
<p style="box-sizing: border-box; margin: 0px 0px 10px;">Lorem ipsum dolor sit amet, consectetur adipisicing elit. Dolore dolorem reprehenderit adipisci saepe beatae nisi, atque perferendis aliquam illo perspiciatis eos voluptatem laborum doloremque maxime, ea sunt natus distinctio exercitationem, error porro impedit dolorum tenetur.</p>
</div>
</figcaption></figure>', 0, 0, 0, 1, CAST(0x0000A7C5006B9898 AS DateTime), NULL, 0, 48, 0, 60, 0, N'', N'', N'', N'', N'', N'', N'd72ec051-a1a7-4235-86b0-5f7e395d9d37', N'197ca7e1-d2ca-4f10-87f8-893e77394eb4', CAST(0x0000A7C5006B9898 AS DateTime), CAST(0x0000A7CC009FAE1C AS DateTime), N'197ca7e1-d2ca-4f10-87f8-893e77394eb4', -1, CAST(0x0000A7C600477512 AS DateTime), N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', N'Admin', NULL)
INSERT [dbo].[gb_News] ([NewsID], [SiteID], [ZoneID], [Title], [SubTitle], [Url], [Code], [OpenInNewWindow], [IncludeInSearch], [IncludeInSiteMap], [IncludeInFeed], [BriefContent], [FullContent], [NewsType], [Position], [ShowOption], [IsPublished], [StartDate], [EndDate], [DisplayOrder], [Viewed], [IsDeleted], [AllowCommentsForDays], [CommentCount], [MetaTitle], [MetaKeywords], [MetaDescription], [AdditionalMetaTags], [CompiledMeta], [FileAttachment], [NewsGuid], [UserGuid], [CreatedUtc], [LastModUtc], [LastModUserGuid], [StateID], [ApprovedUtc], [ApprovedUserGuid], [ApprovedBy], [RejectedNotes]) VALUES (28, 1, 2, N'World’s Best Eco Friendly Destination Worth Visiting in 2017', N'', N'', N'', 0, 1, 1, 1, N'World’s Best Eco Friendly Destination Worth Visiting in 2017', N'<p class="first" style="margin: 0px 0px 10px; text-align: left; color: #333333; text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: Roboto,sans-serif; font-size: 14px; font-style: normal; font-weight: normal; word-spacing: 0px; white-space: normal; box-sizing: border-box; orphans: 2; widows: 2; background-color: #ffffff;">Lorem ipsum dolor sit amet, consectetur adipisicing elit. Rerum consectetur provident rem magni delectus facilis, iure eius ipsam quibusdam, aut incidunt soluta? Quis aliquid corrupti asperiores, non accusamus dolores nisi error a temporibus. Quis voluptatibus ex neque, eius corporis fuga consequuntur harum, totam deleniti, alias maxime facilis magni vel praesentium numquam ratione cumque accusamus labore culpa at aliquid. Laboriosam perspiciatis laudantium debitis nam deleniti doloremque quaerat iusto tempora dolorum? Ipsa, quidem! Nobis autem iure velit accusantium et recusandae nulla accusamus!</p>
<figure class="clearfix" style="margin: 0px; text-align: left; color: #333333; text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: Roboto,sans-serif; font-size: 14px; font-style: normal; font-weight: normal; word-spacing: 0px; display: block; white-space: normal; box-sizing: border-box; orphans: 2; widows: 2; background-color: #ffffff;"><figcaption style="display: block; box-sizing: border-box;">
<div class="content" style="box-sizing: border-box;">
<p style="margin: 0px 0px 10px; box-sizing: border-box;">Lorem ipsum dolor sit amet, consectetur adipisicing elit. Dolore dolorem reprehenderit adipisci saepe beatae nisi, atque perferendis aliquam illo perspiciatis eos voluptatem laborum doloremque maxime, ea sunt natus distinctio exercitationem, error porro impedit dolorum tenetur.</p>
</div>
</figcaption>
<div class="aboutimg" style="box-sizing: border-box;"><img alt="" style="border: 0px; border-image: none; vertical-align: middle; box-sizing: border-box;" src="http://kinhluan.canhcam.gb/Data/Sites/1/media/news/dt1.jpg" /></div>
</figure>
<p class="ps" style="margin: 0px 0px 10px; text-align: left; color: #333333; text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: Roboto,sans-serif; font-size: 14px; font-style: normal; font-weight: normal; word-spacing: 0px; white-space: normal; box-sizing: border-box; orphans: 2; widows: 2; background-color: #ffffff;"><em class="fa fa-quote-left" aria-hidden="true" style="line-height: 1; font-family: FontAwesome; font-style: normal; font-weight: normal; display: inline-block; box-sizing: border-box;"></em><span> </span>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Placeat cupiditate voluptates quibusdam quae explicabo pariatur tempore, aliquid ipsa.<em class="fa fa-quote-right" aria-hidden="true" style="line-height: 1; font-family: FontAwesome; font-style: normal; font-weight: normal; display: inline-block; box-sizing: border-box;"></em></p>
<figure class="fix" style="margin: 0px; text-align: left; color: #333333; text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: Roboto,sans-serif; font-size: 14px; font-style: normal; font-weight: normal; word-spacing: 0px; display: block; white-space: normal; box-sizing: border-box; orphans: 2; widows: 2; background-color: #ffffff;">
<div class="aboutimg" style="box-sizing: border-box;"><img alt="" style="border: 0px; border-image: none; vertical-align: middle; box-sizing: border-box;" src="http://kinhluan.canhcam.gb/Data/Sites/1/media/news/dt2.jpg" /></div>
<figcaption style="display: block; box-sizing: border-box;">
<div class="content" style="box-sizing: border-box;">
<p style="margin: 0px 0px 10px; box-sizing: border-box;">Lorem ipsum dolor sit amet, consectetur adipisicing elit. Dolore dolorem reprehenderit adipisci saepe beatae nisi, atque perferendis aliquam illo perspiciatis eos voluptatem laborum doloremque maxime, ea sunt natus distinctio exercitationem, error porro impedit dolorum tenetur.</p>
</div>
</figcaption></figure>', 0, 0, 0, 1, CAST(0x0000A7C5006C0AE0 AS DateTime), NULL, 0, 40, 0, 60, 0, N'', N'', N'', N'', N'', N'', N'529f8266-6f49-4462-bdcb-0f01f54406ef', N'50903e5c-6cce-4ffe-8a4b-8837b1189c2f', CAST(0x0000A7C5006C0AE0 AS DateTime), CAST(0x0000A7CC009FA73D AS DateTime), N'50903e5c-6cce-4ffe-8a4b-8837b1189c2f', 4, CAST(0x0000A7C600477512 AS DateTime), N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', N'Admin', NULL)
INSERT [dbo].[gb_News] ([NewsID], [SiteID], [ZoneID], [Title], [SubTitle], [Url], [Code], [OpenInNewWindow], [IncludeInSearch], [IncludeInSiteMap], [IncludeInFeed], [BriefContent], [FullContent], [NewsType], [Position], [ShowOption], [IsPublished], [StartDate], [EndDate], [DisplayOrder], [Viewed], [IsDeleted], [AllowCommentsForDays], [CommentCount], [MetaTitle], [MetaKeywords], [MetaDescription], [AdditionalMetaTags], [CompiledMeta], [FileAttachment], [NewsGuid], [UserGuid], [CreatedUtc], [LastModUtc], [LastModUserGuid], [StateID], [ApprovedUtc], [ApprovedUserGuid], [ApprovedBy], [RejectedNotes]) VALUES (29, 1, 2, N'Great Places to Visit in London', N'', N'~/great-places-to-visit-in-london-1', N'', 0, 1, 1, 1, N'', N'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Rerum consectetur provident rem magni delectus facilis, iure eius ipsam quibusdam, aut incidunt soluta? Quis aliquid corrupti asperiores, non accusamus dolores nisi error a temporibus. Quis voluptatibus ex neque, eius corporis fuga consequuntur harum, totam deleniti, alias maxime facilis magni vel praesentium numquam ratione cumque accusamus labore culpa at aliquid. Laboriosam perspiciatis laudantium debitis nam deleniti doloremque quaerat iusto tempora dolorum? Ipsa, quidem! Nobis autem iure velit accusantium et recusandae nulla accusamus! Lorem ipsum dolor sit amet, consectetur adipisicing elit. Dolore dolorem reprehenderit adipisci saepe beatae nisi, atque perferendis aliquam illo perspiciatis eos voluptatem laborum doloremque maxime, ea sunt natus distinctio exercitationem, error porro impedit dolorum tenetur. Lorem ipsum dolor sit amet, consectetur adipisicing elit. Placeat cupiditate voluptates quibusdam quae explicabo pariatur tempore, aliquid ipsa. Lorem ipsum dolor sit amet, consectetur adipisicing elit. Dolore dolorem reprehenderit adipisci saepe beatae nisi, atque perferendis aliquam illo perspiciatis eos voluptatem laborum doloremque maxime, ea sunt natus distinctio exercitationem, error porro impedit dolorum tenetur.', 0, 0, 0, 1, CAST(0x0000A7C5006C3720 AS DateTime), NULL, 0, 31, 0, 60, 0, N'', N'', N'', N'', N'', N'', N'055c4638-d648-484f-a43c-d14c9da52bc6', N'50903e5c-6cce-4ffe-8a4b-8837b1189c2f', CAST(0x0000A7C5006C79B5 AS DateTime), CAST(0x0000A7CA00297198 AS DateTime), N'50903e5c-6cce-4ffe-8a4b-8837b1189c2f', -1, CAST(0x0000A7C600477512 AS DateTime), N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', N'Admin', NULL)
INSERT [dbo].[gb_News] ([NewsID], [SiteID], [ZoneID], [Title], [SubTitle], [Url], [Code], [OpenInNewWindow], [IncludeInSearch], [IncludeInSiteMap], [IncludeInFeed], [BriefContent], [FullContent], [NewsType], [Position], [ShowOption], [IsPublished], [StartDate], [EndDate], [DisplayOrder], [Viewed], [IsDeleted], [AllowCommentsForDays], [CommentCount], [MetaTitle], [MetaKeywords], [MetaDescription], [AdditionalMetaTags], [CompiledMeta], [FileAttachment], [NewsGuid], [UserGuid], [CreatedUtc], [LastModUtc], [LastModUserGuid], [StateID], [ApprovedUtc], [ApprovedUserGuid], [ApprovedBy], [RejectedNotes]) VALUES (30, 1, 2, N'Great Places to Visit in London', N'', N'', N'', 0, 1, 1, 1, N'<img alt="" src="http://kinhluan.canhcam.gb/Data/Sites/1/media/news/banner.jpg" style="box-sizing: border-box; border: 0px; vertical-align: middle; color: #333333; font-family: Roboto, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;" />', N'<p class="first" style="box-sizing: border-box; margin: 0px 0px 10px; color: #333333; font-family: Roboto, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration-style: initial; text-decoration-color: initial;">Lorem ipsum dolor sit amet, consectetur adipisicing elit. Rerum consectetur provident rem magni delectus facilis, iure eius ipsam quibusdam, aut incidunt soluta? Quis aliquid corrupti asperiores, non accusamus dolores nisi error a temporibus. Quis voluptatibus ex neque, eius corporis fuga consequuntur harum, totam deleniti, alias maxime facilis magni vel praesentium numquam ratione cumque accusamus labore culpa at aliquid. Laboriosam perspiciatis laudantium debitis nam deleniti doloremque quaerat iusto tempora dolorum? Ipsa, quidem! Nobis autem iure velit accusantium et recusandae nulla accusamus!</p>
<figure class="clearfix" style="box-sizing: border-box; display: block; margin: 0px; color: #333333; font-family: Roboto, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration-style: initial; text-decoration-color: initial;"><figcaption style="box-sizing: border-box; display: block;">
<div class="content" style="box-sizing: border-box;">
<p style="box-sizing: border-box; margin: 0px 0px 10px;">Lorem ipsum dolor sit amet, consectetur adipisicing elit. Dolore dolorem reprehenderit adipisci saepe beatae nisi, atque perferendis aliquam illo perspiciatis eos voluptatem laborum doloremque maxime, ea sunt natus distinctio exercitationem, error porro impedit dolorum tenetur.</p>
</div>
</figcaption>
<div class="aboutimg" style="box-sizing: border-box;"><img alt="" src="http://kinhluan.canhcam.gb/Data/Sites/1/media/news/dt1.jpg" style="box-sizing: border-box; border: 0px; vertical-align: middle;" /></div>
</figure>
<p class="ps" style="box-sizing: border-box; margin: 0px 0px 10px; color: #333333; font-family: Roboto, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration-style: initial; text-decoration-color: initial;"><em class="fa fa-quote-left" aria-hidden="true" style="box-sizing: border-box; display: inline-block; font-family: FontAwesome; font-style: normal; font-weight: normal; line-height: 1; -webkit-font-smoothing: antialiased;"></em><span> </span>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Placeat cupiditate voluptates quibusdam quae explicabo pariatur tempore, aliquid ipsa.<em class="fa fa-quote-right" aria-hidden="true" style="box-sizing: border-box; display: inline-block; font-family: FontAwesome; font-style: normal; font-weight: normal; line-height: 1; -webkit-font-smoothing: antialiased;"></em></p>
<figure class="fix" style="box-sizing: border-box; display: block; margin: 0px; color: #333333; font-family: Roboto, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration-style: initial; text-decoration-color: initial;">
<div class="aboutimg" style="box-sizing: border-box;"><img alt="" src="http://kinhluan.canhcam.gb/Data/Sites/1/media/news/dt2.jpg" style="box-sizing: border-box; border: 0px; vertical-align: middle;" /></div>
<figcaption style="box-sizing: border-box; display: block;">
<div class="content" style="box-sizing: border-box;">
<p style="box-sizing: border-box; margin: 0px 0px 10px;">Lorem ipsum dolor sit amet, consectetur adipisicing elit. Dolore dolorem reprehenderit adipisci saepe beatae nisi, atque perferendis aliquam illo perspiciatis eos voluptatem laborum doloremque maxime, ea sunt natus distinctio exercitationem, error porro impedit dolorum tenetur.</p>
</div>
</figcaption></figure>', 0, 0, 0, 1, CAST(0x0000A7C5006C97E9 AS DateTime), NULL, 0, 24, 0, 60, 0, N'', N'', N'', N'', N'', N'', N'fbf43ddc-d963-41ac-bfe4-cb48e77456ba', N'50903e5c-6cce-4ffe-8a4b-8837b1189c2f', CAST(0x0000A7C5006C97E9 AS DateTime), CAST(0x0000A7CA0037C13D AS DateTime), N'50903e5c-6cce-4ffe-8a4b-8837b1189c2f', -1, CAST(0x0000A7C600477512 AS DateTime), N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', N'Admin', NULL)
INSERT [dbo].[gb_News] ([NewsID], [SiteID], [ZoneID], [Title], [SubTitle], [Url], [Code], [OpenInNewWindow], [IncludeInSearch], [IncludeInSiteMap], [IncludeInFeed], [BriefContent], [FullContent], [NewsType], [Position], [ShowOption], [IsPublished], [StartDate], [EndDate], [DisplayOrder], [Viewed], [IsDeleted], [AllowCommentsForDays], [CommentCount], [MetaTitle], [MetaKeywords], [MetaDescription], [AdditionalMetaTags], [CompiledMeta], [FileAttachment], [NewsGuid], [UserGuid], [CreatedUtc], [LastModUtc], [LastModUserGuid], [StateID], [ApprovedUtc], [ApprovedUserGuid], [ApprovedBy], [RejectedNotes]) VALUES (31, 1, -1, N'Great Places to Visit in VietNam', N'', N'', N'', 0, 1, 1, 1, N'<img alt="" src="http://kinhluan.canhcam.gb/Data/Sites/1/media/news/banner.jpg" style="box-sizing: border-box; border: 0px; vertical-align: middle; color: #333333; font-family: Roboto, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;" />', N'<p class="first" style="box-sizing: border-box; margin: 0px 0px 10px; color: #333333; font-family: Roboto, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration-style: initial; text-decoration-color: initial; text-align: left;">Lorem ipsum dolor sit amet, consectetur adipisicing elit. Rerum consectetur provident rem magni delectus facilis, iure eius ipsam quibusdam, aut incidunt soluta? Quis aliquid corrupti asperiores, non accusamus dolores nisi error a temporibus. Quis voluptatibus ex neque, eius corporis fuga consequuntur harum, totam deleniti, alias maxime facilis magni vel praesentium numquam ratione cumque accusamus labore culpa at aliquid. Laboriosam perspiciatis laudantium debitis nam deleniti doloremque quaerat iusto tempora dolorum? Ipsa, quidem! Nobis autem iure velit accusantium et recusandae nulla accusamus!</p>
<figure class="clearfix" style="box-sizing: border-box; display: block; margin: 0px; color: #333333; font-family: Roboto, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration-style: initial; text-decoration-color: initial;"><figcaption style="box-sizing: border-box; display: block;">
<div class="content" style="box-sizing: border-box;">
<p style="box-sizing: border-box; margin: 0px 0px 10px;">Lorem ipsum dolor sit amet, consectetur adipisicing elit. Dolore dolorem reprehenderit adipisci saepe beatae nisi, atque perferendis aliquam illo perspiciatis eos voluptatem laborum doloremque maxime, ea sunt natus distinctio exercitationem, error porro impedit dolorum tenetur.</p>
</div>
</figcaption>
<div class="aboutimg" style="box-sizing: border-box;"><img alt="" src="http://kinhluan.canhcam.gb/Data/Sites/1/media/news/dt1.jpg" style="box-sizing: border-box; border: 0px; vertical-align: middle;" /></div>
</figure>
<p class="ps" style="box-sizing: border-box; margin: 0px 0px 10px; color: #333333; font-family: Roboto, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration-style: initial; text-decoration-color: initial; text-align: left;"><em class="fa fa-quote-left" aria-hidden="true" style="box-sizing: border-box; display: inline-block; font-family: FontAwesome; font-style: normal; font-weight: normal; line-height: 1; -webkit-font-smoothing: antialiased;"></em><span style="box-sizing: border-box;"> </span>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Placeat cupiditate voluptates quibusdam quae explicabo pariatur tempore, aliquid ipsa.<em class="fa fa-quote-right" aria-hidden="true" style="box-sizing: border-box; display: inline-block; font-family: FontAwesome; font-style: normal; font-weight: normal; line-height: 1; -webkit-font-smoothing: antialiased;"></em></p>
<figure class="fix" style="box-sizing: border-box; display: block; margin: 0px; color: #333333; font-family: Roboto, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration-style: initial; text-decoration-color: initial;">
<div class="aboutimg" style="box-sizing: border-box;"><img alt="" src="http://kinhluan.canhcam.gb/Data/Sites/1/media/news/dt2.jpg" style="box-sizing: border-box; border: 0px; vertical-align: middle;" /></div>
<figcaption style="box-sizing: border-box; display: block;">
<div class="content" style="box-sizing: border-box;">
<p style="box-sizing: border-box; margin: 0px 0px 10px;">Lorem ipsum dolor sit amet, consectetur adipisicing elit. Dolore dolorem reprehenderit adipisci saepe beatae nisi, atque perferendis aliquam illo perspiciatis eos voluptatem laborum doloremque maxime, ea sunt natus distinctio exercitationem, error porro impedit dolorum tenetur.</p>
</div>
</figcaption></figure>', 0, 0, 0, 1, CAST(0x0000A7C500764DC9 AS DateTime), NULL, 0, 10, 0, 60, 0, N'', N'', N'', N'', N'', N'', N'cf1047f0-79ed-493b-beef-fc6492756573', N'1043fd68-bb63-42e5-bee9-0cf0b230f07b', CAST(0x0000A7C500764DC9 AS DateTime), CAST(0x0000A7C900972DE3 AS DateTime), N'1043fd68-bb63-42e5-bee9-0cf0b230f07b', -1, CAST(0x0000A7C9008CC0FB AS DateTime), N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', N'Admin', NULL)
INSERT [dbo].[gb_News] ([NewsID], [SiteID], [ZoneID], [Title], [SubTitle], [Url], [Code], [OpenInNewWindow], [IncludeInSearch], [IncludeInSiteMap], [IncludeInFeed], [BriefContent], [FullContent], [NewsType], [Position], [ShowOption], [IsPublished], [StartDate], [EndDate], [DisplayOrder], [Viewed], [IsDeleted], [AllowCommentsForDays], [CommentCount], [MetaTitle], [MetaKeywords], [MetaDescription], [AdditionalMetaTags], [CompiledMeta], [FileAttachment], [NewsGuid], [UserGuid], [CreatedUtc], [LastModUtc], [LastModUserGuid], [StateID], [ApprovedUtc], [ApprovedUserGuid], [ApprovedBy], [RejectedNotes]) VALUES (32, 1, -1, N'Great Places to Visit in London', N'', N'', N'', 0, 1, 1, 1, N'', N'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Rerum consectetur provident rem magni delectus facilis, iure eius ipsam quibusdam, aut incidunt soluta? Quis aliquid corrupti asperiores, non accusamus dolores nisi error a temporibus. Quis voluptatibus ex neque, eius corporis fuga consequuntur harum, totam deleniti, alias maxime facilis magni vel praesentium numquam ratione cumque accusamus labore culpa at aliquid. Laboriosam perspiciatis laudantium debitis nam deleniti doloremque quaerat iusto tempora dolorum? Ipsa, quidem! Nobis autem iure velit accusantium et recusandae nulla accusamus!
Lorem ipsum dolor sit amet, consectetur adipisicing elit. Dolore dolorem reprehenderit adipisci saepe beatae nisi, atque perferendis aliquam illo perspiciatis eos voluptatem laborum doloremque maxime, ea sunt natus distinctio exercitationem, error porro impedit dolorum tenetur.
Lorem ipsum dolor sit amet, consectetur adipisicing elit. Placeat cupiditate voluptates quibusdam quae explicabo pariatur tempore, aliquid ipsa.
Lorem ipsum dolor sit amet, consectetur adipisicing elit. Dolore dolorem reprehenderit adipisci saepe beatae nisi, atque perferendis aliquam illo perspiciatis eos voluptatem laborum doloremque maxime, ea sunt natus distinctio exercitationem, error porro impedit dolorum tenetur.', 0, 0, 0, 0, CAST(0x0000A7C9007D0F32 AS DateTime), NULL, 0, 6, 1, 60, 0, N'', N'', N'', N'', N'', N'', N'82772e61-043f-42a7-9ebf-884047dd9606', N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', CAST(0x0000A7C9007D0F32 AS DateTime), CAST(0x0000A7C9008CA12F AS DateTime), N'a5cebe11-6deb-49d0-9f42-852fb7cb3304', NULL, NULL, NULL, NULL, NULL)
SET IDENTITY_INSERT [dbo].[gb_News] OFF
SET IDENTITY_INSERT [dbo].[gb_KLAuthor] ON
INSERT [dbo].[gb_KLAuthor] ([AuthorID], [UserID], [Name], [Avatar], [LevelAuthor], [LinkFacebook], [LinkTwitter], [LinkPinterest], [LinkInstagram], [JoinDate], [ArticleCount], [IsDel], [IsActive]) VALUES (1, 9, N'Tri Test', N'1.jpg', N'Basic', N'', N'', N'', N'', CAST(0x0000A7C4011665FA AS DateTime), 1, 0, 1)
INSERT [dbo].[gb_KLAuthor] ([AuthorID], [UserID], [Name], [Avatar], [LevelAuthor], [LinkFacebook], [LinkTwitter], [LinkPinterest], [LinkInstagram], [JoinDate], [ArticleCount], [IsDel], [IsActive]) VALUES (2, 10, N'Khanh Ngo', N'2.jpg', N'Basic', N'', N'', N'', N'', CAST(0x0000A7C500DDBAF0 AS DateTime), 1, 0, 1)
INSERT [dbo].[gb_KLAuthor] ([AuthorID], [UserID], [Name], [Avatar], [LevelAuthor], [LinkFacebook], [LinkTwitter], [LinkPinterest], [LinkInstagram], [JoinDate], [ArticleCount], [IsDel], [IsActive]) VALUES (3, 11, N'Sang Sang', N'3.jpg', N'Basic', N'', N'', N'', N'', CAST(0x0000A7C500DEC99A AS DateTime), 1, 0, 1)
INSERT [dbo].[gb_KLAuthor] ([AuthorID], [UserID], [Name], [Avatar], [LevelAuthor], [LinkFacebook], [LinkTwitter], [LinkPinterest], [LinkInstagram], [JoinDate], [ArticleCount], [IsDel], [IsActive]) VALUES (4, 12, N'Tri Tri', N'4.jpg', N'Basic', N'', N'', N'', N'', CAST(0x0000A7C500DF4AD9 AS DateTime), 3, 0, 1)
INSERT [dbo].[gb_KLAuthor] ([AuthorID], [UserID], [Name], [Avatar], [LevelAuthor], [LinkFacebook], [LinkTwitter], [LinkPinterest], [LinkInstagram], [JoinDate], [ArticleCount], [IsDel], [IsActive]) VALUES (5, 13, N'Khanh Khanh', N'5.jpg', N'Basic', N'', N'', N'', N'', CAST(0x0000A7C500E97E66 AS DateTime), 2, 0, 1)
INSERT [dbo].[gb_KLAuthor] ([AuthorID], [UserID], [Name], [Avatar], [LevelAuthor], [LinkFacebook], [LinkTwitter], [LinkPinterest], [LinkInstagram], [JoinDate], [ArticleCount], [IsDel], [IsActive]) VALUES (6, 14, N'diệu', N'2.jpg', N'Basic', N'', N'', N'', N'', CAST(0x0000A7C50117BA5A AS DateTime), 0, 0, 1)
INSERT [dbo].[gb_KLAuthor] ([AuthorID], [UserID], [Name], [Avatar], [LevelAuthor], [LinkFacebook], [LinkTwitter], [LinkPinterest], [LinkInstagram], [JoinDate], [ArticleCount], [IsDel], [IsActive]) VALUES (8, 16, N'Nguyen Kinh Luan', N'13483242_1230900560254040_4830219852495004140_o.jpg', N'Basic', N'', N'', N'', N'', CAST(0x0000A7CA009E22B2 AS DateTime), 0, 0, 0)
SET IDENTITY_INSERT [dbo].[gb_KLAuthor] OFF
SET IDENTITY_INSERT [dbo].[gb_KLNewType] ON
INSERT [dbo].[gb_KLNewType] ([NewsTypeID], [Name], [Url], [ParentID], [IsDelected]) VALUES (1, N'Life', N'', -1, 0)
INSERT [dbo].[gb_KLNewType] ([NewsTypeID], [Name], [Url], [ParentID], [IsDelected]) VALUES (2, N'Education', N'', -1, 0)
INSERT [dbo].[gb_KLNewType] ([NewsTypeID], [Name], [Url], [ParentID], [IsDelected]) VALUES (3, N'Animals', N'', 1, 0)
SET IDENTITY_INSERT [dbo].[gb_KLNewType] OFF
SET IDENTITY_INSERT [dbo].[gb_KLNews] ON
INSERT [dbo].[gb_KLNews] ([KLNewID], [NewsID], [AuthorID], [ViewCount], [ShareCount], [CommentCount], [LikeCount], [ApprovedBy], [NewType], [Newlsevel], [Newstotalpoint], [Isdraft], [Isapproved]) VALUES (1, 25, 1, 0, 0, 0, 0, N'', 1, 1, 0, 0, 0)
INSERT [dbo].[gb_KLNews] ([KLNewID], [NewsID], [AuthorID], [ViewCount], [ShareCount], [CommentCount], [LikeCount], [ApprovedBy], [NewType], [Newlsevel], [Newstotalpoint], [Isdraft], [Isapproved]) VALUES (2, 26, 2, 0, 0, 0, 0, N'', 3, 1, 0, 0, 0)
INSERT [dbo].[gb_KLNews] ([KLNewID], [NewsID], [AuthorID], [ViewCount], [ShareCount], [CommentCount], [LikeCount], [ApprovedBy], [NewType], [Newlsevel], [Newstotalpoint], [Isdraft], [Isapproved]) VALUES (3, 27, 3, 0, 0, 0, 0, N'', 1, 1, 0, 0, 0)
INSERT [dbo].[gb_KLNews] ([KLNewID], [NewsID], [AuthorID], [ViewCount], [ShareCount], [CommentCount], [LikeCount], [ApprovedBy], [NewType], [Newlsevel], [Newstotalpoint], [Isdraft], [Isapproved]) VALUES (4, 28, 4, 0, 0, 0, 0, N'', 1, 1, 0, 0, 0)
INSERT [dbo].[gb_KLNews] ([KLNewID], [NewsID], [AuthorID], [ViewCount], [ShareCount], [CommentCount], [LikeCount], [ApprovedBy], [NewType], [Newlsevel], [Newstotalpoint], [Isdraft], [Isapproved]) VALUES (5, 29, 4, 0, 0, 0, 0, N'', 1, 1, 0, 0, 0)
INSERT [dbo].[gb_KLNews] ([KLNewID], [NewsID], [AuthorID], [ViewCount], [ShareCount], [CommentCount], [LikeCount], [ApprovedBy], [NewType], [Newlsevel], [Newstotalpoint], [Isdraft], [Isapproved]) VALUES (6, 30, 4, 0, 0, 0, 0, N'', 1, 1, 0, 0, 0)
INSERT [dbo].[gb_KLNews] ([KLNewID], [NewsID], [AuthorID], [ViewCount], [ShareCount], [CommentCount], [LikeCount], [ApprovedBy], [NewType], [Newlsevel], [Newstotalpoint], [Isdraft], [Isapproved]) VALUES (7, 31, 5, 0, 0, 0, 0, N'', 3, 1, 0, 0, 0)
SET IDENTITY_INSERT [dbo].[gb_KLNews] OFF
SET IDENTITY_INSERT [dbo].[gb_KLBook] ON
INSERT [dbo].[gb_KLBook] ([BookID], [AuthorID], [Title], [Image], [Url], [Description], [IsPublish], [IsDelected]) VALUES (8, 1, N'A Tale of Two Cities', N'1.jpg', N'https://en.wikipedia.org/wiki/A_Tale_of_Two_Cities', N'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Omnis aperiam ullam temporibus unde necessitatibus, optio consequatur dolore delectus totam aspernatur, sapiente obcaecati? Eum repudiandae quo molestiae illum, voluptates animi quidem non ea earum eius odio nihil aut delectus, aperiam, ab laboriosam atque sed necessitatibus eos modi ducimus. A sapiente exercitationem quia porro enim neque unde iusto dignissimos magnam ducimus, tempora obcaecati, necessitatibus dicta, doloremque.
<p> </p>
<p>Excepturi fuga beatae quaerat architecto ea nobis adipisci, nisi sequi ut pariatur inventore atque, enim dolorem praesentium! Eos excepturi nisi maiores dolores aspernatur quia, similique, doloribus odit quis dolorem, enim unde soluta ullam? Nulla, perferendis, maiores</p>', 1, 0)
INSERT [dbo].[gb_KLBook] ([BookID], [AuthorID], [Title], [Image], [Url], [Description], [IsPublish], [IsDelected]) VALUES (9, 3, N'A Tale of Two Cities', N'2.jpg', N'https://en.wikipedia.org/wiki/A_Tale_of_Two_Cities', N'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Omnis aperiam ullam temporibus unde necessitatibus, optio consequatur dolore delectus totam aspernatur, sapiente obcaecati? Eum repudiandae quo molestiae illum, voluptates animi quidem non ea earum eius odio nihil aut delectus, aperiam, ab laboriosam atque sed necessitatibus eos modi ducimus. A sapiente exercitationem quia porro enim neque unde iusto dignissimos magnam ducimus, tempora obcaecati, necessitatibus dicta, doloremque.', 1, 0)
INSERT [dbo].[gb_KLBook] ([BookID], [AuthorID], [Title], [Image], [Url], [Description], [IsPublish], [IsDelected]) VALUES (10, 3, N'Tư duy tích cực thay đổi cuộc sống', N'3.jpg', N'https://tiki.vn/tu-duy-tich-cuc-thay-doi-cuoc-song-p373111.html', N'Có lẽ tất cả chúng ta đều biết rằng những người vui vẻ, yêu đời, năng động thì làm gì cũng dễ thành công và đời sống của họ nói chung là hạnh phúc hơn những người thường xuyên cau có, gắt bẩn, stress... Đó là khác biệt giữa người tích cực và người tiêu cực.
Tư duy tích cực là loại tư duy nhìn về chính ta, về mọi người và về thế giới quanh ta với một sắc màu tích cực, đầy tình yêu, đầy nhân ái, đầy ý thức hướng thiện, năng động, cải tiến, làm cho tâm ta, tâm mọi người và thế giới của ta luôn thêm trong sáng và hạnh phúc.
Trong một thế giới có nhiều chiến tranh, bạo động và tội ác, luôn luôn có mầm tư duy tiêu cực tìm cách sinh sôi nẩy nở, len lỏi vào tận nơi sâu thẳm của trái tim con người. Cho nên nếu chúng ta không biết cách ngăn ngừa cỏ dại tiêu cực và nuôi dưỡng hoa màu tích cực, trái tim chúng ta có thể sẽ có lúc nghẹt thở vì cỏ dại.
Trái tim mỗi chúng ta là vườn hoa và chúng ta là người giữ vườn. Khoa học tư duy tích cực là khoa học về các phương pháp giữ vườn sao cho không bị cỏ dại lấn át và các bông hoa sắc mầu sẽ nẩy sinh tốt tươi, đẹp đẽ.', 1, 0)
INSERT [dbo].[gb_KLBook] ([BookID], [AuthorID], [Title], [Image], [Url], [Description], [IsPublish], [IsDelected]) VALUES (11, 1, N'Nghĩ Giàu, Làm Giàu Và Những Trải Nghiệm Ở Việt Nam', N'4.jpg', N'https://www.fahasa.com/nghi-giau-lam-giau-va-nhung-trai-nghiem-o-viet-nam.html#fhs-tab-extra-info', N'Nghĩ Giàu Làm Giàu đã làm thay đổi rất nhiều cuộc đời của những người đã đọc nó trở thành kỳ diệu. Với giáo sư Charles H. Cranford lại càng đặc biệt bởi ông đã có thời gian làm việc cùng Napoleon Hill, cho nên ông viết Nghĩ Giàu Làm Giàu – những trải nghiệm ở Việt Nam với vai trò một cộng sự của Napoleon Hill, cũng là người từng vấp ngã nhiều lần ...', 1, 0)
INSERT [dbo].[gb_KLBook] ([BookID], [AuthorID], [Title], [Image], [Url], [Description], [IsPublish], [IsDelected]) VALUES (12, 1, N'Cuộc Phiêu Lưu Kỳ Diệu Của Nils', N'5.jpg', N'http://diendanlequydon.com/viewtopic.php?t=395592', N'<p>Cậu bé Nils Holgersson hay nghịch phá và ngược đãi với các loài động vật, sau một lần chơi xấu với một gia thần đã bị vị thần này biến thành cậu bé Tí Hon. Tình cờ phải đi theo đàn ngỗng trời bay di trú đi dọc theo đất nước Thụy Điển, Nils đã học được những bài học về lòng dũng cảm, tình yêu thương, biết giữ chữ tín và dần trưởng thành, trở thành một người tốt.</p>
<br />
Tác phẩm đạt giải Nobel Văn học năm 1909. Đây không chỉ là một bài học địa lý về đất nước Thụy Điển, mà còn là một bài thơ dài về thiên nhiên, một thiên trường ca về con người và lao động, bài học đạo lý không chỉ cho trẻ con mà cả cho người lớn…được viết bằng sự trong sáng và giản dị của ngôn ngữ, vẻ đẹp của văn phong và trí tưởng tượng phong phú.', 1, 0)
INSERT [dbo].[gb_KLBook] ([BookID], [AuthorID], [Title], [Image], [Url], [Description], [IsPublish], [IsDelected]) VALUES (13, 1, N'Tư duy tích cực thay đổi cuộc sống', N'3.jpg', N'https://tiki.vn/tu-duy-tich-cuc-thay-doi-cuoc-song-p373111.html', N'Có lẽ tất cả chúng ta đều biết rằng những người vui vẻ, yêu đời, năng động thì làm gì cũng dễ thành công và đời sống của họ nói chung là hạnh phúc hơn những người thường xuyên cau có, gắt bẩn, stress... Đó là khác biệt giữa người tích cực và người tiêu cực.<br />
Tư duy tích cực là loại tư duy nhìn về chính ta, về mọi người và về thế giới quanh ta với một sắc màu tích cực, đầy tình yêu, đầy nhân ái, đầy ý thức hướng thiện, năng động, cải tiến, làm cho tâm ta, tâm mọi người và thế giới của ta luôn thêm trong sáng và hạnh phúc.<br />
Trong một thế giới có nhiều chiến tranh, bạo động và tội ác, luôn luôn có mầm tư duy tiêu cực tìm cách sinh sôi nẩy nở, len lỏi vào tận nơi sâu thẳm của trái tim con người. Cho nên nếu chúng ta không biết cách ngăn ngừa cỏ dại tiêu cực và nuôi dưỡng hoa màu tích cực, trái tim chúng ta có thể sẽ có lúc nghẹt thở vì cỏ dại.<br />
Trái tim mỗi chúng ta là vườn hoa và chúng ta là người giữ vườn. Khoa học tư duy tích cực là khoa học về các phương pháp giữ vườn sao cho không bị cỏ dại lấn át và các bông hoa sắc mầu sẽ nẩy sinh tốt tươi, đẹp đẽ.', 1, 0)
INSERT [dbo].[gb_KLBook] ([BookID], [AuthorID], [Title], [Image], [Url], [Description], [IsPublish], [IsDelected]) VALUES (14, 1, N'Nghĩ Giàu, Làm Giàu Và Những Trải Nghiệm Ở Việt Nam', N'4.jpg', N'https://www.fahasa.com/nghi-giau-lam-giau-va-nhung-trai-nghiem-o-viet-nam.html#fhs-tab-extra-info', N'Nghĩ Giàu Làm Giàu đã làm thay đổi rất nhiều cuộc đời của những người đã đọc nó trở thành kỳ diệu. Với giáo sư Charles H. Cranford lại càng đặc biệt bởi ông đã có thời gian làm việc cùng Napoleon Hill, cho nên ông viết Nghĩ Giàu Làm Giàu – những trải nghiệm ở Việt Nam với vai trò một cộng sự của Napoleon Hill, cũng là người từng vấp ngã nhiều lần ...', 1, 0)
INSERT [dbo].[gb_KLBook] ([BookID], [AuthorID], [Title], [Image], [Url], [Description], [IsPublish], [IsDelected]) VALUES (15, 1, N'A Tale of Two Cities', N'2.jpg', N'https://en.wikipedia.org/wiki/A_Tale_of_Two_Cities', N'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Omnis aperiam ullam temporibus unde necessitatibus, optio consequatur dolore delectus totam aspernatur, sapiente obcaecati? Eum repudiandae quo molestiae illum, voluptates animi quidem non ea earum eius odio nihil aut delectus, aperiam, ab laboriosam atque sed necessitatibus eos modi ducimus. A sapiente exercitationem quia porro enim neque unde iusto dignissimos magnam ducimus, tempora obcaecati, necessitatibus dicta, doloremque.', 1, 0)
SET IDENTITY_INSERT [dbo].[gb_KLBook] OFF
INSERT [dbo].[gb_KLGratitude] ([GuestID], [Name], [Avatar], [AuthorID], [CreateUtc], [Comment]) VALUES (1, N'Sang ', N'1.jpg', 1, CAST(0x0000A84700000000 AS DateTime), N'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Placeat cupiditate voluptates quibusdam quae explicabo pariatur tempore, aliquid ipsa.')
INSERT [dbo].[gb_KLGratitude] ([GuestID], [Name], [Avatar], [AuthorID], [CreateUtc], [Comment]) VALUES (2, N'Tri ', N'2.jpg', 1, CAST(0x0000A76B00000000 AS DateTime), N'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Placeat cupiditate voluptates quibusdam quae explicabo pariatur tempore, aliquid ipsa.')
INSERT [dbo].[gb_KLGratitude] ([GuestID], [Name], [Avatar], [AuthorID], [CreateUtc], [Comment]) VALUES (3, N'Khanh ', N'1.jpg', 1, CAST(0x0000A76B00000000 AS DateTime), N'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Placeat cupiditate voluptates quibusdam quae explicabo pariatur tempore, aliquid ipsa.')