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 230 total

IdFirst nameLast nameEmailCreated atUpdated atPost 1 titlePost 2 titlePost 3 title
4HankKuhlmanhank-kuhlman@example.com20/11/23 12:1424/11/23 20:19Dolores.Reprehenderit.Aperiam.
5AlainaRunolfsdottiralaina-runolfsdottir@example.com15/11/23 07:0321/11/23 09:56Expedita.Sit.Alias.
5AlainaRunolfsdottiralaina-runolfsdottir@example.com15/11/23 07:0321/11/23 09:56Expedita.Sit.Alias.
6LedaO'Haraleda-o'hara@example.com19/12/23 22:3623/12/23 06:20Temporibus.Inventore.Quas.
6LedaO'Haraleda-o'hara@example.com19/12/23 22:3623/12/23 06:20Temporibus.Inventore.Quas.
7RosendoShanahanrosendo-shanahan@example.com23/11/23 11:3129/11/23 18:24Unde.Deleniti.Ut.
7RosendoShanahanrosendo-shanahan@example.com23/11/23 11:3129/11/23 18:24Unde.Deleniti.Ut.
12MichelinaSimonismichelina-simonis@example.com21/10/23 16:1323/10/23 20:05Est.Iure.Doloribus.
13JosefFayjosef-fay@example.com26/12/23 19:2430/12/23 09:12Dolorem.Enim.Et.
14LashondaWisokylashonda-wisoky@example.com09/11/23 20:3011/11/23 14:09Incidunt.Natus.Non.