SQL:
SELECT "users".* FROM "users" LEFT OUTER JOIN "posts" ON "posts"."user_id" = "users"."id" WHERE "posts"."title" ILIKE '%t%'
Id | First name | Last name | Created at | Updated at | Post 1 title | Post 2 title | Post 3 title | |
---|---|---|---|---|---|---|---|---|
4 | Hank | Kuhlman | hank-kuhlman@example.com | 20/11/23 12:14 | 24/11/23 20:19 | Dolores. | Reprehenderit. | Aperiam. |
5 | Alaina | Runolfsdottir | alaina-runolfsdottir@example.com | 15/11/23 07:03 | 21/11/23 09:56 | Expedita. | Sit. | Alias. |
5 | Alaina | Runolfsdottir | alaina-runolfsdottir@example.com | 15/11/23 07:03 | 21/11/23 09:56 | Expedita. | Sit. | Alias. |
6 | Leda | O'Hara | leda-o'hara@example.com | 19/12/23 22:36 | 23/12/23 06:20 | Temporibus. | Inventore. | Quas. |
6 | Leda | O'Hara | leda-o'hara@example.com | 19/12/23 22:36 | 23/12/23 06:20 | Temporibus. | Inventore. | Quas. |
7 | Rosendo | Shanahan | rosendo-shanahan@example.com | 23/11/23 11:31 | 29/11/23 18:24 | Unde. | Deleniti. | Ut. |
7 | Rosendo | Shanahan | rosendo-shanahan@example.com | 23/11/23 11:31 | 29/11/23 18:24 | Unde. | Deleniti. | Ut. |
12 | Michelina | Simonis | michelina-simonis@example.com | 21/10/23 16:13 | 23/10/23 20:05 | Est. | Iure. | Doloribus. |
13 | Josef | Fay | josef-fay@example.com | 26/12/23 19:24 | 30/12/23 09:12 | Dolorem. | Enim. | Et. |
14 | Lashonda | Wisoky | lashonda-wisoky@example.com | 09/11/23 20:30 | 11/11/23 14:09 | Incidunt. | Natus. | Non. |