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

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

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

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

Parameters Provided:

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

Permalink

Embed Link to Results