select sks_product.id,sks_product.name1,sks_product.cid,sks_product.thumb_image_path,sks_product.price,sks_product.markdown,sks_product.finalsale,sks_product.brand_id, IF(`sks_product`.`markdown` < `sks_product`.`price` and `sks_product`.`markdown` > 0,`sks_product`.`markdown`,`sks_product`.`price`) as netprice,sks_category.id as sks_cat_id,sks_category.name as sks_cat_name,sks_category.displayorder as ska_cat_disp from `sks_product` LEFT JOIN `sks_category` ON sks_product.cid like CONCAT('%,',CONCAT(`sks_category`.`id`,',%')) where `sks_product`.`id` in(2120,18877,18880,19396,19563,20241,21174,21579,21988,24589,24590,27150,28412,28440,28487,29061,29449,29450,29542,29718,29722,37488,37490,37617,37812) order by `sks_category`.displayorder,`sks_product`.`ndate` desc, sks_product.id desc | Stanley Korshak
LOGIN       MY BAG (0)
Mother's Day Picks
Sort By :
1 - 32 of 33 Items
View :
1  2   | Next | Last   
Women's
Jewelry
Shak | Contemporary
Beauty
Gifts