Checked and tested the CRM query on L'OCcitane stores to identify the issue through MySQL Workbench. The query did not have errors in getting customer_id from cy_202212_account and sys_trans_num from cy_202212_header. Tested limiting the CRM query rows to 1 up to 5 on stores 243 and 745. The query successfully returned 1 up to 5 rows of data but took a lot of time. Query stuck on "Fetching" when limiter is removed. The CRM query executes successfully and returns rows flawlessly when done through the POS server in PuTTY.