Advanced User Search

Go to Simple mode

SQL:

SELECT "users".* FROM "users" LEFT OUTER JOIN "posts" ON "posts"."user_id" = "users"."id" WHERE "posts"."title" ILIKE '%t%'

Your first 10 results out of 304 total

IdFirst nameLast nameEmailCreated atUpdated atPost 1 titlePost 2 titlePost 3 title
4HankKuhlmanhank-kuhlman@example.com27/07/25 07:2929/07/25 14:26Dolores.Reprehenderit.Aperiam.
5AlainaRunolfsdottiralaina-runolfsdottir@example.com29/06/25 14:4630/06/25 22:29Expedita.Sit.Alias.
5AlainaRunolfsdottiralaina-runolfsdottir@example.com29/06/25 14:4630/06/25 22:29Expedita.Sit.Alias.
6LedaO'Haraleda-o'hara@example.com08/07/25 07:4615/07/25 00:43Temporibus.Inventore.Quas.
6LedaO'Haraleda-o'hara@example.com08/07/25 07:4615/07/25 00:43Temporibus.Inventore.Quas.
7RosendoShanahanrosendo-shanahan@example.com27/06/25 17:0430/06/25 03:30Unde.Deleniti.Ut.
7RosendoShanahanrosendo-shanahan@example.com27/06/25 17:0430/06/25 03:30Unde.Deleniti.Ut.
12MichelinaSimonismichelina-simonis@example.com25/06/25 20:1827/06/25 04:48Est.Iure.Doloribus.
13JosefFayjosef-fay@example.com23/06/25 11:2928/06/25 12:02Dolorem.Enim.Et.
14LashondaWisokylashonda-wisoky@example.com15/06/25 01:2018/06/25 07:57Incidunt.Natus.Non.