[SELECT t1.*, IF(es_nuevo_hasta>='2024-09-08','S','N') es_nuevo, t2.nombre AS categoria_n, t2.id id_categoria, t3.nombre AS sub_categoria_n, t3.id id_sub_categoria, t4.nombre AS sub_sub_categoria_n, t4.id id_sub_sub_categoria, (SELECT f.url FROM fotos_prod f WHERE f.id_producto=t1.id AND f.orden=0 LIMIT 1) as url, (SELECT COALESCE(SUM(IF(COALESCE(k.actual, 0) > 0, k.actual, 0)), 0) FROM stock k WHERE k.id_producto=t1.id) as stock_g FROM productos t1 INNER JOIN productos_categorias pc ON pc.id_producto=t1.id LEFT JOIN categorias t2 ON t2.id=pc.id_categoria LEFT JOIN sub_categorias t3 ON t3.id=pc.id_sub_categoria LEFT JOIN sub_sub_categorias t4 ON t4.id=pc.id_sub_sub_categoria WHERE t1.borrado=0 AND t1.visible='S' AND t1.categoria='86' AND t1.id<>'7170' AND t1.visible='S' AND (SELECT COALESCE(SUM(IF(COALESCE(k.actual, 0) > 0, k.actual, 0)), 0) FROM stock k WHERE k.id_producto=t1.id)>0 GROUP BY t1.id ORDER BY RAND() LIMIT 8]