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

SELECT `OrderSourceId` FROM `Ap_AutoPublish_Mercadolibre_Queue` WHERE ((( `CustomerId` = 1 ) AND ( `Status` = 'normal' )) AND (( `TaskStatus` = 1 ) OR ((( `TaskStatus` = 2 )
                AND ( `LoadQueueTime` < TIMESTAMP ( '2023-06-29 08:05:13.098569' ) ))
        AND ( `LoadQueueTime` > TIMESTAMP ( '2023-06-24 09:05:13.098571' ) ))))
GROUP BY

    `OrderSourceId`;

建议优化：

SELECT `OrderSourceId` FROM `Ap_AutoPublish_Mercadolibre_Queue` WHERE ((( `CustomerId` = 1 ) AND ( `Status` = 'normal' )) AND (( `TaskStatus` = 1 )))
GROUP BY
    `OrderSourceId`
union  
SELECT `OrderSourceId` FROM `Ap_AutoPublish_Mercadolibre_Queue` WHERE ((( `CustomerId` = 1 ) AND ( `Status` = 'normal' )) AND
(( `TaskStatus` = 2 )
                AND ( `LoadQueueTime` < TIMESTAMP ( '2023-06-29 08:05:13.098569' ) ))
        AND ( `LoadQueueTime` > TIMESTAMP ( '2023-06-24 09:05:13.098571' ) )
)
GROUP BY
    `OrderSourceId`