SELECT clrcode, clrName FROm tblcolorpattern WHERE active=1 AND clrcode='BG' AND clrType IN(1,2)
BG ::: BG-Blue-Gingham-Jersey-Knit-blanket.jpg
SELECT clrcode, clrName FROm tblcolorpattern WHERE active=1 AND clrcode='WTE' AND clrType IN(1,2)
WTE ::: WTE-Solid-White-Jersey-Knit-blanket.jpg
SELECT clrcode, clrName FROm tblcolorpattern WHERE active=1 AND clrcode='IVY' AND clrType IN(1,2)
::: --blanket.jpg
SELECT clrcode, clrName FROm tblcolorpattern WHERE active=1 AND clrcode='PINK' AND clrType IN(1,2)
::: --blanket.jpg
SELECT clrcode, clrName FROm tblcolorpattern WHERE active=1 AND clrcode='BLUE' AND clrType IN(1,2)
BLUE ::: BLUE-Baby-Blue-Jersey-Knit-blanket.jpg
SELECT clrcode, clrName FROm tblcolorpattern WHERE active=1 AND clrcode='YLW' AND clrType IN(1,2)
::: --blanket.jpg
SELECT clrcode, clrName FROm tblcolorpattern WHERE active=1 AND clrcode='NVY' AND clrType IN(1,2)
NVY ::: NVY-Solid-Navy-Jersey-Knit-blanket.jpg
SELECT clrcode, clrName FROm tblcolorpattern WHERE active=1 AND clrcode='AQ' AND clrType IN(1,2)
AQ ::: AQ-Solid-Aqua-Jersey-Knit-blanket.jpg
SELECT clrcode, clrName FROm tblcolorpattern WHERE active=1 AND clrcode='BGDY' AND clrType IN(1,2)
BGDY ::: BGDY-Burgundy-Jersey-Knit-blanket.jpg
SELECT clrcode, clrName FROm tblcolorpattern WHERE active=1 AND clrcode='BLK' AND clrType IN(1,2)
BLK ::: BLK-Solid-Black-Jersey-Knit-blanket.jpg
SELECT clrcode, clrName FROm tblcolorpattern WHERE active=1 AND clrcode='BRN' AND clrType IN(1,2)
BRN ::: BRN-Solid-Brown-Jersey-Knit-blanket.jpg
SELECT clrcode, clrName FROm tblcolorpattern WHERE active=1 AND clrcode='DGY' AND clrType IN(1,2)
DGY ::: DGY-Dark-Grey-Jersey-Knit-blanket.jpg
SELECT clrcode, clrName FROm tblcolorpattern WHERE active=1 AND clrcode='DORG' AND clrType IN(1,2)
DORG ::: DORG-Burnt-Orange-Jersey-Knit-blanket.jpg
SELECT clrcode, clrName FROm tblcolorpattern WHERE active=1 AND clrcode='GY' AND clrType IN(1,2)
GY ::: GY-Silver-Grey-Jersey-Knit-blanket.jpg
SELECT clrcode, clrName FROm tblcolorpattern WHERE active=1 AND clrcode='HPK' AND clrType IN(1,2)
HPK ::: HPK-Hot-Pink-Jersey-Knit-blanket.jpg
SELECT clrcode, clrName FROm tblcolorpattern WHERE active=1 AND clrcode='LVDR' AND clrType IN(1,2)
LVDR ::: LVDR-Solid-Lavender-Jersey-Knit-blanket.jpg
SELECT clrcode, clrName FROm tblcolorpattern WHERE active=1 AND clrcode='ORG' AND clrType IN(1,2)
ORG ::: ORG-Solid-Orange-Jersey-Knit-blanket.jpg
SELECT clrcode, clrName FROm tblcolorpattern WHERE active=1 AND clrcode='PPL' AND clrType IN(1,2)
PPL ::: PPL-Purple-Jersey-Knit-blanket.jpg
SELECT clrcode, clrName FROm tblcolorpattern WHERE active=1 AND clrcode='RD' AND clrType IN(1,2)
RD ::: RD-Solid-Red-Jersey-Knit-blanket.jpg
SELECT clrcode, clrName FROm tblcolorpattern WHERE active=1 AND clrcode='SG' AND clrType IN(1,2)
::: --blanket.jpg
SELECT clrcode, clrName FROm tblcolorpattern WHERE active=1 AND clrcode='TL' AND clrType IN(1,2)
TL ::: TL-Teal-Jersey-Knit-blanket.jpg
SELECT clrcode, clrName FROm tblcolorpattern WHERE active=1 AND clrcode='PD' AND clrType IN(1,2)
PD ::: PD-Pink-Pindot-Jersey-Knit-blanket.jpg
SELECT clrcode, clrName FROm tblcolorpattern WHERE active=1 AND clrcode='WD' AND clrType IN(1,2)
WD ::: WD-White-Swiss-Dot-Jersey-Knit-blanket.jpg
SELECT clrcode, clrName FROm tblcolorpattern WHERE active=1 AND clrcode='TQ' AND clrType IN(1,2)
TQ ::: TQ-Turquoise-Jersey-Knit-blanket.jpg
SELECT clrcode, clrName FROm tblcolorpattern WHERE active=1 AND clrcode='F544' AND clrType IN(1,2)
F544 ::: F544-Vehicles-Blue-blanket.jpg
SELECT clrcode, clrName FROm tblcolorpattern WHERE active=1 AND clrcode='F544' AND clrType IN(1,2)
F544 ::: F544-Vehicles-Blue-blanket.jpg
SELECT clrcode, clrName FROm tblcolorpattern WHERE active=1 AND clrcode='MNT' AND clrType IN(1,2)
MNT ::: MNT-Soft-Mint-Jersey-Knit-blanket.jpg
SELECT clrcode, clrName FROm tblcolorpattern WHERE active=1 AND clrcode='SGM' AND clrType IN(1,2)
::: --blanket.jpg
SELECT clrcode, clrName FROm tblcolorpattern WHERE active=1 AND clrcode='GP' AND clrType IN(1,2)
::: --blanket.jpg