Get entity_id and name of products in Magento db. Don't forget your table prefix!

entity_id-product_name.sql

select cpev.entity_id as entity_id, cpev.value as product_name from catalog_product_entity_varchar as cpev
    join eav_attribute as ea on cpev.attribute_id = ea.attribute_id
    join eav_entity_type as eet on ea.entity_type_id = eet.entity_type_id
    join catalog_product_entity as cpe on cpe.entity_id = cpev.entity_id
    where ea.attribute_code = 'name'
    and eet.entity_type_code = 'catalog_product'
    and cpe.type_id = 'downloadable';