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
KIT-1-E Stem Cell Growth Factor Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 75 0.25 Binding ≤ 10μM
VGFR1-1-E Vascular Endothelial Growth Factor Receptor 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 59 0.25 Binding ≤ 10μM
VGFR2-1-E Vascular Endothelial Growth Factor Receptor 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 35 0.26 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
KIT_HUMAN P10721 Stem Cell Growth Factor Receptor, Human 75 0.25 Binding ≤ 1μM
VGFR1_HUMAN P17948 Vascular Endothelial Growth Factor Receptor 1, Human 59 0.25 Binding ≤ 1μM
VGFR2_HUMAN P35968 Vascular Endothelial Growth Factor Receptor 2, Human 198 0.23 Binding ≤ 1μM
KIT_HUMAN P10721 Stem Cell Growth Factor Receptor, Human 75 0.25 Binding ≤ 10μM
VGFR1_HUMAN P17948 Vascular Endothelial Growth Factor Receptor 1, Human 59 0.25 Binding ≤ 10μM
VGFR2_HUMAN P35968 Vascular Endothelial Growth Factor Receptor 2, Human 198 0.23 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.89 15.44 -47.77 3 7 1 69 555.772 8
Hi High (pH 8-9.5) 5.89 13.06 -14.24 2 7 0 67 554.764 8
Mid Mid (pH 6-8) 5.89 15.31 -53.76 3 7 1 69 555.772 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
KIT-1-E Stem Cell Growth Factor Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 237 0.24 Binding ≤ 10μM
VGFR1-1-E Vascular Endothelial Growth Factor Receptor 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 1351 0.21 Binding ≤ 10μM
VGFR2-1-E Vascular Endothelial Growth Factor Receptor 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 259 0.24 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
KIT_HUMAN P10721 Stem Cell Growth Factor Receptor, Human 237 0.24 Binding ≤ 1μM
VGFR2_HUMAN P35968 Vascular Endothelial Growth Factor Receptor 2, Human 259 0.24 Binding ≤ 1μM
KIT_HUMAN P10721 Stem Cell Growth Factor Receptor, Human 237 0.24 Binding ≤ 10μM
VGFR1_HUMAN P17948 Vascular Endothelial Growth Factor Receptor 1, Human 1351 0.21 Binding ≤ 10μM
VGFR2_HUMAN P35968 Vascular Endothelial Growth Factor Receptor 2, Human 259 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) 4.97 13.28 -45.19 3 8 1 78 543.717 7
Hi High (pH 8-9.5) 4.97 10.89 -13.71 2 8 0 77 542.709 7
Mid Mid (pH 6-8) 4.97 13.14 -50.72 3 8 1 78 543.717 7

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
KIT-1-E Stem Cell Growth Factor Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 5710 0.19 Binding ≤ 10μM
VGFR1-1-E Vascular Endothelial Growth Factor Receptor 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 4953 0.20 Binding ≤ 10μM
VGFR2-1-E Vascular Endothelial Growth Factor Receptor 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 122 0.25 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
VGFR2_HUMAN P35968 Vascular Endothelial Growth Factor Receptor 2, Human 122 0.25 Binding ≤ 1μM
KIT_HUMAN P10721 Stem Cell Growth Factor Receptor, Human 5710 0.19 Binding ≤ 10μM
VGFR1_HUMAN P17948 Vascular Endothelial Growth Factor Receptor 1, Human 4953 0.20 Binding ≤ 10μM
VGFR2_HUMAN P35968 Vascular Endothelial Growth Factor Receptor 2, Human 122 0.25 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.99 13.91 -47.14 3 7 1 69 527.718 6
Hi High (pH 8-9.5) 4.99 11.52 -15.92 2 7 0 67 526.71 6
Mid Mid (pH 6-8) 4.99 13.77 -51.94 3 7 1 69 527.718 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
VGFR1-1-E Vascular Endothelial Growth Factor Receptor 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 1590 0.20 Binding ≤ 10μM
VGFR2-1-E Vascular Endothelial Growth Factor Receptor 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 164 0.23 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
VGFR2_HUMAN P35968 Vascular Endothelial Growth Factor Receptor 2, Human 164 0.23 Binding ≤ 1μM
VGFR1_HUMAN P17948 Vascular Endothelial Growth Factor Receptor 1, Human 1590 0.20 Binding ≤ 10μM
VGFR2_HUMAN P35968 Vascular Endothelial Growth Factor Receptor 2, Human 164 0.23 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.13 16.2 -46.49 3 7 1 69 569.799 8
Hi High (pH 8-9.5) 6.13 13.82 -14.62 2 7 0 67 568.791 8
Mid Mid (pH 6-8) 6.13 16.07 -50.96 3 7 1 69 569.799 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
VGFR1-1-E Vascular Endothelial Growth Factor Receptor 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 3842 0.20 Binding ≤ 10μM
VGFR2-1-E Vascular Endothelial Growth Factor Receptor 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 180 0.25 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
VGFR2_HUMAN P35968 Vascular Endothelial Growth Factor Receptor 2, Human 180 0.25 Binding ≤ 1μM
VGFR1_HUMAN P17948 Vascular Endothelial Growth Factor Receptor 1, Human 3842 0.20 Binding ≤ 10μM
VGFR2_HUMAN P35968 Vascular Endothelial Growth Factor Receptor 2, Human 180 0.25 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.22 13.65 -46.17 3 7 1 69 548.136 6
Hi High (pH 8-9.5) 5.22 11.26 -13.05 2 7 0 67 547.128 6
Mid Mid (pH 6-8) 5.22 13.51 -52.78 3 7 1 69 548.136 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
KIT-1-E Stem Cell Growth Factor Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 9746 0.18 Binding ≤ 10μM
VGFR1-1-E Vascular Endothelial Growth Factor Receptor 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 2824 0.19 Binding ≤ 10μM
VGFR2-1-E Vascular Endothelial Growth Factor Receptor 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 123 0.24 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
VGFR2_HUMAN P35968 Vascular Endothelial Growth Factor Receptor 2, Human 123 0.24 Binding ≤ 1μM
KIT_HUMAN P10721 Stem Cell Growth Factor Receptor, Human 9746 0.18 Binding ≤ 10μM
VGFR1_HUMAN P17948 Vascular Endothelial Growth Factor Receptor 1, Human 2824 0.19 Binding ≤ 10μM
VGFR2_HUMAN P35968 Vascular Endothelial Growth Factor Receptor 2, Human 123 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.69 14.93 -47.73 3 7 1 69 555.772 7
Hi High (pH 8-9.5) 5.69 12.55 -14.49 2 7 0 67 554.764 7
Mid Mid (pH 6-8) 5.69 14.8 -54.01 3 7 1 69 555.772 7

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
KIT-1-E Stem Cell Growth Factor Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 4843 0.18 Binding ≤ 10μM
VGFR1-1-E Vascular Endothelial Growth Factor Receptor 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 3615 0.18 Binding ≤ 10μM
VGFR2-1-E Vascular Endothelial Growth Factor Receptor 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 262 0.22 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
VGFR2_HUMAN P35968 Vascular Endothelial Growth Factor Receptor 2, Human 262 0.22 Binding ≤ 1μM
KIT_HUMAN P10721 Stem Cell Growth Factor Receptor, Human 4843 0.18 Binding ≤ 10μM
VGFR1_HUMAN P17948 Vascular Endothelial Growth Factor Receptor 1, Human 3615 0.18 Binding ≤ 10μM
VGFR2_HUMAN P35968 Vascular Endothelial Growth Factor Receptor 2, Human 262 0.22 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.67 16.7 -46.57 3 7 1 69 583.826 9
Hi High (pH 8-9.5) 6.67 14.32 -14.59 2 7 0 67 582.818 9
Mid Mid (pH 6-8) 6.67 16.57 -51.05 3 7 1 69 583.826 9

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
KIT-1-E Stem Cell Growth Factor Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 25 0.25 Binding ≤ 10μM
VGFR1-1-E Vascular Endothelial Growth Factor Receptor 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 33 0.25 Binding ≤ 10μM
VGFR2-1-E Vascular Endothelial Growth Factor Receptor 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 233 0.22 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
KIT_HUMAN P10721 Stem Cell Growth Factor Receptor, Human 25 0.25 Binding ≤ 1μM
VGFR1_HUMAN P17948 Vascular Endothelial Growth Factor Receptor 1, Human 33 0.25 Binding ≤ 1μM
VGFR2_HUMAN P35968 Vascular Endothelial Growth Factor Receptor 2, Human 20 0.26 Binding ≤ 1μM
KIT_HUMAN P10721 Stem Cell Growth Factor Receptor, Human 25 0.25 Binding ≤ 10μM
VGFR1_HUMAN P17948 Vascular Endothelial Growth Factor Receptor 1, Human 33 0.25 Binding ≤ 10μM
VGFR2_HUMAN P35968 Vascular Endothelial Growth Factor Receptor 2, Human 20 0.26 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.57 14.06 -49.95 3 7 1 69 599.678 7
Hi High (pH 8-9.5) 5.57 11.7 -14.56 2 7 0 67 598.67 7
Mid Mid (pH 6-8) 5.57 13.92 -55 3 7 1 69 599.678 7

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
KIT-1-E Stem Cell Growth Factor Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 56 0.24 Binding ≤ 10μM
VGFR1-1-E Vascular Endothelial Growth Factor Receptor 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 19 0.26 Binding ≤ 10μM
VGFR2-1-E Vascular Endothelial Growth Factor Receptor 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 27 0.25 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
KIT_HUMAN P10721 Stem Cell Growth Factor Receptor, Human 56 0.24 Binding ≤ 1μM
VGFR1_HUMAN P17948 Vascular Endothelial Growth Factor Receptor 1, Human 19 0.26 Binding ≤ 1μM
VGFR2_HUMAN P35968 Vascular Endothelial Growth Factor Receptor 2, Human 218 0.22 Binding ≤ 1μM
KIT_HUMAN P10721 Stem Cell Growth Factor Receptor, Human 56 0.24 Binding ≤ 10μM
VGFR1_HUMAN P17948 Vascular Endothelial Growth Factor Receptor 1, Human 19 0.26 Binding ≤ 10μM
VGFR2_HUMAN P35968 Vascular Endothelial Growth Factor Receptor 2, Human 218 0.22 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.53 12.78 -51.35 3 8 1 78 597.687 8
Hi High (pH 8-9.5) 5.53 10.41 -16.27 2 8 0 77 596.679 8
Mid Mid (pH 6-8) 5.53 12.65 -56.69 3 8 1 78 597.687 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
VGFR2-1-E Vascular Endothelial Growth Factor Receptor 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 7458 0.18 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
VGFR2_HUMAN P35968 Vascular Endothelial Growth Factor Receptor 2, Human 7458 0.18 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.26 14.51 -47.78 2 7 1 60 541.745 6
Hi High (pH 8-9.5) 5.26 12.13 -16.88 1 7 0 59 540.737 6
Mid Mid (pH 6-8) 5.26 14.38 -52.79 2 7 1 60 541.745 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
KIT-1-E Stem Cell Growth Factor Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 139 0.25 Binding ≤ 10μM
VGFR2-1-E Vascular Endothelial Growth Factor Receptor 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 4807 0.20 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
KIT_HUMAN P10721 Stem Cell Growth Factor Receptor, Human 139 0.25 Binding ≤ 1μM
KIT_HUMAN P10721 Stem Cell Growth Factor Receptor, Human 139 0.25 Binding ≤ 10μM
VGFR2_HUMAN P35968 Vascular Endothelial Growth Factor Receptor 2, Human 4807 0.20 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.01 13.29 -47.09 3 7 1 69 527.718 6
Hi High (pH 8-9.5) 5.01 10.9 -13.04 2 7 0 67 526.71 6
Mid Mid (pH 6-8) 5.01 13.15 -51.21 3 7 1 69 527.718 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
KIT-1-E Stem Cell Growth Factor Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 2190 0.20 Binding ≤ 10μM
VGFR1-1-E Vascular Endothelial Growth Factor Receptor 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 131 0.25 Binding ≤ 10μM
VGFR2-1-E Vascular Endothelial Growth Factor Receptor 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 45 0.26 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
VGFR1_HUMAN P17948 Vascular Endothelial Growth Factor Receptor 1, Human 131 0.25 Binding ≤ 1μM
VGFR2_HUMAN P35968 Vascular Endothelial Growth Factor Receptor 2, Human 45 0.26 Binding ≤ 1μM
KIT_HUMAN P10721 Stem Cell Growth Factor Receptor, Human 2190 0.20 Binding ≤ 10μM
VGFR1_HUMAN P17948 Vascular Endothelial Growth Factor Receptor 1, Human 131 0.25 Binding ≤ 10μM
VGFR2_HUMAN P35968 Vascular Endothelial Growth Factor Receptor 2, Human 45 0.26 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.39 14.68 -48.14 3 7 1 69 541.745 7
Hi High (pH 8-9.5) 5.39 12.3 -14.66 2 7 0 67 540.737 7
Mid Mid (pH 6-8) 5.39 14.55 -54.24 3 7 1 69 541.745 7

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
VGFR1-1-E Vascular Endothelial Growth Factor Receptor 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 2263 0.19 Binding ≤ 10μM
VGFR2-1-E Vascular Endothelial Growth Factor Receptor 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 171 0.23 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
VGFR2_HUMAN P35968 Vascular Endothelial Growth Factor Receptor 2, Human 171 0.23 Binding ≤ 1μM
VGFR1_HUMAN P17948 Vascular Endothelial Growth Factor Receptor 1, Human 2263 0.19 Binding ≤ 10μM
VGFR2_HUMAN P35968 Vascular Endothelial Growth Factor Receptor 2, Human 171 0.23 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.00 13.83 -47.42 3 8 1 78 571.771 9
Hi High (pH 8-9.5) 5.00 11.44 -15.4 2 8 0 77 570.763 9
Mid Mid (pH 6-8) 5.00 13.69 -51.6 3 8 1 78 571.771 9

Parameters Provided:

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

Permalink

Embed Link to Results