Product data Subquery with fallback to default

[Genaker]

SELECT
p.entity_id,
p.sku,
(
SELECT COALESCE(v.value, gv.value)
FROM catalog_product_entity_varchar AS v
LEFT JOIN catalog_product_entity_varchar AS gv
ON gv.entity_id = v.entity_id
AND gv.attribute_id = 71
AND gv.store_id = 0
WHERE v.entity_id = p.entity_id
AND v.attribute_id = 71
AND v.store_id = 1
LIMIT 1
) AS name,
(
SELECT COALESCE(v.value, gv.value)
FROM catalog_product_entity_int AS v
LEFT JOIN catalog_product_entity_int AS gv
ON gv.entity_id = v.entity_id
AND gv.attribute_id = 93
AND gv.store_id = 0
WHERE v.entity_id = p.entity_id
AND v.attribute_id = 93
AND v.store_id = 1
LIMIT 1
) AS color,
(
SELECT COALESCE(v.value, gv.value)
FROM catalog_product_entity_decimal AS v
LEFT JOIN catalog_product_entity_decimal AS gv
ON gv.entity_id = v.entity_id
AND gv.attribute_id = 77
AND gv.store_id = 0
WHERE v.entity_id = p.entity_id
AND v.attribute_id = 77
AND v.store_id = 1
LIMIT 1
) AS price
FROM
catalog_product_entity AS p;

Without fallback

SELECT
p.entity_id,
p.sku,
(
SELECT value
FROM catalog_product_entity_varchar
WHERE entity_id = p.entity_id
AND attribute_id = 71
AND store_id = 1
LIMIT 1
) AS name,
(
SELECT value
FROM catalog_product_entity_int
WHERE entity_id = p.entity_id
AND attribute_id = 93
AND store_id = 1
LIMIT 1
) AS color,
(
SELECT value
FROM catalog_product_entity_decimal
WHERE entity_id = p.entity_id
AND attribute_id = 77
AND store_id = 1
LIMIT 1
) AS price
FROM
catalog_product_entity AS p;