PHP Multiple Counts in MySQL - SQL

PHOTO EMBED

Fri Sep 02 2022 18:42:09 GMT+0000 (Coordinated Universal Time)

Saved by @raca12

$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;
content_copyCOPY

https://popsql.com/learn-sql/mysql/how-to-have-multiple-counts-in-mysql