UCSF
ZINC Item Suppliers, Protomers, & Similar Substances

Analogs

33799539
33799539
44608728
44608728

Draw Identity 99% 90% 80% 70%

Vendors

And 53 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
MTSI-1-B CpG DNA Methylase (cluster #1 Of 2), Bacterial Bacteria 30 0.39 Binding ≤ 10μM
A4-1-E Beta Amyloid A4 Protein (cluster #1 Of 5), Eukaryotic Eukaryotes 800 0.32 Binding ≤ 10μM
CAH1-1-E Carbonic Anhydrase I (cluster #1 Of 12), Eukaryotic Eukaryotes 2410 0.29 Binding ≤ 10μM
CAH12-2-E Carbonic Anhydrase XII (cluster #2 Of 9), Eukaryotic Eukaryotes 3480 0.28 Binding ≤ 10μM
CAH13-1-E Carbonic Anhydrase XIII (cluster #1 Of 7), Eukaryotic Eukaryotes 6850 0.27 Binding ≤ 10μM
CAH15-4-E Carbonic Anhydrase 15 (cluster #4 Of 6), Eukaryotic Eukaryotes 5090 0.27 Binding ≤ 10μM
CAH2-1-E Carbonic Anhydrase II (cluster #1 Of 15), Eukaryotic Eukaryotes 380 0.33 Binding ≤ 10μM
CAH4-3-E Carbonic Anhydrase IV (cluster #3 Of 16), Eukaryotic Eukaryotes 4970 0.28 Binding ≤ 10μM
CAH5B-4-E Carbonic Anhydrase VB (cluster #4 Of 9), Eukaryotic Eukaryotes 9460 0.26 Binding ≤ 10μM
CAH6-8-E Carbonic Anhydrase VI (cluster #8 Of 8), Eukaryotic Eukaryotes 9940 0.26 Binding ≤ 10μM
CAH7-2-E Carbonic Anhydrase VII (cluster #2 Of 8), Eukaryotic Eukaryotes 9300 0.26 Binding ≤ 10μM
CAH9-3-E Carbonic Anhydrase IX (cluster #3 Of 11), Eukaryotic Eukaryotes 4050 0.28 Binding ≤ 10μM
DHB3-1-E Estradiol 17-beta-dehydrogenase 3 (cluster #1 Of 4), Eukaryotic Eukaryotes 9000 0.26 Binding ≤ 10μM
KPCE-5-E Protein Kinase C Epsilon (cluster #5 Of 5), Eukaryotic Eukaryotes 8810 0.26 Binding ≤ 10μM
LGUL-2-E Glyoxalase I (cluster #2 Of 2), Eukaryotic Eukaryotes 10000 0.26 Binding ≤ 10μM
LOX5-4-E Arachidonate 5-lipoxygenase (cluster #4 Of 6), Eukaryotic Eukaryotes 8000 0.26 Binding ≤ 10μM
MMP9-1-E Matrix Metalloproteinase 9 (cluster #1 Of 3), Eukaryotic Eukaryotes 8500 0.26 Binding ≤ 10μM
NOS2-4-E Nitric Oxide Synthase, Inducible (cluster #4 Of 9), Eukaryotic Eukaryotes 6000 0.27 Binding ≤ 10μM
PGH1-6-E Cyclooxygenase-1 (cluster #6 Of 6), Eukaryotic Eukaryotes 8800 0.26 Binding ≤ 10μM
Q8HY88-1-E Potassium Channel Subfamily K Member 2 (cluster #1 Of 1), Eukaryotic Eukaryotes 930 0.31 Binding ≤ 10μM
CP2C9-1-E Cytochrome P450 2C9 (cluster #1 Of 3), Eukaryotic Eukaryotes 4300 0.28 ADME/T ≤ 10μM
Z103192-1-O Trypanosoma Evansi (cluster #1 Of 2), Other Other 2000 0.30 Functional ≤ 10μM
Z50420-1-O Trypanosoma Brucei Brucei (cluster #1 Of 7), Other Other 4800 0.28 Functional ≤ 10μM
Z50425-11-O Plasmodium Falciparum (cluster #11 Of 22), Other Other 4210 0.28 Functional ≤ 10μM
Z50515-1-O Human Herpesvirus 2 (cluster #1 Of 2), Other Other 10 0.41 Functional ≤ 10μM
Z50518-1-O Human Herpesvirus 4 (cluster #1 Of 5), Other Other 10 0.41 Functional ≤ 10μM
Z50600-2-O Vaccinia Virus (cluster #2 Of 2), Other Other 10 0.41 Functional ≤ 10μM
Z50602-1-O Human Herpesvirus 1 (cluster #1 Of 5), Other Other 10 0.41 Functional ≤ 10μM
Z50607-3-O Human Immunodeficiency Virus 1 (cluster #3 Of 10), Other Other 37 0.39 Functional ≤ 10μM
Z50651-2-O Vesicular Stomatitis Virus (cluster #2 Of 2), Other Other 10 0.41 Functional ≤ 10μM
Z50658-4-O Human Immunodeficiency Virus 2 (cluster #4 Of 4), Other Other 37 0.39 Functional ≤ 10μM
Z80186-2-O K562 (Erythroleukemia Cells) (cluster #2 Of 11), Other Other 6810 0.27 Functional ≤ 10μM
Z80224-1-O MCF7 (Breast Carcinoma Cells) (cluster #1 Of 14), Other Other 5580 0.27 Functional ≤ 10μM
Z80244-4-O MDA-MB-468 (Breast Adenocarcinoma) (cluster #4 Of 7), Other Other 9700 0.26 Functional ≤ 10μM
Z80390-1-O PC-3 (Prostate Carcinoma Cells) (cluster #1 Of 10), Other Other 7700 0.27 Functional ≤ 10μM
Z80418-2-O RAW264.7 (Monocytic-macrophage Leukemia Cells) (cluster #2 Of 9), Other Other 8300 0.26 Functional ≤ 10μM
Z80548-3-O THP-1 (Acute Monocytic Leukemia Cells) (cluster #3 Of 5), Other Other 1210 0.31 Functional ≤ 10μM
Z80612-1-O 2008 (Ovarian Carcinoma Cells) (cluster #1 Of 2), Other Other 5000 0.27 Functional ≤ 10μM
Z81170-1-O LNCaP (Prostate Carcinoma) (cluster #1 Of 5), Other Other 8500 0.26 Functional ≤ 10μM
Z81186-1-O LS174T (Colon Adencocarcinoma Cells) (cluster #1 Of 2), Other Other 6500 0.27 Functional ≤ 10μM
Z81252-1-O MDA-MB-231 (Breast Adenocarcinoma Cells) (cluster #1 Of 11), Other Other 7600 0.27 Functional ≤ 10μM
Z80193-1-O L1210 (Lymphocytic Leukemia Cells) (cluster #1 Of 4), Other Other 9000 0.26 ADME/T ≤ 10μM
Z80874-1-O CEM (T-cell Leukemia) (cluster #1 Of 4), Other Other 8700 0.26 ADME/T ≤ 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.30 7.14 -22.28 2 6 0 93 368.385 8
Hi High (pH 8-9.5) 3.05 5.47 -58.07 2 6 -1 99 367.377 7

Analogs

12353732
12353732

Draw Identity 99% 90% 80% 70%

Vendors

And 55 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AHR-1-E Aryl Hydrocarbon Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 169 0.56 Binding ≤ 10μM
CAH1-4-E Carbonic Anhydrase I (cluster #4 Of 12), Eukaryotic Eukaryotes 2210 0.47 Binding ≤ 10μM
CAH12-2-E Carbonic Anhydrase XII (cluster #2 Of 9), Eukaryotic Eukaryotes 950 0.50 Binding ≤ 10μM
CAH13-7-E Carbonic Anhydrase XIII (cluster #7 Of 7), Eukaryotic Eukaryotes 4090 0.44 Binding ≤ 10μM
CAH14-4-E Carbonic Anhydrase XIV (cluster #4 Of 8), Eukaryotic Eukaryotes 830 0.50 Binding ≤ 10μM
CAH15-1-E Carbonic Anhydrase 15 (cluster #1 Of 6), Eukaryotic Eukaryotes 9360 0.41 Binding ≤ 10μM
CAH2-5-E Carbonic Anhydrase II (cluster #5 Of 15), Eukaryotic Eukaryotes 2770 0.46 Binding ≤ 10μM
CAH3-1-E Carbonic Anhydrase III (cluster #1 Of 6), Eukaryotic Eukaryotes 9090 0.42 Binding ≤ 10μM
CAH4-3-E Carbonic Anhydrase IV (cluster #3 Of 16), Eukaryotic Eukaryotes 4470 0.44 Binding ≤ 10μM
CAH5A-8-E Carbonic Anhydrase VA (cluster #8 Of 10), Eukaryotic Eukaryotes 4750 0.44 Binding ≤ 10μM
CAH5B-4-E Carbonic Anhydrase VB (cluster #4 Of 9), Eukaryotic Eukaryotes 4640 0.44 Binding ≤ 10μM
CAH6-2-E Carbonic Anhydrase VI (cluster #2 Of 8), Eukaryotic Eukaryotes 8070 0.42 Binding ≤ 10μM
CAH7-2-E Carbonic Anhydrase VII (cluster #2 Of 8), Eukaryotic Eukaryotes 4350 0.44 Binding ≤ 10μM
CAH9-3-E Carbonic Anhydrase IX (cluster #3 Of 11), Eukaryotic Eukaryotes 810 0.50 Binding ≤ 10μM
ESR1-5-E Estrogen Receptor Alpha (cluster #5 Of 5), Eukaryotic Eukaryotes 785 0.50 Binding ≤ 10μM
NQO2-4-E Quinone Reductase 2 (cluster #4 Of 4), Eukaryotic Eukaryotes 960 0.50 Binding ≤ 10μM
PGH1-2-E Cyclooxygenase-1 (cluster #2 Of 6), Eukaryotic Eukaryotes 830 0.50 Binding ≤ 10μM
PGH2-1-E Cyclooxygenase-2 (cluster #1 Of 8), Eukaryotic Eukaryotes 3490 0.45 Binding ≤ 10μM
PGH1-1-E Cyclooxygenase-1 (cluster #1 Of 2), Eukaryotic Eukaryotes 2840 0.46 Functional ≤ 10μM
Z102306-4-O Aorta (cluster #4 Of 6), Other Other 6918 0.42 Functional ≤ 10μM
Z80156-1-O HL-60 (Promyeloblast Leukemia Cells) (cluster #1 Of 12), Other Other 5000 0.44 Functional ≤ 10μM
Z80224-12-O MCF7 (Breast Carcinoma Cells) (cluster #12 Of 14), Other Other 0 0.00 Functional ≤ 10μM
Z80418-1-O RAW264.7 (Monocytic-macrophage Leukemia Cells) (cluster #1 Of 9), Other Other 4000 0.44 Functional ≤ 10μM
Z80492-2-O SK-N-SH (Neuroblastoma Cells) (cluster #2 Of 2), Other Other 0 0.00 Functional ≤ 10μM
Z80682-7-O A549 (Lung Carcinoma Cells) (cluster #7 Of 11), Other Other 0 0.00 Functional ≤ 10μM
Z81247-2-O HeLa (Cervical Adenocarcinoma Cells) (cluster #2 Of 9), Other Other 0 0.00 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.99 0.79 -8.46 3 3 0 61 228.247 2

Analogs

3978494
3978494
8681596
8681596
8681597
8681597

Draw Identity 99% 90% 80% 70%

Vendors

And 23 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
CAH1-1-E Carbonic Anhydrase I (cluster #1 Of 12), Eukaryotic Eukaryotes 2420 0.37 Binding ≤ 10μM
CAH12-2-E Carbonic Anhydrase XII (cluster #2 Of 9), Eukaryotic Eukaryotes 4720 0.36 Binding ≤ 10μM
CAH15-4-E Carbonic Anhydrase 15 (cluster #4 Of 6), Eukaryotic Eukaryotes 7680 0.34 Binding ≤ 10μM
CAH2-1-E Carbonic Anhydrase II (cluster #1 Of 15), Eukaryotic Eukaryotes 1840 0.38 Binding ≤ 10μM
CAH3-2-E Carbonic Anhydrase III (cluster #2 Of 6), Eukaryotic Eukaryotes 3580 0.36 Binding ≤ 10μM
CAH4-3-E Carbonic Anhydrase IV (cluster #3 Of 16), Eukaryotic Eukaryotes 4900 0.35 Binding ≤ 10μM
CAH5A-6-E Carbonic Anhydrase VA (cluster #6 Of 10), Eukaryotic Eukaryotes 4210 0.36 Binding ≤ 10μM
CAH5B-4-E Carbonic Anhydrase VB (cluster #4 Of 9), Eukaryotic Eukaryotes 4020 0.36 Binding ≤ 10μM
CAH6-1-E Carbonic Anhydrase VI (cluster #1 Of 8), Eukaryotic Eukaryotes 4910 0.35 Binding ≤ 10μM
CAH7-2-E Carbonic Anhydrase VII (cluster #2 Of 8), Eukaryotic Eukaryotes 450 0.42 Binding ≤ 10μM
CAH9-3-E Carbonic Anhydrase IX (cluster #3 Of 11), Eukaryotic Eukaryotes 5030 0.35 Binding ≤ 10μM
PGH1-2-E Cyclooxygenase-1 (cluster #2 Of 6), Eukaryotic Eukaryotes 2500 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) 1.37 -4.3 -13.35 5 6 0 110 290.271 1

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

And 58 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
CAH1-1-E Carbonic Anhydrase I (cluster #1 Of 12), Eukaryotic Eukaryotes 2420 0.37 Binding ≤ 10μM
CAH12-2-E Carbonic Anhydrase XII (cluster #2 Of 9), Eukaryotic Eukaryotes 4720 0.36 Binding ≤ 10μM
CAH15-4-E Carbonic Anhydrase 15 (cluster #4 Of 6), Eukaryotic Eukaryotes 7680 0.34 Binding ≤ 10μM
CAH2-1-E Carbonic Anhydrase II (cluster #1 Of 15), Eukaryotic Eukaryotes 1840 0.38 Binding ≤ 10μM
CAH3-2-E Carbonic Anhydrase III (cluster #2 Of 6), Eukaryotic Eukaryotes 3580 0.36 Binding ≤ 10μM
CAH4-3-E Carbonic Anhydrase IV (cluster #3 Of 16), Eukaryotic Eukaryotes 4900 0.35 Binding ≤ 10μM
CAH5A-6-E Carbonic Anhydrase VA (cluster #6 Of 10), Eukaryotic Eukaryotes 4210 0.36 Binding ≤ 10μM
CAH5B-4-E Carbonic Anhydrase VB (cluster #4 Of 9), Eukaryotic Eukaryotes 4020 0.36 Binding ≤ 10μM
CAH6-1-E Carbonic Anhydrase VI (cluster #1 Of 8), Eukaryotic Eukaryotes 4910 0.35 Binding ≤ 10μM
CAH7-2-E Carbonic Anhydrase VII (cluster #2 Of 8), Eukaryotic Eukaryotes 450 0.42 Binding ≤ 10μM
CAH9-3-E Carbonic Anhydrase IX (cluster #3 Of 11), Eukaryotic Eukaryotes 5030 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) 1.37 -4.94 -11.51 5 6 0 110 290.271 1

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

And 25 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
CAH1-1-E Carbonic Anhydrase I (cluster #1 Of 12), Eukaryotic Eukaryotes 2420 0.37 Binding ≤ 10μM
CAH12-2-E Carbonic Anhydrase XII (cluster #2 Of 9), Eukaryotic Eukaryotes 4720 0.36 Binding ≤ 10μM
CAH15-4-E Carbonic Anhydrase 15 (cluster #4 Of 6), Eukaryotic Eukaryotes 7680 0.34 Binding ≤ 10μM
CAH2-1-E Carbonic Anhydrase II (cluster #1 Of 15), Eukaryotic Eukaryotes 1840 0.38 Binding ≤ 10μM
CAH3-2-E Carbonic Anhydrase III (cluster #2 Of 6), Eukaryotic Eukaryotes 3580 0.36 Binding ≤ 10μM
CAH4-3-E Carbonic Anhydrase IV (cluster #3 Of 16), Eukaryotic Eukaryotes 4900 0.35 Binding ≤ 10μM
CAH5A-6-E Carbonic Anhydrase VA (cluster #6 Of 10), Eukaryotic Eukaryotes 4210 0.36 Binding ≤ 10μM
CAH5B-4-E Carbonic Anhydrase VB (cluster #4 Of 9), Eukaryotic Eukaryotes 4020 0.36 Binding ≤ 10μM
CAH6-1-E Carbonic Anhydrase VI (cluster #1 Of 8), Eukaryotic Eukaryotes 4910 0.35 Binding ≤ 10μM
CAH7-2-E Carbonic Anhydrase VII (cluster #2 Of 8), Eukaryotic Eukaryotes 450 0.42 Binding ≤ 10μM
CAH9-3-E Carbonic Anhydrase IX (cluster #3 Of 11), Eukaryotic Eukaryotes 5030 0.35 Binding ≤ 10μM
PGH1-2-E Cyclooxygenase-1 (cluster #2 Of 6), Eukaryotic Eukaryotes 5300 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) 1.37 -4.98 -12.32 5 6 0 110 290.271 1

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

And 43 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
CAH1-1-E Carbonic Anhydrase I (cluster #1 Of 12), Eukaryotic Eukaryotes 2420 0.37 Binding ≤ 10μM
CAH12-2-E Carbonic Anhydrase XII (cluster #2 Of 9), Eukaryotic Eukaryotes 4720 0.36 Binding ≤ 10μM
CAH15-4-E Carbonic Anhydrase 15 (cluster #4 Of 6), Eukaryotic Eukaryotes 7680 0.34 Binding ≤ 10μM
CAH2-1-E Carbonic Anhydrase II (cluster #1 Of 15), Eukaryotic Eukaryotes 1840 0.38 Binding ≤ 10μM
CAH3-2-E Carbonic Anhydrase III (cluster #2 Of 6), Eukaryotic Eukaryotes 3580 0.36 Binding ≤ 10μM
CAH4-3-E Carbonic Anhydrase IV (cluster #3 Of 16), Eukaryotic Eukaryotes 4900 0.35 Binding ≤ 10μM
CAH5A-6-E Carbonic Anhydrase VA (cluster #6 Of 10), Eukaryotic Eukaryotes 4210 0.36 Binding ≤ 10μM
CAH5B-4-E Carbonic Anhydrase VB (cluster #4 Of 9), Eukaryotic Eukaryotes 4020 0.36 Binding ≤ 10μM
CAH6-1-E Carbonic Anhydrase VI (cluster #1 Of 8), Eukaryotic Eukaryotes 4910 0.35 Binding ≤ 10μM
CAH7-2-E Carbonic Anhydrase VII (cluster #2 Of 8), Eukaryotic Eukaryotes 450 0.42 Binding ≤ 10μM
CAH9-3-E Carbonic Anhydrase IX (cluster #3 Of 11), Eukaryotic Eukaryotes 5030 0.35 Binding ≤ 10μM
PGH1-2-E Cyclooxygenase-1 (cluster #2 Of 6), Eukaryotic Eukaryotes 2000 0.38 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.37 -4.31 -13.19 5 6 0 110 290.271 1

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

And 70 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
CAH1-4-E Carbonic Anhydrase I (cluster #4 Of 12), Eukaryotic Eukaryotes 3200 0.64 Binding ≤ 10μM
CAH12-2-E Carbonic Anhydrase XII (cluster #2 Of 9), Eukaryotic Eukaryotes 7780 0.60 Binding ≤ 10μM
CAH13-1-E Carbonic Anhydrase XIII (cluster #1 Of 7), Eukaryotic Eukaryotes 9860 0.58 Binding ≤ 10μM
CAH14-4-E Carbonic Anhydrase XIV (cluster #4 Of 8), Eukaryotic Eukaryotes 7030 0.60 Binding ≤ 10μM
CAH2-13-E Carbonic Anhydrase II (cluster #13 Of 15), Eukaryotic Eukaryotes 2250 0.66 Binding ≤ 10μM
CAH3-2-E Carbonic Anhydrase III (cluster #2 Of 6), Eukaryotic Eukaryotes 7490 0.60 Binding ≤ 10μM
CAH4-3-E Carbonic Anhydrase IV (cluster #3 Of 16), Eukaryotic Eukaryotes 9800 0.58 Binding ≤ 10μM
CAH5A-6-E Carbonic Anhydrase VA (cluster #6 Of 10), Eukaryotic Eukaryotes 4080 0.63 Binding ≤ 10μM
CAH5B-4-E Carbonic Anhydrase VB (cluster #4 Of 9), Eukaryotic Eukaryotes 9970 0.58 Binding ≤ 10μM
CAH6-2-E Carbonic Anhydrase VI (cluster #2 Of 8), Eukaryotic Eukaryotes 6130 0.61 Binding ≤ 10μM
CAH7-2-E Carbonic Anhydrase VII (cluster #2 Of 8), Eukaryotic Eukaryotes 6070 0.61 Binding ≤ 10μM
CAH9-3-E Carbonic Anhydrase IX (cluster #3 Of 11), Eukaryotic Eukaryotes 6990 0.60 Binding ≤ 10μM
Q2PCB5-2-E Carbonic Anhydrase (cluster #2 Of 2), Eukaryotic Eukaryotes 4130 0.63 Binding ≤ 10μM
Z100766-1-O Radical Scavenging Activity (cluster #1 Of 2), Other Other 7300 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) 0.59 -2.02 -47.55 3 5 -1 101 169.112 1

Analogs

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
CAH1-4-E Carbonic Anhydrase I (cluster #4 Of 12), Eukaryotic Eukaryotes 7610 0.72 Binding ≤ 10μM
CAH1-4-E Carbonic Anhydrase I (cluster #4 Of 12), Eukaryotic Eukaryotes 9800 0.70 Binding ≤ 10μM
CAH12-9-E Carbonic Anhydrase XII (cluster #9 Of 9), Eukaryotic Eukaryotes 6270 0.73 Binding ≤ 10μM
CAH13-1-E Carbonic Anhydrase XIII (cluster #1 Of 7), Eukaryotic Eukaryotes 7790 0.72 Binding ≤ 10μM
CAH14-4-E Carbonic Anhydrase XIV (cluster #4 Of 8), Eukaryotic Eukaryotes 6160 0.73 Binding ≤ 10μM
CAH15-1-E Carbonic Anhydrase 15 (cluster #1 Of 6), Eukaryotic Eukaryotes 9320 0.70 Binding ≤ 10μM
CAH2-13-E Carbonic Anhydrase II (cluster #13 Of 15), Eukaryotic Eukaryotes 870 0.85 Binding ≤ 10μM
CAH2-13-E Carbonic Anhydrase II (cluster #13 Of 15), Eukaryotic Eukaryotes 7280 0.72 Binding ≤ 10μM
CAH3-2-E Carbonic Anhydrase III (cluster #2 Of 6), Eukaryotic Eukaryotes 6610 0.73 Binding ≤ 10μM
CAH4-3-E Carbonic Anhydrase IV (cluster #3 Of 16), Eukaryotic Eukaryotes 7780 0.72 Binding ≤ 10μM
CAH5A-6-E Carbonic Anhydrase VA (cluster #6 Of 10), Eukaryotic Eukaryotes 9200 0.71 Binding ≤ 10μM
CAH5B-4-E Carbonic Anhydrase VB (cluster #4 Of 9), Eukaryotic Eukaryotes 7130 0.72 Binding ≤ 10μM
CAH6-2-E Carbonic Anhydrase VI (cluster #2 Of 8), Eukaryotic Eukaryotes 5700 0.73 Binding ≤ 10μM
CAH7-2-E Carbonic Anhydrase VII (cluster #2 Of 8), Eukaryotic Eukaryotes 4080 0.75 Binding ≤ 10μM
CAH9-3-E Carbonic Anhydrase IX (cluster #3 Of 11), Eukaryotic Eukaryotes 3730 0.76 Binding ≤ 10μM
Q2PCB5-2-E Carbonic Anhydrase (cluster #2 Of 2), Eukaryotic Eukaryotes 8460 0.71 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.37 2.22 -47.43 1 3 -1 60 137.114 1

Analogs

4632590
4632590

Draw Identity 99% 90% 80% 70%

Vendors

And 65 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
CAH1-4-E Carbonic Anhydrase I (cluster #4 Of 12), Eukaryotic Eukaryotes 1070 0.70 Binding ≤ 10μM
CAH12-2-E Carbonic Anhydrase XII (cluster #2 Of 9), Eukaryotic Eukaryotes 8010 0.59 Binding ≤ 10μM
CAH14-4-E Carbonic Anhydrase XIV (cluster #4 Of 8), Eukaryotic Eukaryotes 6680 0.60 Binding ≤ 10μM
CAH2-13-E Carbonic Anhydrase II (cluster #13 Of 15), Eukaryotic Eukaryotes 980 0.70 Binding ≤ 10μM
CAH3-1-E Carbonic Anhydrase III (cluster #1 Of 6), Eukaryotic Eukaryotes 7570 0.60 Binding ≤ 10μM
CAH4-3-E Carbonic Anhydrase IV (cluster #3 Of 16), Eukaryotic Eukaryotes 9600 0.59 Binding ≤ 10μM
CAH5A-8-E Carbonic Anhydrase VA (cluster #8 Of 10), Eukaryotic Eukaryotes 5960 0.61 Binding ≤ 10μM
CAH5B-4-E Carbonic Anhydrase VB (cluster #4 Of 9), Eukaryotic Eukaryotes 7760 0.60 Binding ≤ 10μM
CAH6-2-E Carbonic Anhydrase VI (cluster #2 Of 8), Eukaryotic Eukaryotes 6720 0.60 Binding ≤ 10μM
CAH7-2-E Carbonic Anhydrase VII (cluster #2 Of 8), Eukaryotic Eukaryotes 5230 0.62 Binding ≤ 10μM
CAH9-3-E Carbonic Anhydrase IX (cluster #3 Of 11), Eukaryotic Eukaryotes 5330 0.62 Binding ≤ 10μM
Z50594-8-O Mus Musculus (cluster #8 Of 9), Other Other 190 0.78 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.43 2.5 -50.43 1 3 -1 60 163.152 2

Analogs

57278
57278

Draw Identity 99% 90% 80% 70%

Vendors

And 23 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
CAH1-4-E Carbonic Anhydrase I (cluster #4 Of 12), Eukaryotic Eukaryotes 1920 0.36 Binding ≤ 10μM
CAH12-2-E Carbonic Anhydrase XII (cluster #2 Of 9), Eukaryotic Eukaryotes 4350 0.34 Binding ≤ 10μM
CAH13-6-E Carbonic Anhydrase XIII (cluster #6 Of 7), Eukaryotic Eukaryotes 9530 0.32 Binding ≤ 10μM
CAH15-1-E Carbonic Anhydrase 15 (cluster #1 Of 6), Eukaryotic Eukaryotes 390 0.41 Binding ≤ 10μM
CAH2-5-E Carbonic Anhydrase II (cluster #5 Of 15), Eukaryotic Eukaryotes 480 0.40 Binding ≤ 10μM
CAH3-1-E Carbonic Anhydrase III (cluster #1 Of 6), Eukaryotic Eukaryotes 7400 0.33 Binding ≤ 10μM
CAH4-3-E Carbonic Anhydrase IV (cluster #3 Of 16), Eukaryotic Eukaryotes 8980 0.32 Binding ≤ 10μM
CAH5A-10-E Carbonic Anhydrase VA (cluster #10 Of 10), Eukaryotic Eukaryotes 730 0.39 Binding ≤ 10μM
CAH5B-4-E Carbonic Anhydrase VB (cluster #4 Of 9), Eukaryotic Eukaryotes 890 0.39 Binding ≤ 10μM
CAH6-4-E Carbonic Anhydrase VI (cluster #4 Of 8), Eukaryotic Eukaryotes 9470 0.32 Binding ≤ 10μM
CAH7-2-E Carbonic Anhydrase VII (cluster #2 Of 8), Eukaryotic Eukaryotes 4300 0.34 Binding ≤ 10μM
CAH9-3-E Carbonic Anhydrase IX (cluster #3 Of 11), Eukaryotic Eukaryotes 9820 0.32 Binding ≤ 10μM
Z50038-1-O Plasmodium Yoelii Yoelii (cluster #1 Of 2), Other Other 4 0.53 Functional ≤ 10μM
Z50425-3-O Plasmodium Falciparum (cluster #3 Of 22), Other Other 10000 0.32 Functional ≤ 10μM
Z50512-1-O Cavia Porcellus (cluster #1 Of 7), Other Other 470 0.40 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.11 3.38 -54.79 5 4 1 77 302.394 7

Analogs

3911
3911

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
CAH1-4-E Carbonic Anhydrase I (cluster #4 Of 12), Eukaryotic Eukaryotes 1920 0.36 Binding ≤ 10μM
CAH12-2-E Carbonic Anhydrase XII (cluster #2 Of 9), Eukaryotic Eukaryotes 4350 0.34 Binding ≤ 10μM
CAH13-6-E Carbonic Anhydrase XIII (cluster #6 Of 7), Eukaryotic Eukaryotes 9530 0.32 Binding ≤ 10μM
CAH15-1-E Carbonic Anhydrase 15 (cluster #1 Of 6), Eukaryotic Eukaryotes 390 0.41 Binding ≤ 10μM
CAH2-5-E Carbonic Anhydrase II (cluster #5 Of 15), Eukaryotic Eukaryotes 480 0.40 Binding ≤ 10μM
CAH3-1-E Carbonic Anhydrase III (cluster #1 Of 6), Eukaryotic Eukaryotes 7400 0.33 Binding ≤ 10μM
CAH4-3-E Carbonic Anhydrase IV (cluster #3 Of 16), Eukaryotic Eukaryotes 8980 0.32 Binding ≤ 10μM
CAH5A-10-E Carbonic Anhydrase VA (cluster #10 Of 10), Eukaryotic Eukaryotes 730 0.39 Binding ≤ 10μM
CAH5B-4-E Carbonic Anhydrase VB (cluster #4 Of 9), Eukaryotic Eukaryotes 890 0.39 Binding ≤ 10μM
CAH6-4-E Carbonic Anhydrase VI (cluster #4 Of 8), Eukaryotic Eukaryotes 9470 0.32 Binding ≤ 10μM
CAH7-2-E Carbonic Anhydrase VII (cluster #2 Of 8), Eukaryotic Eukaryotes 4300 0.34 Binding ≤ 10μM
CAH9-3-E Carbonic Anhydrase IX (cluster #3 Of 11), Eukaryotic Eukaryotes 9820 0.32 Binding ≤ 10μM
Z50038-1-O Plasmodium Yoelii Yoelii (cluster #1 Of 2), Other Other 4 0.53 Functional ≤ 10μM
Z50425-3-O Plasmodium Falciparum (cluster #3 Of 22), Other Other 10000 0.32 Functional ≤ 10μM
Z50512-1-O Cavia Porcellus (cluster #1 Of 7), Other Other 470 0.40 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.11 3.38 -54.72 5 4 1 77 302.394 7

Analogs

3831448
3831448
4016718
4016718
5339605
5339605
8552019
8552019
14984516
14984516

Draw Identity 99% 90% 80% 70%

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
CAH1-1-E Carbonic Anhydrase I (cluster #1 Of 12), Eukaryotic Eukaryotes 1490 0.23 Binding ≤ 10μM
CAH12-2-E Carbonic Anhydrase XII (cluster #2 Of 9), Eukaryotic Eukaryotes 9050 0.20 Binding ≤ 10μM
CAH13-1-E Carbonic Anhydrase XIII (cluster #1 Of 7), Eukaryotic Eukaryotes 4820 0.21 Binding ≤ 10μM
CAH15-4-E Carbonic Anhydrase 15 (cluster #4 Of 6), Eukaryotic Eukaryotes 650 0.25 Binding ≤ 10μM
CAH2-1-E Carbonic Anhydrase II (cluster #1 Of 15), Eukaryotic Eukaryotes 2510 0.22 Binding ≤ 10μM
CAH3-2-E Carbonic Anhydrase III (cluster #2 Of 6), Eukaryotic Eukaryotes 6430 0.21 Binding ≤ 10μM
CAH4-3-E Carbonic Anhydrase IV (cluster #3 Of 16), Eukaryotic Eukaryotes 8960 0.20 Binding ≤ 10μM
CAH5A-6-E Carbonic Anhydrase VA (cluster #6 Of 10), Eukaryotic Eukaryotes 4080 0.22 Binding ≤ 10μM
CAH5B-4-E Carbonic Anhydrase VB (cluster #4 Of 9), Eukaryotic Eukaryotes 4560 0.21 Binding ≤ 10μM
CAH6-1-E Carbonic Anhydrase VI (cluster #1 Of 8), Eukaryotic Eukaryotes 9700 0.20 Binding ≤ 10μM
CAH7-2-E Carbonic Anhydrase VII (cluster #2 Of 8), Eukaryotic Eukaryotes 4710 0.21 Binding ≤ 10μM
MDR3-1-E P-glycoprotein 3 (cluster #1 Of 2), Eukaryotic Eukaryotes 6800 0.21 Binding ≤ 10μM
CP2C9-1-E Cytochrome P450 2C9 (cluster #1 Of 3), Eukaryotic Eukaryotes 5000 0.21 ADME/T ≤ 10μM
Z81057-1-O HUVEC (Umbilical Vein Endothelial Cells) (cluster #1 Of 4), Other Other 9990 0.20 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.47 -8.69 -16.42 5 10 0 155 482.441 4

Analogs

4016718
4016718
5339605
5339605
8552019
8552019
17044428
17044428
17044430
17044430

Draw Identity 99% 90% 80% 70%

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
CAH1-1-E Carbonic Anhydrase I (cluster #1 Of 12), Eukaryotic Eukaryotes 1490 0.23 Binding ≤ 10μM
CAH12-2-E Carbonic Anhydrase XII (cluster #2 Of 9), Eukaryotic Eukaryotes 9050 0.20 Binding ≤ 10μM
CAH13-1-E Carbonic Anhydrase XIII (cluster #1 Of 7), Eukaryotic Eukaryotes 4820 0.21 Binding ≤ 10μM
CAH15-4-E Carbonic Anhydrase 15 (cluster #4 Of 6), Eukaryotic Eukaryotes 650 0.25 Binding ≤ 10μM
CAH2-1-E Carbonic Anhydrase II (cluster #1 Of 15), Eukaryotic Eukaryotes 2510 0.22 Binding ≤ 10μM
CAH3-2-E Carbonic Anhydrase III (cluster #2 Of 6), Eukaryotic Eukaryotes 6430 0.21 Binding ≤ 10μM
CAH4-3-E Carbonic Anhydrase IV (cluster #3 Of 16), Eukaryotic Eukaryotes 8960 0.20 Binding ≤ 10μM
CAH5A-6-E Carbonic Anhydrase VA (cluster #6 Of 10), Eukaryotic Eukaryotes 4080 0.22 Binding ≤ 10μM
CAH5B-4-E Carbonic Anhydrase VB (cluster #4 Of 9), Eukaryotic Eukaryotes 4560 0.21 Binding ≤ 10μM
CAH6-1-E Carbonic Anhydrase VI (cluster #1 Of 8), Eukaryotic Eukaryotes 9700 0.20 Binding ≤ 10μM
CAH7-2-E Carbonic Anhydrase VII (cluster #2 Of 8), Eukaryotic Eukaryotes 4710 0.21 Binding ≤ 10μM
MDR3-1-E P-glycoprotein 3 (cluster #1 Of 2), Eukaryotic Eukaryotes 6800 0.21 Binding ≤ 10μM
CP2C9-1-E Cytochrome P450 2C9 (cluster #1 Of 3), Eukaryotic Eukaryotes 5000 0.21 ADME/T ≤ 10μM
Z81057-1-O HUVEC (Umbilical Vein Endothelial Cells) (cluster #1 Of 4), Other Other 9990 0.20 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.47 -8.74 -16.51 5 10 0 155 482.441 4

Analogs

4016718
4016718
5339605
5339605
8552019
8552019
17044428
17044428
17044430
17044430

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
CAH1-1-E Carbonic Anhydrase I (cluster #1 Of 12), Eukaryotic Eukaryotes 1490 0.23 Binding ≤ 10μM
CAH12-2-E Carbonic Anhydrase XII (cluster #2 Of 9), Eukaryotic Eukaryotes 9050 0.20 Binding ≤ 10μM
CAH13-1-E Carbonic Anhydrase XIII (cluster #1 Of 7), Eukaryotic Eukaryotes 4820 0.21 Binding ≤ 10μM
CAH15-4-E Carbonic Anhydrase 15 (cluster #4 Of 6), Eukaryotic Eukaryotes 650 0.25 Binding ≤ 10μM
CAH2-1-E Carbonic Anhydrase II (cluster #1 Of 15), Eukaryotic Eukaryotes 2510 0.22 Binding ≤ 10μM
CAH3-2-E Carbonic Anhydrase III (cluster #2 Of 6), Eukaryotic Eukaryotes 6430 0.21 Binding ≤ 10μM
CAH4-3-E Carbonic Anhydrase IV (cluster #3 Of 16), Eukaryotic Eukaryotes 8960 0.20 Binding ≤ 10μM
CAH5A-6-E Carbonic Anhydrase VA (cluster #6 Of 10), Eukaryotic Eukaryotes 4080 0.22 Binding ≤ 10μM
CAH5B-4-E Carbonic Anhydrase VB (cluster #4 Of 9), Eukaryotic Eukaryotes 4560 0.21 Binding ≤ 10μM
CAH6-1-E Carbonic Anhydrase VI (cluster #1 Of 8), Eukaryotic Eukaryotes 9700 0.20 Binding ≤ 10μM
CAH7-2-E Carbonic Anhydrase VII (cluster #2 Of 8), Eukaryotic Eukaryotes 4710 0.21 Binding ≤ 10μM
MDR3-1-E P-glycoprotein 3 (cluster #1 Of 2), Eukaryotic Eukaryotes 6800 0.21 Binding ≤ 10μM
CP2C9-1-E Cytochrome P450 2C9 (cluster #1 Of 3), Eukaryotic Eukaryotes 5000 0.21 ADME/T ≤ 10μM
Z81057-1-O HUVEC (Umbilical Vein Endothelial Cells) (cluster #1 Of 4), Other Other 9990 0.20 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.47 -1.32 -16.67 5 10 0 155 482.441 4
Hi High (pH 8-9.5) 1.47 -0.33 -56.57 4 10 -1 158 481.433 4

Analogs

1530850
1530850
1554609
1554609

Draw Identity 99% 90% 80% 70%

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
CAH1-1-E Carbonic Anhydrase I (cluster #1 Of 12), Eukaryotic Eukaryotes 1490 0.23 Binding ≤ 10μM
CAH12-2-E Carbonic Anhydrase XII (cluster #2 Of 9), Eukaryotic Eukaryotes 9050 0.20 Binding ≤ 10μM
CAH13-1-E Carbonic Anhydrase XIII (cluster #1 Of 7), Eukaryotic Eukaryotes 4820 0.21 Binding ≤ 10μM
CAH15-4-E Carbonic Anhydrase 15 (cluster #4 Of 6), Eukaryotic Eukaryotes 650 0.25 Binding ≤ 10μM
CAH2-1-E Carbonic Anhydrase II (cluster #1 Of 15), Eukaryotic Eukaryotes 2510 0.22 Binding ≤ 10μM
CAH3-2-E Carbonic Anhydrase III (cluster #2 Of 6), Eukaryotic Eukaryotes 6430 0.21 Binding ≤ 10μM
CAH4-3-E Carbonic Anhydrase IV (cluster #3 Of 16), Eukaryotic Eukaryotes 8960 0.20 Binding ≤ 10μM
CAH5A-6-E Carbonic Anhydrase VA (cluster #6 Of 10), Eukaryotic Eukaryotes 4080 0.22 Binding ≤ 10μM
CAH5B-4-E Carbonic Anhydrase VB (cluster #4 Of 9), Eukaryotic Eukaryotes 4560 0.21 Binding ≤ 10μM
CAH6-1-E Carbonic Anhydrase VI (cluster #1 Of 8), Eukaryotic Eukaryotes 9700 0.20 Binding ≤ 10μM
CAH7-2-E Carbonic Anhydrase VII (cluster #2 Of 8), Eukaryotic Eukaryotes 4710 0.21 Binding ≤ 10μM
MDR3-1-E P-glycoprotein 3 (cluster #1 Of 2), Eukaryotic Eukaryotes 6800 0.21 Binding ≤ 10μM
CP2C9-1-E Cytochrome P450 2C9 (cluster #1 Of 3), Eukaryotic Eukaryotes 5000 0.21 ADME/T ≤ 10μM
Z81057-1-O HUVEC (Umbilical Vein Endothelial Cells) (cluster #1 Of 4), Other Other 9990 0.20 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.47 -1.49 -26.41 5 10 0 155 482.441 4
Hi High (pH 8-9.5) 1.47 -0.48 -66.96 4 10 -1 158 481.433 4

Parameters Provided:

target.name = CAH4-3-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 'CAH4-3-E' AND t.atype_fk = 0 AND c.purchasable IN (1,2,4,5)    LIMIT 50

Permalink

Embed Link to Results