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

Principles of Marketing: A Step By Step Approach

Panduan Menyusun Strategi Pemasaran Secara Sistematis ...

IDR 2,200,000

Optimizing Brand Attractiveness to Millennial Customer

IDR 8,800,000

Competitor Intelligence in Digital Era

Pelajari kompetitor, tingkatkan penawaran, menangkan p...

IDR 660,000

Principles of Marketing

Panduan Menyusun Strategi Pemasaran Secara Sistematis ...

IDR 2,200,000

Practical Marketing Research

Teknik Riset Praktis untuk Pengambilan Keputusan Pemas...

IDR 2,400,000

Strategic Marketing Plan

Perencanaan Sistematis dan Praktis dengan Konsep 9 Ele...

IDR 2,640,000

Marketing Communication Plan

Metode Perencanaan Komunikasi Pemasaran yang Tepat Sas...

IDR 660,000

Creating Super Sales Team

IDR 8,800,000

Sales Supervisor Development Program

Be an Effective Sales Supervisor in the Sales Team

IDR 4,400,000

Key Account Management

Strategi Memaksimalkan Potensi Key Account

IDR 4,400,000

Managing Millennials, Machine-Human Interaction and Mo...

IDR 9,900,000

Service Blueprint

Understanding Online-Offline Customer Journey and Desi...

IDR 330,000

The New Service Loyalty Programs That Work!

IDR 8,800,000

Handling Customer's Complaint

Taktik Jitu Mengubah Kekecewaan Menjadi Rekomendasi

IDR 330,000

Service Strategy That Sells!

IDR 8,800,000

Effective Social Media Marketing

Teknik menyusun dan mengimplementasikan pemasaran mela...

IDR 300,000

Digital Marketing 4.0

Winning the Market by Empowering Customers

IDR 8,800,000

Digital Marketing

Jurus Efektif Melakukan Penjualan Melalui Platform Dig...

IDR 300,000

Marketing Innovation in Digital Era

From Design to Implement to Evaluation

IDR 8,800,000

Integrated Marketing Communication

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

IDR 660,000

Grow With Character

Seni Membentuk Karakter Juara

IDR 330,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