Lines Matching refs:user_id
13 user_id,
18 user_id,
22 SELECT user_id, time
25 user_id >= 1 AND
26 user_id <= 3 AND
31 WHERE user_id = u.user_id AND
34 GROUP BY user_id
36 ORDER BY user_lastseen DESC, user_id;
43 user_id,
48 user_id,
52 SELECT user_id, time
55 user_id >= $1 AND
56 user_id <= $2 AND
61 WHERE user_id = u.user_id AND
64 GROUP BY user_id
66 ORDER BY user_lastseen DESC, user_id;
79 SELECT user_id
81 WHERE user_id IN (SELECT user_id FROM users_table WHERE value_1 >= $4 AND value_1 <= $3)
82 AND user_id IN (SELECT user_id FROM users_table WHERE value_1 >= $5 AND value_1 <= $6)
83 AND user_id IN (SELECT user_id FROM users_table WHERE value_1 >= $1 AND value_1 <= $2)
85 user_id
87 user_id DESC
109 ma.user_id, (GREATEST(coalesce(ma.value_4 / 250, 0.0) + GREATEST(1.0))) / 2 AS prob
113 short_list.user_id = ma.user_id and ma.value_1 < $1 and short_list.event_type < 3
115 ON users_table.user_id = temp.user_id
140 ma.user_id, (GREATEST(coalesce(ma.value_4 / 250, 0.0) + GREATEST(1.0))) / 2 AS prob
144 short_list.user_id = ma.user_id and ma.value_1 < $1 and short_list.event_type < 3
146 ON users_table.user_id = temp.user_id
161 t1.user_id, count(*)
165 user_id
170 user_id
173 ) t2 ON t1.user_id = t2.user_id
176 user_id
179 ) t3 ON t1.user_id = t3.user_id
190 t1.user_id, count(*)
194 user_id
202 ) t2 ON t1.user_id = t2.user_id
205 user_id
208 ) t3 ON t1.user_id = t3.user_id
221 user_id
226 user_id
229 ) t2 ON t1.user_id = t2.user_id
232 user_id
235 ) t3 ON t1.user_id = t3.user_id