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

Start from

IDR 5,000,000

Practical Marketing Research

Teknik Riset Praktis untuk Pengambilan Keputusan Pemas...

Start from

IDR 2,400,000

Principles of Marketing: A Step By Step Approach

Panduan Menyusun Strategi Pemasaran Secara Sistematis ...

Start from

IDR 2,000,000

Marketing 4.0

Teknik pemasaran terbaru yang terintegrasi antara pend...

Start from

IDR 550,000

Key Account Management

Strategi Memaksimalkan Potensi Key Account

Start from

IDR 4,400,000

Sales Plan

Merencanakan Taktik Penjualan Anda untuk Memenangkan P...

Start from

IDR 2,400,000

The New B2B Selling

Teknik Menjual yang Ampuh Kepada Klien Korporat

Start from

IDR 2,400,000

Consultative Selling

Jadilah Konsultan, Selesaikan Problem Pelanggan, Dapat...

Start from

IDR 1,200,000

Sales Force Management

Teknik Pengelolaan Tenaga Penjual Secara Optimal

Start from

IDR 2,400,000

Omni CX Strategy: Empowering Customer through Service ...

Start from

IDR 5,000,000

Service Blueprint

Understanding Online-Offline Customer Journey and Desi...

Start from

IDR 4,400,000

Handling Customer's Complaint

Taktik Jitu Mengubah Kekecewaan Menjadi Rekomendasi

Start from

IDR 2,000,000

Effective Social Media Marketing

Teknik menyusun dan mengimplementasikan pemasaran mela...

Start from

IDR 300,000

Digital Marketing

Jurus Efektif Melakukan Penjualan Melalui Platform Dig...

Start from

IDR 300,000

Integrated Marketing Communication

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

Start from

IDR 2,400,000

Strategic Marketing Plan

Perencanaan Sistematis dan Praktis dengan Konsep 9 Ele...

Start from

IDR 2,400,000

Competitor Intelligence

Memanfaatkan Informasi mengenai Pesaing untuk Memenang...

Start from

IDR 2,400,000

Marketing 4.0

Teknik pemasaran terbaru yang terintegrasi antara pend...

Start from

IDR 220,000

Presentation With Impact

Cara Efektif Mempengaruhi, Meyakinkan, dan Memotivasi ...

Start from

IDR 1,200,000

Integrated Marketing Communication

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

Start from

IDR 2,400,000