(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(262,11314,11322,11575,11312,11321,11505,11694,11316,208,12885,90,2934,6117,12046,12889,12893,12203,11588,12516,12580,11400,11135,12667,12681,940,821,10464,11112,12523,12842,1049,146,2930,424,3754,11691,11138,12514,12513,11315,11313,843,11818,6454,5532,10003,622,12054,11407,12529,12855,12830,12694,11327,231,12892,163,140,2925,2924,5386,2926,6118,12881,12202,11587,12522,12552,12792,12048,11394,11117,12521,12691,425,12884,166,12050,11739,12883,11591,12528,12608,6455,10004,10005,10006,10020,11690,11358,3749,5528,8824,11692,11397,11157,11693,12483,12484,12658,12676,1001,12790,182,8068,9915,567,941,12690,7127,11659,1980,12294,5313,2817,12221,533,11292,7587,11083,4472,9370,5329,11677,262,5330,12461,9359,12480,2,9127,12119,7755,11572,12349,7547,5412,11747,11763,10679,11451,21,11626,8268,12669,12680,8267,176,39,592,1698,10460,915,8,11288,2759,2760,11359,11331,7504,10869,5332,420,12788,8204,12782,5321,9846,10944,10196,1781,807,924,9640,1127,10860,10862,1854,11223,11212,11477,7769,11198,11182,11653,349,12836,5320,5318,1682,7289,7371,6190,6471,6470,7368,6913,10009,8837,9431,9412,11649,787,295,6130,12205,9456,9492,9457,43,12124,10166,5286,12212,12200,10923,10927,10908,10874,8896,7702,7063,12241,11778,11787,11777,11783,1237,504,11063,11059,11417,11418,11422,11455,9353,5210,292,3904,3908,5126,5691,9985,11956,8455,1112,12493,788,10715,10714,11226,11234,11203,11209,350,11475,11476,6672,6505,2677,117,169,526,11119,3418,3412,3410,194,6423,121,582,597,10111,10114,7820,7822,7821,7823,9537,9542,987,12312,11708,7824,7819,11681,7514,10806,1059,11740,487,2819,5213,7515,9881,12127,901,857,949,601,545,11438,9819,8874,10949,842,248,12055,12056,6534,9149,6563,9124,6209,630,12172,986,9864,8850,463,12188,188,4669,4659,8733,4635,8716,12369,12376,3033,7625,7598,9647,3176,11334,11333,11338,11480,6338,11329,6328,8555,11481,11478,10282,11328,11332,11342,10812,10809,3274,12427,10279,11585,6980,5261,7246,12622,3972,12008,12314,9101,12213,5136,6355,5248,11921,11,4533,114,11116,12410,12568,10307,10289,12072,12333,12305,5462,7238,10276,8553,10292,12419,11584,725,9283,11697,5628,5627,9274,12722,7500,11724,9757,6348,8560,8545,12426,12074,12067,10277,12732,9692,9566,12264,7811,430,399,860,902,4,190,12573,11114,12614,10139,7039,11995,11761,48,10741,2828,10138,10140,10918,10929,12238,12597,11601,10480,6642,11517,11593,11807,11715,11721,10749,17,11091,11167,344,10746,11595,11596,154,7219,158,10504,7308,4675,11615,10678,10946,12657,10955,12083,11389,12031,12226,12231,12228,11622,10044,4768,10409,10884,10882,10890,11215,12262,10849,11964,12465,11993,12232,12233,11264,12229,8138,11454,12219,12273,10928,11099,11102,11095,11980,11963,12822,12819,12818,12821,12816,12362,12394,12391,12752,12332,12396,12384,12304,12759,10677,11609,12382,12383,12311,12320,12757,12387,12390,12324,12402,12406,12405,12403,12407,11092,1673,9521,11152,12372,9514,9517,11132,12359,12655,10388,8392,8376,8375,8635,8636,9212,11709,12674,9194,12518,12517,12515,10401,10406,11966,10426,10418,12866,12858,12100,12169,281,310,300,7700,4355,5577,4320,5578,10562,5343,4334,11151,12126,11153,12117,8056,8051,12342,12350,8763,8790,12078,12129,12150,12178,2193,4425,9758,11570,11568,11208,11222,11569,2254,1735,1432,11089,3662,11090,8601,8608,10839,10838,12811,12644,5803,12653,12288,10939,10941,11975,12112,11147,11753,11134,12486,11713,11704,6201,201,5833,10397,10402,11096,12158,12095,12163,12060,12061,12062,10754,12049,8290,8019,9484,9453,10724,9435,9269,9263,12678,12086,9262,12282,9268,9384,11983,12504,12040,12496,9260,11759,9832,11269,6380,8729,6402,621,10630,10606,10624,10847,11801,12820,11200,11564,12044,10887,10883,11802,12110,10940,10629,12705,12082,11352,12236,10016,10598,10623,7088,1906,1421,8606,7771,7736,7767,8890,9839,9845,9997,9995,10052,10046,12063,520,1436,11347,11804,5316,12266,12269,600,1073,11698,11699,9541,9221,12718,7577,710,12019,12017,11879,12351,10735,12335,11018,2146,10756,12303,12204,12317,12328,11642,12271,12431,8085,12132,10885,3366,11842,11831,20,12270,11636,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 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 Portia Balcony Bra
    E - JJ Cups
    Checking inventory...
    Curvy Kate Portia Balcony Bra
    $ 49.99
    Reg. $ 89.99
    Curvy Kate Portia Balcony 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 Strappy Brief Bikini
    S - 3X
    Checking inventory...
    Curvy Kate Hi Voltage Strappy Brief Bikini
    $ 69.99
    Curvy Kate Hi Voltage Strappy Brief Bikini
  • MAIN ITEM
  • Curvy Kate Galaxy Hi-Waist Brief
    S - 3X
    Checking inventory...
    Curvy Kate Galaxy Hi-Waist Brief
    $ 39.99
    Reg. $ 69.99
    Curvy Kate Galaxy Hi-Waist Brief