foreveryourslingerie.ca/categories/?cName=Shape&categoryId=331&shop=Shapewear&cMain=1&npage=1 Shape
SELECT p.*, vo.Item_Price1 as Item_Price1,vo.Item_Price2 ,vo.samefldALU FROM qc_products as p, qc_productInCategories as pc,qc_categories as c, qc_variantOptions AS vo, qc_variants AS v WHERE p.productId = pc.productId AND v.productId = p.productId and pc.categoryId=c.categoryId AND v.variantId = vo.variantId AND c.categoryId IN ( 331 ) AND p.visible=1 AND vo.visible=1 GROUP BY vo.samefldALU ORDER BY p.addedDate desc limit 0,16
MAIN ITEM
Checking inventory...
Marie Jo Color Studio Hi-Waist Light Shaping Brief
Marie Jo Color Studio Hi-Waist Light Shaping Brief
MAIN ITEM
Checking inventory...
Spanx Everyday Shaping Panty
Spanx Everyday Shaping Panty
MAIN ITEM
Checking inventory...
Spanx Undi-Tectable Hipster
Spanx Undi-Tectable Hipster
MAIN ITEM
Checking inventory...
Spanx Spotlight Hi-Waist Panty
Spanx Spotlight Hi-Waist Panty
MAIN ITEM
Checking inventory...
Spanx Higher Power Shorts
Spanx Higher Power Shorts
MAIN ITEM
Checking inventory...
Spanx Lace Hi-Hipster Panty
Spanx Lace Hi-Hipster Panty
MAIN ITEM
Checking inventory...
Spanx 'Shape My Day' Open-Bust Mid-Thigh Bodysuit
Spanx 'Shape My Day' Open-Bust Mid-Thigh Bodysuit
MAIN ITEM
Checking inventory...
Spanx 'Shape My Day' Open-Bust Camisole
Spanx 'Shape My Day' Open-Bust Camisole
MAIN ITEM
Checking inventory...
Chantelle Light Shaping High Waist Brief
Chantelle Light Shaping High Waist Brief
MAIN ITEM
Checking inventory...
Chantelle Light Shaping Full Brief
Chantelle Light Shaping Full Brief
MAIN ITEM
Checking inventory...
Spanx Control Thong
Spanx Control Thong
MAIN ITEM
Checking inventory...
Spanx 'Undie-tectable' Lace Thong
Spanx 'Undie-tectable' Lace Thong
MAIN ITEM
Checking inventory...
Spanx Control Brief
Spanx Control Brief
MAIN ITEM
Checking inventory...
Yummie Tummie 'Nina' Shaping Short
Yummie Tummie 'Nina' Shaping Short
MAIN ITEM
Checking inventory...
Yummie Tummie 'Nici' Shaping Brief
Yummie Tummie 'Nici' Shaping Brief
MAIN ITEM
Checking inventory...
Panache Envy Shaping Brief
Panache Envy Shaping Brief
521631,SS0715LW,SP0515L,1012SP,2745,SP0515,SS5615-PS5615,SS0315-PS0315,2857,2858,SS0815,SP0615,SS0715,YT5-004,YT5-003,7284
(
Checking inventory...Spanx 'Shape My Day' Open-Bust Mid-Thigh Bodysuit$ 99.99Spanx 'Shape My Day' Open-Bust Mid-Thigh Bodysuit
Checking inventory...Spanx 'Shape My Day' Open-Bust Camisole$ 69.99Spanx 'Shape My Day' Open-Bust Camisole
Checking inventory...Chantelle Light Shaping High Waist Brief$ 79.99Chantelle Light Shaping High Waist Brief
Checking inventory...Chantelle Light Shaping Full Brief$ 59.99Chantelle Light Shaping Full Brief
Checking inventory...Spanx 'Undie-tectable' Lace Thong$ 29.99Spanx 'Undie-tectable' Lace Thong
Checking inventory...Yummie Tummie 'Nina' Shaping Short$ 19.99Yummie Tummie 'Nina' Shaping Short
Checking inventory...Yummie Tummie 'Nici' Shaping Brief$ 19.99Yummie Tummie 'Nici' Shaping Brief
