SELECT
    `value`
FROM
    `customer_entity_varchar`
WHERE
    `entity_id` = 10 AND
    `attribute_id` = (SELECT
                         `e`.`attribute_id`
                      FROM
                         `eav_attribute` e
                      LEFT JOIN
                          `eav_entity_type` et
                          ON `e`.`entity_type_id` = `et`.`entity_type_id`
                      WHERE
                          `e`.`attribute_code` = 'password_hash' AND
                          `et`.`entity_type_code` = 'customer'
                     )