Warning: session_write_close() [function.session-write-close]: open(/tmp/session/sess_3slg4vdlb3dr5surhtlfvis957, 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-[(2R,4aS,8aR)-decalin-2-yl]-6-methoxy-pyridin-3-amine N-[(2R,4aS,8aR)-decalin-2-yl]-6-…

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.60 5.32 -4.31 1 3 0 34 260.381 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(2S,4aS,8aR)-decalin-2-yl]-6-methoxy-pyridin-3-amine N-[(2S,4aS,8aR)-decalin-2-yl]-6-…

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.60 5.31 -4.37 1 3 0 34 260.381 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(2R,4aR,8aR)-decalin-2-yl]-6-methoxy-pyridin-3-amine N-[(2R,4aR,8aR)-decalin-2-yl]-6-…

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.60 5.68 -4.39 1 3 0 34 260.381 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(2S,4aR,8aR)-decalin-2-yl]-6-methoxy-pyridin-3-amine N-[(2S,4aR,8aR)-decalin-2-yl]-6-…

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.60 5.97 -4.2 1 3 0 34 260.381 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(2R,4aS,8aR)-decalin-2-yl]pyridin-3-amine N-[(2R,4aS,8aR)-decalin-2-yl]pyr…

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.21 6.87 -3.6 1 2 0 25 230.355 2 ↓
Mid Mid (pH 6-8) 4.21 7.33 -29.32 2 2 1 26 231.363 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(2S,4aS,8aR)-decalin-2-yl]pyridin-3-amine N-[(2S,4aS,8aR)-decalin-2-yl]pyr…

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.21 6.86 -3.65 1 2 0 25 230.355 2 ↓
Mid Mid (pH 6-8) 4.21 7.32 -29.53 2 2 1 26 231.363 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(2R,4aR,8aR)-decalin-2-yl]pyridin-3-amine N-[(2R,4aR,8aR)-decalin-2-yl]pyr…

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.21 7.23 -3.67 1 2 0 25 230.355 2 ↓
Mid Mid (pH 6-8) 4.21 7.68 -29.19 2 2 1 26 231.363 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(2S,4aR,8aR)-decalin-2-yl]pyridin-3-amine N-[(2S,4aR,8aR)-decalin-2-yl]pyr…

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.21 7.52 -3.41 1 2 0 25 230.355 2 ↓
Mid Mid (pH 6-8) 4.21 7.97 -29.38 2 2 1 26 231.363 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N3-[(2R,4aS,8aR)-decalin-2-yl]-N4,N4-dimethyl-pyridine-3,4-diamine N3-[(2R,4aS,8aR)-decalin-2-yl]-N…

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.24 8.53 -28.69 2 3 1 29 274.432 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N3-[(2S,4aS,8aR)-decalin-2-yl]-N4,N4-dimethyl-pyridine-3,4-diamine N3-[(2S,4aS,8aR)-decalin-2-yl]-N…

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.24 8.52 -29.1 2 3 1 29 274.432 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N3-[(2R,4aR,8aR)-decalin-2-yl]-N4,N4-dimethyl-pyridine-3,4-diamine N3-[(2R,4aR,8aR)-decalin-2-yl]-N…

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.24 8.88 -28.75 2 3 1 29 274.432 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N3-[(2S,4aR,8aR)-decalin-2-yl]-N4,N4-dimethyl-pyridine-3,4-diamine N3-[(2S,4aR,8aR)-decalin-2-yl]-N…

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.24 9.18 -28.84 2 3 1 29 274.432 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(2R,4aS,8aR)-decalin-2-yl]-2-chloro-pyridin-3-amine N-[(2R,4aS,8aR)-decalin-2-yl]-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) 5.01 7.4 -4.32 1 2 0 25 264.8 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(2S,4aS,8aR)-decalin-2-yl]-2-chloro-pyridin-3-amine N-[(2S,4aS,8aR)-decalin-2-yl]-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) 5.01 7.39 -4.3 1 2 0 25 264.8 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(2R,4aR,8aR)-decalin-2-yl]-2-chloro-pyridin-3-amine N-[(2R,4aR,8aR)-decalin-2-yl]-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) 5.01 7.76 -4.35 1 2 0 25 264.8 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(2S,4aR,8aR)-decalin-2-yl]-2-chloro-pyridin-3-amine N-[(2S,4aR,8aR)-decalin-2-yl]-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) 5.01 8.05 -4.81 1 2 0 25 264.8 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N5-[(2R,4aS,8aR)-decalin-2-yl]-N2,N2-dimethyl-pyridine-2,5-diamine N5-[(2R,4aS,8aR)-decalin-2-yl]-N…

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.65 8.8 -24.97 2 3 1 29 274.432 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N5-[(2S,4aS,8aR)-decalin-2-yl]-N2,N2-dimethyl-pyridine-2,5-diamine N5-[(2S,4aS,8aR)-decalin-2-yl]-N…

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.65 8.79 -25.04 2 3 1 29 274.432 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N5-[(2R,4aR,8aR)-decalin-2-yl]-N2,N2-dimethyl-pyridine-2,5-diamine N5-[(2R,4aR,8aR)-decalin-2-yl]-N…

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.65 9.16 -24.78 2 3 1 29 274.432 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N5-[(2S,4aR,8aR)-decalin-2-yl]-N2,N2-dimethyl-pyridine-2,5-diamine N5-[(2S,4aR,8aR)-decalin-2-yl]-N…

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.65 9.45 -25.03 2 3 1 29 274.432 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(2R,4aS,8aR)-decalin-2-yl]-2-ethoxy-pyridin-3-amine N-[(2R,4aS,8aR)-decalin-2-yl]-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.76 6.44 -3.95 1 3 0 34 274.408 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(2S,4aS,8aR)-decalin-2-yl]-2-ethoxy-pyridin-3-amine N-[(2S,4aS,8aR)-decalin-2-yl]-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.76 6.44 -3.95 1 3 0 34 274.408 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(2R,4aR,8aR)-decalin-2-yl]-2-ethoxy-pyridin-3-amine N-[(2R,4aR,8aR)-decalin-2-yl]-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.76 6.8 -3.95 1 3 0 34 274.408 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(2S,4aR,8aR)-decalin-2-yl]-2-ethoxy-pyridin-3-amine N-[(2S,4aR,8aR)-decalin-2-yl]-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.76 7.09 -4.22 1 3 0 34 274.408 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N3-[(2R,4aS,8aR)-decalin-2-yl]-N2,N2-dimethyl-pyridine-2,3-diamine N3-[(2R,4aS,8aR)-decalin-2-yl]-N…

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.43 9.18 -25.79 2 3 1 29 274.432 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N3-[(2S,4aS,8aR)-decalin-2-yl]-N2,N2-dimethyl-pyridine-2,3-diamine N3-[(2S,4aS,8aR)-decalin-2-yl]-N…

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.43 9.24 -25.99 2 3 1 29 274.432 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N3-[(2R,4aR,8aR)-decalin-2-yl]-N2,N2-dimethyl-pyridine-2,3-diamine N3-[(2R,4aR,8aR)-decalin-2-yl]-N…

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.43 9.53 -25.69 2 3 1 29 274.432 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N3-[(2S,4aR,8aR)-decalin-2-yl]-N2,N2-dimethyl-pyridine-2,3-diamine N3-[(2S,4aR,8aR)-decalin-2-yl]-N…

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.43 9.87 -25.79 2 3 1 29 274.432 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(2R,4aS,8aR)-decalin-2-yl]-2-methoxy-pyridin-3-amine N-[(2R,4aS,8aR)-decalin-2-yl]-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.39 5.5 -4.09 1 3 0 34 260.381 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(2S,4aS,8aR)-decalin-2-yl]-2-methoxy-pyridin-3-amine N-[(2S,4aS,8aR)-decalin-2-yl]-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.39 5.5 -4.06 1 3 0 34 260.381 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(2R,4aR,8aR)-decalin-2-yl]-2-methoxy-pyridin-3-amine N-[(2R,4aR,8aR)-decalin-2-yl]-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.39 5.86 -4.11 1 3 0 34 260.381 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(2S,4aR,8aR)-decalin-2-yl]-2-methoxy-pyridin-3-amine N-[(2S,4aR,8aR)-decalin-2-yl]-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.39 6.15 -4.32 1 3 0 34 260.381 3 ↓

Parameters Provided:

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

Permalink

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

Embed Link to Results