Warning: session_write_close() [function.session-write-close]: open(/tmp/session/sess_k2pbgekp9chkt74dev3jmoovn6, 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

Draw Identity 99% 90% 80% 70%

Popular Name: 3-(4-aminophenyl)-N-(1-ethyl-4-piperidyl)propanamide 3-(4-aminophenyl)-N-(1-ethyl-4-p…

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) 1.61 6.17 -39.46 4 4 1 60 276.404 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-(2-bromophenyl)-N-[1-[2-oxo-2-(propylamino)ethyl]-4-piperidyl]propanamide 3-(2-bromophenyl)-N-[1-[2-oxo-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.41 8.08 -43.45 3 5 1 63 411.364 8 ↓
Mid Mid (pH 6-8) 3.41 5.9 -11.91 2 5 0 61 410.356 8 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-methyl-N-(4-piperidyl)-3-(p-tolyl)propanamide N-methyl-N-(4-piperidyl)-3-(p-to…

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.26 7.87 -45.65 2 3 1 37 261.389 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-ethyl-N-(4-piperidyl)-3-(p-tolyl)propanamide N-ethyl-N-(4-piperidyl)-3-(p-tol…

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 8.85 -38.61 2 3 1 37 275.416 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(4-piperidyl)-N-propyl-3-(p-tolyl)propanamide N-(4-piperidyl)-N-propyl-3-(p-to…

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.14 9.61 -38.65 2 3 1 37 289.443 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: (2R)-2-amino-N-(1-ethyl-4-piperidyl)-N-methyl-3-phenyl-propanamide (2R)-2-amino-N-(1-ethyl-4-piperi…

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) 1.13 7.25 -91.09 4 4 2 52 291.439 5 ↓
Mid Mid (pH 6-8) 1.13 6.93 -40.95 3 4 1 51 290.431 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: (2S)-2-amino-N-(1-ethyl-4-piperidyl)-N-methyl-3-phenyl-propanamide (2S)-2-amino-N-(1-ethyl-4-piperi…

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) 1.13 7.23 -90.83 4 4 2 52 291.439 5 ↓
Mid Mid (pH 6-8) 1.13 6.93 -40.77 3 4 1 51 290.431 5 ↓

Analogs

40829695
40829695
40829696
40829696

Draw Identity 99% 90% 80% 70%

Popular Name: (3S)-3-amino-N-(1-ethyl-4-piperidyl)-N-methyl-3-phenyl-propanamide (3S)-3-amino-N-(1-ethyl-4-piperi…

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) -0.16 7.54 -88.1 4 4 2 52 291.439 5 ↓
Hi High (pH 8-9.5) -0.16 7.22 -39.4 3 4 1 51 290.431 5 ↓

Analogs

40829695
40829695
40829696
40829696

Draw Identity 99% 90% 80% 70%

Popular Name: (3R)-3-amino-N-(1-ethyl-4-piperidyl)-N-methyl-3-phenyl-propanamide (3R)-3-amino-N-(1-ethyl-4-piperi…

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) -0.16 7.54 -88.48 4 4 2 52 291.439 5 ↓
Hi High (pH 8-9.5) -0.16 7.18 -39.21 3 4 1 51 290.431 5 ↓

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) 0.83 6.9 -19.94 2 7 0 88 375.469 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) 0.83 6.95 -19.22 2 7 0 88 375.469 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) 1.06 6.76 -19.76 2 7 0 88 395.887 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) 1.06 6.81 -19.09 2 7 0 88 395.887 7 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[1-(2,2-difluoroethyl)-4-piperidyl]-3-(2,5-difluorophenyl)propanamide N-[1-(2,2-difluoroethyl)-4-piper…

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 8.63 -43.39 2 3 1 34 333.349 6 ↓
Mid Mid (pH 6-8) 2.99 6.51 -10.41 1 3 0 32 332.341 6 ↓

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) 2.62 6.74 -12.6 1 6 0 68 334.416 7 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(1-isopropyl-4-piperidyl)-N-methyl-3-(2,3,4-trimethoxyphenyl)propanamide N-(1-isopropyl-4-piperidyl)-N-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.91 9.78 -42.16 1 6 1 52 379.521 8 ↓

Analogs

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) 2.24 6.54 -14.41 1 5 0 59 326.343 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-(4-ethoxyphenyl)-N-methyl-N-(1-methyl-4-piperidyl)propanamide 3-(4-ethoxyphenyl)-N-methyl-N-(1…

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.84 9.65 -42.23 1 4 1 34 305.442 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: (2S)-3-(3-fluorophenyl)-2-methyl-N-[1-[2-(methylamino)-2-oxo-ethyl]-4-piperidyl]propanamide (2S)-3-(3-fluorophenyl)-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.14 6.54 -44.82 3 5 1 63 336.431 6 ↓
Mid Mid (pH 6-8) 2.14 4.37 -12.42 2 5 0 61 335.423 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: (2S)-N-(2-dimethylaminoethyl)-3-(3-fluorophenyl)-2-methyl-N-(1-methyl-4-piperidyl)propanamide (2S)-N-(2-dimethylaminoethyl)-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.80 12.07 -96.76 2 4 2 29 351.51 7 ↓
Hi High (pH 8-9.5) 2.80 9.61 -35.76 1 4 1 28 350.502 7 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: (2R)-N-(2-dimethylaminoethyl)-3-(3-fluorophenyl)-2-methyl-N-(1-methyl-4-piperidyl)propanamide (2R)-N-(2-dimethylaminoethyl)-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.80 11.68 -94.87 2 4 2 29 351.51 7 ↓
Hi High (pH 8-9.5) 2.80 9.21 -35.55 1 4 1 28 350.502 7 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: (3S)-N-(2-dimethylaminoethyl)-3-(2-fluorophenyl)-N-(1-methyl-4-piperidyl)butanamide (3S)-N-(2-dimethylaminoethyl)-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.63 12.16 -95.1 2 4 2 29 351.51 7 ↓
Hi High (pH 8-9.5) 2.63 9.7 -36.21 1 4 1 28 350.502 7 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: (3R)-N-(2-dimethylaminoethyl)-3-(2-fluorophenyl)-N-(1-methyl-4-piperidyl)butanamide (3R)-N-(2-dimethylaminoethyl)-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.63 12.16 -97.97 2 4 2 29 351.51 7 ↓
Hi High (pH 8-9.5) 2.63 9.7 -35.58 1 4 1 28 350.502 7 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(1-methyl-4-piperidyl)-3-[2-(trifluoromethoxy)phenyl]propanamide N-(1-methyl-4-piperidyl)-3-[2-(t…

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.08 7.48 -41.19 2 4 1 43 331.358 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(1-ethyl-4-piperidyl)-3-[2-(trifluoromethoxy)phenyl]propanamide N-(1-ethyl-4-piperidyl)-3-[2-(tr…

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.46 8.14 -39.77 2 4 1 43 345.385 7 ↓

Analogs

42690493
42690493

Draw Identity 99% 90% 80% 70%

Popular Name: 3-(2-aminophenyl)-N-methyl-N-(1-methyl-4-piperidyl)propanamide 3-(2-aminophenyl)-N-methyl-N-(1-…

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) 1.84 7.37 -41.2 3 4 1 51 276.404 4 ↓

Analogs

42690494
42690494

Draw Identity 99% 90% 80% 70%

Popular Name: 3-(3-aminophenyl)-N-methyl-N-(1-methyl-4-piperidyl)propanamide 3-(3-aminophenyl)-N-methyl-N-(1-…

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) 1.46 7.28 -41.45 3 4 1 51 276.404 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-(4-aminophenyl)-N-methyl-N-(1-methyl-4-piperidyl)propanamide 3-(4-aminophenyl)-N-methyl-N-(1-…

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) 1.48 7.29 -41.34 3 4 1 51 276.404 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-methyl-3-phenyl-N-(2,2,6,6-tetramethyl-4-piperidyl)butanamide 3-methyl-3-phenyl-N-(2,2,6,6-tet…

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.26 8.46 -38.9 3 3 1 46 317.497 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-(4-aminophenyl)-N-(1-propyl-4-piperidyl)propanamide 3-(4-aminophenyl)-N-(1-propyl-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.12 6.91 -40.16 4 4 1 60 290.431 6 ↓

Analogs

42690494
42690494

Draw Identity 99% 90% 80% 70%

Popular Name: 3-(3-aminophenyl)-N-(1-propyl-4-piperidyl)propanamide 3-(3-aminophenyl)-N-(1-propyl-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.09 6.9 -40.25 4 4 1 60 290.431 6 ↓

Analogs

42690493
42690493

Draw Identity 99% 90% 80% 70%

Popular Name: 3-(2-aminophenyl)-N-(1-propyl-4-piperidyl)propanamide 3-(2-aminophenyl)-N-(1-propyl-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.47 6.99 -40.02 4 4 1 60 290.431 6 ↓

Parameters Provided:

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

Permalink

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

Embed Link to Results