Paramour

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,10994,11312,11321,11005,10992,11319,11320,832,11505,13471,11694,12897,14008,768,12936,11323,10998,14042,11316,208,13434,12885,90,2934,6117,12841,13436,12889,12203,11588,12516,13116,13121,13861,13995,13998,13717,10991,11001,10996,11003,13464,10997,12896,12667,14308,14009,940,10145,10542,821,11370,9391,11383,12823,13883,12843,12692,13457,14292,1049,146,2930,424,1777,3754,12514,12513,14309,11317,13475,11315,11313,554,843,6454,5532,10003,622,12932,11407,13887,12856,12830,12694,14034,14032,13463,13452,14288,255,231,12892,13433,163,140,2925,2924,5386,2926,6118,12867,12863,12202,12522,12552,13118,13117,13852,13994,13701,13711,12792,118,286,12956,13886,12833,12521,12691,14029,13462,425,12884,13468,166,12834,12883,12528,12608,13120,13851,13996,6455,10004,10005,10020,11690,12895,11358,3749,13458,5528,8824,11693,12898,12512,12511,14322,14007,1001,12790,182,8068,567,941,12690,7127,13147,13530,13143,11659,1980,13583,12574,9530,6,5313,533,13012,12983,12996,13051,13042,12987,2133,13036,4472,9370,5317,262,9118,9123,5330,13726,5073,7109,9359,7915,2,9127,12801,5311,7776,7755,13845,11572,12551,7547,5407,13846,13842,11747,11763,10679,3586,11451,21,12662,11626,12665,13259,13100,7887,13265,541,8654,11582,8268,12671,9557,10635,13682,8267,10035,10042,176,39,293,592,1698,915,8,2759,2760,11359,494,11331,7504,10869,8438,13709,420,328,294,512,5307,13286,13722,8283,12788,13444,8204,12782,13445,5321,9846,1781,807,924,7775,193,973,7746,9640,1127,12791,1854,6234,8407,5302,12234,11477,7769,11653,349,13859,13862,13385,13413,13387,13519,13488,13491,13403,13389,13392,13395,13478,13406,13384,13504,13410,13424,13388,13508,13483,13496,13499,13391,13480,13510,13511,13405,13409,368,13968,13966,5320,5318,6190,6471,6470,6913,10009,8837,9431,9412,11649,787,295,12491,515,12571,7882,12205,9492,13177,12535,10167,12561,12557,12588,12595,43,3757,12903,14044,10166,12212,12200,14153,14154,14158,12197,14142,10126,10127,10123,12198,14107,10125,14104,13714,13693,14211,13674,13645,1157,12598,10874,7704,7702,14033,7663,12814,12812,7063,14304,12199,228,14083,14122,14116,14124,12243,11778,11787,11777,11783,14222,14223,1237,504,14027,13885,13763,13761,13758,13764,13759,13762,11059,11417,13369,11418,11422,11446,11455,9185,9171,9353,5210,292,14026,5126,11276,62,9988,11956,13900,1112,13004,13056,13046,13039,12997,13048,8655,13011,13377,12505,788,13520,13481,13495,13967,13965,13962,13972,14183,14178,14174,14195,127,12899,14317,350,13461,13447,14102,14103,11476,13930,14028,13933,6672,6505,2677,117,169,13367,13082,13088,194,12661,6414,6423,358,121,13931,13860,13853,14225,14219,14224,582,597,10111,10114,13756,7820,7822,13752,13755,13753,7823,9537,9542,987,12312,11708,13460,7824,7819,13178,10806,13847,13843,1059,13188,1669,7522,11740,487,528,7515,12947,12837,1033,901,879,857,14039,13307,13302,14018,14016,14020,14017,949,601,545,12418,12254,12253,6270,13430,13459,842,816,248,10856,10864,12531,12463,14114,13979,12055,12056,13802,6563,13820,14241,14243,14242,12906,12829,13075,13102,986,13101,14238,12725,13575,13806,13815,13811,13474,463,12309,13451,12334,13472,12188,14108,14105,188,4669,12340,4659,12306,4635,12368,12768,12341,12369,12376,13985,13981,3031,3033,13977,11279,7625,7583,7596,91,9647,11479,13732,11334,13187,11333,11338,11480,6338,11329,6328,8551,10282,11332,11342,13894,10813,13897,10809,13895,14206,13904,13902,10279,6980,13426,7046,13470,12777,12295,7576,12585,12914,13251,13279,11987,8672,12314,13437,9101,12213,11950,13077,13114,13253,13278,114,13250,12410,12072,8404,8402,11900,7238,10276,8553,14106,14100,14220,14303,13654,725,9283,5628,13640,12764,5627,13577,13881,13715,9274,13659,14239,13579,7500,12766,9757,13831,13837,13835,6348,8560,8545,13274,12074,12067,13108,14236,13111,13882,12494,14235,13574,13576,12734,13107,13870,14237,12499,9566,972,13105,14234,12731,13582,11161,11979,13880,12500,12544,12482,7803,12265,12264,7811,7889,13275,13580,13393,12663,399,860,12744,12741,902,4,3183,10139,48,13661,13631,2828,10138,10140,13062,13629,13705,10913,13638,10918,13696,10929,12594,12597,12913,12931,12963,12949,12953,13455,13431,13456,13435,13429,13469,11341,12959,12905,13849,11601,12793,12773,13834,13731,12929,13838,12909,12955,12902,13700,13840,12944,13830,13182,13189,11593,13255,13439,13272,12945,13720,12952,13091,13641,11715,11721,13268,13270,12857,12827,17,13072,13269,11091,11167,344,11595,11596,14128,14127,154,13104,519,13271,7219,13273,13109,158,13465,13086,12806,13446,12780,9499,13113,13112,912,4675,9488,9485,9450,13257,13716,13614,13718,12316,13686,13721,11025,13642,8686,13660,13626,7336,13888,13889,12659,10124,6519,14265,14258,6555,14264,11421,11424,11462,9427,9414,12670,10946,88,210,12824,12831,12840,12399,12281,13081,13103,13094,14140,14141,14139,14138,13603,13605,13599,13600,13604,13602,13601,12672,12684,12874,12873,12872,10523,10526,14096,14135,14129,14130,8045,11380,6870,12380,12353,12358,12344,12366,8043,11386,9708,9717,9726,9766,8754,10750,13484,10776,13479,10731,13514,13524,10788,13489,10764,12825,12864,12149,12520,12525,12524,12527,12668,12666,12647,11381,13306,13308,13305,3365,13366,13375,12226,12231,9875,13748,13256,4768,14047,14063,11943,14112,205,12417,908,789,692,3009,883,441,423,507,836,1810,1720,7720,212,13757,10884,10882,10890,13527,13526,13974,13975,13598,13593,13597,13594,13595,13596,13591,13592,13742,14143,13740,10849,11964,13743,13738,12248,13379,13376,12233,12554,12555,12566,12600,13374,12229,8181,5114,12219,9115,14151,12273,12274,14066,11099,11102,11095,12011,12015,11980,13918,13899,13908,13905,12362,14003,14013,12394,12752,12332,12396,12343,12336,14004,14014,12384,12304,12759,12367,13258,12748,12378,14011,14006,12382,12383,12311,14015,12750,12302,12363,14012,12749,12395,12393,12290,12370,12299,14002,12355,12291,14010,12757,12387,12390,12324,13737,13941,14299,13992,13935,13938,13934,13957,14298,14301,13956,12402,12406,12405,12403,12404,12407,1064,773,1673,9521,13239,12372,9514,10146,13246,12359,13236,12977,13232,12974,10394,13238,13229,12978,8635,8636,9212,13244,12674,13215,9194,10401,10406,10426,12866,12979,13222,12980,13210,12976,12981,13228,13208,13207,13206,13212,13242,13217,7700,13214,4355,10562,5343,13247,13241,4334,11151,13231,12126,11153,13219,12117,13234,13235,13216,13249,13245,12150,2193,4425,13211,11570,11568,13218,11208,11222,11569,13223,13237,13224,13243,13213,13227,13230,13220,2254,1667,1735,1432,12307,12293,3662,11904,11088,14113,8601,8608,10032,10838,1071,12810,13864,12813,13858,12811,13857,12815,13863,12846,12861,12845,12850,12844,32,813,391,5819,5803,8747,8723,8714,13828,13826,13827,12288,10738,10939,10740,10941,10781,10943,10727,13087,13084,13073,13078,13707,11753,13628,13098,11713,11704,13067,11726,13071,13090,13142,5833,12158,12095,12163,12139,12060,12061,12062,13314,13315,13313,13311,13671,13697,13634,14228,14231,14227,14230,14229,14226,13386,13407,13418,13390,8290,11146,8019,9463,9484,9453,13423,13421,13400,10724,13419,13399,9435,9269,9263,12678,12086,9262,13449,9268,9384,13076,13878,14294,12504,13065,13879,14293,9260,13893,11759,10248,14072,14073,14075,14071,13702,13698,13691,13625,13695,13636,13664,13675,14275,14273,14276,14198,6402,621,10847,8431,13978,13684,11181,13408,11823,13712,13402,13689,13329,13318,13316,11564,14162,301,578,8889,14097,12705,12082,10018,11352,12704,12539,10598,11835,10631,10623,10612,10691,10681,7088,1421,13589,13590,13588,8606,9997,9995,12804,12786,12778,13096,13089,14244,14245,14246,14253,10047,13525,12063,520,1436,13612,4685,11347,13467,13440,8172,5331,5316,12266,12269,12783,12954,12926,600,1073,8414,11699,9541,7451,11666,13146,7421,9221,7416,11665,7409,13144,12718,7577,11109,12326,12313,5230,10258,10257,10259,11883,13545,5841,9738,13766,13768,11018,13771,13798,2146,10756,13774,13788,13777,12303,13153,13779,13944,13948,3626,12431,8085,14051,14057,14050,14049,14054,14048,14069,11919,11942,10628,10615,10885,11993,3366,11831,13666,13651,13687,13667,13973,13943,13947,13653,13690,13552,13554,8422,13551,11636,13744,13741,11948,11639,4241,4253,12105,12102,11210,11233) AND c.name='Paramour' AND p.visible=1 AND vo.visible=1 GROUP BY vo.samefldALU ORDER BY p.addedDate desc limit 0,16