Warning: session_write_close() [function.session-write-close]: open(/tmp/session/sess_9n4v4lo4ueclrs02l8nsihteq2, O_RDWR) failed: No such file or directory (2) in /domains/zinc12/htdocs/lib/zinc/user/ZincAuthentication.php on line 109

Warning: session_write_close() [function.session-write-close]: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp/session) in /domains/zinc12/htdocs/lib/zinc/user/ZincAuthentication.php on line 109

Warning: Cannot modify header information - headers already sent by (output started at /domains/zinc12/htdocs/lib/zinc/user/ZincAuthentication.php:109) in /domains/zinc12/htdocs/search/results.php on line 839
Search Results | ZINC Is Not Commercial - A database of commercially-available compounds
UCSF

No Substances to Display

BUT WAIT!

No substances matching your criteria were found.

However 10 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 = 605474
filter.purchasability = annotated
page.format = targets
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 = 605474 AND c.free = 1 AND c.purchasable = 0    LIMIT 50

Permalink

Embed Link to Results