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 0,16
EL4110CA,0241792-0241793,0163120-0163121,0162690-0162691,0141807,0241802-0241803,FL2321,FL3181BC,FL3182BC,12A1,9951,7695TF,2231EP,6797CA,0163116,FL3020 BC
(
E - H CupsChecking inventory...PrimaDonna Twist Boss Babe Balcony$ 159.99PrimaDonna Twist Boss Babe Balcony
E - G CupsChecking inventory...PrimaDonna Twist 1919 Plunge Bra$ 169.99PrimaDonna Twist 1919 Plunge Bra
E - H CupsChecking inventory...PrimaDonna Twist 1919 Balcony Bra$ 169.99PrimaDonna Twist 1919 Balcony Bra
E - H CupsChecking inventory...Fantasie Olivia Side Support Bra$ 79.99Fantasie Olivia Side Support Bra
F - GG CupsChecking inventory...Sculptresse Chi Chi Full Cup Bra$ 79.99Sculptresse Chi Chi Full Cup Bra
C - G Cups (EU Sizing)Checking inventory...Chantelle Courcelles Spacer Bra$ 99.99Chantelle Courcelles Spacer Bra
E - G CupsChecking inventory...PrimaDonna Every Woman Spacer Bra$ 139.99PrimaDonna Every Woman Spacer Bra
