require_once "../pdefine.php";
$sqlStr="SELECT substr(seihin.bunrui,1,2) as 'dai',count(seihin.id) as 'kazu' from seihin inner join maker on seihin.makercode=maker.makercode ".
"inner join tbl_bunrui on seihin.bunrui=tbl_bunrui.syokubun where media=3 and (maker.MAKERCODE!=20000 and maker.MAKERCODE!=20001 and maker.MAKERCODE!=20003 and maker.MAKERCODE!=20004) ".
" and ifnull(viewfrom,now())<=now() and ifnull(viewto,now()) >=now() group by substr(seihin.bunrui,1,2)";
$rs = $mdb2jsia->queryAll($sqlStr);
?>