select 
  sale_type 
from 
  cscart_products 
where 
  product_id = 1253