select
    storeinfo.code as storeCode,
    storeinfo.name as storeName,
    storeinfo.id as storeId,
    storeinfo.number as storeNumber,
    pricechangeworker.pricechangeworkerid,
    pricechange.vmecode,
    pricechange.code,
    pricechange.changed,
    pricechange.oldprice,
    pricechange.newprice,
    pricechange.band
from pricechangeworker
INNER JOIN pricechange on pricechange.code = pricechangeworker.code
INNER JOIN prices on pricechange.vmecode = prices.vmecode AND pricechange.band = prices.band
INNER JOIN [range] on [range].vmecode = prices.vmecode
INNER JOIN [pricerange] on [pricerange].rangenames = [range].rangenames
inner join storeinfo on storeinfo.code = [pricerange].store
where  pricechangeworker.vmecode = 'V028078'
AND EXISTS (SELECT store from stocktransfer WHERE stocktransfer.store = storeinfo.code AND date > '2019-03-01')