JiaBoo: Your Best Sourcing Partner in China on Building Materials, Decorative Materials, Combo Recommendations, etc.

Sort by Category

Sort by Brand

Ceramic Tile
Floor Tile | Wall Tile | Pattern Tile
Stringcourse | Wall/Floor Tile | Mosaic

Sanitary Ware
Basin | Tap & Shower Head | Bathtub
Toilet | Squatting Pan | Bidet | Urinal
Mop Sink | Bathroom Cabinet
Bathroom Mirror
Shower Room & Shower Bath
Sanitary Hardware

Lamp/Switch/Ceiling
Paddle Board | Lamp | Switch | Socket
TV Socket | Tele Socket
Internet Socket | A/C Socket
Speaker Socket | Ceiling

Furniture
Feather Sofa | Tea Table | Bookcase
TV Cabinet | Shoecase | Side Cabinet
Drinks Cabinet | Computer Desk
Wardrobe | Mattress | Others

Ceramic Tile
select top 10 ID,E_BrandName from Product_Brand where ID in(92,281,504,378,470,458,212,235,447,490,207,442,299,93,425,210,10,433,296,121,436,290,96,211,219,331,268,45,248,471,446,120,512,492,332,329) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(92,281,504,378,470,458,212,235,447,490,207,442,299,93,425,210,10,433,296,121,436,290,96,211,219,331,268,45,248,471,446,120,512,492,332,329) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(92,281,504,378,470,458,212,235,447,490,207,442,299,93,425,210,10,433,296,121,436,290,96,211,219,331,268,45,248,471,446,120,512,492,332,329) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(92,281,504,378,470,458,212,235,447,490,207,442,299,93,425,210,10,433,296,121,436,290,96,211,219,331,268,45,248,471,446,120,512,492,332,329) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc
Nobel | PLAZA | DongPeng | Vero Tiles

select top 10 ID,E_BrandName from Product_Brand where ID in(92,281,504,378,470,458,212,235,447,490,207,442,299,93,425,210,10,433,296,121,436,290,96,211,219,331,268,45,248,471,446,120,512,492,332,329) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(92,281,504,378,470,458,212,235,447,490,207,442,299,93,425,210,10,433,296,121,436,290,96,211,219,331,268,45,248,471,446,120,512,492,332,329) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(92,281,504,378,470,458,212,235,447,490,207,442,299,93,425,210,10,433,296,121,436,290,96,211,219,331,268,45,248,471,446,120,512,492,332,329) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(92,281,504,378,470,458,212,235,447,490,207,442,299,93,425,210,10,433,296,121,436,290,96,211,219,331,268,45,248,471,446,120,512,492,332,329) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc
Verve Tiles | ROMARIO | KITO | Champion

select top 10 ID,E_BrandName from Product_Brand where ID in(92,281,504,378,470,458,212,235,447,490,207,442,299,93,425,210,10,433,296,121,436,290,96,211,219,331,268,45,248,471,446,120,512,492,332,329) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(92,281,504,378,470,458,212,235,447,490,207,442,299,93,425,210,10,433,296,121,436,290,96,211,219,331,268,45,248,471,446,120,512,492,332,329) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc
CIMIC | Sandebo

Flooring
select top 10 ID,E_BrandName from Product_Brand where ID in(315,15,390,347,132,52,319,41,339,396,62,242,285,191,22,437,351,56,122,337,403,34,303,429,478,509,243,349,443) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(315,15,390,347,132,52,319,41,339,396,62,242,285,191,22,437,351,56,122,337,403,34,303,429,478,509,243,349,443) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(315,15,390,347,132,52,319,41,339,396,62,242,285,191,22,437,351,56,122,337,403,34,303,429,478,509,243,349,443) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(315,15,390,347,132,52,319,41,339,396,62,242,285,191,22,437,351,56,122,337,403,34,303,429,478,509,243,349,443) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc
JiLink | YongJi | HengYi | KRONOSENHUA

select top 10 ID,E_BrandName from Product_Brand where ID in(315,15,390,347,132,52,319,41,339,396,62,242,285,191,22,437,351,56,122,337,403,34,303,429,478,509,243,349,443) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(315,15,390,347,132,52,319,41,339,396,62,242,285,191,22,437,351,56,122,337,403,34,303,429,478,509,243,349,443) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(315,15,390,347,132,52,319,41,339,396,62,242,285,191,22,437,351,56,122,337,403,34,303,429,478,509,243,349,443) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc
LEEKA | ShengHuoJia | Power Dekor

