$query = "SELECT receiver, COUNT(*) as total, SUM(case when net_amount > 0.15 then net_amount else 0 end) as toplampara FROM trxes WHERE type='Referal' AND created_at BETWEEN '$baslangic' and '$bitis' GROUP BY receiver HAVING receiver > 0 order by toplampara DESC LIMIT 5";

$query = $db->prepare($query);