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

5670074
5670074
5670075
5670075
5854749
5854749
13783532
13783532
689799
689799

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
Z50602-2-O Human Herpesvirus 1 (cluster #2 Of 5), Other Other 100 0.34 Functional ≤ 10μM
Z50651-2-O Vesicular Stomatitis Virus (cluster #2 Of 2), Other Other 250 0.32 Functional ≤ 10μM
Z80866-1-O GLC4 Cell Line (cluster #1 Of 1), Other Other 3100 0.27 Functional ≤ 10μM
Z81115-1-O KB (Squamous Cell Carcinoma) (cluster #1 Of 6), Other Other 64 0.35 Functional ≤ 10μM
Z81247-2-O HeLa (Cervical Adenocarcinoma Cells) (cluster #2 Of 9), Other Other 80 0.34 Functional ≤ 10μM
Z80390-1-O PC-3 (Prostate Carcinoma Cells) (cluster #1 Of 2), Other Other 82 0.34 ADME/T ≤ 10μM
Z81170-1-O LNCaP (Prostate Carcinoma) (cluster #1 Of 1), Other Other 56 0.35 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) 1.04 2.84 -16.7 2 8 0 104 400.383 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
Z50602-2-O Human Herpesvirus 1 (cluster #2 Of 5), Other Other 250 0.32 Functional ≤ 10μM
Z50651-2-O Vesicular Stomatitis Virus (cluster #2 Of 2), Other Other 250 0.32 Functional ≤ 10μM
Z80166-1-O HT-29 (Colon Adenocarcinoma Cells) (cluster #1 Of 12), Other Other 25 0.37 Functional ≤ 10μM
Z80362-1-O P388 (Lymphoma Cells) (cluster #1 Of 8), Other Other 13 0.38 Functional ≤ 10μM
Z80682-1-O A549 (Lung Carcinoma Cells) (cluster #1 Of 11), Other Other 25 0.37 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.24 8.2 -17.24 0 7 0 72 396.395 4

Analogs

642141
642141
2231796
2231796
8926010
8926010

Draw Identity 99% 90% 80% 70%

Vendors

And 21 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
Z50651-2-O Vesicular Stomatitis Virus (cluster #2 Of 2), Other Other 1445 0.27 Functional ≤ 10μM

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 4.85 13.74 -82.89 2 5 2 44 412.574 12
Hi High (pH 8-9.5) 4.85 11.19 -44.95 1 5 1 43 411.566 12
Hi High (pH 8-9.5) 4.85 9.05 -12.76 0 5 0 42 410.558 12

Analogs

4098919
4098919
4098920
4098920
4475321
4475321
11682059
11682059
16969582
16969582

Draw Identity 99% 90% 80% 70%

Vendors

And 52 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
GCR-1-E Glucocorticoid Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 14 0.37 Binding ≤ 10μM
O46399-1-E Beta Tubulin (cluster #1 Of 1), Eukaryotic Eukaryotes 3000 0.26 Binding ≤ 10μM
Q862F3-2-E Tubulin Alpha Chain (cluster #2 Of 2), Eukaryotic Eukaryotes 2500 0.26 Binding ≤ 10μM
Q862L2-2-E Tubulin Alpha-1 Chain (cluster #2 Of 2), Eukaryotic Eukaryotes 2500 0.26 Binding ≤ 10μM
Q9MZB0-1-E Tubulin Alpha-1 Chain (cluster #1 Of 1), Eukaryotic Eukaryotes 3000 0.26 Binding ≤ 10μM
TBA1A-1-E Tubulin Alpha-3 Chain (cluster #1 Of 3), Eukaryotic Eukaryotes 2180 0.26 Binding ≤ 10μM
TBA4A-1-E Tubulin Alpha-1 Chain (cluster #1 Of 1), Eukaryotic Eukaryotes 1700 0.27 Binding ≤ 10μM
TBB-1-E Tubulin Beta Chain (cluster #1 Of 1), Eukaryotic Eukaryotes 1560 0.27 Binding ≤ 10μM
TBB1-1-E Tubulin Beta-1 Chain (cluster #1 Of 2), Eukaryotic Eukaryotes 460 0.30 Binding ≤ 10μM
TBB2B-1-E Tubulin Beta Chain (cluster #1 Of 1), Eukaryotic Eukaryotes 2500 0.26 Binding ≤ 10μM
TBB3-1-E Tubulin Beta-3 Chain (cluster #1 Of 1), Eukaryotic Eukaryotes 2180 0.26 Binding ≤ 10μM
TBB4A-1-E Tubulin Beta-4 Chain (cluster #1 Of 1), Eukaryotic Eukaryotes 4000 0.25 Binding ≤ 10μM
TBB4B-1-E Tubulin Beta-2 Chain (cluster #1 Of 1), Eukaryotic Eukaryotes 4000 0.25 Binding ≤ 10μM
TBB5-1-E Tubulin Beta-5 Chain (cluster #1 Of 1), Eukaryotic Eukaryotes 4000 0.25 Binding ≤ 10μM
TBB8-1-E Tubulin Beta-8 Chain (cluster #1 Of 1), Eukaryotic Eukaryotes 4000 0.25 Binding ≤ 10μM
TBG1-1-E Tubulin Gamma-1 Chain (cluster #1 Of 1), Eukaryotic Eukaryotes 2180 0.26 Binding ≤ 10μM
Q862F3-1-E Tubulin Alpha Chain (cluster #1 Of 2), Eukaryotic Eukaryotes 590 0.29 Functional ≤ 10μM
Q862L2-1-E Tubulin Alpha-1 Chain (cluster #1 Of 2), Eukaryotic Eukaryotes 590 0.29 Functional ≤ 10μM
TBA1A-1-E Tubulin Alpha-1 Chain (cluster #1 Of 2), Eukaryotic Eukaryotes 460 0.30 Functional ≤ 10μM
TBB1-1-E Tubulin Beta-1 Chain (cluster #1 Of 2), Eukaryotic Eukaryotes 460 0.30 Functional ≤ 10μM
TBB2B-1-E Tubulin Beta Chain (cluster #1 Of 2), Eukaryotic Eukaryotes 590 0.29 Functional ≤ 10μM
Z100695-1-O WRL68 (Embryonic Hepatoma Cells) (cluster #1 Of 1), Other Other 4800 0.25 Functional ≤ 10μM
Z101973-1-O Paracentrotus Lividus (cluster #1 Of 1), Other Other 500 0.29 Functional ≤ 10μM
Z50425-1-O Plasmodium Falciparum (cluster #1 Of 22), Other Other 10000 0.23 Functional ≤ 10μM
Z50426-3-O Plasmodium Falciparum (isolate K1 / Thailand) (cluster #3 Of 9), Other Other 12 0.37 Functional ≤ 10μM
Z50602-2-O Human Herpesvirus 1 (cluster #2 Of 5), Other Other 50 0.34 Functional ≤ 10μM
Z50607-1-O Human Immunodeficiency Virus 1 (cluster #1 Of 10), Other Other 3 0.40 Functional ≤ 10μM
Z50651-2-O Vesicular Stomatitis Virus (cluster #2 Of 2), Other Other 100 0.33 Functional ≤ 10μM
Z80002-1-O 1A9 (Ovarian Adenocarcinoma Cells) (cluster #1 Of 2), Other Other 3 0.40 Functional ≤ 10μM
Z80054-1-O Caco-2 (Colon Adenocarcinoma Cells) (cluster #1 Of 4), Other Other 500 0.29 Functional ≤ 10μM
Z80110-1-O CV-1 (Kidney Cells) (cluster #1 Of 2), Other Other 29 0.35 Functional ≤ 10μM
Z80121-1-O DMS-79 (Small Cell Lung Carcinoma Cells) (cluster #1 Of 1), Other Other 23 0.36 Functional ≤ 10μM
Z80125-1-O DU-145 (Prostate Carcinoma) (cluster #1 Of 9), Other Other 52 0.34 Functional ≤ 10μM
Z80156-1-O HL-60 (Promyeloblast Leukemia Cells) (cluster #1 Of 12), Other Other 2750 0.26 Functional ≤ 10μM
Z80164-1-O HT-1080 (Fibrosarcoma Cells) (cluster #1 Of 6), Other Other 8100 0.24 Functional ≤ 10μM
Z80166-1-O HT-29 (Colon Adenocarcinoma Cells) (cluster #1 Of 12), Other Other 50 0.34 Functional ≤ 10μM
Z80186-6-O K562 (Erythroleukemia Cells) (cluster #6 Of 11), Other Other 30 0.35 Functional ≤ 10μM
Z80224-1-O MCF7 (Breast Carcinoma Cells) (cluster #1 Of 14), Other Other 8500 0.24 Functional ≤ 10μM
Z80284-3-O MOLT-3 (T-lymphoblastic Leukemia Cells) (cluster #3 Of 3), Other Other 14 0.37 Functional ≤ 10μM
Z80354-4-O OVCAR-3 (Ovarian Adenocarcinoma Cells) (cluster #4 Of 4), Other Other 460 0.30 Functional ≤ 10μM
Z80362-1-O P388 (Lymphoma Cells) (cluster #1 Of 8), Other Other 50 0.34 Functional ≤ 10μM
Z80390-1-O PC-3 (Prostate Carcinoma Cells) (cluster #1 Of 10), Other Other 13 0.37 Functional ≤ 10μM
Z80414-1-O Raji (B-lymphoblastic Cells) (cluster #1 Of 3), Other Other 18 0.36 Functional ≤ 10μM
Z80427-1-O RKO (Colon Carcinoma) (cluster #1 Of 1), Other Other 29 0.35 Functional ≤ 10μM
Z80682-1-O A549 (Lung Carcinoma Cells) (cluster #1 Of 11), Other Other 7630 0.24 Functional ≤ 10μM
Z80697-1-O Bel-7402 (Hepatoma Cells) (cluster #1 Of 3), Other Other 9 0.38 Functional ≤ 10μM
Z80819-1-O J774.2 (cluster #1 Of 1), Other Other 13 0.37 Functional ≤ 10μM
Z80847-1-O FaDu (Pharyngeal Carcinoma Cells) (cluster #1 Of 3), Other Other 7 0.38 Functional ≤ 10μM
Z80866-1-O GLC4 Cell Line (cluster #1 Of 1), Other Other 60 0.34 Functional ≤ 10μM
Z80874-1-O CEM (T-cell Leukemia) (cluster #1 Of 7), Other Other 7 0.38 Functional ≤ 10μM
Z80936-1-O HEK293 (Embryonic Kidney Fibroblasts) (cluster #1 Of 4), Other Other 17 0.36 Functional ≤ 10μM
Z81020-3-O HepG2 (Hepatoblastoma Cells) (cluster #3 Of 8), Other Other 500 0.29 Functional ≤ 10μM
Z81115-1-O KB (Squamous Cell Carcinoma) (cluster #1 Of 6), Other Other 8 0.38 Functional ≤ 10μM
Z81135-1-O L6 (Skeletal Muscle Myoblast Cells) (cluster #1 Of 4), Other Other 150 0.32 Functional ≤ 10μM
Z81244-1-O J774 (Macrophage Cells) (cluster #1 Of 1), Other Other 16 0.36 Functional ≤ 10μM
Z81247-2-O HeLa (Cervical Adenocarcinoma Cells) (cluster #2 Of 9), Other Other 69 0.33 Functional ≤ 10μM
Z81252-3-O MDA-MB-231 (Breast Adenocarcinoma Cells) (cluster #3 Of 11), Other Other 8 0.38 Functional ≤ 10μM
Z81335-2-O HCT-15 (Colon Adenocarcinoma Cells) (cluster #2 Of 5), Other Other 1000 0.28 Functional ≤ 10μM
Z80052-1-O C8166 (Leukemic T-cells) (cluster #1 Of 1), Other Other 150 0.32 ADME/T ≤ 10μM
Z80390-1-O PC-3 (Prostate Carcinoma Cells) (cluster #1 Of 2), Other Other 34 0.35 ADME/T ≤ 10μM
Z80583-1-O Vero (Kidney Cells) (cluster #1 Of 3), Other Other 23 0.36 ADME/T ≤ 10μM
Z81115-2-O KB (Squamous Cell Carcinoma) (cluster #2 Of 3), Other Other 5 0.39 ADME/T ≤ 10μM
Z81135-3-O L6 (Skeletal Muscle Myoblast Cells) (cluster #3 Of 6), Other Other 9 0.38 ADME/T ≤ 10μM
Z81170-1-O LNCaP (Prostate Carcinoma) (cluster #1 Of 1), Other Other 31 0.35 ADME/T ≤ 10μM
VE2-1-V Human Papillomavirus Regulatory Protein E2 (cluster #1 Of 1), Viral Viruses 1050 0.28 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.32 4.95 -16.81 1 8 0 93 414.41 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
Z50602-2-O Human Herpesvirus 1 (cluster #2 Of 5), Other Other 25 0.37 Functional ≤ 10μM
Z50651-2-O Vesicular Stomatitis Virus (cluster #2 Of 2), Other Other 25 0.37 Functional ≤ 10μM
Z80110-1-O CV-1 (Kidney Cells) (cluster #1 Of 2), Other Other 6 0.40 Functional ≤ 10μM
Z80166-1-O HT-29 (Colon Adenocarcinoma Cells) (cluster #1 Of 12), Other Other 6 0.40 Functional ≤ 10μM
Z80362-1-O P388 (Lymphoma Cells) (cluster #1 Of 8), Other Other 10 0.39 Functional ≤ 10μM
Z80682-1-O A549 (Lung Carcinoma Cells) (cluster #1 Of 11), Other Other 6 0.40 Functional ≤ 10μM
Z80866-1-O GLC4 Cell Line (cluster #1 Of 1), Other Other 8 0.39 Functional ≤ 10μM
Z81115-1-O KB (Squamous Cell Carcinoma) (cluster #1 Of 6), Other Other 9 0.39 Functional ≤ 10μM
Z81247-2-O HeLa (Cervical Adenocarcinoma Cells) (cluster #2 Of 9), Other Other 7 0.39 Functional ≤ 10μM
Z80390-1-O PC-3 (Prostate Carcinoma Cells) (cluster #1 Of 2), Other Other 32 0.36 ADME/T ≤ 10μM
Z81170-1-O LNCaP (Prostate Carcinoma) (cluster #1 Of 1), Other Other 30 0.36 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.31 8.11 -17.36 0 7 0 72 398.411 4

Parameters Provided:

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

Permalink

Embed Link to Results