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

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.88 17.05 -64.74 2 4 1 43 538.539 8

Analogs

Draw Identity 99% 90% 80% 70%

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.88 17.04 -64.65 2 4 1 43 538.539 8

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
OXYR-1-E Oxytocin Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 48 0.28 Binding ≤ 10μM
V1AR-1-E Vasopressin V1a Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 2900 0.21 Binding ≤ 10μM
V1BR-1-E Vasopressin V1b Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 2900 0.21 Binding ≤ 10μM
V2R-1-E Vasopressin V2 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 7500 0.19 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
OXYR_RAT P70536 Oxytocin Receptor, Rat 48 0.28 Binding ≤ 1μM
OXYR_RAT P70536 Oxytocin Receptor, Rat 48 0.28 Binding ≤ 10μM
V1AR_RAT P30560 Vasopressin V1a Receptor, Rat 2900 0.21 Binding ≤ 10μM
V1BR_RAT P48974 Vasopressin V1b Receptor, Rat 2900 0.21 Binding ≤ 10μM
V2R_RAT Q00788 Vasopressin V2 Receptor, Rat 7500 0.19 Binding ≤ 10μM

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.53 13.47 -20.93 1 7 0 84 524.731 6
Mid Mid (pH 6-8) 2.53 13.95 -38.06 2 7 1 86 525.739 6

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
OXYR-1-E Oxytocin Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 170 0.26 Binding ≤ 10μM
V1AR-1-E Vasopressin V1a Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 2200 0.22 Binding ≤ 10μM
V1BR-1-E Vasopressin V1b Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 2200 0.22 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
OXYR_RAT P70536 Oxytocin Receptor, Rat 170 0.26 Binding ≤ 1μM
OXYR_RAT P70536 Oxytocin Receptor, Rat 170 0.26 Binding ≤ 10μM
V1AR_RAT P30560 Vasopressin V1a Receptor, Rat 2200 0.22 Binding ≤ 10μM
V1BR_RAT P48974 Vasopressin V1b Receptor, Rat 2200 0.22 Binding ≤ 10μM

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.06 8.06 -43.26 5 7 1 125 516.728 7
Hi High (pH 8-9.5) 2.06 7.75 -18.6 4 7 0 124 515.72 7

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
OXYR-1-E Oxytocin Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 170 0.26 Binding ≤ 10μM
V1AR-1-E Vasopressin V1a Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 2200 0.22 Binding ≤ 10μM
V1BR-1-E Vasopressin V1b Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 2200 0.22 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
OXYR_RAT P70536 Oxytocin Receptor, Rat 170 0.26 Binding ≤ 1μM
OXYR_RAT P70536 Oxytocin Receptor, Rat 170 0.26 Binding ≤ 10μM
V1AR_RAT P30560 Vasopressin V1a Receptor, Rat 2200 0.22 Binding ≤ 10μM
V1BR_RAT P48974 Vasopressin V1b Receptor, Rat 2200 0.22 Binding ≤ 10μM

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.06 8.47 -42.78 5 7 1 125 516.728 7
Hi High (pH 8-9.5) 2.06 8.23 -18.56 4 7 0 124 515.72 7

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
OXYR-1-E Oxytocin Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 40 0.27 Binding ≤ 10μM
V1AR-1-E Vasopressin V1a Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 1100 0.21 Binding ≤ 10μM
V1BR-1-E Vasopressin V1b Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 1100 0.21 Binding ≤ 10μM
V2R-1-E Vasopressin V2 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 3000 0.20 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
OXYR_RAT P70536 Oxytocin Receptor, Rat 40 0.27 Binding ≤ 1μM
OXYR_RAT P70536 Oxytocin Receptor, Rat 40 0.27 Binding ≤ 10μM
V1AR_RAT P30560 Vasopressin V1a Receptor, Rat 1100 0.21 Binding ≤ 10μM
V1BR_RAT P48974 Vasopressin V1b Receptor, Rat 1100 0.21 Binding ≤ 10μM
V2R_RAT Q00788 Vasopressin V2 Receptor, Rat 3000 0.20 Binding ≤ 10μM

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.98 3.12 -57.63 5 9 1 148 582.809 8
Mid Mid (pH 6-8) 0.98 2.79 -29.54 4 9 0 147 581.801 8

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
OXYR-1-E Oxytocin Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 40 0.27 Binding ≤ 10μM
V1AR-1-E Vasopressin V1a Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 1100 0.21 Binding ≤ 10μM
V1BR-1-E Vasopressin V1b Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 1100 0.21 Binding ≤ 10μM
V2R-1-E Vasopressin V2 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 3000 0.20 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
OXYR_RAT P70536 Oxytocin Receptor, Rat 40 0.27 Binding ≤ 1μM
OXYR_RAT P70536 Oxytocin Receptor, Rat 40 0.27 Binding ≤ 10μM
V1AR_RAT P30560 Vasopressin V1a Receptor, Rat 1100 0.21 Binding ≤ 10μM
V1BR_RAT P48974 Vasopressin V1b Receptor, Rat 1100 0.21 Binding ≤ 10μM
V2R_RAT Q00788 Vasopressin V2 Receptor, Rat 3000 0.20 Binding ≤ 10μM

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.98 3.08 -57.51 5 9 1 148 582.809 8
Mid Mid (pH 6-8) 0.98 2.76 -27.75 4 9 0 147 581.801 8

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
OXYR-1-E Oxytocin Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 6 0.27 Binding ≤ 10μM
V1AR-1-E Vasopressin V1a Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 500 0.21 Binding ≤ 10μM
V1BR-1-E Vasopressin V1b Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 500 0.21 Binding ≤ 10μM
V2R-1-E Vasopressin V2 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 740 0.20 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
OXYR_RAT P70536 Oxytocin Receptor, Rat 5.9 0.27 Binding ≤ 1μM
V1AR_RAT P30560 Vasopressin V1a Receptor, Rat 500 0.21 Binding ≤ 1μM
V1BR_RAT P48974 Vasopressin V1b Receptor, Rat 500 0.21 Binding ≤ 1μM
V2R_RAT Q00788 Vasopressin V2 Receptor, Rat 740 0.20 Binding ≤ 1μM
OXYR_RAT P70536 Oxytocin Receptor, Rat 5.9 0.27 Binding ≤ 10μM
V1AR_RAT P30560 Vasopressin V1a Receptor, Rat 500 0.21 Binding ≤ 10μM
V1BR_RAT P48974 Vasopressin V1b Receptor, Rat 500 0.21 Binding ≤ 10μM
V2R_RAT Q00788 Vasopressin V2 Receptor, Rat 740 0.20 Binding ≤ 10μM

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.76 13.09 -22.9 2 11 0 136 608.765 7
Hi High (pH 8-9.5) 2.58 12.01 -50.87 1 11 -1 142 607.757 7

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
OXYR-1-E Oxytocin Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 100 0.25 Binding ≤ 10μM
V1AR-1-E Vasopressin V1a Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 4000 0.19 Binding ≤ 10μM
V1BR-1-E Vasopressin V1b Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 4000 0.19 Binding ≤ 10μM
V2R-1-E Vasopressin V2 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 5500 0.19 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
OXYR_RAT P70536 Oxytocin Receptor, Rat 100 0.25 Binding ≤ 1μM
OXYR_RAT P70536 Oxytocin Receptor, Rat 100 0.25 Binding ≤ 10μM
V1AR_RAT P30560 Vasopressin V1a Receptor, Rat 4000 0.19 Binding ≤ 10μM
V1BR_RAT P48974 Vasopressin V1b Receptor, Rat 4000 0.19 Binding ≤ 10μM
V2R_RAT Q00788 Vasopressin V2 Receptor, Rat 5500 0.19 Binding ≤ 10μM

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.57 8.35 -56.27 3 8 1 117 578.821 6
Hi High (pH 8-9.5) 2.57 7.09 -24.43 2 8 0 113 577.813 6

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
OXYR-1-E Oxytocin Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 100 0.25 Binding ≤ 10μM
V1AR-1-E Vasopressin V1a Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 4000 0.19 Binding ≤ 10μM
V1BR-1-E Vasopressin V1b Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 4000 0.19 Binding ≤ 10μM
V2R-1-E Vasopressin V2 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 5500 0.19 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
OXYR_RAT P70536 Oxytocin Receptor, Rat 100 0.25 Binding ≤ 1μM
OXYR_RAT P70536 Oxytocin Receptor, Rat 100 0.25 Binding ≤ 10μM
V1AR_RAT P30560 Vasopressin V1a Receptor, Rat 4000 0.19 Binding ≤ 10μM
V1BR_RAT P48974 Vasopressin V1b Receptor, Rat 4000 0.19 Binding ≤ 10μM
V2R_RAT Q00788 Vasopressin V2 Receptor, Rat 5500 0.19 Binding ≤ 10μM

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.57 8.31 -57.6 3 8 1 117 578.821 6
Hi High (pH 8-9.5) 2.57 6.95 -23.57 2 8 0 113 577.813 6

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
OXYR-1-E Oxytocin Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 100 0.25 Binding ≤ 10μM
V1AR-1-E Vasopressin V1a Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 4000 0.19 Binding ≤ 10μM
V1BR-1-E Vasopressin V1b Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 4000 0.19 Binding ≤ 10μM
V2R-1-E Vasopressin V2 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 5500 0.19 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
OXYR_RAT P70536 Oxytocin Receptor, Rat 100 0.25 Binding ≤ 1μM
OXYR_RAT P70536 Oxytocin Receptor, Rat 100 0.25 Binding ≤ 10μM
V1AR_RAT P30560 Vasopressin V1a Receptor, Rat 4000 0.19 Binding ≤ 10μM
V1BR_RAT P48974 Vasopressin V1b Receptor, Rat 4000 0.19 Binding ≤ 10μM
V2R_RAT Q00788 Vasopressin V2 Receptor, Rat 5500 0.19 Binding ≤ 10μM

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.57 8.3 -60.33 3 8 1 117 578.821 6
Hi High (pH 8-9.5) 2.57 7.09 -29.72 2 8 0 113 577.813 6

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
OXYR-1-E Oxytocin Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 100 0.25 Binding ≤ 10μM
V1AR-1-E Vasopressin V1a Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 4000 0.19 Binding ≤ 10μM
V1BR-1-E Vasopressin V1b Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 4000 0.19 Binding ≤ 10μM
V2R-1-E Vasopressin V2 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 5500 0.19 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
OXYR_RAT P70536 Oxytocin Receptor, Rat 100 0.25 Binding ≤ 1μM
OXYR_RAT P70536 Oxytocin Receptor, Rat 100 0.25 Binding ≤ 10μM
V1AR_RAT P30560 Vasopressin V1a Receptor, Rat 4000 0.19 Binding ≤ 10μM
V1BR_RAT P48974 Vasopressin V1b Receptor, Rat 4000 0.19 Binding ≤ 10μM
V2R_RAT Q00788 Vasopressin V2 Receptor, Rat 5500 0.19 Binding ≤ 10μM

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.57 8.16 -54.18 3 8 1 117 578.821 6
Hi High (pH 8-9.5) 2.57 6.78 -24.25 2 8 0 113 577.813 6

