SELECT a.product_id,CONCAT("https://shop.marketeers.com/asset/upload/images/",a.featured_image) as img, a.product_name,a.product_sub_title, IF(d.main_price is not null,CONCAT("IDR ",FORMAT(MIN(d.main_price),0)), "NOT STARTED") as price, (DATEDIFF(b.date_end, b.date_start)+1) AS days, CONCAT("See Dates and Locations") as dtlocate, b.*, c.product_cat_id,c.product_cat_name, a.product_slug, MONTH(b.date_start) as mnt,a.badge1 FROM product as a left outer join (select product_id, MAX(if(product_attr_meta_id=46,product_attr_value,NULL)) as location, MAX(if(product_attr_meta_id=49,product_attr_value,NULL)) as date_start, MAX(if(product_attr_meta_id=50,product_attr_value,NULL)) as date_end, MAX(if(product_attr_meta_id=74,product_attr_value,NULL)) as shortdesc, MAX(if(product_attr_meta_id=76,product_attr_value,NULL)) as address, MAX(if(product_attr_meta_id=77,product_attr_value,NULL)) as target, MAX(if(product_attr_meta_id=78,product_attr_value,NULL)) as brochure, MAX(if(product_attr_meta_id=79,product_attr_value,NULL)) as pic, MAX(if(product_attr_meta_id=80,product_attr_value,NULL)) as facilitator, MAX(if(product_attr_meta_id=97,product_attr_value,NULL)) as credit from product_attribute group by product_id) as b on a.product_id=b.product_id left outer join (SELECT c1.*,c2.product_cat_name FROM product_category_set as c1 JOIN product_category as c2 ON c1.product_cat_id=c2.product_cat_id ) as c ON a.product_id=c.product_id left outer join (select product_id,product_parent_id,min(main_price) as main_price from product where main_price is not null group by product_parent_id) as d ON a.product_id=d.product_parent_id WHERE a.product_parent_id IS NULL AND a.status=1 AND a.product_parent_id is NULL AND a.product_id is NOT NULL AND d.main_price>=1 AND c.product_cat_id IN ("154","160","166","158","173","184") GROUP BY a.product_name ORDER BY ABS( DATEDIFF( date_start, NOW() ) ) LIMIT 5
MShop

Our Topics

Browse Our Top Program

Digital Marketing In Now Economy

IDR 5,000,000

Practical Marketing Research

Teknik Riset Praktis untuk Pengambilan Keputusan Pemas...

IDR 2,400,000

Principles of Marketing: A Step By Step Approach

Panduan Menyusun Strategi Pemasaran Secara Sistematis ...

IDR 2,000,000

Marketing 4.0

Teknik pemasaran terbaru yang terintegrasi antara pend...

IDR 330,000

The Essence of Consultative Selling

IDR 220,000

The Essence of Integrated Marketing Communication

IDR 220,000

The Essence of Service in Digital Era

IDR 220,000

Capturing Millennial Travelers Through Omni TX & Touri...

IDR 550,000

Key Account Management

Strategi Memaksimalkan Potensi Key Account

IDR 4,400,000

Service Blueprint

Understanding Online-Offline Customer Journey and Desi...

IDR 330,000

Handling Customer's Complaint

Taktik Jitu Mengubah Kekecewaan Menjadi Rekomendasi

IDR 330,000

Promo Bundling 2 Topik Executive Education Program

IDR 16,500,000

The Essence of Strategic Digital Marketing

IDR 220,000

Effective Social Media Marketing

Teknik menyusun dan mengimplementasikan pemasaran mela...

IDR 300,000

Digital Marketing

Jurus Efektif Melakukan Penjualan Melalui Platform Dig...

IDR 300,000

Grow With Character

Seni Membentuk Karakter Juara

IDR 330,000

Integrated Marketing Communication

Strategi Komunikasi Pemasaran yang Kreatif, Efektif, d...

IDR 660,000

Strategic Marketing Plan

Perencanaan Sistematis dan Praktis dengan Konsep 9 Ele...

IDR 330,000

Competitor Intelligence

Memanfaatkan Informasi mengenai Pesaing untuk Memenang...

IDR 2,400,000

Marketing 4.0

Teknik pemasaran terbaru yang terintegrasi antara pend...

IDR 2,000,000

Presentation With Impact

Cara Efektif Mempengaruhi, Meyakinkan, dan Memotivasi ...

IDR 1,200,000

Integrated Marketing Communication

Strategi Komunikasi Pemasaran yang Kreatif, Efektif, d...

IDR 660,000