深圳智汇创想科技有限公司

敏感词

anti-fouling

Medical Cleansing

Anti-mite

bug spray

SELECT
t.id AS id,
t.content AS content,
t.asin AS asin,
t.marketplace_id AS marketplaceId,
t.update_time AS updateTime 
FROM
(
SELECT
taap.id,
taape.content,
taapa.asin,
taapa.marketplace_id,
taap.update_time,
ROW_NUMBER() over ( PARTITION BY taapa.asin, taapa.marketplace_id ORDER BY taap.update_time DESC ) rn 
FROM
t_amazon_a_plus taap
LEFT JOIN t_amazon_a_plus_extend taape ON taap.id = taape.a_plus_id
LEFT JOIN t_amazon_a_plus_asin taapa ON taap.id = taapa.a_plus_id 
WHERE
taap.customer_id = 1 
AND ( taapa.asin, taapa.marketplace_id ) IN (
( 'B0C4YCHZ69', 'ATVPDKIKX0DER' ),
( 'B0BJ1H89KV', 'ATVPDKIKX0DER' ),
( 'B0C4YC7S46', 'ATVPDKIKX0DER' ),
( 'B0BG52SJ5N', 'ATVPDKIKX0DER' )
) 
AND taap.check_status = 3 
AND taap.publish_status = 3 
AND taap.is_deleted = 0 
) t 
WHERE
t.rn = 1