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 '%Air conditioning%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
7 1 20 Pamflet Promo Hisense perfect match hi champion Hisense Primary Author mixed material Hisense 2022 Heating, cooling, lighting : sustainable design methods for architects. Fourth Edition Lechner, Norbert Primary Author mixed material 9781118582428 New York John Wiley & Sons 2014 %2B-%2B399047404_70.gif.gif Ashrae Pocket Guide for Air Conditioning, Heating, Ventilation, Refrigeration. Eighth Edition ASHRAE Primary Author mixed material 9781936504626 United States of America ASHRAE 2013 ashrae.jpg.jpg Brosur AQUA Japan: 2021 Refrigerator AQUA Japan Primary Author mixed material AQUA Japan Leaflet AQUA Air Conditioning 2021 New Turbo Cool Series AQUA Japan Primary Author mixed material AQUA Japan Pamflet Gree Moo5 Mendinginkan Ruangan Paling Cepat! Gree Primary Author mixed material Gree Pamflet Promo Coolze Coolze Primary Author mixed material Coolze