(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(13475,2926,118,1001,1980,6,5313,13012,12983,13051,13042,2133,13036,5317,5330,2,5311,5407,541,14250,14248,14247,14252,14251,14515,14249,592,1698,915,8,5332,294,512,5307,5321,1781,807,924,890,9640,1854,6234,5302,6400,368,5320,5318,13179,14033,7663,11059,9169,9171,11956,13900,13004,13056,13039,12997,13048,13011,14296,14709,14733,14707,13930,14703,6672,6505,13367,14735,10111,10114,7820,7822,14637,7821,7823,7824,7819,13188,248,14734,6523,14732,6563,14736,12188,14738,7625,7583,7596,91,9647,11334,13187,11333,11338,11480,6338,11329,6328,8551,11332,11342,13909,13914,13894,13897,13904,13902,13114,12072,7238,10276,8553,6348,8560,8545,13274,12074,12067,14517,13275,9558,14854,399,860,902,4,738,14327,14335,14331,14336,14329,14323,12949,11601,13182,13189,344,154,14872,14871,14873,13465,13086,12809,13446,12780,14870,9499,13113,13112,9485,13094,13527,13526,13975,13598,13593,13597,13595,13591,13592,12362,14003,14013,12394,12752,12332,12396,12343,12336,14004,14014,12384,12304,12759,12367,12748,12378,14011,14006,12382,12311,14015,12750,12302,12363,14012,12749,12395,12393,12290,12370,12299,14002,12355,12291,14010,12757,12387,12324,13941,13935,13938,13934,14298,14301,13956,10394,8601,8608,10032,10838,8723,10727,5833,8606,14246,13525,520,5331,5316,12313) 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 Lace & Mesh Babydoll
    S - 3X
    Checking inventory...
    iCollection Lace & Mesh Babydoll
    $ 79.99
    iCollection Lace & Mesh Babydoll
  • iCollection Bra and Garter Set
    S - 3X
    Checking inventory...
    iCollection Bra and Garter Set
    $ 79.99
    iCollection Bra and Garter Set
  • MAIN ITEM
  • iCollection Strappy Mesh & Lace Babydoll
    S - 3X
    Checking inventory...
    iCollection Strappy Mesh & Lace Babydoll
    $ 79.99
    iCollection Strappy Mesh & Lace Babydoll
  • MAIN ITEM
  • iCollection Eyelash Lace Thong
    S/M - 3X/4X
    Checking inventory...
    iCollection Eyelash Lace Thong
    $ 15.99
    iCollection Eyelash Lace Thong
  • MAIN ITEM
  • iCollection Flutter Sleeve Wrap
    S - 3X
    Checking inventory...
    iCollection Flutter Sleeve Wrap
    $ 44.99
    Reg. $ 69.99
    iCollection Flutter Sleeve Wrap
  • MAIN ITEM
  • iCollection Mesh & Lace Robe with Bell Sleeves
    S - 3X
    Checking inventory...
    iCollection Mesh & Lace Robe with Bell Sleeves
    $ 39.99
    Reg. $ 54.99
    iCollection Mesh & Lace Robe with Bell Sleeves
  • 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 High Waisted Garter Belt
    Checking inventory...
    iCollection High Waisted Garter Belt
    $ 19.99
    iCollection High Waisted 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
  • MAIN ITEM
  • iCollection Eyelash Lace Hi-Waist Garterbelt
    S/M - 3X/4X
    Checking inventory...
    iCollection Eyelash Lace Hi-Waist Garterbelt
    $ 24.99
    iCollection Eyelash Lace Hi-Waist Garterbelt