use theses


select stcode,in_kartable from payamgir where code_payam=15  and  stcode in

 (
select stcode from payamgir 
where code_payam=15 and in_kartable>0 and stcode in 
(select stcode from stages
 where stg13=1 )

)

 group by stcode,in_kartable
  order by stcode