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

Omnichannel Marketing Battle Plan

Winning Competition with Omni Experience

IDR 4,400,000

New Product Development

IDR 4,400,000

Marketing 4.0

Teknik pemasaran terbaru yang terintegrasi antara pend...

IDR 660,000

Practical Marketing Research

Teknik Riset Praktis untuk Pengambilan Keputusan Pemas...

IDR 4,400,000

The New Scenario Marketing 2019

Managing Millenials, Managing Millenials Customers, Om...

IDR 11,000,000

The New B2B Selling

Teknik Menjual yang Ampuh Kepada Klien Korporat

IDR 660,000

Winning Big Sales

IDR 660,000

Key Account Management

Strategi Memaksimalkan Potensi Key Account

IDR 4,400,000

Win-Win Sales Negotiation Skill

Strategi Menggapai Kesepakatan yang Menguntungkan kedu...

IDR 660,000

SALES PLAN

Merencanakan Taktik Penjualan Anda untuk Memenangkan P...

IDR 660,000

Turning Complaint Into WOW

IDR 660,000

The New Service Loyalty Programs That Work!

Keeping and Growing Valuable Customers with OMNI Techn...

IDR 9,900,000

Handling Customer's Complaint

Taktik Jitu Mengubah Kekecewaan Menjadi Rekomendasi

IDR 330,000

Turning Service Into Sales

Seni Layanan yang Berbuah Penjualan

IDR 660,000

Service Blueprint

Understanding Online-Offline Customer Journey and Desi...

IDR 330,000

Digital Marketing

Jurus Efektif Melakukan Penjualan Melalui Platform Dig...

IDR 660,000

Effective Social Media Marketing

Teknik menyusun dan mengimplementasikan pemasaran mela...

IDR 660,000

Digital Marketing 4.0

Winning the Market by Empowering Customers

IDR 8,800,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

Competitor Intelligence

Memanfaatkan Informasi mengenai Pesaing untuk Memenang...

IDR 4,400,000

Strategic Marketing Plan

Perencanaan Sistematis dan Praktis dengan Konsep 9 Ele...

IDR 330,000

Grow With Character

Seni Membentuk Karakter Juara

IDR 330,000