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 '%RAPE%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
11 1 20 Elevator pitch : a novel Barclay, Linwood Primary Author mixed material 9780008332037 Not Found HQ 2020 coverimg_1001232.jpg Cilka's journey Morris, Heather Primary Author mixed material 9781785769139 London Zaffre 2019 56936111636a1d725e7f25.62397349.jpg EVolo skyscrapers 3 Aiello, Carlo Editor mixed material 9781938740220 Los Angeles EVolo 2016 Evolo3.gif.gif The way I used to be Smith, Amber Primary Author mixed material 9781481449366 New York Margaret Mcelderry Bks 2016 9781481449366.gif.gif To kill a mockingbird Lee, Harper Primary Author mixed material 9780099549482 London Arrow 2016 9780099549482.gif.gif Clothing on figures : how to draw folds, fabrics, and drapery Civardi, Giovanni Primary Author mixed material 9781782212300 Tunbridge Wells Search Press 2015 clothing.gif.gif EVolo skyscrapers 2 : 150 new projects redefine building high Aiello, Carlo Editor mixed material 9781938740053 Los Angeles EVolo 2014 evolo2.gif.gif Tall buildings : structural systems and aerodynamic form Günel, Mehmet Halis Primary Author Ilgin, Hüseyin Emre Primary Author mixed material 9781138021778 London Routledge 2014 tall_building.gif.gif Tall buildings of China Binder, Georges Primary Author mixed material 9781864704129 Victoria The Images Publishing Group 2014 63256244863d1eea31ffb70.88557929.jpg The Artist's guide to drawing the clothed figure : a complete resource on rendering clothing and drapery Massen, Michael Primary Author mixed material 9780823001194 New York Watson-Guptill Publications 2012 drawing_clothed.gif.gif Aplikasi reiki dalam penyembuhan diri sendiri dan orang lain Effendi, Tjiptadinata Primary Author mixed material 9792017356 Jakarta Elex Media Komputindo 2000 coverimg_1282.jpg