$query = $db->query("SELECT COUNT(id) total FROM talep t
join sehir s on t.sehir = s.sehir_key where t.alanid=:alanid and status=:status");
$totalRow = $query->fetchColumn();