add_filter( 'woocomerce_lottery_history', 'woocomerce_lottery_history_sort_by_ticket_number', 15 , 4 );

function woocomerce_lottery_history_sort_by_ticket_number( $history, $product_id, $user_id, $relisteddate ){
		global $wpdb;
		$wheredatefrom = '';
		$datefrom      = FALSE;
		$relisteddate  = get_post_meta( $product_id, '_lottery_relisted', true );
		if(!is_admin() && !empty($relisteddate)){
		    $datefrom = $relisteddate;
		}
		if($datefrom){
		    $wheredatefrom =" AND CAST(date AS DATETIME) > '$datefrom' ";
		}
		if($user_id){
		    $wheredatefrom =" AND wc_lottery_log.userid = $user_id";
		}
		$history = $wpdb->get_results( 'SELECT * FROM '.$wpdb->prefix.'wc_lottery_log LEFT JOIN '.$wpdb->prefix.'wc_lottery_pn_log on '.$wpdb->prefix.'wc_lottery_log.id = '.$wpdb->prefix.'wc_lottery_pn_log.log_id WHERE '.$wpdb->prefix.'wc_lottery_log.lottery_id =' . $product_id . $wheredatefrom.' ORDER BY `ticket_number` ASC');
		return $history;
}