UCSF
ZINC Item Suppliers, Protomers, & Similar Substances

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[4-(difluoromethylsulfanyl)phenyl]-5-methyl-pyrazolo[1,5-a]pyrimidine-3-carboxamide N-[4-(difluoromethylsulfanyl)phe…

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.82 7.35 -21.5 1 5 0 59 334.351 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(2-cyanoethyl)-2,5,7-trimethyl-N-(m-tolyl)pyrazolo[1,5-a]pyrimidine-3-carboxamide N-(2-cyanoethyl)-2,5,7-trimethyl…

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.40 10.46 -18.29 0 6 0 74 347.422 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(3,5-dichlorophenyl)-5,7-dimethyl-pyrazolo[1,5-a]pyrimidine-3-carboxamide N-(3,5-dichlorophenyl)-5,7-dimet…

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.34 7.64 -17.1 1 5 0 59 335.194 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(4-ethynylphenyl)-5,7-dimethyl-pyrazolo[1,5-a]pyrimidine-3-carboxamide N-(4-ethynylphenyl)-5,7-dimethyl…

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.82 7.81 -19.95 1 5 0 59 290.326 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(3,5-dimethylphenyl)-5-methyl-7-oxo-4H-pyrazolo[1,5-a]pyrimidine-3-carboxamide N-(3,5-dimethylphenyl)-5-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.56 4.83 -49.89 1 6 -1 82 295.322 2 ↓
Mid Mid (pH 6-8) 2.10 6.26 -18.17 2 6 0 79 296.33 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(2,4-dimethylphenyl)-5-methyl-7-oxo-4H-pyrazolo[1,5-a]pyrimidine-3-carboxamide N-(2,4-dimethylphenyl)-5-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.56 5.06 -49.55 1 6 -1 82 295.322 2 ↓
Mid Mid (pH 6-8) 2.10 6.49 -17.96 2 6 0 79 296.33 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(5-methoxy-2-methyl-phenyl)-5-methyl-7-oxo-4H-pyrazolo[1,5-a]pyrimidine-3-carboxamide N-(5-methoxy-2-methyl-phenyl)-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) 2.17 3.69 -53.06 1 7 -1 92 311.321 3 ↓
Mid Mid (pH 6-8) 1.71 5.12 -20.25 2 7 0 89 312.329 3 ↓

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.42 5.41 -50.81 1 8 -1 109 339.331 5 ↓
Mid Mid (pH 6-8) 1.96 6.84 -18.19 2 8 0 106 340.339 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) 2.28 5.07 -51.07 1 8 -1 109 339.331 5 ↓
Mid Mid (pH 6-8) 1.82 6.5 -22.03 2 8 0 106 340.339 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(2-fluoro-4-methyl-phenyl)-5-methyl-7-oxo-4H-pyrazolo[1,5-a]pyrimidine-3-carboxamide N-(2-fluoro-4-methyl-phenyl)-5-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) 2.28 4.28 -47.51 1 6 -1 82 299.285 2 ↓
Mid Mid (pH 6-8) 1.82 5.7 -17.14 2 6 0 79 300.293 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(4-fluoro-2-methyl-phenyl)-5-methyl-7-oxo-4H-pyrazolo[1,5-a]pyrimidine-3-carboxamide N-(4-fluoro-2-methyl-phenyl)-5-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) 2.28 4.46 -47.55 1 6 -1 82 299.285 2 ↓
Mid Mid (pH 6-8) 1.82 5.88 -18.43 2 6 0 79 300.293 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(5-fluoro-2-methyl-phenyl)-5-methyl-7-oxo-4H-pyrazolo[1,5-a]pyrimidine-3-carboxamide N-(5-fluoro-2-methyl-phenyl)-5-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) 2.28 4.46 -50.92 1 6 -1 82 299.285 2 ↓
Mid Mid (pH 6-8) 1.82 5.87 -19.58 2 6 0 79 300.293 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(4-chloro-2-methyl-phenyl)-5-methyl-7-oxo-4H-pyrazolo[1,5-a]pyrimidine-3-carboxamide N-(4-chloro-2-methyl-phenyl)-5-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) 2.79 4.91 -47.3 1 6 -1 82 315.74 2 ↓
Mid Mid (pH 6-8) 2.33 6.33 -17.91 2 6 0 79 316.748 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(4-bromo-2-methyl-phenyl)-5-methyl-7-oxo-4H-pyrazolo[1,5-a]pyrimidine-3-carboxamide N-(4-bromo-2-methyl-phenyl)-5-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.92 5.01 -47.24 1 6 -1 82 360.191 2 ↓
Mid Mid (pH 6-8) 2.46 6.42 -17.87 2 6 0 79 361.199 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(4-bromo-3-methyl-phenyl)-5-methyl-7-oxo-4H-pyrazolo[1,5-a]pyrimidine-3-carboxamide N-(4-bromo-3-methyl-phenyl)-5-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.92 4.68 -47.71 1 6 -1 82 360.191 2 ↓
Mid Mid (pH 6-8) 2.46 6.1 -18.27 2 6 0 79 361.199 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(2-chloro-4-methyl-phenyl)-5-methyl-7-oxo-4H-pyrazolo[1,5-a]pyrimidine-3-carboxamide N-(2-chloro-4-methyl-phenyl)-5-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) 2.79 4.79 -46.86 1 6 -1 82 315.74 2 ↓
Mid Mid (pH 6-8) 2.33 6.21 -16.48 2 6 0 79 316.748 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(2-bromo-4-methyl-phenyl)-5-methyl-7-oxo-4H-pyrazolo[1,5-a]pyrimidine-3-carboxamide N-(2-bromo-4-methyl-phenyl)-5-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.92 4.92 -46.6 1 6 -1 82 360.191 2 ↓
Mid Mid (pH 6-8) 2.46 6.33 -16.28 2 6 0 79 361.199 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(4-chloro-2-methoxy-5-methyl-phenyl)-5-methyl-7-oxo-4H-pyrazolo[1,5-a]pyrimidine-3-carboxamide N-(4-chloro-2-methoxy-5-methyl-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) 2.77 4 -47.37 1 7 -1 92 345.766 3 ↓
Mid Mid (pH 6-8) 2.32 5.42 -17.33 2 7 0 89 346.774 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 2,5,7-trimethyl-N-[4-(ureidomethyl)phenyl]pyrazolo[1,5-a]pyrimidine-3-carboxamide 2,5,7-trimethyl-N-[4-(ureidometh…

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.11 3.33 -21.1 4 8 0 114 352.398 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 6-(diethylaminomethyl)-N-(3-hydroxyphenyl)pyrazolo[1,5-a]pyrimidine-3-carboxamide 6-(diethylaminomethyl)-N-(3-hydr…

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.42 5.67 -57.36 3 7 1 84 340.407 6 ↓
Mid Mid (pH 6-8) 1.42 3.56 -18.42 2 7 0 83 339.399 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 6-(diethylaminomethyl)-N-[3-(hydroxymethyl)phenyl]pyrazolo[1,5-a]pyrimidine-3-carboxamide 6-(diethylaminomethyl)-N-[3-(hyd…

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.24 5.86 -58.48 3 7 1 84 354.434 7 ↓
Mid Mid (pH 6-8) 1.24 3.78 -19.67 2 7 0 83 353.426 7 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(2,3-difluorophenyl)pyrazolo[1,5-a]pyrimidine-3-carboxamide N-(2,3-difluorophenyl)pyrazolo[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.62 5.59 -16.56 1 5 0 59 274.23 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 6-(diethylaminomethyl)-N-(2-methoxy-5-methyl-phenyl)pyrazolo[1,5-a]pyrimidine-3-carboxamide 6-(diethylaminomethyl)-N-(2-meth…

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.36 8.6 -55.38 2 7 1 73 368.461 7 ↓
Mid Mid (pH 6-8) 2.36 6.56 -15.81 1 7 0 72 367.453 7 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 6-(diethylaminomethyl)-N-phenyl-pyrazolo[1,5-a]pyrimidine-3-carboxamide 6-(diethylaminomethyl)-N-phenyl-…

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.93 8.52 -55.31 2 6 1 64 324.408 6 ↓
Mid Mid (pH 6-8) 1.93 6.41 -16.22 1 6 0 63 323.4 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(2-chloro-4-iodo-phenyl)pyrazolo[1,5-a]pyrimidine-3-carboxamide N-(2-chloro-4-iodo-phenyl)pyrazo…

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.15 -14.81 1 5 0 59 398.591 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 6-(diethylaminomethyl)-N-(2,3-dimethylphenyl)pyrazolo[1,5-a]pyrimidine-3-carboxamide 6-(diethylaminomethyl)-N-(2,3-di…

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.73 9.96 -55.52 2 6 1 64 352.462 6 ↓
Mid Mid (pH 6-8) 2.73 7.9 -16.27 1 6 0 63 351.454 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(3-cyanophenyl)-6-(diethylaminomethyl)pyrazolo[1,5-a]pyrimidine-3-carboxamide N-(3-cyanophenyl)-6-(diethylamin…

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 8.92 -56.69 2 7 1 88 349.418 6 ↓
Mid Mid (pH 6-8) 1.66 6.81 -16.09 1 7 0 86 348.41 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 6-(diethylaminomethyl)-N-(4-isopropylphenyl)pyrazolo[1,5-a]pyrimidine-3-carboxamide 6-(diethylaminomethyl)-N-(4-isop…

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.44 10.44 -54.88 2 6 1 64 366.489 7 ↓
Mid Mid (pH 6-8) 3.44 8.37 -15.97 1 6 0 63 365.481 7 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(3-carbamoyl-2-methyl-phenyl)-6-(diethylaminomethyl)pyrazolo[1,5-a]pyrimidine-3-carboxamide N-(3-carbamoyl-2-methyl-phenyl)-…

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.10 6.19 -58.35 4 8 1 107 381.46 7 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 6-(diethylaminomethyl)-N-(3-methoxyphenyl)pyrazolo[1,5-a]pyrimidine-3-carboxamide 6-(diethylaminomethyl)-N-(3-meth…

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.96 7.82 -57.99 2 7 1 73 354.434 7 ↓

Parameters Provided:

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

Permalink

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

Embed Link to Results