Having issues creating view

I have a script which creates a view.  It uses several 'hard coded' values and then goes to a table to select the remaining values.  It works fine, however I now need to add some additional hard coded values two of which repeat a child value that was used previously.  If I add these to the script before the select statement that goes to the table, I end up with duplicated of everything in the table.  If I add them after the table selects, I get syntax errors and warnings.  I am attaching the script and hoping that someone can