(0)
SEARCH
foreveryourslingerie.ca/categories/?cName=Shirley_of_Hollywood&categoryId=5&shop=Panties&brandName=Shirley+of+Hollywood

Shirley of Hollywood

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,17682,255,231,17544,163,140,17144,17546,17143,17538,6118,17146,17139,12202,16966,16686,16266,17088,17097,17217,17998,17996,12792,118,286,15524,12691,15516,425,166,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,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='Shirley of Hollywood' 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
  • Shirley of Hollywood Ruffle Shorts
    Plus Sizing
    Checking inventory...
    Shirley of Hollywood Ruffle Shorts
    $ 34.99
    Shirley of Hollywood Ruffle Shorts