Lines Matching refs:user_id
10 user_id
20 users_table.user_id = events_table.user_id AND event_type = 1
22 user_id
24 GROUP BY user_id
26 ORDER BY user_id
31 user_id
41 users_table.user_id = events_table.user_id AND event_type = 1 AND
44 user_id
46 GROUP BY user_id
48 ORDER BY user_id
53 user_id
63 users_table.user_id > events_table.user_id AND event_type = 1 AND
66 user_id
68 GROUP BY user_id
70 ORDER BY user_id
75 user_id
80 …ECT avg(value_3) FROM events_table WHERE users_table.user_id = events_table.user_id GROUP BY user_…
89 user_id
100 e1.user_id = e2.user_id
106 user_id
117 e1.user_id = e2.user_id
126 user_id, count(*)
130 …user_id =ANY(SELECT user_id FROM users_table WHERE value_1 >= 1 AND value_1 <= 2) GROUP BY 1 ORDER…
134 user_id
143 users_table.user_id = events_table.user_id
145 user_id)
147 user_id
149 user_id;
155 SELECT user_id, value_2 FROM users_table WHERE
158 AND user_id IN
161 e1.user_id
165 user_id,
171 GROUP BY user_id
174 user_id,
179 user_id = e1.user_id AND
184 user_id,
189 user_id = e2.user_id AND
195 user_id,
199 user_id = e3.user_id AND
207 user_id = e4.user_id AND
211 group by e1.user_id
222 user_id
226 user_id IN
229 user_id
232 subquery_1.user_id, count_pay
236 users_table.user_id,
243 users_table.user_id = events_table.user_id AND
244 users_table.user_id >= 1 AND
245 users_table.user_id <= 3 AND
250 users_table.user_id,
257 users_table.user_id = events_table.user_id AND
258 users_table.user_id >= 1 AND
259 users_table.user_id <= 3 AND
265 user_id,
270 user_id >= 1 AND
271 user_id <= 3 AND
274 user_id
278 subquery_1.user_id = subquery_2.user_id
280 subquery_1.user_id,
283 count_pay, user_id
285 GROUP BY user_id
293 SELECT user_id, array_length(events_table, 1)
295 SELECT user_id, array_agg(event ORDER BY time) AS events_table
298 u.user_id, e.event_type::text AS event, e.time
302 WHERE u.user_id = e.user_id AND
303 u.user_id IN
306 user_id
310 …D EXISTS (SELECT user_id FROM events_table WHERE event_type > 1 AND event_type <= 3 AND value_3 >…
311 …OT EXISTS (SELECT user_id FROM events_table WHERE event_type > 3 AND event_type <= 4 AND value_3 …
314 GROUP BY user_id
324 SELECT user_id, value_2 FROM users_table WHERE
327 AND user_id IN
330 e1.user_id
334 user_id,
340 GROUP BY user_id
343 user_id,
348 user_id = e1.user_id AND
353 user_id,
358 user_id = e2.user_id AND
364 user_id,
368 value_2 = e3.user_id AND
376 user_id = e4.user_id AND
380 group by e1.user_id
387 user_id
391 user_id IN
394 user_id
397 subquery_1.user_id, count_pay
401 2 * users_table.user_id as user_id,
408 users_table.user_id = events_table.user_id AND
409 users_table.user_id >= 1 AND
410 users_table.user_id <= 3 AND
415 users_table.user_id,
422 users_table.user_id = events_table.user_id AND
423 users_table.user_id >= 1 AND
424 users_table.user_id <= 3 AND
430 user_id,
435 user_id >= 1 AND
436 user_id <= 3 AND
439 user_id
443 subquery_1.user_id = subquery_2.user_id
445 subquery_1.user_id,
448 count_pay, user_id
450 GROUP BY user_id
455 SELECT user_id, array_length(events_table, 1)
457 SELECT user_id, array_agg(event ORDER BY time) AS events_table
460 u.user_id, e.event_type::text AS event, e.time
464 WHERE u.user_id = e.user_id AND
465 u.user_id IN
468 user_id
472 …D EXISTS (SELECT user_id FROM events_table WHERE event_type > 1 AND event_type <= 3 AND value_3 >…
473 …T EXISTS (SELECT user_id FROM events_table WHERE event_type > 3 AND event_type <= 4 AND value_3 >…
476 GROUP BY user_id
482 user_id
494 user_id
499 (SELECT random()) AND user_id < 0
505 user_id
515 users_table.user_id = events_table.user_id AND event_type = 2
517 user_id
524 SELECT DISTINCT user_id
526 WHERE user_id
528 f_inner.user_id
532 e1.user_id
536 e1.user_id = u1.user_id
540 e1.user_id
544 e1.user_id = u1.user_id
545 AND e1.user_id IN (SELECT user_id FROM users_table ORDER BY user_id LIMIT 3)
547 WHERE f_inner.user_id = f_outer.user_id
552 SELECT user_id
554 WHERE user_id IN (SELECT user_id FROM users_table WHERE value_1 >= 1 AND value_1 <= 2)
555 AND user_id IN (SELECT user_id FROM users_table WHERE value_1 >= 3 AND value_1 <= 4)
556 …AND value_2 IN (SELECT user_id FROM users_table WHERE value_1 >= 5 AND value_1 <= 6) ORDER BY 1 D…
566 SELECT user_id, value_2 FROM users_table WHERE
569 …XISTS (SELECT user_id FROM events_table WHERE event_type=1 AND value_3 > 1 AND test_join_function(…