(0)
SEARCH

Freya

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,10542,12514,14309,15329,15398,17200,11317,11315,11313,554,843,17565,17003,15214,17895,17992,622,17893,15885,15857,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,16966,16686,16266,17088,17097,17217,17946,17952,17998,17996,12792,118,286,15524,12691,17971,18096,425,166,17988,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,17106,5332,5307,8286,9651,17353,17350,10009,14722,16081,16799,11649,15948,15520,17949,12206,15736,15975,14154,14158,15664,16286,17818,16295,16281,16683,17153,17038,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,17579,17051,17666,17658,17651,17596,17598,16367,14333,17053,17657,17668,17063,14105,16509,16497,17976,17080,17664,10282,6980,17229,17541,17036,9101,15354,14592,14338,12213,17965,14194,17962,17008,17958,17000,17045,17150,17140,17554,16940,17563,17650,17656,17722,17723,16960,17426,17107,16936,17081,10918,10929,12955,16512,17683,16493,17082,11715,18041,17040,12857,14362,16681,17685,17025,17956,17652,17660,912,16779,8686,17812,7336,6555,11424,11462,15871,16467,16468,17348,16264,16290,13069,13099,14139,17903,17907,10882,10890,16430,13527,13592,15254,15255,17256,15233,12273,12362,12394,12752,12332,12396,12361,12343,12336,14014,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,16917,17574,17203,17083,16962,17687,11153,17464,17995,15228,15229,17429,15767,17238,17636,16829,16830,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,16660,17677,17104,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,15256,8085,10885,11993,17458,15193,17236,13744,13741) AND c.name='Freya' 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
  • Freya Viva Brazilian
    XS - XL
    Checking inventory...
    Freya Viva Brazilian
    $ 29.99
    Freya Viva Brazilian
  • MAIN ITEM
  • Freya Viva Short
    XS - XL
    Checking inventory...
    Freya Viva Short
    $ 29.99
    Freya Viva Short
  • MAIN ITEM
  • Freya Fancies Hipster
    XS - 2X
    Checking inventory...
    Freya Fancies Hipster
    $ 29.99
    Freya Fancies Hipster
  • MAIN ITEM
  • Freya Jasmine Meadow Brief
    S - XL
    Checking inventory...
    Freya Jasmine Meadow Brief
    $ 19.99
    Reg. $ 39.99
    Freya Jasmine Meadow Brief
  • MAIN ITEM
  • Freya Rhea Short
    S - XL
    Checking inventory...
    Freya Rhea Short
    $ 29.99
    Reg. $ 39.99
    Freya Rhea Short
  • MAIN ITEM
  • Freya Rhea Brazilian
    S - XL
    Checking inventory...
    Freya Rhea Brazilian
    $ 29.99
    Reg. $ 39.99
    Freya Rhea Brazilian
  • MAIN ITEM
  • Freya Chi Brazillian Panty
    S - XL
    Checking inventory...
    Freya Chi Brazillian Panty
    $ 29.99
    Freya Chi Brazillian Panty
  • MAIN ITEM
  • Freya Chi Short
    S - XL
    Checking inventory...
    Freya Chi Short
    $ 29.99
    Freya Chi Short
  • MAIN ITEM
  • Freya Escape Lace Short Panty
    S - XL
    Checking inventory...
    Freya Escape Lace Short Panty
    $ 34.99
    Freya Escape Lace Short Panty
  • MAIN ITEM
  • Freya Daisy Lace Short
    S - XL
    Checking inventory...
    Freya Daisy Lace Short
    $ 39.99
    Freya Daisy Lace Short
  • MAIN ITEM
  • Freya Soiree Lace Short
    S - XL
    Checking inventory...
    Freya Soiree Lace Short
    $ 39.99
    Freya Soiree Lace Short
  • MAIN ITEM
  • Freya Idol Allure Hipster
    S - XL
    Checking inventory...
    Freya Idol Allure Hipster
    $ 45.99
    Freya Idol Allure Hipster
  • MAIN ITEM
  • Freya Idol Allure Deep Thong
    S - XL
    Checking inventory...
    Freya Idol Allure Deep Thong
    $ 39.99
    Freya Idol Allure Deep Thong
  • MAIN ITEM
  • Freya 'Fancies' Lace Hipster Short
    S - 2X
    Checking inventory...
    Freya 'Fancies' Lace Hipster Short
    $ 29.99
    Freya 'Fancies' Lace Hipster Short
  • MAIN ITEM
  • Freya 'Idol' Moulded Balconette Bra
    E - HH Cup
    Checking inventory...
    Freya 'Idol' Moulded Balconette Bra
    $ 89.99
    Freya 'Idol' Moulded Balconette Bra
  • Freya 'Deco-Vibe' Brazilian Thong
    S - XL
    Checking inventory...
    Freya 'Deco-Vibe' Brazilian Thong
    $ 34.99
    Freya 'Deco-Vibe' Brazilian Thong