UCSF
ZINC Item Suppliers, Protomers, & Similar Substances

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
NMD3A-5-E Glutamate [NMDA] Receptor Subunit 3A (cluster #5 Of 6), Eukaryotic Eukaryotes 5000 0.49 Binding ≤ 10μM
NMD3B-5-E Glutamate [NMDA] Receptor Subunit 3B (cluster #5 Of 6), Eukaryotic Eukaryotes 5000 0.49 Binding ≤ 10μM
NMDE1-1-E Glutamate [NMDA] Receptor Subunit Epsilon 1 (cluster #1 Of 5), Eukaryotic Eukaryotes 5000 0.49 Binding ≤ 10μM
NMDE2-3-E Glutamate [NMDA] Receptor Subunit Epsilon 2 (cluster #3 Of 5), Eukaryotic Eukaryotes 5000 0.49 Binding ≤ 10μM
NMDE3-2-E Glutamate [NMDA] Receptor Subunit Epsilon 3 (cluster #2 Of 4), Eukaryotic Eukaryotes 5000 0.49 Binding ≤ 10μM
NMDE4-5-E Glutamate [NMDA] Receptor Subunit Epsilon 4 (cluster #5 Of 6), Eukaryotic Eukaryotes 5000 0.49 Binding ≤ 10μM
NMDZ1-1-E Glutamate (NMDA) Receptor Subunit Zeta 1 (cluster #1 Of 6), Eukaryotic Eukaryotes 5000 0.49 Binding ≤ 10μM
Z104302-4-O Glutamate NMDA Receptor (cluster #4 Of 7), Other Other 400 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) 2.52 6.77 -40.47 1 3 -1 56 238.675 1
Mid Mid (pH 6-8) 3.09 5.5 -102.71 0 3 -2 53 237.667 1

Analogs

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
GRID1-1-E Glutamate Receptor Delta-1 Subunit (cluster #1 Of 1), Eukaryotic Eukaryotes 1800 0.62 Binding ≤ 10μM
NMD3A-5-E Glutamate [NMDA] Receptor Subunit 3A (cluster #5 Of 6), Eukaryotic Eukaryotes 1800 0.62 Binding ≤ 10μM
NMD3B-5-E Glutamate [NMDA] Receptor Subunit 3B (cluster #5 Of 6), Eukaryotic Eukaryotes 1800 0.62 Binding ≤ 10μM
NMDE1-3-E Glutamate [NMDA] Receptor Subunit Epsilon 1 (cluster #3 Of 5), Eukaryotic Eukaryotes 1800 0.62 Binding ≤ 10μM
NMDE2-3-E Glutamate [NMDA] Receptor Subunit Epsilon 2 (cluster #3 Of 5), Eukaryotic Eukaryotes 1800 0.62 Binding ≤ 10μM
NMDE3-2-E Glutamate [NMDA] Receptor Subunit Epsilon 3 (cluster #2 Of 4), Eukaryotic Eukaryotes 1800 0.62 Binding ≤ 10μM
NMDE4-5-E Glutamate [NMDA] Receptor Subunit Epsilon 4 (cluster #5 Of 6), Eukaryotic Eukaryotes 1800 0.62 Binding ≤ 10μM
NMDZ1-3-E Glutamate (NMDA) Receptor Subunit Zeta 1 (cluster #3 Of 6), Eukaryotic Eukaryotes 1800 0.62 Binding ≤ 10μM
Z104302-4-O Glutamate NMDA Receptor (cluster #4 Of 7), Other Other 8400 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) 2.20 -7.16 -8.4 2 4 0 66 196.593 0

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

And 18 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
GRID1-1-E Glutamate Receptor Delta-1 Subunit (cluster #1 Of 1), Eukaryotic Eukaryotes 3300 0.55 Binding ≤ 10μM
NMD3A-5-E Glutamate [NMDA] Receptor Subunit 3A (cluster #5 Of 6), Eukaryotic Eukaryotes 3300 0.55 Binding ≤ 10μM
NMD3B-5-E Glutamate [NMDA] Receptor Subunit 3B (cluster #5 Of 6), Eukaryotic Eukaryotes 3300 0.55 Binding ≤ 10μM
NMDE1-3-E Glutamate [NMDA] Receptor Subunit Epsilon 1 (cluster #3 Of 5), Eukaryotic Eukaryotes 3300 0.55 Binding ≤ 10μM
NMDE2-3-E Glutamate [NMDA] Receptor Subunit Epsilon 2 (cluster #3 Of 5), Eukaryotic Eukaryotes 3300 0.55 Binding ≤ 10μM
NMDE3-2-E Glutamate [NMDA] Receptor Subunit Epsilon 3 (cluster #2 Of 4), Eukaryotic Eukaryotes 3300 0.55 Binding ≤ 10μM
NMDE4-5-E Glutamate [NMDA] Receptor Subunit Epsilon 4 (cluster #5 Of 6), Eukaryotic Eukaryotes 3300 0.55 Binding ≤ 10μM
NMDZ1-3-E Glutamate (NMDA) Receptor Subunit Zeta 1 (cluster #3 Of 6), Eukaryotic Eukaryotes 3300 0.55 Binding ≤ 10μM
Z104302-4-O Glutamate NMDA Receptor (cluster #4 Of 7), Other Other 2300 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) 0.54 2.7 -10.8 2 4 0 66 190.202 0

Analogs

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
GRID1-1-E Glutamate Receptor Delta-1 Subunit (cluster #1 Of 1), Eukaryotic Eukaryotes 280 0.66 Binding ≤ 10μM
NMD3A-5-E Glutamate [NMDA] Receptor Subunit 3A (cluster #5 Of 6), Eukaryotic Eukaryotes 280 0.66 Binding ≤ 10μM
NMD3B-5-E Glutamate [NMDA] Receptor Subunit 3B (cluster #5 Of 6), Eukaryotic Eukaryotes 280 0.66 Binding ≤ 10μM
NMDE1-3-E Glutamate [NMDA] Receptor Subunit Epsilon 1 (cluster #3 Of 5), Eukaryotic Eukaryotes 280 0.66 Binding ≤ 10μM
NMDE2-3-E Glutamate [NMDA] Receptor Subunit Epsilon 2 (cluster #3 Of 5), Eukaryotic Eukaryotes 280 0.66 Binding ≤ 10μM
NMDE3-2-E Glutamate [NMDA] Receptor Subunit Epsilon 3 (cluster #2 Of 4), Eukaryotic Eukaryotes 280 0.66 Binding ≤ 10μM
NMDE4-5-E Glutamate [NMDA] Receptor Subunit Epsilon 4 (cluster #5 Of 6), Eukaryotic Eukaryotes 280 0.66 Binding ≤ 10μM
NMDZ1-3-E Glutamate (NMDA) Receptor Subunit Zeta 1 (cluster #3 Of 6), Eukaryotic Eukaryotes 280 0.66 Binding ≤ 10μM
Z104302-4-O Glutamate NMDA Receptor (cluster #4 Of 7), Other Other 3400 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.99 2.59 -8.79 2 4 0 66 231.038 0
Mid Mid (pH 6-8) 1.90 0.52 -42.98 1 4 -1 69 230.03 0

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

And 55 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
GRID1-1-E Glutamate Receptor Delta-1 Subunit (cluster #1 Of 1), Eukaryotic Eukaryotes 9800 0.58 Binding ≤ 10μM
NMD3A-5-E Glutamate [NMDA] Receptor Subunit 3A (cluster #5 Of 6), Eukaryotic Eukaryotes 9800 0.58 Binding ≤ 10μM
NMD3B-5-E Glutamate [NMDA] Receptor Subunit 3B (cluster #5 Of 6), Eukaryotic Eukaryotes 9800 0.58 Binding ≤ 10μM
NMDE1-3-E Glutamate [NMDA] Receptor Subunit Epsilon 1 (cluster #3 Of 5), Eukaryotic Eukaryotes 9800 0.58 Binding ≤ 10μM
NMDE2-3-E Glutamate [NMDA] Receptor Subunit Epsilon 2 (cluster #3 Of 5), Eukaryotic Eukaryotes 9800 0.58 Binding ≤ 10μM
NMDE3-2-E Glutamate [NMDA] Receptor Subunit Epsilon 3 (cluster #2 Of 4), Eukaryotic Eukaryotes 9800 0.58 Binding ≤ 10μM
NMDE4-5-E Glutamate [NMDA] Receptor Subunit Epsilon 4 (cluster #5 Of 6), Eukaryotic Eukaryotes 9800 0.58 Binding ≤ 10μM
NMDZ1-3-E Glutamate (NMDA) Receptor Subunit Zeta 1 (cluster #3 Of 6), Eukaryotic Eukaryotes 9800 0.58 Binding ≤ 10μM
Z104302-4-O Glutamate NMDA Receptor (cluster #4 Of 7), Other Other 9800 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.27 1.48 -11.66 2 4 0 66 162.148 0

Analogs

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
GRIA1-2-E Glutamate Receptor Ionotropic, AMPA 1 (cluster #2 Of 4), Eukaryotic Eukaryotes 1640 0.58 Binding ≤ 10μM
GRIA2-1-E Glutamate Receptor Ionotropic, AMPA 2 (cluster #1 Of 4), Eukaryotic Eukaryotes 1640 0.58 Binding ≤ 10μM
GRIA3-1-E Glutamate Receptor Ionotropic, AMPA 3 (cluster #1 Of 4), Eukaryotic Eukaryotes 1640 0.58 Binding ≤ 10μM
GRIA4-1-E Glutamate Receptor Ionotropic, AMPA 4 (cluster #1 Of 5), Eukaryotic Eukaryotes 1640 0.58 Binding ≤ 10μM
GRID1-1-E Glutamate Receptor Delta-1 Subunit (cluster #1 Of 1), Eukaryotic Eukaryotes 130 0.69 Binding ≤ 10μM
NMD3A-5-E Glutamate [NMDA] Receptor Subunit 3A (cluster #5 Of 6), Eukaryotic Eukaryotes 130 0.69 Binding ≤ 10μM
NMD3B-5-E Glutamate [NMDA] Receptor Subunit 3B (cluster #5 Of 6), Eukaryotic Eukaryotes 130 0.69 Binding ≤ 10μM
NMDE1-3-E Glutamate [NMDA] Receptor Subunit Epsilon 1 (cluster #3 Of 5), Eukaryotic Eukaryotes 130 0.69 Binding ≤ 10μM
NMDE2-3-E Glutamate [NMDA] Receptor Subunit Epsilon 2 (cluster #3 Of 5), Eukaryotic Eukaryotes 130 0.69 Binding ≤ 10μM
NMDE3-2-E Glutamate [NMDA] Receptor Subunit Epsilon 3 (cluster #2 Of 4), Eukaryotic Eukaryotes 130 0.69 Binding ≤ 10μM
NMDE4-5-E Glutamate [NMDA] Receptor Subunit Epsilon 4 (cluster #5 Of 6), Eukaryotic Eukaryotes 130 0.69 Binding ≤ 10μM
NMDZ1-3-E Glutamate (NMDA) Receptor Subunit Zeta 1 (cluster #3 Of 6), Eukaryotic Eukaryotes 130 0.69 Binding ≤ 10μM
Z104302-4-O Glutamate NMDA Receptor (cluster #4 Of 7), Other Other 3100 0.55 Binding ≤ 10μM
Z50425-9-O Plasmodium Falciparum (cluster #9 Of 22), Other Other 3981 0.54 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) 0.99 2.46 -9.86 2 4 0 66 231.038 0
Hi High (pH 8-9.5) 1.86 1.7 -36.44 1 4 1 61 230.03 0
Hi High (pH 8-9.5) 1.90 0.31 -40.97 1 4 -1 69 230.03 0

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

And 5 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
GRID1-1-E Glutamate Receptor Delta-1 Subunit (cluster #1 Of 1), Eukaryotic Eukaryotes 2100 0.57 Binding ≤ 10μM
NMD3A-5-E Glutamate [NMDA] Receptor Subunit 3A (cluster #5 Of 6), Eukaryotic Eukaryotes 2100 0.57 Binding ≤ 10μM
NMD3B-5-E Glutamate [NMDA] Receptor Subunit 3B (cluster #5 Of 6), Eukaryotic Eukaryotes 2100 0.57 Binding ≤ 10μM
NMDE1-3-E Glutamate [NMDA] Receptor Subunit Epsilon 1 (cluster #3 Of 5), Eukaryotic Eukaryotes 2100 0.57 Binding ≤ 10μM
NMDE2-3-E Glutamate [NMDA] Receptor Subunit Epsilon 2 (cluster #3 Of 5), Eukaryotic Eukaryotes 2100 0.57 Binding ≤ 10μM
NMDE3-2-E Glutamate [NMDA] Receptor Subunit Epsilon 3 (cluster #2 Of 4), Eukaryotic Eukaryotes 2100 0.57 Binding ≤ 10μM
NMDE4-5-E Glutamate [NMDA] Receptor Subunit Epsilon 4 (cluster #5 Of 6), Eukaryotic Eukaryotes 2100 0.57 Binding ≤ 10μM
NMDZ1-3-E Glutamate (NMDA) Receptor Subunit Zeta 1 (cluster #3 Of 6), Eukaryotic Eukaryotes 2100 0.57 Binding ≤ 10μM
Z104302-4-O Glutamate NMDA Receptor (cluster #4 Of 7), Other Other 2100 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.54 2.94 -10.71 2 4 0 66 190.202 0

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
GRID1-1-E Glutamate Receptor Delta-1 Subunit (cluster #1 Of 1), Eukaryotic Eukaryotes 1400 0.59 Binding ≤ 10μM
NMD3A-5-E Glutamate [NMDA] Receptor Subunit 3A (cluster #5 Of 6), Eukaryotic Eukaryotes 1400 0.59 Binding ≤ 10μM
NMD3B-5-E Glutamate [NMDA] Receptor Subunit 3B (cluster #5 Of 6), Eukaryotic Eukaryotes 1400 0.59 Binding ≤ 10μM
NMDE1-3-E Glutamate [NMDA] Receptor Subunit Epsilon 1 (cluster #3 Of 5), Eukaryotic Eukaryotes 1400 0.59 Binding ≤ 10μM
NMDE2-3-E Glutamate [NMDA] Receptor Subunit Epsilon 2 (cluster #3 Of 5), Eukaryotic Eukaryotes 1400 0.59 Binding ≤ 10μM
NMDE3-2-E Glutamate [NMDA] Receptor Subunit Epsilon 3 (cluster #2 Of 4), Eukaryotic Eukaryotes 1400 0.59 Binding ≤ 10μM
NMDE4-5-E Glutamate [NMDA] Receptor Subunit Epsilon 4 (cluster #5 Of 6), Eukaryotic Eukaryotes 1400 0.59 Binding ≤ 10μM
NMDZ1-3-E Glutamate (NMDA) Receptor Subunit Zeta 1 (cluster #3 Of 6), Eukaryotic Eukaryotes 1400 0.59 Binding ≤ 10μM
Z104302-4-O Glutamate NMDA Receptor (cluster #4 Of 7), Other Other 1400 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.51 1.01 -11.51 2 5 0 83 190.158 0
Hi High (pH 8-9.5) 0.39 0.03 -122.56 0 5 -2 88 188.142 0
Hi High (pH 8-9.5) 0.39 0.42 -128.47 0 5 -2 88 188.142 0

Analogs

34354758
34354758

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
GLRA1-1-E Glycine Receptor Subunit Alpha-1 (cluster #1 Of 2), Eukaryotic Eukaryotes 90 0.62 Binding ≤ 10μM
GLRA2-1-E Glycine Receptor Subunit Alpha-2 (cluster #1 Of 2), Eukaryotic Eukaryotes 90 0.62 Binding ≤ 10μM
GLRA3-1-E Glycine Receptor Alpha-3 Chain (cluster #1 Of 2), Eukaryotic Eukaryotes 90 0.62 Binding ≤ 10μM
GLRB-1-E Glycine Receptor Beta Chain (cluster #1 Of 2), Eukaryotic Eukaryotes 90 0.62 Binding ≤ 10μM
GRIA1-2-E Glutamate Receptor Ionotropic, AMPA 1 (cluster #2 Of 4), Eukaryotic Eukaryotes 500 0.55 Binding ≤ 10μM
GRIA2-1-E Glutamate Receptor Ionotropic, AMPA 2 (cluster #1 Of 4), Eukaryotic Eukaryotes 500 0.55 Binding ≤ 10μM
GRIA3-1-E Glutamate Receptor Ionotropic, AMPA 3 (cluster #1 Of 4), Eukaryotic Eukaryotes 500 0.55 Binding ≤ 10μM
GRIA4-1-E Glutamate Receptor Ionotropic, AMPA 4 (cluster #1 Of 5), Eukaryotic Eukaryotes 500 0.55 Binding ≤ 10μM
NMD3A-5-E Glutamate [NMDA] Receptor Subunit 3A (cluster #5 Of 6), Eukaryotic Eukaryotes 68 0.63 Binding ≤ 10μM
NMD3B-5-E Glutamate [NMDA] Receptor Subunit 3B (cluster #5 Of 6), Eukaryotic Eukaryotes 68 0.63 Binding ≤ 10μM
NMDE1-3-E Glutamate [NMDA] Receptor Subunit Epsilon 1 (cluster #3 Of 5), Eukaryotic Eukaryotes 68 0.63 Binding ≤ 10μM
NMDE2-3-E Glutamate [NMDA] Receptor Subunit Epsilon 2 (cluster #3 Of 5), Eukaryotic Eukaryotes 68 0.63 Binding ≤ 10μM
NMDE3-2-E Glutamate [NMDA] Receptor Subunit Epsilon 3 (cluster #2 Of 4), Eukaryotic Eukaryotes 68 0.63 Binding ≤ 10μM
NMDE4-5-E Glutamate [NMDA] Receptor Subunit Epsilon 4 (cluster #5 Of 6), Eukaryotic Eukaryotes 68 0.63 Binding ≤ 10μM
NMDZ1-3-E Glutamate (NMDA) Receptor Subunit Zeta 1 (cluster #3 Of 6), Eukaryotic Eukaryotes 68 0.63 Binding ≤ 10μM
NMD3B-1-E Glutamate [NMDA] Receptor Subunit 3B (cluster #1 Of 2), Eukaryotic Eukaryotes 3500 0.48 Functional ≤ 10μM
NMDE2-2-E Glutamate [NMDA] Receptor Subunit Epsilon 2 (cluster #2 Of 2), Eukaryotic Eukaryotes 3500 0.48 Functional ≤ 10μM
NMDE3-1-E Glutamate [NMDA] Receptor Subunit Epsilon 3 (cluster #1 Of 2), Eukaryotic Eukaryotes 3500 0.48 Functional ≤ 10μM
NMDE4-2-E Glutamate [NMDA] Receptor Subunit Epsilon 4 (cluster #2 Of 2), Eukaryotic Eukaryotes 3500 0.48 Functional ≤ 10μM
Z104302-4-O Glutamate NMDA Receptor (cluster #4 Of 7), Other Other 90 0.62 Binding ≤ 10μM
Z50594-1-O Mus Musculus (cluster #1 Of 9), Other Other 4700 0.47 Functional ≤ 10μM
Z50597-10-O Rattus Norvegicus (cluster #10 Of 12), Other Other 5000 0.46 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.79 5.87 -38.83 1 4 -1 73 257.052 1

Parameters Provided:

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

Permalink

Embed Link to Results