UCSF
ZINC Item Suppliers, Protomers, & Similar Substances

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

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.35 8.69 -5.85 0 0 0 0 170.255 0

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

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) 8.07 14.16 -5.49 0 0 0 0 322.879 3

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

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.42 0.56 -36.63 3 12 0 155 533.578 17

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

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.10 1.31 -23.94 2 10 0 128 485.537 11

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
FLT3-1-E Tyrosine-protein Kinase Receptor FLT3 (cluster #1 Of 1), Eukaryotic Eukaryotes 1460 0.28 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
FLT3_HUMAN P36888 Tyrosine-protein Kinase Receptor FLT3, Human 1460 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) 4.08 11.95 -56.47 2 5 1 59 388.491 6

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
FLT3-1-E Tyrosine-protein Kinase Receptor FLT3 (cluster #1 Of 1), Eukaryotic Eukaryotes 90 0.30 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
FLT3_HUMAN P36888 Tyrosine-protein Kinase Receptor FLT3, Human 90 0.30 Binding ≤ 1μM
FLT3_HUMAN P36888 Tyrosine-protein Kinase Receptor FLT3, Human 90 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) 3.26 9.21 -18.59 1 6 0 67 447.51 6
Mid Mid (pH 6-8) 3.26 11.48 -56.96 2 6 1 69 448.518 6

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

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.67 9.71 -13.34 1 2 0 33 285.346 1

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
FLT3-1-E Tyrosine-protein Kinase Receptor FLT3 (cluster #1 Of 1), Eukaryotic Eukaryotes 177 0.32 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
FLT3_HUMAN P36888 Tyrosine-protein Kinase Receptor FLT3, Human 177 0.32 Binding ≤ 1μM
FLT3_HUMAN P36888 Tyrosine-protein Kinase Receptor FLT3, Human 177 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) 5.09 12.4 -55.56 2 4 1 47 405.493 6

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
FLT3-1-E Tyrosine-protein Kinase Receptor FLT3 (cluster #1 Of 1), Eukaryotic Eukaryotes 18 0.31 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
FLT3_HUMAN P36888 Tyrosine-protein Kinase Receptor FLT3, Human 18 0.31 Binding ≤ 1μM
FLT3_HUMAN P36888 Tyrosine-protein Kinase Receptor FLT3, Human 18 0.31 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.29 12.71 -47.04 2 5 1 50 474.6 6
Lo Low (pH 4.5-6) 4.29 15.04 -118.75 3 5 2 51 475.608 6

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

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.46 9.55 -14.47 1 2 0 33 289.309 1

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
FLT3-1-E Tyrosine-protein Kinase Receptor FLT3 (cluster #1 Of 1), Eukaryotic Eukaryotes 19 0.34 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
FLT3_HUMAN P36888 Tyrosine-protein Kinase Receptor FLT3, Human 19 0.34 Binding ≤ 1μM
FLT3_HUMAN P36888 Tyrosine-protein Kinase Receptor FLT3, Human 19 0.34 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.72 9.26 -18.53 1 5 0 55 432.495 5
Mid Mid (pH 6-8) 3.72 11.61 -53.64 2 5 1 56 433.503 5

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
FLT3-1-E Tyrosine-protein Kinase Receptor FLT3 (cluster #1 Of 1), Eukaryotic Eukaryotes 5 0.37 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
FLT3_HUMAN P36888 Tyrosine-protein Kinase Receptor FLT3, Human 5 0.37 Binding ≤ 1μM
FLT3_HUMAN P36888 Tyrosine-protein Kinase Receptor FLT3, Human 5 0.37 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.21 12.79 -54.35 2 4 1 47 423.483 6

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
FLT3-1-E Tyrosine-protein Kinase Receptor FLT3 (cluster #1 Of 1), Eukaryotic Eukaryotes 14 0.33 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
FLT3_HUMAN P36888 Tyrosine-protein Kinase Receptor FLT3, Human 14 0.33 Binding ≤ 1μM
FLT3_HUMAN P36888 Tyrosine-protein Kinase Receptor FLT3, Human 14 0.33 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.96 14.14 -52.78 2 4 1 47 451.537 8

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
FLT3-1-E Tyrosine-protein Kinase Receptor FLT3 (cluster #1 Of 1), Eukaryotic Eukaryotes 12 0.33 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
FLT3_HUMAN P36888 Tyrosine-protein Kinase Receptor FLT3, Human 12 0.33 Binding ≤ 1μM
FLT3_HUMAN P36888 Tyrosine-protein Kinase Receptor FLT3, Human 12 0.33 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.05 9.98 -18.62 1 5 0 55 464.512 6
Mid Mid (pH 6-8) 5.05 12.25 -57.36 2 5 1 56 465.52 6

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

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 7.47 -19.25 1 5 0 70 378.453 3

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
FLT3-1-E Tyrosine-protein Kinase Receptor FLT3 (cluster #1 Of 1), Eukaryotic Eukaryotes 224 0.28 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
FLT3_HUMAN P36888 Tyrosine-protein Kinase Receptor FLT3, Human 224 0.28 Binding ≤ 1μM
FLT3_HUMAN P36888 Tyrosine-protein Kinase Receptor FLT3, Human 224 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) 3.99 9.97 -18.21 1 5 0 55 446.522 6
Mid Mid (pH 6-8) 3.99 12.24 -56.3 2 5 1 56 447.53 6

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

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.08 10.1 -13.96 1 2 0 33 350.215 1

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

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.71 10.15 -15.68 1 2 0 33 285.346 1

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
FLT3-1-E Tyrosine-protein Kinase Receptor FLT3 (cluster #1 Of 1), Eukaryotic Eukaryotes 17 0.32 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
FLT3_HUMAN P36888 Tyrosine-protein Kinase Receptor FLT3, Human 17 0.32 Binding ≤ 1μM
FLT3_HUMAN P36888 Tyrosine-protein Kinase Receptor FLT3, Human 17 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) 6.12 14.66 -54.35 2 4 1 47 463.548 6

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

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.67 10.07 -15.97 1 2 0 33 285.346 1

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
FLT3-1-E Tyrosine-protein Kinase Receptor FLT3 (cluster #1 Of 1), Eukaryotic Eukaryotes 86 0.30 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
FLT3_HUMAN P36888 Tyrosine-protein Kinase Receptor FLT3, Human 86 0.30 Binding ≤ 1μM
FLT3_HUMAN P36888 Tyrosine-protein Kinase Receptor FLT3, Human 86 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) 4.88 9.74 -18.23 1 6 0 67 508.416 6
Mid Mid (pH 6-8) 4.88 12 -56.54 2 6 1 69 509.424 6

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
FLT3-1-E Tyrosine-protein Kinase Receptor FLT3 (cluster #1 Of 1), Eukaryotic Eukaryotes 742 0.29 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
FLT3_HUMAN P36888 Tyrosine-protein Kinase Receptor FLT3, Human 742 0.29 Binding ≤ 1μM
FLT3_HUMAN P36888 Tyrosine-protein Kinase Receptor FLT3, Human 742 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) 5.12 12.42 -52.87 2 4 1 47 405.493 6

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
FLT3-1-E Tyrosine-protein Kinase Receptor FLT3 (cluster #1 Of 1), Eukaryotic Eukaryotes 39 0.32 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
FLT3_HUMAN P36888 Tyrosine-protein Kinase Receptor FLT3, Human 39 0.32 Binding ≤ 1μM
FLT3_HUMAN P36888 Tyrosine-protein Kinase Receptor FLT3, Human 39 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) 4.89 14.14 -51.73 2 4 1 47 433.547 8

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
FLT3-1-E Tyrosine-protein Kinase Receptor FLT3 (cluster #1 Of 1), Eukaryotic Eukaryotes 23 0.46 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
FLT3_HUMAN P36888 Tyrosine-protein Kinase Receptor FLT3, Human 23 0.46 Binding ≤ 1μM
FLT3_HUMAN P36888 Tyrosine-protein Kinase Receptor FLT3, Human 23 0.46 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.55 9.62 -18.07 1 2 0 33 307.299 1

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
FLT3-1-E Tyrosine-protein Kinase Receptor FLT3 (cluster #1 Of 1), Eukaryotic Eukaryotes 470 0.42 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
FLT3_HUMAN P36888 Tyrosine-protein Kinase Receptor FLT3, Human 470 0.42 Binding ≤ 1μM
FLT3_HUMAN P36888 Tyrosine-protein Kinase Receptor FLT3, Human 470 0.42 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.29 9.49 -15.94 1 2 0 33 271.319 1

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

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.20 10.34 -9.9 0 4 0 32 304.397 3

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

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 9.91 -7.91 0 3 0 16 332.447 4

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

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.65 10.16 -7.59 0 2 0 6 320.411 3

Parameters Provided:

ring.id = 131902
filter.purchasability = annotated
page.format = targets
page.num = 1

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 hasring AS hr ON ci.sub_id_fk=hr.sub_id_fk INNER JOIN rings AS r ON hr.rings_fk=r.rings_id  WHERE r.rings_id = 131902 AND c.free = 1 AND c.purchasable = 0    LIMIT 50

Permalink

Embed Link to Results