Lotsia PLM: Форум по семейству систем PLM/PDM/TDM/ERP/Workflow

Код: Выделить всё

SELECT     (SELECT     id
FROM          lsdbo.object_reference obj
WHERE      id IN
(SELECT     object_reference_id
FROM          lsdbo.file1 file1
WHERE      id IN
(SELECT     file_id
FROM          lsdbo.file_ver file_ver
WHERE      file_ver.id = file_log.file_ver_id))) AS isobject_id,
(SELECT     mnemo
FROM          lsdbo.object_type obj_type
WHERE      id =
(SELECT     type_id
FROM          lsdbo.object_reference obj
WHERE      id IN
(SELECT     object_reference_id
FROM          lsdbo.file1 file1
WHERE      id IN
(SELECT     file_id
FROM          lsdbo.file_ver file_ver
WHERE      file_ver.id = file_log.file_ver_id)))) AS mnemo,
(SELECT     description
FROM          lsdbo.object_reference obj
WHERE      id IN
(SELECT     object_reference_id
FROM          lsdbo.file1 file1
WHERE      id IN
(SELECT     file_id
FROM          lsdbo.file_ver file_ver
WHERE      file_ver.id = file_log.file_ver_id))) AS obj_desc,
(SELECT     vs.value
FROM          lsdbo.attrib_value av, lsdbo.value_string vs
WHERE      av.attrib_id = - 28 AND av.value_id = vs.id AND av.object_id IN
(SELECT     object_reference_id
FROM          lsdbo.file1 file1
WHERE      file1.id IN
(SELECT     file_id
FROM          lsdbo.file_ver file_ver
WHERE      file_ver.id = file_log.file_ver_id))) AS indication,
(SELECT     description
FROM          lsdbo.file1 file1
WHERE      file1.id IN
(SELECT     file_id
FROM          lsdbo.file_ver file_ver
WHERE      id = file_log.file_ver_id)) AS doc_desc, 
user_id, 
state AS acc_type, 
cd
FROM         LSDBO.File_Log file_log
WHERE     (state IN ('V', 'A', 'C', 'I')) AND (cd >= DATEADD(month, - 1, GETDATE()))
and user_id = 0