SELECT `article`.`artcId`, `article`.`artcTitle`, `article`.`artcExcerpt`, `article`.`artcDetail`, `article`.`artcKeyword`, `article`.`artcKeyword`, `master_category`.`mscId` as `category_id`, `master_category`.`mscName` as `category_menu`, `article`.`artcSaved`, `article`.`artcPublishTime` as `publish_time`, `article`.`artcStatus`, `article`.`anonymous_article`, `article`.`isShowUser`, `arsip_file`.`arfileId` as `mediaid`, `arsip_file`.`arfileFileType` as `media_type`, `user_komunitas`.`ukomId` as `userid_kontributor`, `user_komunitas`.`ukomName` as `kontributor`, `admin`.`admiId` as `editor_id`, `admin`.`admiRealName` as `editor`
FROM `article`
LEFT JOIN `master_category` ON `master_category`.`mscId` = `article`.`artcMscvId`
LEFT JOIN `article_image` ON `article_image`.`article_id` = `article`.`artcId`
LEFT JOIN `arsip_file` ON `arsip_file`.`arfileId` = `article_image`.`arsip_file_id`
LEFT JOIN `user_komunitas` ON `user_komunitas`.`ukomId` = `article`.`artcUkomIdSaved`
LEFT JOIN `admin` ON `admin`.`admiId` = `article`.`artcUserIdApproved`
WHERE `artcId` = 25
LIMIT 1
Ekowisata
21 Jul 2020 11:11
Teluk Doreri Manokwari
View Teluk Doreri di Manokwari, Papua Barat. Pemandangan dari jalan Sarina Taman Wisata Alam Gunung Meja.
Teluk Doreri di Manokwari Papua Barat, terlihat dari Jalan Sarina, Taman Wisata Alam Gunung Meja. Salah satu objek wisata di Indonesia bagian timur ini mempunyai daya tarik pemandangan bawah lautnya yang unik dan khas. Koleksi terumbu karang disini tak hanya indah namun juga jenisnya jarang ditemukan.
