shopro导出的统计数据核对逻辑，主要是后台导入的团体年卡的对不上

执行下面2组SQL，找出不同的数据，进行增加或者减少操作。

//订单详情表的分组订单ID和数量

SELECT
order_id,count(oi.id) as cid
FROM
`fa_shopro_order_item` `oi`
LEFT JOIN `fa_shopro_order` `o` ON `oi`.`order_id` = `o`.`id`
WHERE
(
`status` > 0
AND `paytime` BETWEEN '1656604802'
AND '1659283199'
AND `oi`.`goods_id` = '36'
AND `oi`.`refund_status` NOT IN ( '2', '3' )
AND `order_way` = '1'
AND `ticket_type` = '2'
)
AND `oi`.`deletetime` IS NULL GROUP BY
order_id ORDER BY cid desc

//人脸录入表的分组订单ID和数量

SELECT ord_id,count(id) as fid FROM fa_shopro_face where ord_id in (
SELECT
order_id
FROM
`fa_shopro_order_item` `oi`
LEFT JOIN `fa_shopro_order` `o` ON `oi`.`order_id` = `o`.`id`
WHERE
(
`status` > 0
AND `paytime` BETWEEN '1656604802'
AND '1659283199'
AND `oi`.`goods_id` = '36'
AND `oi`.`refund_status` NOT IN ( '2', '3' )
AND `order_way` = '1'
AND `ticket_type` = '2'
)
AND `oi`.`deletetime` IS NULL GROUP BY
order_id ) GROUP BY
ord_id ORDER BY fid desc