UCSF

Crickets chirp in the distance. Chirp Chirp.

BUT WAIT!

No substances matching your criteria were found.

However 40 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 = 62026
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 = 62026 AND c.free = 1 AND c.purchasable IN (1,2,4,5)    LIMIT 50

Permalink

Embed Link to Results