(0)
SEARCH

Curvy Kate

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(11314,11322,11575,11312,11321,11505,11316,208,13434,12885,2934,6117,12841,13436,12889,12203,11588,12516,13116,13121,13861,13995,13998,13717,11135,12667,940,821,12823,13883,12843,12523,12853,1049,146,2930,424,11138,12514,11315,11313,6454,5532,10003,622,11407,13887,12856,12694,14034,14040,13463,231,13433,163,140,2925,5386,2926,6118,12867,12863,12202,12522,12552,13118,13117,13852,13994,13701,12792,12521,12691,425,13468,166,12883,12528,12608,13120,6455,10004,10005,10020,11690,12895,11358,3749,13458,5528,8824,11157,11693,12898,12484,12658,12676,1001,12790,13192,182,8068,567,941,12690,7127,13147,13530,11659,1980,12574,5313,533,13012,12983,13024,13042,12995,12986,12993,2133,13036,4472,9370,5317,262,5330,13726,9359,2,9127,7755,11572,12551,7547,11747,11763,10679,11451,21,12662,11626,12665,13259,13100,13265,8268,12669,8267,176,39,592,1698,12785,915,8,11301,2759,2760,11359,11331,7504,10869,420,5307,13286,12788,13444,8204,12782,5321,9846,807,924,9640,1854,5302,11477,7769,11653,349,13392,13391,13480,13510,13511,13405,13409,5318,6190,6471,6470,8837,9431,9412,11649,787,295,12205,9492,13177,43,12903,10166,12212,12200,13693,13674,10874,7702,7063,12243,11778,11787,11777,11783,1237,504,13758,13762,11059,11417,11418,11422,11455,9185,9171,9353,5210,292,14026,3934,5126,11956,1112,13004,13056,13046,13115,13039,13048,12994,13020,13377,788,13520,13481,12899,350,11476,6672,6505,2677,117,169,13082,194,6423,121,582,597,10111,10114,7820,7822,7823,9537,9542,987,12312,11708,13460,7824,7819,13178,10806,1059,13188,11740,487,7515,12947,12837,12127,901,857,13307,13302,14018,14016,14020,14017,949,601,13430,13459,12055,12056,13802,6563,13820,986,13806,13815,13811,463,13801,12188,188,4669,12340,12306,8733,4635,12368,8716,12768,12369,12376,3033,7625,7583,9647,11479,11334,13187,11333,11339,11480,11329,6328,10282,11328,11332,11342,13894,10813,13897,10809,13895,13904,10279,12777,12914,12314,13437,12213,114,12410,12568,10306,12072,7238,10288,8553,12419,11584,725,9283,5628,12764,5627,9274,13659,7500,9757,6348,8574,8545,12069,12067,9566,12264,7811,669,399,860,902,4,738,12614,10139,48,12597,13456,13435,12959,11601,12929,12955,13609,12902,13700,13182,13189,11593,13439,11715,11721,12857,12827,17,11091,11167,344,11595,11596,154,7219,158,912,4675,10946,10764,13306,13375,12226,12231,4768,10884,10882,10890,13742,13740,12262,10849,11964,13743,13738,12554,12576,12555,12566,12600,12229,12219,12273,11099,11102,11095,11980,13918,12819,13899,13908,13905,12362,12394,12752,12332,14014,12384,12304,12759,13258,12382,12383,12311,14010,12757,12387,12390,12324,13737,13992,13935,13938,13934,13957,13956,12402,12406,12405,12403,12404,12407,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,3662,14113,8601,8608,10838,12846,12861,12288,10939,10941,13084,13707,11753,11713,13142,5833,12158,12095,12163,12060,12061,12062,13314,13311,13671,13697,13634,8290,10724,9435,9269,9263,12678,12086,9262,12282,13449,9268,9384,13076,13878,12504,13065,13879,12040,9260,13893,11759,14072,14073,11269,6380,13698,13691,13625,13695,13664,13675,8729,6402,621,10847,11564,12705,12082,11352,12236,12704,12539,10598,10623,7088,1421,8606,9997,12804,12786,12778,13096,13089,12063,520,1436,11347,13467,5316,12266,12269,12954,600,1073,11699,9541,9221,12718,7577,13545,12329,13766,13768,11018,13798,2146,10756,13774,13788,13777,12303,13779,12431,8085,10885,11993,3366,11831,13687,13667,13943,11636,13744,13741,4241,4253) AND c.name='Curvy Kate' 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
  • Curvy Kate Can Can Plunge Bra
    E - J Cup
    Checking inventory...
    Curvy Kate Can Can Plunge Bra
    $ 79.99
    Reg. $ 109.99
    Curvy Kate Can Can Plunge Bra
  • MAIN ITEM
  • Curvy Kate Smoothie Soul Latte Plunge Bra
    F - J Cups
    Checking inventory...
    Curvy Kate Smoothie Soul Latte Plunge Bra
    $ 69.99
    Curvy Kate Smoothie Soul Latte Plunge Bra
  • MAIN ITEM
  • Curvy Kate Hi Voltage Plunge Tankini top
    F - HH Cups
    Checking inventory...
    Curvy Kate Hi Voltage Plunge Tankini top
    $ 119.99
    Curvy Kate Hi Voltage Plunge Tankini top
  • MAIN ITEM
  • Curvy Kate Hi Voltage Plunge Bikini Top
    E - HH Cups
    Checking inventory...
    Curvy Kate Hi Voltage Plunge Bikini Top
    $ 99.99
    Curvy Kate Hi Voltage Plunge Bikini Top
  • MAIN ITEM
  • Curvy Kate Hi Voltage Bikini Bottom
    S - 3X
    Checking inventory...
    Curvy Kate Hi Voltage Bikini Bottom
    $ 69.99
    Curvy Kate Hi Voltage Bikini Bottom