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"."id" DESC

Your first 10 results out of 338 total

Id ▼	First name	Last name	Email	Created at	Updated at	Roles	Posts
359	Junior	Streich	junior-streich@example.com	23/11/26 22:00	24/11/26 23:45	admin	3 Nemo. Tempore. Repellendus.
358	Alberto	Mann	alberto-mann@example.com	10/11/26 06:59	12/11/26 11:04	admin	3 Aspernatur. Iusto. Ad.
357	Elvis	Rodriguez	elvis-rodriguez@example.com	15/10/26 14:37	17/10/26 00:39	admin	3 Molestiae. Maiores. Quia.
356	Filiberto	Feil	filiberto-feil@example.com	12/10/26 03:31	15/10/26 06:36	admin	3 Quod. Incidunt. Eum.
355	Lemuel	Block	lemuel-block@example.com	04/10/26 23:32	07/10/26 23:13	admin	3 Voluptates. Ab. Voluptatem.
354	Johnie	Thompson	johnie-thompson@example.com	21/10/26 23:19	27/10/26 02:53	admin	3 Ut. Autem. Et.
353	Thomasina	Langworth	thomasina-langworth@example.com	13/10/26 04:45	15/10/26 06:50	admin	3 Dolor. Earum. In.
352	Waylon	Pfeffer	waylon-pfeffer@example.com	30/09/26 23:55	07/10/26 07:14	admin	3 Voluptatum. Consequatur. Deleniti.
351	Sung	Rogahn	sung-rogahn@example.com	03/11/26 22:32	05/11/26 00:24	admin	3 Voluptatem. Vero. Consequatur.
350	Stuart	Marquardt	stuart-marquardt@example.com	30/09/26 04:24	04/10/26 05:32	admin	3 Unde. Veritatis. Nostrum.