UCSF

Parameters Provided:

name.synonym = (2E)-oct-2-enal;(E)-2-Octen-1-al;(E)-Oct-2-enal;2-(E)-Octenal;2-trans-Octenal;Oct-(E)-2-enal;Oct-2(E)-enal;Octene-1-oxide;trans-2-Octen-1-al;trans-2-Octenal;trans-Oct-2-enal;trans-Octen-2-al
filter.purchasability = all
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 synonym AS syn ON (ci.cat_id_fk=syn.cat_fk AND ci.supplier_code=syn.supplier_code) INNER JOIN field AS f ON syn.field_fk=f.field_id  WHERE c.free = 1 AND syn.synonym IS NOT NULL AND syn.synonym LIKE '(2E)-oct-2-enal;(E)-2-Octen-1-al;(E)-Oct-2-enal;2-(E)-Octenal;2-trans-Octenal;Oct-(E)-2-enal;Oct-2(E)-enal;Octene-1-oxide;trans-2-Octen-1-al;trans-2-Octenal;trans-Oct-2-enal;trans-Octen-2-al' AND f.ftype IN (3,7,11,12,14) AND ci.sub_id_fk IN (SELECT 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  WHERE c.free = 1   )    LIMIT 50

Permalink

//zinc12.docking.org/results/combination?name.synonym=%282E%29-oct-2-enal%3B%28E%29-2-Octen-1-al%3B%28E%29-Oct-2-enal%3B2-%28E%29-Octenal%3B2-trans-Octenal%3BOct-%28E%29-2-enal%3BOct-2%28E%29-enal%3BOctene-1-oxide%3Btrans-2-Octen-1-al%3Btrans-2-Octenal%3Btrans-Oct-2-enal%3Btrans-Octen-2-al&filter.purchasability=all

Embed Link to Results