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 '%ENGLISH LANGUAGE-GRAMMAR, STUDY, TEACHING%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
10 1 20 Grammar for IELTS with Answers ; Self-Study grammar reference and practice Hopkins, Diana Primary Author mixed material 9780521604628 Cambridge Cambridge University Press 2013 %2B-%2B206904943_140.gif.gif Advanced Market Leader: Business English Course Book. Third Edition O'keeffe, Margaret Primary Author Dubicka, Iwonna; Primary Author mixed material 9781408237038 Slovakia Pearson Longman 2011 9781408237038-us.jpg.jpg Market Leader : Elementary Business English Course Book Cotton, David Primary Author mixed material 9780582773271 England Pearson 2007 9781408237052.jpg.jpg Market Leader : Upper Intermediate Business English Course Book Cotton, David Primary Author Langley, David Primary Author Kent, Simon Primary Author mixed material 9781405881395 England Pearson 2006 91kvyU8-yPL._AC_UY218_.jpg.jpg Market Leader : Upper Intermediate Business English Teacher's Book Mascull, Bill Primary Author mixed material 9781405843462 England Pearson 2006 coverimg_5236.jpg Oxford Preparation Course For The TOEIC Test Oxford Primary Author mixed material 9780194564007 New York Oxford 2006 %2B-%2B871268723_140.gif.gif Market Leader: Course Book (Pre-Intermediate Business English) Cotton, David Primary Author Kent, Simon Primary Author Falvey, David Primary Author mixed material 9781405881388 England Longman 2002 coverimg_5237.jpg MARKET LEADER David Cotton, David Falvey, and Simon Kent Primary Author mixed material PEARSON International Market leader :  Intermediate business English David Cotton, David Falvey, Simon Kent Primary Author mixed material Longman Market leader : upper intermediate test master mixed material England Pearson