Query SELECT `id`, `from_id`, `to_id`, `data`, `sentDate`, `status`, `subject`, `message`, `outbox`, `anonym`, `list_id`, `List_Status`,  `sponsor_status`,  `documents`, `Evaluation_report`, `Diligence_report`, `evaluation_Comp`, List_Period as sponsoring_period, job_id,job_class, (SELECT email FROM users Where sid  = from_id) as email,cvJobClass, fromCountry, toCountry,Re_Post_countires,msg_type,EXTRA_DATA,inbox_subject, order_status,COMPLAINT_ID,time_zone, read_time_zone, (SELECT username  FROM users U Where U.sid = from_id) as username, (SELECT CONCAT(U.FirstName , ' ', U.LastName)  FROM users U Where U.sid = from_id) as JobSeeker, (SELECT CONCAT(U.FirstName , ' ', U.LastName)  FROM users U Where U.sid = to_id) as ToJobSeeker, (SELECT RecCompanyname  FROM users U Where U.sid = from_id) as Recruiter, (SELECT RecCompanyname  FROM users U Where U.sid = to_id)  as ToRecruiter, (SELECT CompanyName  FROM users U Where U.sid = to_id)  as ToCompanyName, (SELECT listing_type_sid FROM listings L Where L.sid = list_id)  as listing_type, (SELECT cv_sponsoring_status FROM listings L Where L.sid = list_id)  as sponsoring_status_Type, (SELECT cv_current_country FROM listings L Where L.sid = list_id)  as cv_current_country, (SELECT activation_date FROM listings L Where L.sid = list_id)  as postingDate, (Select re_posting_date From RepostingDetails Where posting_type = '23139' and cv_id =list_id)  as autoRepostedDate, (SELECT post_type FROM listings L Where L.sid = list_id)  as cvPostType, (SELECT cv_sponsoring_status_search FROM listings L Where L.sid = list_id)  as cvPostStatus, (SELECT (45- DATEDIFF(CURRENT_DATE, activation_date)) FROM listings L Where L.sid = list_id)  as posting_period, (SELECT U.email FROM users U Where U.sid = to_id)  as ToEmail, (SELECT U.username FROM users U Where U.sid = to_id)  as ToUser, (SELECT hh_agency_name  FROM users U Where U.sid = from_id) as headHunter, (SELECT CompanyName  FROM users U Where U.sid = from_id) as Employer, (SELECT Max(p.id) FROM private_message p Where p.list_id = private_message.list_id and p.from_id = private_message.to_id and p.to_id = private_message.from_id) as replyID, (SELECT Max(p.List_Country)  FROM private_message p Where p.id = private_message.id) as List_Country, (SELECT Max(p.List_Period) FROM private_message p Where p.list_id = list_id and p.from_id = from_id and p.to_id = to_id ) as List_Period, (SELECT UP.group_title FROM user_groups UP Where UP.SID = (SELECT U.user_group_sid FROM users U Where U.sid = to_id)) as GropName,  (SELECT Case UP.user_group_sid When 36 Then 'CV' When 47 Then 'CV' When 49 Then 'CV' When 53 Then 'CV' ELSE 'Job' End FROM users UP Where UP.SID = (
		SELECT U.user_sid FROM listings U Where U.sid = list_id)) as TaskType FROM private_message WHERE id =  : 
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 '' at line 2

Query UPDATE `private_message` SET `status` = '1', Read_date = '2026-03-07 02:24:08', read_time_zone = 'America/New_York' WHERE `id` =  : 
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 '' at line 1

Query UPDATE `private_message` SET `status` = '1', Read_date = '2026-03-07 02:24:08', read_time_zone = 'America/New_York' WHERE `parent_id` =  : 
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 '' at line 1

Query INSERT INTO SCREEN_TABLE(SCREENER_ID, LIST_ID, CV_STATUS) values(, , '0') : 
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 ' , '0')' at line 1