UCSF
ZINC Item Suppliers, Protomers, & Similar Substances

Analogs

3881666
3881666

Draw Identity 99% 90% 80% 70%

Vendors

And 16 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
ADA1A-1-E Alpha-1a Adrenergic Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 4400 0.29 Binding ≤ 10μM
ADA1B-1-E Alpha-1b Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 5 0.45 Binding ≤ 10μM
ADA1D-1-E Alpha-1d Adrenergic Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 4 0.45 Binding ≤ 10μM
ADA2A-1-E Alpha-2a Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 3 0.46 Binding ≤ 10μM
ADA2B-1-E Alpha-2b Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 53 0.39 Binding ≤ 10μM
ADA2C-1-E Alpha-2c Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 53 0.39 Binding ≤ 10μM
CAC1C-1-E Voltage-gated L-type Calcium Channel Alpha-1C Subunit (cluster #1 Of 1), Eukaryotic Eukaryotes 40 0.40 Binding ≤ 10μM
Z104304-1-O Adrenergic Receptor Alpha-1 (cluster #1 Of 3), Other Other 6300 0.28 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.22 8.58 -44.4 3 5 1 67 355.458 2
Hi High (pH 8-9.5) 3.22 6.89 -8.62 2 5 0 66 354.45 2

Analogs

3881666
3881666
3953891
3953891
3977785
3977785
4398249
4398249
4535881
4535881

Draw Identity 99% 90% 80% 70%

Vendors

And 33 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
5HT2A-1-E Serotonin 2a (5-HT2a) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 1622 0.31 Binding ≤ 10μM
5HT2C-1-E Serotonin 2c (5-HT2c) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 10000 0.27 Binding ≤ 10μM
AA3R-1-E Adenosine Receptor A3 (cluster #1 Of 6), Eukaryotic Eukaryotes 95 0.38 Binding ≤ 10μM
ADA1A-1-E Alpha-1a Adrenergic Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 1057 0.32 Binding ≤ 10μM
ADA1B-1-E Alpha-1b Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 966 0.32 Binding ≤ 10μM
ADA1D-1-E Alpha-1d Adrenergic Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 289 0.35 Binding ≤ 10μM
ADA2A-1-E Alpha-2a Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 1 0.48 Binding ≤ 10μM
ADA2A-1-E Alpha-2a Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 49 0.39 Binding ≤ 10μM
ADA2B-1-E Alpha-2b Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 7 0.44 Binding ≤ 10μM
ADA2B-1-E Alpha-2b Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 54 0.39 Binding ≤ 10μM
ADA2C-1-E Alpha-2c Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 1 0.48 Binding ≤ 10μM
ADA2C-1-E Alpha-2c Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 54 0.39 Binding ≤ 10μM
CAC1C-1-E Voltage-gated L-type Calcium Channel Alpha-1C Subunit (cluster #1 Of 1), Eukaryotic Eukaryotes 45 0.40 Binding ≤ 10μM
DRD1-1-E Dopamine D1 Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 2000 0.31 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 2430 0.30 Binding ≤ 10μM
DRD4-3-E Dopamine D4 Receptor (cluster #3 Of 4), Eukaryotic Eukaryotes 2000 0.31 Binding ≤ 10μM
DRD5-1-E Dopamine D5 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 2000 0.31 Binding ≤ 10μM
ADA2A-2-E Alpha-2a Adrenergic Receptor (cluster #2 Of 3), Eukaryotic Eukaryotes 165 0.37 Functional ≤ 10μM
ADA2B-2-E Alpha-2b Adrenergic Receptor (cluster #2 Of 3), Eukaryotic Eukaryotes 165 0.37 Functional ≤ 10μM
ADA2C-2-E Alpha-2c Adrenergic Receptor (cluster #2 Of 3), Eukaryotic Eukaryotes 165 0.37 Functional ≤ 10μM
CP2D6-1-E Cytochrome P450 2D6 (cluster #1 Of 3), Eukaryotic Eukaryotes 8 0.44 ADME/T ≤ 10μM
CP2D6-1-E Cytochrome P450 2D6 (cluster #1 Of 3), Eukaryotic Eukaryotes 80 0.38 ADME/T ≤ 10μM
DRD2-4-E Dopamine D2 Receptor (cluster #4 Of 24), Eukaryotic Eukaryotes 2000 0.31 Binding ≤ 10μM
Z104304-1-O Adrenergic Receptor Alpha-1 (cluster #1 Of 3), Other Other 360 0.35 Binding ≤ 10μM
Z50425-3-O Plasmodium Falciparum (cluster #3 Of 22), Other Other 3162 0.30 Functional ≤ 10μM
Z50587-5-O Homo Sapiens (cluster #5 Of 9), Other Other 1100 0.32 Functional ≤ 10μM
Z50597-1-O Rattus Norvegicus (cluster #1 Of 12), Other Other 505 0.34 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) 3.22 8.17 -43.2 3 5 1 67 355.458 2
Hi High (pH 8-9.5) 3.22 6.05 -10.14 2 5 0 66 354.45 2

Analogs

34474936
34474936

Draw Identity 99% 90% 80% 70%

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
ADA1A-2-E Alpha-1a Adrenergic Receptor (cluster #2 Of 3), Eukaryotic Eukaryotes 2500 0.60 Binding ≤ 10μM
ADA2A-3-E Alpha-2a Adrenergic Receptor (cluster #3 Of 4), Eukaryotic Eukaryotes 420 0.69 Binding ≤ 10μM
ADA2B-2-E Alpha-2b Adrenergic Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 420 0.69 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.17 6.32 -37.74 1 2 1 17 177.271 1
Lo Low (pH 4.5-6) 1.17 6.57 -85.23 2 2 2 19 178.279 1

Analogs

34525991
34525991
39957378
39957378

Draw Identity 99% 90% 80% 70%

Vendors

And 77 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
ADA1A-2-E Alpha-1a Adrenergic Receptor (cluster #2 Of 3), Eukaryotic Eukaryotes 2400 0.66 Binding ≤ 10μM
ADA2A-2-E Alpha-2a Adrenergic Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 37 0.87 Binding ≤ 10μM
ADA2B-2-E Alpha-2b Adrenergic Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 37 0.87 Binding ≤ 10μM
PLD1-2-E Phospholipase D1 (cluster #2 Of 2), Eukaryotic Eukaryotes 3600 0.64 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.44 2.78 -41.05 2 3 1 33 164.232 1

Analogs

34027663
34027663
34224121
34224121
41684216
41684216
41684217
41684217
42256412
42256412

Draw Identity 99% 90% 80% 70%

Vendors

And 12 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
5HT1A-4-E Serotonin 1a (5-HT1a) Receptor (cluster #4 Of 4), Eukaryotic Eukaryotes 844 0.65 Binding ≤ 10μM
5HT1B-1-E Serotonin 1b (5-HT1b) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 844 0.65 Binding ≤ 10μM
5HT1D-1-E Serotonin 1d (5-HT1d) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 844 0.65 Binding ≤ 10μM
5HT1F-1-E Serotonin 1f (5-HT1f) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 844 0.65 Binding ≤ 10μM
ADA1A-2-E Alpha-1a Adrenergic Receptor (cluster #2 Of 3), Eukaryotic Eukaryotes 2400 0.61 Binding ≤ 10μM
ADA1B-1-E Alpha-1b Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 2400 0.61 Binding ≤ 10μM
ADA1D-2-E Alpha-1d Adrenergic Receptor (cluster #2 Of 3), Eukaryotic Eukaryotes 2400 0.61 Binding ≤ 10μM
ADA2A-2-E Alpha-2a Adrenergic Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 150 0.73 Binding ≤ 10μM
ADA2B-2-E Alpha-2b Adrenergic Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 150 0.73 Binding ≤ 10μM
ADA2C-2-E Alpha-2c Adrenergic Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 150 0.73 Binding ≤ 10μM
Z104304-1-O Adrenergic Receptor Alpha-1 (cluster #1 Of 3), Other Other 913 0.65 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.56 2.5 -46.94 2 4 1 46 199.665 1
Hi High (pH 8-9.5) 0.56 1.2 -4.89 1 4 0 41 198.657 1

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
ADA1A-2-E Alpha-1a Adrenergic Receptor (cluster #2 Of 3), Eukaryotic Eukaryotes 4000 0.63 Binding ≤ 10μM
ADA2A-1-E Alpha-2a Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 144 0.80 Binding ≤ 10μM
ADA2B-1-E Alpha-2b Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 144 0.80 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.56 4.17 -44.23 2 2 1 29 161.228 1

Analogs

26898952
26898952

Draw Identity 99% 90% 80% 70%

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
ADA1A-2-E Alpha-1a Adrenergic Receptor (cluster #2 Of 3), Eukaryotic Eukaryotes 490 0.63 Binding ≤ 10μM
ADA2A-2-E Alpha-2a Adrenergic Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 5 0.83 Binding ≤ 10μM
ADA2B-2-E Alpha-2b Adrenergic Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 5 0.83 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.15 6.05 -34.53 1 3 1 21 196.249 1
Mid Mid (pH 6-8) 1.15 3.7 -5.71 0 3 0 19 195.241 1

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
ADA1A-2-E Alpha-1a Adrenergic Receptor (cluster #2 Of 3), Eukaryotic Eukaryotes 250 0.58 Binding ≤ 10μM
ADA1B-3-E Alpha-1b Adrenergic Receptor (cluster #3 Of 4), Eukaryotic Eukaryotes 250 0.58 Binding ≤ 10μM
ADA1D-3-E Alpha-1d Adrenergic Receptor (cluster #3 Of 3), Eukaryotic Eukaryotes 250 0.58 Binding ≤ 10μM
ADA2A-2-E Alpha-2a Adrenergic Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 73 0.62 Binding ≤ 10μM
ADA2B-2-E Alpha-2b Adrenergic Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 88 0.62 Binding ≤ 10μM
ADA2C-2-E Alpha-2c Adrenergic Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 88 0.62 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.72 3.9 -44.05 2 5 1 50 238.702 1
Mid Mid (pH 6-8) 0.72 4.27 -94.4 3 5 2 51 239.71 1

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

And 26 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
5HT1A-1-E Serotonin 1a (5-HT1a) Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 580 0.44 Binding ≤ 10μM
5HT1B-1-E Serotonin 1b (5-HT1b) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 580 0.44 Binding ≤ 10μM
5HT1D-1-E Serotonin 1d (5-HT1d) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 580 0.44 Binding ≤ 10μM
5HT1E-1-E Serotonin 1e (5-HT1e) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 4 0.59 Binding ≤ 10μM
5HT1F-1-E Serotonin 1f (5-HT1f) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 580 0.44 Binding ≤ 10μM
5HT2A-1-E Serotonin 2a (5-HT2a) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 4 0.59 Binding ≤ 10μM
5HT2B-1-E Serotonin 2b (5-HT2b) Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 5 0.58 Binding ≤ 10μM
5HT2C-1-E Serotonin 2c (5-HT2c) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 4 0.59 Binding ≤ 10μM
5HT3A-1-E Serotonin 3a (5-HT3a) Receptor (cluster #1 Of 5), Eukaryotic Eukaryotes 70 0.50 Binding ≤ 10μM
5HT3B-2-E Serotonin 3b (5-HT3b) Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 70 0.50 Binding ≤ 10μM
5HT6R-1-E Serotonin 6 (5-HT6) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 55 0.51 Binding ≤ 10μM
5HT7R-1-E Serotonin 7 (5-HT7) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 8010 0.36 Binding ≤ 10μM
ACM5-2-E Muscarinic Acetylcholine Receptor M5 (cluster #2 Of 4), Eukaryotic Eukaryotes 1900 0.40 Binding ≤ 10μM
ADA1A-1-E Alpha-1a Adrenergic Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 0 0.00 Binding ≤ 10μM
ADA1B-1-E Alpha-1b Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 43 0.52 Binding ≤ 10μM
ADA1D-1-E Alpha-1d Adrenergic Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 43 0.52 Binding ≤ 10μM
ADA2A-1-E Alpha-2a Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 19 0.54 Binding ≤ 10μM
ADA2B-1-E Alpha-2b Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 76 0.50 Binding ≤ 10μM
ADA2C-1-E Alpha-2c Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 76 0.50 Binding ≤ 10μM
ADCY1-1-E Brain Adenylate Cyclase 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 71 0.50 Binding ≤ 10μM
ADCY2-2-E Adenylate Cyclase Type II (cluster #2 Of 2), Eukaryotic Eukaryotes 71 0.50 Binding ≤ 10μM
ADCY8-1-E Adenylate Cyclase Type VIII (cluster #1 Of 2), Eukaryotic Eukaryotes 71 0.50 Binding ≤ 10μM
DRD1-1-E Dopamine D1 Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 1420 0.41 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 2841 0.39 Binding ≤ 10μM
HRH1-2-E Histamine H1 Receptor (cluster #2 Of 2), Eukaryotic Eukaryotes 2 0.61 Binding ≤ 10μM
HRH2-1-E Histamine H2 Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 190 0.47 Binding ≤ 10μM
HRH3-2-E Histamine H3 Receptor (cluster #2 Of 3), Eukaryotic Eukaryotes 14 0.55 Binding ≤ 10μM
HRH4-1-E Histamine H4 Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 14 0.55 Binding ≤ 10μM
Q9WTR4-1-E Norepinephrine Transporter (cluster #1 Of 2), Eukaryotic Eukaryotes 26 0.53 Binding ≤ 10μM
SC6A4-3-E Serotonin Transporter (cluster #3 Of 4), Eukaryotic Eukaryotes 2900 0.39 Binding ≤ 10μM
SCN1A-1-E Sodium Channel Protein Type I Alpha Subunit (cluster #1 Of 2), Eukaryotic Eukaryotes 5500 0.37 Binding ≤ 10μM
SCN2A-1-E Sodium Channel Protein Type II Alpha Subunit (cluster #1 Of 2), Eukaryotic Eukaryotes 5500 0.37 Binding ≤ 10μM
SCN3A-1-E Sodium Channel Protein Type III Alpha Subunit (cluster #1 Of 2), Eukaryotic Eukaryotes 5500 0.37 Binding ≤ 10μM
SCN8A-1-E Sodium Channel Protein Type VIII Alpha Subunit (cluster #1 Of 2), Eukaryotic Eukaryotes 5500 0.37 Binding ≤ 10μM
ADCY1-1-E Brain Adenylate Cyclase 1 (cluster #1 Of 2), Eukaryotic Eukaryotes 190 0.47 Functional ≤ 10μM
ADCY2-1-E Adenylate Cyclase Type II (cluster #1 Of 1), Eukaryotic Eukaryotes 190 0.47 Functional ≤ 10μM
ADCY8-1-E Adenylate Cyclase Type VIII (cluster #1 Of 1), Eukaryotic Eukaryotes 190 0.47 Functional ≤ 10μM
HRH2-1-E Histamine H2 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 880 0.42 Functional ≤ 10μM
DRD2-15-E Dopamine D2 Receptor (cluster #15 Of 24), Eukaryotic Eukaryotes 828 0.43 Binding ≤ 10μM
Z104304-1-O Adrenergic Receptor Alpha-1 (cluster #1 Of 3), Other Other 99 0.49 Binding ≤ 10μM
Z50597-1-O Rattus Norvegicus (cluster #1 Of 5), Other Other 26 0.53 Binding ≤ 10μM
Z50425-3-O Plasmodium Falciparum (cluster #3 Of 22), Other Other 5012 0.37 Functional ≤ 10μM
Z50597-1-O Rattus Norvegicus (cluster #1 Of 12), Other Other 3 0.60 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) 3.62 10.31 -40.2 1 2 1 8 265.38 0
Hi High (pH 8-9.5) 3.20 6.56 -36.76 5 7 1 106 476.454 5

Parameters Provided:

annotation.name = ADA2B_BOVIN
anotation.type = B10
page.format = summary
page.num = 1
filter.purchasability = purchasable

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 note AS n ON ci.sub_id_fk=n.sub_id_fk INNER JOIN annotation AS a ON n.anno_id_fk=a.anno_id  WHERE c.free = 1 AND a.short_desc LIKE 'ADA2B\\_BOVIN' AND c.purchasable IN (1,2,4,5)    LIMIT 50

Permalink

Embed Link to Results