Warning: session_write_close() [function.session-write-close]: open(/tmp/session/sess_q4lb9djcffthnbrpg1o8u25qt5, 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: 5-[3-(p-tolyl)propyl]-1H-tetrazole 5-[3-(p-tolyl)propyl]-1H-tetrazole

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.31 5.79 -38.44 0 4 -1 53 201.253 4 ↓
Lo Low (pH 4.5-6) 2.31 5.79 -6.72 1 4 0 54 202.261 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-[3-(4-fluorophenyl)propyl]-1H-tetrazole 5-[3-(4-fluorophenyl)propyl]-1H-…

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.02 5.18 -37.79 0 4 -1 53 205.216 4 ↓
Lo Low (pH 4.5-6) 2.02 5.18 -7.9 1 4 0 54 206.224 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-[3-(4-ethylphenyl)propyl]-1H-tetrazole 5-[3-(4-ethylphenyl)propyl]-1H-t…

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 6.56 -38.38 0 4 -1 53 215.28 5 ↓
Lo Low (pH 4.5-6) 2.77 6.56 -6.53 1 4 0 54 216.288 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-[3-(3,4-dimethylphenyl)propyl]-1H-tetrazole 5-[3-(3,4-dimethylphenyl)propyl]…

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 6.33 -38.87 0 4 -1 53 215.28 4 ↓
Lo Low (pH 4.5-6) 2.68 6.34 -6.84 1 4 0 54 216.288 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-[3-(2,5-dimethylphenyl)propyl]-1H-tetrazole 5-[3-(2,5-dimethylphenyl)propyl]…

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 6.3 -38.53 0 4 -1 53 215.28 4 ↓
Lo Low (pH 4.5-6) 2.68 6.3 -6.81 1 4 0 54 216.288 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-[3-(2,4-dimethylphenyl)propyl]-1H-tetrazole 5-[3-(2,4-dimethylphenyl)propyl]…

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 6.25 -38.51 0 4 -1 53 215.28 4 ↓
Lo Low (pH 4.5-6) 2.68 6.25 -6.82 1 4 0 54 216.288 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-[3-(4-methoxyphenyl)propyl]-1H-tetrazole 5-[3-(4-methoxyphenyl)propyl]-1H…

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.91 4.41 -39.41 0 5 -1 62 217.252 5 ↓
Lo Low (pH 4.5-6) 1.91 4.41 -8.33 1 5 0 64 218.26 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-[3-(2-methoxyphenyl)propyl]-1H-tetrazole 5-[3-(2-methoxyphenyl)propyl]-1H…

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.86 4.47 -40.73 0 5 -1 62 217.252 5 ↓
Lo Low (pH 4.5-6) 1.86 4.47 -7.82 1 5 0 64 218.26 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-[3-(3-methoxyphenyl)propyl]-1H-tetrazole 5-[3-(3-methoxyphenyl)propyl]-1H…

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.89 4.41 -40.3 0 5 -1 62 217.252 5 ↓
Lo Low (pH 4.5-6) 1.89 4.41 -8.21 1 5 0 64 218.26 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-[3-(4-fluoro-3-methyl-phenyl)propyl]-1H-tetrazole 5-[3-(4-fluoro-3-methyl-phenyl)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.40 5.81 -37.98 0 4 -1 53 219.243 4 ↓
Lo Low (pH 4.5-6) 2.40 5.81 -8.05 1 4 0 54 220.251 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-[3-(4-chlorophenyl)propyl]-1H-tetrazole 5-[3-(4-chlorophenyl)propyl]-1H-…

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.54 5.63 -37.36 0 4 -1 53 221.671 4 ↓
Lo Low (pH 4.5-6) 2.54 5.63 -7.11 1 4 0 54 222.679 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-[3-(4-propylphenyl)propyl]-1H-tetrazole 5-[3-(4-propylphenyl)propyl]-1H-…

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.16 7.33 -38.31 0 4 -1 53 229.307 6 ↓
Lo Low (pH 4.5-6) 3.16 7.33 -6.44 1 4 0 54 230.315 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-[3-(2,4,6-trimethylphenyl)propyl]-1H-tetrazole 5-[3-(2,4,6-trimethylphenyl)prop…

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.06 6.83 -38.72 0 4 -1 53 229.307 4 ↓
Lo Low (pH 4.5-6) 3.06 6.83 -7.04 1 4 0 54 230.315 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-[3-(4-methoxy-3-methyl-phenyl)propyl]-1H-tetrazole 5-[3-(4-methoxy-3-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) 2.29 5.16 -39.55 0 5 -1 62 231.279 5 ↓
Lo Low (pH 4.5-6) 2.29 5.16 -8.35 1 5 0 64 232.287 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-[3-(2-methoxy-5-methyl-phenyl)propyl]-1H-tetrazole 5-[3-(2-methoxy-5-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) 2.29 5.14 -40.81 0 5 -1 62 231.279 5 ↓
Lo Low (pH 4.5-6) 2.29 5.14 -7.77 1 5 0 64 232.287 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-[3-(4-ethoxyphenyl)propyl]-1H-tetrazole 5-[3-(4-ethoxyphenyl)propyl]-1H-…

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.29 5.34 -39.33 0 5 -1 62 231.279 6 ↓
Lo Low (pH 4.5-6) 2.29 5.34 -8.2 1 5 0 64 232.287 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-[3-(3-fluoro-4-methoxy-phenyl)propyl]-1H-tetrazole 5-[3-(3-fluoro-4-methoxy-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) 2.00 4.49 -40.96 0 5 -1 62 235.242 5 ↓
Lo Low (pH 4.5-6) 2.00 4.49 -10.57 1 5 0 64 236.25 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-[3-(5-fluoro-2-methoxy-phenyl)propyl]-1H-tetrazole 5-[3-(5-fluoro-2-methoxy-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) 2.00 4.53 -40.03 0 5 -1 62 235.242 5 ↓
Lo Low (pH 4.5-6) 2.00 4.53 -8.03 1 5 0 64 236.25 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-[3-(4-isobutylphenyl)propyl]-1H-tetrazole 5-[3-(4-isobutylphenyl)propyl]-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) 3.16 7.8 -38.38 0 4 -1 53 243.334 6 ↓
Lo Low (pH 4.5-6) 3.16 7.8 -6.29 1 4 0 54 244.342 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-[3-(2-methoxy-4,5-dimethyl-phenyl)propyl]-1H-tetrazole 5-[3-(2-methoxy-4,5-dimethyl-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.67 5.68 -41.34 0 5 -1 62 245.306 5 ↓
Lo Low (pH 4.5-6) 2.67 5.68 -8.04 1 5 0 64 246.314 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-[3-(4-methoxy-2,5-dimethyl-phenyl)propyl]-1H-tetrazole 5-[3-(4-methoxy-2,5-dimethyl-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.67 5.61 -39.54 0 5 -1 62 245.306 5 ↓
Lo Low (pH 4.5-6) 2.67 5.61 -8.31 1 5 0 64 246.314 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-[3-(3,4-dimethoxyphenyl)propyl]-1H-tetrazole 5-[3-(3,4-dimethoxyphenyl)propyl…

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.50 4.31 -41.54 0 6 -1 71 247.278 6 ↓
Lo Low (pH 4.5-6) 1.50 4.31 -11.1 1 6 0 73 248.286 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-[3-(2,5-dimethoxyphenyl)propyl]-1H-tetrazole 5-[3-(2,5-dimethoxyphenyl)propyl…

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 3.75 -42.01 0 6 -1 71 247.278 6 ↓
Lo Low (pH 4.5-6) 1.90 3.75 -8.83 1 6 0 73 248.286 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-[3-(2,4-dimethoxyphenyl)propyl]-1H-tetrazole 5-[3-(2,4-dimethoxyphenyl)propyl…

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 3.77 -41.63 0 6 -1 71 247.278 6 ↓
Lo Low (pH 4.5-6) 1.90 3.77 -9.33 1 6 0 73 248.286 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-[3-(3-chloro-4-methoxy-phenyl)propyl]-1H-tetrazole 5-[3-(3-chloro-4-methoxy-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) 2.52 4.96 -39.94 0 5 -1 62 251.697 5 ↓
Lo Low (pH 4.5-6) 2.52 4.96 -9.23 1 5 0 64 252.705 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-[3-(5-chloro-2-methoxy-phenyl)propyl]-1H-tetrazole 5-[3-(5-chloro-2-methoxy-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) 2.52 4.98 -39.62 0 5 -1 62 251.697 5 ↓
Lo Low (pH 4.5-6) 2.52 4.98 -7.46 1 5 0 64 252.705 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-[3-(3-isopropyl-4-methoxy-phenyl)propyl]-1H-tetrazole 5-[3-(3-isopropyl-4-methoxy-phen…

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.88 6.43 -39.42 0 5 -1 62 259.333 6 ↓
Lo Low (pH 4.5-6) 2.88 6.43 -8.15 1 5 0 64 260.341 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-[3-(4-ethoxy-2,5-dimethyl-phenyl)propyl]-1H-tetrazole 5-[3-(4-ethoxy-2,5-dimethyl-phen…

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.04 6.6 -39.51 0 5 -1 62 259.333 6 ↓
Lo Low (pH 4.5-6) 3.04 6.6 -8.28 1 5 0 64 260.341 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-[3-(4-bromophenyl)propyl]-1H-tetrazole 5-[3-(4-bromophenyl)propyl]-1H-t…

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 5.74 -37.27 0 4 -1 53 266.122 4 ↓
Lo Low (pH 4.5-6) 2.67 5.74 -7.11 1 4 0 54 267.13 4 ↓

Parameters Provided:

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

Permalink

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

Embed Link to Results