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 '%Man-woman relationships%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
9 1 20 The starless sea Morgenstern, Erin Primary Author mixed material 9780385545365 United Kingdom Random House 2019 714315757636b7302c275e5.60097540.jpg Her body and other parties : stories Machado, Carmen Maria Primary Author mixed material 9781555977887 Minnesota Graywolf 2017 her_body.gif.gif Paris for one and other stories Moyes, Jojo Primary Author mixed material 9780718186654 London Penguin 2016 32680297.jpg.jpg The longest ride Sparks, Nicholas Primary Author mixed material 9781455584734 New York Grand Central Publishing 2015 9781455584734.gif.gif Men, women & children : a novel Kultgen, Chad Primary Author mixed material 9780061657313 New York Harper Perennial 2011 20839202.jpg.jpg Norwegian wood Murakami, Haruki Primary Author Rubin, Jay Primary Author mixed material 9780307744661 New York Vintage Books 2011 9780307744661.gif.gif Great Expectations Dickens, Charles Primary Author mixed material 9780451531186 New York Penguin 2009 Great_expectations.jpg.jpg Balzac and the little Chinese seamstress Dai, Sijie Primary Author Yu, Zhongxian Primary Author mixed material 9780385365475 New York Alfred A.Knopf 2001 16558195696470324f7b93d0.92020242.jpeg Great expectations. Dickens, Charles Primary Author mixed material 9781853260049 London wordsworth classics 1987 9781853260049-uk.jpg.jpg