SELECT p.*, vo.Item_Price1 as 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.categoryId IN ( 2,471,929,475,621,472,473,477,486,484,488,485,478,480,481,476,474,835 ) AND p.visible=1 AND vo.visible=1 AND p.productId IN(16682,16685,16675,16687,16495,16996,16999,16997,16988,16987,16993,16989,16990,16711,16703,16713,16717,16781,16777,16776,16800,16824,16804,16811,16819,16805,16816,16807,16801,16799,16809,16826,16823,16817,16877,16876,16847,16908,16907,16868,16866,16874,16955,16920,16929,16957,16919,16673,16688,16959,16974,16896,16883,16901,16886,16978,16884,16902,16885,16903,16892,16882,16905,16893,16888,16704,16709,16702,16701,16699,16716,16875,16980,16508,16510,16511,16498,16505,16512,16865,16864,16869,16870,16503,16496,16691,16686,16678,16695,16698,16706,16708,16758,16585,16588,16853,16860,16855,16851,16861,16852,16846,16501,16497,16844,16637,16293,16266,16292,16619,16840,16608,16743,16751,16842,16770,16742,16792,16794,16795,16796,16594,16787,16780,16778,16790,16791,16789,16772,16773,16771,16774,16665,16705,16668,16689,16680,16677,16683,16414,16658,16659,16662,16663,16661,16660,16638,16640,16623,16632,16626,16642,16630,16639,16624,16627,16625,16621,16654,16655,16648,16647,16649,16645,16651,16671,16693,16684,16667,16454,16607,16602,16614,16605,16598,16609,16616,16618,16615,16617,16122,16132,16135,16138,16113,16586,16653,16589,16591,16590,16572,16587,16412,16417,16411,16499,16506,16500,16568,16516,16557,16549) GROUP BY vo.samefldALU ORDER BY p.addedDate desc limit 160,32
SXPP2U,SXBB29,SXBM35FA,SXBB27SP,SXBB70F,H14744-HW14263,H16866-HW16266,H16715-HW16254,H14897-HW14268,CHLOE19,ONYXDIAMOND,ONYXGLINT,ONYXLUXEDO,ONYXMOSAIC,ONYXVHARNESS,ONLYXCAGE,FS6482AQ,FS6474AQ,FS6480AQ,FS6479AQ,K1907,K1906,K1946,K1904,K1949,PRO2BB,SXBB30F,FS6540,FS6546,FS6543,BRA S PRALINOWY,BRASFNUDE
(
Checking inventory...SAXX Quest 2.0 Boxer Brief with Fly$ 33.95SAXX Quest 2.0 Boxer Brief with Fly
Checking inventory...Beach House Kerry Mesh Tankini$ 109.99Beach House Kerry Mesh Tankini
One Size Fits MostChecking inventory...Onyx Bodywear Diamond Cage Harness$ 89.99Onyx Bodywear Diamond Cage Harness
E - J CupsChecking inventory...Fantasie Paradise Bay Bikini Top$ 89.99Fantasie Paradise Bay Bikini Top
Checking inventory...BN3TH PRO 2.0 Active Boxer Briefs$ 44.99BN3TH PRO 2.0 Active Boxer Briefs
E - J CupsChecking inventory...Fantasie Fiji Underwired Bikini Top$ 89.99Fantasie Fiji Underwired Bikini Top
E - JJ CupsChecking inventory...Ewa Michalak Pralinowy Bra - S Style$ 99.99Ewa Michalak Pralinowy Bra - S Style
E - JJ CupsChecking inventory...Ewa Michalak Nibynic Bra - SF Style$ 99.99Ewa Michalak Nibynic Bra - SF Style