select top 10 ID,E_BrandName from Product_Brand where ID in(315,15,390,347,132,52,319,41,339,396,62,242,285,191,22,437,351,56,122,337,403,34,303,429,478,509,243,349,443) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(315,15,390,347,132,52,319,41,339,396,62,242,285,191,22,437,351,56,122,337,403,34,303,429,478,509,243,349,443) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(315,15,390,347,132,52,319,41,339,396,62,242,285,191,22,437,351,56,122,337,403,34,303,429,478,509,243,349,443) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc
Order | DECK | Der

Sanitary Ware
select top 10 ID,E_BrandName from Product_Brand where ID in(215,487,507,338,473,484,504,441,401,29,493,427,450,32,476,399,187,488,508,113,267,216,502,310,153,133,459,311,65,365,514,460,491,477,202,159,394,305,448,325,122,494,449,31,223,472,203,11,54,395,495,452,260,366,309,466,297,360,220) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(215,487,507,338,473,484,504,441,401,29,493,427,450,32,476,399,187,488,508,113,267,216,502,310,153,133,459,311,65,365,514,460,491,477,202,159,394,305,448,325,122,494,449,31,223,472,203,11,54,395,495,452,260,366,309,466,297,360,220) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(215,487,507,338,473,484,504,441,401,29,493,427,450,32,476,399,187,488,508,113,267,216,502,310,153,133,459,311,65,365,514,460,491,477,202,159,394,305,448,325,122,494,449,31,223,472,203,11,54,395,495,452,260,366,309,466,297,360,220) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(215,487,507,338,473,484,504,441,401,29,493,427,450,32,476,399,187,488,508,113,267,216,502,310,153,133,459,311,65,365,514,460,491,477,202,159,394,305,448,325,122,494,449,31,223,472,203,11,54,395,495,452,260,366,309,466,297,360,220) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc
Delicacy | Haolang | Panasonic | WERFU

select top 10 ID,E_BrandName from Product_Brand where ID in(215,487,507,338,473,484,504,441,401,29,493,427,450,32,476,399,187,488,508,113,267,216,502,310,153,133,459,311,65,365,514,460,491,477,202,159,394,305,448,325,122,494,449,31,223,472,203,11,54,395,495,452,260,366,309,466,297,360,220) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(215,487,507,338,473,484,504,441,401,29,493,427,450,32,476,399,187,488,508,113,267,216,502,310,153,133,459,311,65,365,514,460,491,477,202,159,394,305,448,325,122,494,449,31,223,472,203,11,54,395,495,452,260,366,309,466,297,360,220) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(215,487,507,338,473,484,504,441,401,29,493,427,450,32,476,399,187,488,508,113,267,216,502,310,153,133,459,311,65,365,514,460,491,477,202,159,394,305,448,325,122,494,449,31,223,472,203,11,54,395,495,452,260,366,309,466,297,360,220) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(215,487,507,338,473,484,504,441,401,29,493,427,450,32,476,399,187,488,508,113,267,216,502,310,153,133,459,311,65,365,514,460,491,477,202,159,394,305,448,325,122,494,449,31,223,472,203,11,54,395,495,452,260,366,309,466,297,360,220) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc
Linisi | DongPeng | Moen | Arrow

select top 10 ID,E_BrandName from Product_Brand where ID in(215,487,507,338,473,484,504,441,401,29,493,427,450,32,476,399,187,488,508,113,267,216,502,310,153,133,459,311,65,365,514,460,491,477,202,159,394,305,448,325,122,494,449,31,223,472,203,11,54,395,495,452,260,366,309,466,297,360,220) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(215,487,507,338,473,484,504,441,401,29,493,427,450,32,476,399,187,488,508,113,267,216,502,310,153,133,459,311,65,365,514,460,491,477,202,159,394,305,448,325,122,494,449,31,223,472,203,11,54,395,495,452,260,366,309,466,297,360,220) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc
KOHLER | TOTO

