1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
|
SELECT book.support AS support,
author.title AS author_adv,
book.nglibrary_book_id AS nglibrary_book_id,
book.cover AS cover,
book.title AS title,
book.subtitle AS subtitle,
book.coll5 AS coll5,
book.resume AS resume,
book.author_p AS author_p,
book.coll7 AS coll7,
book.coll6 AS coll6,
book.collection AS collection,
book.serie AS serie,
book.support AS support,
book.isbn AS isbn,
book.year AS year,
book.genre AS genre,
book.public AS public,
book.grp_public AS grp_public,
book.created_on AS book_created_on,
book.grp_genre AS grp_genre,
book.status_bib AS status_bib,
book.periodique AS periodique,
book.hits AS hits
FROM nr3zk_nglibrary_books AS book
LEFT JOIN nr3zk_nglibrary_books_authors AS link_author
ON book.nglibrary_book_id = link_author.nglibrary_book_id
LEFT JOIN nr3zk_nglibrary_authors AS author
ON author.nglibrary_author_id = link_author.nglibrary_author_id
WHERE (`author_adv` LIKE '%herge%') |
Partager