QKNWbTaY

1USE master
2GO 
3
4IF  EXISTS (
5	SELECT name 
6		FROM sys.databases 
7		WHERE name = N'UlianarKvashnina2'
8)
9DROP DATABASE [UlianarKvashnina2]
10GO
11
12CREATE DATABASE [UlianarKvashnina2]
13GO
14
15USE [UlianarKvashnina2]
16GO
17
18IF OBJECT_ID('[UlianarKvashnina2].CodRegion', 'U') IS NOT NULL 
19DROP TABLE [UlianarKvashnina2].CodRegion 
20GO 
21
22IF OBJECT_ID('[UlianarKvashnina2].CodOnCar', 'U') IS NOT NULL 
23DROP TABLE [UlianarKvashnina2].CodOnCar 
24GO 
25
26IF OBJECT_ID('[UlianarKvashnina2].Posts', 'U') IS NOT NULL 
27DROP TABLE [UlianarKvashnina2].Posts 
28GO 
29
30IF OBJECT_ID('[UlianarKvashnina2].Driver', 'U') IS NOT NULL 
31DROP TABLE [UlianarKvashnina2].Driver 
32GO 
33
34IF OBJECT_ID('[UlianarKvashnina2].Violation', 'U') IS NOT NULL 
35DROP TABLE [UlianarKvashnina2].Violation 
36GO 
37
38IF OBJECT_ID('[UlianarKvashnina2].Registration', 'U') IS NOT NULL 
39DROP TABLE [UlianarKvashnina2].Registration 
40GO 
41
42CREATE TABLE CodRegion 
43( 
44ID_cod_region int NOT NULL, 
45Name_region char(40) NULL, 
46CONSTRAINT PK_key_region PRIMARY KEY (ID_cod_region) 
47) 
48GO 
49
50INSERT INTO CodRegion 
51(ID_cod_region, Name_region) 
52VALUES 
53(101, N'Республика Адыгея'), 
54(202, N'Республика Башкортостан'), 
55(166, N'Свердловская область'), 
56(66, N'Свердловская область'), 
57(174, N'Челябинская область'), 
58(150, N'Московская область'), 
59(190, N'Московская область') 
60GO 
61
62CREATE TABLE CodOnCar 
63( 
64ID_cod_car int NOT NULL, 
65Cod_region nvarchar(3) NOT NULL, 
66CONSTRAINT FK_key_car FOREIGN KEY (ID_cod_car) 
67REFERENCES CodRegion(ID_cod_region), 
68CONSTRAINT ckeck CHECK ( 
69SUBSTRING(Cod_region, 1, 1) = 7 OR 
70SUBSTRING(Cod_region, 1, 1) = 2 OR 
71SUBSTRING(Cod_region, 1, 1) = 1 OR len(Cod_region) != 3 
72) 
73) 
74GO 
75
76INSERT INTO CodOnCar 
77(ID_cod_car, Cod_region) 
78VALUES 
79(101, N'101'), 
80(202, N'202'), 
81(166, N'166'), 
82(174, N'174'), 
83(150, N'150'), 
84(190, N'190'), 
85(66, N'66') 
86GO 
87
88CREATE TABLE Posts 
89( 
90Id_Post int NOT NULL, 
91Name char(40) NOT NULL 
92CONSTRAINT PK_key_posts PRIMARY KEY (Id_Post) 
93) 
94
95INSERT INTO Posts 
96(Id_Post, Name) 
97VALUES 
98(1, N'Пост Северный'), 
99(2, N'Пост Западный'), 
100(3, N'Пост Восточный'), 
101(4, N'Пост Южный'), 
102(5, N'Пост Юго-Западный') 
103GO
104
105CREATE TABLE Driver 
106( 
107Id_driver int NOT NULL, 
108LastName nvarchar(40) NOT NULL 
109CONSTRAINT PK_key_driver PRIMARY KEY (Id_driver) 
110) 
111
112INSERT INTO Driver 
113(Id_driver, LastName) 
114VALUES 
115(1, 'Призрак'), 
116(2, 'Последний'), 
117(3, 'Иванов'), 
118(4, 'Первый'), 
119(5, 'Гонщик') 
120GO 
121
122CREATE TABLE Registration 
123( 
124ID_registration int NOT NULL, 
125ID_post int NOT NULL, 
126Model_car nvarchar(40) NOT NULL, 
127Color_car nvarchar(40) NOT NULL, 
128Number_car nvarchar(6) NOT NULL, 
129Cod_region_car int NOT NULL, 
130ID_driver int NOT NULL, 
131Time_registration time NOT NULL, 
132Direction nvarchar(5) NOT NULL 
133CONSTRAINT PK_registration PRIMARY KEY (ID_registration), 
134
135CONSTRAINT FK_post FOREIGN KEY (ID_post) 
136REFERENCES Posts (ID_Post), 
137
138CONSTRAINT FK_region_code FOREIGN KEY (Cod_region_car) 
139REFERENCES CodRegion(ID_cod_region), 
140
141CONSTRAINT FK_driver FOREIGN KEY (ID_driver) 
142REFERENCES Driver(Id_driver), 
143
144CONSTRAINT check_Number_car CHECK (Number_car LIKE 
145'[MМКKЕEНHХXВBАAРPОOСCТT][0-9][0-9][0-9][MМКKЕEНHХXВBАAРPОOСCТT][MМКKЕEНHХXВBАAРPОOСCТT]'), 
146CONSTRAINT check_direction CHECK (Direction LIKE '[Вв][ъы]езд') 
147) 
148GO 
149
150INSERT INTO Registration 
151(ID_registration, ID_post, Model_car, Color_car, Number_car, Cod_region_car, ID_driver, Time_registration, Direction) 
152VALUES 
153(1, 1, N'Audi', N'Красный', N'Р030ВО', 101, 1, '09:00:00', 'Въезд'), 
154(2, 4, N'Audi', N'Красный', N'Р030ВО', 101, 1, '10:00:00', 'Выезд'), 
155(3, 2, N'УАЗ', N'Чёрный', N'К001MМ', 202, 2, '11:00:00', 'Въезд'), 
156(4, 4, N'УАЗ', N'Чёрный', N'К001MМ', 202, 2, '12:00:00', 'Выезд'),  
157(11, 4, N'Ford', N'Зелёный', N'A283ОМ', 190, 2, '13:00:00', 'Въезд'), 
158(12, 3, N'Ford', N'Зелёный', N'A283ОМ', 190, 2, '14:00:00', 'Выезд'),  
159(5, 4, N'ЛАДА', N'Золотой', N'T356ОЕ', 166, 3, '14:00:00', 'Выезд'), 
160(6, 5, N'ЛАДА', N'Золотой', N'T356ОЕ', 166, 3, '15:00:00', 'Въезд'),  
161(7, 5, N'Нива', N'Серый', N'К923EТ', 174, 3, '16:00:00', 'Въезд'), 
162(8, 5, N'Нива', N'Серый', N'К923EТ', 174, 3, '18:00:00', 'Выезд'), 
163(9, 3, N'Toyota', N'Синий', N'Р765ОТ', 150, 4, '06:00:00', 'Въезд'), 
164(10, 3, N'Toyota', N'Синий', N'Р765ОТ', 150, 4, '23:30:00', 'Выезд'),  
165(13, 5, N'Chevrolet', N'Бежевый', N'К321ОТ', 150, 5, '09:00:00', 'Въезд'), 
166(14, 5, N'Chevrolet', N'Бежевый', N'К321ОТ', 150, 5, '10:00:00', 'Выезд'), 
167(15, 1, N'ВАЗ', N'Бежевый', N'E321EТ', 166, 5, '09:00:00', 'Въезд'), 
168(16, 2, N'ВАЗ', N'Бежевый', N'E321EТ', 166, 5, '10:00:00', 'Выезд') 
169GO
170
171--транзитные(въехал через один выехал через другой и регион не екатеринбург) 
172SELECT posts.Name AS 'Пост', this.Color_car as 'Цвет авто', this.Model_car AS 'Модель авто', 
173this.Number_car AS 'Номер', Name_region AS 'Регион', LastName AS 'Водитель' 
174FROM Registration this 
175INNER JOIN posts ON posts.ID_post = this.ID_post 
176INNER JOIN driver ON driver.ID_driver = this.ID_driver 
177INNER JOIN CodRegion ON CodRegion.ID_cod_region = this.Cod_region_car , 
178Registration that 
179WHERE this.Number_car = that.Number_car AND this.Direction = 'Выезд' AND that.Direction = 'Въезд' AND 
180this.Time_registration > that.Time_registration AND 
181this.Cod_region_car <> 166 AND this.Cod_region_car <> 66 AND this.ID_post <> that.ID_post 
182go
183
184--иногородние(въехали и выехали через 1 пост):
185
186SELECT posts.Name AS 'Пост', this.Color_car as 'Цвет авто', this.Model_car AS 'Модель авто', 
187this.Number_car AS 'Номер', Name_region AS 'Регион', LastName AS 'Водитель' 
188FROM Registration this 
189INNER JOIN posts ON posts.ID_post = this.ID_post 
190INNER JOIN driver ON driver.ID_driver = this.ID_driver 
191INNER JOIN CodRegion ON CodRegion.ID_cod_region = this.Cod_region_car , 
192Registration that 
193WHERE this.Number_car = that.Number_car AND this.Direction = 'Въезд' AND that.Direction = 'Выезд' AND 
194this.Time_registration < that.Time_registration AND 
195this.ID_post = that.ID_post 
196go
197
198--местные(выехавшие и вернувшиеся в город и имеющие номера данного региона): 
199
200SELECT posts.Name AS 'Пост', this.Color_car as 'Цвет авто', this.Model_car AS 'Модель авто', 
201this.Number_car AS 'Номер', Name_region AS 'Регион', LastName AS 'Водитель' 
202FROM Registration this 
203INNER JOIN posts ON posts.ID_post = this.ID_post 
204INNER JOIN driver ON driver.ID_driver = this.ID_driver 
205INNER JOIN CodRegion ON CodRegion.ID_cod_region = this.Cod_region_car , 
206Registration that 
207WHERE this.Number_car = that.Number_car AND this.Direction = 'Въезд' AND that.Direction = 'Выезд' AND 
208this.Time_registration > that.Time_registration AND Name_region = 'Свердловская область'
209 
210--прочие(не попавшие в вышеперечисленные) 
211
212SELECT posts.Name AS 'Пост', this.Color_car as 'Цвет авто', this.Model_car AS 'Модель авто', 
213this.Number_car AS 'Номер', Name_region AS 'Регион', LastName AS 'Водитель' 
214FROM Registration this 
215INNER JOIN posts ON posts.ID_post = this.ID_post 
216INNER JOIN driver ON driver.ID_driver = this.ID_driver 
217INNER JOIN CodRegion ON CodRegion.ID_cod_region = this.Cod_region_car, 
218Registration that 
219where this.Number_car = that.Number_car and this.Time_registration > that.Time_registration 
220except 
221SELECT posts.Name AS 'Пост', this.Color_car as 'Цвет авто', this.Model_car AS 'Модель авто', 
222this.Number_car AS 'Номер', Name_region AS 'Регион', LastName AS 'Водитель' 
223FROM Registration this 
224INNER JOIN posts ON posts.ID_post = this.ID_post 
225INNER JOIN driver ON
226driver.ID_driver = this.ID_driver 
227INNER JOIN CodRegion ON CodRegion.ID_cod_region = this.Cod_region_car , 
228Registration that 
229WHERE 
230this.Number_car = that.Number_car AND this.Direction = 'Въезд' AND that.Direction = 'Выезд' AND 
231this.Time_registration > that.Time_registration AND Name_region = 'Свердловская область' 
232or 
233(this.Number_car = that.Number_car AND this.Direction = 'Въезд' AND that.Direction = 'Выезд' AND 
234this.Time_registration < that.Time_registration AND 
235this.ID_post = that.ID_post) 
236or 
237this.Number_car = that.Number_car AND this.Direction = 'Выезд' AND that.Direction = 'Въезд' AND 
238this.Time_registration > that.Time_registration AND 
239this.Cod_region_car <> 166 AND this.Cod_region_car <> 66 AND this.ID_post <> that.ID_post
240
241USE master 
242GO
243
244IF EXISTS ( 
245SELECT name 
246FROM sys.databases 
247WHERE name = N'UlianarKvashnina2' 
248) 
249ALTER DATABASE [UlianarKvashnina2] set single_user with rollback immediate 
250GO 
251
252IF EXISTS ( 
253SELECT name 
254FROM sys.databases 
255WHERE name = N'UlianarKvashnina2' 
256) 
257DROP DATABASE [UlianarKvashnina2] 
258GO 
259
260CREATE DATABASE [UlianarKvashnina2] 
261GO 
262
263USE [UlianarKvashnina2] 
264GO 
265
266IF OBJECT_ID('[UlianarKvashnina2].CodRegion', 'U') IS NOT NULL 
267DROP TABLE [UlianarKvashnina2].CodRegion 
268GO 
269
270IF OBJECT_ID('[UlianarKvashnina2].CodOnCar', 'U') IS NOT NULL 
271DROP TABLE [UlianarKvashnina2].CodOnCar 
272GO 
273
274IF OBJECT_ID('[UlianarKvashnina2].Posts', 'U') IS NOT NULL 
275DROP TABLE [UlianarKvashnina2].Posts 
276GO 
277
278IF OBJECT_ID('[UlianarKvashnina2].Driver', 'U') IS NOT NULL 
279DROP TABLE [UlianarKvashnina2].Driver 
280GO 
281
282IF OBJECT_ID('[UlianarKvashnina2].Violation', 'U') IS NOT NULL 
283DROP TABLE [UlianarKvashnina2].Violation 
284GO 
285
286IF OBJECT_ID('[UlianarKvashnina2].Registration', 'U') IS NOT NULL 
287DROP TABLE [UlianarKvashnina2].Registration 
288GO 
289
290CREATE TABLE CodRegion 
291( 
292ID_cod_region int NOT NULL, 
293Name_region char(40) NULL, 
294CONSTRAINT PK_key_region PRIMARY KEY (ID_cod_region) 
295) 
296GO 
297
298INSERT INTO CodRegion 
299(ID_cod_region, Name_region) 
300VALUES 
301(101, N'Республика Адыгея'), 
302(202, N'Республика Башкортостан'), 
303(166, N'Свердловская область'), 
304(66, N'Свердловская область'), 
305(174, N'Челябинская область'), 
306(150, N'Московская область'), 
307(190, N'Московская область') 
308GO 
309
310CREATE TABLE CodOnCar 
311( 
312ID_cod_car int NOT NULL, 
313Cod_region nvarchar(3) NOT NULL, 
314CONSTRAINT FK_key_car FOREIGN KEY (ID_cod_car) 
315REFERENCES CodRegion(ID_cod_region) 
316) 
317GO 
318
319CREATE TRIGGER check_CodOnCar 
320ON CodOnCar 
321AFTER INSERT 
322AS 
323IF EXISTS( 
324SELECT * FROM CodOnCar 
325WHERE SUBSTRING(Cod_region, 1, 1) != 7 AND 
326SUBSTRING(Cod_region, 1, 1) != 2 AND 
327SUBSTRING(Cod_region, 1, 1) != 1 and len(Cod_region) = 3 
328) 
329BEGIN 
330RAISERROR ('Регион введен неверно!', 1, 1) 
331ROLLBACK TRANSACTION; 
332RETURN 
333END 
334GO 
335
336INSERT INTO CodOnCar 
337(ID_cod_car, Cod_region) 
338VALUES 
339(101, N'101'), 
340(202, N'202'), 
341(166, N'166'), 
342(174, N'174'), 
343(150, N'150'), 
344(190, N'190'), 
345(66, N'66') 
346GO 
347
348CREATE TABLE Posts 
349( 
350Id_Post int NOT NULL, 
351Name char(40) NOT NULL 
352CONSTRAINT PK_key_posts PRIMARY KEY (Id_Post) 
353) 
354
355INSERT INTO Posts 
356(Id_Post, Name) 
357VALUES 
358(1, N'Пост Северный'), 
359(2, N'Пост Восточный'), 
360(3, N'Пост Западный'), 
361(4, N'Пост Южный'), 
362(5, N'Пост Юго-Западный') 
363GO 
364
365
366CREATE TABLE Driver 
367( 
368Id_driver int NOT NULL, 
369LastName nvarchar(40) NOT NULL 
370CONSTRAINT PK_key_driver PRIMARY KEY (Id_driver) 
371) 
372
373INSERT INTO Driver 
374(Id_driver, LastName) 
375VALUES 
376(1, 'Призрак'), 
377(2, 'Последний'), 
378(3, 'Иванов'), 
379(4, 'Первый'), 
380(5, 'Гонщик') 
381GO 
382
383CREATE TABLE Registration 
384( 
385ID_registration int NOT NULL, 
386ID_post int NOT NULL, 
387Model_car nvarchar(40) NOT NULL, 
388Color_car nvarchar(40) NOT NULL, 
389Number_car nvarchar(6) NOT NULL, 
390Cod_region_car int NOT NULL, 
391ID_driver int NOT NULL, 
392Time_registration time NOT NULL, 
393Direction nvarchar(5) NOT NULL 
394CONSTRAINT PK_registration PRIMARY KEY (ID_registration), 
395
396CONSTRAINT FK_post FOREIGN KEY (ID_post) 
397REFERENCES Posts (ID_Post), 
398
399CONSTRAINT FK_region_code FOREIGN KEY (Cod_region_car) 
400REFERENCES CodRegion(ID_cod_region), 
401
402CONSTRAINT FK_driver FOREIGN KEY (ID_driver) 
403REFERENCES Driver(Id_driver) 
404) 
405GO 
406
407CREATE TRIGGER check_number_car 
408ON Registration 
409AFTER INSERT 
410AS 
411IF EXISTS( 
412SELECT * FROM Registration 
413WHERE Number_car NOT LIKE '[MМКKЕEНHХXВBАAРPОOСCТT][0-9][0-9][0-9][MМКKЕEНHХXВBАAРPОOСCТT][MМКKЕEНHХXВBАAРPОOСCТT]' 
414) 
415BEGIN 
416RAISERROR ('Неверный номер', 1, 1) 
417ROLLBACK TRANSACTION; 
418RETURN 
419END 
420GO 
421
422CREATE TRIGGER check_Direction 
423ON Registration 
424AFTER INSERT 
425AS 
426IF EXISTS( 
427SELECT * FROM Registration 
428WHERE Direction NOT LIKE '[Вв][ъы]езд' 
429) 
430BEGIN 
431RAISERROR ('Неверное направление', 1, 1)
432ROLLBACK TRANSACTION; 
433RETURN 
434END 
435GO 
436
437INSERT INTO Registration 
438(ID_registration, ID_post, Model_car, Color_car, Number_car, Cod_region_car, ID_driver, Time_registration, Direction) 
439VALUES 
440(1, 1, N'Audi', N'Красный', N'Р030ВО', 101, 1, '09:00:00', 'Въезд'), 
441(2, 4, N'Audi', N'Красный', N'Р030ВО', 101, 1, '10:00:00', 'Выезд'), 
442(3, 2, N'УАЗ', N'Чёрный', N'К001MМ', 202, 2, '11:00:00', 'Въезд'), 
443(4, 4, N'УАЗ', N'Чёрный', N'К001MМ', 202, 2, '12:00:00', 'Выезд'), 
444(11, 4, N'Ford', N'Зелёный', N'A283ОМ', 190, 2, '13:00:00', 'Въезд'), 
445(12, 3, N'Ford', N'Зелёный', N'A283ОМ', 190, 2, '14:00:00', 'Выезд'), 
446(5, 4, N'ЛАДА', N'Золотой', N'T356ОЕ', 166, 3, '14:00:00', 'Выезд'), 
447(6, 5, N'ЛАДА', N'Золотой', N'T356ОЕ', 166, 3, '15:00:00', 'Въезд'), 
448(7, 5, N'Нива', N'Серый', N'К923EТ', 174, 3, '16:00:00', 'Въезд'), 
449(8, 5, N'Нива', N'Серый', N'К923EТ', 174, 3, '18:00:00', 'Выезд'),  
450(9, 3, N'Toyota', N'Синий', N'Р765ОТ', 150, 4, '06:00:00', 'Въезд'), 
451(10, 3, N'Toyota', N'Синий', N'Р765ОТ', 150, 4, '23:30:00', 'Выезд'), 
452(13, 5, N'Chevrolet', N'Бежевый', N'К321ОТ', 150, 5, '09:00:00', 'Въезд'), 
453(14, 5, N'Chevrolet', N'Бежевый', N'К321ОТ', 150, 5, '10:00:00', 'Выезд'), 
454(15, 1, N'ВАЗ', N'Бежевый', N'E321EТ', 166, 5, '09:00:00', 'Въезд'), 
455(16, 2, N'ВАЗ', N'Бежевый', N'E321EТ', 166, 5, '10:00:00', 'Выезд') 
456GO 
457--транзитные(въехал через один выехал через другой и регион не екатеринбург)
458
459SELECT posts.Name AS 'Пост', this.Color_car as 'Цвет авто', this.Model_car AS 'Модель авто', 
460this.Number_car AS 'Номер', Name_region AS 'Регион', LastName AS 'Водитель' 
461FROM Registration this 
462INNER JOIN posts ON posts.ID_post = this.ID_post 
463INNER JOIN driver ON driver.ID_driver = this.ID_driver 
464INNER JOIN CodRegion ON CodRegion.ID_cod_region = this.Cod_region_car , 
465Registration that 
466WHERE this.Number_car = that.Number_car AND this.Direction = 'Выезд' AND that.Direction = 'Въезд' AND 
467this.Time_registration > that.Time_registration AND 
468this.Cod_region_car <> 166 AND this.Cod_region_car <> 66 AND this.ID_post <> that.ID_post 
469go 
470--иногородние(въехали и выехали через 1 пост):
471
472SELECT posts.Name AS 'Пост', this.Color_car as 'Цвет авто', this.Model_car AS 'Модель авто', 
473this.Number_car AS 'Номер', Name_region AS 'Регион', LastName AS 'Водитель' 
474FROM Registration this 
475INNER JOIN posts ON posts.ID_post = this.ID_post 
476INNER JOIN driver ON driver.ID_driver = this.ID_driver 
477INNER JOIN CodRegion ON CodRegion.ID_cod_region = this.Cod_region_car , 
478Registration that 
479WHERE this.Number_car = that.Number_car AND this.Direction = 'Въезд' AND that.Direction = 'Выезд' AND 
480this.Time_registration < that.Time_registration AND 
481this.ID_post = that.ID_post 
482go
483
484--местные(выехавшие и вернувшиеся в город и имеющие номера данного региона):
485
486SELECT posts.Name AS 'Пост', this.Color_car as 'Цвет авто', this.Model_car AS 'Модель авто', 
487this.Number_car AS 'Номер', Name_region AS 'Регион', LastName AS 'Водитель' 
488FROM Registration this 
489INNER JOIN posts ON posts.ID_post = this.ID_post 
490INNER JOIN driver ON driver.ID_driver = this.ID_driver 
491INNER JOIN CodRegion ON CodRegion.ID_cod_region = this.Cod_region_car , 
492Registration that 
493WHERE this.Number_car = that.Number_car AND this.Direction = 'Въезд' AND that.Direction = 'Выезд' AND 
494this.Time_registration > that.Time_registration AND Name_region = 'Свердловская область' 
495--прочие(не попавшие в вышеперечисленные) 
496
497SELECT posts.Name AS 'Пост', this.Color_car as 'Цвет авто', this.Model_car AS 'Модель авто', 
498this.Number_car AS 'Номер', Name_region AS 'Регион', LastName AS 'Водитель' 
499FROM Registration this 
500INNER JOIN posts ON posts.ID_post =
501this.ID_post 
502INNER JOIN driver ON driver.ID_driver = this.ID_driver 
503INNER JOIN CodRegion ON CodRegion.ID_cod_region = this.Cod_region_car, 
504Registration that 
505where this.Number_car = that.Number_car and this.Time_registration > that.Time_registration 
506except 
507SELECT posts.Name AS 'Пост', this.Color_car as 'Цвет авто', this.Model_car AS 'Модель авто', 
508this.Number_car AS 'Номер', Name_region AS 'Регион', LastName AS 'Водитель' 
509FROM Registration this 
510INNER JOIN posts ON posts.ID_post = this.ID_post 
511INNER JOIN driver ON driver.ID_driver = this.ID_driver 
512INNER JOIN CodRegion ON CodRegion.ID_cod_region = this.Cod_region_car , 
513Registration that 
514WHERE 
515this.Number_car = that.Number_car AND this.Direction = 'Въезд' AND that.Direction = 'Выезд' AND 
516this.Time_registration > that.Time_registration AND Name_region = 'Свердловская область' 
517or 
518(this.Number_car = that.Number_car AND this.Direction = 'Въезд' AND that.Direction = 'Выезд' AND 
519this.Time_registration < that.Time_registration AND 
520this.ID_post = that.ID_post) 
521or 
522this.Number_car = that.Number_car AND this.Direction = 'Выезд' AND that.Direction = 'Въезд' AND 
523this.Time_registration > that.Time_registration AND 
524this.Cod_region_car <> 166 AND this.Cod_region_car <> 66 AND this.ID_post <> that.ID_post