Please, help me to find syntax error in SQL generated after calling get_full_list method. Here is my SQL
Query Failed: SELECT cases.* ,cases_cstm.phone_c,cases_cstm.biz_email_c,cases_cstm.processor_address_c,cases_cstm.funder_dba_name_c,cases_cstm.case_state_c,cases_cstm.note_name_c,cases_cstm.reminder_descr_c,cases_cstm.plaint_affid_title_c,cases_cstm.judg_amount_less_pay_c,cases_cstm.county_of_filing_c,cases_cstm.date_of_judgement_c,cases_cstm.duplicate_name_c,cases_cstm.date_of_default_c,cases_cstm.merchant_zip_c,cases_cstm.ftid_c,cases_cstm.sender_phone_c,cases_cstm.delivery_method_c,cases_cstm.merchant_id_c,cases_cstm.ssn_c,cases_cstm.business_name_abbr_c,cases_cstm.attorney_name_c,cases_cstm.note_descr_c,cases_cstm.merchant_address_c,cases_cstm.jjwg_maps_lng_c,cases_cstm.owner_state_c,cases_cstm.created_by_contact_c,cases_cstm.legal_fee_prcnt_c,cases_cstm.bank_department_c,cases_cstm.payback_amount_c,cases_cstm.owed_c,cases_cstm.leg_fee_written_c,cases_cstm.funder_abbr_c,cases_cstm.jjwg_maps_lat_c,cases_cstm.advance_amount_c,cases_cstm.jjwg_address_cache_id_c,cases_cstm.bank_city_zip_c,cases_cstm.merchant_city_c,cases_cstm.five_days_after_today_c,cases_cstm.jjwg_maps_geocode_status_c,cases_cstm.turn_stale_case_c,cases_cstm.plaint_affid_county_c,cases_cstm.bal_with_fees_c,cases_cstm.bank_name_c,cases_cstm.method_of_submission_c,cases_cstm.tot_pay_rcvd_c,cases_cstm.owner_name_c,cases_cstm.plaint_affid_signer_c,cases_cstm.merch_agree_date_c,cases_cstm.curr_date_c,cases_cstm.file_names_c,cases_cstm.sender_name_c,cases_cstm.rtr_c,cases_cstm.plaint_address_c,cases_cstm.jjwg_maps_address_c,cases_cstm.reminder_switcher_c,cases_cstm.coj_date_c,cases_cstm.judg_amount_c,cases_cstm.owner_address_c,cases_cstm.default_fee_c,cases_cstm.owner_name_abbr_c,cases_cstm.sender_email_c,cases_cstm.amount_purchased_c,cases_cstm.merchant_state_c,cases_cstm.case_reminder_c,cases_cstm.plaint_affid_state_c,cases_cstm.duplicate_number_c,cases_cstm.index_number_c,cases_cstm.merchant_dba_name_c,cases_cstm.bank_str_address_c,cases_cstm.legal_fee_calc_c , jt0.user_name modified_by_name , jt0.created_by modified_by_name_owner , 'Users' modified_by_name_mod , jt1.user_name created_by_name , jt1.created_by created_by_name_owner , 'Users' created_by_name_mod , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod , accounts.name account_name , accounts.assigned_user_id account_name_owner , 'Accounts' account_name_mod, jt4.name processor_name_c , ' ' cases_cases_1_name , ' ' cases_cases_1cases_idb FROM cases LEFT JOIN cases_cstm ON cases.id = cases_cstm.id_c LEFT JOIN users jt0 ON cases.modified_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON cases.created_by=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON cases.assigned_user_id=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN accounts accounts ON cases.account_id=accounts.id AND accounts.deleted=0
AND accounts.deleted=0 LEFT JOIN accounts jt4 ON cases_cstm. = jt4.id AND jt4.deleted=0 where (cases.date_modified <= '2016-10-29 13:29:01' AND cases_cstm.case_state_c <> 'Duplicate' AND cases_cstm.case_state_c <> 'Declined' AND cases_cstm.case_state_c <> 'Returned' AND cases_cstm.case_state_c <> 'Bankruptcy' AND cases_cstm.case_state_c <> 'Payment_Plan' AND cases_cstm.case_state_c <> 'Local_Counsel' AND cases.state = 'Open') AND cases.deleted=0: MySQL 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 '= jt4.id AND jt4.deleted=0 where (cases.date_modified <= '2016-10-29 13:29:01' ' at line 9