In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!
what does this mean in this instance, and how do i resolve it ASAP?
Array (  => INSERT INTO dwtphovu_8347379386_test.6_serviceleads TSL ( TSL.bigint_LeadID, TSL.text_Consumer, TSL.text_LeadAttributes, TSL.timestamp_ExpectedBy, TSL.text_LeadMessage, TSL.bigint_ServiceID, TSL.bigint_SupplierID, TSL.bigint_RegionID, TSL.tinyint_LeadSent, TSL.timestamp_LeadCreated, TSL.text_Duplicates ) SELECT bigint_LeadID, text_Consumer, text_LeadAttributes, timestamp_ExpectedBy, text_LeadMessage, bigint_ServiceID, bigint_SupplierID, ( SELECT TR.bigint_RegionID FROM dwtphovu_8347379386_test.1_regions TR, dwtphovu_8347379386_prod.1_regions PR WHERE CONCAT("%",UPPER(PR.text_RegionDescription),"%") LIKE CONCAT("%",UPPER(TR.text_RegionDescription),"%") AND PR.bigint_RegionID = PSL.bigint_RegionID ) AS bigint_RegionID, tinyint_LeadSent, timestamp_LeadCreated, text_LeadSubject FROM dwtphovu_8347379386_prod.6_serviceleads PSL;  => ERROR #1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TSL ( TSL.bigint_LeadID, TSL.text_Consumer, TSL.text_LeadAttribu' at line 2 in /home/dwtphovu/public_html/intellisource.co.za/test_8347379386/db_synchronizer.php on Line 57 )