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,11319,11320,13471,11694,12897,14008,14455,11323,11316,13464,14320,12667,14308,14009,14456,10145,10542,3754,12514,12513,14309,11317,11315,11313,554,843,14155,6454,5532,10003,622,12932,13887,12856,12694,14034,14032,13463,13452,14288,14461,255,231,12892,163,14508,140,14512,2925,2924,5386,2926,6118,14506,12867,12202,12522,13118,13117,13852,13994,13701,13711,12792,118,286,14146,12956,13886,12833,12691,14029,13462,14462,425,12884,166,14511,14507,12834,12883,12528,12608,13120,13851,13996,7127,11659,5313,5317,9123,13726,2,5311,7755,13845,11572,12551,13846,13842,12665,7887,13265,14330,11582,8268,8267,10042,176,39,293,1698,2760,11359,10869,13709,5332,294,512,5307,13722,8204,12782,13445,7775,7746,9640,6234,11653,13966,6470,6913,10009,8837,9412,11649,12205,13179,14154,13873,14158,13871,14104,13714,13693,13674,13645,12812,14083,14122,14116,14124,14222,14223,504,14027,11417,13368,11418,11422,11446,11455,11276,62,13900,13048,8655,13011,13377,12505,13461,14102,11476,117,169,13088,227,6414,6423,358,13860,14225,14219,9537,9542,10806,13847,13843,7522,11740,7515,12947,12837,13430,13459,14669,842,248,10864,14352,12463,14114,12906,12829,13102,13101,13474,12334,13472,14105,4659,12306,4635,12368,13981,3031,3033,13732,6328,10282,10813,6980,13426,9101,12213,13253,13278,13250,13869,14194,14290,14100,14220,5627,13715,9274,13659,13108,14236,13882,12494,14235,13580,12663,14336,14329,13661,2828,10138,10140,13705,10918,13696,10929,12949,12953,13429,12955,13840,12944,13830,13272,12952,13641,11715,12857,13091,11091,11167,11595,11596,14127,14362,14426,13104,14160,14144,13271,13273,13109,912,4675,9485,9450,13716,13614,8686,13660,13626,7336,13889,14258,6555,14264,11424,11462,9414,14567,14558,12831,12840,14562,14139,14138,13599,13600,13604,12873,12872,13256,10882,10890,13527,13974,13597,13591,13592,14257,13738,14660,14665,11974,13379,13376,12233,13374,12229,12273,12274,12362,14003,14013,12394,12752,12332,12396,12343,12336,14004,14014,12384,12304,12759,12367,13258,12311,12402,12406,12405,12403,12404,12407,773,10146,13246,12359,13238,13229,12978,8636,12674,13215,9194,10406,10426,12980,13210,12981,13208,13206,13260,13242,13217,13241,11153,13219,13209,12117,12307,14113,12811,13857,12815,13863,14397,12845,14429,12850,5803,8723,8714,13826,10740,10941,10781,10943,13073,13078,13628,11704,13067,11726,13071,13142,5833,8019,9484,9453,13065,13879,14293,10847,578,10598,11835,10631,10623,10612,14168,13590,13588,9995,12778,13089,14245,10047,13525,520,14433,14432,5316,12269,11699,7451,11666,13146,7421,7416,11665,7409,13144,12326,12313,14459,12431,8085,10628,10885,11993,3366,13744,4241) AND c.name='Louisa Bracq' AND p.visible=1 AND vo.visible=1 GROUP BY vo.samefldALU ORDER BY p.addedDate desc limit 0,16
(
