'select am.code, am.path, a.name '+
                             'from application_machine as am INNER JOIN application as a on ' +
                             'a.code = am.application_code where' +
                             'am.machine_code='+ MachineCode +

                             'order by am.code;';