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 '%MAJALAH SEJARAH%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
7 1 20 Intisari: No. 729 / INTM20230601 / Juni 2023 Kompas Gramedia Primary Author mixed material 977053490003 Jakarta Kompas Gramedia 2023 605718226647d39ad270035.80128361.PNG National Geographic Indonesia: MNGI20230601 / Juni 2023 Gramedia Percetakan Primary Author mixed material Jakarta Gramedia Percetakan 2023 449921685647d38d49817a6.78120808.PNG Intisari: Seratus Persen Beragama, Seratus Persen Berbangsa Kompas Gramedia Primary Author mixed material Jakarta Kompas Gramedia 2022 Intisari: Seratus Persen Beragama, Seratus Persen Berbangsa (Desember 2022) Kompas Gramedia Primary Author mixed material 977053490003 Jakarta Kompas Gramedia 2022 Intisari: Memahami Corona si Virus Durjana (Maret 2020) Kompas Gramedia Primary Author mixed material 977053490003 Jakarta Kompas Gramedia 2020 3902040466363207152f033.13135484.jpeg Intisari: Mengintip Peluang Tikus Logam 2020 (Januari 2020) Kompas Gramedia Primary Author mixed material 977053490003 Jakarta Kompas Gramedia 2020 124520125663631ffe64bb49.43873741.jpg Intisari: Warna-Warni Histori Tionghoa Nusantara (Februari 2020) Kompas Gramedia Primary Author mixed material 977053490003 Jakarta Kompas Gramedia 2020 1489185386636320f6bce229.94786535.jpg