Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
- ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement