(0)
SEARCH
foreveryourslingerie.ca/categories/?cName=Soak&categoryId=5&shop=Products&brandName=Soak

Soak

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(597,11314,11322,11575,11312,11321,16433,16434,11319,11320,832,15536,16694,11694,14008,14455,15729,15324,15399,16407,16968,768,15511,11323,16291,11316,208,90,17138,6117,14513,17137,12203,15365,15855,16927,16690,16293,17085,10991,16688,15356,16120,14308,14009,14456,15728,16409,16963,940,10145,10542,821,15887,15508,16260,17093,16928,17134,1049,2930,14542,15323,15500,424,16130,12514,14309,15329,15398,17200,16222,11317,11315,11313,554,843,17565,17003,15214,622,15885,15857,12694,16262,16276,15518,16287,16274,17076,16950,16951,17141,255,231,163,140,17144,17143,2925,2924,5386,2926,6118,17146,17139,12202,15390,15346,15380,15884,16966,16686,16266,17088,17097,12792,118,286,15524,12691,14031,15516,425,166,14507,15392,16924,16678,16292,10004,17552,10005,16673,15333,17039,11690,16406,11358,11693,12512,14322,14007,14453,15203,15727,15326,15400,16408,16932,17197,1001,12790,603,14751,14750,15261,567,941,12690,7127,13147,13530,13143,11659,13583,15614,5336,533,16554,16550,17158,17168,2133,16633,4472,5317,16636,15959,16627,16626,15977,16622,262,15080,13727,7938,7109,15967,15563,15706,2,16631,16629,16632,16634,16637,16630,16639,16620,9127,5311,5412,13846,10679,3586,17267,17266,11626,16428,17372,14330,11582,8268,10635,8267,14250,14248,14247,14252,14251,14515,14249,97,15809,16526,592,15385,915,204,11359,494,2966,7504,10872,8438,14286,16549,17087,17092,17106,5332,17674,5307,8283,8204,12782,5321,1781,807,924,193,890,9651,1127,1854,16889,5302,6400,16353,7769,349,15505,17059,13862,13494,13491,13508,13511,5318,16727,16723,16736,16722,16721,16737,16735,16732,16756,16724,16726,16741,16703,16137,16711,16700,16114,16121,16710,14688,16852,17673,17353,17350,15946,10009,15526,16081,15523,16080,16799,15952,11649,787,295,12491,16278,15948,515,15531,15520,7882,12206,16223,15738,10167,14285,43,3757,15046,15947,15736,15975,14654,10166,12212,16005,14153,14154,14158,14142,10127,16520,15955,15664,16286,14211,16295,16281,15978,1157,15401,10874,15430,7704,7702,14033,16677,16683,7663,17153,17154,17038,17013,17024,7063,14987,12199,228,17125,17122,11786,11778,17212,17239,1230,498,36,504,16706,16758,16720,16095,16695,13758,16487,11059,11417,15992,13368,15999,11418,11431,11446,11455,9353,5210,292,14725,9988,16499,16506,13903,16346,13377,17649,17667,16475,16476,16477,16780,16778,16868,16874,16866,16943,16952,16914,17189,17188,17190,127,12899,14317,350,15197,13447,17187,17177,17185,14707,6505,17487,14658,117,169,13367,194,16524,13933,17182,358,14735,582,597,10111,10114,13756,7820,7822,13752,13755,17157,13753,14637,7821,7823,16784,9537,987,17018,16414,7824,7819,17604,17618,10806,13847,13188,17170,17167,11740,487,528,14589,14324,7515,15039,15064,901,857,601,16716,16699,16702,16697,16696,16094,16123,16119,545,16764,16125,14985,12418,12254,12253,6270,15072,14425,14669,842,816,16503,248,10856,17580,17009,16284,10864,17579,17051,14599,17666,17658,17672,17651,17655,17591,17596,17598,12055,16367,12056,16878,6523,6549,16876,17090,16877,14333,17053,986,17657,17668,16277,16941,3304,17659,15165,17401,17400,17406,17403,17402,17404,17405,17399,17063,12188,16501,14101,16507,14105,16509,16497,15264,188,4669,16933,12340,4659,16921,12306,4635,16913,12368,16983,17089,17080,17653,17664,14629,7625,7596,9647,11334,13185,17169,11333,11480,11329,17102,17079,8551,10282,11328,11332,13909,13914,13894,15581,13897,10809,15571,13904,13902,15580,3274,15574,15572,16801,16815,16805,16809,16825,16812,16808,16811,16813,16800,16806,16804,10805,6980,16504,17229,7046,16513,17225,17036,16984,17002,16561,8672,16495,12314,15841,13437,9101,15354,14592,14338,12213,114,17180,16498,12410,16511,2260,8402,14193,14194,17300,17283,7238,17321,17032,17008,17000,17031,16028,16020,16021,16033,16032,16014,17311,17318,17301,17288,17279,16981,17041,17045,17133,17135,17145,17150,17140,14303,16523,9283,16925,7500,17275,17294,17298,13837,16019,6348,15206,8560,8545,15200,15199,16940,15394,16970,13576,17223,8059,12499,9566,17226,15366,972,16267,16945,15375,12500,15122,12482,7803,12265,16265,16961,17077,12264,15213,16015,16038,17296,17282,17291,17096,17108,7889,17650,16022,16037,17656,16960,399,860,49,17426,902,16372,15673,17054,17052,17057,17055,17107,16936,17081,1025,48,14563,16234,17471,13629,10913,16412,10918,10929,16417,15076,11341,15447,17078,15617,17433,16231,15448,14579,15449,17094,16230,16944,17095,13731,16915,17454,16687,12955,16512,14463,12902,16505,14585,17105,16493,16923,17082,16494,17103,15074,13189,17173,13439,16508,11715,11721,17004,17040,15851,12857,12827,17,191,15558,14362,14383,154,16681,16674,14160,14157,519,17037,17025,16685,17375,17340,17341,17342,17343,17344,16382,16391,14872,14871,14874,13465,16224,17652,17660,912,16779,16775,11025,16658,8686,16659,7336,10124,6519,6555,16091,16419,16418,11421,11424,11462,15866,15871,15881,16466,16467,16468,17345,17348,16296,16264,14944,16290,10946,11561,210,13081,13103,13069,13099,14140,14139,15873,15865,15853,15878,16500,14099,14717,14275,15271,15486,15753,15144,8045,12380,12353,12358,12344,12366,9708,9717,8754,17269,17272,17271,10750,10776,10731,16843,10788,10764,12668,16964,16949,16935,16967,16931,17209,17208,17210,17211,17207,17576,17555,17570,17571,17581,17456,17387,16901,11935,11931,14112,205,789,692,3009,883,441,423,507,836,17164,17162,17248,17161,212,13757,10884,10882,10890,16847,15732,16430,16980,16787,13527,13526,13592,15769,16225,16838,17237,16835,16227,16792,16833,14663,15251,16828,16572,16837,15253,13740,15395,14204,15378,17480,16665,14457,16587,10849,14458,11964,16213,15254,15255,16668,16070,16472,16483,16071,16473,17016,17005,17394,17007,17020,17026,16140,14693,17635,16994,16995,16453,16162,9133,17256,15233,12273,12274,16056,15650,17250,17044,17028,17027,17257,13918,17305,17285,17303,17277,17293,16619,17331,17475,17477,14150,17312,17302,13908,14159,17455,17326,17287,14547,17310,17313,12362,12394,12752,12332,12396,12343,14014,12384,12304,12759,12367,12382,12311,14015,12750,15895,15633,12302,15634,14012,12749,12395,12290,12299,15507,12355,12291,14010,12757,12387,12324,13941,13935,13938,14298,13956,15147,15142,16882,12402,12406,12405,12403,12404,12407,16484,16491,1673,16451,9514,10146,16413,8635,8636,9212,16689,16672,12674,16680,17196,12979,12980,16085,15335,17218,15338,17232,13212,13242,13217,16271,16282,16272,15327,17567,15343,16957,16918,15328,16919,17578,16917,17574,17201,17203,17100,17083,16912,16962,7700,16410,4355,10562,5343,4334,11151,17463,14980,16662,11153,17464,16663,15731,14913,13216,13245,16773,16774,16771,16926,16956,16971,2193,4425,13211,15939,16643,11570,11568,13218,11208,11222,11569,15216,13223,13221,13224,15220,13243,13230,2254,1735,1432,15217,11871,14957,14959,14958,15228,15229,17411,17425,17429,3662,15767,16831,16832,17238,16226,16829,16830,16205,10839,1071,17199,17198,17349,12810,16088,12813,12811,12815,16084,14413,17192,17195,17191,16908,16907,16471,16470,16469,15022,17347,17346,32,391,8747,8723,10738,10939,10740,10941,10781,10943,10727,16416,13707,13628,16404,15276,15280,15807,13142,5833,7165,17268,17270,17273,16955,12060,16929,12061,16920,14951,15552,16618,15553,16617,15550,16615,15549,15498,15496,15497,15494,15495,15837,16589,16590,16591,16790,16789,16791,8290,8019,9269,9263,15886,9262,9268,9384,16661,17099,16660,17104,17447,9260,13893,11759,10248,15582,16667,16693,11310,17468,16431,15730,16705,16354,13691,17499,17497,17501,17502,17506,17508,17507,17503,17498,17496,17335,17338,17500,17495,17504,17333,17337,17334,17336,17371,17385,16895,10847,15231,13408,8657,16138,16132,16718,16742,16770,16853,16854,16394,13586,13361,16370,13316,14770,17363,17384,17383,17204,17193,17194,17638,17640,17639,17643,17254,17370,301,17379,16579,17117,17114,16583,17584,17593,17621,14445,15187,15586,17373,14145,17624,17620,13589,13590,13588,16609,16607,16602,16614,16605,16598,17583,17255,8606,9997,9995,14244,17231,14245,17230,14246,17234,15542,15528,16946,16922,13525,17647,16586,12063,17440,1436,15194,14527,14493,15788,15791,17413,17409,17410,11347,17156,13440,8172,16243,16247,16248,16244,5331,14914,12266,12269,1073,16321,8414,11699,9541,16399,7451,13146,7421,7416,7409,12718,17408,17422,15583,16432,5230,15768,14459,15252,16836,16834,17235,15585,15825,16864,16870,16865,16869,14192,14184,14177,16930,14175,16938,14189,16953,16937,16127,16128,16139,16102,16106,16134,15894,15860,15872,15848,17453,17441,17448,17424,15632,16840,17068,5841,16647,16652,17071,16797,16651,13798,16650,13774,13788,13777,12303,17512,17472,16648,16655,17510,17521,16891,15156,15256,3626,8085,14048,14439,14069,15707,15702,15655,15657,15652,15896,16992,16988,16987,17251,16990,16989,17019,16986,17035,14524,11928,10885,11993,16734,16733,16728,16752,17458,16749,16748,16488,15193,11881,17460,17459,17461,17457,16884,16860,16978,8422,8430,17236,16794,6291,13744,13741,14521,17284,11927,17306,17281,17316,17297,17324,17274,17295,17292) AND c.name='Soak' 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
  • Soak Flatter Smoothing Spray
    3oz
    Checking inventory...
    Soak Flatter Smoothing Spray
    $ 10.00
    Soak Flatter Smoothing Spray
  • MAIN ITEM
  • Soak Rinse Free Soap - 12oz Bottle
    12oz
    Checking inventory...
    Soak Rinse Free Soap - 12oz Bottle
    $ 16.00
    Soak Rinse Free Soap - 12oz Bottle
  • MAIN ITEM
  • Soak Rinse Free Soap Travel Size - 3oz
    3oz
    Checking inventory...
    Soak Rinse Free Soap Travel Size - 3oz
    $ 10.00
    Soak Rinse Free Soap Travel Size - 3oz
  • MAIN ITEM
  • Minisoak Assorted Travel Kit - 8 Pack
    8 x 5mL
    Checking inventory...
    Minisoak Assorted Travel Kit - 8 Pack
    $ 11.00
    Minisoak Assorted Travel Kit - 8 Pack
  • MAIN ITEM
  • Minisoak 5mL - Single Packet
    5mL Trial Packet
    Checking inventory...
    Minisoak 5mL - Single Packet
    $ 1.10
    Minisoak 5mL - Single Packet
  • MAIN ITEM
  • Minisoak Scentless Travel Kit - 8 Pack
    8 x 5mL
    Checking inventory...
    Minisoak Scentless Travel Kit - 8 Pack
    $ 11.00
    Minisoak Scentless Travel Kit - 8 Pack
  • MAIN ITEM
  • Handmaid Luxury Hand Cream - 3oz
    3oz
    Checking inventory...
    Handmaid Luxury Hand Cream - 3oz
    $ 10.00
    Handmaid Luxury Hand Cream - 3oz