Warning: session_write_close() [function.session-write-close]: open(/tmp/session/sess_roplb8oqte74unoaie1q9bbmt1, 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
Search Results | ZINC Is Not Commercial - A database of commercially-available compounds
UCSF
ZINC Item Suppliers, Protomers, & Similar Substances

Analogs

539461
539461
5900656
5900656
13550666
13550666

Draw Identity 99% 90% 80% 70%

Popular Name: 6-hydroxy-2-[(4-phenylphenyl)methylene]benzofuran-3-one 6-hydroxy-2-[(4-phenylphenyl)met…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 4.53 0.52 -9.97 1 3 0 50 314.34 2 ↓

Analogs

5900656
5900656
6104823
6104823
13550666
13550666
539460
539460

Draw Identity 99% 90% 80% 70%

Popular Name: (2Z)-2-(1,1'-biphenyl-4-ylmethylene)-6-hydroxy-1-benzofuran-3(2H)-one (2Z)-2-(1,1'-biphenyl-4-ylmethyl…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 4.53 0.64 -9.66 1 3 0 50 314.34 2 ↓

Analogs

41431149
41431149
41431366
41431366
41436595
41436595
41437618
41437618
41506095
41506095

Draw Identity 99% 90% 80% 70%

Popular Name: (2Z)-6-hydroxy-7-methyl-2-[(4-phenylphenyl)methylene]benzofuran-3-one (2Z)-6-hydroxy-7-methyl-2-[(4-ph…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 5.37 9.77 -9.64 1 3 0 50 328.367 2 ↓
Hi High (pH 8-9.5) 5.37 10.53 -42.4 0 3 -1 53 327.359 2 ↓

Analogs

41431235
41431235
41431457
41431457
41436701
41436701
41437776
41437776
41506281
41506281

Draw Identity 99% 90% 80% 70%

Popular Name: (2E)-6-hydroxy-4-methyl-2-[(4-phenylphenyl)methylene]benzofuran-3-one (2E)-6-hydroxy-4-methyl-2-[(4-ph…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 4.90 9.53 -9.8 1 3 0 50 328.367 2 ↓
Hi High (pH 8-9.5) 4.90 10.3 -43.93 0 3 -1 53 327.359 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: [(2Z)-7-methyl-3-oxo-2-[(4-phenylphenyl)methylene]benzofuran-6-yl] [(2Z)-7-methyl-3-oxo-2-[(4-pheny…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 4.93 13.76 -12.23 0 4 0 57 370.404 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: [(2Z)-4-methyl-3-oxo-2-[(4-phenylphenyl)methylene]benzofuran-6-yl] [(2Z)-4-methyl-3-oxo-2-[(4-pheny…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 4.93 13.73 -12.24 0 4 0 57 370.404 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 2-[(2Z)-4-methyl-3-oxo-2-[(4-phenylphenyl)methylene]benzofuran-6-yl]oxyacetonitrile 2-[(2Z)-4-methyl-3-oxo-2-[(4-phe…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 5.22 12.52 -14.23 0 4 0 63 367.404 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 2-[(2Z)-7-methyl-3-oxo-2-[(4-phenylphenyl)methylene]benzofuran-6-yl]oxyacetamide 2-[(2Z)-7-methyl-3-oxo-2-[(4-phe…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 4.17 9.98 -17.75 2 5 0 83 385.419 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 2-[(2Z)-4-methyl-3-oxo-2-[(4-phenylphenyl)methylene]benzofuran-6-yl]oxyacetamide 2-[(2Z)-4-methyl-3-oxo-2-[(4-phe…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 4.17 9.93 -16.78 2 5 0 83 385.419 5 ↓

Analogs

41499031
41499031

Draw Identity 99% 90% 80% 70%

Popular Name: methyl methyl

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 5.66 14.09 -13.29 0 5 0 66 414.457 6 ↓

Analogs

41499027
41499027

Draw Identity 99% 90% 80% 70%

Popular Name: methyl methyl

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 5.66 14.1 -13.29 0 5 0 66 414.457 6 ↓

Analogs

41499439
41499439

Draw Identity 99% 90% 80% 70%

Popular Name: methyl methyl

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 5.66 14.04 -13.51 0 5 0 66 414.457 6 ↓

Analogs

41499435
41499435

Draw Identity 99% 90% 80% 70%

Popular Name: methyl methyl

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 5.66 14.04 -13.55 0 5 0 66 414.457 6 ↓

Analogs

41500095
41500095

Draw Identity 99% 90% 80% 70%

Popular Name: ethyl ethyl

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 6.04 15.01 -12.95 0 5 0 66 428.484 7 ↓

Analogs

41500091
41500091

Draw Identity 99% 90% 80% 70%

Popular Name: ethyl ethyl

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 6.04 15.03 -12.93 0 5 0 66 428.484 7 ↓

Analogs

41500508
41500508

Draw Identity 99% 90% 80% 70%

Popular Name: ethyl ethyl

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 6.04 14.96 -13.2 0 5 0 66 428.484 7 ↓

Analogs

41500504
41500504

Draw Identity 99% 90% 80% 70%

Popular Name: ethyl ethyl

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 6.04 14.98 -13.18 0 5 0 66 428.484 7 ↓

Analogs

41432296
41432296

Draw Identity 99% 90% 80% 70%

Popular Name: isopropyl isopropyl

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 6.04 15.13 -13.87 0 5 0 66 428.484 7 ↓

Analogs

41432392
41432392

Draw Identity 99% 90% 80% 70%

Popular Name: isopropyl isopropyl

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 6.04 15.08 -12.94 0 5 0 66 428.484 7 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: (2Z)-7-methyl-6-(3-methylbut-2-enoxy)-2-[(4-phenylphenyl)methylene]benzofuran-3-one (2Z)-7-methyl-6-(3-methylbut-2-e…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 7.12 14.87 -8.83 0 3 0 39 396.486 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: (2Z)-4-methyl-6-(3-methylbut-2-enoxy)-2-[(4-phenylphenyl)methylene]benzofuran-3-one (2Z)-4-methyl-6-(3-methylbut-2-e…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 7.12 14.75 -8.39 0 3 0 39 396.486 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: allyl allyl

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 5.95 14.99 -13.8 0 5 0 66 426.468 8 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: allyl allyl

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 5.95 14.94 -12.91 0 5 0 66 426.468 8 ↓

Analogs

41431149
41431149
41431366
41431366
41436595
41436595
41437618
41437618
41248319
41248319

Draw Identity 99% 90% 80% 70%

Popular Name: (2Z)-6-acetonyloxy-7-methyl-2-[(4-phenylphenyl)methylene]benzofuran-3-one (2Z)-6-acetonyloxy-7-methyl-2-[(…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 4.98 13.82 -15.82 0 4 0 57 384.431 5 ↓

Analogs

41431235
41431235
41431457
41431457
41436701
41436701
41437776
41437776
41248392
41248392

Draw Identity 99% 90% 80% 70%

Popular Name: (2Z)-6-acetonyloxy-4-methyl-2-[(4-phenylphenyl)methylene]benzofuran-3-one (2Z)-6-acetonyloxy-4-methyl-2-[(…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 4.98 13.76 -14.85 0 4 0 57 384.431 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: (2Z)-7-(dimethylaminomethyl)-6-hydroxy-4-methyl-2-[(4-phenylphenyl)methylene]benzofuran-3-one (2Z)-7-(dimethylaminomethyl)-6-h…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 5.10 11.6 -46.28 2 4 1 55 386.471 4 ↓
Mid Mid (pH 6-8) 5.10 12.56 -32.25 1 4 0 58 385.463 4 ↓

Analogs

41514617
41514617
41584458
41584458

Draw Identity 99% 90% 80% 70%

Popular Name: (2Z)-7-(diethylaminomethyl)-6-hydroxy-4-methyl-2-[(4-phenylphenyl)methylene]benzofuran-3-one (2Z)-7-(diethylaminomethyl)-6-hy…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 5.85 13.31 -41.91 2 4 1 55 414.525 6 ↓
Mid Mid (pH 6-8) 5.85 13.89 -28.3 1 4 0 58 413.517 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: (2E)-7-[(diisobutylamino)methyl]-6-hydroxy-4-methyl-2-[(4-phenylphenyl)methylene]benzofuran-3-one (2E)-7-[(diisobutylamino)methyl]…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 7.35 15.86 -38.35 2 4 1 55 470.633 8 ↓
Mid Mid (pH 6-8) 7.35 16.36 -29.56 1 4 0 58 469.625 8 ↓

Analogs

41584186
41584186
41513421
41513421

Draw Identity 99% 90% 80% 70%

Popular Name: (2Z)-7-[[butyl(methyl)amino]methyl]-6-hydroxy-4-methyl-2-[(4-phenylphenyl)methylene]benzofuran-3-one (2Z)-7-[[butyl(methyl)amino]meth…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 6.54 14.18 -46.13 2 4 1 55 428.552 7 ↓
Mid Mid (pH 6-8) 6.54 14.74 -29.76 1 4 0 58 427.544 7 ↓

Analogs

41584048
41584048
41513421
41513421

Draw Identity 99% 90% 80% 70%

Popular Name: (2E)-7-[(dibutylamino)methyl]-6-hydroxy-4-methyl-2-[(4-phenylphenyl)methylene]benzofuran-3-one (2E)-7-[(dibutylamino)methyl]-6-…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 7.98 16.19 -43.24 2 4 1 55 470.633 10 ↓
Mid Mid (pH 6-8) 7.98 16.73 -29.62 1 4 0 58 469.625 10 ↓

Analogs

41513164
41513164

Draw Identity 99% 90% 80% 70%

Popular Name: (2E)-7-[[bis(2-methoxyethyl)amino]methyl]-6-hydroxy-4-methyl-2-[(4-phenylphenyl)methylene]benzofuran (2E)-7-[[bis(2-methoxyethyl)amin…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 5.07 8.95 -10.59 1 6 0 72 473.569 10 ↓
Hi High (pH 8-9.5) 5.07 9.71 -50.21 0 6 -1 75 472.561 10 ↓
Mid Mid (pH 6-8) 5.07 11.94 -36.81 1 6 0 76 473.569 10 ↓

Analogs

41510674
41510674
41514617
41514617

Draw Identity 99% 90% 80% 70%

Popular Name: (2E)-7-[(dipropylamino)methyl]-6-hydroxy-4-methyl-2-[(4-phenylphenyl)methylene]benzofuran-3-one (2E)-7-[(dipropylamino)methyl]-6…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 6.86 14.63 -41.52 2 4 1 55 442.579 8 ↓
Mid Mid (pH 6-8) 6.86 15.21 -28.63 1 4 0 58 441.571 8 ↓

Parameters Provided:

ring.id = 221169
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 = 221169 AND c.free = 1 AND c.purchasable = 0    LIMIT 50

Permalink

//zinc12.docking.org/results/combination?ring.id=221169&filter.purchasability=annotated

Embed Link to Results