add promotionlink tpl and separate select insert