UCSF
ZINC Item Suppliers, Protomers, & Similar Substances

Analogs

40847426
40847426

Draw Identity 99% 90% 80% 70%

Vendors

And 8 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
ABCG2-2-E ATP-binding Cassette Sub-family G Member 2 (cluster #2 Of 2), Eukaryotic Eukaryotes 74 0.29 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.58 8.76 -13.86 2 8 0 101 469.582 8

Analogs

38413756
38413756

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
A1Z199-1-E BCR/ABL P210 Fusion Protein (cluster #1 Of 1), Eukaryotic Eukaryotes 750 0.23 Binding ≤ 10μM
ABCG2-2-E ATP-binding Cassette Sub-family G Member 2 (cluster #2 Of 2), Eukaryotic Eukaryotes 4898 0.20 Binding ≤ 10μM
ABL1-1-E Tyrosine-protein Kinase ABL (cluster #1 Of 1), Eukaryotic Eukaryotes 11 0.30 Binding ≤ 10μM
ABL2-1-E Tyrosine-protein Kinase ABL2 (cluster #1 Of 1), Eukaryotic Eukaryotes 6 0.31 Binding ≤ 10μM
BCR-1-E Breakpoint Cluster Region Protein (cluster #1 Of 1), Eukaryotic Eukaryotes 473 0.24 Binding ≤ 10μM
BLK-1-E Tyrosine-protein Kinase BLK (cluster #1 Of 1), Eukaryotic Eukaryotes 520 0.24 Binding ≤ 10μM
BRAF-1-E Serine/threonine-protein Kinase B-raf (cluster #1 Of 1), Eukaryotic Eukaryotes 3300 0.21 Binding ≤ 10μM
CAH1-1-E Carbonic Anhydrase I (cluster #1 Of 12), Eukaryotic Eukaryotes 32 0.28 Binding ≤ 10μM
CAH12-1-E Carbonic Anhydrase XII (cluster #1 Of 9), Eukaryotic Eukaryotes 980 0.23 Binding ≤ 10μM
CAH13-2-E Carbonic Anhydrase XIII (cluster #2 Of 7), Eukaryotic Eukaryotes 7450 0.19 Binding ≤ 10μM
CAH14-8-E Carbonic Anhydrase XIV (cluster #8 Of 8), Eukaryotic Eukaryotes 468 0.24 Binding ≤ 10μM
CAH15-2-E Carbonic Anhydrase 15 (cluster #2 Of 6), Eukaryotic Eukaryotes 78 0.27 Binding ≤ 10μM
CAH2-1-E Carbonic Anhydrase II (cluster #1 Of 15), Eukaryotic Eukaryotes 30 0.28 Binding ≤ 10μM
CAH3-1-E Carbonic Anhydrase III (cluster #1 Of 6), Eukaryotic Eukaryotes 528 0.24 Binding ≤ 10μM
CAH4-1-E Carbonic Anhydrase IV (cluster #1 Of 16), Eukaryotic Eukaryotes 4553 0.20 Binding ≤ 10μM
CAH6-1-E Carbonic Anhydrase VI (cluster #1 Of 8), Eukaryotic Eukaryotes 392 0.24 Binding ≤ 10μM
CAH7-1-E Carbonic Anhydrase VII (cluster #1 Of 8), Eukaryotic Eukaryotes 109 0.26 Binding ≤ 10μM
CAH9-1-E Carbonic Anhydrase IX (cluster #1 Of 11), Eukaryotic Eukaryotes 76 0.27 Binding ≤ 10μM
CDK19-1-E Cell Division Cycle 2-like Protein Kinase 6 (cluster #1 Of 1), Eukaryotic Eukaryotes 5500 0.20 Binding ≤ 10μM
CLK1-2-E Dual Specificty Protein Kinase CLK1 (cluster #2 Of 2), Eukaryotic Eukaryotes 4500 0.20 Binding ≤ 10μM
CLK4-1-E Dual Specificity Protein Kinase CLK4 (cluster #1 Of 2), Eukaryotic Eukaryotes 4200 0.20 Binding ≤ 10μM
CSF1R-1-E Macrophage Colony-stimulating Factor 1 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 960 0.23 Binding ≤ 10μM
DDR1-1-E Epithelial Discoidin Domain-containing Receptor 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 43 0.28 Binding ≤ 10μM
DDR2-1-E Discoidin Domain-containing Receptor 2 (cluster #1 Of 1), Eukaryotic Eukaryotes 15 0.30 Binding ≤ 10μM
EGFR-1-E Epidermal Growth Factor Receptor ErbB1 (cluster #1 Of 4), Eukaryotic Eukaryotes 7600 0.19 Binding ≤ 10μM
EPHA8-1-E Ephrin Type-A Receptor 8 (cluster #1 Of 1), Eukaryotic Eukaryotes 2100 0.21 Binding ≤ 10μM
FGR-1-E Tyrosine-protein Kinase FGR (cluster #1 Of 2), Eukaryotic Eukaryotes 2400 0.21 Binding ≤ 10μM
FRK-1-E Tyrosine-protein Kinase FRK (cluster #1 Of 1), Eukaryotic Eukaryotes 3500 0.21 Binding ≤ 10μM
FYN-1-E Tyrosine-protein Kinase FYN (cluster #1 Of 5), Eukaryotic Eukaryotes 5500 0.20 Binding ≤ 10μM
GAK-1-E Serine/threonine-protein Kinase GAK (cluster #1 Of 2), Eukaryotic Eukaryotes 3600 0.21 Binding ≤ 10μM
KIT-1-E Stem Cell Growth Factor Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 97 0.27 Binding ≤ 10μM
KSYK-1-E Tyrosine-protein Kinase SYK (cluster #1 Of 2), Eukaryotic Eukaryotes 5000 0.20 Binding ≤ 10μM
LCK-1-E Tyrosine-protein Kinase LCK (cluster #1 Of 4), Eukaryotic Eukaryotes 62 0.27 Binding ≤ 10μM
LYN-1-E Tyrosine-protein Kinase Lyn (cluster #1 Of 1), Eukaryotic Eukaryotes 220 0.25 Binding ≤ 10μM
MELK-1-E Maternal Embryonic Leucine Zipper Kinase (cluster #1 Of 1), Eukaryotic Eukaryotes 1900 0.22 Binding ≤ 10μM
MK08-1-E Mitogen-activated Protein Kinase 8 (cluster #1 Of 5), Eukaryotic Eukaryotes 5000 0.20 Binding ≤ 10μM
MK09-1-E C-Jun N-terminal Kinase 2 (cluster #1 Of 3), Eukaryotic Eukaryotes 5200 0.20 Binding ≤ 10μM
MK10-1-E C-Jun N-terminal Kinase 3 (cluster #1 Of 2), Eukaryotic Eukaryotes 3300 0.21 Binding ≤ 10μM
MLTK-1-E Mixed Lineage Kinase 7 (cluster #1 Of 1), Eukaryotic Eukaryotes 2600 0.21 Binding ≤ 10μM
PGFRA-1-E Platelet-derived Growth Factor Receptor Alpha (cluster #1 Of 2), Eukaryotic Eukaryotes 90 0.27 Binding ≤ 10μM
PGFRB-1-E Platelet-derived Growth Factor Receptor Beta (cluster #1 Of 1), Eukaryotic Eukaryotes 72 0.27 Binding ≤ 10μM
PLK4-1-E Serine/threonine-protein Kinase PLK4 (cluster #1 Of 1), Eukaryotic Eukaryotes 9000 0.19 Binding ≤ 10μM
RAF1-1-E Serine/threonine-protein Kinase RAF (cluster #1 Of 1), Eukaryotic Eukaryotes 1700 0.22 Binding ≤ 10μM
ST17A-1-E Serine/threonine-protein Kinase 17A (cluster #1 Of 2), Eukaryotic Eukaryotes 5300 0.20 Binding ≤ 10μM
TNI3K-1-E Serine/threonine-protein Kinase TNNI3K (cluster #1 Of 1), Eukaryotic Eukaryotes 4300 0.20 Binding ≤ 10μM
ABL1-1-E Tyrosine-protein Kinase ABL (cluster #1 Of 2), Eukaryotic Eukaryotes 90 0.27 Functional ≤ 10μM
BCR-1-E Breakpoint Cluster Region Protein (cluster #1 Of 2), Eukaryotic Eukaryotes 90 0.27 Functional ≤ 10μM
KIT-1-E Stem Cell Growth Factor Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 5000 0.20 Functional ≤ 10μM
PGFRA-1-E Platelet-derived Growth Factor Receptor Alpha (cluster #1 Of 1), Eukaryotic Eukaryotes 96 0.27 Functional ≤ 10μM
Z50466-1-O Trypanosoma Cruzi (cluster #1 Of 8), Other Other 9000 0.19 Functional ≤ 10μM
Z80036-1-O BaF3 (IL-3-dependent Pro-B-cells) (cluster #1 Of 3), Other Other 9100 0.19 Functional ≤ 10μM
Z80166-4-O HT-29 (Colon Adenocarcinoma Cells) (cluster #4 Of 12), Other Other 60 0.27 Functional ≤ 10μM
Z80186-1-O K562 (Erythroleukemia Cells) (cluster #1 Of 11), Other Other 6 0.31 Functional ≤ 10μM
Z80928-3-O HCT-116 (Colon Carcinoma Cells) (cluster #3 Of 9), Other Other 10000 0.19 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.89 13.15 -49.4 3 8 1 87 494.623 7
Mid Mid (pH 6-8) 3.89 13.03 -52.36 3 8 1 87 494.623 7
Mid Mid (pH 6-8) 3.89 10.78 -14.7 2 8 0 86 493.615 7

Analogs

4098433
4098433
5809705
5809705

Draw Identity 99% 90% 80% 70%

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
ABCG2-2-E ATP-binding Cassette Sub-family G Member 2 (cluster #2 Of 2), Eukaryotic Eukaryotes 4900 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) 3.30 0.54 -7.95 1 4 0 55 284.311 2

Analogs

13334938
13334938
13334939
13334939
13334943
13334943
13334944
13334944
1627642
1627642

Draw Identity 99% 90% 80% 70%

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
ABCG2-2-E ATP-binding Cassette Sub-family G Member 2 (cluster #2 Of 2), Eukaryotic Eukaryotes 4900 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) 3.30 0.53 -7.85 1 4 0 55 284.311 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
ABCG2-2-E ATP-binding Cassette Sub-family G Member 2 (cluster #2 Of 2), Eukaryotic Eukaryotes 9300 0.32 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.58 8.7 -9.31 0 4 0 45 298.338 3

Analogs

31350669
31350669
31350671
31350671

Draw Identity 99% 90% 80% 70%

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
ABCG2-2-E ATP-binding Cassette Sub-family G Member 2 (cluster #2 Of 2), Eukaryotic Eukaryotes 9300 0.32 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.58 8.71 -9.31 0 4 0 45 298.338 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
ABCG2-2-E ATP-binding Cassette Sub-family G Member 2 (cluster #2 Of 2), Eukaryotic Eukaryotes 6600 0.27 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) 4.19 4.44 -11.49 3 6 0 96 370.401 4
Hi High (pH 8-9.5) 4.19 5.43 -54 2 6 -1 99 369.393 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
ABCG2-2-E ATP-binding Cassette Sub-family G Member 2 (cluster #2 Of 2), Eukaryotic Eukaryotes 4100 0.24 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) 5.18 5.17 -10.44 4 6 0 107 424.493 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
ABCG2-2-E ATP-binding Cassette Sub-family G Member 2 (cluster #2 Of 2), Eukaryotic Eukaryotes 560 0.29 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.82 8.18 -18.23 2 6 0 80 402.45 6

Analogs

4935
4935

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
ABCG2-2-E ATP-binding Cassette Sub-family G Member 2 (cluster #2 Of 2), Eukaryotic Eukaryotes 8900 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) 3.13 5.88 -8.25 1 4 0 56 270.284 2
Hi High (pH 8-9.5) 3.13 6.87 -50.77 0 4 -1 59 269.276 2

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

And 17 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
ABCG2-2-E ATP-binding Cassette Sub-family G Member 2 (cluster #2 Of 2), Eukaryotic Eukaryotes 6000 0.26 Binding ≤ 10μM
CYSP-4-E Cruzipain (cluster #4 Of 4), Eukaryotic Eukaryotes 4000 0.27 Binding ≤ 10μM
MDR1-2-E P-glycoprotein 1 (cluster #2 Of 3), Eukaryotic Eukaryotes 7600 0.26 Binding ≤ 10μM
MRP1-1-E Multidrug Resistance-associated Protein 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 8500 0.25 Binding ≤ 10μM
MRP2-1-E Canalicular Multispecific Organic Anion Transporter 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 7800 0.26 Binding ≤ 10μM
MRP3-1-E Canalicular Multispecific Organic Anion Transporter 2 (cluster #1 Of 1), Eukaryotic Eukaryotes 5100 0.26 Binding ≤ 10μM
Z50425-3-O Plasmodium Falciparum (cluster #3 Of 22), Other Other 726 0.31 Functional ≤ 10μM
Z50607-1-O Human Immunodeficiency Virus 1 (cluster #1 Of 10), Other Other 10 0.40 Functional ≤ 10μM
Z50677-1-O Human Immunodeficiency Virus (cluster #1 Of 3), Other Other 9 0.40 Functional ≤ 10μM
Z80295-6-O MT4 (Lymphocytes) (cluster #6 Of 8), Other Other 7 0.41 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) 5.03 0.49 -10.21 3 7 0 120 435.285 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
ABCG2-2-E ATP-binding Cassette Sub-family G Member 2 (cluster #2 Of 2), Eukaryotic Eukaryotes 940 0.18 Binding ≤ 10μM
MDR1-2-E P-glycoprotein 1 (cluster #2 Of 3), Eukaryotic Eukaryotes 68 0.21 Binding ≤ 10μM
CP2C9-1-E Cytochrome P450 2C9 (cluster #1 Of 3), Eukaryotic Eukaryotes 7100 0.15 ADME/T ≤ 10μM
Z80133-1-O EMT6 (Mammary Carcinoma Cells) (cluster #1 Of 3), Other Other 38 0.22 Functional ≤ 10μM
Z81255-1-O MDR (Multi-drug Resistant Cells) (cluster #1 Of 1), Other Other 16 0.23 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.50 0.51 -59.9 3 10 1 112 647.752 11

Analogs

898881
898881
3873159
3873159
39451
39451

Draw Identity 99% 90% 80% 70%

Vendors

And 2 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
ABCG2-2-E ATP-binding Cassette Sub-family G Member 2 (cluster #2 Of 2), Eukaryotic Eukaryotes 3100 0.31 Binding ≤ 10μM
ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 57 0.41 Binding ≤ 10μM
ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 68 0.40 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) 4.37 -2.54 -9.86 3 5 0 86 340.375 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
ABCG2-2-E ATP-binding Cassette Sub-family G Member 2 (cluster #2 Of 2), Eukaryotic Eukaryotes 430 0.21 Binding ≤ 10μM
MDR1-2-E P-glycoprotein 1 (cluster #2 Of 3), Eukaryotic Eukaryotes 2000 0.19 Binding ≤ 10μM
MDR1-1-E P-glycoprotein 1 (cluster #1 Of 2), Eukaryotic Eukaryotes 2000 0.19 Functional ≤ 10μM
Z80054-1-O Caco-2 (Colon Adenocarcinoma Cells) (cluster #1 Of 4), Other Other 2000 0.19 Functional ≤ 10μM
Z80493-1-O SK-OV-3 (Ovarian Carcinoma Cells) (cluster #1 Of 6), Other Other 8100 0.17 Functional ≤ 10μM
Z80773-1-O CHRC/5 Cell Line (cluster #1 Of 1), Other Other 21 0.26 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.85 0.85 -62.78 3 8 1 94 564.662 8

Analogs

15219779
15219779
15219782
15219782
15219784
15219784

Draw Identity 99% 90% 80% 70%

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
ABCG2-2-E ATP-binding Cassette Sub-family G Member 2 (cluster #2 Of 2), Eukaryotic Eukaryotes 800 0.30 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.97 -1.8 -10.03 1 6 0 65 379.46 2

Parameters Provided:

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

Permalink

Embed Link to Results