Values : 
SELECT 
	pr.product_id,
	left(pr.name,100) as nombre,
    pr.price,
     ( SELECT pro.product_id 
     FROM woo_product_11_05_2021 pro 
     WHERE pro.name 
     like CONCAT('%',nombre,'%') 
     limit 1
    ) AS pro_id,
    ( SELECT pro.name 
     FROM woo_product_11_05_2021 pro 
     WHERE pro.name 
     like CONCAT('%',nombre,'%') 
     limit 1
    ) AS nombre_old,
     ( SELECT pro.price 
     FROM woo_product_11_05_2021 pro 
     WHERE pro.name 
     like CONCAT('%',nombre,'%') 
     limit 1
    ) AS precio
FROM woo_product pr 
where pr.unidad_id = 10
order by nombre
Error : 42S02
 Error 00000


 Query : SELECT 
	pr.product_id,
	left(pr.name,100) as nombre,
    pr.price,
     ( SELECT pro.product_id 
     FROM woo_product_11_05_2021 pro 
     WHERE pro.name 
     like CONCAT('%',nombre,'%') 
     limit 1
    ) AS pro_id,
    ( SELECT pro.name 
     FROM woo_product_11_05_2021 pro 
     WHERE pro.name 
     like CONCAT('%',nombre,'%') 
     limit 1
    ) AS nombre_old,
     ( SELECT pro.price 
     FROM woo_product_11_05_2021 pro 
     WHERE pro.name 
     like CONCAT('%',nombre,'%') 
     limit 1
    ) AS precio
FROM woo_product pr 
where pr.unidad_id = 10
order by nombre