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.biblio_id IN (SELECT bt.biblio_id FROM biblio_topic AS bt LEFT JOIN mst_topic AS t ON bt.topic_id=t.topic_id WHERE topic LIKE '%SPECIALIZED DICTIONARIES%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
9 1 20 Oxford learner's thesaurus : a dictionary of synonyms Oxford Primary Author mixed material 9780194752008 Oxford Oxford 2010 coverimg_6150.jpg Kamus Sinonim Matanggui, Junaiyah H Primary Author mixed material 9789790257238 Jakarta Grasindo 2009 kamus_sinonim.jpg.jpg Cambridge Advanced Learner's Dictionary Cambridge Primary Author mixed material 0521843790 Singapore Cambridge University Press 2008 519sycisUXL._SX331_BO1%2C204%2C203%2C200_.jpg.jpg Practical English Usage Fully Revised Swan, Michael Primary Author mixed material 9780194420983 Oxford Oxford 2008 coverimg_8593.jpg Shortcut PowerPoint 2007 Yuwono, Ari Primary Author mixed material 9789792726893 Jakarta Elex Media Komputindo 2008 coverimg_9846.jpg Phaidon Design Classics volume one phaidon Primary Author mixed material 9780714843995 New York Phaidon 2006 coverimg_8495.jpg Tesaurus Bahasa Indonesia Eko Endarmoko Primary Author mixed material 9789792224474 Jakarta Gramedia 2006 coverimg_10517.jpg Oxford advanced learner's compass Oxford University Primary Author mixed material Oxford University Press Oxford learner's thesaurus Oxford University Primary Author mixed material Oxford University Press