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

Lejaby

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(11314,11322,11575,11312,11321,10699,11505,10704,11694,10515,11316,208,11728,90,2934,6117,12046,11750,12203,11588,11400,11135,940,821,12051,10464,11110,1049,146,2930,424,3754,11691,11138,12514,12513,11315,11313,843,11818,6454,5532,10008,10003,622,10475,12054,10508,10466,11407,11327,991,231,11702,163,140,2925,2924,5386,2926,6118,12052,11737,12202,11587,12048,11394,11117,96,425,11729,166,12050,11739,11591,6455,10004,10005,11125,10006,10020,11690,11358,6674,3749,5528,8824,11692,11397,11157,11693,12483,12484,1001,182,8068,9915,8991,567,941,7127,11659,1980,12294,5239,5313,2817,12220,533,11292,11287,7587,9794,9792,9784,10355,11070,11081,2133,4472,9370,5329,11677,262,5330,12461,9359,12480,2,9127,12119,7755,11572,12349,7547,5407,11747,11763,10679,10199,11451,21,11626,8268,8267,4203,6181,6179,176,39,6178,6177,11078,11077,592,1698,10460,9859,915,8,11288,2759,2760,11359,11331,7504,10869,5332,420,8204,5321,9846,10944,10196,10868,1781,807,924,9640,11703,1127,10860,10862,1854,8406,11223,11212,11477,7769,11198,11182,11653,5323,349,7786,5320,5318,584,1682,11685,7289,4288,11688,7371,6190,6471,6470,10334,7368,6913,10009,8837,9431,9412,11649,787,295,6130,11678,12205,9456,9492,9457,43,9830,12124,10166,5286,12212,12200,11464,11436,10915,10927,10908,10874,8896,7702,8948,7063,11043,12241,11778,11787,11777,11783,1237,504,11063,11059,11054,11417,11418,11422,11455,8494,9353,5207,292,3904,3908,5126,5691,9985,11956,8445,1112,12077,788,10715,10714,11226,11234,11203,11209,11368,11393,350,10368,11475,11472,11476,6672,6505,2677,8327,117,169,526,11119,3418,3412,3410,194,6423,121,582,597,10111,10114,7820,7822,7821,7823,9537,9542,987,11708,7824,7819,11679,11689,7514,10806,1059,11740,11687,487,2819,9874,5213,7515,9868,9881,12127,901,857,10752,949,601,545,11438,9819,8874,10949,10191,842,248,731,12055,12056,1050,141,6534,9149,6549,9124,6209,450,12172,986,7366,7367,9864,10942,8850,10195,463,5277,12188,188,4669,4659,8733,4635,8716,9838,12013,3033,10331,7625,7598,11494,11550,11549,11514,9647,11479,3176,11334,11333,11338,11480,6338,11329,6328,8555,11481,11478,10282,11328,11332,11337,10812,10809,3274,12427,5509,11585,7257,6980,9873,11744,10906,5261,7235,3972,10278,12008,8722,5137,11707,10457,9101,12167,12213,11911,5136,5138,5248,11921,11,4533,114,5476,11311,11116,12410,10307,10289,11916,12072,5462,7238,10276,8553,10292,12419,11584,725,9283,11697,5628,11720,11727,10399,10411,5627,10408,9274,11696,10416,7500,11724,9757,6348,8560,8545,11913,11915,12426,10312,12074,12067,12073,5485,9761,10811,9692,9566,12265,12264,7811,430,399,860,902,4,190,11114,10139,7039,11995,11410,11761,48,10741,11608,11030,11408,11988,11403,2828,10138,10140,11981,10918,10929,12238,12237,11036,11121,11610,11601,10480,10497,11040,6635,11518,11517,11605,11593,12210,11806,11807,10749,11746,17,11091,11032,11167,344,10746,11604,10637,11595,11596,154,7218,10639,158,10504,7013,7308,4675,11615,10678,11441,10946,10737,10897,10955,9707,9763,12083,11389,12031,9866,12226,12231,12228,11622,10044,4768,10389,10417,10396,10409,360,10884,10882,10890,11215,12262,10848,11641,10849,11964,12465,8627,11974,11799,11993,12232,12233,11264,9465,11268,11910,11376,11261,10857,11382,12229,8138,11454,11463,11427,12219,12273,10928,11099,11102,11095,11097,11098,11980,11963,10677,11617,11609,10414,7660,12402,12406,12405,12403,12404,12407,11092,10238,10423,1673,9521,11152,12372,9514,9517,11132,12359,8359,8365,8392,8376,8375,8635,8636,11709,9212,11732,9194,12006,11990,12287,12284,10401,11992,10406,11966,10426,10418,11136,11128,12100,12169,11065,281,310,300,7700,4355,5577,4320,5578,11735,11712,10562,5343,4334,11151,11706,12126,11153,11731,12117,8056,8051,11844,8763,8790,12078,12129,12150,12178,2193,4425,9758,11570,11568,11208,11222,11569,2254,1735,1432,11089,3662,11090,10792,8601,8608,10839,10838,5803,12036,12042,10901,12288,10939,10941,11975,12009,9863,12112,9877,12092,11147,11753,11134,12486,11442,11443,11713,11704,6201,201,5833,11214,9833,10397,10402,11096,12158,12095,12163,10722,10754,12049,8290,8019,9484,9453,10724,9435,9269,9263,12086,9262,9879,12282,9268,9384,11149,11983,12504,11145,12040,12496,9260,10938,11759,10720,10766,9832,11250,11269,6380,10772,10732,8729,6402,621,10630,10606,10624,10847,11801,11200,11564,8818,12044,12043,10676,10846,10845,10887,10883,10886,11802,12110,10940,10629,10896,10891,9238,12082,11348,12236,10016,10598,10623,7088,1906,1421,8606,7372,7373,6966,7771,7736,7767,8939,8890,9839,9845,9997,9995,11717,11730,10052,10046,12063,520,1436,11347,11804,5316,12266,12269,11115,11643,600,1073,11698,11701,10744,11699,9541,9221,7577,710,11392,11372,12019,12017,11838,11879,12351,10735,12335,11020,11018,2146,10756,9734,12204,12317,12328,11642,12271,12431,8085,12132,10885,3366,11842,11831,11840,20,12270,11634,4241,4253) AND c.name='Lejaby' 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
  • Lejaby Demoiselle Bikini Brief
    S - 2X
    Checking inventory...
    Lejaby Demoiselle Bikini Brief
    $ 79.99
    Lejaby Demoiselle Bikini Brief
  • MAIN ITEM
  • Lejaby 'Roxane' Tanga
    Checking inventory...
    Lejaby 'Roxane' Tanga
    $ 79.99
    Lejaby 'Roxane' Tanga
  • MAIN ITEM
  • Lejaby 'Roxane' High Brief
    Checking inventory...
    Lejaby 'Roxane' High Brief
    $ 84.99
    Lejaby 'Roxane' High Brief
  • MAIN ITEM
  • Lejaby 'Attrape Coeur' Sensual Bra
    DD - G Cup
    Checking inventory...
    Lejaby 'Attrape Coeur' Sensual Bra
    $ 164.99
    Lejaby 'Attrape Coeur' Sensual Bra
  • MAIN ITEM
  • Lejaby 'Attrape Coeur' Tanga
    S - 2X
    Checking inventory...
    Lejaby 'Attrape Coeur' Tanga
    $ 64.99
    Lejaby 'Attrape Coeur' Tanga