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

Glamory

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(7046,11314,11322,11575,10994,11312,11321,11005,10992,11319,11320,832,11505,13471,11694,12897,14008,768,12936,11323,10998,14042,11316,208,13434,12885,90,2934,6117,12841,13436,12889,12203,11588,12516,13116,13121,13995,13998,13717,10991,11001,10996,11003,13464,10997,11135,12896,12667,14009,940,10145,10542,821,11370,12532,12530,11383,12823,13883,12843,12523,12853,12692,13457,1049,146,8177,2930,424,1777,3754,11138,12514,12513,11317,13475,11315,11313,554,843,6454,5532,10003,622,12932,11407,13887,12856,12830,12694,14034,14040,13463,13452,255,231,12892,13433,163,140,2925,2924,5386,2926,6118,12867,12863,12202,12522,12552,13118,13117,13994,13701,13711,12792,118,286,12956,13886,12833,12521,12691,14029,13462,425,12884,13468,166,12834,12883,12528,12608,13120,13996,6455,10004,10005,10020,11690,12895,11358,3749,13458,5528,8824,11157,11693,12898,12512,12511,12484,12658,12676,14007,1001,12790,13192,182,8068,567,941,12690,7127,13147,13530,13143,11659,1980,13583,12574,9530,6,5313,533,13012,12983,12996,13024,13042,12995,12986,12993,13037,2133,13036,4472,9370,5317,262,9118,9123,5330,13726,5073,7109,9359,7915,2,9127,12801,7776,7755,11572,12551,7547,11747,11763,10679,3586,11451,21,12662,11626,12665,13259,13100,7887,13265,541,8654,11582,8268,12671,12669,9557,10635,13682,8267,10035,10042,176,39,293,592,1698,12785,915,8,11301,2759,2760,11359,494,11331,7504,10869,8438,13709,420,328,294,512,5307,13286,13722,8283,12788,13444,8204,12782,13445,5321,9846,1781,807,924,7775,193,973,7746,9640,1127,12791,12911,1854,6234,8407,5302,12234,11477,7769,11653,349,13385,13413,13387,13519,13488,13491,13403,13389,13392,13395,13478,13406,13384,13504,13410,13424,13388,13508,13483,13496,13499,13391,13480,13510,13511,13405,13409,368,13968,13966,5318,6190,6471,6470,6913,10009,8837,12951,9431,9412,11649,787,295,12491,515,12571,7882,12205,9492,9460,13177,12535,10167,12561,12557,12588,12595,43,3757,12903,14044,10166,12212,12200,12197,10126,10127,10123,12198,10125,13714,13693,13674,13645,1157,12598,10874,7704,7702,14033,7663,12814,12812,7063,12199,228,14083,14122,14116,14124,12243,11778,11787,11777,11783,1237,504,14027,13885,13763,13761,13758,13764,13759,13762,11059,11417,13369,11418,11422,11446,11455,9185,9171,9353,5210,292,14026,3934,5126,11276,62,9988,12134,11956,13900,1112,13004,13056,13046,13039,13048,8655,12994,13020,13377,12505,788,13520,13481,13495,13967,13965,13962,13972,127,12899,350,13461,13447,11476,14028,6672,6505,2677,117,169,13367,13082,13088,194,12661,6414,6423,358,121,582,597,10111,10114,13756,7820,7822,13752,13755,13753,7823,9537,9542,987,12312,11708,13460,7824,7819,13178,13092,10806,1059,13188,1669,7522,11740,13068,487,12027,528,7515,12947,12837,12127,1033,901,879,857,13080,14039,13307,13302,14018,14016,14020,14017,949,601,545,12418,12254,12253,6270,13430,13459,842,816,248,10856,12462,10864,12531,12463,14114,13979,12055,12056,13802,6563,13820,12906,12829,13075,13102,986,13101,12725,13575,13806,13815,13811,13474,8850,463,13801,12309,13451,12334,13472,12188,188,4669,12340,8737,4659,12306,8733,4635,12368,8716,12768,12341,12369,12376,13985,13981,3031,3033,13976,13977,11279,7625,7583,7608,91,9647,11479,13732,11334,13187,11333,11339,11480,11329,6328,10282,11328,11332,11342,13894,10813,13897,10809,13895,13904,10279,6980,12319,13426,7046,13470,12777,12295,7576,12585,12914,13251,13279,11987,8672,12314,13437,9101,12213,11950,13077,13114,13253,13278,114,13250,12410,12568,10306,12072,8404,8402,11900,7238,10288,8553,12419,11584,14106,14100,13654,725,9283,5628,13640,12764,5627,13577,13881,13715,9274,13659,13579,7500,12766,9757,6348,8574,8545,13274,12069,12067,13108,13111,13882,12494,13574,13576,12734,13107,12499,9566,972,13105,12731,13582,11161,11979,12502,13880,12500,12544,12482,7803,12265,12264,7811,7889,13275,13580,669,13393,12663,399,860,12743,12744,12741,902,4,12614,3183,10139,48,13110,13661,13631,2828,10138,10140,13062,13629,12800,13705,10913,13638,10918,13696,10929,12594,12597,12913,12931,12963,12949,12953,13455,13431,13456,13435,13429,13443,13469,11341,12959,12905,13063,11601,12793,12773,13731,12929,12909,12955,13609,12902,13700,12944,13182,13189,11593,13255,13439,13272,12945,13720,12952,13091,13641,11715,11721,13268,13270,12857,12827,17,13072,13269,11091,11167,344,11595,11596,14128,14127,154,13104,519,13271,7219,13273,13109,158,12747,13465,13086,12806,13446,12780,9499,13113,13112,912,4675,9488,9485,9450,13257,13716,13614,13718,12316,13686,13721,11025,13642,8686,13660,13626,7336,13888,13889,12659,10124,6519,6555,11421,11424,11462,9427,9414,12670,10946,88,210,12824,12831,12840,12399,12281,13081,13103,13094,13603,13605,13599,13600,13604,13602,13601,12688,12684,12874,12873,12872,10523,10526,14096,8045,11380,6870,12380,12353,12358,12344,12366,8043,11386,9708,9717,9726,9766,8754,10750,13484,10776,13479,10731,12488,13514,13524,10788,13489,10764,12825,12864,12149,12520,12525,12524,12527,12668,12666,12647,11381,13306,13308,13305,3365,13366,13375,12226,12231,9875,13748,13256,4768,14047,14063,11943,14112,205,12417,908,789,692,3009,883,441,423,507,836,1810,1720,7720,212,13757,10884,10882,10890,13527,13526,13974,13975,13598,13593,13597,13594,13595,13596,13591,13592,13742,13740,12262,10849,11964,13743,13738,12248,13379,13376,12233,12554,12576,12555,12566,12600,13374,12229,8181,5114,12219,9115,12273,12274,14066,11099,11102,11095,12619,12011,12015,11101,11980,13918,12819,13899,13908,13905,12362,14003,14013,12394,12752,12332,12396,12343,12336,14004,14014,12384,12304,12759,12367,13258,12748,12378,14011,14006,12382,12383,12311,14015,12750,12302,12363,14012,12749,12395,12393,12290,12370,12299,14002,12355,12291,14010,12757,12387,12390,12324,13737,13941,13992,13935,13938,13934,13957,13956,12402,12406,12405,12403,12404,12407,1064,773,1673,9521,13239,12372,9514,10146,13246,11132,12359,13236,12977,13232,12974,10394,13238,12975,13229,12978,8635,8636,9212,13244,12674,13215,9194,10401,10406,10426,12866,12858,12979,13222,12980,13210,12976,12981,13228,13208,13212,13242,13217,7700,13214,4355,10562,5343,13247,13241,4334,11151,13231,12126,11153,13219,12117,13234,13235,13216,13249,13245,12150,2193,4425,13211,11570,11568,11208,11222,11569,13237,13224,13213,13227,13230,13220,2254,1667,1735,1432,12307,12293,3662,11904,11088,14113,8601,8608,10032,10838,1071,12810,13864,12813,13858,12811,13857,12815,13863,12846,12861,12845,12850,12844,12673,32,813,391,5819,5803,8747,8723,8714,13828,13826,13827,12288,10738,10939,10740,10941,10781,10943,10727,13087,13084,13073,13078,13707,11753,13628,13098,11713,11704,13067,11726,13071,13090,13142,5833,12158,12095,12163,12139,12060,12061,12062,13314,13315,13313,13311,13671,13697,13634,13386,13407,13418,13390,8290,11146,8019,9463,9484,9453,13423,13421,13400,10724,13419,13399,9435,9269,9263,12678,12086,9262,12282,13449,9268,9384,13076,13878,12504,13065,13879,12040,9260,13893,11759,10248,14072,14073,14075,14071,11269,6380,13702,13698,13691,13625,13695,13644,13636,13664,13675,8729,6402,621,10847,8431,13978,13684,11181,13408,11823,13712,13402,13689,13329,13318,13316,11564,301,578,8889,14097,12705,12082,10018,11352,13735,12236,12704,12539,10598,11835,10631,10623,10612,10691,10681,7088,1421,13589,13590,13588,8606,9997,9995,12804,12786,12778,13096,13089,10047,13525,12063,520,1436,13612,4685,11347,13467,13440,8172,5331,5316,12266,12269,12783,12954,12926,600,1073,8414,11699,9541,7451,11666,13146,7421,9221,7416,11665,7409,13144,12718,7577,11109,11180,12326,12313,5230,10258,10257,10259,11883,13545,5841,12329,13766,13768,11018,13771,13798,2146,10756,13774,13788,13777,12303,13153,13779,13944,13948,3626,12431,8085,12957,14057,14050,14049,14054,14048,14069,11919,11942,10628,10615,12605,10885,11993,3366,11831,13666,13651,13687,13667,13973,13943,13947,13653,13690,13552,12921,13554,8422,13551,11636,13744,13741,11948,11639,4241,4253,12464,12105,12102,11217,11210,11233) AND c.name='Glamory' 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
  • Glamory Vital 40 Support Hold Ups
    L - 4X
    Checking inventory...
    Glamory Vital 40 Support Hold Ups
    $ 39.99
    Glamory Vital 40 Support Hold Ups
  • MAIN ITEM
  • Glamory Satin Matt 20 Tights
    M - 4XL
    Checking inventory...
    Glamory Satin Matt 20 Tights
    $ 19.99
    Glamory Satin Matt 20 Tights
  • MAIN ITEM
  • Glamory Microstar 50 Tights
    M - 4XL
    Checking inventory...
    Glamory Microstar 50 Tights
    $ 34.99
    Glamory Microstar 50 Tights
  • MAIN ITEM
  • Glamory Vital 70 Support Tights
    M - 4XL
    Checking inventory...
    Glamory Vital 70 Support Tights
    $ 34.99
    Glamory Vital 70 Support Tights
  • MAIN ITEM
  • Glamory Allure 20 Hold Ups
    M - 4X
    Checking inventory...
    Glamory Allure 20 Hold Ups
    $ 34.99
    Glamory Allure 20 Hold Ups
  • MAIN ITEM
  • Glamory Deluxe 20 Hold Ups
    M - 4X
    Checking inventory...
    Glamory Deluxe 20 Hold Ups
    $ 39.99
    Glamory Deluxe 20 Hold Ups
  • MAIN ITEM
  • Glamory 'Micro 60' Opaque Stay-Up Stocking
    LG - 4X
    Checking inventory...
    Glamory 'Micro 60' Opaque Stay-Up Stocking
    $ 34.99
    Glamory 'Micro 60' Opaque Stay-Up Stocking
  • MAIN ITEM
  • Glamory 'Mesh' Fishnet Stay-Up Stockings
    LG - 4X
    Checking inventory...
    Glamory 'Mesh' Fishnet Stay-Up Stockings
    $ 34.99
    Glamory 'Mesh' Fishnet Stay-Up Stockings
  • MAIN ITEM
  • Glamory 'Couture 20' Backseam Stay-Up Stockings
    LG - 4X
    Checking inventory...
    Glamory 'Couture 20' Backseam Stay-Up Stockings
    $ 39.99
    Glamory 'Couture 20' Backseam Stay-Up Stockings
  • MAIN ITEM
  • Glamory 'Comfort 20' Stay-Up Stockings
    L - 4X
    Checking inventory...
    Glamory 'Comfort 20' Stay-Up Stockings
    $ 39.99
    Glamory 'Comfort 20' Stay-Up Stockings
  • MAIN ITEM
  • Glamory 'Dream 20' Lace Top Stockings
    LG - 4X
    Checking inventory...
    Glamory 'Dream 20' Lace Top Stockings
    $ 34.99
    Glamory 'Dream 20' Lace Top Stockings