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

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 2,000,000

Principles of Marketing

Panduan Menyusun Strategi Pemasaran Secara Sistematis ...

Start from

IDR 2,000,000

Omnichannel Marketing Battle Plan

Winning Competition with Omni Experience

Start from

IDR 5,000,000

Sales Force Management

Teknik Pengelolaan Tenaga Penjual Secara Optimal

Start from

IDR 2,400,000

Win-Win Sales Negotiation Skill

Strategi Menggapai Kesepakatan yang Menguntungkan kedu...

Start from

IDR 1,200,000

Winning Sales Force

The New Strategic Sales Management 2018

Start from

IDR 5,000,000

Sales Supervisor Development Program

Be an Effective Sales Supervisor in the Sales Team

Start from

IDR 4,000,000

On Becoming Sales Superstar

Rahasia Motivasi Menjadi Salesman Bermental Positif & ...

Start from

IDR 1,200,000

Handling Customer's Complaint

Taktik Jitu Mengubah Kekecewaan Menjadi Rekomendasi

Start from

IDR 2,000,000

Effective Communication Skill

Be A Savvy And Dynamic Communicator

Start from

IDR 2,000,000

Empowering Customer Through Service Power

Start from

IDR 5,000,000

Service Blueprint

Understanding Online-Offline Customer Journey and Desi...

Start from

IDR 4,000,000

Digital Marketing

Jurus Efektif Melakukan Penjualan Melalui Platform Dig...

Start from

IDR 300,000

Effective Social Media Marketing

Teknik menyusun dan mengimplementasikan pemasaran mela...

Start from

IDR 300,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 2,000,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

Marketing Manager Development Program

Start from

IDR 10,000,000

Integrated Marketing Communication

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

Start from

IDR 2,400,000

Presentation With Impact

Cara Efektif Mempengaruhi, Meyakinkan, dan Memotivasi ...

Start from

IDR 1,200,000