Warning: session_write_close() [function.session-write-close]: open(/tmp/session/sess_psq44gb8n0ogprd5lf0s2uupu5, 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

42431881
42431881

Draw Identity 99% 90% 80% 70%

Popular Name: (R)-benzothiophen-2-yl(2-thienyl)methanamine (R)-benzothiophen-2-yl(2-thienyl…

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.01 6.53 -5.35 2 1 0 26 245.372 2 ↓
Mid Mid (pH 6-8) 4.01 6.87 -42.45 3 1 1 28 246.38 2 ↓

Analogs

42431880
42431880

Draw Identity 99% 90% 80% 70%

Popular Name: (S)-benzothiophen-2-yl(2-thienyl)methanamine (S)-benzothiophen-2-yl(2-thienyl…

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.01 6.53 -5.48 2 1 0 26 245.372 2 ↓
Mid Mid (pH 6-8) 4.01 6.87 -42.44 3 1 1 28 246.38 2 ↓

Analogs

42431883
42431883

Draw Identity 99% 90% 80% 70%

Popular Name: (S)-benzothiophen-2-yl-(5-methyl-2-thienyl)methanamine (S)-benzothiophen-2-yl-(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) 4.23 7.36 -5.7 2 1 0 26 259.399 2 ↓
Mid Mid (pH 6-8) 4.23 7.7 -42.2 3 1 1 28 260.407 2 ↓

Analogs

42431882
42431882

Draw Identity 99% 90% 80% 70%

Popular Name: (R)-benzothiophen-2-yl-(5-methyl-2-thienyl)methanamine (R)-benzothiophen-2-yl-(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) 4.23 7.36 -5.62 2 1 0 26 259.399 2 ↓
Mid Mid (pH 6-8) 4.23 7.7 -42.23 3 1 1 28 260.407 2 ↓

Analogs

42431885
42431885

Draw Identity 99% 90% 80% 70%

Popular Name: (S)-benzothiophen-2-yl-(5-ethyl-2-thienyl)methanamine (S)-benzothiophen-2-yl-(5-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) 4.80 8.15 -5.43 2 1 0 26 273.426 3 ↓
Mid Mid (pH 6-8) 4.80 8.49 -42.2 3 1 1 28 274.434 3 ↓

Analogs

42431884
42431884

Draw Identity 99% 90% 80% 70%

Popular Name: (R)-benzothiophen-2-yl-(5-ethyl-2-thienyl)methanamine (R)-benzothiophen-2-yl-(5-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) 4.80 8.16 -5.51 2 1 0 26 273.426 3 ↓
Mid Mid (pH 6-8) 4.80 8.49 -42.27 3 1 1 28 274.434 3 ↓

Analogs

42431887
42431887

Draw Identity 99% 90% 80% 70%

Popular Name: (S)-benzothiophen-2-yl-(5-chloro-2-thienyl)methanamine (S)-benzothiophen-2-yl-(5-chloro…

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.81 7.15 -5.34 2 1 0 26 279.817 2 ↓
Mid Mid (pH 6-8) 4.81 7.49 -46.17 3 1 1 28 280.825 2 ↓

Analogs

42431886
42431886

Draw Identity 99% 90% 80% 70%

Popular Name: (R)-benzothiophen-2-yl-(5-chloro-2-thienyl)methanamine (R)-benzothiophen-2-yl-(5-chloro…

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.81 7.15 -5.18 2 1 0 26 279.817 2 ↓
Mid Mid (pH 6-8) 4.81 7.49 -46.19 3 1 1 28 280.825 2 ↓

Analogs

42431897
42431897
48855152
48855152
48855156
48855156

Draw Identity 99% 90% 80% 70%

Popular Name: (1S)-1-(benzothiophen-2-yl)-N-methyl-1-(5-methyl-2-thienyl)methanamine (1S)-1-(benzothiophen-2-yl)-N-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) 4.60 9.46 -36.87 2 1 1 17 274.434 3 ↓
Mid Mid (pH 6-8) 4.60 8.12 -5.65 1 1 0 12 273.426 3 ↓

Analogs

48855152
48855152
48855156
48855156
42431896
42431896

Draw Identity 99% 90% 80% 70%

Popular Name: (1R)-1-(benzothiophen-2-yl)-N-methyl-1-(5-methyl-2-thienyl)methanamine (1R)-1-(benzothiophen-2-yl)-N-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) 4.60 9.46 -36.86 2 1 1 17 274.434 3 ↓
Mid Mid (pH 6-8) 4.60 8.14 -5.8 1 1 0 12 273.426 3 ↓

Analogs

42431901
42431901

Draw Identity 99% 90% 80% 70%

Popular Name: (1S)-1-(benzothiophen-2-yl)-N-methyl-1-(2-thienyl)methanamine (1S)-1-(benzothiophen-2-yl)-N-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) 4.38 8.62 -37.11 2 1 1 17 260.407 3 ↓
Mid Mid (pH 6-8) 4.38 7.31 -5.6 1 1 0 12 259.399 3 ↓

Analogs

42431900
42431900

Draw Identity 99% 90% 80% 70%

Popular Name: (1R)-1-(benzothiophen-2-yl)-N-methyl-1-(2-thienyl)methanamine (1R)-1-(benzothiophen-2-yl)-N-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) 4.38 8.63 -37.08 2 1 1 17 260.407 3 ↓
Mid Mid (pH 6-8) 4.38 7.3 -5.35 1 1 0 12 259.399 3 ↓

Analogs

42431903
42431903

Draw Identity 99% 90% 80% 70%

Popular Name: (1R)-1-(benzothiophen-2-yl)-1-(5-chloro-2-thienyl)-N-methyl-methanamine (1R)-1-(benzothiophen-2-yl)-1-(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) 5.18 9.25 -40.48 2 1 1 17 294.852 3 ↓
Mid Mid (pH 6-8) 5.18 7.94 -5.32 1 1 0 12 293.844 3 ↓

Analogs

42431902
42431902

Draw Identity 99% 90% 80% 70%

Popular Name: (1S)-1-(benzothiophen-2-yl)-1-(5-chloro-2-thienyl)-N-methyl-methanamine (1S)-1-(benzothiophen-2-yl)-1-(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) 5.18 9.26 -40.47 2 1 1 17 294.852 3 ↓
Mid Mid (pH 6-8) 5.18 7.92 -5.12 1 1 0 12 293.844 3 ↓

Analogs

42431908
42431908

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(S)-benzothiophen-2-yl(2-thienyl)methyl]ethanamine N-[(S)-benzothiophen-2-yl(2-thie…

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 9.48 -35.35 2 1 1 17 274.434 4 ↓
Mid Mid (pH 6-8) 4.76 8.3 -5.24 1 1 0 12 273.426 4 ↓

Analogs

42431907
42431907

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(R)-benzothiophen-2-yl(2-thienyl)methyl]ethanamine N-[(R)-benzothiophen-2-yl(2-thie…

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 9.48 -35.36 2 1 1 17 274.434 4 ↓
Mid Mid (pH 6-8) 4.76 8.25 -5.06 1 1 0 12 273.426 4 ↓

Analogs

42431911
42431911

Draw Identity 99% 90% 80% 70%

Popular Name: (S)-benzothiophen-2-yl-(5-bromo-2-thienyl)methanamine (S)-benzothiophen-2-yl-(5-bromo-…

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.94 7.26 -5.36 2 1 0 26 324.268 2 ↓
Mid Mid (pH 6-8) 4.94 7.6 -46.28 3 1 1 28 325.276 2 ↓

Analogs

42431910
42431910

Draw Identity 99% 90% 80% 70%

Popular Name: (R)-benzothiophen-2-yl-(5-bromo-2-thienyl)methanamine (R)-benzothiophen-2-yl-(5-bromo-…

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.94 7.26 -5.19 2 1 0 26 324.268 2 ↓
Mid Mid (pH 6-8) 4.94 7.6 -46.28 3 1 1 28 325.276 2 ↓

Analogs

42431913
42431913

Draw Identity 99% 90% 80% 70%

Popular Name: (1R)-1-(benzothiophen-2-yl)-1-(5-bromo-2-thienyl)-N-methyl-methanamine (1R)-1-(benzothiophen-2-yl)-1-(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) 5.31 9.35 -40.6 2 1 1 17 339.303 3 ↓
Mid Mid (pH 6-8) 5.31 8.04 -5.34 1 1 0 12 338.295 3 ↓

Analogs

42431912
42431912

Draw Identity 99% 90% 80% 70%

Popular Name: (1S)-1-(benzothiophen-2-yl)-1-(5-bromo-2-thienyl)-N-methyl-methanamine (1S)-1-(benzothiophen-2-yl)-1-(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) 5.31 9.36 -40.61 2 1 1 17 339.303 3 ↓
Mid Mid (pH 6-8) 5.31 8.03 -5.2 1 1 0 12 338.295 3 ↓

Analogs

42431993
42431993

Draw Identity 99% 90% 80% 70%

Popular Name: (S)-benzothiophen-2-yl-(5-methyl-2-thienyl)methanol (S)-benzothiophen-2-yl-(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) 4.18 7.15 -6.07 1 1 0 20 260.383 2 ↓

Analogs

42431992
42431992

Draw Identity 99% 90% 80% 70%

Popular Name: (R)-benzothiophen-2-yl-(5-methyl-2-thienyl)methanol (R)-benzothiophen-2-yl-(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) 4.18 7.15 -6.1 1 1 0 20 260.383 2 ↓

Analogs

42431995
42431995

Draw Identity 99% 90% 80% 70%

Popular Name: (S)-benzothiophen-2-yl-(5-ethyl-2-thienyl)methanol (S)-benzothiophen-2-yl-(5-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) 4.76 7.94 -5.87 1 1 0 20 274.41 3 ↓

Analogs

42431994
42431994

Draw Identity 99% 90% 80% 70%

Popular Name: (R)-benzothiophen-2-yl-(5-ethyl-2-thienyl)methanol (R)-benzothiophen-2-yl-(5-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) 4.76 7.94 -5.89 1 1 0 20 274.41 3 ↓

Analogs

42432005
42432005

Draw Identity 99% 90% 80% 70%

Popular Name: (S)-benzothiophen-2-yl-(5-chloro-2-thienyl)methanol (S)-benzothiophen-2-yl-(5-chloro…

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.95 -5.57 1 1 0 20 280.801 2 ↓

Analogs

42432004
42432004

Draw Identity 99% 90% 80% 70%

Popular Name: (R)-benzothiophen-2-yl-(5-chloro-2-thienyl)methanol (R)-benzothiophen-2-yl-(5-chloro…

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.94 -5.59 1 1 0 20 280.801 2 ↓

Analogs

42432013
42432013

Draw Identity 99% 90% 80% 70%

Popular Name: (S)-benzothiophen-2-yl-(5-bromo-2-thienyl)methanol (S)-benzothiophen-2-yl-(5-bromo-…

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.89 7.05 -5.59 1 1 0 20 325.252 2 ↓

Analogs

42432012
42432012

Draw Identity 99% 90% 80% 70%

Popular Name: (R)-benzothiophen-2-yl-(5-bromo-2-thienyl)methanol (R)-benzothiophen-2-yl-(5-bromo-…

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.89 7.05 -5.64 1 1 0 20 325.252 2 ↓

Analogs

42432015
42432015

Draw Identity 99% 90% 80% 70%

Popular Name: 2-[(R)-chloro(2-thienyl)methyl]benzothiophene 2-[(R)-chloro(2-thienyl)methyl]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) 5.20 10.12 -6.5 0 0 0 0 264.802 2 ↓

Analogs

42432014
42432014

Draw Identity 99% 90% 80% 70%

Popular Name: 2-[(S)-chloro(2-thienyl)methyl]benzothiophene 2-[(S)-chloro(2-thienyl)methyl]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) 5.20 10.12 -6.49 0 0 0 0 264.802 2 ↓

Parameters Provided:

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

Permalink

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

Embed Link to Results