SELECT cpe.entity_id, cpe.sku, cped.value as price, cped.store_id
FROM catalog_product_entity cpe
JOIN catalog_product_entity_decimal cped ON cpe.entity_id=cped.entity_id
JOIN eav_attribute ea ON cped.attribute_id=ea.attribute_id AND ea.attribute_code='price' -- omitting entity type for brevity
WHERE cped.store_id!=0