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 "users"."created_at" DESC

Your first 10 results out of 364 total

Id	First name	Last name	Email	Created at ▼	Updated at	Roles	Posts
432	Alva	Skiles	alva-skiles@example.com	09/12/26 15:35	14/12/26 06:11	admin	3 Voluptates. Qui. Qui.
5	Alaina	Runolfsdottir	alaina-runolfsdottir@example.com	09/12/26 14:47	10/12/26 07:49	admin	3 Expedita. Sit. Alias.
113	Derick	Herman	derick-herman@example.com	08/12/26 18:02	11/12/26 17:10	admin	3 Harum. Itaque. Itaque.
139	Vince	Pfannerstill	vince-pfannerstill@example.com	08/12/26 15:17	13/12/26 18:00	admin	3 Sed. Et. Enim.
2	Callie	Jenkins	callie-jenkins@example.com	08/12/26 15:06	12/12/26 04:47	user	0
341	Eleanore	Becker	eleanore-becker@example.com	08/12/26 12:11	14/12/26 18:35	admin	3 Vero. Sequi. Exercitationem.
169	Hobert	Rogahn	hobert-rogahn@example.com	08/12/26 08:42	12/12/26 18:57	admin	3 Non. Corrupti. Ut.
70	Shenika	Kohler	shenika-kohler@example.com	08/12/26 06:17	12/12/26 09:18	admin	3 In. Doloribus. Sequi.
43	Van	Kilback	van-kilback@example.com	07/12/26 20:44	13/12/26 11:47	admin	3 Earum. Et. Ab.
65	Henrietta	Ratke	henrietta-ratke@example.com	07/12/26 18:55	08/12/26 13:21	admin	3 Harum. Enim. Quibusdam.