(0)
SEARCH

Prima Donna

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(12362,11314,11322,11575,11312,11321,16433,16434,11319,11320,16694,11694,14008,14455,15729,15324,15399,16407,16968,11323,11316,17680,16688,15356,14308,14009,17681,14456,16409,16963,17684,10145,16463,10542,15127,12514,14309,15329,15398,17200,11317,11315,11313,554,843,17565,17003,15214,17895,17992,18106,622,17893,12694,16262,16276,15518,16287,16274,17076,16950,16951,17141,17961,18099,17682,255,231,17544,163,140,17144,17546,17143,17538,6118,17986,17146,17139,12202,18134,18128,16966,16686,16266,17088,17097,17217,17946,17952,17998,17996,12792,118,286,15524,12691,17971,18096,425,166,17988,18137,16924,16678,16292,7127,11659,16554,16550,5317,16074,15563,15706,2,5311,13846,17690,17679,17266,11582,8268,17955,17951,11359,17973,16549,17087,18110,18112,17106,5332,5307,8286,9651,17353,17350,10009,14722,16799,11649,15948,15520,17949,12206,15736,15975,15664,16286,17818,16295,16281,16683,17153,17024,504,11445,11417,13368,11418,11431,11446,11455,16506,13903,13377,17649,17667,17969,117,169,12661,358,9537,10806,13847,14589,14324,7515,15039,15064,14669,842,248,6291,10864,18114,17579,17051,18113,17666,17658,17596,17598,16367,14333,17053,17657,17668,17063,14105,18107,16509,16497,17976,17948,17080,17945,17664,10282,6980,17229,17541,9101,15354,14592,14338,12213,17965,14194,17962,17958,17000,17045,17608,17568,17150,17140,17554,16940,17563,17650,17656,17722,17723,16936,17081,10918,10929,12955,16512,17683,16493,11715,18041,17040,12857,14362,16681,17685,17956,17652,17660,912,16779,8686,17812,7336,6555,11424,11462,16467,17348,16264,16290,13069,13099,14139,17903,17907,18126,18139,18124,18147,10882,10890,16430,13527,13592,15254,15255,17256,15233,12273,12362,12394,12752,12332,12396,12361,12343,12336,12384,12304,12759,12374,12367,12311,12321,12402,12406,12405,12403,12404,12407,10146,8636,12674,18101,16680,17196,12980,15338,17836,17232,13242,13217,16272,15328,16919,17578,18123,16917,17574,17203,16962,17687,11153,17464,17995,15228,15229,17429,15767,17238,17636,16829,16205,17198,17349,12811,12815,17195,17678,17191,17686,18079,16907,18078,17801,17802,17675,17676,17904,17906,18092,18094,10740,10941,10781,10943,13628,13142,5833,8019,18120,16660,17677,15582,11310,16431,16354,10847,15231,17254,15586,13590,13588,17255,14245,17230,15528,13525,17440,15194,12269,15584,17793,11699,7451,13146,7421,7416,7409,15583,16432,15768,14459,15252,16836,17235,15585,17732,8085,10885,11993,17458,15193,17236,13744,13741) AND c.name='Prima Donna' 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 57
    MAIN ITEM
  • PrimaDonna Baboushka Full Brief
    M - 3X
    Checking inventory...
    PrimaDonna Baboushka Full Brief
    $ 119.99
    PrimaDonna Baboushka Full Brief
  • MAIN ITEM
  • PrimaDonna Baboushka Rio Brief
    M - 2X
    Checking inventory...
    PrimaDonna Baboushka Rio Brief
    $ 99.99
    PrimaDonna Baboushka Rio Brief
  • MAIN ITEM
  • PrimaDonna Baboushka Lace Shorts
    M - 2X
    Checking inventory...
    PrimaDonna Baboushka Lace Shorts
    $ 119.99
    PrimaDonna Baboushka Lace Shorts
  • MAIN ITEM
  • PrimaDonna Twist Boss Babe Hotpants
    XS - 2X
    Checking inventory...
    PrimaDonna Twist Boss Babe Hotpants
    $ 69.99
    PrimaDonna Twist Boss Babe Hotpants
  • MAIN ITEM
  • PrimaDonna Twist Boss Babe Thong
    XS - XL
    Checking inventory...
    PrimaDonna Twist Boss Babe Thong
    $ 69.99
    PrimaDonna Twist Boss Babe Thong
  • MAIN ITEM
  • PrimaDonna Candle Light Full Brief
    M - 3X
    Checking inventory...
    PrimaDonna Candle Light Full Brief
    $ 79.99
    PrimaDonna Candle Light Full Brief
  • MAIN ITEM
  • PrimaDonna Candle Light Rio Brief
    S - 2X
    Checking inventory...
    PrimaDonna Candle Light Rio Brief
    $ 69.99
    PrimaDonna Candle Light Rio Brief
  • MAIN ITEM
  • PrimaDonna Gracious Full Brief
    M - 3X
    Checking inventory...
    PrimaDonna Gracious Full Brief
    $ 79.99
    PrimaDonna Gracious Full Brief
  • MAIN ITEM
  • PrimaDonna Gracious Thong
    S - XL
    Checking inventory...
    PrimaDonna Gracious Thong
    $ 69.99
    PrimaDonna Gracious Thong
  • MAIN ITEM
  • PrimaDonna Twist 1919 Hotpants
    XS - 2X
    Checking inventory...
    PrimaDonna Twist 1919 Hotpants
    $ 79.99
    PrimaDonna Twist 1919 Hotpants
  • MAIN ITEM
  • PrimaDonna Twist 1919 Thong
    XS - XL
    Checking inventory...
    PrimaDonna Twist 1919 Thong
    $ 59.99
    PrimaDonna Twist 1919 Thong
  • MAIN ITEM
  • Prima Wild Flower Full Brief
    M - 3X
    Checking inventory...
    Prima Wild Flower Full Brief
    $ 74.99
    Prima Wild Flower Full Brief
  • MAIN ITEM
  • PrimaDonna Wild Flower Rio Brief
    S - 2X
    Checking inventory...
    PrimaDonna Wild Flower Rio Brief
    $ 69.99
    PrimaDonna Wild Flower Rio Brief
  • MAIN ITEM
  • PrimaDonna Twist I Want You Hotpants
    S - 2X
    Checking inventory...
    PrimaDonna Twist I Want You Hotpants
    $ 59.99
    PrimaDonna Twist I Want You Hotpants
  • MAIN ITEM
  • PrimaDonna Twist Fame Hotpants
    XS - 2X
    Checking inventory...
    PrimaDonna Twist Fame Hotpants
    $ 69.99
    PrimaDonna Twist Fame Hotpants
  • MAIN ITEM
  • PrimaDonna Twist Fame Thong
    XS - XL
    Checking inventory...
    PrimaDonna Twist Fame Thong
    $ 59.99
    PrimaDonna Twist Fame Thong
Items 1-16 of 57