Find voucher code in uCommerce

gistfile1.sql

SELECT TOP 100
    *
FROM
	uCommerce_CampaignItem ci 
        LEFT JOIN uCommerce_Target t ON ci.CampaignItemId = t.CampaignItemId
		LEFT JOIN uCommerce_VoucherTarget vt ON t.TargetId = vt.VoucherTargetId
        LEFT JOIN uCommerce_ProductTarget pt ON t.TargetId = pt.ProductTargetId
WHERE
    ci.Name = 'Campaign Item Name'