JUMA AL MAJID CENTER - LIBRARY SEARCH

Search Results

SELECT books.id, books.title, books.en_name,books.broad_name, books.latin_name,books.material_type, books.statement_of_response, book_with_author.authorname_ar, book_with_author.authorname_en, book_with_author.authorname_filter_ar, book_with_author.authorname_filter_en FROM books LEFT JOIN book_with_author ON book_with_author.book_id = books.id WHERE ( book_with_author.authorname_ar = 'السامرائي، قاسم، 1935- / 1354-' OR book_with_author.authorname_filter_ar = 'السامرائي، قاسم، 1935- / 1354-' OR book_with_author.authorname_en = 'السامرائي، قاسم، 1935- / 1354-' OR book_with_author.authorname_ar ) GROUP BY books.id
No. Material No Material Type Language Title Statment Of Responsibility Main Subject
51 874088 Book English 5 Seconds of Summer : Hey, Let's Make A Band! 5 Seconds of Summer (Musical group) Subject biographies