= DATE_SUB('{$hoje}', INTERVAL 1 YEAR) AND o.status = s.stat_id AND s.stat_ignored <> 1 {$qry_filter_clients} {$qry_filter_areas} "; $sql.= " GROUP BY p.problema ORDER BY total DESC LIMIT 10"; $sql = $conn->query($sql); $data = array(); if ($sql->rowCount()) { foreach ($sql->fetchAll(PDO::FETCH_ASSOC) as $row) { $data[] = $row; } } else { $data[] = array( "problema" => TRANS('NO_RECORDS_FOUND'), "total" => 0 ); } $data[]['chart_title'] = TRANS('TOP_TEN_TYPE_OF_ISSUES', '', 1); // IMPORTANT, output to json echo json_encode($data); ?>