Warning: session_write_close() [function.session-write-close]: open(/tmp/session/sess_3625q05nfh2vc34qqc58tk7ek4, 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: N-(4-chloro-3-cyano-phenyl)-2,3-dihydro-1,4-dioxine-5-carboxamide N-(4-chloro-3-cyano-phenyl)-2,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.59 4.87 -13.3 1 5 0 71 264.668 2 ↓
Mid Mid (pH 6-8) 1.78 3.08 -38.3 0 5 -1 78 263.66 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(4-methylsulfanylphenyl)-5,6-dihydro-1,4-dioxine-2-carboxamide N-(4-methylsulfanylphenyl)-5,6-d…

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.67 -0.23 -13.03 1 4 0 48 251.307 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(2-methoxy-5-nitro-phenyl)-5,6-dihydro-1,4-dioxine-2-carboxamide N-(2-methoxy-5-nitro-phenyl)-5,6…

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.18 4.15 -18.63 1 8 0 103 280.236 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(2-methyl-3-nitro-phenyl)-5,6-dihydro-1,4-dioxine-2-carboxamide N-(2-methyl-3-nitro-phenyl)-5,6-…

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.55 5.58 -13.2 1 7 0 93 264.237 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 2-(2,3-dihydro-1,4-dioxine-5-carbonylamino)-5-nitro-benzoic 2-(2,3-dihydro-1,4-dioxine-5-car…

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.65 -41.52 1 9 -1 134 293.211 4 ↓
Hi High (pH 8-9.5) 1.40 4.17 -111.38 0 9 -2 140 292.203 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 2-(2,3-dihydro-1,4-dioxine-5-carbonylamino)-4-nitro-benzoic 2-(2,3-dihydro-1,4-dioxine-5-car…

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.7 -41.07 1 9 -1 134 293.211 4 ↓
Hi High (pH 8-9.5) 1.40 4.18 -114.83 0 9 -2 140 292.203 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 2-(2,3-dihydro-1,4-dioxine-5-carbonylamino)-5-iodo-benzoic 2-(2,3-dihydro-1,4-dioxine-5-car…

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.34 6.05 -43.84 1 6 -1 88 374.11 3 ↓
Hi High (pH 8-9.5) 2.52 4.56 -121.09 0 6 -2 94 373.102 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3,5-dibromo-2-(2,3-dihydro-1,4-dioxine-5-carbonylamino)benzoic 3,5-dibromo-2-(2,3-dihydro-1,4-d…

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.80 6.17 -43.44 1 6 -1 88 406.006 3 ↓
Hi High (pH 8-9.5) 2.98 4.65 -123.11 0 6 -2 94 404.998 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-bromo-2-(2,3-dihydro-1,4-dioxine-5-carbonylamino)benzoic 3-bromo-2-(2,3-dihydro-1,4-dioxi…

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.04 5.86 -51.61 1 6 -1 88 327.11 3 ↓
Hi High (pH 8-9.5) 2.22 4.05 -129.88 0 6 -2 94 326.102 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[3-(2-aminoethoxy)phenyl]-2,3-dihydro-1,4-dioxine-5-carboxamide N-[3-(2-aminoethoxy)phenyl]-2,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.07 1.77 -49.44 4 6 1 84 265.289 5 ↓
Hi High (pH 8-9.5) 0.07 1.33 -17.85 3 6 0 83 264.281 5 ↓
Hi High (pH 8-9.5) 0.26 -0.02 -75.63 3 6 0 91 264.281 5 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 4-(2,3-dihydro-1,4-dioxine-5-carbonylamino)-3-fluoro-benzoic 4-(2,3-dihydro-1,4-dioxine-5-car…

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 4.74 -51.29 1 6 -1 88 266.204 3 ↓
Hi High (pH 8-9.5) 1.42 3 -104.59 0 6 -2 94 265.196 3 ↓

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.92 2.29 -16.39 2 7 0 86 278.264 4 ↓
Hi High (pH 8-9.5) 1.10 0.52 -54.37 1 7 -1 92 277.256 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[4-(difluoromethoxy)-3-fluoro-phenyl]-2,3-dihydro-1,4-dioxine-5-carboxamide N-[4-(difluoromethoxy)-3-fluoro-…

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 3.7 -16.73 1 5 0 57 289.209 4 ↓
Hi High (pH 8-9.5) 2.12 1.95 -48.25 0 5 -1 63 288.201 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(2-bromo-4,5-dimethoxy-phenyl)-2,3-dihydro-1,4-dioxine-5-carboxamide N-(2-bromo-4,5-dimethoxy-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.62 4.03 -11.92 1 6 0 66 344.161 4 ↓
Hi High (pH 8-9.5) 1.80 2.39 -46.22 0 6 -1 72 343.153 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(4-amino-3-methoxy-phenyl)-2,3-dihydro-1,4-dioxine-5-carboxamide N-(4-amino-3-methoxy-phenyl)-2,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.70 1.36 -13.68 3 6 0 83 250.254 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[3-chloro-4-(dimethylamino)phenyl]-2,3-dihydro-1,4-dioxine-5-carboxamide N-[3-chloro-4-(dimethylamino)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) 1.94 5.66 -14.31 1 5 0 51 282.727 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(5-cyano-2-ethoxy-phenyl)-2,3-dihydro-1,4-dioxine-5-carboxamide N-(5-cyano-2-ethoxy-phenyl)-2,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.35 4.81 -15.49 1 6 0 81 274.276 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(4-chloro-3-fluoro-phenyl)-2,3-dihydro-1,4-dioxine-5-carboxamide N-(4-chloro-3-fluoro-phenyl)-2,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 4.63 -15.3 1 4 0 48 257.648 2 ↓

Analogs

37985987
37985987

Draw Identity 99% 90% 80% 70%

Popular Name: N-[3-(cyanomethoxy)phenyl]-2,3-dihydro-1,4-dioxine-5-carboxamide N-[3-(cyanomethoxy)phenyl]-2,3-d…

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.05 4.07 -21.54 1 6 0 81 260.249 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(5-chloro-2-methylsulfanyl-phenyl)-2,3-dihydro-1,4-dioxine-5-carboxamide N-(5-chloro-2-methylsulfanyl-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.27 5.71 -12.15 1 4 0 48 285.752 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(2-methoxy-4-methyl-phenyl)-2,3-dihydro-1,4-dioxine-5-carboxamide N-(2-methoxy-4-methyl-phenyl)-2,…

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.67 4.14 -12.26 1 5 0 57 249.266 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[4-chloro-3-(methylcarbamoyl)phenyl]-2,3-dihydro-1,4-dioxine-5-carboxamide N-[4-chloro-3-(methylcarbamoyl)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) 1.03 2.86 -18.53 2 6 0 77 296.71 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(3-ethynylphenyl)-2,3-dihydro-1,4-dioxine-5-carboxamide N-(3-ethynylphenyl)-2,3-dihydro-…

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.97 5.26 -16.44 1 4 0 48 229.235 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[4-(ureidomethyl)phenyl]-2,3-dihydro-1,4-dioxine-5-carboxamide N-[4-(ureidomethyl)phenyl]-2,3-d…

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.07 0.29 -18.96 4 7 0 103 277.28 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(2,3-difluorophenyl)-2,3-dihydro-1,4-dioxine-5-carboxamide N-(2,3-difluorophenyl)-2,3-dihyd…

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.47 4.22 -10.35 1 4 0 48 241.193 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3,5-dichloro-2-(2,3-dihydro-1,4-dioxine-5-carbonylamino)benzoic 3,5-dichloro-2-(2,3-dihydro-1,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) 2.54 5.96 -43.33 1 6 -1 88 317.104 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(5-carbamoyl-2-methyl-phenyl)-2,3-dihydro-1,4-dioxine-5-carboxamide N-(5-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) 0.43 1.63 -24.08 3 6 0 91 262.265 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(5-cyano-2-methyl-phenyl)-2,3-dihydro-1,4-dioxine-5-carboxamide N-(5-cyano-2-methyl-phenyl)-2,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.37 5.24 -17.03 1 5 0 71 244.25 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[4-(methylsulfonylmethyl)phenyl]-2,3-dihydro-1,4-dioxine-5-carboxamide N-[4-(methylsulfonylmethyl)pheny…

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.60 2.29 -23.59 1 6 0 82 297.332 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[2-[(1S)-1-hydroxyethyl]phenyl]-2,3-dihydro-1,4-dioxine-5-carboxamide N-[2-[(1S)-1-hydroxyethyl]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) 0.75 2.47 -13.7 2 5 0 68 249.266 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[2-[(1R)-1-hydroxyethyl]phenyl]-2,3-dihydro-1,4-dioxine-5-carboxamide N-[2-[(1R)-1-hydroxyethyl]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) 0.75 2.53 -13.86 2 5 0 68 249.266 3 ↓

Parameters Provided:

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

Permalink

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

Embed Link to Results