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(11358,832,768,10515,208,11728,90,2934,6117,12046,11750,8828,12203,11588,940,821,12051,10464,11406,11110,146,2930,424,1777,6455,10004,10005,11125,10006,10020,11690,11358,3749,5528,8824,11692,11397,11157,11693,182,8068,567,9530,5239,4472,9370,262,9118,5073,7109,9359,7915,9127,12119,7776,7547,11747,11763,10679,7505,10199,3586,11451,21,102,11626,8654,8934,9557,10635,10035,10040,10109,12032,8908,11078,9859,2759,10850,10039,494,7504,650,4312,420,8283,414,9846,10944,10196,3747,11716,11719,10862,10881,8407,10164,7769,11198,11182,349,11026,5320,5318,8252,7289,7369,7370,6190,6471,9431,12170,9492,9460,9822,10167,43,3757,3875,9479,9830,10166,12212,10126,11401,10127,11464,1157,8942,8971,7063,11043,228,9353,292,5126,5034,9988,12134,788,10715,12186,11231,11203,127,350,11119,194,9029,582,597,987,11708,7415,1036,1222,1059,487,2819,528,901,857,949,601,545,11438,816,10856,11448,339,12055,12056,750,522,6209,986,7365,463,188,4669,8737,11520,11978,10809,7046,11743,5261,7576,8672,11707,11950,4577,11116,12410,725,9283,11697,5628,11720,11727,10399,10411,11546,7500,9757,5485,9566,972,12001,11037,11161,11979,7803,7811,7889,11325,11413,10139,7039,11995,11415,11761,11399,10741,11030,11411,10913,12238,11034,10511,11035,10180,12211,11807,11758,10225,9986,9418,9994,17,519,8288,8710,10178,11615,10678,11602,8690,11025,12286,11722,12114,12137,230,12018,11425,11051,3178,10124,6519,6555,11124,11124,11421,9427,290,309,10946,88,210,12400,12281,10737,10175,11126,10904,8045,12128,11380,6854,6870,10905,9708,9717,8754,9486,9481,9446,10750,10776,10731,9747,9709,12149,12168,11381,11378,11216,11873,12037,11969,9866,3365,12226,12231,12228,12227,9875,4768,10396,10409,360,205,908,789,692,3009,883,441,1810,1720,7720,212,10884,10848,11641,10849,11964,197,5114,11454,12219,10936,10920,11102,11095,12011,12015,11101,11103,11105,11968,1064,1673,9521,11152,9514,8365,8392,8635,11709,9212,12006,12287,10401,11992,11056,11136,11065,281,310,7700,4355,5577,11735,10562,5343,4334,11151,11706,8056,8763,12150,2193,4425,9758,11208,11222,6466,3662,10792,10421,1071,32,813,391,5819,8747,8723,12036,10901,11144,11139,12288,10738,10939,11998,11975,9863,12112,11147,11753,11442,11713,6201,201,9535,11229,11984,9833,10404,10407,11096,12047,8290,11146,9463,9435,9269,9263,12086,9261,9879,12282,9268,9384,11149,11983,9260,10938,11759,10624,11801,11200,11227,12044,301,10887,10896,10891,8884,10691,10681,7088,7374,6969,7737,7745,7757,8910,8964,9841,9997,11717,12063,9745,4685,11347,11009,8172,11429,11804,11113,10909,600,1073,11698,10744,9541,8849,11109,10763,11173,710,11379,11644,12020,11960,12000,11838,11883,12132,12147,11634,11633) AND c.name='Coco Reef' AND p.visible=1 AND vo.visible=1 GROUP BY vo.samefldALU ORDER BY p.addedDate desc limit 0,16
(
E - F CupsChecking inventory...Coco Reef Silent Bloom Bandeau Tankini$ 119.99Coco Reef Silent Bloom Bandeau Tankini