provider:13provider:18SELECT GROUP_CONCAT(c.`id`) as cartids FROM `cart` as c LEFT JOIN `cart_item` as ci ON c.`id`=ci.`cart_id` LEFT JOIN `cart_person_invoice` as cpi ON c.`id` = cpi.`cart_id`
        WHERE (cpi.`cart_id` IS NULL AND ((ci.`lis_code`='AgSARSCoV2kk' AND c.`cart_status`=90) OR (ci.`lis_code`='AgSARSCoV2testc' AND c.`cart_status`=90) OR (ci.`lis_code`='PCRSARSCoV2testckk' AND c.`cart_status`=90))
        AND ci.`labor_id`='intern' AND c.`remitter_type`=36) OR (cpi.`cart_id` IS NULL AND ci.`labor_id`='drln_zh01' AND c.`cart_status` = 90 AND c.`remitter_id`=2842) AND c.`person_id` NOT IN (0)