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,13508,16727,16723,16722,16724,16741,16137,16114,16121,16769,16740,16763,16765,16746,13758,16757,16487,16475,16476,16780,16778,16868,16874,16866,16943,16952,16914,17189,17188,17190,17487,17720,16716,16715,16125,17090,17401,17400,17406,17403,17402,17404,17405,17102,17079,17096,17108,18007,18010,18021,14717,14275,15271,15144,8045,12380,12353,12358,12344,12366,8043,9717,8754,17269,17272,17271,10750,10776,10731,16843,10788,10764,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,11935,11931,15732,17926,16453,17910,17913,13918,17305,17303,17293,16619,17331,17475,17477,14150,17312,17302,14159,17455,17287,17310,17313,17993,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,17912,17914,17268,17270,17273,16955,12060,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,16693,15730,17497,17501,17506,17508,17503,17498,17496,17338,17500,17495,17333,18022,17194,17638,17640,17639,17643,17413,16399,17915,17911,16864,16865,14177,16930,14175,16938,14189,16953,16937,16127,16128,16102,16106,15894,15860,15872,15848,17453,17441,17448,17424,14524,16734,16733,16730,18020,18013,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 Cabana Towel$ 44.99Dock & Bay Extra Large Cabana Towel