Analogs

3915327
3915327

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
OXYR-1-E Oxytocin Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 54 0.27 Binding ≤ 10μM
V1AR-1-E Vasopressin V1a Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 3600 0.21 Binding ≤ 10μM
V1BR-1-E Vasopressin V1b Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 3600 0.21 Binding ≤ 10μM
V2R-1-E Vasopressin V2 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 7400 0.19 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
OXYR_RAT P70536 Oxytocin Receptor, Rat 54 0.27 Binding ≤ 1μM
OXYR_RAT P70536 Oxytocin Receptor, Rat 54 0.27 Binding ≤ 10μM
V1AR_RAT P30560 Vasopressin V1a Receptor, Rat 3600 0.21 Binding ≤ 10μM
V1BR_RAT P48974 Vasopressin V1b Receptor, Rat 3600 0.21 Binding ≤ 10μM
V2R_RAT Q00788 Vasopressin V2 Receptor, Rat 7400 0.19 Binding ≤ 10μM

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.99 -59.2 4 7 1 111 550.811 8
Hi High (pH 8-9.5) 1.41 7.66 -24.93 3 7 0 110 549.803 8

Analogs

3915327
3915327

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
OXYR-1-E Oxytocin Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 54 0.27 Binding ≤ 10μM
V1AR-1-E Vasopressin V1a Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 3600 0.21 Binding ≤ 10μM
V1BR-1-E Vasopressin V1b Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 3600 0.21 Binding ≤ 10μM
V2R-1-E Vasopressin V2 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 7400 0.19 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
OXYR_RAT P70536 Oxytocin Receptor, Rat 54 0.27 Binding ≤ 1μM
OXYR_RAT P70536 Oxytocin Receptor, Rat 54 0.27 Binding ≤ 10μM
V1AR_RAT P30560 Vasopressin V1a Receptor, Rat 3600 0.21 Binding ≤ 10μM
V1BR_RAT P48974 Vasopressin V1b Receptor, Rat 3600 0.21 Binding ≤ 10μM
V2R_RAT Q00788 Vasopressin V2 Receptor, Rat 7400 0.19 Binding ≤ 10μM

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.97 -54.55 4 7 1 111 550.811 8
Hi High (pH 8-9.5) 1.41 7.64 -26.23 3 7 0 110 549.803 8

