UCSF

Nothing for you to see here

BUT WAIT!

No substances matching your criteria were found.

However 12 substances were found by removing the purchasability filter.

If you believe there should have been a result, please tell us what you think is missing. (Vendor ID, Compound ID, URL to where we can find the molecule on line). Thanks!

Parameters Provided:

ring.id = 226066
filter.purchasability = purchasable
page.num = 1

Structural Results Found: (before additional filtering)

SQL Query Was

SELECT DISTINCT(ci.sub_id_fk) AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id INNER JOIN hasring AS hr ON ci.sub_id_fk=hr.sub_id_fk INNER JOIN rings AS r ON hr.rings_fk=r.rings_id  WHERE r.rings_id = 226066 AND c.free = 1 AND c.purchasable IN (1,2,4,5)    LIMIT 50

Permalink

Embed Link to Results