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 '%FAMILIES%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
14 1 20 Maleficent : mistress of evil Rudnick, Elizabeth Primary Author mixed material 9781368045605 Los Angeles Disney Press 2019 9781368045605.jpg.jpg And the mountains echoed Hosseini, Khaled Primary Author mixed material 9781526604644 London Bloomsbury 2018 9781526604644.gif.gif Lu Reynolds, Jason Primary Author mixed material 9781481450249 New York Atheneum Books for Young Readers 2018 90052775964366d7d0be4e2.04972276.jpg City of spies : a novel Khan, Sorayya Primary Author mixed material 9781503941571 New York Little A 2017 City_of_Spies.jpg.jpg Little fires everywhere : a novel Ng, Celeste Primary Author mixed material 9780735224292 New York Penguin 2017 little_fires.gif.gif This is not a werewolf story Evans, Sandra Primary Author mixed material 9781481444804 New York Atheneum Books for Young Readers 2016 9781481444804.gif.gif Little men: anak-anak plumfield Alcott, Louisa May Primary Author mixed material 9786020323329 Jakarta Gramedia Pustaka Utama 2015 2100899552659505f8d147e4.34842547.jpeg Crazy rich Asians Kwan, Kevin Primary Author mixed material 9780804171588 New York Anchor Books 2014 %2B-%2B903879694_70.gif.gif Doctor Sleep : a novel King, Stephen Primary Author mixed material 9781982131807 New York Gallery Books 2013 9781982131807.gif.gif Men, women & children : a novel Kultgen, Chad Primary Author mixed material 9780061657313 New York Harper Perennial 2011 20839202.jpg.jpg A thousand splendid suns Hosseini, Khaled Primary Author Windgassen, Michael Primary Author mixed material 9780747593775 London Bloomsbury 2008 9780747593775.gif.gif The Red parts : autobiography of a trial Nelson, Maggie Primary Author mixed material 9781555977368 Minnesota Graywolf 2007 THE_RED_PARTS.jpg.jpg The Outsiders Hinton, S. E. Primary Author mixed material 9780142407332 New York Speak 1995 outsiders.gif.gif A raisin in the sun Hansberry, Lorraine Primary Author mixed material 9780679755333 New York Vintage Books 1994 %2B-%2B48894058_140.jpg.jpg