-- Правильный SQL запрос для получения всех данных контакта с кастомными полями
-- Исправлено: birthday в vtiger_contactsubdetails, mailingstreet в vtiger_contactaddress

SELECT 
    cd.contactid,
    cd.firstname,
    cd.lastname,
    cd.email,
    cd.mobile,
    cd.phone,
    cs.birthday,                    -- ✅ Из vtiger_contactsubdetails
    ca.mailingstreet,               -- ✅ Из vtiger_contactaddress
    ca.mailingcity,
    ca.mailingstate,
    ca.mailingzip,
    ca.mailingcountry,
    -- Кастомные поля из vtiger_contactscf:
    ccf.cf_1157 AS middle_name,     -- Отчество
    ccf.cf_1263 AS birthplace,      -- Место рождения
    ccf.cf_1257 AS inn,             -- ИНН
    ccf.cf_1849 AS requisites,      -- Реквизиты
    ccf.cf_1580 AS code,            -- Код
    ccf.cf_1706 AS sms              -- SMS
FROM vtiger_contactdetails cd
LEFT JOIN vtiger_contactscf ccf ON ccf.contactid = cd.contactid
LEFT JOIN vtiger_contactsubdetails cs ON cs.contactsubscriptionid = cd.contactid
LEFT JOIN vtiger_contactaddress ca ON ca.contactaddressid = cd.contactid
LEFT JOIN vtiger_crmentity ce ON ce.crmid = cd.contactid
WHERE cd.contactid = {{ $json.contact_id }}
  AND ce.deleted = 0