SELECT biblio.biblio_id, biblio.title, biblio.image, biblio.isbn_issn, biblio.publish_year, pbl.publisher_name AS `publisher`, pplc.place_name AS `publish_place`, biblio.labels, biblio.input_date FROM biblio LEFT JOIN mst_publisher AS pbl ON biblio.publisher_id=pbl.publisher_id LEFT JOIN mst_place AS pplc ON biblio.publish_place_id=pplc.place_id WHERE opac_hide=0 AND (biblio.title LIKE '%%' AND biblio.gmd_id NOT IN (SELECT gmd_id FROM mst_gmd WHERE gmd_name='Manuscript')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 10000, 20
16213 501 20 The Last Shogun Shiba, Ryotaro Primary Author mixed material 9789791924030 s.i Kantera 2010 82158980558e1a2c9baae09811779d46.jpg.jpg The Lost Hero Rhordan, Rick Primary Author mixed material 9781423113461 New York Disney Hyperion Books New York 2010 9781423142652-us.jpg.jpg The Making Of Avatar Duncan, Jody Primary Author mixed material 9780810997066 New York Abrams 2010 %2B-%2B443556403_140.gif.gif The media student's book Branston, Gill Primary Author mixed material 9780415558426 Oxon Routledge 2010 med.jpg.jpg The Microsoft way Stross, Randall E. Primary Author mixed material 9789792915280 Yogyakarta Andi 2010 mmm.jpg.jpg The Microsoft Way : The Real Story how Bill Gates Outsmarts the Competition Stross, Randall E. Primary Author mixed material 9789792915280 Yogyakarta Penerbit Andi 2010 coverimg_10754.jpg The New Encyclopaedia Britannica (Guide to the Britannica) Encyclopaedia Britannica, inc. Primary Author mixed material 9781593398378 Chicago Encyclopaedia Britannica, inc. 2010 Image_%2832%29.jpg.jpg The New Encyclopaedia Britannica Index L-Z Encyclopaedia Britannica, inc. Primary Author mixed material 9781593398378 Chicago Encyclopaedia Britannica, inc. 2010 Image_%2832%29.jpg.jpg The New Encyclopaedia Britannica Volume 1 Encyclopaedia Britannica, inc. Primary Author mixed material 9781593398378 Chicago Encyclopaedia Britannica, inc. 2010 Image_%2832%29.jpg.jpg The New Encyclopaedia Britannica Volume 13 Encyclopaedia Britannica, inc. Primary Author mixed material 9781593398378 Chicago Encyclopaedia Britannica, inc. 2010 Image_%2832%29.jpg.jpg The New Encyclopaedia Britannica Volume 15 Encyclopaedia Britannica, inc. Primary Author mixed material 9781593398378 Chicago Encyclopaedia Britannica, inc. 2010 Image_%2832%29.jpg.jpg The New Encyclopaedia Britannica Volume 16 Encyclopaedia Britannica, inc. Primary Author mixed material 9781593398378 Chicago Encyclopaedia Britannica, inc. 2010 Image_%2832%29.jpg.jpg The New Encyclopaedia Britannica Volume 17 Encyclopaedia Britannica, inc. Primary Author mixed material 9781593398378 Chicago Encyclopaedia Britannica, inc. 2010 Image_%2832%29.jpg.jpg The New Encyclopaedia Britannica Volume 20 Encyclopaedia Britannica, inc. Primary Author mixed material 9781593398378 Chicago Encyclopaedia Britannica, inc. 2010 Image_%2832%29.jpg.jpg The New Encyclopaedia Britannica Volume 21 Encyclopaedia Britannica, inc. Primary Author mixed material 9781593398378 Chicago Encyclopaedia Britannica, inc 2010 Image_%2832%29.jpg.jpg The New Encyclopaedia Britannica Volume 22 Encyclopaedia Britannica, inc. Primary Author mixed material 9781593398378 Chicago Encyclopaedia Britannica, inc. 2010 Image_%2832%29.jpg.jpg The New Encyclopaedia Britannica Volume 23 Encyclopaedia Britannica, inc. Primary Author mixed material 9781593398378 Chicago Encyclopaedia Britannica, inc. 2010 Image_%2832%29.jpg.jpg The New Encyclopaedia Britannica Volume 24 Encyclopaedia Britannica, inc. Primary Author mixed material 9781593398378 Chicago Encyclopaedia Britannica, inc. 2010 Image_%2832%29.jpg.jpg The New Encyclopaedia Britannica Volume 25 Encyclopaedia Britannica, inc. Primary Author mixed material 9781593398378 Chicago Encyclopaedia Britannica, inc. 2010 Image_%2832%29.jpg.jpg The New Encyclopaedia Britannica Volume 26 Encyclopaedia Britannica, inc. Primary Author mixed material 9781593398378 Chicago Encyclopaedia Britannica, inc 2010 Image_%2832%29.jpg.jpg