Analogs

3915327
3915327

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
OXYR-1-E Oxytocin Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 54 0.27 Binding ≤ 10μM
V1AR-1-E Vasopressin V1a Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 3600 0.21 Binding ≤ 10μM
V1BR-1-E Vasopressin V1b Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 3600 0.21 Binding ≤ 10μM
V2R-1-E Vasopressin V2 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 7400 0.19 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
OXYR_RAT P70536 Oxytocin Receptor, Rat 54 0.27 Binding ≤ 1μM
OXYR_RAT P70536 Oxytocin Receptor, Rat 54 0.27 Binding ≤ 10μM
V1AR_RAT P30560 Vasopressin V1a Receptor, Rat 3600 0.21 Binding ≤ 10μM
V1BR_RAT P48974 Vasopressin V1b Receptor, Rat 3600 0.21 Binding ≤ 10μM
V2R_RAT Q00788 Vasopressin V2 Receptor, Rat 7400 0.19 Binding ≤ 10μM

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 8.08 -55.93 4 7 1 111 550.811 8
Hi High (pH 8-9.5) 1.41 7.75 -26.61 3 7 0 110 549.803 8

Analogs

3915327
3915327

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
OXYR-1-E Oxytocin Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 54 0.27 Binding ≤ 10μM
V1AR-1-E Vasopressin V1a Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 3600 0.21 Binding ≤ 10μM
V1BR-1-E Vasopressin V1b Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 3600 0.21 Binding ≤ 10μM
V2R-1-E Vasopressin V2 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 7400 0.19 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
OXYR_RAT P70536 Oxytocin Receptor, Rat 54 0.27 Binding ≤ 1μM
OXYR_RAT P70536 Oxytocin Receptor, Rat 54 0.27 Binding ≤ 10μM
V1AR_RAT P30560 Vasopressin V1a Receptor, Rat 3600 0.21 Binding ≤ 10μM
V1BR_RAT P48974 Vasopressin V1b Receptor, Rat 3600 0.21 Binding ≤ 10μM
V2R_RAT Q00788 Vasopressin V2 Receptor, Rat 7400 0.19 Binding ≤ 10μM

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 8.08 -61.24 4 7 1 111 550.811 8
Hi High (pH 8-9.5) 1.41 7.75 -25.15 3 7 0 110 549.803 8

