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 PARIWISATA%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
38 1 20 Bali & Beyond: Volume 19 No. 212 / Jan-Mar 2018 BUMI DIAN KUSUMA Primary Author mixed material 02164590 Bali BUMI DIAN KUSUMA 2018 1776919009635b3be17d9263.96000709.jpg Bali & Beyond: Volume 20 No. 214 / Jul-Sept 2018 BUMI DIAN KUSUMA Primary Author mixed material 02164590 Bali BUMI DIAN KUSUMA 2018 1422209888636363048e0713.53699472.jpg Batik: Maret 2018 Batik Air Primary Author mixed material Jakarta Batik Air 2018 39066696636b0e4ca83835.69353303.jpg Colours: March 2018 Visindo Agensi Tama Primary Author mixed material Jakarta Visindo Agensi Tama 2018 DestinAsian: February-March 2018 DestinAsian Media Group Primary Author mixed material Jakarta DestinAsian Media Group 2018 J+ by The Jakarta Post / Travel Edition: Issue 4 / August 2018 The Jakarta Post Primary Author mixed material 23030879 Jakarta The Jakarta Post 2018 Jakarta Now!: April 2018 Phoenix Communications Primary Author mixed material Jakarta Phoenix Communications 2018 Jakarta Now!: July 2018 Phoenix Communications Primary Author mixed material Jakarta Phoenix Communications 2018 Lionmag: Januari 2018 Lionmag Primary Author mixed material 19794185 Jakarta Lionmag 2018 Lionmag: Maret 2018 Lionmag Primary Author mixed material 19794185 Jakarta Lionmag 2018 Panorama: April - May 2018 Panorama Media Primary Author mixed material Jakarta PT. Panorama Media 2018 Panorama: February - March 2018 Panorama Media Primary Author mixed material 23374020 Jakarta Panorama Media 2018 209016561063648710c18b93.00770325.jpg Sriwijaya: Edisi 86 / April 2018 NEGERI AKSARA MANDIRI Primary Author mixed material Jakarta NEGERI AKSARA MANDIRI 2018 coverimg_1000926.jpg Travel+Leisure: July 2018 Time Inc. Affluent Media Group Primary Author mixed material 19060823 New York ; London Time Inc. Affluent Media Group 2018 15454588166364755c047dd2.89769805.jpg Panorama: July - September 2018 Panorama Media Primary Author mixed material 23374020 Jakarta Panorama Media 2017/2018 Bali & Beyond: Volume 18 No. 204 / May 2017 BUMI DIAN KUSUMA Primary Author mixed material 02164590 Bali BUMI DIAN KUSUMA 2017 1976290992635b3a93dd9b30.28318346.jpg Bali & Beyond: Volume 19 No. 208 / Sept 2017 BUMI DIAN KUSUMA Primary Author mixed material 02164590 Bali BUMI DIAN KUSUMA 2017 286525876635b3b4f8104b9.72274490.jpg Bali & Beyond: Volume 19 No. 211/ December 2017 BUMI DIAN KUSUMA Primary Author mixed material 02164590 Bali BUMI DIAN KUSUMA 2017 7521671576384190b84d6f2.87709134.jpg Bali Now!: August 2017 Phoenix Communications Primary Author mixed material 20862539 Jakarta Phoenix Communications 2017 185007107063806eb3c129b7.34526228.jpg Bali Now!: July 2017 Phoenix Communications Primary Author mixed material 20862539 Jakarta Phoenix Communications 2017 410498501636862ea5b24b2.88213178.jpg