General zinc15 curation

From DISI
Revision as of 17:32, 17 August 2017 by Frodo (talk | contribs) (asdf)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

update purchasability (belongs on curator page)

update substance set purchasability = substance_best_purchasability(sub_id) where sub_id in (select sub_id from substance where purchasability is null limit 10000);