UCSF
ZINC Item Suppliers, Protomers, & Similar Substances

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(1-cyclopentyl-4-piperidyl)methyl]-4-methoxy-benzamide N-[(1-cyclopentyl-4-piperidyl)me…

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.39 8.79 -47.11 2 4 1 43 317.453 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(1-cyclopentyl-4-piperidyl)methyl]-3,5-dimethoxy-benzamide N-[(1-cyclopentyl-4-piperidyl)me…

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.83 -46.04 2 5 1 52 347.479 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(1-cyclopentyl-4-piperidyl)methyl]-3,4,5-trimethoxy-benzamide N-[(1-cyclopentyl-4-piperidyl)me…

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.97 8.63 -50.92 2 6 1 61 377.505 7 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(1-cyclopentyl-4-piperidyl)methyl]-2-methyl-benzamide N-[(1-cyclopentyl-4-piperidyl)me…

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.73 9.89 -43.81 2 3 1 34 301.454 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(1-cyclopentyl-4-piperidyl)methyl]-3-nitro-benzamide N-[(1-cyclopentyl-4-piperidyl)me…

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.27 9.85 -56.44 2 6 1 79 332.424 5 ↓

Analogs

39563974
39563974

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(1-cyclopentyl-4-piperidyl)methyl]-4-nitro-benzamide N-[(1-cyclopentyl-4-piperidyl)me…

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.29 10.14 -50.81 2 6 1 79 332.424 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(1-cyclopentyl-4-piperidyl)methyl]-2,3-dimethoxy-benzamide N-[(1-cyclopentyl-4-piperidyl)me…

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.70 9.78 -50.37 2 5 1 52 347.479 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(1-cyclopentyl-4-piperidyl)methyl]-4-ethyl-benzamide N-[(1-cyclopentyl-4-piperidyl)me…

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.25 10.9 -44.97 2 3 1 34 315.481 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(1-cyclopentyl-4-piperidyl)methyl]-2-methyl-3-nitro-benzamide N-[(1-cyclopentyl-4-piperidyl)me…

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.65 10.38 -55.31 2 6 1 79 346.451 5 ↓

Analogs

36236457
36236457

Draw Identity 99% 90% 80% 70%

Popular Name: 5-chloro-N-[(1-cyclopentyl-4-piperidyl)methyl]-2-nitro-benzamide 5-chloro-N-[(1-cyclopentyl-4-pip…

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.90 11.67 -51.64 2 6 1 79 366.869 5 ↓

Analogs

44503784
44503784
21800316
21800316
21800319
21800319

Draw Identity 99% 90% 80% 70%

Popular Name: 2-chloro-N-[(1-cyclopentyl-4-piperidyl)methyl]-5-nitro-benzamide 2-chloro-N-[(1-cyclopentyl-4-pip…

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.90 10.37 -44.74 2 6 1 79 366.869 5 ↓

Analogs

39563970
39563970

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(1-cyclopentyl-4-piperidyl)methyl]-3-methyl-4-nitro-benzamide N-[(1-cyclopentyl-4-piperidyl)me…

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.67 10.74 -50.08 2 6 1 79 346.451 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(1-cyclopentyl-4-piperidyl)methyl]-4-(trifluoromethyl)benzamide N-[(1-cyclopentyl-4-piperidyl)me…

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.23 10.47 -46.58 2 3 1 34 355.424 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-chloro-N-[(1-cyclopentyl-4-piperidyl)methyl]-2-methoxy-benzamide 5-chloro-N-[(1-cyclopentyl-4-pip…

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.54 10.3 -44.9 2 4 1 43 351.898 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(1-cyclopentyl-4-piperidyl)methyl]-2-fluoro-benzamide N-[(1-cyclopentyl-4-piperidyl)me…

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.45 9.54 -49.84 2 3 1 34 305.417 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(1-cyclopentyl-4-piperidyl)methyl]-3-fluoro-benzamide N-[(1-cyclopentyl-4-piperidyl)me…

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.47 9.53 -42.85 2 3 1 34 305.417 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(1-cyclopentyl-4-piperidyl)methyl]-4,5-dimethoxy-2-nitro-benzamide N-[(1-cyclopentyl-4-piperidyl)me…

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.87 10.42 -56.52 2 8 1 98 392.476 7 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(1-cyclopentyl-4-piperidyl)methyl]-2-nitro-benzamide N-[(1-cyclopentyl-4-piperidyl)me…

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 10.81 -53.99 2 6 1 79 332.424 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(1-cyclopentyl-4-piperidyl)methyl]-2-methoxy-benzamide N-[(1-cyclopentyl-4-piperidyl)me…

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.89 9.77 -47.61 2 4 1 43 317.453 5 ↓

Analogs

37846349
37846349

Draw Identity 99% 90% 80% 70%

Popular Name: 3-bromo-N-[(1-cyclopentyl-4-piperidyl)methyl]benzamide 3-bromo-N-[(1-cyclopentyl-4-pipe…

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.12 10.09 -42.41 2 3 1 34 366.323 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 4-bromo-N-[(1-cyclopentyl-4-piperidyl)methyl]benzamide 4-bromo-N-[(1-cyclopentyl-4-pipe…

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.14 10.09 -45.45 2 3 1 34 366.323 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 2-chloro-N-[(1-cyclopentyl-4-piperidyl)methyl]benzamide 2-chloro-N-[(1-cyclopentyl-4-pip…

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.96 9.98 -46.77 2 3 1 34 321.872 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-chloro-N-[(1-cyclopentyl-4-piperidyl)methyl]benzamide 3-chloro-N-[(1-cyclopentyl-4-pip…

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 9.98 -42.57 2 3 1 34 321.872 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(1-cyclopentyl-4-piperidyl)methyl]-3,4-dimethyl-benzamide N-[(1-cyclopentyl-4-piperidyl)me…

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.16 10.79 -45.24 2 3 1 34 315.481 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(1-cyclopentyl-4-piperidyl)methyl]-4-ethoxy-benzamide N-[(1-cyclopentyl-4-piperidyl)me…

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.77 9.72 -47.02 2 4 1 43 331.48 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(1-cyclopentyl-4-piperidyl)methyl]-3,4,5-triethoxy-benzamide N-[(1-cyclopentyl-4-piperidyl)me…

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 11.15 -50.61 2 6 1 61 419.586 10 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 2-bromo-N-[(1-cyclopentyl-4-piperidyl)methyl]benzamide 2-bromo-N-[(1-cyclopentyl-4-pipe…

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 10.09 -46.18 2 3 1 34 366.323 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(1-cyclopentyl-4-piperidyl)methyl]-3,4-dimethoxy-benzamide N-[(1-cyclopentyl-4-piperidyl)me…

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.98 8.71 -50.04 2 5 1 52 347.479 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(1-cyclopentyl-4-piperidyl)methyl]-4-methyl-3-nitro-benzamide N-[(1-cyclopentyl-4-piperidyl)me…

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.67 10.4 -56.6 2 6 1 79 346.451 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 4-chloro-N-[(1-cyclopentyl-4-piperidyl)methyl]-3-nitro-benzamide 4-chloro-N-[(1-cyclopentyl-4-pip…

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.90 10.5 -56.83 2 6 1 79 366.869 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(1-cyclopentyl-4-piperidyl)methyl]benzamide N-[(1-cyclopentyl-4-piperidyl)me…

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.33 9.46 -45.2 2 3 1 34 287.427 4 ↓

Analogs

39563969
39563969

Draw Identity 99% 90% 80% 70%

Popular Name: 2-chloro-N-[(1-cyclopentyl-4-piperidyl)methyl]-4-nitro-benzamide 2-chloro-N-[(1-cyclopentyl-4-pip…

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.90 10.37 -52.23 2 6 1 79 366.869 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(1-cyclopentyl-4-piperidyl)methyl]-4-methyl-benzamide N-[(1-cyclopentyl-4-piperidyl)me…

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.78 10.13 -45.17 2 3 1 34 301.454 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3,5-dichloro-N-[(1-cyclopentyl-4-piperidyl)methyl]benzamide 3,5-dichloro-N-[(1-cyclopentyl-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.62 10.42 -41.91 2 3 1 34 356.317 4 ↓

Parameters Provided:

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

Permalink

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

Embed Link to Results