UCSF
ZINC Item Suppliers, Protomers, & Similar Substances

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
GRM5-3-E Metabotropic Glutamate Receptor 5 (cluster #3 Of 5), Eukaryotic Eukaryotes 23 0.71 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
GRM5_HUMAN P41594 Metabotropic Glutamate Receptor 5, Human 23 0.71 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.39 7.54 -8.69 0 1 0 13 217.268 0

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
GRM5-3-E Metabotropic Glutamate Receptor 5 (cluster #3 Of 5), Eukaryotic Eukaryotes 2966 0.52 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
GRM5_HUMAN P41594 Metabotropic Glutamate Receptor 5, Human 2966 0.52 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.41 7.54 -7.33 0 1 0 13 217.268 0

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
GRM5-3-E Metabotropic Glutamate Receptor 5 (cluster #3 Of 5), Eukaryotic Eukaryotes 140 0.64 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
GRM5_HUMAN P41594 Metabotropic Glutamate Receptor 5, Human 140 0.64 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.37 7.52 -10.76 0 1 0 13 217.268 0

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
GRM5-3-E Metabotropic Glutamate Receptor 5 (cluster #3 Of 5), Eukaryotic Eukaryotes 25 0.67 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
GRM5_HUMAN P41594 Metabotropic Glutamate Receptor 5, Human 25.3 0.66 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.51 7.61 -6.35 0 1 0 13 235.258 0

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
GRM5-3-E Metabotropic Glutamate Receptor 5 (cluster #3 Of 5), Eukaryotic Eukaryotes 49 0.64 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
GRM5_HUMAN P41594 Metabotropic Glutamate Receptor 5, Human 49 0.64 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.28 6.77 -9.3 0 2 0 22 229.304 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
GRM5-3-E Metabotropic Glutamate Receptor 5 (cluster #3 Of 5), Eukaryotic Eukaryotes 36 0.65 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
GRM5_HUMAN P41594 Metabotropic Glutamate Receptor 5, Human 36.3 0.65 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.26 6.81 -11.08 0 2 0 22 229.304 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
GRM5-3-E Metabotropic Glutamate Receptor 5 (cluster #3 Of 5), Eukaryotic Eukaryotes 10 0.75 Binding ≤ 10μM
GRM5-3-E Metabotropic Glutamate Receptor 5 (cluster #3 Of 5), Eukaryotic Eukaryotes 83 0.66 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
GRM5_RAT P31424 Metabotropic Glutamate Receptor 5, Rat 10 0.75 Binding ≤ 1μM
GRM5_RAT P31424 Metabotropic Glutamate Receptor 5, Rat 10 0.75 Binding ≤ 10μM
GRM5_HUMAN P41594 Metabotropic Glutamate Receptor 5, Human 2 0.81 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.68 8.14 -8.36 0 1 0 13 213.305 0

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
GRM5-3-E Metabotropic Glutamate Receptor 5 (cluster #3 Of 5), Eukaryotic Eukaryotes 129 0.64 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
GRM5_HUMAN P41594 Metabotropic Glutamate Receptor 5, Human 129 0.64 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.90 7.99 -8.15 0 1 0 13 233.723 0

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
GRM5-3-E Metabotropic Glutamate Receptor 5 (cluster #3 Of 5), Eukaryotic Eukaryotes 413 0.50 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
GRM5_HUMAN P41594 Metabotropic Glutamate Receptor 5, Human 413 0.50 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.12 8.48 -8.88 0 1 0 13 267.275 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
GRM5-3-E Metabotropic Glutamate Receptor 5 (cluster #3 Of 5), Eukaryotic Eukaryotes 266 0.48 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
GRM5_HUMAN P41594 Metabotropic Glutamate Receptor 5, Human 266 0.48 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.20 7.27 -7.17 0 2 0 22 283.274 2

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
GRM5-3-E Metabotropic Glutamate Receptor 5 (cluster #3 Of 5), Eukaryotic Eukaryotes 0 0.00 Binding ≤ 10μM
GRM5-3-E Metabotropic Glutamate Receptor 5 (cluster #3 Of 5), Eukaryotic Eukaryotes 1 0.79 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
GRM5_RAT P31424 Metabotropic Glutamate Receptor 5, Rat 0.25 0.84 Binding ≤ 1μM
GRM5_HUMAN P41594 Metabotropic Glutamate Receptor 5, Human 0.37 0.83 Binding ≤ 1μM
GRM5_HUMAN P41594 Metabotropic Glutamate Receptor 5, Human 0.37 0.83 Binding ≤ 10μM
GRM5_RAT P31424 Metabotropic Glutamate Receptor 5, Rat 0.25 0.84 Binding ≤ 10μM
GRM5_HUMAN P41594 Metabotropic Glutamate Receptor 5, Human 0.94 0.79 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.98 7.86 -9.98 0 2 0 37 224.288 0

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
GRM5-3-E Metabotropic Glutamate Receptor 5 (cluster #3 Of 5), Eukaryotic Eukaryotes 2020 0.44 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
GRM5_HUMAN P41594 Metabotropic Glutamate Receptor 5, Human 2020 0.44 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.45 6.36 -16.64 1 3 0 42 256.33 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
GRM5-3-E Metabotropic Glutamate Receptor 5 (cluster #3 Of 5), Eukaryotic Eukaryotes 654 0.58 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
GRM5_HUMAN P41594 Metabotropic Glutamate Receptor 5, Human 654 0.58 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.75 4.62 -9.45 1 2 0 33 215.277 0

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
GRM5-3-E Metabotropic Glutamate Receptor 5 (cluster #3 Of 5), Eukaryotic Eukaryotes 1000 0.49 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
GRM5_HUMAN P41594 Metabotropic Glutamate Receptor 5, Human 1000 0.49 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.05 4.25 -16.78 2 3 0 56 242.303 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
GRM5-3-E Metabotropic Glutamate Receptor 5 (cluster #3 Of 5), Eukaryotic Eukaryotes 79 0.66 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
GRM5_HUMAN P41594 Metabotropic Glutamate Receptor 5, Human 78.6 0.66 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.28 6.01 -8.95 2 2 0 39 218.256 0
Lo Low (pH 4.5-6) 2.28 6.26 -31.06 3 2 1 40 219.264 0

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
GRM5-3-E Metabotropic Glutamate Receptor 5 (cluster #3 Of 5), Eukaryotic Eukaryotes 526 0.59 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
GRM5_HUMAN P41594 Metabotropic Glutamate Receptor 5, Human 526 0.59 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.61 7.39 -7.88 0 1 0 13 282.137 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) 1.98 5.67 -12.65 1 2 0 33 257.289 0

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
GRM5-3-E Metabotropic Glutamate Receptor 5 (cluster #3 Of 5), Eukaryotic Eukaryotes 2920 0.48 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
GRM5_HUMAN P41594 Metabotropic Glutamate Receptor 5, Human 2920 0.48 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.17 8.06 -11.17 0 1 0 13 227.263 0

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
GRM5-3-E Metabotropic Glutamate Receptor 5 (cluster #3 Of 5), Eukaryotic Eukaryotes 4 0.73 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
GRM5_RAT P31424 Metabotropic Glutamate Receptor 5, Rat 4.2 0.73 Binding ≤ 1μM
GRM5_RAT P31424 Metabotropic Glutamate Receptor 5, Rat 4.2 0.73 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.47 8.08 -9.49 0 2 0 37 336.157 0

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
GRM5-5-E Metabotropic Glutamate Receptor 5 (cluster #5 Of 5), Eukaryotic Eukaryotes 1 0.74 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
GRM5_RAT P31424 Metabotropic Glutamate Receptor 5, Rat 1.3 0.73 Binding ≤ 1μM
GRM5_RAT P31424 Metabotropic Glutamate Receptor 5, Rat 1.3 0.73 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.59 8.15 -7.99 0 2 0 37 354.147 0

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
GRM5-3-E Metabotropic Glutamate Receptor 5 (cluster #3 Of 5), Eukaryotic Eukaryotes 23 0.63 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
GRM5_RAT P31424 Metabotropic Glutamate Receptor 5, Rat 23.3 0.63 Binding ≤ 1μM
GRM5_RAT P31424 Metabotropic Glutamate Receptor 5, Rat 23.3 0.63 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.68 8.86 -13.45 0 2 0 37 350.184 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
GRM5-2-E Metabotropic Glutamate Receptor 5 (cluster #2 Of 5), Eukaryotic Eukaryotes 133 0.60 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
GRM5_RAT P31424 Metabotropic Glutamate Receptor 5, Rat 132.9 0.60 Binding ≤ 1μM
GRM5_RAT P31424 Metabotropic Glutamate Receptor 5, Rat 132.9 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) 3.77 6.99 -9.09 0 2 0 22 341.173 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
GRM5-3-E Metabotropic Glutamate Receptor 5 (cluster #3 Of 5), Eukaryotic Eukaryotes 2 0.76 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
GRM5_RAT P31424 Metabotropic Glutamate Receptor 5, Rat 1.6 0.77 Binding ≤ 1μM
GRM5_RAT P31424 Metabotropic Glutamate Receptor 5, Rat 1.6 0.77 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.55 7.07 -11.92 0 2 0 37 228.251 0

Parameters Provided:

ring.id = 224878
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 = 224878 AND c.free = 1 AND c.purchasable = 0    LIMIT 50

Permalink

Embed Link to Results