JezK
Edit File: killed_mysql_queries.log.1
2020-10-25 17:11:28 +0000 [info] killed_thread_id:63195429 user:qpentd4d_petmagi host:localhost db:qpentd4d_rolanda command:Query time:23 query:SELECT * FROM `sma_sales` LEFT JOIN `sma_payments` ON `sma_payments`.`sale_id`=`sma_sales`.`id` LEFT JOIN ( SELECT sale_id, product_id, serial_no, GROUP_CONCAT(CONCAT(sma_sale_items.product_name, '__', sma_sale_items.quantity) SEPARATOR '___') as item_nane from sma_sale_items GROUP BY sma_sale_items.sale_id ) FSI ON `FSI`.`sale_id`=`sma_sales`.`id` LEFT JOIN `sma_warehouses` ON `sma_warehouses`.`id`=`sma_sales`.`warehouse_id`