select "auteurs"."id", "auteurs"."username", "books__co_auteurs"."id_books" as "pivot_id_books", "books__co_auteurs"."id_auteur" as "pivot_id_auteur" from "auteurs" innerjoin "books__co_auteurs" on "auteurs"."id" = "books__co_auteurs"."id_auteur" where "books__co_auteurs"."id_books" in (2, 14) and "auteurs"."deleted_at" isnull
select "langues"."Abbreviation", "books_has_langues"."Books_id" as "pivot_Books_id", "books_has_langues"."Langue_id" as "pivot_Langue_id" from "langues" innerjoin "books_has_langues" on "langues"."id" = "books_has_langues"."Langue_id" where "books_has_langues"."Books_id" in (2, 14) and "langues"."deleted_at" isnull