请教这句查询哪里错了.

2016-07-07 15:00 来源：www.chinab4c.com 作者：ecshop专家

$sql = "SELECT COUNT(*) FROM " .$GLOBALS['ecs']->table('goods'). " AS g" . $GLOBALS['ecs']->table('admin_user') . "AS a WHERE g.suppliers_id = "SELECT suppliers_id FROM ".$GLOBALS['ecs']->('admin_user') . "AS a WHERE a.user_name='$usname' AND is_delete='$is_delete' $where";