Warning: session_write_close() [function.session-write-close]: open(/tmp/session/sess_f73369lonc9o15us3a62nlmk11, O_RDWR) failed: No such file or directory (2) in /domains/zinc12/htdocs/lib/zinc/user/ZincAuthentication.php on line 109

Warning: session_write_close() [function.session-write-close]: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp/session) in /domains/zinc12/htdocs/lib/zinc/user/ZincAuthentication.php on line 109
Search Results | ZINC Is Not Commercial - A database of commercially-available compounds
UCSF
ZINC Item Suppliers, Protomers, & Similar Substances

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

And 3 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
CYNT-2-B Carbonic Anhydrase (cluster #2 Of 3), Bacterial Bacteria 2090 0.80 Binding ≤ 10μM
B5SU02-5-E Alpha Carbonic Anhydrase (cluster #5 Of 6), Eukaryotic Eukaryotes 105 0.98 Binding ≤ 10μM
C0IX24-4-E Carbonic Anhydrase (cluster #4 Of 5), Eukaryotic Eukaryotes 361 0.90 Binding ≤ 10μM
CAH1-1-E Carbonic Anhydrase I (cluster #1 Of 12), Eukaryotic Eukaryotes 8600 0.71 Binding ≤ 10μM
CAH12-8-E Carbonic Anhydrase XII (cluster #8 Of 9), Eukaryotic Eukaryotes 34 1.05 Binding ≤ 10μM
CAH13-2-E Carbonic Anhydrase XIII (cluster #2 Of 7), Eukaryotic Eukaryotes 79 0.99 Binding ≤ 10μM
CAH14-7-E Carbonic Anhydrase XIV (cluster #7 Of 8), Eukaryotic Eukaryotes 280 0.92 Binding ≤ 10μM
CAH15-6-E Carbonic Anhydrase 15 (cluster #6 Of 6), Eukaryotic Eukaryotes 48 1.02 Binding ≤ 10μM
CAH2-1-E Carbonic Anhydrase II (cluster #1 Of 15), Eukaryotic Eukaryotes 7400 0.72 Binding ≤ 10μM
CAH4-12-E Carbonic Anhydrase IV (cluster #12 Of 16), Eukaryotic Eukaryotes 540 0.88 Binding ≤ 10μM
CAH5A-2-E Carbonic Anhydrase VA (cluster #2 Of 10), Eukaryotic Eukaryotes 2300 0.79 Binding ≤ 10μM
CAH5B-2-E Carbonic Anhydrase VB (cluster #2 Of 9), Eukaryotic Eukaryotes 2150 0.79 Binding ≤ 10μM
CAH6-1-E Carbonic Anhydrase VI (cluster #1 Of 8), Eukaryotic Eukaryotes 798 0.85 Binding ≤ 10μM
CAH7-7-E Carbonic Anhydrase VII (cluster #7 Of 8), Eukaryotic Eukaryotes 5 1.16 Binding ≤ 10μM
CAH9-10-E Carbonic Anhydrase IX (cluster #10 Of 11), Eukaryotic Eukaryotes 41 1.03 Binding ≤ 10μM
CAN-3-F Carbonic Anhydrase (cluster #3 Of 3), Fungal Fungi 447 0.89 Binding ≤ 10μM
Q5AJ71-3-F Carbonic Anhydrase (cluster #3 Of 4), Fungal Fungi 832 0.85 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.88 -5.22 -12.61 4 6 0 112 180.214 1
Mid Mid (pH 6-8) -0.88 -4.74 -44.86 3 6 -1 109 179.206 1

Analogs

39332864
39332864

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-10-E Carbonic Anhydrase I (cluster #10 Of 12), Eukaryotic Eukaryotes 258 0.66 Binding ≤ 10μM
CAH10-2-E Carbonic Anhydrase-related Protein 10 (cluster #2 Of 2), Eukaryotic Eukaryotes 258 0.66 Binding ≤ 10μM
CAH11-2-E Carbonic Anhydrase-related Protein 2 (cluster #2 Of 2), Eukaryotic Eukaryotes 258 0.66 Binding ≤ 10μM
CAH12-8-E Carbonic Anhydrase XII (cluster #8 Of 9), Eukaryotic Eukaryotes 258 0.66 Binding ≤ 10μM
CAH13-2-E Carbonic Anhydrase XIII (cluster #2 Of 7), Eukaryotic Eukaryotes 258 0.66 Binding ≤ 10μM
CAH14-7-E Carbonic Anhydrase XIV (cluster #7 Of 8), Eukaryotic Eukaryotes 258 0.66 Binding ≤ 10μM
CAH2-11-E Carbonic Anhydrase II (cluster #11 Of 15), Eukaryotic Eukaryotes 258 0.66 Binding ≤ 10μM
CAH3-5-E Carbonic Anhydrase III (cluster #5 Of 6), Eukaryotic Eukaryotes 258 0.66 Binding ≤ 10μM
CAH4-12-E Carbonic Anhydrase IV (cluster #12 Of 16), Eukaryotic Eukaryotes 258 0.66 Binding ≤ 10μM
CAH5A-2-E Carbonic Anhydrase VA (cluster #2 Of 10), Eukaryotic Eukaryotes 258 0.66 Binding ≤ 10μM
CAH5B-2-E Carbonic Anhydrase VB (cluster #2 Of 9), Eukaryotic Eukaryotes 258 0.66 Binding ≤ 10μM
CAH6-1-E Carbonic Anhydrase VI (cluster #1 Of 8), Eukaryotic Eukaryotes 258 0.66 Binding ≤ 10μM
CAH7-7-E Carbonic Anhydrase VII (cluster #7 Of 8), Eukaryotic Eukaryotes 258 0.66 Binding ≤ 10μM
CAH8-2-E Carbonic Anhydrase-related Protein 8 (cluster #2 Of 2), Eukaryotic Eukaryotes 258 0.66 Binding ≤ 10μM
CAH9-10-E Carbonic Anhydrase IX (cluster #10 Of 11), Eukaryotic Eukaryotes 258 0.66 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.77 -3.07 -18.21 2 7 0 101 236.278 3
Hi High (pH 8-9.5) -0.77 -3.59 -51.44 1 7 -1 103 235.27 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
CAH1-1-E Carbonic Anhydrase I (cluster #1 Of 12), Eukaryotic Eukaryotes 70 0.72 Binding ≤ 10μM
CAH2-1-E Carbonic Anhydrase II (cluster #1 Of 15), Eukaryotic Eukaryotes 9 0.80 Binding ≤ 10μM
CAH4-12-E Carbonic Anhydrase IV (cluster #12 Of 16), Eukaryotic Eukaryotes 19 0.77 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.40 -2.84 -31.27 5 5 1 100 230.294 1
Hi High (pH 8-9.5) 0.40 -2.35 -28.25 4 5 0 98 229.286 1
Hi High (pH 8-9.5) 0.40 -2.77 -51.49 3 5 -1 97 228.278 1

Analogs

39891627
39891627
39891630
39891630
39891633
39891633
5816052
5816052

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-10-E Carbonic Anhydrase I (cluster #10 Of 12), Eukaryotic Eukaryotes 7010 0.60 Binding ≤ 10μM
CAH2-11-E Carbonic Anhydrase II (cluster #11 Of 15), Eukaryotic Eukaryotes 950 0.70 Binding ≤ 10μM
CAH4-12-E Carbonic Anhydrase IV (cluster #12 Of 16), Eukaryotic Eukaryotes 8640 0.59 Binding ≤ 10μM

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) -0.44 -2.36 -42.74 2 6 -1 100 207.26 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
CYNT-2-B Carbonic Anhydrase (cluster #2 Of 3), Bacterial Bacteria 2380 0.72 Binding ≤ 10μM
B5SU02-5-E Alpha Carbonic Anhydrase (cluster #5 Of 6), Eukaryotic Eukaryotes 92 0.90 Binding ≤ 10μM
C0IX24-4-E Carbonic Anhydrase (cluster #4 Of 5), Eukaryotic Eukaryotes 357 0.82 Binding ≤ 10μM
CAH1-1-E Carbonic Anhydrase I (cluster #1 Of 12), Eukaryotic Eukaryotes 9300 0.64 Binding ≤ 10μM
CAH12-8-E Carbonic Anhydrase XII (cluster #8 Of 9), Eukaryotic Eukaryotes 4 1.07 Binding ≤ 10μM
CAH14-7-E Carbonic Anhydrase XIV (cluster #7 Of 8), Eukaryotic Eukaryotes 245 0.84 Binding ≤ 10μM
CAH15-6-E Carbonic Anhydrase 15 (cluster #6 Of 6), Eukaryotic Eukaryotes 49 0.93 Binding ≤ 10μM
CAH2-1-E Carbonic Anhydrase II (cluster #1 Of 15), Eukaryotic Eukaryotes 19 0.98 Binding ≤ 10μM
CAH4-12-E Carbonic Anhydrase IV (cluster #12 Of 16), Eukaryotic Eukaryotes 355 0.82 Binding ≤ 10μM
CAH5A-2-E Carbonic Anhydrase VA (cluster #2 Of 10), Eukaryotic Eukaryotes 2160 0.72 Binding ≤ 10μM
CAH5B-2-E Carbonic Anhydrase VB (cluster #2 Of 9), Eukaryotic Eukaryotes 2075 0.72 Binding ≤ 10μM
CAH6-1-E Carbonic Anhydrase VI (cluster #1 Of 8), Eukaryotic Eukaryotes 740 0.78 Binding ≤ 10μM
CAH7-7-E Carbonic Anhydrase VII (cluster #7 Of 8), Eukaryotic Eukaryotes 4 1.07 Binding ≤ 10μM
CAH9-10-E Carbonic Anhydrase IX (cluster #10 Of 11), Eukaryotic Eukaryotes 30 0.96 Binding ≤ 10μM
CAN-3-F Carbonic Anhydrase (cluster #3 Of 3), Fungal Fungi 360 0.82 Binding ≤ 10μM
Q5AJ71-3-F Carbonic Anhydrase (cluster #3 Of 4), Fungal Fungi 19 0.98 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
Mid Mid (pH 6-8) -1.32 -4.01 -9.54 3 6 0 102 194.241 1
Mid Mid (pH 6-8) -1.32 -4 -10.43 3 6 0 102 194.241 1
Mid Mid (pH 6-8) -4.44 -3.84 -39.75 4 6 1 103 195.249 1

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
CYNT-2-B Carbonic Anhydrase (cluster #2 Of 3), Bacterial Bacteria 2380 0.72 Binding ≤ 10μM
B5SU02-5-E Alpha Carbonic Anhydrase (cluster #5 Of 6), Eukaryotic Eukaryotes 92 0.90 Binding ≤ 10μM
C0IX24-4-E Carbonic Anhydrase (cluster #4 Of 5), Eukaryotic Eukaryotes 357 0.82 Binding ≤ 10μM
CAH1-1-E Carbonic Anhydrase I (cluster #1 Of 12), Eukaryotic Eukaryotes 9300 0.64 Binding ≤ 10μM
CAH12-8-E Carbonic Anhydrase XII (cluster #8 Of 9), Eukaryotic Eukaryotes 4 1.07 Binding ≤ 10μM
CAH14-7-E Carbonic Anhydrase XIV (cluster #7 Of 8), Eukaryotic Eukaryotes 245 0.84 Binding ≤ 10μM
CAH15-6-E Carbonic Anhydrase 15 (cluster #6 Of 6), Eukaryotic Eukaryotes 49 0.93 Binding ≤ 10μM
CAH2-1-E Carbonic Anhydrase II (cluster #1 Of 15), Eukaryotic Eukaryotes 19 0.98 Binding ≤ 10μM
CAH4-12-E Carbonic Anhydrase IV (cluster #12 Of 16), Eukaryotic Eukaryotes 355 0.82 Binding ≤ 10μM
CAH5A-2-E Carbonic Anhydrase VA (cluster #2 Of 10), Eukaryotic Eukaryotes 2160 0.72 Binding ≤ 10μM
CAH5B-2-E Carbonic Anhydrase VB (cluster #2 Of 9), Eukaryotic Eukaryotes 2075 0.72 Binding ≤ 10μM
CAH6-1-E Carbonic Anhydrase VI (cluster #1 Of 8), Eukaryotic Eukaryotes 740 0.78 Binding ≤ 10μM
CAH7-7-E Carbonic Anhydrase VII (cluster #7 Of 8), Eukaryotic Eukaryotes 4 1.07 Binding ≤ 10μM
CAH9-10-E Carbonic Anhydrase IX (cluster #10 Of 11), Eukaryotic Eukaryotes 30 0.96 Binding ≤ 10μM
CAN-3-F Carbonic Anhydrase (cluster #3 Of 3), Fungal Fungi 360 0.82 Binding ≤ 10μM
Q5AJ71-3-F Carbonic Anhydrase (cluster #3 Of 4), Fungal Fungi 19 0.98 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

Analogs

32150186
32150186

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-10-E Carbonic Anhydrase I (cluster #10 Of 12), Eukaryotic Eukaryotes 550 0.52 Binding ≤ 10μM
CAH10-2-E Carbonic Anhydrase-related Protein 10 (cluster #2 Of 2), Eukaryotic Eukaryotes 550 0.52 Binding ≤ 10μM
CAH11-2-E Carbonic Anhydrase-related Protein 2 (cluster #2 Of 2), Eukaryotic Eukaryotes 550 0.52 Binding ≤ 10μM
CAH12-8-E Carbonic Anhydrase XII (cluster #8 Of 9), Eukaryotic Eukaryotes 550 0.52 Binding ≤ 10μM
CAH13-2-E Carbonic Anhydrase XIII (cluster #2 Of 7), Eukaryotic Eukaryotes 550 0.52 Binding ≤ 10μM
CAH14-7-E Carbonic Anhydrase XIV (cluster #7 Of 8), Eukaryotic Eukaryotes 550 0.52 Binding ≤ 10μM
CAH2-11-E Carbonic Anhydrase II (cluster #11 Of 15), Eukaryotic Eukaryotes 550 0.52 Binding ≤ 10μM
CAH3-5-E Carbonic Anhydrase III (cluster #5 Of 6), Eukaryotic Eukaryotes 550 0.52 Binding ≤ 10μM
CAH4-12-E Carbonic Anhydrase IV (cluster #12 Of 16), Eukaryotic Eukaryotes 550 0.52 Binding ≤ 10μM
CAH5A-2-E Carbonic Anhydrase VA (cluster #2 Of 10), Eukaryotic Eukaryotes 550 0.52 Binding ≤ 10μM
CAH5B-2-E Carbonic Anhydrase VB (cluster #2 Of 9), Eukaryotic Eukaryotes 550 0.52 Binding ≤ 10μM
CAH6-1-E Carbonic Anhydrase VI (cluster #1 Of 8), Eukaryotic Eukaryotes 550 0.52 Binding ≤ 10μM
CAH7-7-E Carbonic Anhydrase VII (cluster #7 Of 8), Eukaryotic Eukaryotes 550 0.52 Binding ≤ 10μM
CAH8-2-E Carbonic Anhydrase-related Protein 8 (cluster #2 Of 2), Eukaryotic Eukaryotes 550 0.52 Binding ≤ 10μM
CAH9-10-E Carbonic Anhydrase IX (cluster #10 Of 11), Eukaryotic Eukaryotes 550 0.52 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.40 -2.86 -52.35 3 9 -1 155 279.279 5
Mid Mid (pH 6-8) -1.40 -2.37 -92.86 2 9 -2 153 278.271 5

Analogs

4217364
4217364

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
CAH-1-A Carbonic Anhydrase (cluster #1 Of 2), Archaea Archaea 60 0.78 Binding ≤ 10μM
CYNT-2-B Carbonic Anhydrase (cluster #2 Of 3), Bacterial Bacteria 9 0.87 Binding ≤ 10μM
P96878-1-B PROBABLE TRANSMEMBRANE CARBONIC ANHYDRASE (CARBONATE DEHYDRATASE) (CARBONIC DEHYDRATASE) (cluster #1 Of 2), Bacterial Bacteria 12 0.85 Binding ≤ 10μM
Y1284-1-B Uncharacterized Protein Rv1284/MT1322 (cluster #1 Of 2), Bacterial Bacteria 481 0.68 Binding ≤ 10μM
B5SU02-5-E Alpha Carbonic Anhydrase (cluster #5 Of 6), Eukaryotic Eukaryotes 16 0.84 Binding ≤ 10μM
C0IX24-4-E Carbonic Anhydrase (cluster #4 Of 5), Eukaryotic Eukaryotes 74 0.77 Binding ≤ 10μM
CAH1-10-E Carbonic Anhydrase I (cluster #10 Of 12), Eukaryotic Eukaryotes 900 0.65 Binding ≤ 10μM
CAH10-2-E Carbonic Anhydrase-related Protein 10 (cluster #2 Of 2), Eukaryotic Eukaryotes 440 0.68 Binding ≤ 10μM
CAH11-2-E Carbonic Anhydrase-related Protein 2 (cluster #2 Of 2), Eukaryotic Eukaryotes 440 0.68 Binding ≤ 10μM
CAH12-8-E Carbonic Anhydrase XII (cluster #8 Of 9), Eukaryotic Eukaryotes 6 0.89 Binding ≤ 10μM
CAH13-2-E Carbonic Anhydrase XIII (cluster #2 Of 7), Eukaryotic Eukaryotes 490 0.68 Binding ≤ 10μM
CAH14-7-E Carbonic Anhydrase XIV (cluster #7 Of 8), Eukaryotic Eukaryotes 440 0.68 Binding ≤ 10μM
CAH15-6-E Carbonic Anhydrase 15 (cluster #6 Of 6), Eukaryotic Eukaryotes 72 0.77 Binding ≤ 10μM
CAH2-11-E Carbonic Anhydrase II (cluster #11 Of 15), Eukaryotic Eukaryotes 7 0.88 Binding ≤ 10μM
CAH3-5-E Carbonic Anhydrase III (cluster #5 Of 6), Eukaryotic Eukaryotes 7 0.88 Binding ≤ 10μM
CAH4-12-E Carbonic Anhydrase IV (cluster #12 Of 16), Eukaryotic Eukaryotes 72 0.77 Binding ≤ 10μM
CAH5A-2-E Carbonic Anhydrase VA (cluster #2 Of 10), Eukaryotic Eukaryotes 7 0.88 Binding ≤ 10μM
CAH5B-2-E Carbonic Anhydrase VB (cluster #2 Of 9), Eukaryotic Eukaryotes 54 0.78 Binding ≤ 10μM
CAH6-1-E Carbonic Anhydrase VI (cluster #1 Of 8), Eukaryotic Eukaryotes 7 0.88 Binding ≤ 10μM
CAH7-7-E Carbonic Anhydrase VII (cluster #7 Of 8), Eukaryotic Eukaryotes 16 0.84 Binding ≤ 10μM
CAH8-2-E Carbonic Anhydrase-related Protein 8 (cluster #2 Of 2), Eukaryotic Eukaryotes 440 0.68 Binding ≤ 10μM
CAH9-10-E Carbonic Anhydrase IX (cluster #10 Of 11), Eukaryotic Eukaryotes 1000 0.65 Binding ≤ 10μM
Q2PCB5-1-E Carbonic Anhydrase (cluster #1 Of 2), Eukaryotic Eukaryotes 5720 0.56 Binding ≤ 10μM
CAH1-3-E Carbonic Anhydrase I (cluster #3 Of 3), Eukaryotic Eukaryotes 250 0.71 Functional ≤ 10μM
CAH2-1-E Carbonic Anhydrase II (cluster #1 Of 2), Eukaryotic Eukaryotes 3 0.92 Functional ≤ 10μM
CAH4-1-E Carbonic Anhydrase IV (cluster #1 Of 2), Eukaryotic Eukaryotes 70 0.77 Functional ≤ 10μM
CAH9-1-E Carbonic Anhydrase IX (cluster #1 Of 2), Eukaryotic Eukaryotes 25 0.82 Functional ≤ 10μM
CAN-3-F Carbonic Anhydrase (cluster #3 Of 3), Fungal Fungi 83 0.76 Binding ≤ 10μM
Q3I4V7-2-F Carbonic Anhydrase 2 (cluster #2 Of 4), Fungal Fungi 10 0.86 Binding ≤ 10μM
Q5AJ71-3-F Carbonic Anhydrase (cluster #3 Of 4), Fungal Fungi 40 0.80 Binding ≤ 10μM
Q6FTL6-1-F Carbonic Anhydrase (cluster #1 Of 1), Fungal Fungi 11 0.86 Binding ≤ 10μM

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) -1.15 -4.36 -19.16 3 7 0 115 222.251 2
Mid Mid (pH 6-8) -1.15 -3.88 -51.46 2 7 -1 113 221.243 2

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
CAH1-1-E Carbonic Anhydrase I (cluster #1 Of 12), Eukaryotic Eukaryotes 5 0.58 Binding ≤ 10μM
CAH2-1-E Carbonic Anhydrase II (cluster #1 Of 15), Eukaryotic Eukaryotes 4 0.59 Binding ≤ 10μM
CAH4-12-E Carbonic Anhydrase IV (cluster #12 Of 16), Eukaryotic Eukaryotes 3 0.60 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.85 -2.54 -45.33 2 8 -1 134 333.396 4
Mid Mid (pH 6-8) 0.85 -2.05 -103.39 1 8 -2 132 332.388 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
CAH1-1-E Carbonic Anhydrase I (cluster #1 Of 12), Eukaryotic Eukaryotes 7 0.57 Binding ≤ 10μM
CAH2-1-E Carbonic Anhydrase II (cluster #1 Of 15), Eukaryotic Eukaryotes 5 0.58 Binding ≤ 10μM
CAH4-12-E Carbonic Anhydrase IV (cluster #12 Of 16), Eukaryotic Eukaryotes 6 0.58 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.46 -2.53 -45.03 2 8 -1 134 333.396 5
Mid Mid (pH 6-8) 0.46 -2.05 -103.12 1 8 -2 132 332.388 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
CAH1-5-E Carbonic Anhydrase I (cluster #5 Of 12), Eukaryotic Eukaryotes 3 0.52 Binding ≤ 10μM
CAH2-6-E Carbonic Anhydrase II (cluster #6 Of 15), Eukaryotic Eukaryotes 4 0.51 Binding ≤ 10μM
CAH4-12-E Carbonic Anhydrase IV (cluster #12 Of 16), Eukaryotic Eukaryotes 12 0.48 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.13 -5.04 -56.39 3 10 -1 168 376.421 5
Ref Reference (pH 7) 0.13 -6.6 -43.19 3 10 -1 167 376.421 5
Mid Mid (pH 6-8) 0.13 -4.56 -106.45 2 10 -2 165 375.413 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
CAH1-1-E Carbonic Anhydrase I (cluster #1 Of 12), Eukaryotic Eukaryotes 900 0.35 Binding ≤ 10μM
CAH2-1-E Carbonic Anhydrase II (cluster #1 Of 15), Eukaryotic Eukaryotes 10 0.47 Binding ≤ 10μM
CAH4-12-E Carbonic Anhydrase IV (cluster #12 Of 16), Eukaryotic Eukaryotes 51 0.43 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.16 -1.85 -19.8 3 10 0 143 374.4 6
Mid Mid (pH 6-8) 0.16 -1.36 -49.61 2 10 -1 140 373.392 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
CAH1-1-E Carbonic Anhydrase I (cluster #1 Of 12), Eukaryotic Eukaryotes 2000 0.44 Binding ≤ 10μM
CAH2-1-E Carbonic Anhydrase II (cluster #1 Of 15), Eukaryotic Eukaryotes 24 0.59 Binding ≤ 10μM
CAH4-12-E Carbonic Anhydrase IV (cluster #12 Of 16), Eukaryotic Eukaryotes 32 0.58 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.41 -4.28 -33.18 1 8 -1 122 325.295 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
CAH1-1-E Carbonic Anhydrase I (cluster #1 Of 12), Eukaryotic Eukaryotes 2000 0.44 Binding ≤ 10μM
CAH2-1-E Carbonic Anhydrase II (cluster #1 Of 15), Eukaryotic Eukaryotes 24 0.59 Binding ≤ 10μM
CAH4-12-E Carbonic Anhydrase IV (cluster #12 Of 16), Eukaryotic Eukaryotes 32 0.58 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.41 -4.15 -29.45 1 8 -1 122 325.295 3
Lo Low (pH 4.5-6) -1.25 -4.34 -67.55 3 8 1 122 327.311 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
CAH2-1-E Carbonic Anhydrase II (cluster #1 Of 15), Eukaryotic Eukaryotes 100 0.58 Binding ≤ 10μM
CAH4-12-E Carbonic Anhydrase IV (cluster #12 Of 16), Eukaryotic Eukaryotes 600 0.51 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.42 -5.87 -31.93 2 8 -1 134 311.268 4
Mid Mid (pH 6-8) 2.42 -5.38 -83.99 1 8 -2 132 310.26 4

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
CAH-1-A Carbonic Anhydrase (cluster #1 Of 2), Archaea Archaea 740 0.54 Binding ≤ 10μM
Q50565-1-A Carbonic Anhydrase (cluster #1 Of 1), Archaea Archaea 5350 0.46 Binding ≤ 10μM
CYNT-2-B Carbonic Anhydrase (cluster #2 Of 3), Bacterial Bacteria 27 0.66 Binding ≤ 10μM
Y1284-1-B Uncharacterized Protein Rv1284/MT1322 (cluster #1 Of 2), Bacterial Bacteria 1030 0.52 Binding ≤ 10μM
B5SU02-5-E Alpha Carbonic Anhydrase (cluster #5 Of 6), Eukaryotic Eukaryotes 39 0.65 Binding ≤ 10μM
C0IX24-4-E Carbonic Anhydrase (cluster #4 Of 5), Eukaryotic Eukaryotes 105 0.61 Binding ≤ 10μM
CAH1-1-E Carbonic Anhydrase I (cluster #1 Of 12), Eukaryotic Eukaryotes 25 0.67 Binding ≤ 10μM
CAH12-8-E Carbonic Anhydrase XII (cluster #8 Of 9), Eukaryotic Eukaryotes 22 0.67 Binding ≤ 10μM
CAH13-2-E Carbonic Anhydrase XIII (cluster #2 Of 7), Eukaryotic Eukaryotes 50 0.64 Binding ≤ 10μM
CAH14-7-E Carbonic Anhydrase XIV (cluster #7 Of 8), Eukaryotic Eukaryotes 25 0.67 Binding ≤ 10μM
CAH15-6-E Carbonic Anhydrase 15 (cluster #6 Of 6), Eukaryotic Eukaryotes 58 0.63 Binding ≤ 10μM
CAH2-1-E Carbonic Anhydrase II (cluster #1 Of 15), Eukaryotic Eukaryotes 8000 0.45 Binding ≤ 10μM
CAH3-5-E Carbonic Anhydrase III (cluster #5 Of 6), Eukaryotic Eukaryotes 5000 0.46 Binding ≤ 10μM
CAH4-12-E Carbonic Anhydrase IV (cluster #12 Of 16), Eukaryotic Eukaryotes 13 0.69 Binding ≤ 10μM
CAH5A-2-E Carbonic Anhydrase VA (cluster #2 Of 10), Eukaryotic Eukaryotes 25 0.67 Binding ≤ 10μM
CAH5B-2-E Carbonic Anhydrase VB (cluster #2 Of 9), Eukaryotic Eukaryotes 2 0.76 Binding ≤ 10μM
CAH6-1-E Carbonic Anhydrase VI (cluster #1 Of 8), Eukaryotic Eukaryotes 43 0.64 Binding ≤ 10μM
CAH7-7-E Carbonic Anhydrase VII (cluster #7 Of 8), Eukaryotic Eukaryotes 1 0.79 Binding ≤ 10μM
CAH9-1-E Carbonic Anhydrase IX (cluster #1 Of 11), Eukaryotic Eukaryotes 50 0.64 Binding ≤ 10μM
CAH1-3-E Carbonic Anhydrase I (cluster #3 Of 3), Eukaryotic Eukaryotes 25 0.67 Functional ≤ 10μM
CAH2-1-E Carbonic Anhydrase II (cluster #1 Of 2), Eukaryotic Eukaryotes 8 0.71 Functional ≤ 10μM
CAH9-1-E Carbonic Anhydrase IX (cluster #1 Of 2), Eukaryotic Eukaryotes 50 0.64 Functional ≤ 10μM
CAN-3-F Carbonic Anhydrase (cluster #3 Of 3), Fungal Fungi 98 0.61 Binding ≤ 10μM
Q5AJ71-3-F Carbonic Anhydrase (cluster #3 Of 4), Fungal Fungi 8 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.76 -0.91 -11.89 2 5 0 82 258.324 3
Hi High (pH 8-9.5) 1.76 -0.43 -46.1 1 5 -1 80 257.316 3
Hi High (pH 8-9.5) 1.76 0 -24.43 2 5 0 81 258.324 3

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

And 14 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
CAH-1-A Carbonic Anhydrase (cluster #1 Of 2), Archaea Archaea 170 0.68 Binding ≤ 10μM
CYNT-2-B Carbonic Anhydrase (cluster #2 Of 3), Bacterial Bacteria 660 0.62 Binding ≤ 10μM
P96878-1-B PROBABLE TRANSMEMBRANE CARBONIC ANHYDRASE (CARBONATE DEHYDRATASE) (CARBONIC DEHYDRATASE) (cluster #1 Of 2), Bacterial Bacteria 562 0.63 Binding ≤ 10μM
Y1284-1-B Uncharacterized Protein Rv1284/MT1322 (cluster #1 Of 2), Bacterial Bacteria 781 0.61 Binding ≤ 10μM
B5SU02-5-E Alpha Carbonic Anhydrase (cluster #5 Of 6), Eukaryotic Eukaryotes 21 0.77 Binding ≤ 10μM
C0IX24-4-E Carbonic Anhydrase (cluster #4 Of 5), Eukaryotic Eukaryotes 132 0.69 Binding ≤ 10μM
CAH1-1-E Carbonic Anhydrase I (cluster #1 Of 12), Eukaryotic Eukaryotes 780 0.61 Binding ≤ 10μM
CAH12-8-E Carbonic Anhydrase XII (cluster #8 Of 9), Eukaryotic Eukaryotes 3 0.85 Binding ≤ 10μM
CAH13-2-E Carbonic Anhydrase XIII (cluster #2 Of 7), Eukaryotic Eukaryotes 19 0.77 Binding ≤ 10μM
CAH14-7-E Carbonic Anhydrase XIV (cluster #7 Of 8), Eukaryotic Eukaryotes 43 0.74 Binding ≤ 10μM
CAH15-6-E Carbonic Anhydrase 15 (cluster #6 Of 6), Eukaryotic Eukaryotes 65 0.72 Binding ≤ 10μM
CAH2-1-E Carbonic Anhydrase II (cluster #1 Of 15), Eukaryotic Eukaryotes 9 0.80 Binding ≤ 10μM
CAH3-5-E Carbonic Anhydrase III (cluster #5 Of 6), Eukaryotic Eukaryotes 1 0.90 Binding ≤ 10μM
CAH4-12-E Carbonic Anhydrase IV (cluster #12 Of 16), Eukaryotic Eukaryotes 36 0.74 Binding ≤ 10μM
CAH5A-2-E Carbonic Anhydrase VA (cluster #2 Of 10), Eukaryotic Eukaryotes 65 0.72 Binding ≤ 10μM
CAH5B-2-E Carbonic Anhydrase VB (cluster #2 Of 9), Eukaryotic Eukaryotes 62 0.72 Binding ≤ 10μM
CAH6-1-E Carbonic Anhydrase VI (cluster #1 Of 8), Eukaryotic Eukaryotes 10 0.80 Binding ≤ 10μM
CAH7-7-E Carbonic Anhydrase VII (cluster #7 Of 8), Eukaryotic Eukaryotes 2 0.87 Binding ≤ 10μM
CAH9-10-E Carbonic Anhydrase IX (cluster #10 Of 11), Eukaryotic Eukaryotes 27 0.76 Binding ≤ 10μM
CAH1-3-E Carbonic Anhydrase I (cluster #3 Of 3), Eukaryotic Eukaryotes 50 0.73 Functional ≤ 10μM
CAH2-1-E Carbonic Anhydrase II (cluster #1 Of 2), Eukaryotic Eukaryotes 14 0.79 Functional ≤ 10μM
CAH4-1-E Carbonic Anhydrase IV (cluster #1 Of 2), Eukaryotic Eukaryotes 36 0.74 Functional ≤ 10μM
CAN-3-F Carbonic Anhydrase (cluster #3 Of 3), Fungal Fungi 119 0.69 Binding ≤ 10μM
Q5AJ71-3-F Carbonic Anhydrase (cluster #3 Of 4), Fungal Fungi 484 0.63 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.15 -5.18 -53.63 3 7 0 109 237.286 1
Ref Reference (pH 7) -0.15 -4.78 -45.79 3 7 0 109 237.286 1
Hi High (pH 8-9.5) -0.15 -3.64 -23.75 2 7 0 106 236.278 1

Analogs

32150186
32150186
4217364
4217364

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-10-E Carbonic Anhydrase I (cluster #10 Of 12), Eukaryotic Eukaryotes 645 0.54 Binding ≤ 10μM
CAH2-11-E Carbonic Anhydrase II (cluster #11 Of 15), Eukaryotic Eukaryotes 9 0.70 Binding ≤ 10μM
CAH4-12-E Carbonic Anhydrase IV (cluster #12 Of 16), Eukaryotic Eukaryotes 46 0.64 Binding ≤ 10μM
CAH5A-2-E Carbonic Anhydrase VA (cluster #2 Of 10), Eukaryotic Eukaryotes 54 0.64 Binding ≤ 10μM
CAH5B-2-E Carbonic Anhydrase VB (cluster #2 Of 9), Eukaryotic Eukaryotes 54 0.64 Binding ≤ 10μM

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 0.52 -2.34 -17.39 3 7 0 115 264.332 3
Mid Mid (pH 6-8) 0.52 -1.85 -49.6 2 7 -1 113 263.324 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
CAH1-1-E Carbonic Anhydrase I (cluster #1 Of 12), Eukaryotic Eukaryotes 850 0.45 Binding ≤ 10μM
CAH2-1-E Carbonic Anhydrase II (cluster #1 Of 15), Eukaryotic Eukaryotes 17 0.57 Binding ≤ 10μM
CAH4-12-E Carbonic Anhydrase IV (cluster #12 Of 16), Eukaryotic Eukaryotes 174 0.50 Binding ≤ 10μM
CAH5A-2-E Carbonic Anhydrase VA (cluster #2 Of 10), Eukaryotic Eukaryotes 83 0.52 Binding ≤ 10μM
CAH5B-2-E Carbonic Anhydrase VB (cluster #2 Of 9), Eukaryotic Eukaryotes 83 0.52 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.52 -1.07 -13.76 2 7 0 107 298.349 2
Mid Mid (pH 6-8) 1.52 -0.96 -21.71 2 7 0 106 298.349 2
Mid Mid (pH 6-8) 1.52 -0.42 -24.61 2 7 0 106 298.349 2

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
CAH1-1-E Carbonic Anhydrase I (cluster #1 Of 12), Eukaryotic Eukaryotes 900 0.47 Binding ≤ 10μM
CAH2-1-E Carbonic Anhydrase II (cluster #1 Of 15), Eukaryotic Eukaryotes 2 0.68 Binding ≤ 10μM
CAH4-12-E Carbonic Anhydrase IV (cluster #12 Of 16), Eukaryotic Eukaryotes 21 0.60 Binding ≤ 10μM
CAH5A-2-E Carbonic Anhydrase VA (cluster #2 Of 10), Eukaryotic Eukaryotes 76 0.55 Binding ≤ 10μM
CAH5B-2-E Carbonic Anhydrase VB (cluster #2 Of 9), Eukaryotic Eukaryotes 76 0.55 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.53 -1.01 -17.47 3 7 0 115 284.322 3
Mid Mid (pH 6-8) 0.53 -0.52 -49.88 2 7 -1 113 283.314 3

Analogs

4217364
4217364
32150186
32150186

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-10-E Carbonic Anhydrase I (cluster #10 Of 12), Eukaryotic Eukaryotes 50 0.54 Binding ≤ 10μM
CAH2-11-E Carbonic Anhydrase II (cluster #11 Of 15), Eukaryotic Eukaryotes 6 0.61 Binding ≤ 10μM
CAH4-12-E Carbonic Anhydrase IV (cluster #12 Of 16), Eukaryotic Eukaryotes 25 0.56 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.06 0.02 -16.76 3 7 0 115 306.413 7
Mid Mid (pH 6-8) 2.06 0.51 -49.38 2 7 -1 113 305.405 7

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
CAH1-10-E Carbonic Anhydrase I (cluster #10 Of 12), Eukaryotic Eukaryotes 460 0.52 Binding ≤ 10μM
CAH2-11-E Carbonic Anhydrase II (cluster #11 Of 15), Eukaryotic Eukaryotes 9 0.66 Binding ≤ 10μM
CAH4-12-E Carbonic Anhydrase IV (cluster #12 Of 16), Eukaryotic Eukaryotes 130 0.57 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.53 -2.97 -14.19 3 8 0 124 280.331 4

Parameters Provided:

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

Permalink

Embed Link to Results