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(12362,11314,11322,11575,11312,11321,16433,16434,11319,11320,832,15536,16694,11694,14008,14455,15729,15324,15399,16407,16968,768,11323,16291,18098,11316,208,17539,90,17138,17542,6117,17970,12203,16927,16690,16293,17085,17216,17944,17997,17680,11002,16688,15356,14308,14009,17681,14456,16409,16963,17684,940,10145,10542,821,17839,15887,15508,16260,17093,16928,17134,17959,18095,17697,1049,14542,15323,15500,424,12514,14309,15329,15398,17200,17954,11317,11315,11313,554,843,17565,17003,15214,17895,17992,622,17893,15885,15857,12694,16262,16276,15518,16287,16274,17076,16950,16951,17141,17961,18099,17682,255,231,17544,163,140,17144,17546,17143,17538,6118,17986,17146,17139,12202,16966,16686,16266,17088,17097,17217,17946,17952,17998,17996,12792,118,286,15524,12691,15516,17971,18096,425,166,17988,16924,16678,16292,10004,17552,10005,15333,17039,11690,16406,17894,17990,17750,11358,11693,12512,14322,14007,17694,14453,15203,15727,15326,15400,16408,16932,17197,17689,1001,12790,14751,14750,15261,567,941,12690,7127,13147,13530,13143,11659,13583,15614,533,16554,16550,17158,17168,2133,16633,4472,5317,15991,16627,16626,15977,16622,262,15080,16074,7938,7109,16001,15563,15706,2,16631,16632,16637,16630,16639,16620,9127,5311,5412,13846,17699,17690,17679,10679,3586,17267,17266,11626,17372,11582,8268,17960,17955,17966,17951,14250,14248,14247,14252,14251,14515,14249,97,15809,16526,592,915,204,11359,494,17645,17950,7504,17973,8438,14286,16549,17087,17092,17106,5332,17674,5307,8283,8286,5321,17805,1781,807,924,193,890,9651,1127,1854,16889,5302,6400,16353,7769,349,17733,17059,13862,13508,16727,16723,16722,16724,16741,16137,16114,16121,18085,18087,18088,18086,18084,14688,16852,17673,17353,17350,10009,14722,16081,15523,16080,16799,15952,11649,787,295,12491,15948,15531,17967,15520,17949,7882,12206,10167,14285,43,3757,15046,15736,15975,14654,10166,12212,14153,14154,14158,14142,10127,16520,15664,16286,17818,14211,16295,16281,1157,15401,10874,15430,15426,7704,7702,14033,16677,16683,7663,17153,17154,17038,17013,17024,7063,12199,228,17125,18080,17122,11786,11778,17212,17239,36,504,16769,16740,16763,16765,16746,13758,16757,16487,11059,11445,11417,15992,13368,11418,11431,17749,11446,11455,5210,292,14725,9988,16499,16506,13903,13377,17649,17667,16475,16476,16780,16778,16868,16874,16866,16943,16952,16914,17189,17188,17190,127,12899,14317,350,15197,17177,17185,14707,17969,17975,6505,17487,17720,117,169,13367,194,16524,13933,17182,358,14735,582,10111,10114,13756,7820,7822,13752,13755,17157,13753,14637,7821,7823,16784,9537,987,17018,16414,17692,7824,7819,17604,17618,10806,13847,13188,17170,487,528,14589,14324,7515,15039,15064,901,857,601,17838,16716,16715,545,16125,14985,12418,12254,12253,6270,14425,14669,842,816,248,6291,10856,17580,17009,10864,17579,17051,17666,17658,17651,17596,17598,12055,17142,16367,12056,16878,6523,6549,16879,17090,16877,14333,17053,986,17657,17668,16277,17566,16941,3304,17659,17401,17400,17406,17403,17402,17404,17405,17063,12188,16501,14101,16507,14105,16509,16497,17976,15264,17977,188,16983,17089,17080,17664,7625,7596,11334,13185,11333,11480,11329,17102,17079,8551,10282,11328,13909,13914,13894,13897,10809,15571,13904,13902,16801,16815,16805,16825,16808,16811,16813,10805,6980,17229,7046,16513,17225,17541,17036,16984,17543,17002,16561,8672,9101,15354,14592,14338,12213,114,17180,17965,12410,17972,14193,14194,17300,17283,7238,17957,17032,17962,17008,17958,17000,17953,17031,16020,16033,16014,17318,17301,17288,17279,16981,17041,17045,17133,17135,17145,17150,17140,14303,16523,16925,7500,17275,17323,13837,16019,6348,8560,8545,3301,17554,16940,17563,18045,8059,12499,17564,9566,17226,15366,972,16267,17742,16945,12500,12482,7803,12265,17562,16961,12264,16015,17282,17096,17108,7889,17650,17656,17722,17723,16960,399,860,49,17426,902,17107,16936,17081,14563,17471,10913,10918,10929,15076,11341,15447,17078,17433,16231,15448,14579,15449,17094,16230,16944,17095,13731,16915,17454,12955,16512,17683,14463,12902,16505,17691,16493,17082,16494,17103,15074,13189,17173,13439,11715,11721,18042,17004,18041,17040,12857,12827,17,191,15558,14362,14383,154,16681,16674,519,17685,17695,17688,17702,17037,17025,17947,17956,17340,17553,17550,17557,16382,16391,14872,14874,16224,17652,17660,912,16779,16775,18007,18010,18021,17813,11025,16658,17814,8686,17812,7336,10124,6519,6555,11421,11424,11462,15871,16466,16467,16468,17348,16296,16264,16290,10946,11561,210,13103,13069,13099,14140,14139,15865,17908,17903,17907,15878,16500,17803,17800,14099,14717,14275,15271,15144,8045,12380,12353,12358,12344,12366,8043,9717,8754,17269,17272,17271,10750,10776,10731,16843,10788,10764,16964,16935,16967,16931,17209,17208,17210,17211,17207,17576,17555,17570,17571,17581,17783,17788,17785,17784,17786,17787,17833,17831,17830,17832,18073,18068,18069,18072,18071,18067,18012,17456,11935,11931,789,3009,883,441,423,507,836,17164,17162,212,13757,10884,10882,10890,16847,15732,17897,16430,16787,13527,13526,13592,15769,16838,17237,16835,16833,14663,15251,16828,16572,16837,17637,15253,13740,15395,17480,14457,16587,10849,11964,16213,15254,15255,16070,16472,16483,16071,16473,18008,17007,17020,14693,17926,17635,16453,17989,16162,17910,9133,17256,15233,17913,12273,17250,17044,17028,17257,13918,17305,17303,17293,16619,17331,17475,17477,14150,17312,17302,14159,17455,17287,17310,17313,12362,12394,12752,12332,12396,12361,12343,12336,14014,12384,12304,12759,12374,12367,12382,12311,12321,14015,15895,12302,14012,12749,12395,12338,12290,12299,15507,12355,12291,14010,12757,12387,12324,13941,13935,13938,13956,15147,15142,12402,12406,12405,12403,12404,12407,17716,16484,16491,17993,1673,16451,9514,10146,8635,8636,9212,18100,16689,16672,12674,18101,16680,17196,12979,12980,16085,15335,17835,17218,15338,17836,17232,13212,13242,13217,16271,16272,15327,17567,15343,16957,16918,15328,16919,17578,16917,17574,17201,17203,17083,16912,16962,17693,17687,7700,4355,10562,5343,4334,11151,17463,17834,11153,17464,17995,15731,14913,16773,16774,16771,16956,16971,17572,17556,17575,17577,17569,17582,17752,17753,17754,17751,17778,17776,17774,17779,2193,4425,13211,15939,16643,11570,11568,11208,11222,11569,15216,13221,13224,15220,13243,2254,1735,1432,15217,11871,14959,14958,15228,17761,15229,17411,17425,17429,15767,17238,17636,16829,16830,16205,10839,1071,17474,17473,17199,17198,17349,12810,12813,12811,12815,17192,17696,17195,17678,17191,17686,16908,18076,18077,18079,16907,18078,15022,17801,17802,17347,17701,17675,17676,17905,17909,17904,17906,18093,18091,18092,18094,32,391,8747,10738,10939,10740,10941,10781,10943,10727,13707,13628,15276,15280,15807,17912,17914,13142,5833,7165,17268,17270,17273,16955,12060,16929,12061,12062,16920,15552,16618,15553,16617,16615,15498,15496,15497,15494,15495,16589,16590,16591,17797,17796,17795,16790,16789,17829,17824,17827,17826,17828,17825,17775,17777,17780,17823,17820,17821,17822,17979,17978,18025,17980,18056,17981,18018,8290,8019,9269,9263,15886,9262,17968,9268,9384,16661,17700,17099,16660,17677,17104,17447,9260,13893,11759,17765,10248,15582,16693,17558,11310,17468,16431,15730,16354,17497,17501,17506,17508,17503,17498,17496,17338,17500,17495,17333,17337,10847,15231,8657,16854,16394,16370,13316,14770,17363,18022,17762,17194,17638,17640,17639,17643,17254,301,16579,17117,17525,17114,16583,17731,18002,18011,17535,17621,17899,15586,14145,17624,17620,13589,13590,13588,16609,16607,16602,16614,16605,16598,17583,17255,14244,17231,14245,17230,14246,17234,15542,15528,13525,17647,16586,12063,17440,15194,14527,15790,15791,17413,17409,17410,11347,17156,13440,8172,17900,16243,17902,16247,16248,16244,5331,14914,17746,12266,12269,15584,17793,1073,8414,11699,9541,16399,7451,13146,7421,7416,7409,12718,17408,17422,15583,16432,5230,15768,14459,15252,16836,17235,17915,17911,15585,16864,16865,14177,16930,14175,16938,14189,16953,16937,16127,16128,16102,16106,15894,15860,15872,15848,17453,17441,17448,17424,17901,17844,17068,9738,16644,16653,17520,16797,16651,13798,8813,13774,17864,13788,13777,12303,17512,17868,17849,17867,17845,16648,17514,17611,17510,17521,17807,17808,17732,15256,3626,8085,15882,16992,16988,16987,16990,14524,10885,11993,16734,16733,16730,17458,16488,15193,17459,17461,17457,18020,16860,18013,18049,8422,17236,13744,13741,14521,14522,17292) 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 Mai Tai Robe & Panty Set$ 69.99Fantasy Mai Tai Robe & Panty Set
S/M - 3X/4XChecking inventory...Fantasy Bahama Mama Chiffon Kimono & Panty$ 69.99Fantasy Bahama Mama Chiffon Kimono & Panty