· 4 years ago · Jun 17, 2021, 12:56 PM
1SELECT
2 count(*)
3FROM
4 `image_recognition_irmodelperformancelog`
5LEFT OUTER JOIN `Web_evaluation` ON(
6 `image_recognition_irmodelperformancelog`.`evaluation_id` = `Web_evaluation`.`id`
7 )
8LEFT OUTER JOIN `Web_person` ON(
9 `Web_evaluation`.`seller_id` = `Web_person`.`id`
10 )
11LEFT OUTER JOIN `Web_evaluationsandbox` ON(
12 `image_recognition_irmodelperformancelog`.`evaluation_sandbox_id` = `Web_evaluationsandbox`.`id`
13 )
14WHERE NOT
15 (
16 (
17 (
18 `Web_person`.`email` LIKE BINARY % trendlee.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY cosmin % AND `Web_person`.`email` IS NOT NULL
19 ) OR(
20 `Web_evaluationsandbox`.`email` LIKE BINARY % trendlee.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY cosmin % AND `Web_evaluationsandbox`.`email` IS NOT NULL
21 ) OR(
22 `Web_person`.`email` LIKE BINARY % rebag.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY cosmin % AND `Web_person`.`email` IS NOT NULL
23 ) OR(
24 `Web_evaluationsandbox`.`email` LIKE BINARY % rebag.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY cosmin % AND `Web_evaluationsandbox`.`email` IS NOT NULL
25 ) OR(
26 `Web_person`.`email` LIKE BINARY % gmail.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY talpah % AND `Web_person`.`email` IS NOT NULL
27 ) OR(
28 `Web_evaluationsandbox`.`email` LIKE BINARY % gmail.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY talpah % AND `Web_evaluationsandbox`.`email` IS NOT NULL
29 ) OR(
30 `Web_person`.`email` LIKE BINARY % trendlee.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY alin % AND `Web_person`.`email` IS NOT NULL
31 ) OR(
32 `Web_evaluationsandbox`.`email` LIKE BINARY % trendlee.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY alin % AND `Web_evaluationsandbox`.`email` IS NOT NULL
33 ) OR(
34 `Web_person`.`email` LIKE BINARY % rebag.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY alin % AND `Web_person`.`email` IS NOT NULL
35 ) OR(
36 `Web_evaluationsandbox`.`email` LIKE BINARY % rebag.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY alin % AND `Web_evaluationsandbox`.`email` IS NOT NULL
37 ) OR(
38 `Web_person`.`email` LIKE BINARY % gmail.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY ademinoiu % AND `Web_person`.`email` IS NOT NULL
39 ) OR(
40 `Web_evaluationsandbox`.`email` LIKE BINARY % gmail.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY ademinoiu % AND `Web_evaluationsandbox`.`email` IS NOT NULL
41 ) OR(
42 `Web_person`.`email` LIKE BINARY % trendlee.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY andrei % AND `Web_person`.`email` IS NOT NULL
43 ) OR(
44 `Web_evaluationsandbox`.`email` LIKE BINARY % trendlee.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY andrei % AND `Web_evaluationsandbox`.`email` IS NOT NULL
45 ) OR(
46 `Web_person`.`email` LIKE BINARY % rebag.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY andrei % AND `Web_person`.`email` IS NOT NULL
47 ) OR(
48 `Web_evaluationsandbox`.`email` LIKE BINARY % rebag.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY andrei % AND `Web_evaluationsandbox`.`email` IS NOT NULL
49 ) OR(
50 `Web_person`.`email` LIKE BINARY % trendlee.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY marian % AND `Web_person`.`email` IS NOT NULL
51 ) OR(
52 `Web_evaluationsandbox`.`email` LIKE BINARY % trendlee.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY marian % AND `Web_evaluationsandbox`.`email` IS NOT NULL
53 ) OR(
54 `Web_person`.`email` LIKE BINARY % rebag.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY marian % AND `Web_person`.`email` IS NOT NULL
55 ) OR(
56 `Web_evaluationsandbox`.`email` LIKE BINARY % rebag.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY marian % AND `Web_evaluationsandbox`.`email` IS NOT NULL
57 ) OR(
58 `Web_person`.`email` LIKE BINARY % trendlee.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY marius.marin % AND `Web_person`.`email` IS NOT NULL
59 ) OR(
60 `Web_evaluationsandbox`.`email` LIKE BINARY % trendlee.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY marius.marin % AND `Web_evaluationsandbox`.`email` IS NOT NULL
61 ) OR(
62 `Web_person`.`email` LIKE BINARY % rebag.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY marius.marin % AND `Web_person`.`email` IS NOT NULL
63 ) OR(
64 `Web_evaluationsandbox`.`email` LIKE BINARY % rebag.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY marius.marin % AND `Web_evaluationsandbox`.`email` IS NOT NULL
65 ) OR(
66 `Web_person`.`email` LIKE BINARY % trendlee.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY mihai % AND `Web_person`.`email` IS NOT NULL
67 ) OR(
68 `Web_evaluationsandbox`.`email` LIKE BINARY % trendlee.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY mihai % AND `Web_evaluationsandbox`.`email` IS NOT NULL
69 ) OR(
70 `Web_person`.`email` LIKE BINARY % rebag.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY mihai % AND `Web_person`.`email` IS NOT NULL
71 ) OR(
72 `Web_evaluationsandbox`.`email` LIKE BINARY % rebag.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY mihai % AND `Web_evaluationsandbox`.`email` IS NOT NULL
73 ) OR(
74 `Web_person`.`email` LIKE BINARY % rebag.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY razvan % AND `Web_person`.`email` IS NOT NULL
75 ) OR(
76 `Web_evaluationsandbox`.`email` LIKE BINARY % rebag.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY razvan % AND `Web_evaluationsandbox`.`email` IS NOT NULL
77 ) OR(
78 `Web_person`.`email` LIKE BINARY % digitallabs.ro AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY mihai % AND `Web_person`.`email` IS NOT NULL
79 ) OR(
80 `Web_evaluationsandbox`.`email` LIKE BINARY % digitallabs.ro AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY mihai % AND `Web_evaluationsandbox`.`email` IS NOT NULL
81 ) OR(
82 `Web_person`.`email` LIKE BINARY % trendlee.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY razvan % AND `Web_person`.`email` IS NOT NULL
83 ) OR(
84 `Web_evaluationsandbox`.`email` LIKE BINARY % trendlee.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY razvan % AND `Web_evaluationsandbox`.`email` IS NOT NULL
85 ) OR(
86 `Web_person`.`email` LIKE BINARY % trendlee.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY alexandru % AND `Web_person`.`email` IS NOT NULL
87 ) OR(
88 `Web_evaluationsandbox`.`email` LIKE BINARY % trendlee.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY alexandru % AND `Web_evaluationsandbox`.`email` IS NOT NULL
89 ) OR(
90 `Web_person`.`email` LIKE BINARY % rebag.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY alexandru % AND `Web_person`.`email` IS NOT NULL
91 ) OR(
92 `Web_evaluationsandbox`.`email` LIKE BINARY % rebag.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY alexandru % AND `Web_evaluationsandbox`.`email` IS NOT NULL
93 ) OR(
94 `Web_person`.`email` LIKE BINARY % rebag.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY rbgautotest % AND `Web_person`.`email` IS NOT NULL
95 ) OR(
96 `Web_evaluationsandbox`.`email` LIKE BINARY % rebag.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY rbgautotest % AND `Web_evaluationsandbox`.`email` IS NOT NULL
97 ) OR(
98 `Web_person`.`email` LIKE BINARY % rebag.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY valentin % AND `Web_person`.`email` IS NOT NULL
99 ) OR(
100 `Web_evaluationsandbox`.`email` LIKE BINARY % rebag.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY valentin % AND `Web_evaluationsandbox`.`email` IS NOT NULL
101 ) OR(
102 `Web_person`.`email` LIKE BINARY % rebag.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY daniel.muntean % AND `Web_person`.`email` IS NOT NULL
103 ) OR(
104 `Web_evaluationsandbox`.`email` LIKE BINARY % rebag.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY daniel.muntean % AND `Web_evaluationsandbox`.`email` IS NOT NULL
105 ) OR(
106 `Web_person`.`email` LIKE BINARY % rebag.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY andrei.urucu % AND `Web_person`.`email` IS NOT NULL
107 ) OR(
108 `Web_evaluationsandbox`.`email` LIKE BINARY % rebag.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY andrei.urucu % AND `Web_evaluationsandbox`.`email` IS NOT NULL
109 ) OR(
110 `Web_person`.`email` LIKE BINARY % rebag.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY mihai.ilie % AND `Web_person`.`email` IS NOT NULL
111 ) OR(
112 `Web_evaluationsandbox`.`email` LIKE BINARY % rebag.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY mihai.ilie % AND `Web_evaluationsandbox`.`email` IS NOT NULL
113 ) OR(
114 `Web_person`.`email` LIKE BINARY % rebag.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY marius % AND `Web_person`.`email` IS NOT NULL
115 ) OR(
116 `Web_evaluationsandbox`.`email` LIKE BINARY % rebag.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY marius % AND `Web_evaluationsandbox`.`email` IS NOT NULL
117 ) OR(
118 `Web_person`.`email` LIKE BINARY % rebag.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY mihai.dinuta % AND `Web_person`.`email` IS NOT NULL
119 ) OR(
120 `Web_evaluationsandbox`.`email` LIKE BINARY % rebag.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY mihai.dinuta % AND `Web_evaluationsandbox`.`email` IS NOT NULL
121 ) OR(
122 `Web_person`.`email` LIKE BINARY % rebag.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY mihai.toma % AND `Web_person`.`email` IS NOT NULL
123 ) OR(
124 `Web_evaluationsandbox`.`email` LIKE BINARY % rebag.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY mihai.toma % AND `Web_evaluationsandbox`.`email` IS NOT NULL
125 ) OR(
126 `Web_person`.`email` LIKE BINARY % rebag.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY valentin.pricop % AND `Web_person`.`email` IS NOT NULL
127 ) OR(
128 `Web_evaluationsandbox`.`email` LIKE BINARY % rebag.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY valentin.pricop % AND `Web_evaluationsandbox`.`email` IS NOT NULL
129 ) OR(
130 `Web_person`.`email` LIKE BINARY % rebag.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY cristian % AND `Web_person`.`email` IS NOT NULL
131 ) OR(
132 `Web_evaluationsandbox`.`email` LIKE BINARY % rebag.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY cristian % AND `Web_evaluationsandbox`.`email` IS NOT NULL
133 ) OR(
134 `Web_person`.`email` LIKE BINARY % rebag.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY dan % AND `Web_person`.`email` IS NOT NULL
135 ) OR(
136 `Web_evaluationsandbox`.`email` LIKE BINARY % rebag.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY dan % AND `Web_evaluationsandbox`.`email` IS NOT NULL
137 ) OR(
138 `Web_person`.`email` LIKE BINARY % rebag.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY stefan % AND `Web_person`.`email` IS NOT NULL
139 ) OR(
140 `Web_evaluationsandbox`.`email` LIKE BINARY % rebag.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY stefan % AND `Web_evaluationsandbox`.`email` IS NOT NULL
141 ) OR(
142 `Web_person`.`email` LIKE BINARY % rebag.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY jay % AND `Web_person`.`email` IS NOT NULL
143 ) OR(
144 `Web_evaluationsandbox`.`email` LIKE BINARY % rebag.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY jay % AND `Web_evaluationsandbox`.`email` IS NOT NULL
145 ) OR(
146 `Web_person`.`email` LIKE BINARY % rebag.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY olivier % AND `Web_person`.`email` IS NOT NULL
147 ) OR(
148 `Web_evaluationsandbox`.`email` LIKE BINARY % rebag.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY olivier % AND `Web_evaluationsandbox`.`email` IS NOT NULL
149 ) OR(
150 `Web_person`.`email` LIKE BINARY % rebag.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY jonathan.bernstein % AND `Web_person`.`email` IS NOT NULL
151 ) OR(
152 `Web_evaluationsandbox`.`email` LIKE BINARY % rebag.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY jonathan.bernstein % AND `Web_evaluationsandbox`.`email` IS NOT NULL
153 ) OR(
154 `Web_person`.`email` LIKE BINARY % rebag.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY gabriel.lupu % AND `Web_person`.`email` IS NOT NULL
155 ) OR(
156 `Web_evaluationsandbox`.`email` LIKE BINARY % rebag.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY gabriel.lupu % AND `Web_evaluationsandbox`.`email` IS NOT NULL
157 ) OR(
158 `Web_person`.`email` LIKE BINARY % gmail.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY oliv.hepbis % AND `Web_person`.`email` IS NOT NULL
159 ) OR(
160 `Web_evaluationsandbox`.`email` LIKE BINARY % gmail.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY oliv.hepbis % AND `Web_evaluationsandbox`.`email` IS NOT NULL
161 ) OR(
162 `Web_person`.`email` LIKE BINARY % gmail.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY applez12345map % AND `Web_person`.`email` IS NOT NULL
163 ) OR(
164 `Web_evaluationsandbox`.`email` LIKE BINARY % gmail.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY applez12345map % AND `Web_evaluationsandbox`.`email` IS NOT NULL
165 ) OR(
166 `Web_person`.`email` LIKE BINARY % gmail.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY charles.gorra % AND `Web_person`.`email` IS NOT NULL
167 ) OR(
168 `Web_evaluationsandbox`.`email` LIKE BINARY % gmail.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY charles.gorra % AND `Web_evaluationsandbox`.`email` IS NOT NULL
169 ) OR(
170 `Web_person`.`email` LIKE BINARY % gmail.com AND `Web_person`.`email` IS NOT NULL AND `Web_person`.`email` LIKE BINARY rachellebalagtas % AND `Web_person`.`email` IS NOT NULL
171 ) OR(
172 `Web_evaluationsandbox`.`email` LIKE BINARY % gmail.com AND `Web_evaluationsandbox`.`email` IS NOT NULL AND `Web_evaluationsandbox`.`email` LIKE BINARY rachellebalagtas % AND `Web_evaluationsandbox`.`email` IS NOT NULL
173 )
174 )
175 )