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 '%SINGAPORE%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
7 1 20 China rich girlfriend Kwan, Kevin Primary Author mixed material 9781101973394 New York Anchor Books 2015 %2B-%2B823748414_70.gif.gif WOHA : selected projects : Vol. 2 Bingham-Hall, Patrick Primary Author mixed material 9789814428040 Balmain Pesaro Publishing 2015 195710012164363578e89953.71725190.jpg Crazy rich Asians Kwan, Kevin Primary Author mixed material 9780804171588 New York Anchor Books 2014 %2B-%2B903879694_70.gif.gif DP architects : the master architect series Anderson, Collin Primary Author Chan, Sui Him Primary Author Cleary, Mark W. Primary Author Ball, Debbie Primary Author mixed material 9781864704471 Mulgrave Images Publishing Group 2012 9781864704471.gif.gif Evolution of a retail streetscape : DP Architects on Orchard Road Frampton, Kenneth Primary Author Anderson, Collin Primary Author Ball, Debbie Primary Author Maki, Fumikiho Primary Author mixed material 9781864704624 Mulgrave, Vic. Images Publishing Group 2012 9781864704624.gif.gif Batik : creating an identity Lee, Chor Lin Primary Author mixed material 9789814155915 Singapore National Museum of Singapore and Editions Didier Millet 2007 %2B-%2B018502081_140.jpg.jpg Singapore food Hutton, Wendy Primary Author mixed material 9789812613219 Singapore Marshall Cavendish International 2007 9789812613219.jpg.jpg