select
ifnull(name.value, ifnull(fs.name, TENHH)) as name,
ifnull(price.value, ifnull(fs.price, ebiz.GIALE)) as price,
ebiz.MABH as sku
from fahasa_ebiz_stock_info ebiz
left join fahasa_stock fs on fs.sku = ebiz.MABH
left join fhs_catalog_product_entity pe on pe.sku = ebiz.MABH
left JOIN fhs_catalog_product_entity_varchar name ON pe.entity_id = name.entity_id AND name.attribute_id = 71
left JOIN fhs_catalog_product_entity_decimal price ON pe.entity_id = price.entity_id AND price.attribute_id = 75
where MABH in ("8934974163459");