Lines Matching refs:by

50 first_value(visit_time) over (partition by visit_id order by visit_time asc) as start_time,
51 first_value(visit_time) over (partition by visit_id order by visit_time desc) as end_time,
52 first_value(eref_key) over (partition by visit_id order by visit_time asc) as landing_eref_key,
53 first_value(iref_key) over (partition by visit_id order by visit_time asc) as landing_iref_key,
54 first_value(page_id) over (partition by visit_id order by visit_time asc) as landing_page_id,
55 first_value(page_type) over (partition by visit_id order by visit_time asc) as landing_page_type,
56 first_value(eref_key) over (partition by visit_id order by visit_time desc) as exit_eref_key,
57 first_value(iref_key) over (partition by visit_id order by visit_time desc) as exit_iref_key,
58 first_value(page_id) over (partition by visit_id order by visit_time desc) as exit_page_id,
59 first_value(page_type) over (partition by visit_id order by visit_time desc) as exit_page_type,
60 count(*) over (partition by visit_id ) as pvs,
69 first_value(visit_time) over (partition by visit_id order by visit_time asc) as start_time,
70 first_value(visit_time) over (partition by visit_id order by visit_time desc) as end_time,
71 first_value(eref_key) over (partition by visit_id order by visit_time asc) as landing_eref_key,
72 first_value(iref_key) over (partition by visit_id order by visit_time asc) as landing_iref_key,
73 first_value(page_id) over (partition by visit_id order by visit_time asc) as landing_page_id,
74 first_value(page_type) over (partition by visit_id order by visit_time asc) as landing_page_type,
75 first_value(eref_key) over (partition by visit_id order by visit_time desc) as exit_eref_key,
76 first_value(iref_key) over (partition by visit_id order by visit_time desc) as exit_iref_key,
77 first_value(page_id) over (partition by visit_id order by visit_time desc) as exit_page_id,
78 first_value(page_type) over (partition by visit_id order by visit_time desc) as exit_page_type,
79 count(*) over (partition by visit_id ) as pvs,
88 first_value(visit_time) over (partition by visit_id order by visit_time asc) as start_time,
89 first_value(visit_time) over (partition by visit_id order by visit_time desc) as end_time,
90 first_value(eref_key) over (partition by visit_id order by visit_time asc) as landing_eref_key,
91 first_value(iref_key) over (partition by visit_id order by visit_time asc) as landing_iref_key,
92 first_value(page_id) over (partition by visit_id order by visit_time asc) as landing_page_id,
93 first_value(page_type) over (partition by visit_id order by visit_time asc) as landing_page_type,
94 first_value(eref_key) over (partition by visit_id order by visit_time desc) as exit_eref_key,
95 first_value(iref_key) over (partition by visit_id order by visit_time desc) as exit_iref_key,
96 first_value(page_id) over (partition by visit_id order by visit_time desc) as exit_page_id,
97 first_value(page_type) over (partition by visit_id order by visit_time desc) as exit_page_type,
98 count(*) over (partition by visit_id ) as pvs,
107 first_value(visit_time) over (partition by visit_id order by visit_time asc) as start_time,
108 first_value(visit_time) over (partition by visit_id order by visit_time desc) as end_time,
109 first_value(eref_key) over (partition by visit_id order by visit_time asc) as landing_eref_key,
110 first_value(iref_key) over (partition by visit_id order by visit_time asc) as landing_iref_key,
111 first_value(page_id) over (partition by visit_id order by visit_time asc) as landing_page_id,
112 first_value(page_type) over (partition by visit_id order by visit_time asc) as landing_page_type,
113 first_value(eref_key) over (partition by visit_id order by visit_time desc) as exit_eref_key,
114 first_value(iref_key) over (partition by visit_id order by visit_time desc) as exit_iref_key,
115 first_value(page_id) over (partition by visit_id order by visit_time desc) as exit_page_id,
116 first_value(page_type) over (partition by visit_id order by visit_time desc) as exit_page_type,
117 count(*) over (partition by visit_id ) as pvs,
126 first_value(visit_time) over (partition by visit_id order by visit_time asc) as start_time,
127 first_value(visit_time) over (partition by visit_id order by visit_time desc) as end_time,
128 first_value(eref_key) over (partition by visit_id order by visit_time asc) as landing_eref_key,
129 first_value(iref_key) over (partition by visit_id order by visit_time asc) as landing_iref_key,
130 first_value(page_id) over (partition by visit_id order by visit_time asc) as landing_page_id,
131 first_value(page_type) over (partition by visit_id order by visit_time asc) as landing_page_type,
132 first_value(eref_key) over (partition by visit_id order by visit_time desc) as exit_eref_key,
133 first_value(iref_key) over (partition by visit_id order by visit_time desc) as exit_iref_key,
134 first_value(page_id) over (partition by visit_id order by visit_time desc) as exit_page_id,
135 first_value(page_type) over (partition by visit_id order by visit_time desc) as exit_page_type,
136 count(*) over (partition by visit_id ) as pvs,
145 first_value(visit_time) over (partition by visit_id order by visit_time asc) as start_time,
146 first_value(visit_time) over (partition by visit_id order by visit_time desc) as end_time,
147 first_value(eref_key) over (partition by visit_id order by visit_time asc) as landing_eref_key,
148 first_value(iref_key) over (partition by visit_id order by visit_time asc) as landing_iref_key,
149 first_value(page_id) over (partition by visit_id order by visit_time asc) as landing_page_id,
150 first_value(page_type) over (partition by visit_id order by visit_time asc) as landing_page_type,
151 first_value(eref_key) over (partition by visit_id order by visit_time desc) as exit_eref_key,
152 first_value(iref_key) over (partition by visit_id order by visit_time desc) as exit_iref_key,
153 first_value(page_id) over (partition by visit_id order by visit_time desc) as exit_page_id,
154 first_value(page_type) over (partition by visit_id order by visit_time desc) as exit_page_type,
155 count(*) over (partition by visit_id ) as pvs,
164 first_value(visit_time) over (partition by visit_id order by visit_time asc) as start_time,
165 first_value(visit_time) over (partition by visit_id order by visit_time desc) as end_time,
166 first_value(eref_key) over (partition by visit_id order by visit_time asc) as landing_eref_key,
167 first_value(iref_key) over (partition by visit_id order by visit_time asc) as landing_iref_key,
168 first_value(page_id) over (partition by visit_id order by visit_time asc) as landing_page_id,
169 first_value(page_type) over (partition by visit_id order by visit_time asc) as landing_page_type,
170 first_value(eref_key) over (partition by visit_id order by visit_time desc) as exit_eref_key,
171 first_value(iref_key) over (partition by visit_id order by visit_time desc) as exit_iref_key,
172 first_value(page_id) over (partition by visit_id order by visit_time desc) as exit_page_id,
173 first_value(page_type) over (partition by visit_id order by visit_time desc) as exit_page_type,
174 count(*) over (partition by visit_id ) as pvs,
183 first_value(visit_time) over (partition by visit_id order by visit_time asc) as start_time,
184 first_value(visit_time) over (partition by visit_id order by visit_time desc) as end_time,
185 first_value(eref_key) over (partition by visit_id order by visit_time asc) as landing_eref_key,
186 first_value(iref_key) over (partition by visit_id order by visit_time asc) as landing_iref_key,
187 first_value(page_id) over (partition by visit_id order by visit_time asc) as landing_page_id,
188 first_value(page_type) over (partition by visit_id order by visit_time asc) as landing_page_type,
189 first_value(eref_key) over (partition by visit_id order by visit_time desc) as exit_eref_key,
190 first_value(iref_key) over (partition by visit_id order by visit_time desc) as exit_iref_key,
191 first_value(page_id) over (partition by visit_id order by visit_time desc) as exit_page_id,
192 first_value(page_type) over (partition by visit_id order by visit_time desc) as exit_page_type,
193 count(*) over (partition by visit_id ) as pvs,
202 first_value(visit_time) over (partition by visit_id order by visit_time asc) as start_time,
203 first_value(visit_time) over (partition by visit_id order by visit_time desc) as end_time,
204 first_value(eref_key) over (partition by visit_id order by visit_time asc) as landing_eref_key,
205 first_value(iref_key) over (partition by visit_id order by visit_time asc) as landing_iref_key,
206 first_value(page_id) over (partition by visit_id order by visit_time asc) as landing_page_id,
207 first_value(page_type) over (partition by visit_id order by visit_time asc) as landing_page_type,
208 first_value(eref_key) over (partition by visit_id order by visit_time desc) as exit_eref_key,
209 first_value(iref_key) over (partition by visit_id order by visit_time desc) as exit_iref_key,
210 first_value(page_id) over (partition by visit_id order by visit_time desc) as exit_page_id,
211 first_value(page_type) over (partition by visit_id order by visit_time desc) as exit_page_type,
212 count(*) over (partition by visit_id ) as pvs,
221 first_value(visit_time) over (partition by visit_id order by visit_time asc) as start_time,
222 first_value(visit_time) over (partition by visit_id order by visit_time desc) as end_time,
223 first_value(eref_key) over (partition by visit_id order by visit_time asc) as landing_eref_key,
224 first_value(iref_key) over (partition by visit_id order by visit_time asc) as landing_iref_key,
225 first_value(page_id) over (partition by visit_id order by visit_time asc) as landing_page_id,
226 first_value(page_type) over (partition by visit_id order by visit_time asc) as landing_page_type,
227 first_value(eref_key) over (partition by visit_id order by visit_time desc) as exit_eref_key,
228 first_value(iref_key) over (partition by visit_id order by visit_time desc) as exit_iref_key,
229 first_value(page_id) over (partition by visit_id order by visit_time desc) as exit_page_id,
230 first_value(page_type) over (partition by visit_id order by visit_time desc) as exit_page_type,
231 count(*) over (partition by visit_id ) as pvs,
240 first_value(visit_time) over (partition by visit_id order by visit_time asc) as start_time,
241 first_value(visit_time) over (partition by visit_id order by visit_time desc) as end_time,
242 first_value(eref_key) over (partition by visit_id order by visit_time asc) as landing_eref_key,
243 first_value(iref_key) over (partition by visit_id order by visit_time asc) as landing_iref_key,
244 first_value(page_id) over (partition by visit_id order by visit_time asc) as landing_page_id,
245 first_value(page_type) over (partition by visit_id order by visit_time asc) as landing_page_type,
246 first_value(eref_key) over (partition by visit_id order by visit_time desc) as exit_eref_key,
247 first_value(iref_key) over (partition by visit_id order by visit_time desc) as exit_iref_key,
248 first_value(page_id) over (partition by visit_id order by visit_time desc) as exit_page_id,
249 first_value(page_type) over (partition by visit_id order by visit_time desc) as exit_page_type,
250 count(*) over (partition by visit_id ) as pvs,
259 first_value(visit_time) over (partition by visit_id order by visit_time asc) as start_time,
260 first_value(visit_time) over (partition by visit_id order by visit_time desc) as end_time,
261 first_value(eref_key) over (partition by visit_id order by visit_time asc) as landing_eref_key,
262 first_value(iref_key) over (partition by visit_id order by visit_time asc) as landing_iref_key,
263 first_value(page_id) over (partition by visit_id order by visit_time asc) as landing_page_id,
264 first_value(page_type) over (partition by visit_id order by visit_time asc) as landing_page_type,
265 first_value(eref_key) over (partition by visit_id order by visit_time desc) as exit_eref_key,
266 first_value(iref_key) over (partition by visit_id order by visit_time desc) as exit_iref_key,
267 first_value(page_id) over (partition by visit_id order by visit_time desc) as exit_page_id,
268 first_value(page_type) over (partition by visit_id order by visit_time desc) as exit_page_type,
269 count(*) over (partition by visit_id ) as pvs,
278 first_value(visit_time) over (partition by visit_id order by visit_time asc) as start_time,
279 first_value(visit_time) over (partition by visit_id order by visit_time desc) as end_time,
280 first_value(eref_key) over (partition by visit_id order by visit_time asc) as landing_eref_key,
281 first_value(iref_key) over (partition by visit_id order by visit_time asc) as landing_iref_key,
282 first_value(page_id) over (partition by visit_id order by visit_time asc) as landing_page_id,
283 first_value(page_type) over (partition by visit_id order by visit_time asc) as landing_page_type,
284 first_value(eref_key) over (partition by visit_id order by visit_time desc) as exit_eref_key,
285 first_value(iref_key) over (partition by visit_id order by visit_time desc) as exit_iref_key,
286 first_value(page_id) over (partition by visit_id order by visit_time desc) as exit_page_id,
287 first_value(page_type) over (partition by visit_id order by visit_time desc) as exit_page_type,
288 count(*) over (partition by visit_id ) as pvs,
297 first_value(visit_time) over (partition by visit_id order by visit_time asc) as start_time,
298 first_value(visit_time) over (partition by visit_id order by visit_time desc) as end_time,
299 first_value(eref_key) over (partition by visit_id order by visit_time asc) as landing_eref_key,
300 first_value(iref_key) over (partition by visit_id order by visit_time asc) as landing_iref_key,
301 first_value(page_id) over (partition by visit_id order by visit_time asc) as landing_page_id,
302 first_value(page_type) over (partition by visit_id order by visit_time asc) as landing_page_type,
303 first_value(eref_key) over (partition by visit_id order by visit_time desc) as exit_eref_key,
304 first_value(iref_key) over (partition by visit_id order by visit_time desc) as exit_iref_key,
305 first_value(page_id) over (partition by visit_id order by visit_time desc) as exit_page_id,
306 first_value(page_type) over (partition by visit_id order by visit_time desc) as exit_page_type,
307 count(*) over (partition by visit_id ) as pvs,
316 first_value(visit_time) over (partition by visit_id order by visit_time asc) as start_time,
317 first_value(visit_time) over (partition by visit_id order by visit_time desc) as end_time,
318 first_value(eref_key) over (partition by visit_id order by visit_time asc) as landing_eref_key,
319 first_value(iref_key) over (partition by visit_id order by visit_time asc) as landing_iref_key,
320 first_value(page_id) over (partition by visit_id order by visit_time asc) as landing_page_id,
321 first_value(page_type) over (partition by visit_id order by visit_time asc) as landing_page_type,
322 first_value(eref_key) over (partition by visit_id order by visit_time desc) as exit_eref_key,
323 first_value(iref_key) over (partition by visit_id order by visit_time desc) as exit_iref_key,
324 first_value(page_id) over (partition by visit_id order by visit_time desc) as exit_page_id,
325 first_value(page_type) over (partition by visit_id order by visit_time desc) as exit_page_type,
326 count(*) over (partition by visit_id ) as pvs,
335 first_value(visit_time) over (partition by visit_id order by visit_time asc) as start_time,
336 first_value(visit_time) over (partition by visit_id order by visit_time desc) as end_time,
337 first_value(eref_key) over (partition by visit_id order by visit_time asc) as landing_eref_key,
338 first_value(iref_key) over (partition by visit_id order by visit_time asc) as landing_iref_key,
339 first_value(page_id) over (partition by visit_id order by visit_time asc) as landing_page_id,
340 first_value(page_type) over (partition by visit_id order by visit_time asc) as landing_page_type,
341 first_value(eref_key) over (partition by visit_id order by visit_time desc) as exit_eref_key,
342 first_value(iref_key) over (partition by visit_id order by visit_time desc) as exit_iref_key,
343 first_value(page_id) over (partition by visit_id order by visit_time desc) as exit_page_id,
344 first_value(page_type) over (partition by visit_id order by visit_time desc) as exit_page_type,
345 count(*) over (partition by visit_id ) as pvs,