select id=selectMcbSubmissionStatusFromMCAXS260 resultMap=selectMcbSubmissionStatusInfoResultMap1 SELECT msssubmission_request_id mssjob_seeker_id mssjob_seeker_by_company_id msssub

This is a SQL query that retrieves data from multiple tables using several joins. It selects various columns from the tables mcb_submission_status, mcb_submission_request, company_contract_media, and contract_media_master. It includes conditions in the WHERE clause to filter the results based on specific criteria, such as the submission status, force stop flag, job seeker by company ID, and system deleting flag. The results are ordered by job seeker by company ID and submission request ID. The query uses dynamic SQL to generate the job seeker by company ID list using the tag. The resultMap attribute specifies the mapping of the query results to a result map defined elsewhere