Php

$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();

$query = $db->prepare("SELECT id total FROM talep t inner join sehir s on t.sehir = s.sehir_key where t.alanid=:alanid and status=:status");
$query->execute(array("alanid"=>"DEĞER","status"=>"DEĞER"));
$totalRow = $query->rowCount();