UCSF
ZINC Item Suppliers, Protomers, & Similar Substances

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-(2-aminoethyl)-N-(2-cyclopentylethyl)benzamide 3-(2-aminoethyl)-N-(2-cyclopenty…

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) 2.14 5.8 -49.1 4 3 1 57 261.389 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-amino-N-(2-cyclopentylethyl)-4-nitro-benzamide 3-amino-N-(2-cyclopentylethyl)-4…

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) 2.55 5.78 -9.46 3 6 0 101 277.324 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(2-cyclopentylethyl)-3-(methylamino)-4-nitro-benzamide N-(2-cyclopentylethyl)-3-(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) 2.93 6.74 -9.51 2 6 0 87 291.351 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(2-cyclopentylethyl)-3-hydrazino-4-nitro-benzamide N-(2-cyclopentylethyl)-3-hydrazi…

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) 2.31 5.49 -10.13 4 7 0 113 292.339 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(2-cyclopentylethyl)-3-fluoro-4-nitro-benzamide N-(2-cyclopentylethyl)-3-fluoro-…

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.23 7.73 -9.41 1 5 0 75 280.299 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(2-cyclopentylethyl)-2-(isopropylamino)benzamide N-(2-cyclopentylethyl)-2-(isopro…

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 7.64 -6.62 2 3 0 41 274.408 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(2-cyclopentylethyl)-4-(ethylamino)-3,5-difluoro-benzamide N-(2-cyclopentylethyl)-4-(ethyla…

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.60 6.67 -6.85 2 3 0 41 296.361 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 4-amino-N-(2-cyclopentylethyl)-3,5-difluoro-benzamide 4-amino-N-(2-cyclopentylethyl)-3…

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) 2.85 5.06 -7.17 3 3 0 55 268.307 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(2-cyclopentylethyl)-3,5-difluoro-4-(methylamino)benzamide N-(2-cyclopentylethyl)-3,5-diflu…

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.23 5.87 -7.13 2 3 0 41 282.334 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(2-cyclopentylethyl)-3,5-difluoro-4-hydrazino-benzamide N-(2-cyclopentylethyl)-3,5-diflu…

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) 2.61 4.88 -7.98 4 4 0 67 283.322 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(2-cyclopentylethyl)-3,4,5-trifluoro-benzamide N-(2-cyclopentylethyl)-3,4,5-tri…

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.53 7.18 -7.2 1 2 0 29 271.282 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(2-cyclopentylethyl)-2,4-dimethyl-5-sulfamoyl-benzamide N-(2-cyclopentylethyl)-2,4-dimet…

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) 2.63 3.33 -11.92 3 5 0 89 324.446 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(2-cyclopentylethyl)-2-methyl-5-nitro-benzamide N-(2-cyclopentylethyl)-2-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) 3.52 8.37 -7.31 1 5 0 75 276.336 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(2-cyclopentylethyl)-4-(dimethylamino)-3-fluoro-benzamide N-(2-cyclopentylethyl)-4-(dimeth…

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.38 7.92 -6.57 1 3 0 32 278.371 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 4-chloro-N-(2-cyclopentylethyl)-3-nitro-benzamide 4-chloro-N-(2-cyclopentylethyl)-…

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.75 8.07 -13.94 1 5 0 75 296.754 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 2-bromo-N-(2-cyclopentylethyl)benzamide 2-bromo-N-(2-cyclopentylethyl)be…

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.95 7.62 -8.98 1 2 0 29 296.208 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 4-bromo-N-(2-cyclopentylethyl)benzamide 4-bromo-N-(2-cyclopentylethyl)be…

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.99 7.62 -7.04 1 2 0 29 296.208 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(2-cyclopentylethyl)-4-fluoro-benzamide N-(2-cyclopentylethyl)-4-fluoro-…

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.35 7.07 -7.48 1 2 0 29 235.302 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 2-chloro-N-(2-cyclopentylethyl)-5-nitro-benzamide 2-chloro-N-(2-cyclopentylethyl)-…

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.75 8.22 -7.61 1 5 0 75 296.754 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(2-cyclopentylethyl)-2-fluoro-benzamide N-(2-cyclopentylethyl)-2-fluoro-…

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.30 7.07 -12.12 1 2 0 29 235.302 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-bromo-N-(2-cyclopentylethyl)benzamide 3-bromo-N-(2-cyclopentylethyl)be…

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.97 7.62 -6.16 1 2 0 29 296.208 4 ↓

Analogs

31986041
31986041

Draw Identity 99% 90% 80% 70%

Popular Name: 4-cyano-N-(2-cyclopentylethyl)benzamide 4-cyano-N-(2-cyclopentylethyl)be…

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) 2.94 7.39 -9.85 1 3 0 53 242.322 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-chloro-N-(2-cyclopentylethyl)-2-nitro-benzamide 5-chloro-N-(2-cyclopentylethyl)-…

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.75 8.9 -12.07 1 5 0 75 296.754 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(2-cyclopentylethyl)-2-hydroxy-3-methyl-benzamide N-(2-cyclopentylethyl)-2-hydroxy…

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 6.25 -9.85 2 3 0 49 247.338 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(2-cyclopentylethyl)-2-hydroxy-3-methoxy-benzamide N-(2-cyclopentylethyl)-2-hydroxy…

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.28 5.3 -12.48 2 4 0 59 263.337 5 ↓
Hi High (pH 8-9.5) 3.28 6.37 -58.75 1 4 -1 61 262.329 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-cyano-N-(2-cyclopentylethyl)benzamide 3-cyano-N-(2-cyclopentylethyl)be…

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) 2.92 7.39 -12.43 1 3 0 53 242.322 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3,4-dichloro-N-(2-cyclopentylethyl)-5-nitro-benzamide 3,4-dichloro-N-(2-cyclopentyleth…

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.36 8.53 -9.58 1 5 0 75 331.199 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 4-chloro-N-(2-cyclopentylethyl)-2-hydroxy-benzamide 4-chloro-N-(2-cyclopentylethyl)-…

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 6.06 -8.92 2 3 0 49 267.756 4 ↓
Hi High (pH 8-9.5) 4.33 7.07 -50.74 1 3 -1 52 266.748 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 4-bromo-N-(2-cyclopentylethyl)-3-nitro-benzamide 4-bromo-N-(2-cyclopentylethyl)-3…

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.88 8.15 -13.73 1 5 0 75 341.205 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-bromo-N-(2-cyclopentylethyl)-2-fluoro-benzamide 5-bromo-N-(2-cyclopentylethyl)-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.09 7.7 -8.73 1 2 0 29 314.198 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(2-cyclopentylethyl)-4-fluoro-3-nitro-benzamide N-(2-cyclopentylethyl)-4-fluoro-…

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.24 7.73 -15.03 1 5 0 75 280.299 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 2-bromo-N-(2-cyclopentylethyl)-4-fluoro-benzamide 2-bromo-N-(2-cyclopentylethyl)-4…

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.09 7.69 -8.02 1 2 0 29 314.198 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 2-bromo-N-(2-cyclopentylethyl)-5-fluoro-benzamide 2-bromo-N-(2-cyclopentylethyl)-5…

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.09 7.69 -6.52 1 2 0 29 314.198 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 4-bromo-N-(2-cyclopentylethyl)-2-fluoro-benzamide 4-bromo-N-(2-cyclopentylethyl)-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.09 7.7 -10.16 1 2 0 29 314.198 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(2-cyclopentylethyl)-2-(methylamino)benzamide N-(2-cyclopentylethyl)-2-(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) 2.99 6.17 -6.85 2 3 0 41 246.354 5 ↓

Parameters Provided:

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

Permalink

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

Embed Link to Results