Warning: session_write_close() [function.session-write-close]: open(/tmp/session/sess_0041535fkbb6udnp1j8l003am0, 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: N-[2-[(2S,6R)-2,6-dimethylmorpholin-4-yl]ethyl]tetrahydropyran-4-amine N-[2-[(2S,6R)-2,6-dimethylmorpho…

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.07 2.21 -42.91 2 4 1 38 243.371 4 ↓
Hi High (pH 8-9.5) 1.07 1.04 -3.52 1 4 0 34 242.363 4 ↓
Lo Low (pH 4.5-6) 1.07 4.48 -122.97 3 4 2 40 244.379 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[2-[(2S,6S)-2,6-dimethylmorpholin-4-yl]ethyl]tetrahydropyran-4-amine N-[2-[(2S,6S)-2,6-dimethylmorpho…

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.07 2.51 -42.87 2 4 1 38 243.371 4 ↓
Hi High (pH 8-9.5) 1.07 1.33 -3.23 1 4 0 34 242.363 4 ↓
Lo Low (pH 4.5-6) 1.07 4.43 -122.29 3 4 2 40 244.379 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[2-[(2R,6R)-2,6-dimethylmorpholin-4-yl]ethyl]tetrahydropyran-4-amine N-[2-[(2R,6R)-2,6-dimethylmorpho…

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.07 2.5 -42.92 2 4 1 38 243.371 4 ↓
Hi High (pH 8-9.5) 1.07 1.32 -3.23 1 4 0 34 242.363 4 ↓
Lo Low (pH 4.5-6) 1.07 4.45 -122.29 3 4 2 40 244.379 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[2-[(2R)-2-methylmorpholin-4-yl]ethyl]tetrahydropyran-4-amine N-[2-[(2R)-2-methylmorpholin-4-y…

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.71 1.46 -42.53 2 4 1 38 229.344 4 ↓
Hi High (pH 8-9.5) 0.71 0.29 -3.54 1 4 0 34 228.336 4 ↓
Lo Low (pH 4.5-6) 0.71 3.74 -121.37 3 4 2 40 230.352 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[2-[(2S)-2-methylmorpholin-4-yl]ethyl]tetrahydropyran-4-amine N-[2-[(2S)-2-methylmorpholin-4-y…

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.71 1.47 -42.54 2 4 1 38 229.344 4 ↓
Hi High (pH 8-9.5) 0.71 0.3 -3.7 1 4 0 34 228.336 4 ↓
Lo Low (pH 4.5-6) 0.71 3.75 -121.49 3 4 2 40 230.352 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[2-[(3R)-3-methylmorpholin-4-yl]ethyl]tetrahydropyran-4-amine N-[2-[(3R)-3-methylmorpholin-4-y…

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.68 1.32 -42.49 2 4 1 38 229.344 4 ↓
Hi High (pH 8-9.5) 0.68 0.14 -3.37 1 4 0 34 228.336 4 ↓
Lo Low (pH 4.5-6) 0.68 3.51 -118.26 3 4 2 40 230.352 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[2-[(3S)-3-methylmorpholin-4-yl]ethyl]tetrahydropyran-4-amine N-[2-[(3S)-3-methylmorpholin-4-y…

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.68 1.33 -42.49 2 4 1 38 229.344 4 ↓
Hi High (pH 8-9.5) 0.68 0.15 -3.65 1 4 0 34 228.336 4 ↓
Lo Low (pH 4.5-6) 0.68 3.52 -118.25 3 4 2 40 230.352 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[2-[(2R,5R)-2,5-dimethylmorpholin-4-yl]ethyl]tetrahydropyran-4-amine N-[2-[(2R,5R)-2,5-dimethylmorpho…

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.04 1.91 -42.77 2 4 1 38 243.371 4 ↓
Hi High (pH 8-9.5) 1.04 0.75 -3.36 1 4 0 34 242.363 4 ↓
Lo Low (pH 4.5-6) 1.04 4.09 -121 3 4 2 40 244.379 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[2-[(2S,5R)-2,5-dimethylmorpholin-4-yl]ethyl]tetrahydropyran-4-amine N-[2-[(2S,5R)-2,5-dimethylmorpho…

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.04 2.07 -42.89 2 4 1 38 243.371 4 ↓
Hi High (pH 8-9.5) 1.04 0.89 -3.41 1 4 0 34 242.363 4 ↓
Lo Low (pH 4.5-6) 1.04 4.26 -119.69 3 4 2 40 244.379 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[2-[(2R)-2-ethylmorpholin-4-yl]ethyl]tetrahydropyran-4-amine N-[2-[(2R)-2-ethylmorpholin-4-yl…

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.21 2.3 -42.43 2 4 1 38 243.371 5 ↓
Hi High (pH 8-9.5) 1.21 1.13 -3.32 1 4 0 34 242.363 5 ↓
Lo Low (pH 4.5-6) 1.21 4.56 -122.42 3 4 2 40 244.379 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[2-[(2S)-2-ethylmorpholin-4-yl]ethyl]tetrahydropyran-4-amine N-[2-[(2S)-2-ethylmorpholin-4-yl…

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.21 2.31 -42.48 2 4 1 38 243.371 5 ↓
Hi High (pH 8-9.5) 1.21 1.14 -3.49 1 4 0 34 242.363 5 ↓
Lo Low (pH 4.5-6) 1.21 4.58 -122.52 3 4 2 40 244.379 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[2-(2,2-dimethylmorpholin-4-yl)ethyl]tetrahydropyran-4-amine N-[2-(2,2-dimethylmorpholin-4-yl…

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.16 2.39 -42.78 2 4 1 38 243.371 4 ↓
Hi High (pH 8-9.5) 1.16 1.22 -3.54 1 4 0 34 242.363 4 ↓
Lo Low (pH 4.5-6) 1.16 4.35 -122.25 3 4 2 40 244.379 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[2-[(3R)-3-ethylmorpholin-4-yl]ethyl]tetrahydropyran-4-amine N-[2-[(3R)-3-ethylmorpholin-4-yl…

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.21 1.97 -42.74 2 4 1 38 243.371 5 ↓
Hi High (pH 8-9.5) 1.21 0.78 -3.25 1 4 0 34 242.363 5 ↓
Lo Low (pH 4.5-6) 1.21 4.12 -120.22 3 4 2 40 244.379 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[2-[(3S)-3-ethylmorpholin-4-yl]ethyl]tetrahydropyran-4-amine N-[2-[(3S)-3-ethylmorpholin-4-yl…

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.21 1.99 -42.82 2 4 1 38 243.371 5 ↓
Hi High (pH 8-9.5) 1.21 0.81 -3.5 1 4 0 34 242.363 5 ↓
Lo Low (pH 4.5-6) 1.21 4.14 -120.27 3 4 2 40 244.379 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[2-[(6R)-2,2,6-trimethylmorpholin-4-yl]ethyl]tetrahydropyran-4-amine N-[2-[(6R)-2,2,6-trimethylmorpho…

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.52 3.12 -43.21 2 4 1 38 257.398 4 ↓
Hi High (pH 8-9.5) 1.52 1.95 -3.56 1 4 0 34 256.39 4 ↓
Lo Low (pH 4.5-6) 1.52 5.08 -123.7 3 4 2 40 258.406 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[2-[(6S)-2,2,6-trimethylmorpholin-4-yl]ethyl]tetrahydropyran-4-amine N-[2-[(6S)-2,2,6-trimethylmorpho…

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.52 3.11 -43.13 2 4 1 38 257.398 4 ↓
Hi High (pH 8-9.5) 1.52 1.94 -3.35 1 4 0 34 256.39 4 ↓
Lo Low (pH 4.5-6) 1.52 5.08 -123.74 3 4 2 40 258.406 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[2-[(2R,5R)-5-ethyl-2-methyl-morpholin-4-yl]ethyl]tetrahydropyran-4-amine N-[2-[(2R,5R)-5-ethyl-2-methyl-m…

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.58 2.99 -43.16 2 4 1 38 257.398 5 ↓
Hi High (pH 8-9.5) 1.58 1.81 -3.04 1 4 0 34 256.39 5 ↓
Lo Low (pH 4.5-6) 1.58 4.83 -121.08 3 4 2 40 258.406 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[2-[(2R,5S)-5-ethyl-2-methyl-morpholin-4-yl]ethyl]tetrahydropyran-4-amine N-[2-[(2R,5S)-5-ethyl-2-methyl-m…

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.58 2.74 -43.18 2 4 1 38 257.398 5 ↓
Hi High (pH 8-9.5) 1.58 1.55 -3.52 1 4 0 34 256.39 5 ↓
Lo Low (pH 4.5-6) 1.58 4.9 -121.68 3 4 2 40 258.406 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[2-[(2S,5R)-5-ethyl-2-methyl-morpholin-4-yl]ethyl]tetrahydropyran-4-amine N-[2-[(2S,5R)-5-ethyl-2-methyl-m…

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.58 2.72 -43.11 2 4 1 38 257.398 5 ↓
Hi High (pH 8-9.5) 1.58 1.53 -3.31 1 4 0 34 256.39 5 ↓
Lo Low (pH 4.5-6) 1.58 4.88 -121.6 3 4 2 40 258.406 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[2-[(2S,5S)-5-ethyl-2-methyl-morpholin-4-yl]ethyl]tetrahydropyran-4-amine N-[2-[(2S,5S)-5-ethyl-2-methyl-m…

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.58 3.02 -43.24 2 4 1 38 257.398 5 ↓
Hi High (pH 8-9.5) 1.58 1.83 -3.28 1 4 0 34 256.39 5 ↓
Lo Low (pH 4.5-6) 1.58 4.86 -121.04 3 4 2 40 258.406 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[2-(3,3-dimethylmorpholin-4-yl)ethyl]tetrahydropyran-4-amine N-[2-(3,3-dimethylmorpholin-4-yl…

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.16 1.7 -42.6 2 4 1 38 243.371 4 ↓
Hi High (pH 8-9.5) 1.16 0.53 -3.09 1 4 0 34 242.363 4 ↓
Lo Low (pH 4.5-6) 1.16 3.8 -117.87 3 4 2 40 244.379 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: (2R,4R)-2-methyl-N-(2-morpholinoethyl)tetrahydropyran-4-amine (2R,4R)-2-methyl-N-(2-morpholino…

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.71 1.5 -42.97 2 4 1 38 229.344 4 ↓
Hi High (pH 8-9.5) 0.71 0.33 -3.19 1 4 0 34 228.336 4 ↓
Lo Low (pH 4.5-6) 0.71 3.77 -121.2 3 4 2 40 230.352 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: (2S,4R)-2-methyl-N-(2-morpholinoethyl)tetrahydropyran-4-amine (2S,4R)-2-methyl-N-(2-morpholino…

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.71 1.21 -42.68 2 4 1 38 229.344 4 ↓
Hi High (pH 8-9.5) 0.71 0.06 -3.18 1 4 0 34 228.336 4 ↓
Lo Low (pH 4.5-6) 0.71 3.49 -121.08 3 4 2 40 230.352 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: (2R,4S)-2-methyl-N-(2-morpholinoethyl)tetrahydropyran-4-amine (2R,4S)-2-methyl-N-(2-morpholino…

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.71 1.22 -42.7 2 4 1 38 229.344 4 ↓
Hi High (pH 8-9.5) 0.71 0.05 -3.53 1 4 0 34 228.336 4 ↓
Lo Low (pH 4.5-6) 0.71 3.5 -121.14 3 4 2 40 230.352 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: (2S,4S)-2-methyl-N-(2-morpholinoethyl)tetrahydropyran-4-amine (2S,4S)-2-methyl-N-(2-morpholino…

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.71 1.5 -42.99 2 4 1 38 229.344 4 ↓
Hi High (pH 8-9.5) 0.71 0.31 -3.68 1 4 0 34 228.336 4 ↓
Lo Low (pH 4.5-6) 0.71 3.76 -121.19 3 4 2 40 230.352 4 ↓

Parameters Provided:

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

Permalink

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

Embed Link to Results