UCSF
ZINC Item Suppliers, Protomers, & Similar Substances

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 2-(2-oxooxazolo[4,5-b]pyridin-3-yl)acetohydrazide 2-(2-oxooxazolo[4,5-b]pyridin-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.00 1.2 -18.56 3 7 0 103 208.177 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 2-(2-oxooxazolo[4,5-b]pyridin-3-yl)acetamide 2-(2-oxooxazolo[4,5-b]pyridin-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) -0.92 1.07 -17.74 2 6 0 91 193.162 2 ↓

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) 0.21 5.04 -14.42 0 6 0 74 208.173 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: butyl butyl

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.64 7.55 -13.81 0 6 0 74 250.254 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: isopropyl isopropyl

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.95 6.68 -14.24 0 6 0 74 236.227 4 ↓

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.58 5.96 -14.16 0 6 0 74 222.2 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-[(4-bromophenyl)methyl]oxazolo[4,5-b]pyridin-2-one 3-[(4-bromophenyl)methyl]oxazolo…

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.75 8.31 -9.6 0 4 0 48 305.131 2 ↓

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.11 8.34 -13.36 0 6 0 74 284.271 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-[(4-nitrophenyl)methyl]oxazolo[4,5-b]pyridin-2-one 3-[(4-nitrophenyl)methyl]oxazolo…

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.90 8.4 -12.48 0 7 0 94 271.232 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-isopropyloxazolo[4,5-b]pyridin-2-one 3-isopropyloxazolo[4,5-b]pyridin…

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.08 5.17 -9.77 0 4 0 48 178.191 1 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-methyloxazolo[4,5-b]pyridin-2-one 3-methyloxazolo[4,5-b]pyridin-2-one

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 3.66 -9.91 0 4 0 48 150.137 0 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-(3-phenylpropyl)oxazolo[4,5-b]pyridin-2-one 3-(3-phenylpropyl)oxazolo[4,5-b]…

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.67 9.24 -11.01 0 4 0 48 254.289 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-[2-(4-fluorophenyl)-2-oxo-ethyl]oxazolo[4,5-b]pyridin-2-one 3-[2-(4-fluorophenyl)-2-oxo-ethy…

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.66 7.87 -16.18 0 5 0 65 272.235 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-(2-oxooxazolo[4,5-b]pyridin-3-yl)pentane-2,4-dione 3-(2-oxooxazolo[4,5-b]pyridin-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) -0.58 6.58 -26.18 0 6 0 82 234.211 3 ↓
Hi High (pH 8-9.5) 0.18 5.24 -48.42 0 6 -1 88 233.203 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-acetonyloxazolo[4,5-b]pyridin-2-one 3-acetonyloxazolo[4,5-b]pyridin-…

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.11 4.9 -16.19 0 5 0 65 192.174 2 ↓

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.55 6.34 -11.3 0 6 0 74 236.227 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-[(1S)-1-methyl-2-oxo-propyl]oxazolo[4,5-b]pyridin-2-one 3-[(1S)-1-methyl-2-oxo-propyl]ox…

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.25 5.95 -17.34 0 5 0 65 206.201 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-[(1R)-1-methyl-2-oxo-propyl]oxazolo[4,5-b]pyridin-2-one 3-[(1R)-1-methyl-2-oxo-propyl]ox…

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.25 5.96 -17.34 0 5 0 65 206.201 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-[2-oxo-2-(2-thienyl)ethyl]oxazolo[4,5-b]pyridin-2-one 3-[2-oxo-2-(2-thienyl)ethyl]oxaz…

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.39 6.94 -16.49 0 5 0 65 260.274 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-phenacyloxazolo[4,5-b]pyridin-2-one 3-phenacyloxazolo[4,5-b]pyridin-…

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.49 7.8 -16.89 0 5 0 65 254.245 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-[2-oxo-2-(p-tolyl)ethyl]oxazolo[4,5-b]pyridin-2-one 3-[2-oxo-2-(p-tolyl)ethyl]oxazol…

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.94 8.48 -16.73 0 5 0 65 268.272 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-[2-(3-methoxyphenyl)-2-oxo-ethyl]oxazolo[4,5-b]pyridin-2-one 3-[2-(3-methoxyphenyl)-2-oxo-eth…

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 7.11 -19.52 0 6 0 74 284.271 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-[2-(4-bromophenyl)-2-oxo-ethyl]oxazolo[4,5-b]pyridin-2-one 3-[2-(4-bromophenyl)-2-oxo-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.30 8.42 -15.72 0 5 0 65 333.141 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(2-cyanoethyl)-N-methyl-2-(2-oxooxazolo[4,5-b]pyridin-3-yl)acetamide N-(2-cyanoethyl)-N-methyl-2-(2-o…

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.85 5.95 -21.34 0 7 0 92 260.253 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-(2,2-dimethoxyethyl)oxazolo[4,5-b]pyridin-2-one 3-(2,2-dimethoxyethyl)oxazolo[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.29 3.66 -13.07 0 6 0 67 224.216 4 ↓

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) 0.44 6.23 -15.02 0 6 0 74 236.227 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-prop-2-ynyloxazolo[4,5-b]pyridin-2-one 3-prop-2-ynyloxazolo[4,5-b]pyrid…

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.50 5.2 -11.25 0 4 0 48 174.159 1 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-(2,2-diethoxyethyl)oxazolo[4,5-b]pyridin-2-one 3-(2,2-diethoxyethyl)oxazolo[4,5…

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 5.56 -12.85 0 6 0 67 252.27 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-[2-(3,4-dimethylphenyl)-2-oxo-ethyl]oxazolo[4,5-b]pyridin-2-one 3-[2-(3,4-dimethylphenyl)-2-oxo-…

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.32 9.02 -17.01 0 5 0 65 282.299 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: (2S)-2-(2-oxooxazolo[4,5-b]pyridin-3-yl)-2-phenyl-acetic (2S)-2-(2-oxooxazolo[4,5-b]pyrid…

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.17 8.14 -56.12 0 6 -1 88 269.236 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: (2R)-2-(2-oxooxazolo[4,5-b]pyridin-3-yl)-2-phenyl-acetic (2R)-2-(2-oxooxazolo[4,5-b]pyrid…

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.17 8.43 -56.11 0 6 -1 88 269.236 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: (2S)-2-(2-oxooxazolo[4,5-b]pyridin-3-yl)-4-phenyl-butanoic (2S)-2-(2-oxooxazolo[4,5-b]pyrid…

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.90 10.41 -59.75 0 6 -1 88 297.29 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: (2R)-2-(2-oxooxazolo[4,5-b]pyridin-3-yl)-4-phenyl-butanoic (2R)-2-(2-oxooxazolo[4,5-b]pyrid…

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.90 10.37 -59.66 0 6 -1 88 297.29 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-(3-oxobutyl)oxazolo[4,5-b]pyridin-2-one 3-(3-oxobutyl)oxazolo[4,5-b]pyri…

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 5.32 -12.41 0 5 0 65 206.201 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 6-amino-3H-oxazolo[4,5-b]pyridin-2-one 6-amino-3H-oxazolo[4,5-b]pyridin…

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.09 -0.85 -9.16 3 5 0 85 151.125 0 ↓

Parameters Provided:

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

Permalink

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

Embed Link to Results