string(508) "SELECT p.product_id, product_name, product_slug, price, meta_data, galleries,
(SELECT COUNT(product_id) as total_likes FROM dung_2_manawa_v2_product_likes pl WHERE pl.product_id = p.product_id) as likes,
store_name, store_slug FROM dung_2_manawa_v2_products p
LEFT JOIN dung_2_manawa_v2_store s ON s.store_id = p.store_id
WHERE p.microsite_id = 6239 AND product_status = 'active' AND product_name != '' AND p.store_id = '400' ORDER BY p.created_at DESC"
