UCSF
ZINC Item Suppliers, Protomers, & Similar Substances

Analogs

5726822
5726822
5727503
5727503
6223060
6223060
6223061
6223061
6223062
6223062

Draw Identity 99% 90% 80% 70%

Popular Name: N-benzyl-N-(3-nitrophenyl)-2-phenoxy-acetamide N-benzyl-N-(3-nitrophenyl)-2-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.38 13.35 -13.85 0 6 0 75 362.385 7 ↓

Analogs

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.70 14.67 -11.7 0 5 0 56 472.368 9 ↓

Analogs

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.72 15.32 -15.91 0 5 0 56 472.368 9 ↓

Analogs

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.65 14.71 -11.65 0 5 0 56 472.368 9 ↓

Analogs

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.67 14.67 -11.99 0 5 0 56 472.368 9 ↓

Analogs

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.67 15.36 -15.67 0 5 0 56 472.368 9 ↓

Analogs

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.70 15.32 -16.12 0 5 0 56 472.368 9 ↓

Analogs

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) 7.05 15.27 -11.67 0 5 0 56 486.395 9 ↓

Analogs

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) 7.07 15.38 -11.59 0 5 0 56 486.395 9 ↓

Analogs

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) 7.16 16.2 -12.92 0 5 0 56 486.395 10 ↓

Analogs

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) 7.07 15.21 -12.04 0 5 0 56 486.395 9 ↓

Analogs

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) 7.07 15.34 -11.87 0 5 0 56 486.395 9 ↓

Analogs

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) 7.10 16.02 -15.64 0 5 0 56 486.395 9 ↓

Analogs

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) 7.19 16.06 -18.22 0 5 0 56 486.395 10 ↓

Analogs

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) 7.10 15.86 -16.09 0 5 0 56 486.395 9 ↓

Analogs

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) 7.07 15.91 -15.69 0 5 0 56 486.395 9 ↓

Analogs

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) 7.10 15.97 -15.93 0 5 0 56 486.395 9 ↓

Analogs

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.33 13.93 -16.86 0 6 0 65 488.367 10 ↓

Analogs

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.30 13.28 -12.62 0 6 0 65 488.367 10 ↓

Analogs

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.95 15.15 -16.27 0 5 0 56 492.786 9 ↓

Analogs

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.90 15.17 -18.64 0 5 0 56 492.786 9 ↓

Analogs

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.93 14.52 -11.5 0 5 0 56 492.786 9 ↓

Analogs

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.88 14.53 -13.78 0 5 0 56 492.786 9 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 2-[2-(benzyl-phenyl-amino)-2-oxo-ethoxy]benzoic 2-[2-(benzyl-phenyl-amino)-2-oxo…

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.39 12.81 -72.9 0 5 -1 70 360.389 7 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 4-[2-(benzyl-phenyl-amino)-2-oxo-ethoxy]benzoic 4-[2-(benzyl-phenyl-amino)-2-oxo…

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.35 12.32 -53.59 0 5 -1 70 360.389 7 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-[2-(benzyl-phenyl-amino)-2-oxo-ethoxy]benzoic 3-[2-(benzyl-phenyl-amino)-2-oxo…

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.33 12.3 -60.85 0 5 -1 70 360.389 7 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 4-[2-(benzyl-phenyl-amino)-2-oxo-ethoxy]-3-methoxy-benzoic 4-[2-(benzyl-phenyl-amino)-2-oxo…

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) 3.94 12.07 -54.7 0 6 -1 79 390.415 8 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 2-[4-[2-(benzyl-phenyl-amino)-2-oxo-ethoxy]phenyl]acetic 2-[4-[2-(benzyl-phenyl-amino)-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) 3.87 13.12 -52.36 0 5 -1 70 374.416 8 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 4-[2-(benzyl-phenyl-amino)-2-oxo-ethoxy]benzene-1,3-dicarboxylic 4-[2-(benzyl-phenyl-amino)-2-oxo…

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.27 12.44 -129.1 0 7 -2 110 403.39 8 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-benzyl-2-(2-fluoro-4-nitro-phenoxy)-N-phenyl-acetamide N-benzyl-2-(2-fluoro-4-nitro-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.49 13.45 -13.9 0 6 0 75 380.375 7 ↓

Analogs

6223062
6223062
6223063
6223063

Draw Identity 99% 90% 80% 70%

Popular Name: N-benzyl-2-(2,5-dichlorophenoxy)-N-(3-nitrophenyl)acetamide N-benzyl-2-(2,5-dichlorophenoxy)…

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 2.69 -13.63 0 6 0 75 431.275 7 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 2-[4-[benzyl-(2-phenoxyacetyl)amino]phenyl]-N-(2-methoxyethyl)acetamide 2-[4-[benzyl-(2-phenoxyacetyl)am…

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) 3.71 10.58 -19.46 1 6 0 68 432.52 11 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 2-[4-[benzyl-(2-phenoxyacetyl)amino]phenyl]-N-isopropyl-acetamide 2-[4-[benzyl-(2-phenoxyacetyl)am…

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.40 12.3 -19.33 1 5 0 59 416.521 9 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 2-[4-[benzyl-(2-phenoxyacetyl)amino]phenyl]-N-ethyl-acetamide 2-[4-[benzyl-(2-phenoxyacetyl)am…

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.10 11.5 -19.41 1 5 0 59 402.494 9 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 2-[4-[benzyl-(2-phenoxyacetyl)amino]phenyl]-N-(2-dimethylaminoethyl)acetamide 2-[4-[benzyl-(2-phenoxyacetyl)am…

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) 3.76 12.79 -53.27 2 6 1 63 446.571 11 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-methyl-2-[3-[(2-phenoxyacetyl)-(p-tolylmethyl)amino]phenyl]-N-propyl-acetamide N-methyl-2-[3-[(2-phenoxyacetyl)…

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.27 15.04 -20.31 0 5 0 50 444.575 10 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 2-[3-[benzyl-(2-phenoxyacetyl)amino]phenyl]-N-isobutyl-acetamide 2-[3-[benzyl-(2-phenoxyacetyl)am…

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.82 13 -19.3 1 5 0 59 430.548 10 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 2-[3-[benzyl-(2-phenoxyacetyl)amino]phenyl]acetic 2-[3-[benzyl-(2-phenoxyacetyl)am…

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) 3.84 13.24 -65.14 0 5 -1 70 374.416 8 ↓

Parameters Provided:

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

Permalink

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

Embed Link to Results