UCSF
ZINC Item Suppliers, Protomers, & Similar Substances

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 88 0.32 Binding ≤ 10μM
AA2AR-1-E Adenosine A2a Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 1232 0.27 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 88 0.32 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 88 0.32 Binding ≤ 10μM
AA2AR_HUMAN P29274 Adenosine A2a Receptor, Human 1232 0.27 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) 4.38 12.94 -9.34 1 6 0 69 434.927 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
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 88 0.32 Binding ≤ 10μM
AA2AR-1-E Adenosine A2a Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 1232 0.27 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 88 0.32 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 88 0.32 Binding ≤ 10μM
AA2AR_HUMAN P29274 Adenosine A2a Receptor, Human 1232 0.27 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) 4.38 12.97 -9.27 1 6 0 69 434.927 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
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 148 0.30 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_HUMAN P30542 Adenosine A1 Receptor, Human 148 0.30 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 15 0.34 Binding ≤ 1μM
AA1R_HUMAN P30542 Adenosine A1 Receptor, Human 148 0.30 Binding ≤ 10μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 15 0.34 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) 4.83 13.64 -9.45 1 6 0 69 448.954 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
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 148 0.30 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_HUMAN P30542 Adenosine A1 Receptor, Human 148 0.30 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 15 0.34 Binding ≤ 1μM
AA1R_HUMAN P30542 Adenosine A1 Receptor, Human 148 0.30 Binding ≤ 10μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 15 0.34 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) 4.83 13.64 -9.3 1 6 0 69 448.954 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
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 94 0.30 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_HUMAN P30542 Adenosine A1 Receptor, Human 94 0.30 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 6 0.35 Binding ≤ 1μM
AA1R_HUMAN P30542 Adenosine A1 Receptor, Human 94 0.30 Binding ≤ 10μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 6 0.35 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) 4.44 12.28 -10.85 1 7 0 78 464.953 10

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 94 0.30 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_HUMAN P30542 Adenosine A1 Receptor, Human 94 0.30 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 6 0.35 Binding ≤ 1μM
AA1R_HUMAN P30542 Adenosine A1 Receptor, Human 94 0.30 Binding ≤ 10μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 6 0.35 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) 4.44 12.28 -10.76 1 7 0 78 464.953 10

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 22 0.32 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 22 0.32 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 22 0.32 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) 5.21 14.56 -9.14 1 6 0 69 462.981 10

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 22 0.32 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 22 0.32 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 22 0.32 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) 5.21 14.56 -9.02 1 6 0 69 462.981 10

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 25 0.31 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_HUMAN P30542 Adenosine A1 Receptor, Human 25 0.31 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 10 0.33 Binding ≤ 1μM
AA1R_HUMAN P30542 Adenosine A1 Receptor, Human 25 0.31 Binding ≤ 10μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 10 0.33 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) 4.82 13.21 -10.56 1 7 0 78 478.98 11

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 25 0.31 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_HUMAN P30542 Adenosine A1 Receptor, Human 25 0.31 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 10 0.33 Binding ≤ 1μM
AA1R_HUMAN P30542 Adenosine A1 Receptor, Human 25 0.31 Binding ≤ 10μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 10 0.33 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) 4.82 13.21 -10.53 1 7 0 78 478.98 11

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 29 0.32 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_HUMAN P30542 Adenosine A1 Receptor, Human 29 0.32 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 16 0.33 Binding ≤ 1μM
AA1R_HUMAN P30542 Adenosine A1 Receptor, Human 29 0.32 Binding ≤ 10μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 16 0.33 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) 4.88 13.9 -8.77 1 6 0 69 466.944 10

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 29 0.32 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_HUMAN P30542 Adenosine A1 Receptor, Human 29 0.32 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 16 0.33 Binding ≤ 1μM
AA1R_HUMAN P30542 Adenosine A1 Receptor, Human 29 0.32 Binding ≤ 10μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 16 0.33 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) 4.88 14.13 -9.16 1 6 0 69 466.944 10

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 33 0.32 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 33 0.32 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 33 0.32 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) 4.90 13.93 -9.35 1 6 0 69 466.944 10

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 33 0.32 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 33 0.32 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 33 0.32 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) 4.90 13.92 -9.29 1 6 0 69 466.944 10

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 16 0.33 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_HUMAN P30542 Adenosine A1 Receptor, Human 16 0.33 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 12 0.34 Binding ≤ 1μM
AA1R_HUMAN P30542 Adenosine A1 Receptor, Human 16 0.33 Binding ≤ 10μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 12 0.34 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) 4.92 13.94 -10.02 1 6 0 69 466.944 10

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 16 0.33 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_HUMAN P30542 Adenosine A1 Receptor, Human 16 0.33 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 12 0.34 Binding ≤ 1μM
AA1R_HUMAN P30542 Adenosine A1 Receptor, Human 16 0.33 Binding ≤ 10μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 12 0.34 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) 4.92 13.92 -9.87 1 6 0 69 466.944 10

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 76 0.30 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 76 0.30 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 76 0.30 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) 5.39 14.3 -8.26 1 6 0 69 483.399 10

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 76 0.30 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 76 0.30 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 76 0.30 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) 5.39 14.53 -8.45 1 6 0 69 483.399 10

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 178 0.29 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 178 0.29 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 178 0.29 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) 5.41 14.38 -8.77 1 6 0 69 483.399 10

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 178 0.29 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 178 0.29 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 178 0.29 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) 5.41 14.36 -8.67 1 6 0 69 483.399 10

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 153 0.29 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_HUMAN P30542 Adenosine A1 Receptor, Human 153 0.29 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 19 0.33 Binding ≤ 1μM
AA1R_HUMAN P30542 Adenosine A1 Receptor, Human 153 0.29 Binding ≤ 10μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 19 0.33 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) 5.44 14.4 -9.36 1 6 0 69 483.399 10

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 153 0.29 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_HUMAN P30542 Adenosine A1 Receptor, Human 153 0.29 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 19 0.33 Binding ≤ 1μM
AA1R_HUMAN P30542 Adenosine A1 Receptor, Human 153 0.29 Binding ≤ 10μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 19 0.33 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) 5.44 14.37 -9.22 1 6 0 69 483.399 10

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 130 0.29 Binding ≤ 10μM
AA2AR-1-E Adenosine A2a Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 1358 0.25 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 130 0.29 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 130 0.29 Binding ≤ 10μM
AA2AR_HUMAN P29274 Adenosine A2a Receptor, Human 1358 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) 5.26 14.67 -8.81 1 6 0 69 462.981 11

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 130 0.29 Binding ≤ 10μM
AA2AR-1-E Adenosine A2a Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 1358 0.25 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 130 0.29 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 130 0.29 Binding ≤ 10μM
AA2AR_HUMAN P29274 Adenosine A2a Receptor, Human 1358 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) 5.26 14.69 -8.72 1 6 0 69 462.981 11

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 31 0.32 Binding ≤ 10μM
AA2AR-1-E Adenosine A2a Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 1517 0.25 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 31 0.32 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 31 0.32 Binding ≤ 10μM
AA2AR_HUMAN P29274 Adenosine A2a Receptor, Human 1517 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) 5.12 14.6 -9.07 1 6 0 69 462.981 10

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 31 0.32 Binding ≤ 10μM
AA2AR-1-E Adenosine A2a Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 1517 0.25 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 31 0.32 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 31 0.32 Binding ≤ 10μM
AA2AR_HUMAN P29274 Adenosine A2a Receptor, Human 1517 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) 5.12 14.62 -9 1 6 0 69 462.981 10

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 48 0.30 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 48 0.30 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 48 0.30 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) 5.57 15.27 -9 1 6 0 69 477.008 10

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 48 0.30 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 48 0.30 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 48 0.30 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) 5.57 15.29 -9.04 1 6 0 69 477.008 10

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 17 0.31 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_HUMAN P30542 Adenosine A1 Receptor, Human 17 0.31 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 7 0.33 Binding ≤ 1μM
AA1R_HUMAN P30542 Adenosine A1 Receptor, Human 17 0.31 Binding ≤ 10μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 7 0.33 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) 5.18 13.92 -10.55 1 7 0 78 493.007 11

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 17 0.31 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_HUMAN P30542 Adenosine A1 Receptor, Human 17 0.31 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 7 0.33 Binding ≤ 1μM
AA1R_HUMAN P30542 Adenosine A1 Receptor, Human 17 0.31 Binding ≤ 10μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 7 0.33 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) 5.18 13.93 -10.52 1 7 0 78 493.007 11

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 44 0.30 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 44 0.30 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 44 0.30 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) 5.75 15.03 -8.24 1 6 0 69 497.426 10

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 44 0.30 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 44 0.30 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 44 0.30 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) 5.75 15.26 -8.45 1 6 0 69 497.426 10

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 100 0.29 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 100 0.29 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 100 0.29 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) 5.78 15.1 -8.73 1 6 0 69 497.426 10

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 100 0.29 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 100 0.29 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 100 0.29 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) 5.78 15.09 -8.69 1 6 0 69 497.426 10

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 41 0.30 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 41 0.30 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 41 0.30 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) 5.80 15.12 -9.31 1 6 0 69 497.426 10

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 41 0.30 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 41 0.30 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 41 0.30 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) 5.80 15.1 -9.22 1 6 0 69 497.426 10

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 62 0.30 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 62 0.30 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 62 0.30 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) 5.63 15.34 -8.98 1 6 0 69 477.008 11

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 62 0.30 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 62 0.30 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 62 0.30 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) 5.63 15.57 -8.67 1 6 0 69 477.008 11

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 62 0.30 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 62 0.30 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 62 0.30 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) 5.63 15.39 -8.92 1 6 0 69 477.008 11

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 62 0.30 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 62 0.30 Binding ≤ 1μM
AA1R_BOVIN P28190 Adenosine A1 Receptor, Bovin 62 0.30 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) 5.63 15.35 -8.8 1 6 0 69 477.008 11

Parameters Provided:

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

Permalink

Embed Link to Results