foreveryourslingerie.ca/categories/?cName=Bras&categoryId=1&shop=Bras&cMain=1&npage=26
Bras
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 ( 1 ) AND p.visible=1 AND vo.visible=1 GROUP BY vo.samefldALU ORDER BY p.addedDate desc limit 400,16
MAIN ITEM
Checking inventory...
Fantasie Smoothing T-Shirt Bra
Fantasie Smoothing T-Shirt Bra
MAIN ITEM
Checking inventory...
Aviana Satin Jacquard Softcup Bra
Aviana Satin Jacquard Softcup Bra
MAIN ITEM
Checking inventory...
Freya 'Deco' Soft Cup Bra
Freya 'Deco' Soft Cup Bra
MAIN ITEM
Checking inventory...
Prima Donna Madison Bra
Prima Donna Madison Bra
MAIN ITEM
Checking inventory...
Van Elle Softest Bra Ever
Van Elle Softest Bra Ever
MAIN ITEM
Checking inventory...
Enell Sport Compression Bra
Enell Sport Compression Bra
MAIN ITEM
Checking inventory...
Elita Microfiber Comfort Cami
Elita Microfiber Comfort Cami
MAIN ITEM
Checking inventory...
Freya Deco Strapless Bra
Freya Deco Strapless Bra
MAIN ITEM
Checking inventory...
Chantelle 'Rive Gauche' Underwire Bra
Chantelle 'Rive Gauche' Underwire Bra
MAIN ITEM
Checking inventory...
Chantelle 'C Magnifique' Bra
Chantelle 'C Magnifique' Bra
MAIN ITEM
Checking inventory...
Fantasie Smoothing Strapless Bra
Fantasie Smoothing Strapless Bra
MAIN ITEM
Checking inventory...
Marlies Dekkers Dame de Paris Sparrow Balcony Bra
Marlies Dekkers Dame de Paris Sparrow Balcony Bra
MAIN ITEM
Checking inventory...
Felina Melina Underwire Bra
Felina Melina Underwire Bra
MAIN ITEM
Checking inventory...
Le Mystere Soiree Strapless Bra
Le Mystere Soiree Strapless Bra
MAIN ITEM
Checking inventory...
Panache Evie Strapless Bra
Panache Evie Strapless Bra
MAIN ITEM
Checking inventory...
Warners Cut and Sewn Cup
Warners Cut and Sewn Cup
FL4510,2353,AA4231,0162120-0162121,75335,100,6859,AA4233,3281,1891,FL4530,15420-154201,527,9756,5320,1044