chive All kinds of chive,potato, onions (white/yellow), garlic, carrot, tomato, bell pepper, chili, chive, cumin seed, star a

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=30494 and seriesID=1669 and ( productname like '%.html;Benzyl-Alcohol-;-Diacetyl-;Dipentene-;-Aldehyde-C-16-;Coumarin%' or keywords like '%.html;Benzyl-Alcohol-;-Diacetyl-;Dipentene-;-Aldehyde-C-16-;Coumarin%') and validated='2' order by displayorder_series asc,displayorder asc,submitdate desc ) and id is not null and ComId=30494 and seriesID=1669 and ( productname like '%.html;Benzyl-Alcohol-;-Diacetyl-;Dipentene-;-Aldehyde-C-16-;Coumarin%' or keywords like '%.html;Benzyl-Alcohol-;-Diacetyl-;Dipentene-;-Aldehyde-C-16-;Coumarin%') and validated='2' order by displayorder_series asc,displayorder asc,submitdate desc