Analogs

3915328
3915328

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
OXYR-1-E Oxytocin Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 5 0.29 Binding ≤ 10μM
V1AR-1-E Vasopressin V1a Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 530 0.22 Binding ≤ 10μM
V1BR-1-E Vasopressin V1b Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 530 0.22 Binding ≤ 10μM
V2R-1-E Vasopressin V2 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 1300 0.21 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
OXYR_RAT P70536 Oxytocin Receptor, Rat 4.9 0.29 Binding ≤ 1μM
V1AR_RAT P30560 Vasopressin V1a Receptor, Rat 530 0.22 Binding ≤ 1μM
V1BR_RAT P48974 Vasopressin V1b Receptor, Rat 530 0.22 Binding ≤ 1μM
OXYR_RAT P70536 Oxytocin Receptor, Rat 4.9 0.29 Binding ≤ 10μM
V1AR_RAT P30560 Vasopressin V1a Receptor, Rat 530 0.22 Binding ≤ 10μM
V1BR_RAT P48974 Vasopressin V1b Receptor, Rat 530 0.22 Binding ≤ 10μM
V2R_RAT Q00788 Vasopressin V2 Receptor, Rat 1300 0.21 Binding ≤ 10μM

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.96 10.46 -51.16 2 8 1 105 594.864 9
Hi High (pH 8-9.5) 2.96 8.15 -25.4 1 8 0 104 593.856 9

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
OXYR-1-E Oxytocin Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 240 0.25 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
OXYR_RAT P70536 Oxytocin Receptor, Rat 240 0.25 Binding ≤ 1μM
OXYR_RAT P70536 Oxytocin Receptor, Rat 240 0.25 Binding ≤ 10μM

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.75 13.08 -13.31 1 7 0 93 530.731 9

Analogs

