(0)
SEARCH
foreveryourslingerie.ca/categories/?cName=Fleurt&categoryId=5&shop=Lingerie&brandName=Fleur%27t

Fleurt

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(9396,11377,9402,9404,2926,118,6674,1001,9915,10810,8991,8988,1980,6,5313,10338,12220,11292,11287,9792,9784,10355,10358,11070,11080,2133,5329,5330,2,5407,9054,541,4199,6181,6179,6178,6177,592,1698,915,8,5332,294,512,5321,5299,1781,807,924,890,9640,1127,1854,6234,5315,368,5320,5318,584,1682,4288,7370,10325,11039,9070,198,8484,2824,9952,7663,11063,11059,11058,11062,8494,5207,62,12014,11956,8445,1112,10368,11475,11472,10363,10364,11868,9071,6672,6505,8327,10372,3418,3414,3412,3420,6423,9362,10492,10490,121,9143,10111,10114,7820,7822,7821,7823,7824,7819,12027,5213,842,248,731,1050,522,141,6534,9149,6549,9124,450,7366,12188,3031,3033,10331,7625,7598,7596,9648,91,9647,11479,11334,10333,11333,11338,11480,6338,11329,6328,8551,11481,11478,11328,11332,11337,10812,7255,5509,7257,5261,7235,10278,11987,8722,5137,5136,5138,5248,4577,4533,5476,10307,10289,12072,5462,7238,10276,8553,10292,7202,5496,11972,6348,8560,8545,10312,12074,12067,12073,5485,10811,9568,399,860,49,902,4,190,11981,9129,9097,11121,11610,11601,6635,10753,11605,11593,10749,195,10637,154,7222,6166,7218,10639,7682,12223,10567,9499,8352,8325,10504,7035,7013,7308,7049,6551,4675,9485,10027,10044,11303,11304,8138,7660,10424,8392,10418,5577,10214,8601,8608,10032,10839,10838,8723,11155,10727,11705,5833,11924,8606,7374,10052,10046,10033,520,5331,5316,10795,11108,11106,10736,20,951) AND c.name='Fleur\'t' 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
  • Fleur't Lace Bust Chemise
    S/M - L/L
    Checking inventory...
    Fleur't Lace Bust Chemise
    $ 89.99
    Fleur't Lace Bust Chemise