0
Inclusive of all taxes
select distinct color from bar_combination inner join master_color on bar_combination.colr=master_color.cid where scatid='1' and delstatus='0' and color not in ('','0') and cur_stock>0