foreveryourslingerie.ca/categories/?cName=Panties&categoryId=330&shop=Panties&cMain=1&npage=3
Panties
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 ( 330 ) AND p.visible=1 AND vo.visible=1 GROUP BY vo.samefldALU ORDER BY p.addedDate desc limit 32,16
MAIN ITEM
Checking inventory...
Panache Ana Brief
Panache Ana Brief
MAIN ITEM
Checking inventory...
Panache Clara Brief
Panache Clara Brief
MAIN ITEM
Checking inventory...
Prima Donna Twist I Do Lace Hotpants
Prima Donna Twist I Do Lace Hotpants
MAIN ITEM
Checking inventory...
Prima Donna Twist I Do Italian Brief
Prima Donna Twist I Do Italian Brief
MAIN ITEM
Checking inventory...
Prima Donna Twist Take a Bow Brief
Prima Donna Twist Take a Bow Brief
MAIN ITEM
Checking inventory...
Prima Donna Twist Take a Bow Hotpants
Prima Donna Twist Take a Bow Hotpants
MAIN ITEM
Checking inventory...
Wacoal Embrace Lace Hi Cut Brief
Wacoal Embrace Lace Hi Cut Brief
MAIN ITEM
Checking inventory...
Chantelle Soft Stretch Full Brief
Chantelle Soft Stretch Full Brief
MAIN ITEM
Checking inventory...
Chantelle Soft Stretch Thong
Chantelle Soft Stretch Thong
MAIN ITEM
Checking inventory...
Chantelle Soft Stretch Hipster
Chantelle Soft Stretch Hipster
MAIN ITEM
Checking inventory...
Passionata Brooklyn Shorty
Passionata Brooklyn Shorty
MAIN ITEM
Checking inventory...
Empreinte Ashley Shorty
Empreinte Ashley Shorty
MAIN ITEM
Checking inventory...
Empreinte Ashley Thong
Empreinte Ashley Thong
MAIN ITEM
Checking inventory...
Fantasie Annalise Brief
Fantasie Annalise Brief
MAIN ITEM
Checking inventory...
Fantasie Annalise Thong
Fantasie Annalise Thong
MAIN ITEM
Checking inventory...
Freya Rhea Short
Freya Rhea Short
9395,7253EM,0541602BK,0541603BK,0541711,0541712,841191DW,2647,2649,2644,5704ULTRAMARINE,02183,01183,FL3075,FL3077,AA2396