select top 16 id,productname,photo from product where id not in (select top 0 id from product where id is not null and ComId=42978 and seriesID=1640 and validated='2' order by displayorder_series asc,displayorder asc,submitdate desc ) and id is not null and ComId=42978 and seriesID=1640 and validated='2' order by displayorder_series asc,displayorder asc,submitdate desc
Juxian Hengsheng Foodstuffs Co., Ltd.
Contact Person (Trading Department): Ms. Sophia Lu| Email this pageBookmark this page |