BOUTIQUE
SEARCH
foreveryourslingerie.ca/categories/?cName=Coquette&categoryId=5&shop=Lingerie&brandName=Coquette

Coquette

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(9632,9396,11377,9402,9404,2926,118,6674,1001,9914,9915,10810,8991,8988,11294,1980,6,5313,10338,11302,11292,11287,9792,9784,10351,10355,10356,11070,11080,5306,2133,5329,5330,2,5407,923,9054,541,4204,4199,4201,6181,6179,6178,6177,592,1698,915,8,5332,294,512,5307,5321,5299,1781,807,924,890,9640,1127,1854,6234,5315,368,5320,5318,584,1682,4288,7370,10325,11039,9070,198,9206,9190,8484,2824,9952,7663,11063,11059,11058,11061,8494,5207,502,62,5325,8445,1112,10368,11472,10363,10364,9071,6672,6505,8327,10372,3418,3414,3412,3420,161,667,6423,9362,10492,10490,121,9143,10111,10114,7820,7822,7821,7823,7824,7819,10337,5213,842,248,731,180,1050,522,141,6534,9149,9124,450,7965,7366,3031,3033,10331,7625,7598,7589,7596,9648,91,9647,11479,10333,6338,6328,8551,11481,11478,10812,7664,7253,5509,7257,7241,5261,7235,10278,8722,5137,5136,5138,10328,5248,4577,4544,4533,9078,10335,5475,10307,10289,5462,7238,8553,10292,7202,5496,11047,5505,6348,9587,8560,8545,10312,5485,10811,9593,9568,3759,399,860,49,902,4,190,11416,9129,9097,11121,11601,6635,312,10753,11593,11031,10749,195,10637,154,7222,6166,7218,10640,7682,10567,10568,9499,8352,8325,10504,7035,7013,7308,7049,6551,4675,9485,1532,6883,10027,10044,11303,11304,8138,7660,10424,8392,10418,5577,10214,8601,8608,10032,10839,10838,8723,11155,10727,5833,8606,7374,10052,10046,8592,10033,520,5331,5316,10795,11108,11106,10736,20,951,11637) AND c.name='Coquette' AND p.visible=1 AND vo.visible=1 GROUP BY vo.samefldALU ORDER BY p.addedDate desc limit 0,32
Shop By       
Shop By Colour:
Items 1-32 of 41
    MAIN ITEM
  • Coquette Scalloped Lace Babydoll
    S - 3X/4X
    Checking inventory...
    Coquette Scalloped Lace Babydoll
    $ 54.99
    Coquette Scalloped Lace Babydoll
  • MAIN ITEM
  • Coquette Stretch Lace Bustier
    S - 3X/4X
    Checking inventory...
    Coquette Stretch Lace Bustier
    $ 79.99
    Coquette Stretch Lace Bustier
  • MAIN ITEM
  • Coquette Microfibre Babydoll
    S - 3X/4X
    Checking inventory...
    Coquette Microfibre Babydoll
    $ 59.99
    Coquette Microfibre Babydoll
  • MAIN ITEM
  • Coquette Lace & Dot Babydoll
    S - 3X/4X
    Checking inventory...
    Coquette Lace & Dot Babydoll
    $ 49.99
    Coquette Lace & Dot Babydoll
  • MAIN ITEM
  • Coquette Chiffon Babydoll
    Checking inventory...
    Coquette Chiffon Babydoll
    $ 69.99
    Coquette Chiffon Babydoll
  • MAIN ITEM
  • Coquette Ruffle Panty
    Checking inventory...
    Coquette Ruffle Panty
    $ 14.99
    Coquette Ruffle Panty
  • MAIN ITEM
  • Coquette Lace Babydoll
    Checking inventory...
    Coquette Lace Babydoll
    $ 59.99
    Coquette Lace Babydoll
  • MAIN ITEM
  • Coquette Lace Cup Babydoll
    Checking inventory...
    Coquette Lace Cup Babydoll
    $ 49.99
    Coquette Lace Cup Babydoll
  • MAIN ITEM
  • Coquette Lace Babydoll with Removable Cap Sleeves
    Three Ways to Wear!
    Checking inventory...
    Coquette Lace Babydoll with Removable Cap Sleeves
    $ 59.99
    Coquette Lace Babydoll with Removable Cap Sleeves
  • MAIN ITEM
  • Coquette Sheer Flyaway Lace Babydoll
    Checking inventory...
    Coquette Sheer Flyaway Lace Babydoll
    $ 59.99
    Coquette Sheer Flyaway Lace Babydoll
  • MAIN ITEM
  • Coquette Bustier with Peek-a-Boo Bra Cups
    Checking inventory...
    Coquette Bustier with Peek-a-Boo Bra Cups
    $ 79.99
    Coquette Bustier with Peek-a-Boo Bra Cups
  • MAIN ITEM
  • Coquette Hi-Waist Garter Belt
    Checking inventory...
    Coquette Hi-Waist Garter Belt
    $ 38.99
    Coquette Hi-Waist Garter Belt
  • MAIN ITEM
  • Coquette Thong
    Checking inventory...
    Coquette Thong
    $ 12.99
    Coquette Thong
  • MAIN ITEM
  • Coquette Side-tie Lace Panty
    Checking inventory...
    Coquette Side-tie Lace Panty
    $ 14.99
    Coquette Side-tie Lace Panty
  • MAIN ITEM
  • Coquette Hi-Waist Garter Skirt
    Checking inventory...
    Coquette Hi-Waist Garter Skirt
    $ 19.99
    Coquette Hi-Waist Garter Skirt
  • MAIN ITEM
  • Coquette Hi-Waist Garter Belt
    Checking inventory...
    Coquette Hi-Waist Garter Belt
    $ 19.99
    Coquette Hi-Waist Garter Belt
  • MAIN ITEM
  • Coquette Asymmetrical Lace Panty
    Checking inventory...
    Coquette Asymmetrical Lace Panty
    $ 14.99
    Coquette Asymmetrical Lace Panty
  • MAIN ITEM
  • Coquette Front to Back Lace Up Panty
    Checking inventory...
    Coquette Front to Back Lace Up Panty
    $ 19.99
    Coquette Front to Back Lace Up Panty
  • MAIN ITEM
  • Coquette Lilac Lace Babydoll & Panty
    Checking inventory...
    Coquette Lilac Lace Babydoll & Panty
    $ 49.99
    Coquette Lilac Lace Babydoll & Panty
  • MAIN ITEM
  • Coquette Crotchless Panty with Ribbon Cuffs
    Checking inventory...
    Coquette Crotchless Panty with Ribbon Cuffs
    $ 19.99
    Coquette Crotchless Panty with Ribbon Cuffs
  • MAIN ITEM
  • Coquette Mask & Chained Handcuff Belt
    Checking inventory...
    Coquette Mask & Chained Handcuff Belt
    $ 24.99
    Coquette Mask & Chained Handcuff Belt
  • MAIN ITEM
  • Coquette French Maid Babydoll
    Checking inventory...
    Coquette French Maid Babydoll
    $ 29.99
    Coquette French Maid Babydoll
  • MAIN ITEM
  • Coquette Nurse Babydoll
    Checking inventory...
    Coquette Nurse Babydoll
    $ 29.99
    Coquette Nurse Babydoll
  • MAIN ITEM
  • Coquette Cage Panty
    Checking inventory...
    Coquette Cage Panty
    $ 19.99
    Coquette Cage Panty
  • MAIN ITEM
  • Coquette Cage Bow Panty
    Checking inventory...
    Coquette Cage Bow Panty
    $ 19.99
    Coquette Cage Bow Panty
  • MAIN ITEM
  • Coquette Lace Booty Short
    Checking inventory...
    Coquette Lace Booty Short
    $ 14.99
    Coquette Lace Booty Short
  • MAIN ITEM
  • Coquette Corset with Lace
    Checking inventory...
    Coquette Corset with Lace
    $ 89.99
    Coquette Corset with Lace
  • MAIN ITEM
  • Coquette Lace Babydoll & G-String
    Checking inventory...
    Coquette Lace Babydoll & G-String
    $ 49.99
    Coquette Lace Babydoll & G-String
  • MAIN ITEM
  • Coquette Ruffle Crotchless Panty
    Checking inventory...
    Coquette Ruffle Crotchless Panty
    $ 24.99
    Coquette Ruffle Crotchless Panty
  • MAIN ITEM
  • Coquette Sheer Thigh High Stockings
    Checking inventory...
    Coquette Sheer Thigh High Stockings
    $ 8.99
    Coquette Sheer Thigh High Stockings
  • MAIN ITEM
  • Coquette Backseam Stockings
    Checking inventory...
    Coquette Backseam Stockings
    $ 9.99
    Coquette Backseam Stockings
  • MAIN ITEM
  • Coquette Ruffle Garterbelt
    Checking inventory...
    Coquette Ruffle Garterbelt
    $ 24.99
    Coquette Ruffle Garterbelt
Items 1-32 of 41