string(719) "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_product_categories pc LEFT JOIN dung_2_manawa_v2_products p ON p.product_id = pc.product_id LEFT JOIN dung_2_manawa_v2_store s ON s.store_id = p.store_id LEFT JOIN dung_2_manawa_v2_categories c ON c.category_id = pc.category_id WHERE p.microsite_id = 1256 AND product_status = 'active' AND product_name != '' AND (pc.category_id = 8 OR category_group = 8) ORDER BY p.created_at DESC"