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(15500,17168,13494,13491,13508,16727,16723,16736,16722,16721,16737,16735,16732,16756,16724,16726,16741,16703,16137,16711,16700,16114,16121,16710,16769,16740,16763,16765,16706,16095,16746,13758,16757,16487,16475,16476,16477,16780,16778,16868,16874,16866,16943,16952,16914,17189,17188,17190,17487,17720,17719,17718,16716,16699,16702,16697,16094,16123,16719,16125,17090,15165,17401,17400,17406,17403,17402,17404,17405,17399,14629,17102,17079,17077,17096,17108,17375,14717,14275,15271,15144,8045,12380,12353,12358,12344,12366,9717,8754,17269,17272,17271,10750,10776,10731,16843,10788,10764,12668,16964,16949,16935,16967,16931,17209,17208,17210,17211,17207,17576,17555,17570,17571,17581,17387,11935,11931,15732,17394,16453,13918,17305,17285,17303,17277,17293,16619,17331,17475,17477,14150,17312,17302,14159,17455,17326,17287,17310,17313,16882,15731,14913,13216,13245,16773,16774,16771,16926,16956,16971,17572,17556,17575,17577,17569,17582,17752,17753,17754,17751,2193,4425,13211,15939,16643,11570,11568,13218,11208,11222,11569,15216,13223,13221,13224,15220,13243,13230,2254,1735,1432,15217,11871,14957,14959,14958,17268,17270,17273,16955,12060,16929,12061,16920,15552,16618,15553,16617,15550,16615,15549,15498,15496,15497,15494,15495,15837,16589,16590,16591,16790,16789,16791,16667,16693,15730,17499,17497,17501,17502,17506,17508,17507,17503,17498,17496,17335,17338,17500,17495,17504,17333,17334,17336,17371,17385,16895,13408,16138,16132,16718,16742,16770,17204,17193,17194,17638,17640,17639,17643,17370,17379,17373,17413,16399,15825,16864,16870,16865,16869,14177,16930,14175,16938,14189,16953,16937,16127,16128,16139,16102,16106,15894,15860,15872,15848,17453,17441,17448,17424,14524,11928,16734,16733,16728,16752,16749,16748,16884,16978,17284,11927,17281,17316,17297,17324,17274,17292) AND c.name='Dock & Bay' AND p.visible=1 AND vo.visible=1 GROUP BY vo.samefldALU ORDER BY p.addedDate desc limit 0,16
(
78 x 35" TowelChecking inventory...Dock & Bay Extra Large Active Towel$ 44.99Dock & Bay Extra Large Active Towel
78 x 35" TowelChecking inventory...Dock & Bay Extra Large Cabana Towel$ 44.99Dock & Bay Extra Large Cabana Towel
