B0BKGHSD3R
[500 ] during [POST] to [http://zhcxkj-center-bi/list/queryAmzProductPerformanceDimChild] [IAmzProductPerformanceDimOpenApi#queryAmzProductPerformanceDimChildList(AmzProductPerformanceDimChildQry)]: [{"success":false,"errCode":"10000500","errMessage":"\n### Error querying database. Cause: java.sql.SQLException: sql injection violation, dbType mysql, , druid-version 1.2.11, syntax error: not suppo... (24575 bytes)]
SELECT
tappd.asin AS asin,
tappd.country_code AS countryCode,
tappd.currency_code AS currencyCode,
tappd.source_id AS sourceId,
-- tapb.brand AS brand GROUP_CONCAT( concat( tappd.sku, '' ), ';' ) AS skus,
GROUP_CONCAT( concat( tappd.fnsku, '' ), ';' ) AS fnskus,
min( tappd.promotion_time ) AS promotionTime,
min( tappd.sale_status ) AS saleStatus,
min( tappd.label_attribute ) AS labelAttribute,
sum( t.saleQuantity ) AS saleQuantity
FROM
t_amz_product_performance_dim tappd
INNER JOIN t_amz_product_brand tapb ON tapb.customer_id = tappd.customer_id
AND tapb.source_id = tappd.source_id
AND tapb.asin = tappd.asin
LEFT JOIN (
SELECT
tapp.source_id AS sourceId,
tapp.msku AS msku,
sum( tapp.sale_quantity ) AS saleQuantity
FROM
t_amz_product_performance tapp
WHERE
tapp.customer_id = 1
AND tapp.purchase_date >= '2023-07-19 00:00:00'
AND tapp.purchase_date <= '2023-07-19 23:59:59'
AND tapp.is_deleted = 0
GROUP BY
tapp.source_id,
tapp.msku
) t ON tappd.source_id = t.sourceId
AND tappd.msku = t.msku
WHERE
tappd.customer_id = 1
AND tapb.brand IN ( 'COSLUS' )
AND tappd.asin IN ( 'B0BKGHSD3R' )
AND tappd.country_code = 'US'
AND tappd.asin IN ( 'B0BKGHSD3R' )
AND tappd.asin IS NOT NULL
AND tappd.asin != ''
AND tappd.is_deleted = 0
GROUP BY
tappd.asin,
tappd.country_code,
tappd.currency_code,
tappd.source_id
ORDER BY
saleQuantity DESC
没有,号，且没有聚合max