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...
Prima Donna Twist Cabaret Bodysuit
Prima Donna Twist Cabaret Bodysuit
MAIN ITEM
Checking inventory...
Prima Donna Twist Cabaret Shaper Brief
Prima Donna Twist Cabaret Shaper Brief
MAIN ITEM
Checking inventory...
Spanx Spotlight Lace Bodysuit
Spanx Spotlight Lace Bodysuit
MAIN ITEM
Checking inventory...
Spanx Spotlight Lace Bralette
Spanx Spotlight Lace Bralette
MAIN ITEM
Checking inventory...
Spanx Spotlight Lace Brief
Spanx Spotlight Lace Brief
MAIN ITEM
Checking inventory...
Spanx Undie-Tectable Lace Hi-Hipster Panty
Spanx Undie-Tectable Lace Hi-Hipster Panty
MAIN ITEM
Checking inventory...
Spanx Control Thong
Spanx Control Thong
MAIN ITEM
Checking inventory...
Spanx Retro Shaping Brief
Spanx Retro Shaping Brief
MAIN ITEM
Checking inventory...
Dita Von Teese Sheer Witchery Bustier
Dita Von Teese Sheer Witchery Bustier
MAIN ITEM
Checking inventory...
Spanx Oncore Hi-Waist Mid-Thigh Short
Spanx Oncore Hi-Waist Mid-Thigh Short
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
0441612BK,0541613BK,10119R-10119P,10124R-10124P,10123R,SP0515R,SS0815R,FS0115-PS0115,D47954,SS1915-PS1915,521631,SS0715LW,SP0515L,1012SP,2745,SP0515