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

Fantasy

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(11422,11314,11322,11575,11312,11321,16433,16434,11316,208,15861,6117,14513,12203,16927,16690,16293,14514,940,821,1049,2930,424,12514,11315,11313,6454,10003,622,12694,14032,231,163,140,2925,5386,2926,6118,15862,14506,12867,12202,15089,16966,16686,12792,12691,425,166,14969,12528,6455,10004,10005,10020,11690,11358,3749,11693,1001,12790,182,567,941,12690,7127,13147,13530,11659,5336,533,13042,17168,2133,16633,4472,5317,16636,15959,15977,16622,262,15080,13727,15967,15563,15706,2,16631,16629,16632,16634,16637,16620,9127,5311,10679,14602,11626,14330,8268,14583,8267,176,592,14608,915,204,7504,10872,5332,5307,12788,8204,12782,5321,807,924,9651,1854,5302,7769,349,17059,13862,13511,5318,16703,16137,16142,16711,16700,16114,16121,16115,16799,11649,295,12206,15738,43,15736,10166,12212,15964,14154,15978,10874,7702,504,16706,16708,14190,16738,16755,16095,16698,16747,16754,13758,11059,11417,11418,11431,11455,9169,9353,5210,292,16346,16319,13377,350,6505,117,169,194,16524,15096,14735,582,597,10111,10114,7820,7822,17157,7821,7823,9537,9542,987,12312,7824,7819,10806,13188,17167,11740,487,7515,15064,901,857,601,16699,16697,16696,16094,16129,16119,16719,16133,16125,15072,12055,16367,12056,6523,13802,6549,14333,986,3304,15165,12188,188,4669,16933,12340,12306,4635,16913,12368,7625,9647,11334,17169,11333,11480,13185,8551,10282,11328,11332,13909,13914,13894,15579,13897,10809,15571,13904,13902,15573,3274,15574,15572,16801,16815,16805,16809,16825,16812,16808,16811,16813,16800,16806,16804,10805,12314,13437,15354,14338,12213,114,16498,12410,16511,7238,16028,16020,16047,16021,16024,16017,16033,16016,16014,14303,9283,5628,5627,7500,9757,16019,6348,15206,8560,8545,15200,16043,15199,15205,8059,9566,14580,15366,16018,15213,16015,16030,16022,16037,399,860,902,1025,48,16239,12955,16512,12902,16505,13189,17173,13439,11715,11721,12857,12827,191,15558,14362,14383,154,16681,16674,15870,14160,14157,17037,17025,16682,16685,16893,10946,14717,14275,10764,4768,14434,10884,16795,10882,10890,15732,16570,16430,15250,15769,16225,17237,16835,16792,14663,15251,14143,16828,16572,15253,13740,16204,16665,16587,10849,11964,15249,15254,15255,16067,16140,16118,16453,15233,12273,13918,16619,14150,13908,14767,14159,14547,12362,15631,12394,12752,12332,14014,12384,12304,12759,12382,12311,14010,12757,12387,15279,12324,13935,13938,13956,15147,15142,12402,12406,12405,12403,12404,12407,1673,16451,16415,9514,10146,16413,8635,8636,9212,16689,15765,12674,16680,12979,12980,16085,15335,15338,13212,13242,13217,16271,16282,16272,15327,15343,16957,16918,15328,16919,16917,17201,17203,17100,17083,16912,16962,7700,16410,4355,10562,5343,4334,11151,14980,16662,11153,16663,15731,14913,13234,13216,13249,13245,16772,16773,16774,16771,16965,16926,16956,16971,2193,4425,13211,15939,16643,11570,11568,13218,11208,11222,11569,15216,13223,13221,13237,13224,15220,13243,13230,2254,1735,1432,15217,11871,14957,14959,14958,15228,15229,3662,15767,16450,14113,17238,16226,16829,16205,10839,10939,10941,13707,13142,5833,12060,12061,13314,13671,15828,15829,15322,8290,9269,9263,15886,9262,9268,9384,16661,17099,16660,14293,17104,9260,13893,11759,16666,16667,16693,11310,15730,14931,13691,10847,15232,16903,16892,10613,7088,8606,9997,14245,14246,15528,12063,1436,11347,14914,12266,12269,1073,16347,11699,7416,12718,15768,14459,15252,17235,16228,15872,15848,13774,13788,13777,12303,16891,15256,8085,10885,11993,13647,11881,16884,16900,17236,16794,13744,13741) AND c.name='Fantasy' 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
  • Fantasy Bahama Mama Chiffon Kimono & Panty
    S/M - 3X/4X
    Checking inventory...
    Fantasy Bahama Mama Chiffon Kimono & Panty
    $ 69.99
    Fantasy Bahama Mama Chiffon Kimono & Panty
  • MAIN ITEM
  • Fantasy Marilyn Halter & Panty
    S - 3X
    Checking inventory...
    Fantasy Marilyn Halter & Panty
    $ 69.99
    Fantasy Marilyn Halter & Panty
  • MAIN ITEM
  • Fantasy Courtney Lace Robe & G-String Set
    Plus Sized
    Checking inventory...
    Fantasy Courtney Lace Robe & G-String Set
    $ 69.99
    Fantasy Courtney Lace Robe & G-String Set