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 '%Architecture -- Details.%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
11 1 20 Corridor Trüby, Stephan Primary Author Werlemann, hans Primary Author Mcleod, Kevin et.all Primary Author mixed material 9788891013118 Venezia Marsilio 2014 image_book_%285%29.jpg.jpg Door Koolhaas, Rem Primary Author boom, irma Primary Author mixed material 9788891013002 Venezia Marsilio, 2014 image_book_%287%29.jpg.jpg Elevator Koolhaas, Rem Primary Author mixed material 9788891013095 Venezia Marsilio 2014 coverimg_17933.jpg Escalator Koolhaas, Rem Primary Author mixed material 9788891013057 Venezia Marsilio, 2014 image_book.jpg.jpg Fireplace Koolhaas, Rem Primary Author boom, irma Primary Author Marot, Sébastien Primary Author mixed material 9788891013033 Venezia Marsilio 2014 image_book_%282%29.jpg.jpg Floor Koolhaas, Rem Primary Author boom, irma Primary Author Easterling, Keller Primary Author mixed material 9788891012982 Venezia Marsilio 2014 20170829_114925.jpg.jpg Ramp Koolhaas, Rem Primary Author mixed material 9788891013088 Venezia Marsilio 2014 cc.jpg.jpg Roof Feng, Jiren Primary Author Zhenning,Fang Primary Author Petermann, Stephan Primary Author mixed material 9788891013101 Venezia Marsilio 2014 81sUmejNSqL.jpg.jpg Stair Koolhaas, Rem Primary Author Trüby, Stephan Primary Author boom, irma Primary Author mixed material 9788891013040 Venezia Marsilio 2014 coverimg_17938.jpg Toilet Koolhaas, Rem Primary Author boom, irma Primary Author mixed material 9788891013064 Venezia Marsilio 2014 image_book_%286%29.jpg.jpg Wall Koolhaas, Rem Primary Author boom, irma Primary Author mixed material 9788891012999 Venezia Marsilio 2014 20170829_132048.jpg.jpg