user_suppliers

Select
    inn,
    fullname,
    u.*
From organization o
Join organizationdata od on o.organizationdataid = od.id --and od.accreditationenddate > now() c 09.03.23 аккредитация бессрочная
join signature sign on sign.id = od.operatorsignatureid
join users u on u.signatureid=sign.id
Where 1=1
And o.actual_id is null
And o.active = true
 And o.type = 'supplier'
 And o.draft = false
limit 123
;