42988746
42988746
42988748
42988748

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
Z50597-1-O Rattus Norvegicus (cluster #1 Of 12), Other Other 1 0.36 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
Z50597 Z50597 Rattus Norvegicus 0.6 0.37 Functional ≤ 10μM

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 7.3 -62.18 6 7 1 113 475.613 5
Hi High (pH 8-9.5) 2.27 7.03 -19.6 5 7 0 111 474.605 5

Analogs

Draw Identity 99% 90% 80% 70%

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.60 6.55 -55.15 3 6 1 74 406.506 2
Hi High (pH 8-9.5) 1.60 4.67 -16.61 2 6 0 73 405.498 2

Analogs

Draw Identity 99% 90% 80% 70%

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.20 0.3 -49.87 2 6 1 61 471.643 8

Analogs

Draw Identity 99% 90% 80% 70%

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.48 0.53 -22.25 1 6 0 68 474.601 7

Analogs

Draw Identity 99% 90% 80% 70%

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.90 0.25 -17.25 1 6 0 68 476.617 6

Analogs

Draw Identity 99% 90% 80% 70%

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.42 0.08 -21.34 1 6 0 68 482.596 8

Analogs

14987144
14987144

Draw Identity 99% 90% 80% 70%

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.90 -1.7 -65.1 3 6 1 72 471.643 8

Analogs

Draw Identity 99% 90% 80% 70%

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.54 -0.45 -18.42 1 6 0 68 478.633 7

Analogs

Draw Identity 99% 90% 80% 70%

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.40 0.5 -55.48 2 5 1 56 429.606 8

Analogs

Draw Identity 99% 90% 80% 70%

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 -3.09 -24.74 2 8 0 97 440.544 7

Analogs

Draw Identity 99% 90% 80% 70%

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.23 1.2 -57.07 2 7 1 74 435.548 5

Analogs

Draw Identity 99% 90% 80% 70%

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.98 -0.86 -51.96 3 7 1 85 477.581 7

Analogs

Draw Identity 99% 90% 80% 70%

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.98 -3.95 -20.06 2 8 0 101 487.556 5

Analogs

Draw Identity 99% 90% 80% 70%

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.99 -1.56 -16.99 1 6 0 72 461.587 4

Analogs

Draw Identity 99% 90% 80% 70%

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.57 0.04 -58.69 2 4 1 43 461.651 6

Analogs

Draw Identity 99% 90% 80% 70%

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.39 1.01 -61.27 2 6 1 61 497.729 9

Analogs

Draw Identity 99% 90% 80% 70%

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.05 -0.84 -18.47 1 6 0 72 481.596 5

Analogs

11782317
11782317

Draw Identity 99% 90% 80% 70%

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 1.74 -59.81 2 5 1 52 437.604 7

Analogs

Draw Identity 99% 90% 80% 70%

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.90 -0.24 -17.11 1 6 0 68 468.569 7

Analogs

Draw Identity 99% 90% 80% 70%

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.57 0.6 -72.41 3 5 1 63 479.547 5

Analogs

Draw Identity 99% 90% 80% 70%

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.54 -0.34 -18.45 1 6 0 72 497.639 6

Analogs

Draw Identity 99% 90% 80% 70%

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 -1.16 -15.03 1 8 0 89 487.604 6

Analogs

Draw Identity 99% 90% 80% 70%

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.53 -0.87 -15.62 1 5 0 59 426.582 4

Analogs

Draw Identity 99% 90% 80% 70%

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 -2.2 -16.35 1 7 0 84 448.548 4

Analogs

Draw Identity 99% 90% 80% 70%

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.99 -0.06 -58.65 2 5 1 52 463.623 6

Analogs

12100258
12100258

Draw Identity 99% 90% 80% 70%

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.67 -1.04 -57.35 3 4 1 54 455.622 5

Analogs

Draw Identity 99% 90% 80% 70%

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 0.6 -13.56 1 7 0 85 411.502 4

Analogs

Draw Identity 99% 90% 80% 70%

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.31 -0.26 -53.21 2 6 1 61 493.649 7

Analogs

Draw Identity 99% 90% 80% 70%

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.63 -1.77 -23.19 1 8 0 86 494.588 7

Analogs

Draw Identity 99% 90% 80% 70%

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.60 -1.69 -16.4 2 7 0 87 494.595 4

Analogs

Draw Identity 99% 90% 80% 70%

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.50 -1.68 -58.59 2 5 1 46 462.658 6

Analogs

Draw Identity 99% 90% 80% 70%

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.26 -1.6 -47.56 4 7 1 92 489.592 6

Parameters Provided:

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

Permalink

Embed Link to Results