= DATE_ADD(now(), INTERVAL '-".LIMIT_TIME_SELL."' HOUR) ";
$totalrows = @mysql_fetch_array(mysql_query("SELECT
ifnull(sum(case when s.ds_status = 'B0' or s.ds_status = 'C0' or s.ds_status = 'D0' then 1 else 0 end),0) D0_cnt
, ifnull(sum(case when s.ds_status = 'Z0' then 1 else 0 end),0) Z0_cnt
, ifnull(sum(case when s.ds_status = 'ZS' then 1 else 0 end),0) ZS_cnt
FROM sale_master s
INNER JOIN car_master a on ( s.cd_car = a.cd_car )
WHERE s.ds_delind = 'N'
$sql"
));
?>