Warning: session_write_close() [function.session-write-close]: open(/tmp/session/sess_ujmhf3jofr1g48393k86aaitu1, 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: (3S)-3-morpholino-1,1-dioxo-thiane-3-carboxylic (3S)-3-morpholino-1,1-dioxo-thia…

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.68 -0.03 -54.93 0 6 -1 87 262.307 2 ↓
Mid Mid (pH 6-8) -2.68 2.1 -47.58 1 6 0 88 263.315 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: (3R)-3-morpholino-1,1-dioxo-thiane-3-carboxylic (3R)-3-morpholino-1,1-dioxo-thia…

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.68 1.13 -49.08 0 6 -1 87 262.307 2 ↓
Mid Mid (pH 6-8) -2.68 2.16 -32.08 1 6 0 88 263.315 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: [(3S)-3-[(2S,6R)-2,6-dimethylmorpholin-4-yl]-1,1-dioxo-thian-3-yl]methanamine [(3S)-3-[(2S,6R)-2,6-dimethylmor…

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.42 -1.14 -48.93 3 5 1 74 277.41 2 ↓
Hi High (pH 8-9.5) -0.42 -1.89 -10.23 2 5 0 73 276.402 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: [(3S)-3-[(2S,6S)-2,6-dimethylmorpholin-4-yl]-1,1-dioxo-thian-3-yl]methanamine [(3S)-3-[(2S,6S)-2,6-dimethylmor…

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.42 -0.88 -49.32 3 5 1 74 277.41 2 ↓
Hi High (pH 8-9.5) -0.42 -1.63 -9.75 2 5 0 73 276.402 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: [(3S)-3-[(2R,6R)-2,6-dimethylmorpholin-4-yl]-1,1-dioxo-thian-3-yl]methanamine [(3S)-3-[(2R,6R)-2,6-dimethylmor…

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.42 -0.87 -49.48 3 5 1 74 277.41 2 ↓
Hi High (pH 8-9.5) -0.42 -1.63 -9.88 2 5 0 73 276.402 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: [(3S)-3-[(2R)-2-methylmorpholin-4-yl]-1,1-dioxo-thian-3-yl]methanamine [(3S)-3-[(2R)-2-methylmorpholin-…

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.78 -1.89 -48.65 3 5 1 74 263.383 2 ↓
Hi High (pH 8-9.5) -0.78 -2.64 -10.24 2 5 0 73 262.375 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: [(3S)-3-[(2S)-2-methylmorpholin-4-yl]-1,1-dioxo-thian-3-yl]methanamine [(3S)-3-[(2S)-2-methylmorpholin-…

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.78 -2.01 -46.84 3 5 1 74 263.383 2 ↓
Hi High (pH 8-9.5) -0.78 -2.04 -10.36 2 5 0 73 262.375 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: [(3S)-3-[(3R)-3-methylmorpholin-4-yl]-1,1-dioxo-thian-3-yl]methanamine [(3S)-3-[(3R)-3-methylmorpholin-…

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.82 -2.45 -53.6 3 5 1 74 263.383 2 ↓
Hi High (pH 8-9.5) -0.82 -2.79 -10.51 2 5 0 73 262.375 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: [(3S)-3-[(3S)-3-methylmorpholin-4-yl]-1,1-dioxo-thian-3-yl]methanamine [(3S)-3-[(3S)-3-methylmorpholin-…

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.82 -2.04 -53.02 3 5 1 74 263.383 2 ↓
Hi High (pH 8-9.5) -0.82 -2.47 -9.87 2 5 0 73 262.375 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: [(3S)-3-[(2R,5R)-2,5-dimethylmorpholin-4-yl]-1,1-dioxo-thian-3-yl]methanamine [(3S)-3-[(2R,5R)-2,5-dimethylmor…

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.45 -1.73 -48.45 3 5 1 74 277.41 2 ↓
Hi High (pH 8-9.5) -0.45 -2.14 -10.1 2 5 0 73 276.402 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: [(3S)-3-[(2S,5R)-2,5-dimethylmorpholin-4-yl]-1,1-dioxo-thian-3-yl]methanamine [(3S)-3-[(2S,5R)-2,5-dimethylmor…

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.45 -1.32 -54.48 3 5 1 74 277.41 2 ↓
Hi High (pH 8-9.5) -0.45 -2.11 -12.14 2 5 0 73 276.402 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: [(3S)-3-[(2R)-2-ethylmorpholin-4-yl]-1,1-dioxo-thian-3-yl]methanamine [(3S)-3-[(2R)-2-ethylmorpholin-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) -0.28 -1.05 -48.79 3 5 1 74 277.41 3 ↓
Hi High (pH 8-9.5) -0.28 -1.45 -10.26 2 5 0 73 276.402 3 ↓
Lo Low (pH 4.5-6) -0.28 0.84 -134.23 4 5 2 75 278.418 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: [(3S)-3-[(2S)-2-ethylmorpholin-4-yl]-1,1-dioxo-thian-3-yl]methanamine [(3S)-3-[(2S)-2-ethylmorpholin-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) -0.28 -1.16 -47.21 3 5 1 74 277.41 3 ↓
Hi High (pH 8-9.5) -0.28 -1.3 -11.17 2 5 0 73 276.402 3 ↓
Lo Low (pH 4.5-6) -0.28 0.79 -140.15 4 5 2 75 278.418 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: [(3S)-3-(2,2-dimethylmorpholin-4-yl)-1,1-dioxo-thian-3-yl]methanamine [(3S)-3-(2,2-dimethylmorpholin-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) -0.34 -0.98 -49.63 3 5 1 74 277.41 2 ↓
Hi High (pH 8-9.5) -0.34 -1.38 -10.22 2 5 0 73 276.402 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: [(3R)-3-(2,2-dimethylmorpholin-4-yl)-1,1-dioxo-thian-3-yl]methanamine [(3R)-3-(2,2-dimethylmorpholin-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) -0.34 -1.17 -53.5 3 5 1 74 277.41 2 ↓
Hi High (pH 8-9.5) -0.34 -1.13 -10.19 2 5 0 73 276.402 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: [(3S)-3-[(3R)-3-ethylmorpholin-4-yl]-1,1-dioxo-thian-3-yl]methanamine [(3S)-3-[(3R)-3-ethylmorpholin-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) -0.28 -1.53 -54.73 3 5 1 74 277.41 3 ↓
Hi High (pH 8-9.5) -0.28 -1.84 -11.16 2 5 0 73 276.402 3 ↓
Lo Low (pH 4.5-6) -0.28 0 -132.34 4 5 2 75 278.418 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: [(3S)-3-[(3S)-3-ethylmorpholin-4-yl]-1,1-dioxo-thian-3-yl]methanamine [(3S)-3-[(3S)-3-ethylmorpholin-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) -0.28 -1.3 -51.4 3 5 1 74 277.41 3 ↓
Hi High (pH 8-9.5) -0.28 -1.46 -11 2 5 0 73 276.402 3 ↓
Lo Low (pH 4.5-6) -0.28 0.07 -131.29 4 5 2 75 278.418 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: [(3S)-3-[(2R,5R)-5-ethyl-2-methyl-morpholin-4-yl]-1,1-dioxo-thian-3-yl]methanamine [(3S)-3-[(2R,5R)-5-ethyl-2-methy…

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.08 -0.53 -55.57 3 5 1 74 291.437 3 ↓
Hi High (pH 8-9.5) 0.08 -0.81 -11.08 2 5 0 73 290.429 3 ↓
Lo Low (pH 4.5-6) 0.08 0.76 -131.74 4 5 2 75 292.445 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: [(3S)-3-[(2R,5S)-5-ethyl-2-methyl-morpholin-4-yl]-1,1-dioxo-thian-3-yl]methanamine [(3S)-3-[(2R,5S)-5-ethyl-2-methy…

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.08 -0.55 -51.71 3 5 1 74 291.437 3 ↓
Hi High (pH 8-9.5) 0.08 -0.72 -11 2 5 0 73 290.429 3 ↓
Lo Low (pH 4.5-6) 0.08 0.81 -132.48 4 5 2 75 292.445 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: [(3S)-3-[(2S,5R)-5-ethyl-2-methyl-morpholin-4-yl]-1,1-dioxo-thian-3-yl]methanamine [(3S)-3-[(2S,5R)-5-ethyl-2-methy…

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.08 -0.78 -55.26 3 5 1 74 291.437 3 ↓
Hi High (pH 8-9.5) 0.08 -1.09 -11.21 2 5 0 73 290.429 3 ↓
Lo Low (pH 4.5-6) 0.08 0.76 -133.34 4 5 2 75 292.445 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: [(3S)-3-[(2S,5S)-5-ethyl-2-methyl-morpholin-4-yl]-1,1-dioxo-thian-3-yl]methanamine [(3S)-3-[(2S,5S)-5-ethyl-2-methy…

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.08 -0.3 -52.2 3 5 1 74 291.437 3 ↓
Hi High (pH 8-9.5) 0.08 -0.46 -10.8 2 5 0 73 290.429 3 ↓
Lo Low (pH 4.5-6) 0.08 0.76 -130.45 4 5 2 75 292.445 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: [(3S)-3-(3,3-dimethylmorpholin-4-yl)-1,1-dioxo-thian-3-yl]methanamine [(3S)-3-(3,3-dimethylmorpholin-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) -0.34 -2.27 -54.05 3 5 1 74 277.41 2 ↓
Hi High (pH 8-9.5) -0.34 -2.55 -11.09 2 5 0 73 276.402 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: [(3R)-3-(3,3-dimethylmorpholin-4-yl)-1,1-dioxo-thian-3-yl]methanamine [(3R)-3-(3,3-dimethylmorpholin-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) -0.34 -1.95 -54.45 3 5 1 74 277.41 2 ↓
Hi High (pH 8-9.5) -0.34 -2.31 -10.66 2 5 0 73 276.402 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: [(3S)-1,1-dioxo-3-[(6R)-2,2,6-trimethylmorpholin-4-yl]thian-3-yl]methanamine [(3S)-1,1-dioxo-3-[(6R)-2,2,6-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) 0.03 -0.35 -47.48 3 5 1 74 291.437 2 ↓
Hi High (pH 8-9.5) 0.03 -0.56 -11.21 2 5 0 73 290.429 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: [(3S)-1,1-dioxo-3-[(6S)-2,2,6-trimethylmorpholin-4-yl]thian-3-yl]methanamine [(3S)-1,1-dioxo-3-[(6S)-2,2,6-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) 0.03 -0.26 -49.92 3 5 1 74 291.437 2 ↓
Hi High (pH 8-9.5) 0.03 -0.65 -10.14 2 5 0 73 290.429 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: (3S)-3-morpholino-1,1-dioxo-thiane-3-carbonitrile (3S)-3-morpholino-1,1-dioxo-thia…

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.17 -1.2 -19.65 0 5 0 70 244.316 1 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: (3R)-3-morpholino-1,1-dioxo-thiane-3-carbonitrile (3R)-3-morpholino-1,1-dioxo-thia…

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.17 -1.19 -19.7 0 5 0 70 244.316 1 ↓

Parameters Provided:

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

Permalink

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

Embed Link to Results