UCSF
ZINC Item Suppliers, Protomers, & Similar Substances

Analogs

4215367
4215367

Draw Identity 99% 90% 80% 70%

Vendors

And 11 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 4470 0.23 Binding ≤ 10μM
5HT1B-1-E Serotonin 1b (5-HT1b) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 4470 0.23 Binding ≤ 10μM
5HT1D-1-E Serotonin 1d (5-HT1d) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 4470 0.23 Binding ≤ 10μM
5HT1F-2-E Serotonin 1f (5-HT1f) Receptor (cluster #2 Of 2), Eukaryotic Eukaryotes 4470 0.23 Binding ≤ 10μM
5HT2A-1-E Serotonin 2a (5-HT2a) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 7 0.36 Binding ≤ 10μM
5HT2B-3-E Serotonin 2b (5-HT2b) Receptor (cluster #3 Of 4), Eukaryotic Eukaryotes 6 0.36 Binding ≤ 10μM
5HT2C-3-E Serotonin 2c (5-HT2c) Receptor (cluster #3 Of 3), Eukaryotic Eukaryotes 6 0.36 Binding ≤ 10μM
5HT3A-1-E Serotonin 3a (5-HT3a) Receptor (cluster #1 Of 5), Eukaryotic Eukaryotes 152 0.30 Binding ≤ 10μM
5HT3B-1-E Serotonin 3b (5-HT3b) Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 95 0.31 Binding ≤ 10μM
5HT3C-1-E Serotonin 3c (5-HT3c) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 152 0.30 Binding ≤ 10μM
5HT3D-1-E Serotonin 3d (5-HT3d) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 152 0.30 Binding ≤ 10μM
5HT3E-1-E Serotonin 3e (5-HT3e) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 152 0.30 Binding ≤ 10μM
5HT4R-1-E Serotonin 4 (5-HT4) Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 29 0.33 Binding ≤ 10μM
ADA1A-1-E Alpha-1a Adrenergic Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 30 0.33 Binding ≤ 10μM
ADA1B-1-E Alpha-1b Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 30 0.33 Binding ≤ 10μM
ADA1D-1-E Alpha-1d Adrenergic Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 30 0.33 Binding ≤ 10μM
ADA2A-1-E Alpha-2a Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 4500 0.23 Binding ≤ 10μM
ADA2B-1-E Alpha-2b Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 4500 0.23 Binding ≤ 10μM
ADA2C-1-E Alpha-2c Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 4500 0.23 Binding ≤ 10μM
DRD1-1-E Dopamine D1 Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 227 0.29 Binding ≤ 10μM
KCNH2-1-E HERG (cluster #1 Of 5), Eukaryotic Eukaryotes 7400 0.22 Binding ≤ 10μM
5HT3A-1-E Serotonin 3a (5-HT3a) Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 1500 0.25 Functional ≤ 10μM
5HT4R-1-E Serotonin 4 (5-HT4) Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 55 0.32 Functional ≤ 10μM
KCNH2-1-E HERG (cluster #1 Of 2), Eukaryotic Eukaryotes 7 0.36 Functional ≤ 10μM
DRD2-4-E Dopamine D2 Receptor (cluster #4 Of 24), Eukaryotic Eukaryotes 680 0.27 Binding ≤ 10μM
Z104304-1-O Adrenergic Receptor Alpha-1 (cluster #1 Of 3), Other Other 110 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.99 8.67 -54.72 4 7 1 87 466.961 9

Analogs

4215367
4215367

Draw Identity 99% 90% 80% 70%

Vendors

And 9 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 4470 0.23 Binding ≤ 10μM
5HT1B-1-E Serotonin 1b (5-HT1b) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 4470 0.23 Binding ≤ 10μM
5HT1D-1-E Serotonin 1d (5-HT1d) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 4470 0.23 Binding ≤ 10μM
5HT1F-2-E Serotonin 1f (5-HT1f) Receptor (cluster #2 Of 2), Eukaryotic Eukaryotes 4470 0.23 Binding ≤ 10μM
5HT2A-1-E Serotonin 2a (5-HT2a) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 7 0.36 Binding ≤ 10μM
5HT2B-3-E Serotonin 2b (5-HT2b) Receptor (cluster #3 Of 4), Eukaryotic Eukaryotes 6 0.36 Binding ≤ 10μM
5HT2C-3-E Serotonin 2c (5-HT2c) Receptor (cluster #3 Of 3), Eukaryotic Eukaryotes 6 0.36 Binding ≤ 10μM
5HT3A-1-E Serotonin 3a (5-HT3a) Receptor (cluster #1 Of 5), Eukaryotic Eukaryotes 152 0.30 Binding ≤ 10μM
5HT3B-1-E Serotonin 3b (5-HT3b) Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 95 0.31 Binding ≤ 10μM
5HT3C-1-E Serotonin 3c (5-HT3c) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 152 0.30 Binding ≤ 10μM
5HT3D-1-E Serotonin 3d (5-HT3d) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 152 0.30 Binding ≤ 10μM
5HT3E-1-E Serotonin 3e (5-HT3e) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 152 0.30 Binding ≤ 10μM
5HT4R-1-E Serotonin 4 (5-HT4) Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 29 0.33 Binding ≤ 10μM
ADA1A-1-E Alpha-1a Adrenergic Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 30 0.33 Binding ≤ 10μM
ADA1B-1-E Alpha-1b Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 30 0.33 Binding ≤ 10μM
ADA1D-1-E Alpha-1d Adrenergic Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 30 0.33 Binding ≤ 10μM
ADA2A-1-E Alpha-2a Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 4500 0.23 Binding ≤ 10μM
ADA2B-1-E Alpha-2b Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 4500 0.23 Binding ≤ 10μM
ADA2C-1-E Alpha-2c Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 4500 0.23 Binding ≤ 10μM
DRD1-1-E Dopamine D1 Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 227 0.29 Binding ≤ 10μM
KCNH2-1-E HERG (cluster #1 Of 5), Eukaryotic Eukaryotes 7400 0.22 Binding ≤ 10μM
5HT3A-1-E Serotonin 3a (5-HT3a) Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 1500 0.25 Functional ≤ 10μM
5HT4R-1-E Serotonin 4 (5-HT4) Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 55 0.32 Functional ≤ 10μM
KCNH2-1-E HERG (cluster #1 Of 2), Eukaryotic Eukaryotes 7 0.36 Functional ≤ 10μM
DRD2-4-E Dopamine D2 Receptor (cluster #4 Of 24), Eukaryotic Eukaryotes 680 0.27 Binding ≤ 10μM
Z104304-1-O Adrenergic Receptor Alpha-1 (cluster #1 Of 3), Other Other 110 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.99 8.28 -52.82 4 7 1 87 466.961 9

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
5HT3A-1-E Serotonin 3a (5-HT3a) Receptor (cluster #1 Of 5), Eukaryotic Eukaryotes 1 0.57 Binding ≤ 10μM
5HT3B-1-E Serotonin 3b (5-HT3b) Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 1 0.57 Binding ≤ 10μM
5HT4R-1-E Serotonin 4 (5-HT4) Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 29 0.48 Binding ≤ 10μM
5HT3A-1-E Serotonin 3a (5-HT3a) Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 4 0.53 Functional ≤ 10μM
5HT4R-1-E Serotonin 4 (5-HT4) Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 51 0.46 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.74 -2.43 -42.27 4 5 1 68 322.816 3

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
5HT3A-1-E Serotonin 3a (5-HT3a) Receptor (cluster #1 Of 5), Eukaryotic Eukaryotes 1 0.57 Binding ≤ 10μM
5HT3B-1-E Serotonin 3b (5-HT3b) Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 1 0.57 Binding ≤ 10μM
5HT4R-1-E Serotonin 4 (5-HT4) Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 29 0.48 Binding ≤ 10μM
5HT3A-1-E Serotonin 3a (5-HT3a) Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 4 0.53 Functional ≤ 10μM
5HT4R-1-E Serotonin 4 (5-HT4) Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 51 0.46 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.74 4.3 -44.64 4 5 1 69 322.816 3

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
5HT3A-1-E Serotonin 3a (5-HT3a) Receptor (cluster #1 Of 5), Eukaryotic Eukaryotes 152 0.43 Binding ≤ 10μM
5HT3B-1-E Serotonin 3b (5-HT3b) Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 152 0.43 Binding ≤ 10μM
5HT4R-1-E Serotonin 4 (5-HT4) Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 21 0.49 Binding ≤ 10μM
5HT4R-1-E Serotonin 4 (5-HT4) Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 66 0.46 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.67 -2.36 -40.72 4 5 1 68 324.832 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 660 0.51 Binding ≤ 10μM
5HT1B-1-E Serotonin 1b (5-HT1b) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 180 0.56 Binding ≤ 10μM
5HT2A-1-E Serotonin 2a (5-HT2a) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 240 0.55 Binding ≤ 10μM
5HT2C-1-E Serotonin 2c (5-HT2c) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 450 0.52 Binding ≤ 10μM
5HT3A-1-E Serotonin 3a (5-HT3a) Receptor (cluster #1 Of 5), Eukaryotic Eukaryotes 34 0.62 Binding ≤ 10μM
5HT4R-1-E Serotonin 4 (5-HT4) Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 620 0.51 Binding ≤ 10μM
5HT6R-2-E Serotonin 6 (5-HT6) Receptor (cluster #2 Of 2), Eukaryotic Eukaryotes 7 0.67 Binding ≤ 10μM
5HT7R-1-E Serotonin 7 (5-HT7) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 3000 0.45 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 7.14 -42.83 3 2 1 32 247.749 1

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

25503976
25503976
21818858
21818858

Draw Identity 99% 90% 80% 70%

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
5HT3A-2-E Serotonin 3a (5-HT3a) Receptor (cluster #2 Of 5), Eukaryotic Eukaryotes 11 0.56 Binding ≤ 10μM
5HT4R-1-E Serotonin 4 (5-HT4) Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 5750 0.37 Binding ≤ 10μM
DRD2-4-E Dopamine D2 Receptor (cluster #4 Of 24), Eukaryotic Eukaryotes 919 0.42 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.61 6.99 -37.3 1 5 0 61 271.32 3

Parameters Provided:

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

Permalink

Embed Link to Results