Advanced search

Conditions are built from the form builder's attribute_select, predicate_select and combinator_select, and groups can be nested. Attributes with a known set of values, such as a role or tag name, get a select instead of a text field.

SQL

SELECT users.*, (SELECT COUNT(*) FROM posts WHERE posts.user_id = users.id) AS posts_count FROM "users" ORDER BY (SELECT COUNT(*) FROM posts WHERE posts.user_id = users.id) ASC

Your first 10 results out of 338 total

Id First name Last name Email Created at Updated at Roles Posts ▲
198 Micah Friesen micah-friesen@example.com 16/11/26 04:33 22/11/26 11:53
user
0
66 Samantha Gulgowski samantha-gulgowski@example.com 01/11/26 08:24 07/11/26 16:41
user
0
159 Casey Orn casey-orn@example.com 06/10/26 20:41 12/10/26 13:33
user
0
3 Serena Howell serena-howell@example.com 03/11/26 05:43 05/11/26 04:59
user
0
105 Reyes Lubowitz reyes-lubowitz@example.com 03/10/26 18:05 07/10/26 11:31
user
0
107 Tory Durgan tory-durgan@example.com 07/11/26 01:03 10/11/26 05:41
user
0
157 Tyler Murphy tyler-murphy@example.com 15/10/26 23:21 22/10/26 02:52
user
0
158 Merrill Morissette merrill-morissette@example.com 16/10/26 06:33 16/10/26 20:35
user
0
131 Carrol Wolf carrol-wolf@example.com 12/11/26 00:20 18/11/26 00:32
user
0
144 Mose Stiedemann mose-stiedemann@example.com 14/11/26 18:38 19/11/26 08:35
user
0