SELECT     processes_1.uut_level3 AS Issue, Tests_1.Test_Name AS Number, processes_1.UUT_Name AS name,
                          (SELECT     results.Pass_Flag
                            FROM          results INNER JOIN
                                                   sequencer ON results.sqid = sequencer.sqid INNER JOIN
                                                   Tests ON sequencer.tid = Tests.tid INNER JOIN
                                                   sub_processes ON Tests.spid = sub_processes.spid INNER JOIN
                                                   processes ON sub_processes.pid = processes.pid ) AS H3
FROM         processes AS processes_1 INNER JOIN
                      sub_processes AS sub_processes_1 ON processes_1.pid = sub_processes_1.pid INNER JOIN
                      Tests AS Tests_1 ON sub_processes_1.spid = Tests_1.spid INNER JOIN
                      sequencer AS sequencer_1 ON Tests_1.tid = sequencer_1.tid INNER JOIN
                      results AS results_1 ON sequencer_1.sqid = results_1.sqid
WHERE     (NOT (Tests_1.Test_Name LIKE N'Skip%'))
ORDER BY Issue