select mo.id from ss_moduleorg mo
inner join ss_module m on m.id = mo.module
inner join ss_moduletype mt on mt.id = m.type
join SO_OrgSystem os on os.id = mo.organization
join SO_StructureUnit su ON su.id = os.id
where mt.alias = '{module}' AND m.complect='' AND m.isNamed=1 AND su.shortname = '{short name organization}'