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 = 3419 AND product_status = 'active' AND product_name != '' AND p.store_id = '167' ORDER BY p.created_at DESC"