Warning: session_write_close() [function.session-write-close]: open(/tmp/session/sess_q3ebf10pia0uhe1hs7ev8h3071, 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: (2R)-2-phenyl-2-[[2-(tetrazol-1-yl)acetyl]amino]propanoic (2R)-2-phenyl-2-[[2-(tetrazol-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) -0.30 5.76 -69.55 1 8 -1 113 274.26 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: (2S)-2-phenyl-2-[[2-(tetrazol-1-yl)acetyl]amino]propanoic (2S)-2-phenyl-2-[[2-(tetrazol-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) -0.30 5.75 -65.48 1 8 -1 113 274.26 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[[4-(2-aminoethyl)phenyl]methyl]-2-(tetrazol-1-yl)acetamide N-[[4-(2-aminoethyl)phenyl]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) -1.19 2.68 -66.27 4 7 1 100 261.309 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: (2S)-2-phenyl-2-[[2-(tetrazol-1-yl)acetyl]amino]acetic (2S)-2-phenyl-2-[[2-(tetrazol-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) -0.75 3.89 -67.81 1 8 -1 113 260.233 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: (2R)-2-phenyl-2-[[2-(tetrazol-1-yl)acetyl]amino]acetic (2R)-2-phenyl-2-[[2-(tetrazol-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) -0.75 3.89 -71.49 1 8 -1 113 260.233 5 ↓

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.29 5.85 -28.03 1 8 0 99 368.191 7 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 2-[5-[(isopropyl-methyl-amino)methyl]tetrazol-1-yl]-N-[(2-methoxyphenyl)methyl]acetamide 2-[5-[(isopropyl-methyl-amino)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) 0.41 5.06 -52.37 2 8 1 86 333.416 8 ↓
Mid Mid (pH 6-8) 0.41 2.65 -16.7 1 8 0 85 332.408 8 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(2-dimethylaminoethyl)-N-[(4-fluorophenyl)methyl]-2-(tetrazol-1-yl)acetamide N-(2-dimethylaminoethyl)-N-[(4-f…

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.26 8.2 -74.46 1 7 1 68 307.353 7 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(1R)-1-(3,4-difluorophenyl)ethyl]-2-(tetrazol-1-yl)acetamide N-[(1R)-1-(3,4-difluorophenyl)et…

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.64 4.8 -23.06 1 6 0 73 267.239 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(1S)-1-(3,4-difluorophenyl)ethyl]-2-(tetrazol-1-yl)acetamide N-[(1S)-1-(3,4-difluorophenyl)et…

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.64 4.81 -22.84 1 6 0 73 267.239 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-allyl-N-[(3-cyanophenyl)methyl]-2-(tetrazol-1-yl)acetamide N-allyl-N-[(3-cyanophenyl)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 7.8 -27.59 0 7 0 88 282.307 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(1S)-2-hydroxy-1-phenyl-ethyl]-2-(tetrazol-1-yl)acetamide N-[(1S)-2-hydroxy-1-phenyl-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.63 1.51 -21.15 2 7 0 93 247.258 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(1R)-2-hydroxy-1-phenyl-ethyl]-2-(tetrazol-1-yl)acetamide N-[(1R)-2-hydroxy-1-phenyl-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.63 1.51 -20.87 2 7 0 93 247.258 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-benzyl-N-(2-hydroxyethyl)-2-(tetrazol-1-yl)acetamide N-benzyl-N-(2-hydroxyethyl)-2-(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) -0.56 3.87 -22.27 1 7 0 84 261.285 6 ↓

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.66 6.2 -30.12 1 9 0 108 333.348 9 ↓

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.66 6.19 -28.27 1 9 0 108 333.348 9 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(4-fluorophenyl)methyl]-N-methyl-2-(tetrazol-1-yl)acetamide N-[(4-fluorophenyl)methyl]-N-met…

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.23 5.98 -23.25 0 6 0 64 249.249 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 2-(tetrazol-1-yl)-N-[(1S)-1-[3-(trifluoromethyl)phenyl]butyl]acetamide 2-(tetrazol-1-yl)-N-[(1S)-1-[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) 1.41 7.08 -23.65 1 6 0 73 327.31 7 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 2-(tetrazol-1-yl)-N-[(1R)-1-[3-(trifluoromethyl)phenyl]butyl]acetamide 2-(tetrazol-1-yl)-N-[(1R)-1-[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) 1.41 7.08 -24.36 1 6 0 73 327.31 7 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(1S)-2-methyl-1-[3-(trifluoromethyl)phenyl]propyl]-2-(tetrazol-1-yl)acetamide N-[(1S)-2-methyl-1-[3-(trifluoro…

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 6.9 -24.47 1 6 0 73 327.31 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(1R)-2-methyl-1-[3-(trifluoromethyl)phenyl]propyl]-2-(tetrazol-1-yl)acetamide N-[(1R)-2-methyl-1-[3-(trifluoro…

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 7.12 -24.4 1 6 0 73 327.31 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 2-(5-ethyltetrazol-1-yl)-N-[(3-methoxyphenyl)methyl]acetamide 2-(5-ethyltetrazol-1-yl)-N-[(3-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) 0.52 3.62 -18.7 1 7 0 82 275.312 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(3-chlorophenyl)methyl]-2-(5-ethyltetrazol-1-yl)acetamide N-[(3-chlorophenyl)methyl]-2-(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.14 4.83 -17.95 1 6 0 73 279.731 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 2-(5-ethyltetrazol-1-yl)-N-[(1S)-1-(4-fluorophenyl)ethyl]acetamide 2-(5-ethyltetrazol-1-yl)-N-[(1S)…

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.21 5.23 -19.4 1 6 0 73 277.303 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 2-(5-ethyltetrazol-1-yl)-N-[(1R)-1-(4-fluorophenyl)ethyl]acetamide 2-(5-ethyltetrazol-1-yl)-N-[(1R)…

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.21 5.24 -20.02 1 6 0 73 277.303 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(2-bromophenyl)methyl]-2-(5-ethyltetrazol-1-yl)-N-methyl-acetamide N-[(2-bromophenyl)methyl]-2-(5-e…

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.55 -20.13 0 6 0 64 338.209 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 2-(5-ethyltetrazol-1-yl)-N-(o-tolylmethyl)acetamide 2-(5-ethyltetrazol-1-yl)-N-(o-to…

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.88 5.11 -17.79 1 6 0 73 259.313 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 2-(5-ethyltetrazol-1-yl)-N-[(4-hydroxyphenyl)methyl]-N-methyl-acetamide 2-(5-ethyltetrazol-1-yl)-N-[(4-h…

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 3.54 -22.14 1 7 0 84 275.312 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-[[[2-(tetrazol-1-yl)acetyl]amino]methyl]benzoic 3-[[[2-(tetrazol-1-yl)acetyl]ami…

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 4.43 -65.63 1 8 -1 113 260.233 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 4-[[methyl-[2-(tetrazol-1-yl)acetyl]amino]methyl]benzoic 4-[[methyl-[2-(tetrazol-1-yl)ace…

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.02 6.48 -68.24 0 8 -1 104 274.26 5 ↓

Analogs

41867813
41867813

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(1R)-1-(4-isopropoxy-3-methoxy-phenyl)ethyl]-2-(tetrazol-1-yl)acetamide N-[(1R)-1-(4-isopropoxy-3-methox…

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.77 5.42 -26.24 1 8 0 91 319.365 7 ↓

Analogs

41867811
41867811

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(1S)-1-(4-isopropoxy-3-methoxy-phenyl)ethyl]-2-(tetrazol-1-yl)acetamide N-[(1S)-1-(4-isopropoxy-3-methox…

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.77 5.44 -25.59 1 8 0 91 319.365 7 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(4-fluoro-3-methyl-phenyl)methyl]-2-(tetrazol-1-yl)acetamide N-[(4-fluoro-3-methyl-phenyl)met…

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.36 4.56 -21.96 1 6 0 73 249.249 4 ↓

Parameters Provided:

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

Permalink

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

Embed Link to Results