magento-bad-eu-prices.sql

select
    eu_flat.entity_id,
    eu_flat.sku,
    def_eav.value default_eav_price,
    eu_eav.value eu_eav_price,
    eu_flat.price eu_flat_price
from catalog_product_flat_3 eu_flat
inner join catalog_product_entity_decimal eu_eav
    on eu_flat.entity_id = eu_eav.entity_id
    and eu_eav.attribute_id = 75
    and eu_eav.store_id = 3
inner join catalog_product_entity_decimal def_eav
    on eu_flat.entity_id = def_eav.entity_id
    and def_eav.attribute_id = 75
    and def_eav.store_id = 1
where eu_eav.value != eu_flat.price;