PLA-1628 Refactor Special Promote

Here copy & paste is only the sql query. But is seems it could be optimized somewhat and then they would differ more. But maybe @SebastianMarzjan  can shed a light if we will be cleaning up this right now or maybe in new Refactor :8ball: