string(721) "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 = 18 OR category_group = 18) ORDER BY p.created_at DESC"
.png)
.png)
.png)
