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

这条是CA的

-- 没勾选
                SELECT
                    t1.msku AS msku,
                    sum( tafvi.fulfillable_quantity ) AS fulfillableQuantity,
                    sum( tafvi.pending_transshipment_quantity ) AS pendingTransshipmentQuantity,
                    sum( tafvi.fc_processing_quantity ) AS fcProcessingQuantity
                FROM
                (
                    SELECT
                        tafvic.msku,
                        tafvic.virtual_id
                    FROM
                    t_amz_fba_virtual_inventory_country tafvic
                    WHERE tafvic.msku IN("CC-CCNN-P","ND-ND-PP6","CCNN-GG-761","ND-ND-PP1","PP-ND-ND22","MC-F5O8-3R42","News-ND-ND-L","UPND-NPND-GG","UPND-NPND-PP","News-ND-ND-LP","ND-ND-GG1","GG-ND-ND-NEW","PP-NDND-PP-1","GG-NDND-GG","CC-CCNN-G","Y1-3BO5-P1V8","9K-97YD-UA6L","GG-ND-ND22","CCNN-PP-761","ND-ND-PP4","ND-ND-PP5","ND-ND-PP2","28-0EHI-E9E4","News-TT-P","ND-ND-PP3","PP-ND-ND33","76-TUBR-VSGW","PP-NDND-PP","GG-NDND-GG-1","4L-GYXC-4ATM","FD-MTC9-5JIC","1A-1E7Z-JUD1","13-7TJE-NZB5","NZ-LZ1X-XTCI")
                    AND tafvic.is_deleted = 0
                    AND tafvic.exist_child = 0
                    GROUP BY tafvic.msku, tafvic.virtual_id
                ) t1
                LEFT JOIN t_amz_fba_virtual_inventory tafvi ON t1.virtual_id = tafvi.id
                WHERE tafvi.warehouse_type IN ( 3, 4 )
                AND tafvi.is_deleted = 0
                GROUP BY t1.msku
                ORDER BY tafvi.fulfillable_quantity desc