Kitchen Ware
select top 10 ID,E_BrandName from Product_Brand where ID in(430,361,464,158,295,410,461,155,112,29,278,344,481,152,32,513,275,255,341,149,276,273,150,187,233,445,359,382,259,267,156,462,87,356,310,479,439,482,90,503,480,265,365,483,88,159,474,79,228,205,448,377,454,274,400,145,494,380,449,154,11,346,214,383,469,366,249,343,48,240,186,455,363,466,352,389,475,498,8) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(430,361,464,158,295,410,461,155,112,29,278,344,481,152,32,513,275,255,341,149,276,273,150,187,233,445,359,382,259,267,156,462,87,356,310,479,439,482,90,503,480,265,365,483,88,159,474,79,228,205,448,377,454,274,400,145,494,380,449,154,11,346,214,383,469,366,249,343,48,240,186,455,363,466,352,389,475,498,8) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(430,361,464,158,295,410,461,155,112,29,278,344,481,152,32,513,275,255,341,149,276,273,150,187,233,445,359,382,259,267,156,462,87,356,310,479,439,482,90,503,480,265,365,483,88,159,474,79,228,205,448,377,454,274,400,145,494,380,449,154,11,346,214,383,469,366,249,343,48,240,186,455,363,466,352,389,475,498,8) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(430,361,464,158,295,410,461,155,112,29,278,344,481,152,32,513,275,255,341,149,276,273,150,187,233,445,359,382,259,267,156,462,87,356,310,479,439,482,90,503,480,265,365,483,88,159,474,79,228,205,448,377,454,274,400,145,494,380,449,154,11,346,214,383,469,366,249,343,48,240,186,455,363,466,352,389,475,498,8) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc
Missing Home | ECOWATER | TORIGA | Moen

select top 10 ID,E_BrandName from Product_Brand where ID in(430,361,464,158,295,410,461,155,112,29,278,344,481,152,32,513,275,255,341,149,276,273,150,187,233,445,359,382,259,267,156,462,87,356,310,479,439,482,90,503,480,265,365,483,88,159,474,79,228,205,448,377,454,274,400,145,494,380,449,154,11,346,214,383,469,366,249,343,48,240,186,455,363,466,352,389,475,498,8) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(430,361,464,158,295,410,461,155,112,29,278,344,481,152,32,513,275,255,341,149,276,273,150,187,233,445,359,382,259,267,156,462,87,356,310,479,439,482,90,503,480,265,365,483,88,159,474,79,228,205,448,377,454,274,400,145,494,380,449,154,11,346,214,383,469,366,249,343,48,240,186,455,363,466,352,389,475,498,8) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(430,361,464,158,295,410,461,155,112,29,278,344,481,152,32,513,275,255,341,149,276,273,150,187,233,445,359,382,259,267,156,462,87,356,310,479,439,482,90,503,480,265,365,483,88,159,474,79,228,205,448,377,454,274,400,145,494,380,449,154,11,346,214,383,469,366,249,343,48,240,186,455,363,466,352,389,475,498,8) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(430,361,464,158,295,410,461,155,112,29,278,344,481,152,32,513,275,255,341,149,276,273,150,187,233,445,359,382,259,267,156,462,87,356,310,479,439,482,90,503,480,265,365,483,88,159,474,79,228,205,448,377,454,274,400,145,494,380,449,154,11,346,214,383,469,366,249,343,48,240,186,455,363,466,352,389,475,498,8) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc
Arrow | Optima | KOHLER | Pamilor

select top 10 ID,E_BrandName from Product_Brand where ID in(430,361,464,158,295,410,461,155,112,29,278,344,481,152,32,513,275,255,341,149,276,273,150,187,233,445,359,382,259,267,156,462,87,356,310,479,439,482,90,503,480,265,365,483,88,159,474,79,228,205,448,377,454,274,400,145,494,380,449,154,11,346,214,383,469,366,249,343,48,240,186,455,363,466,352,389,475,498,8) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(430,361,464,158,295,410,461,155,112,29,278,344,481,152,32,513,275,255,341,149,276,273,150,187,233,445,359,382,259,267,156,462,87,356,310,479,439,482,90,503,480,265,365,483,88,159,474,79,228,205,448,377,454,274,400,145,494,380,449,154,11,346,214,383,469,366,249,343,48,240,186,455,363,466,352,389,475,498,8) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc
Mermax | Midea

Paint/Wall Paper/Curtain
select top 10 ID,E_BrandName from Product_Brand where ID in(69,530,241,252,381,499,30,516,67,370,434,500,33,262,431,208,518,515,286,435) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(69,530,241,252,381,499,30,516,67,370,434,500,33,262,431,208,518,515,286,435) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(69,530,241,252,381,499,30,516,67,370,434,500,33,262,431,208,518,515,286,435) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(69,530,241,252,381,499,30,516,67,370,434,500,33,262,431,208,518,515,286,435) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc
CAPAROL | DULUX | Brewster | Glamor

