您好，欢迎来到虫洞时空！
请登录
[买家]
[卖家]
|
免费注册
买家注册
卖家注册
请求出现异常，异常类型：【org.springframework.jdbc.BadSqlGrammarException】，
异常信息：【PreparedStatementCallback; bad SQL grammar [ SELECT p.*, b.NAME AS brand_name, b.name_en as brand_name_en, sp.NAME AS prv_name, sp.contact AS prv_contact, sp.ADDRESS AS prv_address, sp.TELEPHONE AS prv_tel, sp.logo AS prv_logo, sp.email AS prv_email, sp.SYS_NUM AS prvSysNum, c.BASE_DISCOUNT, c.TAX_RATE, c.DUTYFREE_RATE, d.DETAIL_INFO, g.DISCOUNT AS groupon_discount, g.id AS groupon_id, ss.id AS store_id, ca.IS_REAGENT, ca.IS_REAGENT_CHEM FROM prd_base AS p INNER JOIN sys_provider AS sp ON p.PRV_ID = sp.ID AND sp. STATUS = 1 INNER JOIN slr_config AS c ON p.PRV_ID = c.PRV_ID LEFT JOIN prd_brand AS b ON p.BRAND_ID = b.id LEFT JOIN slr_config AS c ON p.PRV_ID = c.PRV_ID LEFT JOIN prd_brand AS b ON p.BRAND_ID = b.id LEFT JOIN prd_detail AS d ON p.id = d.PRD_ID AND p.PRV_ID = d.PRV_ID LEFT JOIN prd_category AS ca ON p.CATEGORY_ID = ca.ID LEFT JOIN sys_store AS ss ON sp.ID = ss.PRV_ID AND ss. STATUS = 1 LEFT JOIN ( SELECT g.*, gp.PRD_ID FROM prd_groupon_product AS gp JOIN prd_groupon AS g ON g.ID = gp.GROUPON_ID AND g. STATUS = 3 AND NOW() >= g.START_DATE AND NOW() < DATE_ADD(g.END_DATE, INTERVAL 1 DAY) ) AS g ON g.PRD_ID = p.ID WHERE p.id =? ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Not unique table/alias: 'b'】
北京虫洞时空于2021年10月成立，为进一步提升实验室供应链效率， 解决实验室在采购中存在的选货、价格、物流和结算难等问题，提升实验室服务的互联网化水平，公司致力于成为中国领先的专业实验室第三方电商平台。
