Select distinct SCategory from CJlryMaster where AddInfo20 not in ('y','draft') and SCategory not in ('','Null','0') and PQty<>0 and CJlryImage not in ('','Null') and MCategory='Silver Fashion Jewelry' and SCategory='Pendants' order by (SCategory) asc