frozen pumpkin products All kinds of frozen pumpkin products,frozen green asparagus, garlic products, onion products , sweet potato products , broccoli , caulifl

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