select top 10 ID,E_BrandName from Product_Brand where ID in(69,530,241,252,381,499,30,516,67,370,434,500,33,262,431,208,518,515,286,435) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(69,530,241,252,381,499,30,516,67,370,434,500,33,262,431,208,518,515,286,435) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(69,530,241,252,381,499,30,516,67,370,434,500,33,262,431,208,518,515,286,435) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(69,530,241,252,381,499,30,516,67,370,434,500,33,262,431,208,518,515,286,435) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc
DaShiYe | Qaobo | Master's Mark | Nippon

Radiator/Water Heater
select top 10 ID,E_BrandName from Product_Brand where ID in(272,135,398,355,424,453,38,350,496,156,101,373,411,365,391,371,417,76,245,497,136,251,372,134,312,80,423,266) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(272,135,398,355,424,453,38,350,496,156,101,373,411,365,391,371,417,76,245,497,136,251,372,134,312,80,423,266) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(272,135,398,355,424,453,38,350,496,156,101,373,411,365,391,371,417,76,245,497,136,251,372,134,312,80,423,266) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(272,135,398,355,424,453,38,350,496,156,101,373,411,365,391,371,417,76,245,497,136,251,372,134,312,80,423,266) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc
TSINGHUA SOLAR | SUNPU | zehnder | NVC

select top 10 ID,E_BrandName from Product_Brand where ID in(272,135,398,355,424,453,38,350,496,156,101,373,411,365,391,371,417,76,245,497,136,251,372,134,312,80,423,266) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(272,135,398,355,424,453,38,350,496,156,101,373,411,365,391,371,417,76,245,497,136,251,372,134,312,80,423,266) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(272,135,398,355,424,453,38,350,496,156,101,373,411,365,391,371,417,76,245,497,136,251,372,134,312,80,423,266) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(272,135,398,355,424,453,38,350,496,156,101,373,411,365,391,371,417,76,245,497,136,251,372,134,312,80,423,266) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc
Keen&Juche | Midea | HuaDi | HuangMing

select top 10 ID,E_BrandName from Product_Brand where ID in(272,135,398,355,424,453,38,350,496,156,101,373,411,365,391,371,417,76,245,497,136,251,372,134,312,80,423,266) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(272,135,398,355,424,453,38,350,496,156,101,373,411,365,391,371,417,76,245,497,136,251,372,134,312,80,423,266) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc
FLORECE | ARISTON

Door/Staircase/Decoration Ware
select top 10 ID,E_BrandName from Product_Brand where ID in(115,284,418,438,387,146,327,292,304,401,427,364,86,298,353,273,130,379,362,465,147,213,236,21,393,239,333,279,224,119,188,234,225,414,451,474,282,122,463,388,294,123,237,260,48,263,432,340,289,114,369,392,486,157,137) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(115,284,418,438,387,146,327,292,304,401,427,364,86,298,353,273,130,379,362,465,147,213,236,21,393,239,333,279,224,119,188,234,225,414,451,474,282,122,463,388,294,123,237,260,48,263,432,340,289,114,369,392,486,157,137) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(115,284,418,438,387,146,327,292,304,401,427,364,86,298,353,273,130,379,362,465,147,213,236,21,393,239,333,279,224,119,188,234,225,414,451,474,282,122,463,388,294,123,237,260,48,263,432,340,289,114,369,392,486,157,137) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(115,284,418,438,387,146,327,292,304,401,427,364,86,298,353,273,130,379,362,465,147,213,236,21,393,239,333,279,224,119,188,234,225,414,451,474,282,122,463,388,294,123,237,260,48,263,432,340,289,114,369,392,486,157,137) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc
Long Xiang | Hao Chuan | YEEPIN | WERFU

select top 10 ID,E_BrandName from Product_Brand where ID in(115,284,418,438,387,146,327,292,304,401,427,364,86,298,353,273,130,379,362,465,147,213,236,21,393,239,333,279,224,119,188,234,225,414,451,474,282,122,463,388,294,123,237,260,48,263,432,340,289,114,369,392,486,157,137) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(115,284,418,438,387,146,327,292,304,401,427,364,86,298,353,273,130,379,362,465,147,213,236,21,393,239,333,279,224,119,188,234,225,414,451,474,282,122,463,388,294,123,237,260,48,263,432,340,289,114,369,392,486,157,137) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(115,284,418,438,387,146,327,292,304,401,427,364,86,298,353,273,130,379,362,465,147,213,236,21,393,239,333,279,224,119,188,234,225,414,451,474,282,122,463,388,294,123,237,260,48,263,432,340,289,114,369,392,486,157,137) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc
STANLEY | Topstrong | Hongjing

