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,13493,13491,13508,13483,13511,16727,16723,16736,16722,16721,16737,16735,16725,16756,16724,16726,16741,16703,16137,16142,16711,16700,16114,16121,16115,16710,16707,16706,16708,16758,16720,16768,16095,16695,16698,16747,13758,16487,16475,16476,16477,16780,16778,16868,16874,16866,16943,16952,16914,17189,17188,17190,16716,16699,16702,16697,16696,16709,16094,16123,16119,16719,16125,13802,17090,14241,15165,17401,17400,17406,17403,17402,17404,17405,17399,14629,17102,17079,17077,17096,17108,17375,14717,14275,15271,15486,15753,14135,14130,15144,8045,12380,12353,12358,12344,12366,9708,9717,9766,8754,17269,17272,17271,10750,15225,14361,10776,10731,14374,16843,10788,10764,12668,12666,16964,16949,16935,16967,16931,17209,17208,17210,17211,17207,11935,11931,15732,16453,13918,16619,14150,13908,14159,14547,16883,16882,15731,14913,13216,13245,16772,16773,16774,16771,16965,16926,16956,16971,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,13314,13671,14951,15552,16618,15553,16617,15550,16615,15549,15498,15496,15497,15494,15495,15837,15828,15840,15829,16589,16590,16591,16790,16789,16791,16667,16684,16670,15730,14931,13691,17335,17338,17332,17333,17334,17336,17371,17385,16895,13408,13712,16138,16132,16122,16718,16742,16770,16113,17204,17193,17194,16903,17379,17357,17413,16399,15825,15826,16864,16870,16865,16869,14192,14184,14177,16930,14175,16938,14189,16953,14187,16937,16127,16128,16139,16102,16106,16134,15894,15860,15872,15848,14524,11928,14928,14926,16734,16728,16752,16749,16750,11881,16884,16900,17284,11927,17280,17281,17316,17297,17324,17274,17295,17292,12105) 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
