SELECT DISTINCT
    SPR11.NAIM,
    SPR11.UID,
    JDD.PROIZV_DATA_VR,
    JDD.KOLVO,
    JDD.SUMMA_REAL,
    JDD.SUMMA_ZAKUPKI,
    (SELECT LIST (NAIM, ', ') FROM SPRAV_02 WHERE ID IN (SELECT ID_PARENT_USER FROM JUR_DOCS_DETAIL_PROIZV WHERE ID_PARENT=JDD.ID)) AS USER_PR
FROM
   JUR_DOCS_DETAIL JDD
   LEFT JOIN JUR_DOCS_DETAIL_PROIZV JDDP
ON
   JDDP.ID_PARENT = JDD.ID
   LEFT JOIN SPRAV_11 SPR11
ON
   SPR11.ID = JDD.NOMENKL_ID
   LEFT JOIN SPRAV_111 SPR111
ON
   SPR111.ID_PARENT=JDD.NOMENKL_ID AND SPR111.MAGAZIN_ID=JDDP.ID_PARENT_MAG
   LEFT JOIN JUR_DOCS JUR
ON
   JDD.ID_PARENT=JUR.ID
WHERE
    JDD.PROIZV_REJIM=2 AND JDD.NOMENKL_ID=:NOMENKL_ID AND JUR.DOC_TIP_ID=2 AND SPR11.DELETED = 0
    AND (JDDP.ID_PARENT_USER = :ID_PARENT_USER OR :ID_PARENT_USER IS NULL)
    AND (JDDP.ID_PARENT_MAG = :PROIZV_ID OR :PROIZV_ID IS NULL)
    AND CAST(JDDP.DATA AS DATE) BETWEEN :STDATA AND :ENDDATA
    AND (JUR.OPENED_DOC_MAGAZIN_ID = :OPENED_DOC_MAGAZIN_ID OR :OPENED_DOC_MAGAZIN_ID IS NULL)
    AND (JUR.KONTRAGENT_ID = :KONTRAGENT_ID OR :KONTRAGENT_ID IS NULL)
    AND (JUR.FOTIS_ORDER_FL = :FOTIS_ORDER_FL OR :FOTIS_ORDER_FL IS NULL)
    AND (JUR.DELETED=:DELETED OR :DELETED IS NULL)