UCSF
ZINC Item Suppliers, Protomers, & Similar Substances

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

And 31 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 450 0.44 Binding ≤ 10μM
5HT1B-1-E Serotonin 1b (5-HT1b) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 23 0.53 Binding ≤ 10μM
5HT1D-1-E Serotonin 1d (5-HT1d) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 8 0.57 Binding ≤ 10μM
5HT1E-1-E Serotonin 1e (5-HT1e) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 5500 0.37 Binding ≤ 10μM
5HT1F-1-E Serotonin 1f (5-HT1f) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 26 0.53 Binding ≤ 10μM
5HT2A-1-E Serotonin 2a (5-HT2a) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 376 0.45 Binding ≤ 10μM
5HT2C-1-E Serotonin 2c (5-HT2c) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 7900 0.36 Binding ≤ 10μM
5HT3A-1-E Serotonin 3a (5-HT3a) Receptor (cluster #1 Of 5), Eukaryotic Eukaryotes 9 0.56 Binding ≤ 10μM
5HT1B-1-E Serotonin 1b (5-HT1b) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 77 0.50 Functional ≤ 10μM
5HT1D-1-E Serotonin 1d (5-HT1d) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 5 0.58 Functional ≤ 10μM
5HT1F-1-E Serotonin 1f (5-HT1f) Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 35 0.52 Functional ≤ 10μM
Z50588-6-O Canis Familiaris (cluster #6 Of 7), Other Other 49 0.51 Functional ≤ 10μM
Z50592-1-O Oryctolagus Cuniculus (cluster #1 Of 8), Other Other 2400 0.39 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) 1.40 4.17 -47.88 3 5 1 66 296.416 6
Hi High (pH 8-9.5) 1.40 1.7 -14.32 2 5 0 65 295.408 6

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
5HT1A-1-E Serotonin 1a (5-HT1a) Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 4 0.38 Binding ≤ 10μM
5HT2A-1-E Serotonin 2a (5-HT2a) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 3 0.38 Binding ≤ 10μM
5HT2B-2-E Serotonin 2b (5-HT2b) Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 3 0.38 Binding ≤ 10μM
5HT2C-2-E Serotonin 2c (5-HT2c) Receptor (cluster #2 Of 3), Eukaryotic Eukaryotes 3 0.38 Binding ≤ 10μM
DRD2-17-E Dopamine D2 Receptor (cluster #17 Of 24), Eukaryotic Eukaryotes 34 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) 3.65 -6.02 -52.2 3 6 1 62 436.605 7

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

And 20 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 210 0.30 Binding ≤ 10μM
5HT2A-1-E Serotonin 2a (5-HT2a) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 9 0.36 Binding ≤ 10μM
5HT2B-1-E Serotonin 2b (5-HT2b) Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 9 0.36 Binding ≤ 10μM
5HT2C-1-E Serotonin 2c (5-HT2c) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 9 0.36 Binding ≤ 10μM
ADA2A-1-E Alpha-2a Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 0 0.00 Binding ≤ 10μM
DRD1-1-E Dopamine D1 Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 750 0.28 Binding ≤ 10μM
SGMR1-1-E Sigma Opioid Receptor (cluster #1 Of 6), Eukaryotic Eukaryotes 64 0.32 Binding ≤ 10μM
DRD2-4-E Dopamine D2 Receptor (cluster #4 Of 24), Eukaryotic Eukaryotes 110 0.31 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.95 3.39 -62.26 1 6 1 66 427.496 8

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

And 6 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 1 0.70 Binding ≤ 10μM
5HT1A-1-E Serotonin 1a (5-HT1a) Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 2 0.68 Binding ≤ 10μM
5HT1A-1-E Serotonin 1a (5-HT1a) Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 975 0.47 Binding ≤ 10μM
5HT1B-1-E Serotonin 1b (5-HT1b) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 2570 0.43 Binding ≤ 10μM
5HT1D-1-E Serotonin 1d (5-HT1d) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 160 0.53 Binding ≤ 10μM
5HT1D-1-E Serotonin 1d (5-HT1d) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 638 0.48 Binding ≤ 10μM
5HT1F-1-E Serotonin 1f (5-HT1f) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 160 0.53 Binding ≤ 10μM
5HT2A-1-E Serotonin 2a (5-HT2a) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 1100 0.46 Binding ≤ 10μM
5HT2B-1-E Serotonin 2b (5-HT2b) Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 1614 0.45 Binding ≤ 10μM
5HT2C-1-E Serotonin 2c (5-HT2c) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 7250 0.40 Binding ≤ 10μM
5HT3A-1-E Serotonin 3a (5-HT3a) Receptor (cluster #1 Of 5), Eukaryotic Eukaryotes 1 0.70 Binding ≤ 10μM
5HT3B-1-E Serotonin 3b (5-HT3b) Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 1 0.70 Binding ≤ 10μM
5HT5A-1-E Serotonin 5a (5-HT5a) Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 2500 0.44 Binding ≤ 10μM
5HT7R-1-E Serotonin 7 (5-HT7) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 9 0.63 Binding ≤ 10μM
5HT7R-1-E Serotonin 7 (5-HT7) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 466 0.49 Binding ≤ 10μM
AA3R-3-E Adenosine Receptor A3 (cluster #3 Of 6), Eukaryotic Eukaryotes 1 0.70 Binding ≤ 10μM
ADA1A-1-E Alpha-1a Adrenergic Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 2082 0.44 Binding ≤ 10μM
ADA1B-1-E Alpha-1b Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 9460 0.39 Binding ≤ 10μM
ADA1D-1-E Alpha-1d Adrenergic Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 9460 0.39 Binding ≤ 10μM
ADA2A-3-E Alpha-2a Adrenergic Receptor (cluster #3 Of 4), Eukaryotic Eukaryotes 1000 0.47 Binding ≤ 10μM
ADA2B-1-E Alpha-2b Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 810 0.47 Binding ≤ 10μM
ADA2C-3-E Alpha-2c Adrenergic Receptor (cluster #3 Of 4), Eukaryotic Eukaryotes 810 0.47 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 179 0.52 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 259 0.51 Binding ≤ 10μM
SGMR1-1-E Sigma Opioid Receptor (cluster #1 Of 6), Eukaryotic Eukaryotes 5240 0.41 Binding ≤ 10μM
5HT1A-1-E Serotonin 1a (5-HT1a) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 3 0.66 Functional ≤ 10μM
5HT1B-1-E Serotonin 1b (5-HT1b) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 260 0.51 Functional ≤ 10μM
ADCY3-1-E Adenylate Cyclase Type III (cluster #1 Of 1), Eukaryotic Eukaryotes 8 0.63 Functional ≤ 10μM
ADCY5-1-E Adenylate Cyclase Type V (cluster #1 Of 1), Eukaryotic Eukaryotes 8 0.63 Functional ≤ 10μM
DRD2-2-E Dopamine D2 Receptor (cluster #2 Of 24), Eukaryotic Eukaryotes 86 0.55 Binding ≤ 10μM
DRD2-2-E Dopamine D2 Receptor (cluster #2 Of 24), Eukaryotic Eukaryotes 5072 0.41 Binding ≤ 10μM
Z50597-1-O Rattus Norvegicus (cluster #1 Of 12), Other Other 1 0.70 Functional ≤ 10μM
Z80094-1-O CHO-MG (Ovarian Cells) (cluster #1 Of 1), Other Other 3 0.66 Functional ≤ 10μM
Z81247-2-O HeLa (Cervical Adenocarcinoma Cells) (cluster #2 Of 9), Other Other 18 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) 4.34 7.8 -35.71 2 2 1 25 248.39 5

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
5HT1A-1-E Serotonin 1a (5-HT1a) Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 3711 0.35 Binding ≤ 10μM
ADA2A-3-E Alpha-2a Adrenergic Receptor (cluster #3 Of 4), Eukaryotic Eukaryotes 2670 0.35 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 424 0.41 Binding ≤ 10μM
DRD4-2-E Dopamine D4 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 6 0.52 Binding ≤ 10μM
DRD4-1-E Dopamine D4 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 1 0.57 Functional ≤ 10μM
DRD2-9-E Dopamine D2 Receptor (cluster #9 Of 24), Eukaryotic Eukaryotes 2920 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) 3.03 -0.7 -61.86 3 4 1 58 295.362 6

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
5HT1A-1-E Serotonin 1a (5-HT1a) Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 525 0.34 Binding ≤ 10μM
5HT2A-1-E Serotonin 2a (5-HT2a) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 36 0.40 Binding ≤ 10μM
AA2BR-1-E Adenosine A2b Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 1023 0.32 Binding ≤ 10μM
ADA2A-1-E Alpha-2a Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 127 0.37 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 2682 0.30 Binding ≤ 10μM
DRD4-3-E Dopamine D4 Receptor (cluster #3 Of 4), Eukaryotic Eukaryotes 9 0.43 Binding ≤ 10μM
DRD4-3-E Dopamine D4 Receptor (cluster #3 Of 4), Eukaryotic Eukaryotes 42 0.40 Binding ≤ 10μM
DRD2-17-E Dopamine D2 Receptor (cluster #17 Of 24), Eukaryotic Eukaryotes 1842 0.31 Binding ≤ 10μM
DRD2-17-E Dopamine D2 Receptor (cluster #17 Of 24), Eukaryotic Eukaryotes 2748 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) 3.62 -2.55 -54.89 2 4 1 36 350.486 4

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
5HT1A-1-E Serotonin 1a (5-HT1a) Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 991 0.32 Binding ≤ 10μM
5HT2A-1-E Serotonin 2a (5-HT2a) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 15 0.42 Binding ≤ 10μM
AA2BR-1-E Adenosine A2b Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 1708 0.31 Binding ≤ 10μM
ADA2A-1-E Alpha-2a Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 343 0.35 Binding ≤ 10μM
DRD4-3-E Dopamine D4 Receptor (cluster #3 Of 4), Eukaryotic Eukaryotes 8 0.44 Binding ≤ 10μM
DRD2-17-E Dopamine D2 Receptor (cluster #17 Of 24), Eukaryotic Eukaryotes 5882 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.62 -2.53 -54.85 2 4 1 36 350.486 4

Analogs

3651042
3651042

Draw Identity 99% 90% 80% 70%

Vendors

And 69 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
5HT1A-3-E Serotonin 1a (5-HT1a) Receptor (cluster #3 Of 4), Eukaryotic Eukaryotes 5 0.89 Binding ≤ 10μM
5HT1B-1-E Serotonin 1b (5-HT1b) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 6 0.89 Binding ≤ 10μM
5HT1D-1-E Serotonin 1d (5-HT1d) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 6 0.89 Binding ≤ 10μM
5HT1E-1-E Serotonin 1e (5-HT1e) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 4 0.90 Binding ≤ 10μM
5HT1F-1-E Serotonin 1f (5-HT1f) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 6 0.89 Binding ≤ 10μM
5HT2A-2-E Serotonin 2a (5-HT2a) Receptor (cluster #2 Of 3), Eukaryotic Eukaryotes 680 0.66 Binding ≤ 10μM
5HT2B-1-E Serotonin 2b (5-HT2b) Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 680 0.66 Binding ≤ 10μM
5HT2C-1-E Serotonin 2c (5-HT2c) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 680 0.66 Binding ≤ 10μM
5HT3A-4-E Serotonin 3a (5-HT3a) Receptor (cluster #4 Of 5), Eukaryotic Eukaryotes 120 0.75 Binding ≤ 10μM
5HT3B-1-E Serotonin 3b (5-HT3b) Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 87 0.76 Binding ≤ 10μM
5HT3C-1-E Serotonin 3c (5-HT3c) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 120 0.75 Binding ≤ 10μM
5HT3D-1-E Serotonin 3d (5-HT3d) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 120 0.75 Binding ≤ 10μM
5HT3E-1-E Serotonin 3e (5-HT3e) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 120 0.75 Binding ≤ 10μM
5HT4R-1-E Serotonin 4 (5-HT4) Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 37 0.80 Binding ≤ 10μM
5HT5A-1-E Serotonin 5a (5-HT5a) Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 250 0.71 Binding ≤ 10μM
5HT6R-1-E Serotonin 6 (5-HT6) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 93 0.76 Binding ≤ 10μM
5HT7R-2-E Serotonin 7 (5-HT7) Receptor (cluster #2 Of 3), Eukaryotic Eukaryotes 8 0.87 Binding ≤ 10μM
AA3R-4-E Adenosine Receptor A3 (cluster #4 Of 6), Eukaryotic Eukaryotes 79 0.76 Binding ≤ 10μM
DRD1-1-E Dopamine D1 Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 9690 0.54 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 523 0.68 Binding ≤ 10μM
SC6A4-1-E Serotonin Transporter (cluster #1 Of 4), Eukaryotic Eukaryotes 740 0.66 Binding ≤ 10μM
5HT1A-1-E Serotonin 1a (5-HT1a) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 10 0.86 Functional ≤ 10μM
5HT1B-1-E Serotonin 1b (5-HT1b) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 5 0.89 Functional ≤ 10μM
5HT1D-1-E Serotonin 1d (5-HT1d) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 5 0.89 Functional ≤ 10μM
5HT1F-1-E Serotonin 1f (5-HT1f) Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 8 0.87 Functional ≤ 10μM
5HT2A-1-E Serotonin 2a (5-HT2a) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 70 0.77 Functional ≤ 10μM
5HT2B-1-E Serotonin 2b (5-HT2b) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 6 0.89 Functional ≤ 10μM
5HT2C-1-E 5-hydroxytryptamine Receptor 2C (cluster #1 Of 2), Eukaryotic Eukaryotes 25 0.82 Functional ≤ 10μM
5HT3A-1-E Serotonin 3a (5-HT3a) Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 500 0.68 Functional ≤ 10μM
5HT4R-1-E Serotonin 4 (5-HT4) Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 4 0.90 Functional ≤ 10μM
5HT7R-1-E Serotonin 7 (5-HT7) Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 15 0.84 Functional ≤ 10μM
DRD2-1-E Dopamine D2 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 0 0.00 Functional ≤ 10μM
Z50588-4-O Canis Familiaris (cluster #4 Of 7), Other Other 210 0.72 Functional ≤ 10μM
Z50592-1-O Oryctolagus Cuniculus (cluster #1 Of 8), Other Other 300 0.70 Functional ≤ 10μM
Z50597-10-O Rattus Norvegicus (cluster #10 Of 12), Other Other 919 0.65 Functional ≤ 10μM
Z80334-1-O NG108-15 (Neuroblastoma-glioma Hybrid Cells) (cluster #1 Of 1), Other Other 298 0.70 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) 0.57 0.5 -47.88 5 3 1 64 177.227 2

Analogs

32131087
32131087
32131089
32131089
3995781
3995781
4292831
4292831

Draw Identity 99% 90% 80% 70%

Vendors

And 35 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 2000 0.35 Binding ≤ 10μM
5HT1B-1-E Serotonin 1b (5-HT1b) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 8700 0.31 Binding ≤ 10μM
5HT1D-2-E Serotonin 1d (5-HT1d) Receptor (cluster #2 Of 2), Eukaryotic Eukaryotes 8700 0.31 Binding ≤ 10μM
5HT1F-1-E Serotonin 1f (5-HT1f) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 8700 0.31 Binding ≤ 10μM
5HT2A-1-E Serotonin 2a (5-HT2a) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 3 0.52 Binding ≤ 10μM
5HT2B-1-E Serotonin 2b (5-HT2b) Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 28 0.46 Binding ≤ 10μM
5HT2C-1-E Serotonin 2c (5-HT2c) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 28 0.46 Binding ≤ 10μM
5HT3A-1-E Serotonin 3a (5-HT3a) Receptor (cluster #1 Of 5), Eukaryotic Eukaryotes 53 0.44 Binding ≤ 10μM
5HT3B-2-E Serotonin 3b (5-HT3b) Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 53 0.44 Binding ≤ 10μM
5HT5A-1-E Serotonin 5a (5-HT5a) Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 1000 0.37 Binding ≤ 10μM
5HT6R-1-E Serotonin 6 (5-HT6) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 10 0.49 Binding ≤ 10μM
5HT7R-1-E Serotonin 7 (5-HT7) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 9 0.49 Binding ≤ 10μM
AA3R-1-E Adenosine Receptor A3 (cluster #1 Of 6), Eukaryotic Eukaryotes 156 0.41 Binding ≤ 10μM
ACM1-3-E Muscarinic Acetylcholine Receptor M1 (cluster #3 Of 5), Eukaryotic Eukaryotes 9 0.49 Binding ≤ 10μM
ACM2-4-E Muscarinic Acetylcholine Receptor M2 (cluster #4 Of 6), Eukaryotic Eukaryotes 91 0.43 Binding ≤ 10μM
ACM3-1-E Muscarinic Acetylcholine Receptor M3 (cluster #1 Of 5), Eukaryotic Eukaryotes 34 0.45 Binding ≤ 10μM
ACM4-1-E Muscarinic Acetylcholine Receptor M4 (cluster #1 Of 6), Eukaryotic Eukaryotes 91 0.43 Binding ≤ 10μM
ACM5-2-E Muscarinic Acetylcholine Receptor M5 (cluster #2 Of 4), Eukaryotic Eukaryotes 34 0.45 Binding ≤ 10μM
ADA1A-1-E Alpha-1a Adrenergic Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 4 0.51 Binding ≤ 10μM
ADA1B-1-E Alpha-1b Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 4 0.51 Binding ≤ 10μM
ADA1D-1-E Alpha-1d Adrenergic Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 4 0.51 Binding ≤ 10μM
ADA2A-1-E Alpha-2a Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 58 0.44 Binding ≤ 10μM
ADA2B-1-E Alpha-2b Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 58 0.44 Binding ≤ 10μM
ADA2C-1-E Alpha-2c Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 58 0.44 Binding ≤ 10μM
DRD1-2-E Dopamine D1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 8000 0.31 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 960 0.37 Binding ≤ 10μM
DRD4-4-E Dopamine D4 Receptor (cluster #4 Of 4), Eukaryotic Eukaryotes 9 0.49 Binding ≤ 10μM
DRD5-1-E Dopamine D5 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 890 0.37 Binding ≤ 10μM
HRH1-1-E Histamine H1 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 2 0.53 Binding ≤ 10μM
HRH2-1-E Histamine H2 Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 18 0.47 Binding ≤ 10μM
HRH3-1-E Histamine H3 Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 18 0.47 Binding ≤ 10μM
HRH4-1-E Histamine H4 Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 70 0.44 Binding ≤ 10μM
KCNH2-1-E HERG (cluster #1 Of 5), Eukaryotic Eukaryotes 6490 0.32 Binding ≤ 10μM
Q63380-1-E Transporter (cluster #1 Of 1), Eukaryotic Eukaryotes 390 0.39 Binding ≤ 10μM
Q9WTR4-1-E Norepinephrine Transporter (cluster #1 Of 2), Eukaryotic Eukaryotes 697 0.37 Binding ≤ 10μM
SC6A4-1-E Serotonin Transporter (cluster #1 Of 4), Eukaryotic Eukaryotes 3900 0.33 Binding ≤ 10μM
SGMR1-1-E Sigma Opioid Receptor (cluster #1 Of 6), Eukaryotic Eukaryotes 8500 0.31 Binding ≤ 10μM
HRH3-2-E Histamine H3 Receptor (cluster #2 Of 2), Eukaryotic Eukaryotes 631 0.38 Functional ≤ 10μM
KCNH2-1-E HERG (cluster #1 Of 2), Eukaryotic Eukaryotes 191 0.41 Functional ≤ 10μM
DRD2-15-E Dopamine D2 Receptor (cluster #15 Of 24), Eukaryotic Eukaryotes 290 0.40 Binding ≤ 10μM
Z104303-1-O Muscarinic Acetylcholine Receptor (cluster #1 Of 7), Other Other 51 0.44 Binding ≤ 10μM
Z104304-1-O Adrenergic Receptor Alpha-1 (cluster #1 Of 3), Other Other 9 0.49 Binding ≤ 10μM
Z102275-1-O Hypothalamus (cluster #1 Of 1), Other Other 10 0.49 Functional ≤ 10μM
Z50425-3-O Plasmodium Falciparum (cluster #3 Of 22), Other Other 7943 0.31 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) 4.14 7.55 -7.08 1 4 0 35 326.831 1
Hi High (pH 8-9.5) 4.14 8.88 -23.43 2 4 1 36 327.839 1
Mid Mid (pH 6-8) 4.14 11.23 -89.99 3 4 2 38 328.847 1

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

And 2 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 385 0.36 Binding ≤ 10μM
5HT2A-1-E Serotonin 2a (5-HT2a) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 4010 0.30 Binding ≤ 10μM
AA2BR-1-E Adenosine A2b Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 177 0.38 Binding ≤ 10μM
ADA2A-3-E Alpha-2a Adrenergic Receptor (cluster #3 Of 4), Eukaryotic Eukaryotes 168 0.38 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 2810 0.31 Binding ≤ 10μM
DRD4-3-E Dopamine D4 Receptor (cluster #3 Of 4), Eukaryotic Eukaryotes 9 0.45 Binding ≤ 10μM
DRD4-1-E Dopamine D4 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 8 0.45 Functional ≤ 10μM
Z50425-3-O Plasmodium Falciparum (cluster #3 Of 22), Other Other 7943 0.29 Functional ≤ 10μM
DRD2-17-E Dopamine D2 Receptor (cluster #17 Of 24), Eukaryotic Eukaryotes 6300 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) 2.87 8.23 -15.37 1 5 0 59 334.423 4

Analogs

2559943
2559943
3616630
3616630
14551
14551

Draw Identity 99% 90% 80% 70%

Vendors

And 18 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 238 0.39 Binding ≤ 10μM
5HT2A-1-E Serotonin 2a (5-HT2a) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 610 0.36 Binding ≤ 10μM
ADA2A-1-E Alpha-2a Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 110 0.41 Binding ≤ 10μM
HRH1-2-E Histamine H1 Receptor (cluster #2 Of 2), Eukaryotic Eukaryotes 1000 0.35 Binding ≤ 10μM
KCNH2-5-E HERG (cluster #5 Of 5), Eukaryotic Eukaryotes 100 0.41 Binding ≤ 10μM
NMD3A-3-E Glutamate [NMDA] Receptor Subunit 3A (cluster #3 Of 6), Eukaryotic Eukaryotes 13 0.46 Binding ≤ 10μM
NMD3B-3-E Glutamate [NMDA] Receptor Subunit 3B (cluster #3 Of 6), Eukaryotic Eukaryotes 13 0.46 Binding ≤ 10μM
NMDE1-2-E Glutamate [NMDA] Receptor Subunit Epsilon 1 (cluster #2 Of 5), Eukaryotic Eukaryotes 13 0.46 Binding ≤ 10μM
NMDE2-1-E Glutamate [NMDA] Receptor Subunit Epsilon 2 (cluster #1 Of 5), Eukaryotic Eukaryotes 94 0.41 Binding ≤ 10μM
NMDE3-1-E Glutamate [NMDA] Receptor Subunit Epsilon 3 (cluster #1 Of 4), Eukaryotic Eukaryotes 13 0.46 Binding ≤ 10μM
NMDE4-3-E Glutamate [NMDA] Receptor Subunit Epsilon 4 (cluster #3 Of 6), Eukaryotic Eukaryotes 13 0.46 Binding ≤ 10μM
NMDZ1-2-E Glutamate (NMDA) Receptor Subunit Zeta 1 (cluster #2 Of 6), Eukaryotic Eukaryotes 13 0.46 Binding ≤ 10μM
SGMR1-1-E Sigma Opioid Receptor (cluster #1 Of 6), Eukaryotic Eukaryotes 4 0.49 Binding ≤ 10μM
NMDE2-1-E Glutamate [NMDA] Receptor Subunit Epsilon 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 110 0.41 Functional ≤ 10μM
NMDE3-2-E Glutamate [NMDA] Receptor Subunit Epsilon 3 (cluster #2 Of 2), Eukaryotic Eukaryotes 263 0.38 Functional ≤ 10μM
NMDZ1-2-E Glutamate (NMDA) Receptor Subunit Zeta 1 (cluster #2 Of 3), Eukaryotic Eukaryotes 110 0.41 Functional ≤ 10μM
Z104304-1-O Adrenergic Receptor Alpha-1 (cluster #1 Of 3), Other Other 220 0.39 Binding ≤ 10μM
Z104297-1-O Glutamate NMDA Receptor; GRIN1/GRIN2B (cluster #1 Of 1), Other Other 66 0.42 Functional ≤ 10μM
Z104302-1-O Glutamate NMDA Receptor (cluster #1 Of 3), Other Other 263 0.38 Functional ≤ 10μM
Z50425-3-O Plasmodium Falciparum (cluster #3 Of 22), Other Other 3981 0.32 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.58 7.91 -39.49 3 3 1 45 326.46 5

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

And 2 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 12 0.40 Binding ≤ 10μM
5HT1D-1-E Serotonin 1d (5-HT1d) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 3000 0.28 Binding ≤ 10μM
5HT2A-1-E Serotonin 2a (5-HT2a) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 7500 0.26 Binding ≤ 10μM
5HT2B-2-E Serotonin 2b (5-HT2b) Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 7500 0.26 Binding ≤ 10μM
5HT2C-2-E Serotonin 2c (5-HT2c) Receptor (cluster #2 Of 3), Eukaryotic Eukaryotes 7500 0.26 Binding ≤ 10μM
ADA1A-1-E Alpha-1a Adrenergic Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 87 0.35 Binding ≤ 10μM
ADA1B-1-E Alpha-1b Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 500 0.32 Binding ≤ 10μM
ADA1D-1-E Alpha-1d Adrenergic Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 500 0.32 Binding ≤ 10μM
ADA2A-1-E Alpha-2a Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 2800 0.28 Binding ≤ 10μM
ADA2B-1-E Alpha-2b Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 1000 0.30 Binding ≤ 10μM
ADA2C-1-E Alpha-2c Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 1000 0.30 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 1200 0.30 Binding ≤ 10μM
DRD4-4-E Dopamine D4 Receptor (cluster #4 Of 4), Eukaryotic Eukaryotes 1800 0.29 Binding ≤ 10μM
HRH1-1-E Histamine H1 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 24 0.38 Binding ≤ 10μM
DRD2-8-E Dopamine D2 Receptor (cluster #8 Of 24), Eukaryotic Eukaryotes 2900 0.28 Binding ≤ 10μM
Z104304-1-O Adrenergic Receptor Alpha-1 (cluster #1 Of 3), Other Other 229 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) 1.35 8.86 -48.41 1 8 1 88 402.5 6
Mid Mid (pH 6-8) 1.35 6.65 -16.85 0 8 0 87 401.492 6

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

And 38 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 430 0.30 Binding ≤ 10μM
5HT1B-1-E Serotonin 1b (5-HT1b) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 55 0.34 Binding ≤ 10μM
5HT1D-1-E Serotonin 1d (5-HT1d) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 55 0.34 Binding ≤ 10μM
5HT1E-1-E Serotonin 1e (5-HT1e) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 55 0.34 Binding ≤ 10μM
5HT1F-1-E Serotonin 1f (5-HT1f) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 55 0.34 Binding ≤ 10μM
5HT2A-1-E Serotonin 2a (5-HT2a) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 2 0.41 Binding ≤ 10μM
5HT2B-1-E Serotonin 2b (5-HT2b) Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 2 0.41 Binding ≤ 10μM
5HT2C-1-E Serotonin 2c (5-HT2c) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 2 0.41 Binding ≤ 10μM
5HT6R-2-E Serotonin 6 (5-HT6) Receptor (cluster #2 Of 2), Eukaryotic Eukaryotes 224 0.31 Binding ≤ 10μM
5HT7R-1-E Serotonin 7 (5-HT7) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 4 0.39 Binding ≤ 10μM
ACM1-3-E Muscarinic Acetylcholine Receptor M1 (cluster #3 Of 5), Eukaryotic Eukaryotes 6300 0.24 Binding ≤ 10μM
ACM2-4-E Muscarinic Acetylcholine Receptor M2 (cluster #4 Of 6), Eukaryotic Eukaryotes 6300 0.24 Binding ≤ 10μM
ACM3-1-E Muscarinic Acetylcholine Receptor M3 (cluster #1 Of 5), Eukaryotic Eukaryotes 6300 0.24 Binding ≤ 10μM
ACM4-3-E Muscarinic Acetylcholine Receptor M4 (cluster #3 Of 6), Eukaryotic Eukaryotes 6300 0.24 Binding ≤ 10μM
ACM5-3-E Muscarinic Acetylcholine Receptor M5 (cluster #3 Of 4), Eukaryotic Eukaryotes 6300 0.24 Binding ≤ 10μM
ADA1A-1-E Alpha-1a Adrenergic Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 13 0.37 Binding ≤ 10μM
ADA1B-1-E Alpha-1b Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 2 0.41 Binding ≤ 10μM
ADA1D-1-E Alpha-1d Adrenergic Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 2 0.41 Binding ≤ 10μM
ADA2A-1-E Alpha-2a Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 25 0.35 Binding ≤ 10μM
ADA2B-1-E Alpha-2b Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 8 0.38 Binding ≤ 10μM
ADA2C-1-E Alpha-2c Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 8 0.38 Binding ≤ 10μM
DRD1-1-E Dopamine D1 Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 620 0.29 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 10 0.37 Binding ≤ 10μM
DRD4-3-E Dopamine D4 Receptor (cluster #3 Of 4), Eukaryotic Eukaryotes 9 0.38 Binding ≤ 10μM
HRH1-1-E Histamine H1 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 88 0.33 Binding ≤ 10μM
KCNH2-1-E HERG (cluster #1 Of 5), Eukaryotic Eukaryotes 920 0.28 Binding ≤ 10μM
SC6A4-1-E Serotonin Transporter (cluster #1 Of 4), Eukaryotic Eukaryotes 1400 0.27 Binding ≤ 10μM
SGMR1-1-E Sigma Opioid Receptor (cluster #1 Of 6), Eukaryotic Eukaryotes 4300 0.25 Binding ≤ 10μM
KCNH2-1-E HERG (cluster #1 Of 2), Eukaryotic Eukaryotes 163 0.32 Functional ≤ 10μM
DRD2-4-E Dopamine D2 Receptor (cluster #4 Of 24), Eukaryotic Eukaryotes 7 0.38 Binding ≤ 10μM
Z104304-1-O Adrenergic Receptor Alpha-1 (cluster #1 Of 3), Other Other 3 0.40 Binding ≤ 10μM
Z50425-3-O Plasmodium Falciparum (cluster #3 Of 22), Other Other 10000 0.23 Functional ≤ 10μM
Z50597-1-O Rattus Norvegicus (cluster #1 Of 12), Other Other 35 0.35 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.96 12.27 -47.95 1 6 1 65 411.501 4

Parameters Provided:

annotation.name = 5HT1A_MOUSE
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 '5HT1A\\_MOUSE' AND c.purchasable IN (1,2,4,5)    LIMIT 50

Permalink

Embed Link to Results