select top 10 ID,E_BrandName from Product_Brand where ID in(115,284,418,438,387,146,327,292,304,401,427,364,86,298,353,273,130,379,362,465,147,213,236,21,393,239,333,279,224,119,188,234,225,414,451,474,282,122,463,388,294,123,237,260,48,263,432,340,289,114,369,392,486,157,137) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(115,284,418,438,387,146,327,292,304,401,427,364,86,298,353,273,130,379,362,465,147,213,236,21,393,239,333,279,224,119,188,234,225,414,451,474,282,122,463,388,294,123,237,260,48,263,432,340,289,114,369,392,486,157,137) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(115,284,418,438,387,146,327,292,304,401,427,364,86,298,353,273,130,379,362,465,147,213,236,21,393,239,333,279,224,119,188,234,225,414,451,474,282,122,463,388,294,123,237,260,48,263,432,340,289,114,369,392,486,157,137) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc
KeLaiNuo | Binsen | FoLuoLun

Lamp/Switch/Ceiling
select top 10 ID,E_BrandName from Product_Brand where ID in(89,367,232,127,250,38,316,61,253,502,270,368,99,317,231,251,345,280,269,226,100,91,489,51) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(89,367,232,127,250,38,316,61,253,502,270,368,99,317,231,251,345,280,269,226,100,91,489,51) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(89,367,232,127,250,38,316,61,253,502,270,368,99,317,231,251,345,280,269,226,100,91,489,51) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(89,367,232,127,250,38,316,61,253,502,270,368,99,317,231,251,345,280,269,226,100,91,489,51) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc
Haolang | TOSUN | YiSiDun | SIEMENS

select top 10 ID,E_BrandName from Product_Brand where ID in(89,367,232,127,250,38,316,61,253,502,270,368,99,317,231,251,345,280,269,226,100,91,489,51) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(89,367,232,127,250,38,316,61,253,502,270,368,99,317,231,251,345,280,269,226,100,91,489,51) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(89,367,232,127,250,38,316,61,253,502,270,368,99,317,231,251,345,280,269,226,100,91,489,51) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(89,367,232,127,250,38,316,61,253,502,270,368,99,317,231,251,345,280,269,226,100,91,489,51) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(89,367,232,127,250,38,316,61,253,502,270,368,99,317,231,251,345,280,269,226,100,91,489,51) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc
NVC | LONON | AOPU | HUSILONG | OPALRELY

select top 10 ID,E_BrandName from Product_Brand where ID in(89,367,232,127,250,38,316,61,253,502,270,368,99,317,231,251,345,280,269,226,100,91,489,51) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc
KAFANJIE

Furniture
select top 10 ID,E_BrandName from Product_Brand where ID in(137,260,501,510) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(137,260,501,510) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(137,260,501,510) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc
WERFU | STANLEY | XiLinMen

select top 10 ID,E_BrandName from Product_Brand where ID in(137,260,501,510) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc
F&D.XinYaoJia

Household Ornament
select top 10 ID,E_BrandName from Product_Brand where ID in(141,506) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(141,506) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc
VEETA TOWN | Bestair

Base Material
select top 10 ID,E_BrandName from Product_Brand where ID in(517,519,520,521,522,523,524,525,526,527,528,529,530,531,532) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(517,519,520,521,522,523,524,525,526,527,528,529,530,531,532) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(517,519,520,521,522,523,524,525,526,527,528,529,530,531,532) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc
MeiChao | Ginde | CAPAROL

select top 10 ID,E_BrandName from Product_Brand where ID in(517,519,520,521,522,523,524,525,526,527,528,529,530,531,532) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(517,519,520,521,522,523,524,525,526,527,528,529,530,531,532) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(517,519,520,521,522,523,524,525,526,527,528,529,530,531,532) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc
JING CHENG PAI | Henkel | TaiLiYa

select top 10 ID,E_BrandName from Product_Brand where ID in(517,519,520,521,522,523,524,525,526,527,528,529,530,531,532) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(517,519,520,521,522,523,524,525,526,527,528,529,530,531,532) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(517,519,520,521,522,523,524,525,526,527,528,529,530,531,532) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc

select top 10 ID,E_BrandName from Product_Brand where ID in(517,519,520,521,522,523,524,525,526,527,528,529,530,531,532) and isshow=1 and E_BrandName is not null order by OrderNum desc,id desc
PengChuang | VESBO | Metylan | CREAD