SELECT clrId, clrcode, clrName FROm tblcolorpattern WHERE active=1 AND clrcode='' AND clrType IN(1,2)<BR>WTE ::: WTE-Solid-White-Jersey-Knit-round-crib.jpg<BR>IVRY ::: IVRY-Solid-Ivory-Jersey-Knit-round-crib.jpg<BR>PK ::: PK-Baby-Pink-Jersey-Knit-round-crib.jpg<BR>BLUE ::: BLUE-Baby-Blue-Jersey-Knit-round-crib.jpg<BR>MNT ::: MNT-Soft-Mint-Jersey-Knit-round-crib.jpg<BR>NVY ::: NVY-Solid-Navy-Jersey-Knit-round-crib.jpg<BR>WD ::: WD-White-Swiss-Dot-Jersey-Knit-round-crib.jpg<BR>PP ::: PP-Pink-Stripes-Jersey-Knit-round-crib.jpg<BR>W1214 ::: W1214-Marvel-Comics-round-crib.jpg<BR>BG ::: BG-Blue-Gingham-Jersey-Knit-round-crib.jpg<BR>YG ::: YG-Yellow-Gingham-Jersey-round-crib.jpg<BR>BP ::: BP-Blue-Pinstripe-Jersey-Knit-round-crib.jpg<BR>PD ::: PD-Pink-Pindot-Jersey-Knit-round-crib.jpg<BR>WS1 ::: WS1-Solid-White-Woven-round-crib.jpg<BR>WS2 ::: WS2-Solid-Ivory-Woven-round-crib.jpg<BR>WS3 ::: WS3-Baby-Pink-Woven-round-crib.jpg<BR>WS4 ::: WS4-Solid-Blue-Woven-round-crib.jpg<BR>WS5 ::: WS5-Solid-Yellow-Woven-round-crib.jpg<BR>WS8 ::: WS8-Solid-Red-Woven-round-crib.jpg<BR>WS15 ::: WS15-Hunter-Green-Woven-round-crib.jpg<BR>WS11 ::: WS11-Solid-Lilac-Woven-round-crib.jpg<BR>WS16 ::: WS16-Solid-Brown-Woven-round-crib.jpg<BR>WS18 ::: WS18-Solid-Navy-Woven-round-crib.jpg<BR>WS9 ::: WS9-Solid-Peach-Woven-round-crib.jpg<BR>WS17 ::: WS17-Solid-Black-Woven-round-crib.jpg<BR>WS12 ::: WS12-Solid-Purple-Woven-round-crib.jpg<BR>WS13 ::: WS13-Wedgewood-Blue-Woven-round-crib.jpg<BR>WS28 ::: WS28-Solid-Orchid-Woven-round-crib.jpg<BR>TW-WTE ::: TW-WTE-Solid-White-Cotton-Jersey-Knit-Twin-round-crib.jpg<BR>BLK ::: BLK-Solid-Black-Jersey-Knit-round-crib.jpg<BR>FS1 ::: FS1-Flannel--White-round-crib.jpg<BR>FS5 ::: FS5-Flannel-FS5--Yellow-round-crib.jpg<BR>PP-QLTD ::: PP-QLTD-White-Quilted-Pack-N-Play-round-crib.jpg<BR>LVDR ::: LVDR-Solid-Lavender-Jersey-Knit-round-crib.jpg<BR>TW-PK ::: TW-PK-Solid-Pink-Cotton-Jersey-Knit-Twin-round-crib.jpg<BR>FS14 ::: FS14-Flannel--Burgundy-round-crib.jpg<BR>IN009 ::: IN009-Space-round-crib.jpg<BR>QLTD ::: QLTD-Quilted-Mattress-Pad-round-crib.jpg<BR>YB-QLTD ::: YB-QLTD-White-Quilted-Youth-Bed-round-crib.jpg<BR>ORG ::: ORG-Solid-Orange-Jersey-Knit-round-crib.jpg<BR>BRN ::: BRN-Solid-Brown-Jersey-Knit-round-crib.jpg<BR>RD ::: RD-Solid-Red-Jersey-Knit-round-crib.jpg<BR>FS13 ::: FS13-Flannel-FS13--Lilac-round-crib.jpg<BR>FS2 ::: FS2-Flannel-FS2--Ivory-round-crib.jpg<BR>FS4 ::: FS4-Flannel-FS4--Blue-round-crib.jpg<BR>FS9 ::: FS9-Flannel-FS9--Aqua-blue-round-crib.jpg<BR>FS8 ::: FS8-Flannel-FS8--Red-round-crib.jpg<BR>BGDY ::: BGDY-Burgundy-Jersey-Knit-round-crib.jpg<BR>FS10 ::: FS10-Flannel--Sage-round-crib.jpg<BR>FS16 ::: FS16-Flannel--Black-round-crib.jpg<BR>FS11 ::: FS11-Flannel--Hunter-Green-round-crib.jpg<BR>FS7 ::: FS7-Flannel60--Navy-round-crib.jpg<BR>DORG ::: DORG-Burnt-Orange-Jersey-Knit-round-crib.jpg<BR>FS3A ::: FS3A-Flannel-FS3A--Hot-Pink-round-crib.jpg<BR>OGC ::: OGC-Organic-White-Jersey-Knit-round-crib.jpg<BR>HPK ::: HPK-Hot-Pink-Jersey-Knit-round-crib.jpg<BR>GY ::: GY-Silver-Grey-Jersey-Knit-round-crib.jpg<BR>W548 ::: W548-Primary-Polka-Dots-Navy-Woven-round-crib.jpg<BR>WS20 ::: WS20-Solid-Orange-Woven-round-crib.jpg<BR>WS21 ::: WS21-Solid-Aqua-Woven-round-crib.jpg<BR>WS3B ::: WS3B-Hot-Pink-Woven-round-crib.jpg<BR>OG-IVRY ::: OG-IVRY-Organic-Ivory-Jersey-Knit-round-crib.jpg<BR>TL ::: TL-Teal-Jersey-Knit-round-crib.jpg<BR>PPL ::: PPL-Purple-Jersey-Knit-round-crib.jpg<BR>DGY ::: DGY-Dark-Grey-Jersey-Knit-round-crib.jpg<BR>OG-BL ::: OG-BL-Organic-Baby-Blue-Jersey-Knit-round-crib.jpg<BR>AQ ::: AQ-Solid-Aqua-Jersey-Knit-round-crib.jpg<BR>WS23 ::: WS23-Solid-Grey-Woven-round-crib.jpg<BR>WS20A ::: WS20A-Deep-Orange-Woven-round-crib.jpg<BR>W814 ::: W814-Pink-Dual-Stripe-round-crib.jpg<BR>WS24 ::: WS24-Solid-Teal-Woven-round-crib.jpg<BR>W104 ::: W104-Burgundy-Chevron-Zigzag-round-crib.jpg<BR>W107 ::: W107-Brown-Chevron-Zigzag-round-crib.jpg<BR>W111 ::: W111-Hunter-Green-Chevron-Zigzag-round-crib.jpg<BR>W117 ::: W117-Purple-Chevron-Zigzag-round-crib.jpg<BR>TW-IVY ::: TW-IVY-Solid-Ivory-Cotton-Jersey-Knit-Twin-round-crib.jpg<BR>TW-BL ::: TW-BL-Baby-Blue-Cotton-Jersey-Knit-Twin-round-crib.jpg<BR>TW-YLW ::: TW-YLW-Soft-Yellow-Cotton-Jersey-Knit-Twin-round-crib.jpg<BR>TW-MNT ::: TW-MNT-Soft-Mint-Cotton-Jersey-Knit-Twin-round-crib.jpg<BR>TW-NVY ::: TW-NVY-Solid-Navy-Cotton-Jersey-Knit-Twin-round-crib.jpg<BR>TW-RD ::: TW-RD-Solid-Red-Cotton-Jersey-Knit-Twin-round-crib.jpg<BR>TW-SG ::: TW-SG-Solid-Sage-Cotton-Jersey-Knit-Twin-round-crib.jpg<BR>TW-AQ ::: TW-AQ-Solid-Aqua-Cotton-Jersey-Knit-Twin-round-crib.jpg<BR>TW-GY ::: TW-GY-Silver-Grey-Cotton-Jersey-Knit-Twin-round-crib.jpg<BR>TW-DGY ::: TW-DGY-Dark-Grey-Cotton-Jersey-Knit-Twin-round-crib.jpg<BR>TW-ORG ::: TW-ORG-Solid-Orange-Cotton-Jersey-Knit-Twin-round-crib.jpg<BR>TW-DORG ::: TW-DORG-Burnt-Orange-Cotton-Jersey-Knit-Twin-round-crib.jpg<BR>TW-HPK ::: TW-HPK-Hot-Pink-Cotton-Jersey-Knit-Twin-round-crib.jpg<BR>TW-BGDY ::: TW-BGDY-Solid-Burgundy-Cotton-Jersey-Knit-Twin-round-crib.jpg<BR>TW-BRN ::: TW-BRN-Solid-Brown-Cotton-Jersey-Knit-Twin-round-crib.jpg<BR>TW-BLK ::: TW-BLK-Solid-Black-Cotton-Jersey-Knit-Twin-round-crib.jpg<BR>F425 ::: F425-Argyle-Transport-round-crib.jpg<BR>F426 ::: F426-Argyle-Transport-Blue-round-crib.jpg<BR>W885 ::: W885-Argyle-Brown-Transport-round-crib.jpg<BR>TQ ::: TQ-Turquoise-Jersey-Knit-round-crib.jpg<BR>W910 ::: W910-Polka-Dots-Black-round-crib.jpg<BR>W913 ::: W913-Polka-Dots-Burgundy-round-crib.jpg<BR>W916 ::: W916-Polka-Dots-Grey-round-crib.jpg<BR>W917 ::: W917-Polka-Dots-Hot-Pink-round-crib.jpg<BR>W918 ::: W918-Polka-Dots-Hunter-Green-round-crib.jpg<BR>W920 ::: W920-Polka-Dots-Lime-round-crib.jpg<BR>W921 ::: W921-Polka-Dots-Navy-round-crib.jpg<BR>W923 ::: W923-Polka-Dots-Pink-round-crib.jpg<BR>W924 ::: W924-Polka-Dots-Purple-round-crib.jpg<BR>WS26 ::: WS26-Dark-Grey-Woven-round-crib.jpg<BR>WS27 ::: WS27-Turquoise-Woven-round-crib.jpg<BR>W945 ::: W945-Purple-Gingham-Check-round-crib.jpg<BR>W970 ::: W970-Navy-Honeycomb-round-crib.jpg<BR>W976 ::: W976-Green-Honeycomb-round-crib.jpg<BR>W983 ::: W983-Hot-Pink-Honeycomb-round-crib.jpg<BR>W985 ::: W985-Sage-Honeycomb-round-crib.jpg<BR>W131 ::: W131-Black-Links-round-crib.jpg<BR>W134 ::: W134-Red-Links-round-crib.jpg<BR>W137 ::: W137-Sage-Links-round-crib.jpg<BR>W140 ::: W140-Green-Links-round-crib.jpg<BR>W141 ::: W141-Purple-Links-round-crib.jpg<BR>W146 ::: W146-Citrus-Links-round-crib.jpg<BR>W154 ::: W154-Hunter-Green-Polka-Dots-round-crib.jpg<BR>W1242 ::: W1242-Paisley-Red-round-crib.jpg<BR>W989 ::: W989-Brown-Damask-round-crib.jpg<BR>W990 ::: W990-Purple-Damask-round-crib.jpg<BR>W994 ::: W994-Red-Damask-round-crib.jpg<BR>W995 ::: W995-White-Damask-round-crib.jpg<BR>W997 ::: W997-Turquoise-Damask-round-crib.jpg<BR>TW-OG-ECRU ::: TW-OG-ECRU-Organic-Ivory-Cotton-Jersey-Knit-Twin-round-crib.jpg<BR>TW-OG-WTE ::: TW-OG-WTE-Organic-White-Cotton-Jersey-Knit-Twin-round-crib.jpg<BR>TW-WD ::: TW-WD-White-Swiss-Dot-Jersey-Knit-Twin-round-crib.jpg<BR>TW-TL ::: TW-TL-Teal-Cotton-Jersey-Knit-Twin-round-crib.jpg<BR>TW-PPL ::: TW-PPL-Purple-Cotton-Jersey-Knit-Twin-round-crib.jpg<BR>TW-OG-BL ::: TW-OG-BL-Organic-Baby-Blue-Cotton-Jersey-Knit-Twin-round-crib.jpg<BR>TW-TQ ::: TW-TQ-Turquoise-Cotton-Jersey-Knit-Twin-round-crib.jpg<BR>TW-PD ::: TW-PD-Pink-Pindot-Cotton-Jersey-Knit-Twin-round-crib.jpg<BR>TW-BG ::: TW-BG-Blue-Gingham-Jersey-Knit-Twin-round-crib.jpg<BR>W1010 ::: W1010-Neon-Green-Polka-Dots-round-crib.jpg<BR>W15 ::: W15-Grey-Dot-Circles-round-crib.jpg<BR>W16 ::: W16-Grey-Floral-Stems-round-crib.jpg<BR>W17 ::: W17-Grey-Multi-Circles-round-crib.jpg<BR>W19 ::: W19-White-On-White-Multi-Circles-round-crib.jpg<BR>GNG ::: GNG-Sage-Gingham-Jersey-Knit-round-crib.jpg<BR>FS23 ::: FS23-Flannel--Dark-Grey-round-crib.jpg<BR>W118 ::: W118-Grey-Chevron-Zigzag-round-crib.jpg<BR>TW-WS1 ::: TW-WS1-Solid-White-Cotton-Woven-round-crib.jpg<BR>F540 ::: F540-Vehicles-Cream-round-crib.jpg<BR>F539 ::: F539-Argyle-Transport-Brown-round-crib.jpg<BR>TW-W16 ::: TW-W16-Grey-Floral-Stems-Cotton-Woven-Twin-round-crib.jpg<BR>TW-W15 ::: TW-W15-Grey-Dot-Circles-Cotton-Woven-Twin-round-crib.jpg<BR>F544 ::: F544-Vehicles-Blue-round-crib.jpg<BR>F546 ::: F546-Sports-Blue-Grid-round-crib.jpg<BR>F545 ::: F545-Sports-Green-Grid-round-crib.jpg<BR>W1094 ::: W1094-Construction-Zone-round-crib.jpg<BR>W1104 ::: W1104-Sparkly-Pink-Chevron-round-crib.jpg<BR>W1136 ::: W1136-Dump-Trucks-round-crib.jpg<BR>W1153 ::: W1153-Royal-Circle-Swirls-round-crib.jpg<BR>W1194 ::: W1194-Unicorns-round-crib.jpg<BR>W1201 ::: W1201-Little-Mermaid-Damask-round-crib.jpg<BR>F560 ::: F560-Animal-Faces-Pink-round-crib.jpg<BR>F567 ::: F567-Doggy-Play-Blue-round-crib.jpg<BR>F568 ::: F568-Construction-Zone-round-crib.jpg<BR>W1219 ::: W1219-Red-Stars-round-crib.jpg<BR>W1218 ::: W1218-Safari-Animals-Pink-round-crib.jpg<BR>W1221 ::: W1221-Turtles-Black-round-crib.jpg<BR>W1222 ::: W1222-Colored-Stripes-Black-round-crib.jpg<BR>W1223 ::: W1223-Colored-Circles-Black-round-crib.jpg<BR>W1224 ::: W1224-Patriotic-Stars-round-crib.jpg<BR>W1243 ::: W1243-Dots-Hot-Pink-round-crib.jpg<BR>W1226 ::: W1226-Pindots-Black-round-crib.jpg<BR>W1227 ::: W1227-White-On-White-Pindots-round-crib.jpg<BR>W1228 ::: W1228-Stars-Red-round-crib.jpg<BR>W1229 ::: W1229-Gray-Pindots-round-crib.jpg<BR>W1230 ::: W1230-Pindots-Gray-round-crib.jpg<BR>W1231 ::: W1231-Royal-Polka-Dots-round-crib.jpg<BR>W1234 ::: W1234-Puzzle-round-crib.jpg<BR>TW-WS4 ::: TW-WS4-Solid-Blue-Cotton-Woven-round-crib.jpg<BR>WP ::: WP-Waterproof-Mattress-Protector-round-crib.jpg<BR>IN001 ::: IN001-Animal-Fun-round-crib.jpg<BR>IN002 ::: IN002-Baby-Animals-round-crib.jpg<BR>IN003 ::: IN003-Baby-Dinosaurs-round-crib.jpg<BR>IN005 ::: IN005-Dinosaurs-round-crib.jpg<BR>IN008 ::: IN008-Woodland-Bears-round-crib.jpg<BR>IN004 ::: IN004-Construction-Cars-round-crib.jpg<BR>W1236 ::: W1236-Floral-Navy-round-crib.jpg<BR>TW-WS1X ::: TW-WS1X-Snow-White-round-crib.jpg<BR>TW-WS2X ::: TW-WS2X-Camel-round-crib.jpg<BR>TW-WS3X ::: TW-WS3X-Dusty-Rose-round-crib.jpg<BR>TW-WS4X ::: TW-WS4X-Sky-Blue-round-crib.jpg<BR>TW-WS23X ::: TW-WS23X-Solid-Gray-round-crib.jpg<BR>TW-WS13X ::: TW-WS13X-Wedgewood-Blue-round-crib.jpg<BR>TW-WS12X ::: TW-WS12X-Plum-round-crib.jpg<BR>TW-WS15X ::: TW-WS15X-Hunter-Green-round-crib.jpg<BR>TW-WS8X ::: TW-WS8X-Crimson-Red-round-crib.jpg<BR>