mysqli - my query won't work due to order by Clause in mysql -

i writing query displaying data , added order clause in query. query

select * `coupons`  `status` = 'a' &&  `type` = '2'     &&  `time` > curdate() && `start_date` <= curdate() order `stocks` asc  

in above query sorted 'stocks' in cases stocks 0 , case want show row @ last. should please . in advance.

order case when `stocks` = 0 1 else 0 end asc , `stocks` asc