BrandName |
ClothesName |
VievingUrl |
Price |
Brand1 |
Pants |
http://mysite.com?B=1&C=1 |
123.9900 |
Brand1 |
T-Shirt |
http://mysite.com?B=1&C=2 |
110.9900 |
Brand2 |
Pants |
http://mysite.com?B=2&C=1 |
75.9900 |
Brand2 |
T-Shirt |
http://mysite.com?B=2&C=2 |
85.9900 |
Skipping FOREIGN KEY constraint '#BrandsClothes' definition for temporary table. FOREIGN KEY constraints are not enforced on local or global temporary tables.
Skipping FOREIGN KEY constraint '#BrandsClothes' definition for temporary table. FOREIGN KEY constraints are not enforced on local or global temporary tables.
Skipping FOREIGN KEY constraint '#BCAttributes' definition for temporary table. FOREIGN KEY constraints are not enforced on local or global temporary tables.
Skipping FOREIGN KEY constraint '#BCAttributes' definition for temporary table. FOREIGN KEY constraints are not enforced on local or global temporary tables.
Skipping FOREIGN KEY constraint '#BCAttributes' definition for temporary table. FOREIGN KEY constraints are not enforced on local or global temporary tables.
ClothesName |
BrandName |
AttrName |
AttrValue |
T-Shirt |
Brand1 |
Color |
Pearl, Black widow |
T-Shirt |
Brand1 |
Size |
M, L, XL |
T-Shirt |
Brand2 |
Custom |
15% Discount |
T-Shirt |
Brand2 |
Shape |
Slim fit, Regular fit |
T-Shirt |
Brand2 |
Provider |
G-Star, Armani |
ClothesName |
BrandName |
AttrName |
AttrValue |
Pants |
Brand1 |
Size |
32, 33, 34 |
T-Shirt |
Brand1 |
Size |
M, L, XL |