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,10995,10993,11312,11321,11005,10992,11004,11319,11320,832,11817,11485,10699,11505,10704,11694,768,11323,10998,10515,11316,208,11736,90,2934,6117,12046,11750,12203,11588,12516,10991,11001,10996,11003,10997,11695,11400,11135,940,10145,9403,821,9396,11370,12537,12532,12530,11383,12533,9402,9400,12051,10464,11406,11110,12523,1049,146,8177,2930,424,1777,3754,11691,11138,12514,12513,11317,11315,11313,554,843,11818,6454,5532,10008,10003,622,12054,10508,11407,12529,11327,991,255,231,11702,163,140,2925,2924,5386,2926,6118,12052,11737,12202,11587,12522,118,286,12048,11394,11117,12521,96,425,11729,166,12050,11739,11591,12528,6455,10004,10005,11125,10006,10020,11690,11358,6674,3749,5528,8824,11692,11397,11157,11693,12512,12511,12483,12484,1001,182,8068,9915,10810,567,941,8988,12690,7127,5,11659,1980,10350,12294,9530,6,5240,5313,2817,12221,533,11292,11287,7587,9794,9784,10355,11083,11081,2133,4472,9370,5329,11677,262,9118,9123,5330,12461,5073,7109,9359,12480,7915,2,9127,12119,7776,7755,11572,12349,7547,5407,11747,9054,11763,10679,7505,10199,3586,11451,21,102,11626,7887,541,8654,11582,8268,9557,10635,8267,10035,10042,10456,12032,4203,4199,6181,6179,8908,176,39,6177,11077,293,592,1698,8940,8919,10460,9859,915,8,11288,2759,2760,11359,11449,11457,494,11331,7504,10869,8437,4312,5332,420,328,294,512,8283,8204,414,5321,9846,10944,10196,1781,807,924,7775,890,7746,9640,11703,3747,11719,1127,10860,10861,10862,10881,1854,6234,8406,8407,11223,11212,12234,10164,10161,11477,7769,11198,11182,11185,11199,11653,349,368,5320,5318,8252,584,1682,11169,7289,4255,7369,7371,7370,6190,6471,6470,10334,7368,6913,10009,8837,9431,9412,11649,787,295,6130,12491,515,12170,7882,12205,9456,9492,9460,9457,9822,12535,10167,11042,9070,9857,12171,12090,12096,12138,12154,43,198,3757,3875,7744,9830,12124,10166,5286,12212,12200,12197,10126,10127,10123,12198,10125,10915,10927,10908,12093,1157,10874,8942,8971,8896,7704,7702,7663,7063,11043,12199,228,12241,11778,11787,11777,11783,1237,504,11063,11059,11417,11418,11422,11446,11455,9353,5207,292,12116,3904,3908,5126,11276,5116,62,5691,9988,12134,9985,12113,12014,11956,8445,9828,1112,8655,12077,12505,12493,788,10715,10714,12186,12161,12106,11231,11226,11234,11203,11224,11209,127,350,11475,11472,11476,11829,6672,6505,2677,8327,117,169,526,11119,3418,3412,3410,194,227,6414,6423,9029,9017,358,10490,121,582,597,10111,10114,7820,7822,7821,7823,9537,9542,987,12312,11708,7824,9049,7819,7415,1036,11681,7514,10806,1059,1669,7522,11740,11687,487,12027,2819,528,9874,5213,7515,9868,9881,12127,1033,901,879,857,11733,11711,10718,949,601,545,12418,11438,12254,12253,6270,9819,8874,10949,10191,842,816,248,10856,12462,12534,10864,12531,12463,11450,339,12279,12055,12056,750,1050,522,6534,9149,6563,9124,6209,450,12172,9703,986,7365,7366,7367,9864,10942,8850,10195,463,12309,12334,12188,188,4669,8737,4659,8733,4635,8716,12341,11978,12369,12376,12013,3031,3033,11279,10331,7625,7598,7596,91,9647,11473,3176,11334,10333,10485,11333,11338,11480,6338,11329,6328,8555,11481,11478,10282,11328,11332,11337,10812,10809,3274,12427,10279,11585,7257,6980,12319,10906,7046,12295,11743,5261,7246,12622,3972,7576,12585,10290,12008,11987,8722,5137,8672,11707,12314,10457,9101,12167,12213,11911,5136,5138,5248,11950,11921,11,4577,4533,114,10445,10580,5476,11311,11116,12410,10453,11841,10307,10289,11916,12072,8404,8405,12333,12305,5462,11847,7238,10276,8553,10292,12419,11584,725,9283,11697,5628,11720,11727,10399,10411,11546,11560,5627,10408,9274,11696,10416,7500,11724,11723,9757,6348,8560,8545,11913,12426,10312,12074,12067,5485,11465,10811,12501,12494,12543,10435,11420,9692,12506,12499,9566,972,11458,12001,11161,11979,12502,12500,12544,12482,7803,12265,12264,7811,7889,10987,9568,430,399,860,902,4,10436,10591,11114,11413,11751,3183,12029,10139,7039,11995,11410,11761,11399,48,10741,11608,11028,11877,11366,11836,11988,11403,12004,2828,10138,10140,11981,10913,10918,10929,9129,12238,11034,11036,11121,10437,11341,11610,11601,10511,10480,10497,11035,11040,6635,11518,11517,10451,11593,9984,9987,12211,12210,11806,11807,11715,11721,10749,9986,9418,9994,17,11091,11167,344,10746,11604,10637,11595,11596,154,10578,519,7219,10573,10639,158,12223,10567,9499,8352,8325,10504,7308,6551,912,4675,9488,9485,9450,8288,8289,8710,8735,8958,8907,10178,10173,10202,9854,9884,9851,11615,10678,11602,12331,12316,11025,12315,8686,12325,7336,12286,11722,12283,11718,12114,12137,12166,12075,12080,230,12660,12018,12664,12016,12659,12002,11425,11461,11441,12280,10124,6519,6555,11421,11424,11462,9427,9414,290,12670,12679,12677,309,10946,12657,88,210,12400,12281,12289,10175,11126,12688,12684,12682,12645,10523,10526,8045,12128,11380,6854,6870,6853,6890,12380,12353,12358,12344,12366,8043,12157,11386,9708,9717,9726,9766,8754,12185,11391,9486,9481,9446,10750,10776,10731,12488,10961,10788,12487,10955,9747,9709,9707,9763,12149,12168,12099,12083,12520,12525,12524,12527,11381,11378,11389,11388,11216,11237,11873,12037,12031,12033,11969,12023,12010,3365,12226,12231,12228,12227,9875,11622,10044,4768,10389,10417,10396,10409,11918,11931,360,205,12417,908,789,692,3009,883,441,1810,1720,7720,212,10884,10882,10890,10614,10607,10603,8439,11215,11303,12262,10848,11641,10849,11964,12465,11799,11993,12248,12232,12233,11264,11268,11910,11261,10855,12229,12230,8181,8180,8138,5114,11454,11463,11427,12219,9115,11221,12273,12272,10936,10920,10928,11099,11102,11095,12011,12015,12022,11101,11103,11097,11105,11098,11968,11980,11963,10677,11617,11609,10414,7678,12402,12406,12405,12403,12407,11092,1064,773,1673,9521,11152,12372,9514,9517,11132,12359,12655,8359,8365,8392,8376,8375,8635,8636,9212,11709,12674,11732,9194,12006,11990,12518,12517,12515,12287,12284,10401,11992,10406,11966,10426,10418,11128,12100,12169,281,310,300,7700,4355,5577,4320,5578,11735,10562,5343,4334,11151,11706,12126,11153,12117,8056,8051,12342,12350,8763,8790,12078,12129,12150,12178,2193,4425,9758,9716,11570,11568,11208,11222,11569,2254,1735,1432,11089,3662,11816,11090,11814,11904,11088,8601,8608,10032,10839,10838,1071,12673,12644,12510,12509,32,813,391,5819,5803,8747,8723,8714,12036,12042,12035,10901,10903,12675,12650,12653,12651,12683,11155,12288,12285,10738,10939,10740,10941,10781,10943,10727,11998,11975,12009,11985,9863,12112,9877,12092,9876,12148,11147,12489,11753,11134,12486,11442,11443,11430,11713,11704,11726,11705,6201,201,5833,9535,9540,11229,11214,11984,11970,10404,10407,10397,10402,11096,12158,12095,12163,12139,10754,12047,12049,8290,11146,8019,11148,9463,9484,9453,10724,9435,9269,9263,12678,12086,9262,12282,9268,9384,11149,11983,12504,11145,12040,12496,9260,10938,11759,10248,10720,10775,9832,11259,11269,6380,10732,8729,6402,621,12133,10630,12135,10606,10624,10847,8421,11801,11184,11181,10698,11823,11859,11902,11170,8657,11200,12425,12429,12428,11564,11227,12044,12045,12043,301,578,10676,10846,10845,10887,10883,10886,11802,10730,12110,10940,10629,10896,6531,8113,8125,8117,10894,8886,11700,9238,12082,10018,11352,11583,12236,9567,10016,11930,10598,11835,10631,10623,10612,10691,10681,7088,1906,1421,8606,7374,7372,7373,6969,6966,7737,7771,7736,7745,7757,7767,8910,8939,8964,8890,9841,9839,9845,9997,9995,11717,11730,10047,10052,10046,12063,10033,520,1436,11771,11776,11766,9745,4685,11347,11009,8172,11429,11804,5331,5316,12266,12269,11113,10909,10933,600,1073,8414,11698,11701,10744,11699,9541,7451,11666,7421,9221,7416,11665,7409,7577,12224,11109,11107,11111,11106,10763,11180,11168,11173,12326,12313,710,5230,11800,10258,11379,11644,11392,11372,12020,11960,12000,12019,12017,10257,10259,11838,11883,11879,7932,12351,5841,10735,12335,9080,11020,11018,8681,2146,10756,12303,12204,12317,12328,11642,12271,3626,12431,8085,12132,11919,11920,10628,10615,10885,3366,11842,11894,12141,12147,11831,8422,20,12270,11634,11948,11937,11639,11926,11927,12411,11936,4241,4253,12464,12182,12105,12102,12180,11204,11217,11210,11233,11849) AND c.name='Fantasy' AND p.visible=1 AND vo.visible=1 GROUP BY vo.samefldALU ORDER BY p.addedDate desc limit 0,16
(
One Size Fits MostChecking inventory...Fantasy Antoinette Pearls & Lace SideTie Panty Set$ 45.99Fantasy Antoinette Pearls & Lace SideTie Panty Set
Checking inventory...Fantasy 'Courtney' Lace Robe & G-String Set$ 69.99Fantasy 'Courtney' Lace Robe & G-String Set
