(0)
SEARCH
foreveryourslingerie.ca/categories/?cName=iCollection&categoryId=5&shop=Lingerie&brandName=iCollection

iCollection

SELECT p.*, vo.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.parentCategoryId = 5 AND p.productId IN(12362,118,1001,17168,2133,16633,5317,15991,16627,16626,15977,16622,15080,16001,2,16631,16632,16637,16630,16639,16620,5311,5412,17966,14250,14248,14247,14252,14251,14515,14249,592,204,5332,5307,5321,1781,807,924,193,890,9651,1854,5302,6400,16799,15975,14033,7663,11059,15992,5210,13903,17177,17185,14707,6505,13367,13933,17182,14735,10111,10114,7822,14637,7821,7823,16784,7824,7819,17604,17618,13188,17170,248,6291,6523,6549,12188,7625,7596,11334,13185,11333,11480,11329,8551,11328,13909,13914,13894,13897,15571,13904,13902,16801,16815,16805,16825,16808,16811,16813,10805,17180,7238,16014,17318,17301,17288,17279,16925,17275,17323,16019,6348,8560,8545,16015,17282,399,860,49,902,17056,17471,15076,15074,13189,17173,191,154,17340,17557,16382,16391,14872,14874,16224,16775,13527,13526,13592,17635,12362,12394,12752,12332,12396,12361,12343,12336,14014,12384,12304,12759,12374,12367,12382,12311,12321,14015,15895,12302,14012,12749,12395,12338,12290,12299,15507,12355,12291,14010,12757,12387,12324,13941,13935,13938,13956,15147,15142,10839,10727,5833,16609,16607,16602,16614,16605,16598,14246,17234,13525,5331,14914,17746) AND c.name='iCollection' AND p.visible=1 AND vo.visible=1 GROUP BY vo.samefldALU ORDER BY p.addedDate desc limit 0,16
Shop By       
Shop By Colour:
    MAIN ITEM
  • iCollection Satin & Lace Short Robe
    S - 3X
    Checking inventory...
    iCollection Satin & Lace Short Robe
    $ 99.99
    iCollection Satin & Lace Short Robe
  • MAIN ITEM
  • iCollection Satin & Lace Chemise
    S - 3X
    Checking inventory...
    iCollection Satin & Lace Chemise
    $ 79.99
    iCollection Satin & Lace Chemise
  • MAIN ITEM
  • iCollection Satin & Lace Short Robe
    S - 3X
    Checking inventory...
    iCollection Satin & Lace Short Robe
    $ 99.99
    iCollection Satin & Lace Short Robe
  • MAIN ITEM
  • iCollection Satin & Lace Chemise
    S - 3X
    Checking inventory...
    iCollection Satin & Lace Chemise
    $ 69.99
    iCollection Satin & Lace Chemise
  • MAIN ITEM
  • iCollection Dot Lace Teddy
    S - 3X
    Checking inventory...
    iCollection Dot Lace Teddy
    $ 79.99
    iCollection Dot Lace Teddy
  • MAIN ITEM
  • iCollection Dot Lace Babydoll
    S - XL
    Checking inventory...
    iCollection Dot Lace Babydoll
    $ 79.99
    iCollection Dot Lace Babydoll
  • MAIN ITEM
  • iCollection Lace & Mesh Babydoll
    S - 3X
    Checking inventory...
    iCollection Lace & Mesh Babydoll
    $ 69.99
    Reg. $ 79.99
    iCollection Lace & Mesh Babydoll
  • MAIN ITEM
  • iCollection Velvet and Mesh Gown
    S - 3X
    Checking inventory...
    iCollection Velvet and Mesh Gown
    $ 99.99
    iCollection Velvet and Mesh Gown
  • MAIN ITEM
  • iCollection Softcup Lace Babydoll
    S - 3X
    Checking inventory...
    iCollection Softcup Lace Babydoll
    $ 69.99
    iCollection Softcup Lace Babydoll
  • MAIN ITEM
  • iCollection Striped Mesh Teddy
    S - 3X
    Checking inventory...
    iCollection Striped Mesh Teddy
    $ 89.99
    iCollection Striped Mesh Teddy
  • MAIN ITEM
  • iCollection Lace Waist Cincher
    S - 3X/4X
    Checking inventory...
    iCollection Lace Waist Cincher
    $ 69.99
    iCollection Lace Waist Cincher
  • MAIN ITEM
  • iCollection Dot Mesh & Lace Chemise
    S - 3X
    Checking inventory...
    iCollection Dot Mesh & Lace Chemise
    $ 49.99
    iCollection Dot Mesh & Lace Chemise
  • MAIN ITEM
  • iCollection Dot and Ruffle Mesh Babydoll
    S - 3X
    Checking inventory...
    iCollection Dot and Ruffle Mesh Babydoll
    $ 49.99
    iCollection Dot and Ruffle Mesh Babydoll
  • MAIN ITEM
  • iCollection Seamless Garter Belt
    S/M - 3X/4X
    Checking inventory...
    iCollection Seamless Garter Belt
    $ 19.99
    iCollection Seamless Garter Belt
  • MAIN ITEM
  • iCollection Sheer Lace Robe
    Regular & Plus Sizing
    Checking inventory...
    iCollection Sheer Lace Robe
    $ 69.99
    iCollection Sheer Lace Robe
  • MAIN ITEM
  • iCollection Floral Lace Cap Sleeve Babydoll
    S - 3X
    Checking inventory...
    iCollection Floral Lace Cap Sleeve Babydoll
    $ 59.99
    iCollection Floral Lace Cap Sleeve Babydoll