$toplamGonderi = $wpdb->get_results(" SELECT count(*) as toplam, SUM(IF(durum = '2', 1, 0)) AS gonderildi, SUM(IF(durum = '4', 1, 0)) AS hatali FROM newsletter_islem where bulten_id=$tgonderi->id "); $toplamGonderilecekT =$toplamGonderi[0]->toplam; $toplamGonderilenT =$toplamGonderi[0]->gonderildi; $thatasi =$toplamGonderi[0]->hatali;