UCSF
ZINC Item Suppliers, Protomers, & Similar Substances

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

And 75 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
TYSY-3-E Thymidylate Synthase (cluster #3 Of 3), Eukaryotic Eukaryotes 7000 0.80 Binding ≤ 10μM
Z103205-4-O A431 (cluster #4 Of 4), Other Other 18 1.20 Functional ≤ 10μM
Z103419-1-O UACC-812 (cluster #1 Of 2), Other Other 3100 0.86 Functional ≤ 10μM
Z50425-14-O Plasmodium Falciparum (cluster #14 Of 22), Other Other 7943 0.79 Functional ≤ 10μM
Z80035-6-O B16 (Melanoma Cells) (cluster #6 Of 7), Other Other 8730 0.79 Functional ≤ 10μM
Z80054-2-O Caco-2 (Colon Adenocarcinoma Cells) (cluster #2 Of 4), Other Other 1500 0.91 Functional ≤ 10μM
Z80064-6-O CCRF-CEM (T-cell Leukemia) (cluster #6 Of 9), Other Other 5000 0.82 Functional ≤ 10μM
Z80088-4-O CHO (Ovarian Cells) (cluster #4 Of 4), Other Other 5000 0.82 Functional ≤ 10μM
Z80101-1-O COLO 320DM (Colon Adenocarcinoma Cells) (cluster #1 Of 2), Other Other 1100 0.93 Functional ≤ 10μM
Z80120-3-O DLD-1 (Colon Adenocarcinoma Cells) (cluster #3 Of 5), Other Other 6000 0.81 Functional ≤ 10μM
Z80125-6-O DU-145 (Prostate Carcinoma) (cluster #6 Of 9), Other Other 4800 0.83 Functional ≤ 10μM
Z80136-3-O FM3A (Breast Carcinoma Cells) (cluster #3 Of 6), Other Other 180 1.05 Functional ≤ 10μM
Z80156-6-O HL-60 (Promyeloblast Leukemia Cells) (cluster #6 Of 12), Other Other 9500 0.78 Functional ≤ 10μM
Z80164-4-O HT-1080 (Fibrosarcoma Cells) (cluster #4 Of 6), Other Other 9450 0.78 Functional ≤ 10μM
Z80166-8-O HT-29 (Colon Adenocarcinoma Cells) (cluster #8 Of 12), Other Other 7300 0.80 Functional ≤ 10μM
Z80186-7-O K562 (Erythroleukemia Cells) (cluster #7 Of 11), Other Other 2400 0.87 Functional ≤ 10μM
Z80192-2-O KM12 (Colon Adenocarcinoma Cells) (cluster #2 Of 4), Other Other 8320 0.79 Functional ≤ 10μM
Z80193-8-O L1210 (Lymphocytic Leukemia Cells) (cluster #8 Of 12), Other Other 970 0.94 Functional ≤ 10μM
Z80224-5-O MCF7 (Breast Carcinoma Cells) (cluster #5 Of 14), Other Other 9600 0.78 Functional ≤ 10μM
Z80268-1-O MKN-28 (Gastric Epithelial Carcinoma Cells) (cluster #1 Of 2), Other Other 2500 0.87 Functional ≤ 10μM
Z80269-3-O MKN-45 (Gastric Adenocarcinoma Cells) (cluster #3 Of 3), Other Other 3000 0.86 Functional ≤ 10μM
Z80347-2-O NUGC-3 (Gastric Carcinoma Cells) (cluster #2 Of 2), Other Other 4400 0.83 Functional ≤ 10μM
Z80362-5-O P388 (Lymphoma Cells) (cluster #5 Of 8), Other Other 609 0.97 Functional ≤ 10μM
Z80390-6-O PC-3 (Prostate Carcinoma Cells) (cluster #6 Of 10), Other Other 16 1.21 Functional ≤ 10μM
Z80485-4-O SK-MEL-28 (Melanoma Cells) (cluster #4 Of 6), Other Other 4500 0.83 Functional ≤ 10μM
Z80490-4-O SK-MES-1 (cluster #4 Of 4), Other Other 310 1.01 Functional ≤ 10μM
Z80525-2-O SW48 (cluster #2 Of 2), Other Other 5700 0.82 Functional ≤ 10μM
Z80526-3-O SW480 (Colon Adenocarcinoma Cells) (cluster #3 Of 6), Other Other 8100 0.79 Functional ≤ 10μM
Z80532-5-O T-24 (Bladder Carcinoma Cells) (cluster #5 Of 6), Other Other 4100 0.84 Functional ≤ 10μM
Z80583-6-O Vero (Kidney Cells) (cluster #6 Of 7), Other Other 6810 0.80 Functional ≤ 10μM
Z80641-1-O 791T Cell Line (cluster #1 Of 1), Other Other 5500 0.82 Functional ≤ 10μM
Z80653-2-O 9L (Glioma Cells) (cluster #2 Of 2), Other Other 1000 0.93 Functional ≤ 10μM
Z80682-9-O A549 (Lung Carcinoma Cells) (cluster #9 Of 11), Other Other 9200 0.78 Functional ≤ 10μM
Z80686-1-O AZ-521 Cell Line (cluster #1 Of 1), Other Other 3900 0.84 Functional ≤ 10μM
Z80712-5-O T47D (Breast Carcinoma Cells) (cluster #5 Of 7), Other Other 600 0.97 Functional ≤ 10μM
Z80724-1-O C170 Cell Line (cluster #1 Of 1), Other Other 2000 0.89 Functional ≤ 10μM
Z80742-2-O C6 (Glioma Cells) (cluster #2 Of 3), Other Other 6100 0.81 Functional ≤ 10μM
Z80874-5-O CEM (T-cell Leukemia) (cluster #5 Of 7), Other Other 9230 0.78 Functional ≤ 10μM
Z80928-7-O HCT-116 (Colon Carcinoma Cells) (cluster #7 Of 9), Other Other 8510 0.79 Functional ≤ 10μM
Z81020-1-O HepG2 (Hepatoblastoma Cells) (cluster #1 Of 8), Other Other 9200 0.78 Functional ≤ 10μM
Z81024-6-O NCI-H460 (Non-small Cell Lung Carcinoma) (cluster #6 Of 8), Other Other 8500 0.79 Functional ≤ 10μM
Z81034-5-O A2780 (Ovarian Carcinoma Cells) (cluster #5 Of 10), Other Other 7210 0.80 Functional ≤ 10μM
Z81041-1-O Prostatic Carcinoma Cells (cluster #1 Of 2), Other Other 6400 0.81 Functional ≤ 10μM
Z81043-2-O N592 (cluster #2 Of 2), Other Other 5400 0.82 Functional ≤ 10μM
Z81048-1-O TSU (Prostatic Carcinoma Cells) (cluster #1 Of 2), Other Other 3600 0.85 Functional ≤ 10μM
Z81115-6-O KB (Squamous Cell Carcinoma) (cluster #6 Of 6), Other Other 4460 0.83 Functional ≤ 10μM
Z81121-1-O KKLS Cell Line (cluster #1 Of 1), Other Other 6200 0.81 Functional ≤ 10μM
Z81170-4-O LNCaP (Prostate Carcinoma) (cluster #4 Of 5), Other Other 4900 0.83 Functional ≤ 10μM
Z81247-7-O HeLa (Cervical Adenocarcinoma Cells) (cluster #7 Of 9), Other Other 9700 0.78 Functional ≤ 10μM
Z81252-9-O MDA-MB-231 (Breast Adenocarcinoma Cells) (cluster #9 Of 11), Other Other 9600 0.78 Functional ≤ 10μM
Z81330-1-O SNU- (cluster #1 Of 1), Other Other 2700 0.87 Functional ≤ 10μM
Z81331-3-O SW-620 (Colon Adenocarcinoma Cells) (cluster #3 Of 6), Other Other 9000 0.78 Functional ≤ 10μM
Z81335-3-O HCT-15 (Colon Adenocarcinoma Cells) (cluster #3 Of 5), Other Other 9710 0.78 Functional ≤ 10μM
Z80156-3-O HL-60 (Promyeloblast Leukemia Cells) (cluster #3 Of 4), Other Other 160 1.06 ADME/T ≤ 10μM
Z80192-2-O KM12 (Colon Adenocarcinoma Cells) (cluster #2 Of 2), Other Other 7940 0.79 ADME/T ≤ 10μM
Z80193-4-O L1210 (Lymphocytic Leukemia Cells) (cluster #4 Of 4), Other Other 560 0.97 ADME/T ≤ 10μM
Z80583-3-O Vero (Kidney Cells) (cluster #3 Of 3), Other Other 200 1.04 ADME/T ≤ 10μM
Z80901-2-O HaCaT (Keratinocytes) (cluster #2 Of 2), Other Other 400 1.00 ADME/T ≤ 10μM
Z80928-2-O HCT-116 (Colon Carcinoma Cells) (cluster #2 Of 2), Other Other 2040 0.89 ADME/T ≤ 10μM
Z81247-2-O HeLa (Cervical Adenocarcinoma Cells) (cluster #2 Of 3), Other Other 570 0.97 ADME/T ≤ 10μM
Z81335-2-O HCT-15 (Colon Adenocarcinoma Cells) (cluster #2 Of 2), Other Other 6610 0.81 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) -0.59 -1.23 -13.33 2 4 0 66 130.078 0
Hi High (pH 8-9.5) -0.13 -4 -48.58 1 4 -1 69 129.07 0
Mid Mid (pH 6-8) -0.13 -3.14 -32.57 1 4 -1 69 129.07 0

Analogs

388678
388678
489135
489135
3813010
3813010
3830846
3830846
3977743
3977743

Draw Identity 99% 90% 80% 70%

Vendors

And 9 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
TYSY-1-E Thymidylate Synthase (cluster #1 Of 3), Eukaryotic Eukaryotes 7300 0.42 Binding ≤ 10μM
Z80064-6-O CCRF-CEM (T-cell Leukemia) (cluster #6 Of 9), Other Other 500 0.52 Functional ≤ 10μM
Z80101-2-O COLO 320DM (Colon Adenocarcinoma Cells) (cluster #2 Of 2), Other Other 650 0.51 Functional ≤ 10μM
Z80120-3-O DLD-1 (Colon Adenocarcinoma Cells) (cluster #3 Of 5), Other Other 92 0.58 Functional ≤ 10μM
Z80164-4-O HT-1080 (Fibrosarcoma Cells) (cluster #4 Of 6), Other Other 120 0.57 Functional ≤ 10μM
Z80193-2-O L1210 (Lymphocytic Leukemia Cells) (cluster #2 Of 12), Other Other 45 0.61 Functional ≤ 10μM
Z80208-1-O L5178Y (Lymphoma Cells) (cluster #1 Of 2), Other Other 2 0.72 Functional ≤ 10μM
Z80268-2-O MKN-28 (Gastric Epithelial Carcinoma Cells) (cluster #2 Of 2), Other Other 120 0.57 Functional ≤ 10μM
Z80269-3-O MKN-45 (Gastric Adenocarcinoma Cells) (cluster #3 Of 3), Other Other 3500 0.45 Functional ≤ 10μM
Z80347-2-O NUGC-3 (Gastric Carcinoma Cells) (cluster #2 Of 2), Other Other 15 0.64 Functional ≤ 10μM
Z80525-2-O SW48 (cluster #2 Of 2), Other Other 130 0.57 Functional ≤ 10μM
Z80532-1-O T-24 (Bladder Carcinoma Cells) (cluster #1 Of 6), Other Other 120 0.57 Functional ≤ 10μM
Z80682-9-O A549 (Lung Carcinoma Cells) (cluster #9 Of 11), Other Other 1000 0.49 Functional ≤ 10μM
Z80686-1-O AZ-521 Cell Line (cluster #1 Of 1), Other Other 50 0.60 Functional ≤ 10μM
Z81048-1-O TSU (Prostatic Carcinoma Cells) (cluster #1 Of 2), Other Other 58 0.60 Functional ≤ 10μM
Z81121-1-O KKLS Cell Line (cluster #1 Of 1), Other Other 760 0.50 Functional ≤ 10μM
Z81137-1-O L929 (Fibroblast Cells) (cluster #1 Of 2), Other Other 7700 0.42 Functional ≤ 10μM
Z81170-4-O LNCaP (Prostate Carcinoma) (cluster #4 Of 5), Other Other 69 0.59 Functional ≤ 10μM
Z81330-1-O SNU- (cluster #1 Of 1), Other Other 3 0.70 Functional ≤ 10μM
Z81335-3-O HCT-15 (Colon Adenocarcinoma Cells) (cluster #3 Of 5), Other Other 49 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) -1.72 -5.12 -11.33 3 7 0 105 246.194 2
Hi High (pH 8-9.5) -1.26 -7.87 -48.56 2 7 -1 108 245.186 2

Analogs

3977743
3977743
3977744
3977744
4045293
4045293
1457
1457

Draw Identity 99% 90% 80% 70%

Vendors

And 9 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
TYSY-1-E Thymidylate Synthase (cluster #1 Of 3), Eukaryotic Eukaryotes 7300 0.42 Binding ≤ 10μM
Z80064-6-O CCRF-CEM (T-cell Leukemia) (cluster #6 Of 9), Other Other 500 0.52 Functional ≤ 10μM
Z80101-2-O COLO 320DM (Colon Adenocarcinoma Cells) (cluster #2 Of 2), Other Other 650 0.51 Functional ≤ 10μM
Z80120-3-O DLD-1 (Colon Adenocarcinoma Cells) (cluster #3 Of 5), Other Other 92 0.58 Functional ≤ 10μM
Z80164-4-O HT-1080 (Fibrosarcoma Cells) (cluster #4 Of 6), Other Other 120 0.57 Functional ≤ 10μM
Z80193-2-O L1210 (Lymphocytic Leukemia Cells) (cluster #2 Of 12), Other Other 45 0.61 Functional ≤ 10μM
Z80208-1-O L5178Y (Lymphoma Cells) (cluster #1 Of 2), Other Other 2 0.72 Functional ≤ 10μM
Z80268-2-O MKN-28 (Gastric Epithelial Carcinoma Cells) (cluster #2 Of 2), Other Other 120 0.57 Functional ≤ 10μM
Z80269-3-O MKN-45 (Gastric Adenocarcinoma Cells) (cluster #3 Of 3), Other Other 3500 0.45 Functional ≤ 10μM
Z80347-2-O NUGC-3 (Gastric Carcinoma Cells) (cluster #2 Of 2), Other Other 15 0.64 Functional ≤ 10μM
Z80525-2-O SW48 (cluster #2 Of 2), Other Other 130 0.57 Functional ≤ 10μM
Z80532-1-O T-24 (Bladder Carcinoma Cells) (cluster #1 Of 6), Other Other 120 0.57 Functional ≤ 10μM
Z80682-9-O A549 (Lung Carcinoma Cells) (cluster #9 Of 11), Other Other 1000 0.49 Functional ≤ 10μM
Z80686-1-O AZ-521 Cell Line (cluster #1 Of 1), Other Other 50 0.60 Functional ≤ 10μM
Z81048-1-O TSU (Prostatic Carcinoma Cells) (cluster #1 Of 2), Other Other 58 0.60 Functional ≤ 10μM
Z81121-1-O KKLS Cell Line (cluster #1 Of 1), Other Other 760 0.50 Functional ≤ 10μM
Z81137-1-O L929 (Fibroblast Cells) (cluster #1 Of 2), Other Other 7700 0.42 Functional ≤ 10μM
Z81170-4-O LNCaP (Prostate Carcinoma) (cluster #4 Of 5), Other Other 69 0.59 Functional ≤ 10μM
Z81330-1-O SNU- (cluster #1 Of 1), Other Other 3 0.70 Functional ≤ 10μM
Z81335-3-O HCT-15 (Colon Adenocarcinoma Cells) (cluster #3 Of 5), Other Other 49 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) -1.72 -4.03 -17.41 3 7 0 105 246.194 2
Hi High (pH 8-9.5) -1.26 -6.78 -57.51 2 7 -1 108 245.186 2

Analogs

3977743
3977743
3977744
3977744
4045293
4045293
1457
1457

Draw Identity 99% 90% 80% 70%

Vendors

And 10 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
TYSY-1-E Thymidylate Synthase (cluster #1 Of 3), Eukaryotic Eukaryotes 7300 0.42 Binding ≤ 10μM
Z80064-6-O CCRF-CEM (T-cell Leukemia) (cluster #6 Of 9), Other Other 500 0.52 Functional ≤ 10μM
Z80101-2-O COLO 320DM (Colon Adenocarcinoma Cells) (cluster #2 Of 2), Other Other 650 0.51 Functional ≤ 10μM
Z80120-3-O DLD-1 (Colon Adenocarcinoma Cells) (cluster #3 Of 5), Other Other 92 0.58 Functional ≤ 10μM
Z80164-4-O HT-1080 (Fibrosarcoma Cells) (cluster #4 Of 6), Other Other 120 0.57 Functional ≤ 10μM
Z80193-2-O L1210 (Lymphocytic Leukemia Cells) (cluster #2 Of 12), Other Other 45 0.61 Functional ≤ 10μM
Z80208-1-O L5178Y (Lymphoma Cells) (cluster #1 Of 2), Other Other 2 0.72 Functional ≤ 10μM
Z80268-2-O MKN-28 (Gastric Epithelial Carcinoma Cells) (cluster #2 Of 2), Other Other 120 0.57 Functional ≤ 10μM
Z80269-3-O MKN-45 (Gastric Adenocarcinoma Cells) (cluster #3 Of 3), Other Other 3500 0.45 Functional ≤ 10μM
Z80347-2-O NUGC-3 (Gastric Carcinoma Cells) (cluster #2 Of 2), Other Other 15 0.64 Functional ≤ 10μM
Z80525-2-O SW48 (cluster #2 Of 2), Other Other 130 0.57 Functional ≤ 10μM
Z80532-1-O T-24 (Bladder Carcinoma Cells) (cluster #1 Of 6), Other Other 120 0.57 Functional ≤ 10μM
Z80682-9-O A549 (Lung Carcinoma Cells) (cluster #9 Of 11), Other Other 1000 0.49 Functional ≤ 10μM
Z80686-1-O AZ-521 Cell Line (cluster #1 Of 1), Other Other 50 0.60 Functional ≤ 10μM
Z81048-1-O TSU (Prostatic Carcinoma Cells) (cluster #1 Of 2), Other Other 58 0.60 Functional ≤ 10μM
Z81121-1-O KKLS Cell Line (cluster #1 Of 1), Other Other 760 0.50 Functional ≤ 10μM
Z81137-1-O L929 (Fibroblast Cells) (cluster #1 Of 2), Other Other 7700 0.42 Functional ≤ 10μM
Z81170-4-O LNCaP (Prostate Carcinoma) (cluster #4 Of 5), Other Other 69 0.59 Functional ≤ 10μM
Z81330-1-O SNU- (cluster #1 Of 1), Other Other 3 0.70 Functional ≤ 10μM
Z81335-3-O HCT-15 (Colon Adenocarcinoma Cells) (cluster #3 Of 5), Other Other 49 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) -1.72 -4.23 -22.26 3 7 0 105 246.194 2
Hi High (pH 8-9.5) -1.26 -6.98 -63.95 2 7 -1 108 245.186 2

Analogs

3977743
3977743
3977744
3977744
4045293
4045293
1457
1457

Draw Identity 99% 90% 80% 70%

Vendors

And 9 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
TYSY-1-E Thymidylate Synthase (cluster #1 Of 3), Eukaryotic Eukaryotes 7300 0.42 Binding ≤ 10μM
Z80064-6-O CCRF-CEM (T-cell Leukemia) (cluster #6 Of 9), Other Other 500 0.52 Functional ≤ 10μM
Z80101-2-O COLO 320DM (Colon Adenocarcinoma Cells) (cluster #2 Of 2), Other Other 650 0.51 Functional ≤ 10μM
Z80120-3-O DLD-1 (Colon Adenocarcinoma Cells) (cluster #3 Of 5), Other Other 92 0.58 Functional ≤ 10μM
Z80164-4-O HT-1080 (Fibrosarcoma Cells) (cluster #4 Of 6), Other Other 120 0.57 Functional ≤ 10μM
Z80193-2-O L1210 (Lymphocytic Leukemia Cells) (cluster #2 Of 12), Other Other 45 0.61 Functional ≤ 10μM
Z80208-1-O L5178Y (Lymphoma Cells) (cluster #1 Of 2), Other Other 2 0.72 Functional ≤ 10μM
Z80268-2-O MKN-28 (Gastric Epithelial Carcinoma Cells) (cluster #2 Of 2), Other Other 120 0.57 Functional ≤ 10μM
Z80269-3-O MKN-45 (Gastric Adenocarcinoma Cells) (cluster #3 Of 3), Other Other 3500 0.45 Functional ≤ 10μM
Z80347-2-O NUGC-3 (Gastric Carcinoma Cells) (cluster #2 Of 2), Other Other 15 0.64 Functional ≤ 10μM
Z80525-2-O SW48 (cluster #2 Of 2), Other Other 130 0.57 Functional ≤ 10μM
Z80532-1-O T-24 (Bladder Carcinoma Cells) (cluster #1 Of 6), Other Other 120 0.57 Functional ≤ 10μM
Z80682-9-O A549 (Lung Carcinoma Cells) (cluster #9 Of 11), Other Other 1000 0.49 Functional ≤ 10μM
Z80686-1-O AZ-521 Cell Line (cluster #1 Of 1), Other Other 50 0.60 Functional ≤ 10μM
Z81048-1-O TSU (Prostatic Carcinoma Cells) (cluster #1 Of 2), Other Other 58 0.60 Functional ≤ 10μM
Z81121-1-O KKLS Cell Line (cluster #1 Of 1), Other Other 760 0.50 Functional ≤ 10μM
Z81137-1-O L929 (Fibroblast Cells) (cluster #1 Of 2), Other Other 7700 0.42 Functional ≤ 10μM
Z81170-4-O LNCaP (Prostate Carcinoma) (cluster #4 Of 5), Other Other 69 0.59 Functional ≤ 10μM
Z81330-1-O SNU- (cluster #1 Of 1), Other Other 3 0.70 Functional ≤ 10μM
Z81335-3-O HCT-15 (Colon Adenocarcinoma Cells) (cluster #3 Of 5), Other Other 49 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) -1.72 -4.89 -10.74 3 7 0 105 246.194 2
Hi High (pH 8-9.5) -1.26 -7.64 -47.75 2 7 -1 108 245.186 2

Parameters Provided:

target.name = Z81048-1-O
target.type = F10
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 'Z81048-1-O' AND t.atype_fk = 5 AND c.purchasable IN (1,2,4,5)    LIMIT 50

Permalink

Embed Link to Results