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,16433,11005,16434,11319,11320,832,15536,14152,16117,11694,12897,14008,14455,15629,15324,15399,768,15511,11323,14030,11316,208,15514,90,14961,2934,15861,6117,12841,12203,15358,15363,12516,15088,15365,15370,15859,14513,10991,10996,11003,10997,15356,16120,14320,14308,14009,14456,15624,940,10145,10542,821,15887,12692,13457,15347,15508,1049,2930,14542,15323,15500,16424,424,1777,3754,16130,12514,14309,15329,15398,16222,11317,11315,11313,554,843,14155,6454,10003,15214,622,12932,15532,15885,15857,12694,14035,14032,13463,13452,15091,15093,15360,15518,255,231,15521,163,140,14963,2925,2924,5386,2926,6118,15868,15862,14506,12867,12202,15383,15373,15089,15094,15390,15346,15380,15884,12792,118,286,15524,14146,12691,14031,13462,15388,15516,425,166,14969,14507,12834,15367,12528,15392,15371,15854,6455,10004,10005,15333,16107,10020,11690,12895,11358,3749,11693,12898,12512,14322,14007,14453,15203,15625,15326,15400,1001,12790,182,14751,14750,15976,15261,567,941,12690,7127,13147,13530,13143,11659,1980,13583,15614,9530,5336,533,13042,2133,13036,4472,5317,15959,15977,262,15080,13726,7938,15970,5073,7109,15972,15997,15971,9359,15967,15984,15563,15706,2,9127,5311,11572,5412,13846,10679,3586,14602,11626,16428,541,14345,14330,11582,8268,14583,10635,8267,10035,10042,14250,14248,14247,14252,176,14251,14515,14249,15659,15809,15720,592,15385,14608,915,204,11359,494,7504,10869,8438,14332,14286,15535,15073,15527,15515,15509,13709,328,5307,13679,8283,12788,8204,12782,15070,1781,807,924,193,890,9651,1127,15331,15341,1854,15330,1981,5302,6400,16353,7769,349,15505,13862,13413,13387,13519,13488,13491,13395,13486,13504,13508,13483,13496,13391,13511,13405,13409,368,14318,14307,9576,5318,14688,15946,10009,8837,15526,16081,15523,16080,15952,11649,787,295,12491,15948,515,15531,15520,7882,12207,16223,15737,12535,10167,14285,43,3757,15055,15035,15046,15949,15953,15958,15947,15969,15736,14654,10166,12212,16005,15964,14153,14154,14158,14142,10127,10123,10125,15955,15664,15654,14211,15651,15718,15978,1157,15401,10874,15430,7704,7702,14033,7663,7063,14987,14304,12199,228,14116,16216,12243,11778,11787,14223,889,498,36,1237,504,16105,16141,14180,14182,16131,16098,16100,16095,13758,14169,13762,11059,11417,15992,13368,15988,15999,11418,11422,11446,11455,8494,384,9169,9353,5210,292,14725,16008,15283,9988,15842,16007,15897,16009,16010,15963,16310,16304,16346,16350,16319,16316,16313,16344,15979,15981,13377,15445,15098,15110,15102,13520,13481,13971,14670,14174,127,12899,14317,350,15197,13461,13447,14733,14707,16423,15940,6505,14658,117,169,13367,194,15898,358,13853,14224,16215,582,597,10111,10114,13756,7820,7822,13752,13755,13753,14637,7821,7823,9537,987,15051,12312,7824,7819,10806,13847,1059,13188,1669,15075,11740,487,881,528,14589,14324,16233,7515,15058,15060,12947,15037,12837,15039,15064,901,857,15954,601,16094,16129,16123,16119,545,16133,16125,14985,12418,12254,12253,6270,15072,15062,14425,14669,842,816,248,10856,15374,14582,14371,16284,10864,15382,16258,15362,14599,15903,15902,15899,15943,15627,15630,15626,12055,16367,12056,15916,6523,13802,6549,14674,14678,14675,15908,15171,14333,14241,14243,14242,15050,12829,986,15566,3304,15166,15170,15169,15165,13819,13813,13474,12309,12334,12188,14101,15334,14105,15337,15264,188,4669,12340,4659,12306,4635,12368,15867,15864,14598,14568,14629,14619,7625,7596,9647,11334,13187,11333,11480,11329,10282,11328,11332,13909,13914,13894,15579,15576,13897,10809,15571,13904,13902,15573,3274,15574,15572,14291,10805,14325,6980,15044,15525,7046,15043,15513,7576,8672,12314,15841,13437,9101,15354,14592,14338,12213,8326,114,16025,15056,12410,15054,16040,1337,8402,14193,14194,7238,15361,15355,15348,15369,16028,16020,16023,16021,16024,16017,16033,16016,16014,15004,14996,14220,14303,14569,14367,13654,725,9283,14381,14349,5628,13640,16211,16250,5627,13577,15120,15372,13715,16212,14556,9274,13659,15565,7500,16251,9757,13837,16019,6348,15206,8560,8545,16041,15200,12074,12067,16043,15199,3301,15205,15568,14572,15121,15875,15394,15123,14611,13576,15376,15564,8059,12499,9566,14580,15366,972,15567,15375,12500,15122,12482,7803,12265,15393,14630,15569,12264,14617,7811,15849,16018,15213,16013,16015,16030,7889,13275,9585,15974,15968,13580,14857,16029,16022,16037,399,860,902,14942,14941,14937,16372,16386,16390,16376,16392,16384,15699,15673,1025,15041,15052,10139,15758,15759,48,14563,16234,16240,16242,16237,16239,16241,10447,13629,10913,10918,10929,15076,11341,15447,14604,15617,16231,15448,14579,15621,15449,16230,14956,15623,13731,14612,15622,16236,14628,12955,14463,12902,15743,14610,14585,15742,16232,16229,15618,16235,15074,13189,15619,13439,13272,11715,11721,15042,15049,16083,13268,15851,12857,12827,17,13269,11091,11167,191,15558,14362,14383,154,15879,15870,14160,14157,519,16092,16087,15858,158,16382,16391,14872,14871,14873,15712,14874,13465,13086,12805,13113,16224,15444,15436,912,14997,14994,15006,13718,13686,11025,8686,13626,7336,10124,6519,6555,16091,16419,16418,11421,11424,11462,15866,15871,15881,15379,15353,16466,16467,16468,14620,14935,16296,14939,16264,14944,16290,10946,11561,88,210,16202,13081,13103,13069,13099,13094,14140,14139,15068,15873,15865,15888,15853,14075,15878,14096,14717,14862,14865,14869,14868,14863,14275,15268,15271,15270,15272,15269,15267,15486,15753,15757,15756,14135,14130,15144,15145,15148,8045,12380,12353,12358,12366,9708,9717,9766,8754,10750,15225,14361,10776,15223,14365,13479,10731,15226,14374,14351,15224,10788,10764,14368,14573,14586,14623,14605,12668,12666,13306,3365,13366,12226,4768,15293,14434,15877,11935,11931,14112,205,12417,14672,789,692,3009,883,441,423,507,836,212,13757,10884,10882,10890,15732,15905,15915,16430,13527,13526,13598,13592,15250,15769,16225,16227,14663,15251,14143,15253,13740,15395,14204,15378,16204,14256,14457,10849,14458,11964,16213,15249,15254,11974,12248,16070,16071,16067,16140,16066,16118,15298,14693,5114,9132,15233,15020,15016,15014,15021,15017,12273,12274,16056,15691,15684,15704,16053,14765,13918,14762,14551,14550,14150,14553,13908,15554,14767,14545,14547,14766,14764,12362,15631,15512,15876,14013,12394,12752,12332,15533,16397,15850,12396,12343,12336,14014,12384,12304,12759,12367,15340,14011,15538,15893,12382,12311,15344,14015,12750,15895,15633,12302,15634,14012,12749,12395,12290,15332,12299,15507,15852,12355,12291,14010,12757,12387,15279,12324,16054,13941,13935,13938,14298,13956,15147,15142,12402,12406,12405,12403,12404,12407,14649,15646,1673,16451,16415,15506,14967,9514,10146,16413,15510,14971,8635,8636,9212,15765,12674,15766,15403,15402,12979,12980,16085,16086,15335,15338,13212,13242,13217,16271,16282,16272,15327,15343,15328,7700,16410,4355,10562,5343,4334,11151,14980,11153,15731,14919,14913,13234,13216,13249,13245,2193,4425,13211,11570,11568,13218,11208,11222,11569,15216,13223,13237,13224,15220,13243,13227,13230,15218,2254,1735,1432,15217,11871,14957,14959,14958,15228,15229,15685,15711,15658,3662,15767,16450,14113,16226,16205,10839,10838,1071,15534,15541,15522,15519,15350,15349,15368,12810,16088,12813,12811,12815,16084,14410,14413,14397,14429,14946,15763,15764,16471,16470,16469,15022,32,391,8747,8723,8714,13828,13826,10738,10939,10740,10941,10781,10943,10727,15540,16416,13707,13628,15530,16404,14859,14861,14864,15276,15280,15807,13142,5833,7165,12060,12061,12062,13314,13315,13671,14228,14231,14227,14230,14226,14953,14943,14951,14938,14631,15552,15553,15550,15549,15498,15496,15497,15494,15495,15555,15548,15547,15551,15837,15828,15840,15829,14578,14626,15322,14883,8290,8019,10724,9435,9269,9263,15886,9262,15517,9268,9384,14976,13878,14294,14981,13879,14293,9260,13893,11759,10248,15582,14577,14912,14917,16431,15730,14931,16354,16439,16435,16436,14597,13691,10847,15232,11181,13408,8657,13712,13402,16388,16394,13586,13361,16381,16374,13316,14770,11564,14162,7185,14910,14903,301,14702,14708,15922,15921,14437,16460,14998,14411,15178,15187,15586,10598,10611,10623,10612,10691,10681,14145,7088,14469,1835,15601,16421,13589,13590,13588,15833,8606,14924,9997,9995,14244,14245,14246,15690,15670,15542,15528,15914,13525,15938,12063,15713,1436,15194,14527,15689,14432,14493,15788,16192,15791,15773,13612,11347,13440,8172,16243,16246,16247,16248,16244,16373,5331,11499,14914,12266,12269,15584,600,1073,16317,16322,16339,16349,16342,16345,16303,16301,16343,15834,8414,11699,9541,16399,7451,13146,7421,7416,11668,7409,13144,12718,15583,16432,5230,15768,14459,15252,16228,15585,15825,15826,14179,14192,14184,14177,14175,14189,14187,16127,16128,16139,16116,16102,16106,16101,16134,15894,15860,15872,15848,15632,15423,15820,5841,13766,9080,15909,11018,15919,13771,13798,15816,15918,12887,15821,15910,2146,15917,13774,13788,13777,12303,14538,13153,15934,15930,15907,15935,15156,15248,15256,3626,8085,15726,14452,14058,14048,14439,14069,15707,15702,15655,15723,15657,15652,15896,14524,11928,10885,11993,14928,14916,14926,11831,13667,15193,13683,13951,15880,15451,8422,6291,13744,13741,14521,11927,15259,12105) AND c.name='Fantasy' AND p.visible=1 AND vo.visible=1 GROUP BY vo.samefldALU ORDER BY p.addedDate desc limit 0,16
(
S/M - 3X/4XChecking inventory...Fantasy Bahama Mama Chiffon Kimono & Panty$ 69.99Fantasy Bahama Mama Chiffon Kimono & Panty
1X/2X - 3X/4XChecking inventory...Fantasy Adeline Lace & Sheer Babydoll$ 24.99Reg. $ 64.99Fantasy Adeline Lace & Sheer Babydoll
Plus SizedChecking inventory...Fantasy Courtney Lace Robe & G-String Set$ 69.99Fantasy Courtney Lace Robe & G-String Set
