Magento 2 DB Queries

magento2-bd-queries.sql

# Get product SKU by url key
select e.entity_id,e.sku,v.value from catalog_product_entity e
inner join catalog_product_entity_varchar v on e.entity_id = v.entity_id and 
attribute_id = (select attribute_id from eav_attribute where attribute_code = 'url_key' and entity_type_id = 4)
where v.value = '<url_key>';