UCSF
ZINC Item Suppliers, Protomers, & Similar Substances

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
EPHB3-1-E Ephrin Type-B Receptor 3 (cluster #1 Of 1), Eukaryotic Eukaryotes 79 0.40 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.82 8.97 -57.04 3 5 1 63 355.849 3
Lo Low (pH 4.5-6) 2.82 9.46 -93.82 4 5 2 64 356.857 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
EPHB3-1-E Ephrin Type-B Receptor 3 (cluster #1 Of 1), Eukaryotic Eukaryotes 173 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) 4.04 8.58 -8.09 1 4 0 46 364.63 2
Lo Low (pH 4.5-6) 4.04 9.01 -31.58 2 4 1 48 365.638 2

Analogs

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
ABL1-1-E Tyrosine-protein Kinase ABL (cluster #1 Of 1), Eukaryotic Eukaryotes 590 0.26 Binding ≤ 10μM
ABL2-1-E Tyrosine-protein Kinase ABL2 (cluster #1 Of 1), Eukaryotic Eukaryotes 0 0.00 Binding ≤ 10μM
ACK1-1-E Tyrosine Kinase Non-receptor Protein 2 (cluster #1 Of 1), Eukaryotic Eukaryotes 6 0.35 Binding ≤ 10μM
ACV1B-1-E Activin Receptor Type-1B (cluster #1 Of 1), Eukaryotic Eukaryotes 330 0.27 Binding ≤ 10μM
ACVL1-1-E Serine/threonine-protein Kinase Receptor R3 (cluster #1 Of 1), Eukaryotic Eukaryotes 460 0.27 Binding ≤ 10μM
ACVR1-1-E Activin Receptor Type-1 (cluster #1 Of 1), Eukaryotic Eukaryotes 620 0.26 Binding ≤ 10μM
ADCK3-1-E Chaperone Activity Of Bc1 Complex-like, Mitochondrial (cluster #1 Of 1), Eukaryotic Eukaryotes 190 0.29 Binding ≤ 10μM
AURKB-1-E Serine/threonine-protein Kinase Aurora-B (cluster #1 Of 2), Eukaryotic Eukaryotes 6485 0.22 Binding ≤ 10μM
AVR2A-1-E Activin Receptor Type-2A (cluster #1 Of 1), Eukaryotic Eukaryotes 210 0.28 Binding ≤ 10μM
AVR2B-1-E Activin Receptor Type-2B (cluster #1 Of 1), Eukaryotic Eukaryotes 570 0.26 Binding ≤ 10μM
BCR-1-E Breakpoint Cluster Region Protein (cluster #1 Of 1), Eukaryotic Eukaryotes 1 0.38 Binding ≤ 10μM
BLK-1-E Tyrosine-protein Kinase BLK (cluster #1 Of 1), Eukaryotic Eukaryotes 0 0.00 Binding ≤ 10μM
BMX-1-E Tyrosine-protein Kinase BMX (cluster #1 Of 1), Eukaryotic Eukaryotes 1 0.38 Binding ≤ 10μM
BRAF-1-E Serine/threonine-protein Kinase B-raf (cluster #1 Of 1), Eukaryotic Eukaryotes 570 0.26 Binding ≤ 10μM
BTK-1-E Tyrosine-protein Kinase BTK (cluster #1 Of 1), Eukaryotic Eukaryotes 5 0.35 Binding ≤ 10μM
CSF1R-1-E Macrophage Colony-stimulating Factor 1 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 7 0.35 Binding ≤ 10μM
CSK-1-E Tyrosine-protein Kinase CSK (cluster #1 Of 1), Eukaryotic Eukaryotes 1 0.38 Binding ≤ 10μM
DDR1-1-E Epithelial Discoidin Domain-containing Receptor 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 1 0.38 Binding ≤ 10μM
DDR2-1-E Discoidin Domain-containing Receptor 2 (cluster #1 Of 1), Eukaryotic Eukaryotes 3 0.36 Binding ≤ 10μM
DMPK-1-E Myotonin-protein Kinase (cluster #1 Of 1), Eukaryotic Eukaryotes 1300 0.25 Binding ≤ 10μM
E2AK4-1-E Eukaryotic Translation Initiation Factor 2-alpha Kinase 4 (cluster #1 Of 1), Eukaryotic Eukaryotes 1600 0.25 Binding ≤ 10μM
EGFR-1-E Epidermal Growth Factor Receptor ErbB1 (cluster #1 Of 4), Eukaryotic Eukaryotes 79 0.30 Binding ≤ 10μM
EPHA1-1-E Ephrin Type-A Receptor 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 4 0.36 Binding ≤ 10μM
EPHA2-1-E Ephrin Type-A Receptor 2 (cluster #1 Of 1), Eukaryotic Eukaryotes 137 0.29 Binding ≤ 10μM
EPHA3-1-E Ephrin Type-A Receptor 3 (cluster #1 Of 2), Eukaryotic Eukaryotes 0 0.00 Binding ≤ 10μM
EPHA4-1-E Ephrin Type-A Receptor 4 (cluster #1 Of 1), Eukaryotic Eukaryotes 1 0.38 Binding ≤ 10μM
EPHA5-1-E Ephrin Type-A Receptor 5 (cluster #1 Of 1), Eukaryotic Eukaryotes 0 0.00 Binding ≤ 10μM
EPHA8-1-E Ephrin Type-A Receptor 8 (cluster #1 Of 1), Eukaryotic Eukaryotes 0 0.00 Binding ≤ 10μM
EPHB1-1-E Ephrin Type-B Receptor 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 0 0.00 Binding ≤ 10μM
EPHB2-1-E Ephrin Type-B Receptor 2 (cluster #1 Of 1), Eukaryotic Eukaryotes 4 0.36 Binding ≤ 10μM
EPHB3-1-E Ephrin Type-B Receptor 3 (cluster #1 Of 1), Eukaryotic Eukaryotes 7 0.35 Binding ≤ 10μM
EPHB4-1-E Ephrin Type-B Receptor 4 (cluster #1 Of 1), Eukaryotic Eukaryotes 1 0.38 Binding ≤ 10μM
ERBB2-2-E Receptor Protein-tyrosine Kinase ErbB-2 (cluster #2 Of 3), Eukaryotic Eukaryotes 710 0.26 Binding ≤ 10μM
FGFR1-1-E Fibroblast Growth Factor Receptor 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 880 0.26 Binding ≤ 10μM
FGFR2-1-E Fibroblast Growth Factor Receptor 2 (cluster #1 Of 1), Eukaryotic Eukaryotes 1400 0.25 Binding ≤ 10μM
FGR-1-E Tyrosine-protein Kinase FGR (cluster #1 Of 2), Eukaryotic Eukaryotes 1 0.38 Binding ≤ 10μM
FLT3-1-E Tyrosine-protein Kinase Receptor FLT3 (cluster #1 Of 1), Eukaryotic Eukaryotes 8100 0.22 Binding ≤ 10μM
FRK-1-E Tyrosine-protein Kinase FRK (cluster #1 Of 1), Eukaryotic Eukaryotes 0 0.00 Binding ≤ 10μM
FYN-1-E Tyrosine-protein Kinase FYN (cluster #1 Of 5), Eukaryotic Eukaryotes 1 0.38 Binding ≤ 10μM
GAK-1-E Serine/threonine-protein Kinase GAK (cluster #1 Of 2), Eukaryotic Eukaryotes 3 0.36 Binding ≤ 10μM
HCK-1-E Tyrosine-protein Kinase HCK (cluster #1 Of 1), Eukaryotic Eukaryotes 1 0.38 Binding ≤ 10μM
JAK2-1-E Tyrosine-protein Kinase JAK2 (cluster #1 Of 1), Eukaryotic Eukaryotes 1000 0.25 Binding ≤ 10μM
KC1A-1-E Casein Kinase I Alpha (cluster #1 Of 1), Eukaryotic Eukaryotes 1 0.38 Binding ≤ 10μM
KC1E-1-E Casein Kinase I Epsilon (cluster #1 Of 2), Eukaryotic Eukaryotes 1500 0.25 Binding ≤ 10μM
KIT-1-E Stem Cell Growth Factor Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 93 0.30 Binding ≤ 10μM
KSYK-1-E Tyrosine-protein Kinase SYK (cluster #1 Of 2), Eukaryotic Eukaryotes 2900 0.23 Binding ≤ 10μM
LCK-1-E Tyrosine-protein Kinase LCK (cluster #1 Of 4), Eukaryotic Eukaryotes 0 0.00 Binding ≤ 10μM
LIMK1-1-E LIM Domain Kinase 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 570 0.26 Binding ≤ 10μM
LIMK2-1-E LIM Domain Kinase 2 (cluster #1 Of 1), Eukaryotic Eukaryotes 86 0.30 Binding ≤ 10μM
LYN-1-E Tyrosine-protein Kinase Lyn (cluster #1 Of 1), Eukaryotic Eukaryotes 1 0.38 Binding ≤ 10μM
M3K4-1-E Mitogen-activated Protein Kinase Kinase Kinase 4 (cluster #1 Of 1), Eukaryotic Eukaryotes 310 0.28 Binding ≤ 10μM
M4K1-1-E Mitogen-activated Protein Kinase Kinase Kinase Kinase 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 980 0.25 Binding ≤ 10μM
M4K3-1-E Mitogen-activated Protein Kinase Kinase Kinase Kinase 3 (cluster #1 Of 1), Eukaryotic Eukaryotes 640 0.26 Binding ≤ 10μM
M4K4-1-E Mitogen-activated Protein Kinase Kinase Kinase Kinase 4 (cluster #1 Of 2), Eukaryotic Eukaryotes 3100 0.23 Binding ≤ 10μM
M4K5-1-E Mitogen-activated Protein Kinase Kinase Kinase Kinase 5 (cluster #1 Of 1), Eukaryotic Eukaryotes 45 0.31 Binding ≤ 10μM
MK11-1-E MAP Kinase P38 Beta (cluster #1 Of 1), Eukaryotic Eukaryotes 410 0.27 Binding ≤ 10μM
MK12-1-E MAP Kinase P38 Gamma (cluster #1 Of 2), Eukaryotic Eukaryotes 100 0.30 Binding ≤ 10μM
MK13-1-E MAP Kinase P38 Delta (cluster #1 Of 1), Eukaryotic Eukaryotes 100 0.30 Binding ≤ 10μM
MK14-1-E MAP Kinase P38 Alpha (cluster #1 Of 3), Eukaryotic Eukaryotes 495 0.27 Binding ≤ 10μM
MLTK-1-E Mixed Lineage Kinase 7 (cluster #1 Of 1), Eukaryotic Eukaryotes 45 0.31 Binding ≤ 10μM
MP2K1-1-E Dual Specificity Mitogen-activated Protein Kinase Kinase 1 (cluster #1 Of 4), Eukaryotic Eukaryotes 1700 0.24 Binding ≤ 10μM
MP2K2-1-E Dual Specificity Mitogen-activated Protein Kinase Kinase 2 (cluster #1 Of 1), Eukaryotic Eukaryotes 1700 0.24 Binding ≤ 10μM
MRCKA-1-E Serine/threonine-protein Kinase MRCK-A (cluster #1 Of 1), Eukaryotic Eukaryotes 2000 0.24 Binding ≤ 10μM
MRCKB-1-E Serine/threonine-protein Kinase MRCK Beta (cluster #1 Of 1), Eukaryotic Eukaryotes 2100 0.24 Binding ≤ 10μM
MRCKG-1-E Serine/threonine-protein Kinase MRCK Gamma (cluster #1 Of 1), Eukaryotic Eukaryotes 1200 0.25 Binding ≤ 10μM
MST4-1-E Serine/threonine-protein Kinase MST4 (cluster #1 Of 1), Eukaryotic Eukaryotes 1900 0.24 Binding ≤ 10μM
NLK-1-E Serine/threonine Protein Kinase NLK (cluster #1 Of 1), Eukaryotic Eukaryotes 260 0.28 Binding ≤ 10μM
PGFRA-1-E Platelet-derived Growth Factor Receptor Alpha (cluster #1 Of 2), Eukaryotic Eukaryotes 63 0.31 Binding ≤ 10μM
PGFRB-1-E Platelet-derived Growth Factor Receptor Beta (cluster #1 Of 1), Eukaryotic Eukaryotes 28 0.32 Binding ≤ 10μM
PMYT1-1-E Tyrosine- And Threonine-specific Cdc2-inhibitory Kinase (cluster #1 Of 1), Eukaryotic Eukaryotes 130 0.29 Binding ≤ 10μM
PTK6-1-E Tyrosine-protein Kinase BRK (cluster #1 Of 1), Eukaryotic Eukaryotes 9 0.34 Binding ≤ 10μM
RAF1-1-E Serine/threonine-protein Kinase RAF (cluster #1 Of 1), Eukaryotic Eukaryotes 570 0.26 Binding ≤ 10μM
RET-1-E Tyrosine-protein Kinase Receptor RET (cluster #1 Of 1), Eukaryotic Eukaryotes 730 0.26 Binding ≤ 10μM
RIPK2-1-E Serine/threonine-protein Kinase RIPK2 (cluster #1 Of 1), Eukaryotic Eukaryotes 31 0.32 Binding ≤ 10μM
SIK1-1-E Serine/threonine-protein Kinase SIK1 (cluster #1 Of 1), Eukaryotic Eukaryotes 4 0.36 Binding ≤ 10μM
SIK2-1-E Serine/threonine-protein Kinase SIK2 (cluster #1 Of 1), Eukaryotic Eukaryotes 6 0.35 Binding ≤ 10μM
SLK-1-E Serine/threonine-protein Kinase 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 720 0.26 Binding ≤ 10μM
SRC-1-E Tyrosine-protein Kinase SRC (cluster #1 Of 3), Eukaryotic Eukaryotes 14 0.33 Binding ≤ 10μM
SRMS-1-E Tyrosine-protein Kinase Srms (cluster #1 Of 1), Eukaryotic Eukaryotes 13 0.33 Binding ≤ 10μM
STK10-1-E Serine/threonine-protein Kinase 10 (cluster #1 Of 1), Eukaryotic Eukaryotes 1200 0.25 Binding ≤ 10μM
STK36-1-E Serine/threonine-protein Kinase 36 (cluster #1 Of 1), Eukaryotic Eukaryotes 210 0.28 Binding ≤ 10μM
TBA1A-1-E Tubulin Alpha-3 Chain (cluster #1 Of 3), Eukaryotic Eukaryotes 55 0.31 Binding ≤ 10μM
TEC-1-E Tyrosine-protein Kinase TEC (cluster #1 Of 1), Eukaryotic Eukaryotes 297 0.28 Binding ≤ 10μM
TESK1-1-E Dual Specificity Testis-specific Protein Kinase 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 33 0.32 Binding ≤ 10μM
TGFR1-1-E TGF-beta Receptor Type I (cluster #1 Of 1), Eukaryotic Eukaryotes 230 0.28 Binding ≤ 10μM
TGFR2-1-E TGF-beta Receptor Type II (cluster #1 Of 1), Eukaryotic Eukaryotes 2900 0.23 Binding ≤ 10μM
TNI3K-1-E Serine/threonine-protein Kinase TNNI3K (cluster #1 Of 1), Eukaryotic Eukaryotes 11 0.34 Binding ≤ 10μM
TNIK-1-E TRAF2- And NCK-interacting Kinase (cluster #1 Of 2), Eukaryotic Eukaryotes 2000 0.24 Binding ≤ 10μM
TXK-1-E Tyrosine-protein Kinase TXK (cluster #1 Of 1), Eukaryotic Eukaryotes 2 0.37 Binding ≤ 10μM
VGFR1-1-E Vascular Endothelial Growth Factor Receptor 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 5000 0.22 Binding ≤ 10μM
VGFR2-2-E Vascular Endothelial Growth Factor Receptor 2 (cluster #2 Of 2), Eukaryotic Eukaryotes 2360 0.24 Binding ≤ 10μM
WEE1-1-E Serine/threonine-protein Kinase WEE1 (cluster #1 Of 1), Eukaryotic Eukaryotes 7000 0.22 Binding ≤ 10μM
YES-1-E Tyrosine-protein Kinase YES (cluster #1 Of 1), Eukaryotic Eukaryotes 1 0.38 Binding ≤ 10μM
Z80186-1-O K562 (Erythroleukemia Cells) (cluster #1 Of 11), Other Other 1 0.38 Functional ≤ 10μM
Z80390-1-O PC-3 (Prostate Carcinoma Cells) (cluster #1 Of 10), Other Other 9 0.34 Functional ≤ 10μM
Z81017-1-O WiDr (Colon Adenocarcinoma Cells) (cluster #1 Of 5), Other Other 52 0.31 Functional ≤ 10μM
Z81252-3-O MDA-MB-231 (Breast Adenocarcinoma Cells) (cluster #3 Of 11), Other Other 12 0.34 Functional ≤ 10μM
Z81338-1-O T-cells (cluster #1 Of 3), Other Other 3 0.36 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.13 7.33 -37.83 4 9 1 108 489.025 7
Mid Mid (pH 6-8) 3.13 7.4 -39.94 4 9 1 108 489.025 7
Mid Mid (pH 6-8) 3.13 7.04 -18.14 3 9 0 107 488.017 7

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

And 17 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
ABL1-1-E Tyrosine-protein Kinase ABL (cluster #1 Of 1), Eukaryotic Eukaryotes 1700 0.29 Binding ≤ 10μM
ALK-1-E ALK Tyrosine Kinase Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 1600 0.29 Binding ≤ 10μM
AURKA-2-E Serine/threonine-protein Kinase Aurora-A (cluster #2 Of 3), Eukaryotic Eukaryotes 760 0.31 Binding ≤ 10μM
AURKB-1-E Serine/threonine-protein Kinase Aurora-B (cluster #1 Of 2), Eukaryotic Eukaryotes 390 0.32 Binding ≤ 10μM
AURKC-2-E Serine/threonine-protein Kinase Aurora-C (cluster #2 Of 2), Eukaryotic Eukaryotes 71 0.36 Binding ≤ 10μM
BMPR2-1-E Bone Morphogenetic Protein Receptor Type-2 (cluster #1 Of 1), Eukaryotic Eukaryotes 7800 0.26 Binding ≤ 10μM
CD11A-1-E PITSLRE Serine/threonine-protein Kinase CDC2L2 (cluster #1 Of 1), Eukaryotic Eukaryotes 1200 0.30 Binding ≤ 10μM
CD11B-1-E PITSLRE Serine/threonine-protein Kinase CDC2L1 (cluster #1 Of 1), Eukaryotic Eukaryotes 1300 0.29 Binding ≤ 10μM
CDK1-3-E Cyclin-dependent Kinase 1 (cluster #3 Of 4), Eukaryotic Eukaryotes 9800 0.25 Binding ≤ 10μM
CDK19-1-E Cell Division Cycle 2-like Protein Kinase 6 (cluster #1 Of 1), Eukaryotic Eukaryotes 74 0.36 Binding ≤ 10μM
CDK7-1-E Cyclin-dependent Kinase 7 (cluster #1 Of 1), Eukaryotic Eukaryotes 2900 0.28 Binding ≤ 10μM
CDK8-1-E Cell Division Protein Kinase 8 (cluster #1 Of 1), Eukaryotic Eukaryotes 95 0.35 Binding ≤ 10μM
CDK9-1-E Cyclin-dependent Kinase 9 (cluster #1 Of 2), Eukaryotic Eukaryotes 3000 0.28 Binding ≤ 10μM
CLK1-2-E Dual Specificty Protein Kinase CLK1 (cluster #2 Of 2), Eukaryotic Eukaryotes 8900 0.25 Binding ≤ 10μM
CLK4-2-E Dual Specificity Protein Kinase CLK4 (cluster #2 Of 2), Eukaryotic Eukaryotes 1600 0.29 Binding ≤ 10μM
CSF1R-1-E Macrophage Colony-stimulating Factor 1 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 3 0.43 Binding ≤ 10μM
DDR1-1-E Epithelial Discoidin Domain-containing Receptor 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 58 0.36 Binding ≤ 10μM
DDR2-1-E Discoidin Domain-containing Receptor 2 (cluster #1 Of 1), Eukaryotic Eukaryotes 3800 0.27 Binding ≤ 10μM
EGFR-1-E Epidermal Growth Factor Receptor ErbB1 (cluster #1 Of 4), Eukaryotic Eukaryotes 6500 0.26 Binding ≤ 10μM
EPHA3-1-E Ephrin Type-A Receptor 3 (cluster #1 Of 2), Eukaryotic Eukaryotes 3500 0.27 Binding ≤ 10μM
EPHA6-1-E Ephrin Type-A Receptor 6 (cluster #1 Of 1), Eukaryotic Eukaryotes 330 0.32 Binding ≤ 10μM
EPHB3-1-E Ephrin Type-B Receptor 3 (cluster #1 Of 1), Eukaryotic Eukaryotes 1400 0.29 Binding ≤ 10μM
EPHB4-1-E Ephrin Type-B Receptor 4 (cluster #1 Of 1), Eukaryotic Eukaryotes 1400 0.29 Binding ≤ 10μM
FLT3-1-E Tyrosine-protein Kinase Receptor FLT3 (cluster #1 Of 1), Eukaryotic Eukaryotes 9 0.40 Binding ≤ 10μM
FRK-1-E Tyrosine-protein Kinase FRK (cluster #1 Of 1), Eukaryotic Eukaryotes 400 0.32 Binding ≤ 10μM
INSRR-1-E Insulin Receptor-related Protein (cluster #1 Of 1), Eukaryotic Eukaryotes 3900 0.27 Binding ≤ 10μM
KAPCA-1-E CAMP-dependent Protein Kinase Alpha-catalytic Subunit (cluster #1 Of 4), Eukaryotic Eukaryotes 6900 0.26 Binding ≤ 10μM
KIT-1-E Stem Cell Growth Factor Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 81 0.35 Binding ≤ 10μM
KS6A4-1-E Ribosomal Protein S6 Kinase Alpha 4 (cluster #1 Of 1), Eukaryotic Eukaryotes 7200 0.26 Binding ≤ 10μM
KS6A5-1-E Ribosomal Protein S6 Kinase Alpha 5 (cluster #1 Of 3), Eukaryotic Eukaryotes 1200 0.30 Binding ≤ 10μM
LATS2-1-E Serine/threonine-protein Kinase LATS2 (cluster #1 Of 1), Eukaryotic Eukaryotes 1700 0.29 Binding ≤ 10μM
LIMK2-1-E LIM Domain Kinase 2 (cluster #1 Of 1), Eukaryotic Eukaryotes 4700 0.27 Binding ≤ 10μM
LTK-1-E Leukocyte Tyrosine Kinase Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 550 0.31 Binding ≤ 10μM
M4K1-1-E Mitogen-activated Protein Kinase Kinase Kinase Kinase 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 830 0.30 Binding ≤ 10μM
M4K3-1-E Mitogen-activated Protein Kinase Kinase Kinase Kinase 3 (cluster #1 Of 1), Eukaryotic Eukaryotes 3200 0.27 Binding ≤ 10μM
M4K5-1-E Mitogen-activated Protein Kinase Kinase Kinase Kinase 5 (cluster #1 Of 1), Eukaryotic Eukaryotes 910 0.30 Binding ≤ 10μM
MERTK-1-E Proto-oncogene Tyrosine-protein Kinase MER (cluster #1 Of 1), Eukaryotic Eukaryotes 870 0.30 Binding ≤ 10μM
MET-1-E Hepatocyte Growth Factor Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 1300 0.29 Binding ≤ 10μM
MK09-1-E C-Jun N-terminal Kinase 2 (cluster #1 Of 3), Eukaryotic Eukaryotes 240 0.33 Binding ≤ 10μM
MK15-1-E Mitogen-activated Protein Kinase 15 (cluster #1 Of 1), Eukaryotic Eukaryotes 2800 0.28 Binding ≤ 10μM
MKNK1-1-E MAP Kinase-interacting Serine/threonine-protein Kinase MNK1 (cluster #1 Of 1), Eukaryotic Eukaryotes 4900 0.27 Binding ≤ 10μM
MKNK2-1-E MAP Kinase Signal-integrating Kinase 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 270 0.33 Binding ≤ 10μM
MUSK-1-E Muscle, Skeletal Receptor Tyrosine Protein Kinase (cluster #1 Of 1), Eukaryotic Eukaryotes 10 0.40 Binding ≤ 10μM
NTRK1-1-E Nerve Growth Factor Receptor Trk-A (cluster #1 Of 1), Eukaryotic Eukaryotes 3100 0.28 Binding ≤ 10μM
NTRK2-1-E Neurotrophic Tyrosine Kinase Receptor Type 2 (cluster #1 Of 1), Eukaryotic Eukaryotes 1100 0.30 Binding ≤ 10μM
NTRK3-1-E NT-3 Growth Factor Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 210 0.33 Binding ≤ 10μM
PGFRA-1-E Platelet-derived Growth Factor Receptor Alpha (cluster #1 Of 2), Eukaryotic Eukaryotes 4 0.42 Binding ≤ 10μM
PGFRB-1-E Platelet-derived Growth Factor Receptor Beta (cluster #1 Of 1), Eukaryotic Eukaryotes 66 0.36 Binding ≤ 10μM
PLK3-1-E Serine/threonine-protein Kinase PLK3 (cluster #1 Of 1), Eukaryotic Eukaryotes 8500 0.25 Binding ≤ 10μM
RET-1-E Tyrosine-protein Kinase Receptor RET (cluster #1 Of 1), Eukaryotic Eukaryotes 1900 0.29 Binding ≤ 10μM
RIPK1-1-E Receptor-interacting Serine/threonine-protein Kinase 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 2800 0.28 Binding ≤ 10μM
SLK-1-E Serine/threonine-protein Kinase 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 450 0.32 Binding ≤ 10μM
ST32B-1-E Serine/threonine-protein Kinase 32B (cluster #1 Of 1), Eukaryotic Eukaryotes 270 0.33 Binding ≤ 10μM
STK10-1-E Serine/threonine-protein Kinase 10 (cluster #1 Of 1), Eukaryotic Eukaryotes 460 0.32 Binding ≤ 10μM
STK3-1-E Serine/threonine-protein Kinase MST2 (cluster #1 Of 2), Eukaryotic Eukaryotes 1500 0.29 Binding ≤ 10μM
STK33-1-E Serine/threonine-protein Kinase 33 (cluster #1 Of 1), Eukaryotic Eukaryotes 3800 0.27 Binding ≤ 10μM
STK4-2-E Serine/threonine-protein Kinase MST1 (cluster #2 Of 2), Eukaryotic Eukaryotes 1400 0.29 Binding ≤ 10μM
TIE1-1-E Tyrosine-protein Kinase Receptor Tie-1 (cluster #1 Of 1), Eukaryotic Eukaryotes 110 0.35 Binding ≤ 10μM
TIE2-1-E Tyrosine-protein Kinase TIE-2 (cluster #1 Of 2), Eukaryotic Eukaryotes 450 0.32 Binding ≤ 10μM
UFO-1-E Tyrosine-protein Kinase Receptor UFO (cluster #1 Of 1), Eukaryotic Eukaryotes 340 0.32 Binding ≤ 10μM
VGFR1-1-E Vascular Endothelial Growth Factor Receptor 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 8 0.40 Binding ≤ 10μM
VGFR2-1-E Vascular Endothelial Growth Factor Receptor 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 8 0.40 Binding ≤ 10μM
VGFR3-1-E Vascular Endothelial Growth Factor Receptor 3 (cluster #1 Of 2), Eukaryotic Eukaryotes 190 0.34 Binding ≤ 10μM
VGFR2-2-E Vascular Endothelial Growth Factor Receptor 2 (cluster #2 Of 2), Eukaryotic Eukaryotes 4 0.42 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.73 7.88 -12.09 5 6 0 96 375.407 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
ADCK4-1-E Uncharacterized AarF Domain-containing Protein Kinase 4 (cluster #1 Of 1), Eukaryotic Eukaryotes 129 0.39 Binding ≤ 10μM
BLK-1-E Tyrosine-protein Kinase BLK (cluster #1 Of 1), Eukaryotic Eukaryotes 1 0.50 Binding ≤ 10μM
BMX-1-E Tyrosine-protein Kinase BMX (cluster #1 Of 1), Eukaryotic Eukaryotes 36 0.42 Binding ≤ 10μM
BTK-1-E Tyrosine-protein Kinase BTK (cluster #1 Of 1), Eukaryotic Eukaryotes 9 0.45 Binding ≤ 10μM
CSK-1-E Tyrosine-protein Kinase CSK (cluster #1 Of 1), Eukaryotic Eukaryotes 28 0.42 Binding ≤ 10μM
EPHA1-1-E Ephrin Type-A Receptor 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 5 0.46 Binding ≤ 10μM
EPHA2-1-E Ephrin Type-A Receptor 2 (cluster #1 Of 1), Eukaryotic Eukaryotes 8 0.45 Binding ≤ 10μM
EPHA3-1-E Ephrin Type-A Receptor 3 (cluster #1 Of 2), Eukaryotic Eukaryotes 0 0.00 Binding ≤ 10μM
EPHA4-1-E Ephrin Type-A Receptor 4 (cluster #1 Of 1), Eukaryotic Eukaryotes 5 0.46 Binding ≤ 10μM
EPHA5-1-E Ephrin Type-A Receptor 5 (cluster #1 Of 1), Eukaryotic Eukaryotes 3 0.48 Binding ≤ 10μM
EPHA6-1-E Ephrin Type-A Receptor 6 (cluster #1 Of 1), Eukaryotic Eukaryotes 20 0.43 Binding ≤ 10μM
EPHB2-1-E Ephrin Type-B Receptor 2 (cluster #1 Of 1), Eukaryotic Eukaryotes 7 0.46 Binding ≤ 10μM
EPHB3-1-E Ephrin Type-B Receptor 3 (cluster #1 Of 1), Eukaryotic Eukaryotes 81 0.40 Binding ≤ 10μM
FGR-1-E Tyrosine-protein Kinase FGR (cluster #1 Of 2), Eukaryotic Eukaryotes 0 0.00 Binding ≤ 10μM
FYN-1-E Tyrosine-protein Kinase FYN (cluster #1 Of 5), Eukaryotic Eukaryotes 0 0.00 Binding ≤ 10μM
KSYK-1-E Tyrosine-protein Kinase SYK (cluster #1 Of 2), Eukaryotic Eukaryotes 26 0.42 Binding ≤ 10μM
LCK-1-E Tyrosine-protein Kinase LCK (cluster #1 Of 4), Eukaryotic Eukaryotes 13 0.44 Binding ≤ 10μM
LYN-1-E Tyrosine-protein Kinase Lyn (cluster #1 Of 1), Eukaryotic Eukaryotes 3 0.48 Binding ≤ 10μM
PTK6-1-E Tyrosine-protein Kinase BRK (cluster #1 Of 1), Eukaryotic Eukaryotes 2 0.49 Binding ≤ 10μM
TXK-1-E Tyrosine-protein Kinase TXK (cluster #1 Of 1), Eukaryotic Eukaryotes 2 0.49 Binding ≤ 10μM
TYRO3-1-E Tyrosine-protein Kinase Receptor TYRO3 (cluster #1 Of 1), Eukaryotic Eukaryotes 264 0.37 Binding ≤ 10μM
YES-1-E Tyrosine-protein Kinase YES (cluster #1 Of 1), Eukaryotic Eukaryotes 1 0.50 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.13 4.7 -17.34 5 7 0 113 335.367 5

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

And 1 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
ABL1-1-E Tyrosine-protein Kinase ABL (cluster #1 Of 1), Eukaryotic Eukaryotes 820 0.25 Binding ≤ 10μM
ABL2-1-E Tyrosine-protein Kinase ABL2 (cluster #1 Of 1), Eukaryotic Eukaryotes 3300 0.23 Binding ≤ 10μM
AURKA-1-E Serine/threonine-protein Kinase Aurora-A (cluster #1 Of 3), Eukaryotic Eukaryotes 4 0.35 Binding ≤ 10μM
AURKB-1-E Serine/threonine-protein Kinase Aurora-B (cluster #1 Of 2), Eukaryotic Eukaryotes 9 0.33 Binding ≤ 10μM
AURKC-1-E Serine/threonine-protein Kinase Aurora-C (cluster #1 Of 2), Eukaryotic Eukaryotes 26 0.31 Binding ≤ 10μM
BLK-1-E Tyrosine-protein Kinase BLK (cluster #1 Of 1), Eukaryotic Eukaryotes 68 0.30 Binding ≤ 10μM
BMX-1-E Tyrosine-protein Kinase BMX (cluster #1 Of 1), Eukaryotic Eukaryotes 3100 0.23 Binding ≤ 10μM
BTK-1-E Tyrosine-protein Kinase BTK (cluster #1 Of 1), Eukaryotic Eukaryotes 4200 0.22 Binding ≤ 10μM
CLK2-1-E Dual Specificity Protein Kinase CLK2 (cluster #1 Of 2), Eukaryotic Eukaryotes 3200 0.23 Binding ≤ 10μM
CLK3-1-E Dual Specificity Protein Kinase CLK3 (cluster #1 Of 1), Eukaryotic Eukaryotes 2300 0.23 Binding ≤ 10μM
CSK-1-E Tyrosine-protein Kinase CSK (cluster #1 Of 1), Eukaryotic Eukaryotes 9000 0.21 Binding ≤ 10μM
DDR1-1-E Epithelial Discoidin Domain-containing Receptor 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 4200 0.22 Binding ≤ 10μM
EGFR-1-E Epidermal Growth Factor Receptor ErbB1 (cluster #1 Of 4), Eukaryotic Eukaryotes 6400 0.21 Binding ≤ 10μM
EPHA1-1-E Ephrin Type-A Receptor 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 1800 0.24 Binding ≤ 10μM
EPHA2-1-E Ephrin Type-A Receptor 2 (cluster #1 Of 1), Eukaryotic Eukaryotes 370 0.26 Binding ≤ 10μM
EPHA3-1-E Ephrin Type-A Receptor 3 (cluster #1 Of 2), Eukaryotic Eukaryotes 2100 0.23 Binding ≤ 10μM
EPHA4-1-E Ephrin Type-A Receptor 4 (cluster #1 Of 1), Eukaryotic Eukaryotes 420 0.26 Binding ≤ 10μM
EPHA5-1-E Ephrin Type-A Receptor 5 (cluster #1 Of 1), Eukaryotic Eukaryotes 1400 0.24 Binding ≤ 10μM
EPHA6-1-E Ephrin Type-A Receptor 6 (cluster #1 Of 1), Eukaryotic Eukaryotes 580 0.26 Binding ≤ 10μM
EPHA7-1-E Ephrin Type-A Receptor 7 (cluster #1 Of 1), Eukaryotic Eukaryotes 1000 0.25 Binding ≤ 10μM
EPHB1-1-E Ephrin Type-B Receptor 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 330 0.27 Binding ≤ 10μM
EPHB3-1-E Ephrin Type-B Receptor 3 (cluster #1 Of 1), Eukaryotic Eukaryotes 3500 0.22 Binding ≤ 10μM
EPHB4-1-E Ephrin Type-B Receptor 4 (cluster #1 Of 1), Eukaryotic Eukaryotes 560 0.26 Binding ≤ 10μM
FAK2-1-E Protein-tyrosine Kinase 2-beta (cluster #1 Of 1), Eukaryotic Eukaryotes 2000 0.23 Binding ≤ 10μM
FER-1-E Tyrosine-protein Kinase FER (cluster #1 Of 1), Eukaryotic Eukaryotes 4400 0.22 Binding ≤ 10μM
FGFR1-1-E Fibroblast Growth Factor Receptor 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 2400 0.23 Binding ≤ 10μM
FGFR2-1-E Fibroblast Growth Factor Receptor 2 (cluster #1 Of 1), Eukaryotic Eukaryotes 1700 0.24 Binding ≤ 10μM
FGFR3-1-E Fibroblast Growth Factor Receptor 3 (cluster #1 Of 1), Eukaryotic Eukaryotes 1300 0.24 Binding ≤ 10μM
FGR-1-E Tyrosine-protein Kinase FGR (cluster #1 Of 2), Eukaryotic Eukaryotes 220 0.27 Binding ≤ 10μM
FYN-1-E Tyrosine-protein Kinase FYN (cluster #1 Of 5), Eukaryotic Eukaryotes 1300 0.24 Binding ≤ 10μM
HCK-1-E Tyrosine-protein Kinase HCK (cluster #1 Of 1), Eukaryotic Eukaryotes 1500 0.24 Binding ≤ 10μM
IRAK3-1-E Interleukin-1 Receptor-associated Kinase 3 (cluster #1 Of 1), Eukaryotic Eukaryotes 1400 0.24 Binding ≤ 10μM
LCK-1-E Tyrosine-protein Kinase LCK (cluster #1 Of 4), Eukaryotic Eukaryotes 590 0.26 Binding ≤ 10μM
LYN-1-E Tyrosine-protein Kinase Lyn (cluster #1 Of 1), Eukaryotic Eukaryotes 1400 0.24 Binding ≤ 10μM
MAPK5-1-E MAP Kinase-activated Protein Kinase 5 (cluster #1 Of 1), Eukaryotic Eukaryotes 8 0.33 Binding ≤ 10μM
MERTK-1-E Proto-oncogene Tyrosine-protein Kinase MER (cluster #1 Of 1), Eukaryotic Eukaryotes 730 0.25 Binding ≤ 10μM
PLK4-1-E Serine/threonine-protein Kinase PLK4 (cluster #1 Of 1), Eukaryotic Eukaryotes 410 0.26 Binding ≤ 10μM
ROS1-1-E Proto-oncogene Tyrosine-protein Kinase ROS (cluster #1 Of 1), Eukaryotic Eukaryotes 3100 0.23 Binding ≤ 10μM
SIK1-1-E Serine/threonine-protein Kinase SIK1 (cluster #1 Of 1), Eukaryotic Eukaryotes 1700 0.24 Binding ≤ 10μM
SRC-1-E Tyrosine-protein Kinase SRC (cluster #1 Of 3), Eukaryotic Eukaryotes 800 0.25 Binding ≤ 10μM
ST17A-1-E Serine/threonine-protein Kinase 17A (cluster #1 Of 2), Eukaryotic Eukaryotes 190 0.28 Binding ≤ 10μM
ST17B-1-E Serine/threonine-protein Kinase 17B (cluster #1 Of 1), Eukaryotic Eukaryotes 8 0.33 Binding ≤ 10μM
STK10-1-E Serine/threonine-protein Kinase 10 (cluster #1 Of 1), Eukaryotic Eukaryotes 3700 0.22 Binding ≤ 10μM
TEC-1-E Tyrosine-protein Kinase TEC (cluster #1 Of 1), Eukaryotic Eukaryotes 730 0.25 Binding ≤ 10μM
TIE1-1-E Tyrosine-protein Kinase Receptor Tie-1 (cluster #1 Of 1), Eukaryotic Eukaryotes 1600 0.24 Binding ≤ 10μM
TIE2-1-E Tyrosine-protein Kinase TIE-2 (cluster #1 Of 2), Eukaryotic Eukaryotes 300 0.27 Binding ≤ 10μM
TNK1-1-E Non-receptor Tyrosine-protein Kinase TNK1 (cluster #1 Of 1), Eukaryotic Eukaryotes 2400 0.23 Binding ≤ 10μM
TYRO3-1-E Tyrosine-protein Kinase Receptor TYRO3 (cluster #1 Of 1), Eukaryotic Eukaryotes 3100 0.23 Binding ≤ 10μM
UFO-1-E Tyrosine-protein Kinase Receptor UFO (cluster #1 Of 1), Eukaryotic Eukaryotes 440 0.26 Binding ≤ 10μM
VGFR1-1-E Vascular Endothelial Growth Factor Receptor 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 1000 0.25 Binding ≤ 10μM
VGFR3-1-E Vascular Endothelial Growth Factor Receptor 3 (cluster #1 Of 2), Eukaryotic Eukaryotes 3100 0.23 Binding ≤ 10μM
YES-1-E Tyrosine-protein Kinase YES (cluster #1 Of 1), Eukaryotic Eukaryotes 260 0.27 Binding ≤ 10μM
Z80166-1-O HT-29 (Colon Adenocarcinoma Cells) (cluster #1 Of 12), Other Other 150 0.28 Functional ≤ 10μM
Z80224-1-O MCF7 (Breast Carcinoma Cells) (cluster #1 Of 14), Other Other 670 0.25 Functional ≤ 10μM
Z80390-1-O PC-3 (Prostate Carcinoma Cells) (cluster #1 Of 10), Other Other 790 0.25 Functional ≤ 10μM
Z80493-1-O SK-OV-3 (Ovarian Carcinoma Cells) (cluster #1 Of 6), Other Other 530 0.26 Functional ≤ 10μM
Z80526-1-O SW480 (Colon Adenocarcinoma Cells) (cluster #1 Of 6), Other Other 860 0.25 Functional ≤ 10μM
Z80928-3-O HCT-116 (Colon Carcinoma Cells) (cluster #3 Of 9), Other Other 180 0.28 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) 5.27 12.65 -57.45 1 6 -1 90 475.862 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
EPHA1-1-E Ephrin Type-A Receptor 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 3 0.38 Binding ≤ 10μM
EPHA2-1-E Ephrin Type-A Receptor 2 (cluster #1 Of 1), Eukaryotic Eukaryotes 2 0.39 Binding ≤ 10μM
EPHA3-1-E Ephrin Type-A Receptor 3 (cluster #1 Of 2), Eukaryotic Eukaryotes 40 0.33 Binding ≤ 10μM
EPHA4-1-E Ephrin Type-A Receptor 4 (cluster #1 Of 1), Eukaryotic Eukaryotes 3 0.38 Binding ≤ 10μM
EPHA5-1-E Ephrin Type-A Receptor 5 (cluster #1 Of 1), Eukaryotic Eukaryotes 3 0.38 Binding ≤ 10μM
EPHA7-1-E Ephrin Type-A Receptor 7 (cluster #1 Of 1), Eukaryotic Eukaryotes 1118 0.27 Binding ≤ 10μM
EPHA8-1-E Ephrin Type-A Receptor 8 (cluster #1 Of 1), Eukaryotic Eukaryotes 5 0.37 Binding ≤ 10μM
EPHB1-1-E Ephrin Type-B Receptor 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 1 0.41 Binding ≤ 10μM
EPHB2-1-E Ephrin Type-B Receptor 2 (cluster #1 Of 1), Eukaryotic Eukaryotes 1 0.41 Binding ≤ 10μM
EPHB3-1-E Ephrin Type-B Receptor 3 (cluster #1 Of 1), Eukaryotic Eukaryotes 15 0.35 Binding ≤ 10μM
EPHB4-1-E Ephrin Type-B Receptor 4 (cluster #1 Of 1), Eukaryotic Eukaryotes 5 0.37 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.48 9.83 -14.45 2 9 0 107 417.425 3
Hi High (pH 8-9.5) 2.94 7.1 -60.72 1 9 -1 110 416.417 3

Parameters Provided:

target.name = EPHB3-1-E
target.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 activity AS ac ON ci.sub_id_fk=ac.sub_id_fk INNER JOIN target AS t ON ac.target_fk=t.target_id  WHERE c.free = 1 AND t.code LIKE 'EPHB3-1-E' AND t.atype_fk = 0 AND c.purchasable IN (1,2,4,5)    LIMIT 50

Permalink

Embed Link to Results