SELECT
s.*
FROM
(
SELECT
`CustomerId` AS `CustomerId`,
`Sku` AS `Sku`
FROM
`P_Product` m
WHERE
(((((
`CustomerId` = 1
)
AND (
EXISTS (
SELECT
*
FROM
`P_Market_Product_Review`
WHERE
((((
`CustomerId` = `m`.`CustomerId`
)
AND ( `MarketId` = 97 ))
AND ( `Sku` = `m`.`Sku` ))
AND ( `IsForbidSale` = 1 ))
)))
AND (
EXISTS ( SELECT * FROM `P_Product_ProhibitionSaleMarket` WHERE ((( `CustomerId` = `m`.`CustomerId` ) AND ( `Sku` = `m`.`Sku` )) AND ( `MarketId` = 97 )) )))
AND ( `StartBatch` >= 0 ))
AND ( `StartBatch` <= 200 ))
) p
INNER JOIN (
SELECT
s.*
FROM
`M_ShopeeV2_Listing_Sub` s
INNER JOIN `M_ShopeeV2_Listing` l ON ((((
`s`.`CustomerId` = `l`.`CustomerId`
)
AND ( `s`.`IsGlobal` = `l`.`IsGlobal` ))
AND ( `s`.`OrderSourceId` = `l`.`OrderSourceId` ))
AND ( `s`.`ProductId` = `l`.`ProductId` ))
WHERE
((((((
`l`.`CustomerId` = 1
)
AND ( `l`.`IsGlobal` = 0 ))
AND NOT ( `l`.`Sku` IS NULL OR `l`.`Sku` = '' ))
AND (
`l`.`OrderSourceId` IN ( 14260, 14261, 14262, 14263, 14264, 14265, 14266, 14267 ))
)
AND (
`l`.`EditStatus` IN ( 1, 2, 6 ))
)
AND ((
`l`.`Type` = 1
)
OR ((
`l`.`Type` = 2
)
AND ( `s`.`IsMain` = 0 ))))
) s ON ((
`p`.`CustomerId` = `s`.`CustomerId`
)
AND ( `p`.`Sku` = `s`.`Sku` ))
ORDER BY
`s`.`Id` ASC
LIMIT 0,
100;
任务描述
需求描述
业务背景
1)业务方临时数据处理、统计、导出等无法得到及时帮助
2)生产问题排查排期周期过长
业务文档
https://alidocs.dingtalk.com/i/nodes/mExel2BLV541nqKkSZX5MzAlWgk9rpMq?utm_scene=team_space
验收标准
及时响应业务问题并处理妥善,保持系统稳定性
1.修改sql地方,添加sku匹配