---

USE [myNewVasya];
GO

-- Куда действительно направляются эти вопросы.
SELECT
    pm.textPoll,
    ps.kod AS subjectKod,
    ps.nmSubject,
    ps.targetTable,
    ps.nmField
FROM dbo.spr_pollsToMind AS pm
JOIN dbo.spr_pollsSubject AS ps
    ON ps.kod = pm.kodSubject
WHERE pm.textPoll IN (
    N'ФИО для сертификата',
    N'Формат подключения',
    N'Поле для комментариев и предложений'
);

-- Проверяем отдельно отчёт, оценки и сертификат.
-- Период — по дате мероприятия с 22.09.2026.
SELECT
    r.kod AS kodReport,
    m.kod AS kodMember,
    a.kod AS kodMerop,
    r.manFIO AS reportFIO,
    r.otzyv AS reportOtzyv,
    sc.kodReport AS scoreReport,
    sc.scoreOtzyv,
    c.kodReport AS certificateReport,
    c.mtsCertNumber,
    c.manFIO AS certificateFIO,
    c.formReceived,
    c.lastCheckAt,
    c.lastError
FROM dbo.dat_members AS m
JOIN dbo.dat_activity AS a
    ON a.kod = m.kodMerop
LEFT JOIN dbo.sb_reports AS r
    ON r.kodMember = m.kod
LEFT JOIN dbo.dat_mts_scores AS sc
    ON sc.kodMember = m.kod
   AND sc.kodMerop = a.kod
LEFT JOIN dbo.dat_mts_certificates AS c
    ON c.kodMember = m.kod
   AND c.kodMerop = a.kod
WHERE m.kod IN (10773311, 10787631)
  AND a.dtMerop >= CONVERT(datetime, '20260922', 112)
ORDER BY m.kod, r.kod;