(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(11377,9390,2926,118,1001,13192,8988,1980,6,5313,12221,13012,12983,12996,13024,13029,13042,13001,12995,12990,13010,12986,12993,13037,2133,13013,13036,5317,5330,2,541,592,1698,915,8,5332,294,512,5307,5321,1781,807,924,9640,1127,1854,6234,5302,368,5318,1682,7370,12942,12934,13177,13197,7663,11059,9185,9171,5210,62,11956,13033,1112,13059,13040,13041,12982,13039,12997,12998,13028,12991,12994,13020,13005,11475,6672,6505,13367,3412,3410,6423,121,10111,10114,7820,7822,7823,7824,7819,13092,13068,12027,5213,13080,842,248,6534,9149,6563,12188,3031,3033,7625,7624,7646,7608,91,9647,11479,11334,13187,11333,11338,11480,6338,11329,6328,8551,11478,11342,10812,10279,7246,11987,5260,13114,4533,10307,10289,12072,5462,7238,10276,8553,12722,13579,6348,8560,8545,13274,12074,12067,13275,399,860,902,4,190,12949,12924,13469,12959,11601,6642,12775,12923,13189,11593,10749,344,154,7219,12570,13465,13086,12806,13446,12223,12780,9499,13113,13112,4675,9485,13094,10044,13527,13526,13598,13593,13597,13594,13595,13596,8138,12362,12394,12391,12752,12332,12396,12386,12343,12327,12336,12384,12304,12759,12367,12748,12378,12382,12383,12311,12320,12750,12302,12363,12749,12395,12393,12290,12370,12299,12355,12291,12757,12387,12390,12324,8392,8601,8608,10032,10839,10838,12844,12851,8723,10727,11705,13090,5833,8606,13525,520,5331,5316,13293,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:
Items 1-16 of 19
    MAIN ITEM
  • iCollection Lace & Mesh Babydoll
    S - 3X
    Checking inventory...
    iCollection Lace & Mesh Babydoll
    $ 79.99
    iCollection Lace & Mesh Babydoll
  • MAIN ITEM
  • 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
    $ 69.99
    iCollection Flutter Sleeve Wrap
  • MAIN ITEM
  • iCollection Lace Waist Cincher
    S - 3X/4X
    Checking inventory...
    iCollection Lace Waist Cincher
    $ 69.99
    iCollection Lace Waist Cincher
  • MAIN ITEM
  • iCollection 2pc Halter Bra Set
    S - 3X
    Checking inventory...
    iCollection 2pc Halter Bra Set
    $ 59.99
    iCollection 2pc Halter Bra Set
  • MAIN ITEM
  • iCollection 2pc Lace Up Set
    S - 3X
    Checking inventory...
    iCollection 2pc Lace Up Set
    $ 69.99
    iCollection 2pc Lace Up Set
  • MAIN ITEM
  • iCollection Crotchless Cage Panty
    S - XL
    Checking inventory...
    iCollection Crotchless Cage Panty
    $ 19.99
    iCollection Crotchless Cage Panty
  • MAIN ITEM
  • iCollection Mesh & Lace Robe with Bell Sleeves
    S - 3X
    Checking inventory...
    iCollection Mesh & Lace Robe with Bell Sleeves
    $ 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
  • iCollection Sheer Lace Robe
    Regular & Plus Sizing
    Checking inventory...
    iCollection Sheer Lace Robe
    $ 69.99
    iCollection Sheer Lace Robe
  • MAIN ITEM
  • iCollection Sweet Victorian Corset
    32 - 38 inch Waist Cincher
    Checking inventory...
    iCollection Sweet Victorian Corset
    $ 109.99
    iCollection Sweet Victorian Corset
  • 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
Items 1-16 of 19