Break up Promotion index sql for the tableview

This follows Site's admin Account/Index.php naming conventions.