{"9":{"request":{"url":"/position","get":{"id":"1801439851270844024","org_id":"1801439851242492101"},"post":{},"requestMethod":"GET"},"response":{"data":{"data":{"id":"1801439851270844024","org_id":"1801439851242492101","city_id":"1801439851227617724","cities":{"id":"1801439851227617724","name":"Avdon"},"address":"FFFFF","department_id":"1801439851270840402","departments":{"id":"1801439851270840402","enabled":true,"name":"TestSergei"},"coordinator_id":"1801439851270840514","coordinators":{"id":"1801439851270840514","enabled":true,"hidden":false,"disabled":false,"name":"TestSergei11hgfdhjkgf"},"cluster_id":null,"clusters":null,"nearest_event_id":null,"single":false,"cap":0,"begin_dt":null,"accepted_candidates":0,"sla":0,"status_id":"1801439851249186875","position_statuses":{"id":"1801439851249186875","symbolic_name":"active","name":"Active"},"reason_id":null,"position_reasons":null,"position_id":"33333","has_course":true,"name":"TESTtWO","description":"33"},"messages":[{"success":true}]},"httpCode":200}},"10":{"request":{"url":"/position/event","get":{"position_id":"1801439851270844024","org_id":"1801439851242492101"},"post":{},"requestMethod":"GET"},"response":{"data":{"data":{"course_event":[{"id":"1801439851288553395","org_id":"1801439851242492101","is_course":true,"hidden":false,"time_start":1457654400,"time_end":1457740800,"all_day":false,"address":"sd","city_id":"1801439851227613223","cities":{"id":"1801439851227613223","name":"Brechya"},"name":"QATest","cap":45,"real_cap":45,"candidates_count":2,"pending_candidates":0,"accepted_candidates":2,"pending_candidates_count":0,"instructor_ids":["1801439851270862580"],"instructor_names":"QAInstructor","position_id":"1801439851270844024"},{"id":"1801439851271059757","org_id":"1801439851242492101","is_course":true,"hidden":false,"time_start":1443052800,"time_end":1444435200,"all_day":false,"address":"h","city_id":"1801439851226620412","cities":{"id":"1801439851226620412","name":"Alfey Menashe"},"name":"jhgljh","cap":1,"real_cap":1,"candidates_count":0,"pending_candidates":0,"accepted_candidates":0,"pending_candidates_count":0,"instructor_ids":["1801439851270862580"],"instructor_names":"QAInstructor","position_id":"1801439851270844024"},{"id":"1801439851270861550","org_id":"1801439851242492101","is_course":true,"hidden":false,"time_start":1449802800,"time_end":1449889200,"all_day":false,"address":"dfff","city_id":"1801439851226246321","cities":{"id":"1801439851226246321","name":"Adi"},"name":"fff","cap":8,"real_cap":8,"candidates_count":0,"pending_candidates":0,"accepted_candidates":0,"pending_candidates_count":0,"instructor_ids":["1801439851270842063"],"instructor_names":"qqqqq","position_id":"1801439851270844024"},{"id":"1801439851288900169","org_id":"1801439851242492101","is_course":true,"hidden":false,"time_start":1460073600,"time_end":1460160000,"all_day":false,"address":"er","city_id":"1801439851227618109","cities":{"id":"1801439851227618109","name":"Afula"},"name":"RTL","cap":34,"real_cap":34,"candidates_count":16,"pending_candidates":0,"accepted_candidates":16,"pending_candidates_count":0,"instructor_ids":["1801439851270862580"],"instructor_names":"QAInstructor","position_id":"1801439851270844024"},{"id":"1801439851320333317","org_id":"1801439851242492101","is_course":true,"hidden":false,"time_start":1458086400,"time_end":1458172800,"all_day":false,"address":"df","city_id":"1801439851227618109","cities":{"id":"1801439851227618109","name":"Afula"},"name":"LTR","cap":1,"real_cap":1,"candidates_count":1,"pending_candidates":0,"accepted_candidates":1,"pending_candidates_count":0,"instructor_ids":["1801439851270862580"],"instructor_names":"QAInstructor","position_id":"1801439851270844024"},{"id":"1801439851299269852","org_id":"1801439851242492101","is_course":true,"hidden":false,"time_start":1457654400,"time_end":1457834400,"all_day":false,"address":"ersdfgsdf","city_id":"1801439851287558844","cities":{"id":"1801439851287558844","name":"Achisemech"},"name":"QWERTY","cap":3,"real_cap":3,"candidates_count":1,"pending_candidates":0,"accepted_candidates":1,"pending_candidates_count":0,"instructor_ids":["1801439851270862580"],"instructor_names":"QAInstructor","position_id":"1801439851270844024"},{"id":"1801439851288556115","org_id":"1801439851242492101","is_course":true,"hidden":false,"time_start":1459382400,"time_end":1460160000,"all_day":false,"address":"df","city_id":"1801439851226246321","cities":{"id":"1801439851226246321","name":"Adi"},"name":"On","cap":1,"real_cap":1,"candidates_count":2,"pending_candidates":0,"accepted_candidates":14,"pending_candidates_count":0,"instructor_ids":["1801439851270862580"],"instructor_names":"QAInstructor","position_id":"1801439851270844024"}],"ec_event":[]},"messages":[{"success":true}]},"httpCode":200}},"11":{"request":{"url":"/position/steps","get":{"position_id":"1801439851270844024","org_id":"1801439851242492101"},"post":{},"requestMethod":"GET"},"response":{"data":{"data":[{"id":"1801439851270844046","tag_id":"1801439851261476028","position_step_tags":{"id":"1801439851261476028","enabled":true,"symbolic_name":null,"hidden":false,"name":"Sign"},"index":1000000000,"position_id":"1801439851270844024","type_id":"1801439851259050299","steps":{"id":"1801439851259050299","symbolic_name":"sign","name":"Sign"},"questionnaire_id":null,"group_id":null,"send_rejection_email":true,"name":"Sign","email_subject":null,"email_body":null,"form_title":null,"form_description":null,"questions":[]}],"messages":[{"success":true}]},"httpCode":200}},"12":{"request":{"url":"/candidate/position_candidates","get":{"org_id":"1801439851242492101"},"post":{"position_id":"1801439851270844024","step_id":"1801439851270844046","ec_event_id":null,"filter_by_courses":null,"course_id":null,"status_id":"1801439851238935057","order_field":"rank","asc":null,"page":1},"requestMethod":"POST"},"response":{"data":{"messages":[{"success":false},{"error":"PGSQL_FATAL_ERROR\nERROR:  missing FROM-clause entry for table \"ec_position_steps\"\nLINE 62:                     ec_position_steps.id is null or\n                             ^\nERROR:  missing FROM-clause entry for table \"ec_position_steps\"\nLINE 62:                     ec_position_steps.id is null or\n                             ^\nwith tmp as (select distinct on (cln_candidates.id) cln_candidates.id as cln_candidates_id,\n\tcvs.update_dt as cvs_update_dt,\n\tcvs.update_uid as cvs_update_uid,\n\tcvs.added_dt as cvs_added_dt,\n\tcvs.update_cv_source_id as cvs_update_cv_source_id,\n\tcvs.ct_person_id as cvs_ct_person_id,\n\tcvs.ct_file_photo_id as cvs_ct_file_photo_id,\n\tcvs.ct_original_cv_id as cvs_ct_original_cv_id,\n\taddresses.ct_country_id as addresses_ct_country_id,\n\taddresses.ct_city_id as addresses_ct_city_id,\n\taddresses.street as addresses_street,\n\taddresses.house_num as addresses_house_num,\n\tpersons.ct_marital_status_id as persons_ct_marital_status_id,\n\tpersons.home_phone as persons_home_phone,\n\tpersons.mob_phone as persons_mob_phone,\n\tpersons.email as persons_email,\n\tpersons.icn as persons_icn,\n\tpersons.gender as persons_gender,\n\tpersons.borndate as persons_borndate,\n\tcandidate_positions.ct_cv_source_id as candidate_positions_ct_cv_source_id,\n\tcandidate_positions.ct_cln_position_id as candidate_positions_ct_cln_position_id,\n\tcln_position_names_ml.value as cln_position_names_ml_value,\n\tnames_of_applicants_ml.value as names_of_applicants_ml_value,\n\tsurnames_of_applicants_ml.value as surnames_of_applicants_ml_value,\n\tcv_update_user_names_of_applicants_ml.value as cv_update_user_names_of_applicants_ml_value,\n\tcv_update_user_surnames_of_applicants_ml.value as cv_update_user_surnames_of_applicants_ml_value,\n\tlast_cp.id as last_cp_id,\n\tlast_cp.ct_cln_position_id as last_cp_ct_cln_position_id,\n\tlast_cp.ct_current_step_id as last_cp_ct_current_step_id,\n\tcandidate_positions.is_active as candidate_positions_is_active,\n\tcandidate_positions.id as candidate_positions_id,\n\tcln_candidates.dt as cln_candidates_dt,\n\tcandidate_positions.progress_update_dt as candidate_positions_progress_update_dt,\n\tcandidate_positions.progress_update_uid as candidate_positions_progress_update_uid,\n\tcln_candidates.ct_cln_org_id as cln_candidates_ct_cln_org_id,\n\tcandidate_positions.reliability as candidate_positions_reliability,\n\tcandidate_steps.ct_position_step_id as candidate_steps_ct_position_step_id,\n\tposition_steps.ct_cln_step_id as position_steps_ct_cln_step_id,\n\tcandidate_positions.ct_current_step_id as candidate_positions_ct_current_step_id,\n\tcvs.ct_cln_cv_status_id as cvs_ct_cln_cv_status_id,\n\tcln_candidates.ct_cv_id as cln_candidates_ct_cv_id,\n\tcandidate_steps.id as candidate_steps_id,\n\tcandidate_positions.ct_global_status_id as candidate_positions_ct_global_status_id,\n\tcandidate_steps.ct_candidate_status_id as candidate_steps_ct_candidate_status_id,\n\tcandidate_positions.participate_update_uid as candidate_positions_participate_update_uid,\n\tcandidate_steps.ct_positive_status_id as candidate_steps_ct_positive_status_id,\n\tcandidate_steps.ct_candidate_status_id as final_candidate_status,\n\tcandidate_steps.ct_cln_reason_id as candidate_steps_ct_cln_reason_id,\n\tdont_recruit_candidate_positions.dont_recruit as dont_recruit_candidate_positions_dont_recruit,\n\tcandidate_steps.reminder_dt as candidate_steps_reminder_dt,\n\tcandidate_steps.online_form_id as candidate_steps_online_form_id,\n\tcandidate_positions.ct_cln_event_id as candidate_positions_ct_cln_event_id,\n\tcandidate_steps.ct_cln_event_id as candidate_steps_ct_cln_event_id,\n\tcandidate_steps.ct_cln_participation_status_id as candidate_steps_ct_cln_participation_status_id,\n\tcandidate_steps.ct_cln_attendance_status_id as candidate_steps_ct_cln_attendance_status_id,\n\tcandidate_positions.general_note as candidate_positions_general_note,\n\tcandidate_step_notices_ml.value as candidate_step_notices_ml_value,\n\tposition_step_names_ml.value as position_step_names_ml_value,\n\t(\n                candidate_positions.is_active and\n                (\n                    ec_position_steps.id is null or\n                    ec_candidate_steps.ct_candidate_status_id = 1801439851246885247\n                )\n            ) as can_waive,\n\tparticipate_names_of_applicants_ml.value as participate_names_of_applicants_ml_value,\n\tparticipate_surnames_of_applicants_ml.value as participate_surnames_of_applicants_ml_value,\n\tprogress_update_user_names_of_applicants_ml.value as progress_update_user_names_of_applicants_ml_value,\n\tprogress_update_user_surnames_of_applicants_ml.value as progress_update_user_surnames_of_applicants_ml_value,\n\tcandidate_positions.reliability as _order_0,\n\tcln_candidates.dt as _order_1,\n\tcln_candidates.id as _order_2\n from ct_candidate_positions candidate_positions\nleft join ct_cln_positions cln_positions on cln_positions.id = candidate_positions.ct_cln_position_id\nleft join ct_persons participate_persons on participate_persons.id = candidate_positions.participate_update_uid\nleft join ct_persons_names_of_applicants participate_persons_names_of_applicants on participate_persons_names_of_applicants.ct_person_id = participate_persons.id\nleft join ct_persons_surnames_of_applicants participate_persons_surnames_of_applicants on participate_persons_surnames_of_applicants.ct_person_id = participate_persons.id\nleft join ct_persons progress_update_user_persons on progress_update_user_persons.id = candidate_positions.progress_update_uid\nleft join ct_persons_names_of_applicants progress_update_user_persons_names_of_applicants on progress_update_user_persons_names_of_applicants.ct_person_id = progress_update_user_persons.id\nleft join ct_persons_surnames_of_applicants progress_update_user_persons_surnames_of_applicants on progress_update_user_persons_surnames_of_applicants.ct_person_id = progress_update_user_persons.id\ninner join ct_cln_candidates cln_candidates on (cln_candidates.id = candidate_positions.ct_cln_candidate_id and candidate_positions.ct_global_status_id not in (1801439851288364296))\ninner join ct_candidate_positions last_cp on last_cp.id = cln_candidates.ct_last_candidate_position_id and last_cp.ct_global_status_id not in (1801439851288364296)\ninner join ct_cvs cvs on cvs.id = cln_candidates.ct_cv_id\ninner join ct_candidate_steps candidate_steps on candidate_steps.ct_candidate_position_id = candidate_positions.id and candidate_steps.ct_position_step_id = 1801439851270844046\nleft join ct_position_steps position_steps on position_steps.id = candidate_steps.ct_position_step_id\nleft join (\n                ct_candidate_positions dont_recruit_candidate_positions\n                inner join ct_candidate_steps dont_recruit_candidate_steps\n                  on dont_recruit_candidate_steps.ct_candidate_position_id = dont_recruit_candidate_positions.id\n                inner join ct_cln_reasons dont_recruit_reasons\n                  on dont_recruit_reasons.id = dont_recruit_candidate_steps.ct_cln_reason_id\n                  and dont_recruit_reasons.dont_recruit\n            ) dont_recruit_candidate_positions on dont_recruit_candidate_positions.ct_cln_candidate_id = candidate_positions.ct_cln_candidate_id\nleft join ct_cln_position_names_ml cln_position_names_ml on cln_position_names_ml.ct_cln_position_name_id = cln_positions.name_tid and cln_position_names_ml.ct_language_id = 1\ninner join ct_persons persons on persons.id = cvs.ct_person_id\nleft join ct_persons_names_of_applicants persons_names_of_applicants on persons_names_of_applicants.ct_person_id = persons.id\nleft join ct_persons_surnames_of_applicants persons_surnames_of_applicants on persons_surnames_of_applicants.ct_person_id = persons.id\nleft join ct_persons cv_update_user_persons on cv_update_user_persons.id = cvs.update_uid\nleft join ct_persons_names_of_applicants cv_update_user_persons_names_of_applicants on cv_update_user_persons_names_of_applicants.ct_person_id = cv_update_user_persons.id\nleft join ct_persons_surnames_of_applicants cv_update_user_persons_surnames_of_applicants on cv_update_user_persons_surnames_of_applicants.ct_person_id = cv_update_user_persons.id\nleft join ct_addresses addresses on addresses.id = cvs.ct_address_id\nleft join ct_candidate_step_notices_ml candidate_step_notices_ml on candidate_step_notices_ml.ct_candidate_step_notice_id = candidate_steps.notice_tid and candidate_step_notices_ml.ct_language_id = 1\nleft join ct_position_step_names_ml position_step_names_ml on position_step_names_ml.ct_position_step_name_id = position_steps.name_tid and position_step_names_ml.ct_language_id = 1\nleft join ct_names_of_applicants_ml participate_names_of_applicants_ml on participate_names_of_applicants_ml.ct_person_name_id = participate_persons_names_of_applicants.name_tid and participate_names_of_applicants_ml.ct_language_id = 1\nleft join ct_surnames_of_applicants_ml participate_surnames_of_applicants_ml on participate_surnames_of_applicants_ml.ct_person_surname_id = participate_persons_surnames_of_applicants.surname_tid and participate_surnames_of_applicants_ml.ct_language_id = 1\nleft join ct_names_of_applicants_ml progress_update_user_names_of_applicants_ml on progress_update_user_names_of_applicants_ml.ct_person_name_id = progress_update_user_persons_names_of_applicants.name_tid and progress_update_user_names_of_applicants_ml.ct_language_id = 1\nleft join ct_surnames_of_applicants_ml progress_update_user_surnames_of_applicants_ml on progress_update_user_surnames_of_applicants_ml.ct_person_surname_id = progress_update_user_persons_surnames_of_applicants.surname_tid and progress_update_user_surnames_of_applicants_ml.ct_language_id = 1\nleft join ct_names_of_applicants_ml names_of_applicants_ml on names_of_applicants_ml.ct_person_name_id = persons_names_of_applicants.name_tid and names_of_applicants_ml.ct_language_id = 1\nleft join ct_surnames_of_applicants_ml surnames_of_applicants_ml on surnames_of_applicants_ml.ct_person_surname_id = persons_surnames_of_applicants.surname_tid and surnames_of_applicants_ml.ct_language_id = 1\nleft join ct_names_of_applicants_ml cv_update_user_names_of_applicants_ml on cv_update_user_names_of_applicants_ml.ct_person_name_id = cv_update_user_persons_names_of_applicants.name_tid and cv_update_user_names_of_applicants_ml.ct_language_id = 1\nleft join ct_surnames_of_applicants_ml cv_update_user_surnames_of_applicants_ml on cv_update_user_surnames_of_applicants_ml.ct_person_surname_id = cv_update_user_persons_surnames_of_applicants.surname_tid and cv_update_user_surnames_of_applicants_ml.ct_language_id = 1\n where  ( candidate_positions.ct_cln_position_id = '1801439851270844024' ) and  candidate_positions.ct_global_status_id != '1801439851258840040'\n   and  candidate_steps.ct_cln_event_id is null and  ( candidate_steps.ct_candidate_status_id = '1801439851238935057' )\norder by cln_candidates.id asc, cln_candidates.ct_last_candidate_position_id = candidate_positions.id desc, candidate_positions.is_active desc, candidate_positions.id desc)\n                    select tmp.*\n                    from tmp\n                    order by _order_0 desc, _order_1 asc, _order_2 asc\n                    \n limit 100 offset 0","traces":[{"file":"/var/www/callnet/callnet-dev-api.synergetica.net/application/classes/Db.php","line":62,"function":"checkForError","class":"Callnet\\Db","type":"->","args":[null,"with tmp as (select distinct on (cln_candidates.id) cln_candidates.id as cln_candidates_id,\n\tcvs.update_dt as cvs_update_dt,\n\tcvs.update_uid as cvs_update_uid,\n\tcvs.added_dt as cvs_added_dt,\n\tcvs.update_cv_source_id as cvs_update_cv_source_id,\n\tcvs.ct_person_id as cvs_ct_person_id,\n\tcvs.ct_file_photo_id as cvs_ct_file_photo_id,\n\tcvs.ct_original_cv_id as cvs_ct_original_cv_id,\n\taddresses.ct_country_id as addresses_ct_country_id,\n\taddresses.ct_city_id as addresses_ct_city_id,\n\taddresses.street as addresses_street,\n\taddresses.house_num as addresses_house_num,\n\tpersons.ct_marital_status_id as persons_ct_marital_status_id,\n\tpersons.home_phone as persons_home_phone,\n\tpersons.mob_phone as persons_mob_phone,\n\tpersons.email as persons_email,\n\tpersons.icn as persons_icn,\n\tpersons.gender as persons_gender,\n\tpersons.borndate as persons_borndate,\n\tcandidate_positions.ct_cv_source_id as candidate_positions_ct_cv_source_id,\n\tcandidate_positions.ct_cln_position_id as candidate_positions_ct_cln_position_id,\n\tcln_position_names_ml.value as cln_position_names_ml_value,\n\tnames_of_applicants_ml.value as names_of_applicants_ml_value,\n\tsurnames_of_applicants_ml.value as surnames_of_applicants_ml_value,\n\tcv_update_user_names_of_applicants_ml.value as cv_update_user_names_of_applicants_ml_value,\n\tcv_update_user_surnames_of_applicants_ml.value as cv_update_user_surnames_of_applicants_ml_value,\n\tlast_cp.id as last_cp_id,\n\tlast_cp.ct_cln_position_id as last_cp_ct_cln_position_id,\n\tlast_cp.ct_current_step_id as last_cp_ct_current_step_id,\n\tcandidate_positions.is_active as candidate_positions_is_active,\n\tcandidate_positions.id as candidate_positions_id,\n\tcln_candidates.dt as cln_candidates_dt,\n\tcandidate_positions.progress_update_dt as candidate_positions_progress_update_dt,\n\tcandidate_positions.progress_update_uid as candidate_positions_progress_update_uid,\n\tcln_candidates.ct_cln_org_id as cln_candidates_ct_cln_org_id,\n\tcandidate_positions.reliability as candidate_positions_reliability,\n\tcandidate_steps.ct_position_step_id as candidate_steps_ct_position_step_id,\n\tposition_steps.ct_cln_step_id as position_steps_ct_cln_step_id,\n\tcandidate_positions.ct_current_step_id as candidate_positions_ct_current_step_id,\n\tcvs.ct_cln_cv_status_id as cvs_ct_cln_cv_status_id,\n\tcln_candidates.ct_cv_id as cln_candidates_ct_cv_id,\n\tcandidate_steps.id as candidate_steps_id,\n\tcandidate_positions.ct_global_status_id as candidate_positions_ct_global_status_id,\n\tcandidate_steps.ct_candidate_status_id as candidate_steps_ct_candidate_status_id,\n\tcandidate_positions.participate_update_uid as candidate_positions_participate_update_uid,\n\tcandidate_steps.ct_positive_status_id as candidate_steps_ct_positive_status_id,\n\tcandidate_steps.ct_candidate_status_id as final_candidate_status,\n\tcandidate_steps.ct_cln_reason_id as candidate_steps_ct_cln_reason_id,\n\tdont_recruit_candidate_positions.dont_recruit as dont_recruit_candidate_positions_dont_recruit,\n\tcandidate_steps.reminder_dt as candidate_steps_reminder_dt,\n\tcandidate_steps.online_form_id as candidate_steps_online_form_id,\n\tcandidate_positions.ct_cln_event_id as candidate_positions_ct_cln_event_id,\n\tcandidate_steps.ct_cln_event_id as candidate_steps_ct_cln_event_id,\n\tcandidate_steps.ct_cln_participation_status_id as candidate_steps_ct_cln_participation_status_id,\n\tcandidate_steps.ct_cln_attendance_status_id as candidate_steps_ct_cln_attendance_status_id,\n\tcandidate_positions.general_note as candidate_positions_general_note,\n\tcandidate_step_notices_ml.value as candidate_step_notices_ml_value,\n\tposition_step_names_ml.value as position_step_names_ml_value,\n\t(\n                candidate_positions.is_active and\n                (\n                    ec_position_steps.id is null or\n                    ec_candidate_steps.ct_candidate_status_id = 1801439851246885247\n                )\n            ) as can_waive,\n\tparticipate_names_of_applicants_ml.value as participate_names_of_applicants_ml_value,\n\tparticipate_surnames_of_applicants_ml.value as participate_surnames_of_applicants_ml_value,\n\tprogress_update_user_names_of_applicants_ml.value as progress_update_user_names_of_applicants_ml_value,\n\tprogress_update_user_surnames_of_applicants_ml.value as progress_update_user_surnames_of_applicants_ml_value,\n\tcandidate_positions.reliability as _order_0,\n\tcln_candidates.dt as _order_1,\n\tcln_candidates.id as _order_2\n from ct_candidate_positions candidate_positions\nleft join ct_cln_positions cln_positions on cln_positions.id = candidate_positions.ct_cln_position_id\nleft join ct_persons participate_persons on participate_persons.id = candidate_positions.participate_update_uid\nleft join ct_persons_names_of_applicants participate_persons_names_of_applicants on participate_persons_names_of_applicants.ct_person_id = participate_persons.id\nleft join ct_persons_surnames_of_applicants participate_persons_surnames_of_applicants on participate_persons_surnames_of_applicants.ct_person_id = participate_persons.id\nleft join ct_persons progress_update_user_persons on progress_update_user_persons.id = candidate_positions.progress_update_uid\nleft join ct_persons_names_of_applicants progress_update_user_persons_names_of_applicants on progress_update_user_persons_names_of_applicants.ct_person_id = progress_update_user_persons.id\nleft join ct_persons_surnames_of_applicants progress_update_user_persons_surnames_of_applicants on progress_update_user_persons_surnames_of_applicants.ct_person_id = progress_update_user_persons.id\ninner join ct_cln_candidates cln_candidates on (cln_candidates.id = candidate_positions.ct_cln_candidate_id and candidate_positions.ct_global_status_id not in (1801439851288364296))\ninner join ct_candidate_positions last_cp on last_cp.id = cln_candidates.ct_last_candidate_position_id and last_cp.ct_global_status_id not in (1801439851288364296)\ninner join ct_cvs cvs on cvs.id = cln_candidates.ct_cv_id\ninner join ct_candidate_steps candidate_steps on candidate_steps.ct_candidate_position_id = candidate_positions.id and candidate_steps.ct_position_step_id = 1801439851270844046\nleft join ct_position_steps position_steps on position_steps.id = candidate_steps.ct_position_step_id\nleft join (\n                ct_candidate_positions dont_recruit_candidate_positions\n                inner join ct_candidate_steps dont_recruit_candidate_steps\n                  on dont_recruit_candidate_steps.ct_candidate_position_id = dont_recruit_candidate_positions.id\n                inner join ct_cln_reasons dont_recruit_reasons\n                  on dont_recruit_reasons.id = dont_recruit_candidate_steps.ct_cln_reason_id\n                  and dont_recruit_reasons.dont_recruit\n            ) dont_recruit_candidate_positions on dont_recruit_candidate_positions.ct_cln_candidate_id = candidate_positions.ct_cln_candidate_id\nleft join ct_cln_position_names_ml cln_position_names_ml on cln_position_names_ml.ct_cln_position_name_id = cln_positions.name_tid and cln_position_names_ml.ct_language_id = 1\ninner join ct_persons persons on persons.id = cvs.ct_person_id\nleft join ct_persons_names_of_applicants persons_names_of_applicants on persons_names_of_applicants.ct_person_id = persons.id\nleft join ct_persons_surnames_of_applicants persons_surnames_of_applicants on persons_surnames_of_applicants.ct_person_id = persons.id\nleft join ct_persons cv_update_user_persons on cv_update_user_persons.id = cvs.update_uid\nleft join ct_persons_names_of_applicants cv_update_user_persons_names_of_applicants on cv_update_user_persons_names_of_applicants.ct_person_id = cv_update_user_persons.id\nleft join ct_persons_surnames_of_applicants cv_update_user_persons_surnames_of_applicants on cv_update_user_persons_surnames_of_applicants.ct_person_id = cv_update_user_persons.id\nleft join ct_addresses addresses on addresses.id = cvs.ct_address_id\nleft join ct_candidate_step_notices_ml candidate_step_notices_ml on candidate_step_notices_ml.ct_candidate_step_notice_id = candidate_steps.notice_tid and candidate_step_notices_ml.ct_language_id = 1\nleft join ct_position_step_names_ml position_step_names_ml on position_step_names_ml.ct_position_step_name_id = position_steps.name_tid and position_step_names_ml.ct_language_id = 1\nleft join ct_names_of_applicants_ml participate_names_of_applicants_ml on participate_names_of_applicants_ml.ct_person_name_id = participate_persons_names_of_applicants.name_tid and participate_names_of_applicants_ml.ct_language_id = 1\nleft join ct_surnames_of_applicants_ml participate_surnames_of_applicants_ml on participate_surnames_of_applicants_ml.ct_person_surname_id = participate_persons_surnames_of_applicants.surname_tid and participate_surnames_of_applicants_ml.ct_language_id = 1\nleft join ct_names_of_applicants_ml progress_update_user_names_of_applicants_ml on progress_update_user_names_of_applicants_ml.ct_person_name_id = progress_update_user_persons_names_of_applicants.name_tid and progress_update_user_names_of_applicants_ml.ct_language_id = 1\nleft join ct_surnames_of_applicants_ml progress_update_user_surnames_of_applicants_ml on progress_update_user_surnames_of_applicants_ml.ct_person_surname_id = progress_update_user_persons_surnames_of_applicants.surname_tid and progress_update_user_surnames_of_applicants_ml.ct_language_id = 1\nleft join ct_names_of_applicants_ml names_of_applicants_ml on names_of_applicants_ml.ct_person_name_id = persons_names_of_applicants.name_tid and names_of_applicants_ml.ct_language_id = 1\nleft join ct_surnames_of_applicants_ml surnames_of_applicants_ml on surnames_of_applicants_ml.ct_person_surname_id = persons_surnames_of_applicants.surname_tid and surnames_of_applicants_ml.ct_language_id = 1\nleft join ct_names_of_applicants_ml cv_update_user_names_of_applicants_ml on cv_update_user_names_of_applicants_ml.ct_person_name_id = cv_update_user_persons_names_of_applicants.name_tid and cv_update_user_names_of_applicants_ml.ct_language_id = 1\nleft join ct_surnames_of_applicants_ml cv_update_user_surnames_of_applicants_ml on cv_update_user_surnames_of_applicants_ml.ct_person_surname_id = cv_update_user_persons_surnames_of_applicants.surname_tid and cv_update_user_surnames_of_applicants_ml.ct_language_id = 1\n where  ( candidate_positions.ct_cln_position_id = '1801439851270844024' ) and  candidate_positions.ct_global_status_id != '1801439851258840040'\n   and  candidate_steps.ct_cln_event_id is null and  ( candidate_steps.ct_candidate_status_id = '1801439851238935057' )\norder by cln_candidates.id asc, cln_candidates.ct_last_candidate_position_id = candidate_positions.id desc, candidate_positions.is_active desc, candidate_positions.id desc)\n                    select tmp.*\n                    from tmp\n                    order by _order_0 desc, _order_1 asc, _order_2 asc\n                    \n limit 100 offset 0"]},{"file":"/var/www/erp_synergy/core/db.php","line":105,"function":"exec","class":"Callnet\\Db","type":"->","args":["with tmp as (select distinct on (cln_candidates.id) cln_candidates.id as cln_candidates_id,\n\tcvs.update_dt as cvs_update_dt,\n\tcvs.update_uid as cvs_update_uid,\n\tcvs.added_dt as cvs_added_dt,\n\tcvs.update_cv_source_id as cvs_update_cv_source_id,\n\tcvs.ct_person_id as cvs_ct_person_id,\n\tcvs.ct_file_photo_id as cvs_ct_file_photo_id,\n\tcvs.ct_original_cv_id as cvs_ct_original_cv_id,\n\taddresses.ct_country_id as addresses_ct_country_id,\n\taddresses.ct_city_id as addresses_ct_city_id,\n\taddresses.street as addresses_street,\n\taddresses.house_num as addresses_house_num,\n\tpersons.ct_marital_status_id as persons_ct_marital_status_id,\n\tpersons.home_phone as persons_home_phone,\n\tpersons.mob_phone as persons_mob_phone,\n\tpersons.email as persons_email,\n\tpersons.icn as persons_icn,\n\tpersons.gender as persons_gender,\n\tpersons.borndate as persons_borndate,\n\tcandidate_positions.ct_cv_source_id as candidate_positions_ct_cv_source_id,\n\tcandidate_positions.ct_cln_position_id as candidate_positions_ct_cln_position_id,\n\tcln_position_names_ml.value as cln_position_names_ml_value,\n\tnames_of_applicants_ml.value as names_of_applicants_ml_value,\n\tsurnames_of_applicants_ml.value as surnames_of_applicants_ml_value,\n\tcv_update_user_names_of_applicants_ml.value as cv_update_user_names_of_applicants_ml_value,\n\tcv_update_user_surnames_of_applicants_ml.value as cv_update_user_surnames_of_applicants_ml_value,\n\tlast_cp.id as last_cp_id,\n\tlast_cp.ct_cln_position_id as last_cp_ct_cln_position_id,\n\tlast_cp.ct_current_step_id as last_cp_ct_current_step_id,\n\tcandidate_positions.is_active as candidate_positions_is_active,\n\tcandidate_positions.id as candidate_positions_id,\n\tcln_candidates.dt as cln_candidates_dt,\n\tcandidate_positions.progress_update_dt as candidate_positions_progress_update_dt,\n\tcandidate_positions.progress_update_uid as candidate_positions_progress_update_uid,\n\tcln_candidates.ct_cln_org_id as cln_candidates_ct_cln_org_id,\n\tcandidate_positions.reliability as candidate_positions_reliability,\n\tcandidate_steps.ct_position_step_id as candidate_steps_ct_position_step_id,\n\tposition_steps.ct_cln_step_id as position_steps_ct_cln_step_id,\n\tcandidate_positions.ct_current_step_id as candidate_positions_ct_current_step_id,\n\tcvs.ct_cln_cv_status_id as cvs_ct_cln_cv_status_id,\n\tcln_candidates.ct_cv_id as cln_candidates_ct_cv_id,\n\tcandidate_steps.id as candidate_steps_id,\n\tcandidate_positions.ct_global_status_id as candidate_positions_ct_global_status_id,\n\tcandidate_steps.ct_candidate_status_id as candidate_steps_ct_candidate_status_id,\n\tcandidate_positions.participate_update_uid as candidate_positions_participate_update_uid,\n\tcandidate_steps.ct_positive_status_id as candidate_steps_ct_positive_status_id,\n\tcandidate_steps.ct_candidate_status_id as final_candidate_status,\n\tcandidate_steps.ct_cln_reason_id as candidate_steps_ct_cln_reason_id,\n\tdont_recruit_candidate_positions.dont_recruit as dont_recruit_candidate_positions_dont_recruit,\n\tcandidate_steps.reminder_dt as candidate_steps_reminder_dt,\n\tcandidate_steps.online_form_id as candidate_steps_online_form_id,\n\tcandidate_positions.ct_cln_event_id as candidate_positions_ct_cln_event_id,\n\tcandidate_steps.ct_cln_event_id as candidate_steps_ct_cln_event_id,\n\tcandidate_steps.ct_cln_participation_status_id as candidate_steps_ct_cln_participation_status_id,\n\tcandidate_steps.ct_cln_attendance_status_id as candidate_steps_ct_cln_attendance_status_id,\n\tcandidate_positions.general_note as candidate_positions_general_note,\n\tcandidate_step_notices_ml.value as candidate_step_notices_ml_value,\n\tposition_step_names_ml.value as position_step_names_ml_value,\n\t(\n                candidate_positions.is_active and\n                (\n                    ec_position_steps.id is null or\n                    ec_candidate_steps.ct_candidate_status_id = 1801439851246885247\n                )\n            ) as can_waive,\n\tparticipate_names_of_applicants_ml.value as participate_names_of_applicants_ml_value,\n\tparticipate_surnames_of_applicants_ml.value as participate_surnames_of_applicants_ml_value,\n\tprogress_update_user_names_of_applicants_ml.value as progress_update_user_names_of_applicants_ml_value,\n\tprogress_update_user_surnames_of_applicants_ml.value as progress_update_user_surnames_of_applicants_ml_value,\n\tcandidate_positions.reliability as _order_0,\n\tcln_candidates.dt as _order_1,\n\tcln_candidates.id as _order_2\n from ct_candidate_positions candidate_positions\nleft join ct_cln_positions cln_positions on cln_positions.id = candidate_positions.ct_cln_position_id\nleft join ct_persons participate_persons on participate_persons.id = candidate_positions.participate_update_uid\nleft join ct_persons_names_of_applicants participate_persons_names_of_applicants on participate_persons_names_of_applicants.ct_person_id = participate_persons.id\nleft join ct_persons_surnames_of_applicants participate_persons_surnames_of_applicants on participate_persons_surnames_of_applicants.ct_person_id = participate_persons.id\nleft join ct_persons progress_update_user_persons on progress_update_user_persons.id = candidate_positions.progress_update_uid\nleft join ct_persons_names_of_applicants progress_update_user_persons_names_of_applicants on progress_update_user_persons_names_of_applicants.ct_person_id = progress_update_user_persons.id\nleft join ct_persons_surnames_of_applicants progress_update_user_persons_surnames_of_applicants on progress_update_user_persons_surnames_of_applicants.ct_person_id = progress_update_user_persons.id\ninner join ct_cln_candidates cln_candidates on (cln_candidates.id = candidate_positions.ct_cln_candidate_id and candidate_positions.ct_global_status_id not in (1801439851288364296))\ninner join ct_candidate_positions last_cp on last_cp.id = cln_candidates.ct_last_candidate_position_id and last_cp.ct_global_status_id not in (1801439851288364296)\ninner join ct_cvs cvs on cvs.id = cln_candidates.ct_cv_id\ninner join ct_candidate_steps candidate_steps on candidate_steps.ct_candidate_position_id = candidate_positions.id and candidate_steps.ct_position_step_id = 1801439851270844046\nleft join ct_position_steps position_steps on position_steps.id = candidate_steps.ct_position_step_id\nleft join (\n                ct_candidate_positions dont_recruit_candidate_positions\n                inner join ct_candidate_steps dont_recruit_candidate_steps\n                  on dont_recruit_candidate_steps.ct_candidate_position_id = dont_recruit_candidate_positions.id\n                inner join ct_cln_reasons dont_recruit_reasons\n                  on dont_recruit_reasons.id = dont_recruit_candidate_steps.ct_cln_reason_id\n                  and dont_recruit_reasons.dont_recruit\n            ) dont_recruit_candidate_positions on dont_recruit_candidate_positions.ct_cln_candidate_id = candidate_positions.ct_cln_candidate_id\nleft join ct_cln_position_names_ml cln_position_names_ml on cln_position_names_ml.ct_cln_position_name_id = cln_positions.name_tid and cln_position_names_ml.ct_language_id = 1\ninner join ct_persons persons on persons.id = cvs.ct_person_id\nleft join ct_persons_names_of_applicants persons_names_of_applicants on persons_names_of_applicants.ct_person_id = persons.id\nleft join ct_persons_surnames_of_applicants persons_surnames_of_applicants on persons_surnames_of_applicants.ct_person_id = persons.id\nleft join ct_persons cv_update_user_persons on cv_update_user_persons.id = cvs.update_uid\nleft join ct_persons_names_of_applicants cv_update_user_persons_names_of_applicants on cv_update_user_persons_names_of_applicants.ct_person_id = cv_update_user_persons.id\nleft join ct_persons_surnames_of_applicants cv_update_user_persons_surnames_of_applicants on cv_update_user_persons_surnames_of_applicants.ct_person_id = cv_update_user_persons.id\nleft join ct_addresses addresses on addresses.id = cvs.ct_address_id\nleft join ct_candidate_step_notices_ml candidate_step_notices_ml on candidate_step_notices_ml.ct_candidate_step_notice_id = candidate_steps.notice_tid and candidate_step_notices_ml.ct_language_id = 1\nleft join ct_position_step_names_ml position_step_names_ml on position_step_names_ml.ct_position_step_name_id = position_steps.name_tid and position_step_names_ml.ct_language_id = 1\nleft join ct_names_of_applicants_ml participate_names_of_applicants_ml on participate_names_of_applicants_ml.ct_person_name_id = participate_persons_names_of_applicants.name_tid and participate_names_of_applicants_ml.ct_language_id = 1\nleft join ct_surnames_of_applicants_ml participate_surnames_of_applicants_ml on participate_surnames_of_applicants_ml.ct_person_surname_id = participate_persons_surnames_of_applicants.surname_tid and participate_surnames_of_applicants_ml.ct_language_id = 1\nleft join ct_names_of_applicants_ml progress_update_user_names_of_applicants_ml on progress_update_user_names_of_applicants_ml.ct_person_name_id = progress_update_user_persons_names_of_applicants.name_tid and progress_update_user_names_of_applicants_ml.ct_language_id = 1\nleft join ct_surnames_of_applicants_ml progress_update_user_surnames_of_applicants_ml on progress_update_user_surnames_of_applicants_ml.ct_person_surname_id = progress_update_user_persons_surnames_of_applicants.surname_tid and progress_update_user_surnames_of_applicants_ml.ct_language_id = 1\nleft join ct_names_of_applicants_ml names_of_applicants_ml on names_of_applicants_ml.ct_person_name_id = persons_names_of_applicants.name_tid and names_of_applicants_ml.ct_language_id = 1\nleft join ct_surnames_of_applicants_ml surnames_of_applicants_ml on surnames_of_applicants_ml.ct_person_surname_id = persons_surnames_of_applicants.surname_tid and surnames_of_applicants_ml.ct_language_id = 1\nleft join ct_names_of_applicants_ml cv_update_user_names_of_applicants_ml on cv_update_user_names_of_applicants_ml.ct_person_name_id = cv_update_user_persons_names_of_applicants.name_tid and cv_update_user_names_of_applicants_ml.ct_language_id = 1\nleft join ct_surnames_of_applicants_ml cv_update_user_surnames_of_applicants_ml on cv_update_user_surnames_of_applicants_ml.ct_person_surname_id = cv_update_user_persons_surnames_of_applicants.surname_tid and cv_update_user_surnames_of_applicants_ml.ct_language_id = 1\n where  ( candidate_positions.ct_cln_position_id = '1801439851270844024' ) and  candidate_positions.ct_global_status_id != '1801439851258840040'\n   and  candidate_steps.ct_cln_event_id is null and  ( candidate_steps.ct_candidate_status_id = '1801439851238935057' )\norder by cln_candidates.id asc, cln_candidates.ct_last_candidate_position_id = candidate_positions.id desc, candidate_positions.is_active desc, candidate_positions.id desc)\n                    select tmp.*\n                    from tmp\n                    order by _order_0 desc, _order_1 asc, _order_2 asc\n                    \n limit 100 offset 0"]},{"file":"/var/www/callnet/callnet-dev-api.synergetica.net/application/classes/Db.php","line":403,"function":"execute","class":"Database","type":"->","args":["\n                    with tmp as (select distinct on (cln_candidates.id) cln_candidates.id as cln_candidates_id,\n\tcvs.update_dt as cvs_update_dt,\n\tcvs.update_uid as cvs_update_uid,\n\tcvs.added_dt as cvs_added_dt,\n\tcvs.update_cv_source_id as cvs_update_cv_source_id,\n\tcvs.ct_person_id as cvs_ct_person_id,\n\tcvs.ct_file_photo_id as cvs_ct_file_photo_id,\n\tcvs.ct_original_cv_id as cvs_ct_original_cv_id,\n\taddresses.ct_country_id as addresses_ct_country_id,\n\taddresses.ct_city_id as addresses_ct_city_id,\n\taddresses.street as addresses_street,\n\taddresses.house_num as addresses_house_num,\n\tpersons.ct_marital_status_id as persons_ct_marital_status_id,\n\tpersons.home_phone as persons_home_phone,\n\tpersons.mob_phone as persons_mob_phone,\n\tpersons.email as persons_email,\n\tpersons.icn as persons_icn,\n\tpersons.gender as persons_gender,\n\tpersons.borndate as persons_borndate,\n\tcandidate_positions.ct_cv_source_id as candidate_positions_ct_cv_source_id,\n\tcandidate_positions.ct_cln_position_id as candidate_positions_ct_cln_position_id,\n\tcln_position_names_ml.value as cln_position_names_ml_value,\n\tnames_of_applicants_ml.value as names_of_applicants_ml_value,\n\tsurnames_of_applicants_ml.value as surnames_of_applicants_ml_value,\n\tcv_update_user_names_of_applicants_ml.value as cv_update_user_names_of_applicants_ml_value,\n\tcv_update_user_surnames_of_applicants_ml.value as cv_update_user_surnames_of_applicants_ml_value,\n\tlast_cp.id as last_cp_id,\n\tlast_cp.ct_cln_position_id as last_cp_ct_cln_position_id,\n\tlast_cp.ct_current_step_id as last_cp_ct_current_step_id,\n\tcandidate_positions.is_active as candidate_positions_is_active,\n\tcandidate_positions.id as candidate_positions_id,\n\tcln_candidates.dt as cln_candidates_dt,\n\tcandidate_positions.progress_update_dt as candidate_positions_progress_update_dt,\n\tcandidate_positions.progress_update_uid as candidate_positions_progress_update_uid,\n\tcln_candidates.ct_cln_org_id as cln_candidates_ct_cln_org_id,\n\tcandidate_positions.reliability as candidate_positions_reliability,\n\tcandidate_steps.ct_position_step_id as candidate_steps_ct_position_step_id,\n\tposition_steps.ct_cln_step_id as position_steps_ct_cln_step_id,\n\tcandidate_positions.ct_current_step_id as candidate_positions_ct_current_step_id,\n\tcvs.ct_cln_cv_status_id as cvs_ct_cln_cv_status_id,\n\tcln_candidates.ct_cv_id as cln_candidates_ct_cv_id,\n\tcandidate_steps.id as candidate_steps_id,\n\tcandidate_positions.ct_global_status_id as candidate_positions_ct_global_status_id,\n\tcandidate_steps.ct_candidate_status_id as candidate_steps_ct_candidate_status_id,\n\tcandidate_positions.participate_update_uid as candidate_positions_participate_update_uid,\n\tcandidate_steps.ct_positive_status_id as candidate_steps_ct_positive_status_id,\n\tcandidate_steps.ct_candidate_status_id as final_candidate_status,\n\tcandidate_steps.ct_cln_reason_id as candidate_steps_ct_cln_reason_id,\n\tdont_recruit_candidate_positions.dont_recruit as dont_recruit_candidate_positions_dont_recruit,\n\tcandidate_steps.reminder_dt as candidate_steps_reminder_dt,\n\tcandidate_steps.online_form_id as candidate_steps_online_form_id,\n\tcandidate_positions.ct_cln_event_id as candidate_positions_ct_cln_event_id,\n\tcandidate_steps.ct_cln_event_id as candidate_steps_ct_cln_event_id,\n\tcandidate_steps.ct_cln_participation_status_id as candidate_steps_ct_cln_participation_status_id,\n\tcandidate_steps.ct_cln_attendance_status_id as candidate_steps_ct_cln_attendance_status_id,\n\tcandidate_positions.general_note as candidate_positions_general_note,\n\tcandidate_step_notices_ml.value as candidate_step_notices_ml_value,\n\tposition_step_names_ml.value as position_step_names_ml_value,\n\t(\n                candidate_positions.is_active and\n                (\n                    ec_position_steps.id is null or\n                    ec_candidate_steps.ct_candidate_status_id = 1801439851246885247\n                )\n            ) as can_waive,\n\tparticipate_names_of_applicants_ml.value as participate_names_of_applicants_ml_value,\n\tparticipate_surnames_of_applicants_ml.value as participate_surnames_of_applicants_ml_value,\n\tprogress_update_user_names_of_applicants_ml.value as progress_update_user_names_of_applicants_ml_value,\n\tprogress_update_user_surnames_of_applicants_ml.value as progress_update_user_surnames_of_applicants_ml_value,\n\tcandidate_positions.reliability as _order_0,\n\tcln_candidates.dt as _order_1,\n\tcln_candidates.id as _order_2\n from ct_candidate_positions candidate_positions\nleft join ct_cln_positions cln_positions on cln_positions.id = candidate_positions.ct_cln_position_id\nleft join ct_persons participate_persons on participate_persons.id = candidate_positions.participate_update_uid\nleft join ct_persons_names_of_applicants participate_persons_names_of_applicants on participate_persons_names_of_applicants.ct_person_id = participate_persons.id\nleft join ct_persons_surnames_of_applicants participate_persons_surnames_of_applicants on participate_persons_surnames_of_applicants.ct_person_id = participate_persons.id\nleft join ct_persons progress_update_user_persons on progress_update_user_persons.id = candidate_positions.progress_update_uid\nleft join ct_persons_names_of_applicants progress_update_user_persons_names_of_applicants on progress_update_user_persons_names_of_applicants.ct_person_id = progress_update_user_persons.id\nleft join ct_persons_surnames_of_applicants progress_update_user_persons_surnames_of_applicants on progress_update_user_persons_surnames_of_applicants.ct_person_id = progress_update_user_persons.id\ninner join ct_cln_candidates cln_candidates on (cln_candidates.id = candidate_positions.ct_cln_candidate_id and candidate_positions.ct_global_status_id not in (1801439851288364296))\ninner join ct_candidate_positions last_cp on last_cp.id = cln_candidates.ct_last_candidate_position_id and last_cp.ct_global_status_id not in (1801439851288364296)\ninner join ct_cvs cvs on cvs.id = cln_candidates.ct_cv_id\ninner join ct_candidate_steps candidate_steps on candidate_steps.ct_candidate_position_id = candidate_positions.id and candidate_steps.ct_position_step_id = 1801439851270844046\nleft join ct_position_steps position_steps on position_steps.id = candidate_steps.ct_position_step_id\nleft join (\n                ct_candidate_positions dont_recruit_candidate_positions\n                inner join ct_candidate_steps dont_recruit_candidate_steps\n                  on dont_recruit_candidate_steps.ct_candidate_position_id = dont_recruit_candidate_positions.id\n                inner join ct_cln_reasons dont_recruit_reasons\n                  on dont_recruit_reasons.id = dont_recruit_candidate_steps.ct_cln_reason_id\n                  and dont_recruit_reasons.dont_recruit\n            ) dont_recruit_candidate_positions on dont_recruit_candidate_positions.ct_cln_candidate_id = candidate_positions.ct_cln_candidate_id\nleft join ct_cln_position_names_ml cln_position_names_ml on cln_position_names_ml.ct_cln_position_name_id = cln_positions.name_tid and cln_position_names_ml.ct_language_id = 1\ninner join ct_persons persons on persons.id = cvs.ct_person_id\nleft join ct_persons_names_of_applicants persons_names_of_applicants on persons_names_of_applicants.ct_person_id = persons.id\nleft join ct_persons_surnames_of_applicants persons_surnames_of_applicants on persons_surnames_of_applicants.ct_person_id = persons.id\nleft join ct_persons cv_update_user_persons on cv_update_user_persons.id = cvs.update_uid\nleft join ct_persons_names_of_applicants cv_update_user_persons_names_of_applicants on cv_update_user_persons_names_of_applicants.ct_person_id = cv_update_user_persons.id\nleft join ct_persons_surnames_of_applicants cv_update_user_persons_surnames_of_applicants on cv_update_user_persons_surnames_of_applicants.ct_person_id = cv_update_user_persons.id\nleft join ct_addresses addresses on addresses.id = cvs.ct_address_id\nleft join ct_candidate_step_notices_ml candidate_step_notices_ml on candidate_step_notices_ml.ct_candidate_step_notice_id = candidate_steps.notice_tid and candidate_step_notices_ml.ct_language_id = 1\nleft join ct_position_step_names_ml position_step_names_ml on position_step_names_ml.ct_position_step_name_id = position_steps.name_tid and position_step_names_ml.ct_language_id = 1\nleft join ct_names_of_applicants_ml participate_names_of_applicants_ml on participate_names_of_applicants_ml.ct_person_name_id = participate_persons_names_of_applicants.name_tid and participate_names_of_applicants_ml.ct_language_id = 1\nleft join ct_surnames_of_applicants_ml participate_surnames_of_applicants_ml on participate_surnames_of_applicants_ml.ct_person_surname_id = participate_persons_surnames_of_applicants.surname_tid and participate_surnames_of_applicants_ml.ct_language_id = 1\nleft join ct_names_of_applicants_ml progress_update_user_names_of_applicants_ml on progress_update_user_names_of_applicants_ml.ct_person_name_id = progress_update_user_persons_names_of_applicants.name_tid and progress_update_user_names_of_applicants_ml.ct_language_id = 1\nleft join ct_surnames_of_applicants_ml progress_update_user_surnames_of_applicants_ml on progress_update_user_surnames_of_applicants_ml.ct_person_surname_id = progress_update_user_persons_surnames_of_applicants.surname_tid and progress_update_user_surnames_of_applicants_ml.ct_language_id = 1\nleft join ct_names_of_applicants_ml names_of_applicants_ml on names_of_applicants_ml.ct_person_name_id = persons_names_of_applicants.name_tid and names_of_applicants_ml.ct_language_id = 1\nleft join ct_surnames_of_applicants_ml surnames_of_applicants_ml on surnames_of_applicants_ml.ct_person_surname_id = persons_surnames_of_applicants.surname_tid and surnames_of_applicants_ml.ct_language_id = 1\nleft join ct_names_of_applicants_ml cv_update_user_names_of_applicants_ml on cv_update_user_names_of_applicants_ml.ct_person_name_id = cv_update_user_persons_names_of_applicants.name_tid and cv_update_user_names_of_applicants_ml.ct_language_id = 1\nleft join ct_surnames_of_applicants_ml cv_update_user_surnames_of_applicants_ml on cv_update_user_surnames_of_applicants_ml.ct_person_surname_id = cv_update_user_persons_surnames_of_applicants.surname_tid and cv_update_user_surnames_of_applicants_ml.ct_language_id = 1\n where  ( candidate_positions.ct_cln_position_id = '1801439851270844024' ) and  candidate_positions.ct_global_status_id != '1801439851258840040'\n   and  candidate_steps.ct_cln_event_id is null and  ( candidate_steps.ct_candidate_status_id = '1801439851238935057' )\norder by cln_candidates.id asc, cln_candidates.ct_last_candidate_position_id = candidate_positions.id desc, candidate_positions.is_active desc, candidate_positions.id desc)\n                    select tmp.*\n                    from tmp\n                    order by _order_0 desc, _order_1 asc, _order_2 asc\n                    \n limit 100 offset 0\n                "]},{"file":"/var/www/callnet/callnet-dev-api.synergetica.net/application/classes/Concept/DbBase.php","line":1009,"function":"getAllRows","class":"Callnet\\Db","type":"::","args":["\n                    with tmp as (select distinct on (cln_candidates.id) cln_candidates.id as cln_candidates_id,\n\tcvs.update_dt as cvs_update_dt,\n\tcvs.update_uid as cvs_update_uid,\n\tcvs.added_dt as cvs_added_dt,\n\tcvs.update_cv_source_id as cvs_update_cv_source_id,\n\tcvs.ct_person_id as cvs_ct_person_id,\n\tcvs.ct_file_photo_id as cvs_ct_file_photo_id,\n\tcvs.ct_original_cv_id as cvs_ct_original_cv_id,\n\taddresses.ct_country_id as addresses_ct_country_id,\n\taddresses.ct_city_id as addresses_ct_city_id,\n\taddresses.street as addresses_street,\n\taddresses.house_num as addresses_house_num,\n\tpersons.ct_marital_status_id as persons_ct_marital_status_id,\n\tpersons.home_phone as persons_home_phone,\n\tpersons.mob_phone as persons_mob_phone,\n\tpersons.email as persons_email,\n\tpersons.icn as persons_icn,\n\tpersons.gender as persons_gender,\n\tpersons.borndate as persons_borndate,\n\tcandidate_positions.ct_cv_source_id as candidate_positions_ct_cv_source_id,\n\tcandidate_positions.ct_cln_position_id as candidate_positions_ct_cln_position_id,\n\tcln_position_names_ml.value as cln_position_names_ml_value,\n\tnames_of_applicants_ml.value as names_of_applicants_ml_value,\n\tsurnames_of_applicants_ml.value as surnames_of_applicants_ml_value,\n\tcv_update_user_names_of_applicants_ml.value as cv_update_user_names_of_applicants_ml_value,\n\tcv_update_user_surnames_of_applicants_ml.value as cv_update_user_surnames_of_applicants_ml_value,\n\tlast_cp.id as last_cp_id,\n\tlast_cp.ct_cln_position_id as last_cp_ct_cln_position_id,\n\tlast_cp.ct_current_step_id as last_cp_ct_current_step_id,\n\tcandidate_positions.is_active as candidate_positions_is_active,\n\tcandidate_positions.id as candidate_positions_id,\n\tcln_candidates.dt as cln_candidates_dt,\n\tcandidate_positions.progress_update_dt as candidate_positions_progress_update_dt,\n\tcandidate_positions.progress_update_uid as candidate_positions_progress_update_uid,\n\tcln_candidates.ct_cln_org_id as cln_candidates_ct_cln_org_id,\n\tcandidate_positions.reliability as candidate_positions_reliability,\n\tcandidate_steps.ct_position_step_id as candidate_steps_ct_position_step_id,\n\tposition_steps.ct_cln_step_id as position_steps_ct_cln_step_id,\n\tcandidate_positions.ct_current_step_id as candidate_positions_ct_current_step_id,\n\tcvs.ct_cln_cv_status_id as cvs_ct_cln_cv_status_id,\n\tcln_candidates.ct_cv_id as cln_candidates_ct_cv_id,\n\tcandidate_steps.id as candidate_steps_id,\n\tcandidate_positions.ct_global_status_id as candidate_positions_ct_global_status_id,\n\tcandidate_steps.ct_candidate_status_id as candidate_steps_ct_candidate_status_id,\n\tcandidate_positions.participate_update_uid as candidate_positions_participate_update_uid,\n\tcandidate_steps.ct_positive_status_id as candidate_steps_ct_positive_status_id,\n\tcandidate_steps.ct_candidate_status_id as final_candidate_status,\n\tcandidate_steps.ct_cln_reason_id as candidate_steps_ct_cln_reason_id,\n\tdont_recruit_candidate_positions.dont_recruit as dont_recruit_candidate_positions_dont_recruit,\n\tcandidate_steps.reminder_dt as candidate_steps_reminder_dt,\n\tcandidate_steps.online_form_id as candidate_steps_online_form_id,\n\tcandidate_positions.ct_cln_event_id as candidate_positions_ct_cln_event_id,\n\tcandidate_steps.ct_cln_event_id as candidate_steps_ct_cln_event_id,\n\tcandidate_steps.ct_cln_participation_status_id as candidate_steps_ct_cln_participation_status_id,\n\tcandidate_steps.ct_cln_attendance_status_id as candidate_steps_ct_cln_attendance_status_id,\n\tcandidate_positions.general_note as candidate_positions_general_note,\n\tcandidate_step_notices_ml.value as candidate_step_notices_ml_value,\n\tposition_step_names_ml.value as position_step_names_ml_value,\n\t(\n                candidate_positions.is_active and\n                (\n                    ec_position_steps.id is null or\n                    ec_candidate_steps.ct_candidate_status_id = 1801439851246885247\n                )\n            ) as can_waive,\n\tparticipate_names_of_applicants_ml.value as participate_names_of_applicants_ml_value,\n\tparticipate_surnames_of_applicants_ml.value as participate_surnames_of_applicants_ml_value,\n\tprogress_update_user_names_of_applicants_ml.value as progress_update_user_names_of_applicants_ml_value,\n\tprogress_update_user_surnames_of_applicants_ml.value as progress_update_user_surnames_of_applicants_ml_value,\n\tcandidate_positions.reliability as _order_0,\n\tcln_candidates.dt as _order_1,\n\tcln_candidates.id as _order_2\n from ct_candidate_positions candidate_positions\nleft join ct_cln_positions cln_positions on cln_positions.id = candidate_positions.ct_cln_position_id\nleft join ct_persons participate_persons on participate_persons.id = candidate_positions.participate_update_uid\nleft join ct_persons_names_of_applicants participate_persons_names_of_applicants on participate_persons_names_of_applicants.ct_person_id = participate_persons.id\nleft join ct_persons_surnames_of_applicants participate_persons_surnames_of_applicants on participate_persons_surnames_of_applicants.ct_person_id = participate_persons.id\nleft join ct_persons progress_update_user_persons on progress_update_user_persons.id = candidate_positions.progress_update_uid\nleft join ct_persons_names_of_applicants progress_update_user_persons_names_of_applicants on progress_update_user_persons_names_of_applicants.ct_person_id = progress_update_user_persons.id\nleft join ct_persons_surnames_of_applicants progress_update_user_persons_surnames_of_applicants on progress_update_user_persons_surnames_of_applicants.ct_person_id = progress_update_user_persons.id\ninner join ct_cln_candidates cln_candidates on (cln_candidates.id = candidate_positions.ct_cln_candidate_id and candidate_positions.ct_global_status_id not in (1801439851288364296))\ninner join ct_candidate_positions last_cp on last_cp.id = cln_candidates.ct_last_candidate_position_id and last_cp.ct_global_status_id not in (1801439851288364296)\ninner join ct_cvs cvs on cvs.id = cln_candidates.ct_cv_id\ninner join ct_candidate_steps candidate_steps on candidate_steps.ct_candidate_position_id = candidate_positions.id and candidate_steps.ct_position_step_id = 1801439851270844046\nleft join ct_position_steps position_steps on position_steps.id = candidate_steps.ct_position_step_id\nleft join (\n                ct_candidate_positions dont_recruit_candidate_positions\n                inner join ct_candidate_steps dont_recruit_candidate_steps\n                  on dont_recruit_candidate_steps.ct_candidate_position_id = dont_recruit_candidate_positions.id\n                inner join ct_cln_reasons dont_recruit_reasons\n                  on dont_recruit_reasons.id = dont_recruit_candidate_steps.ct_cln_reason_id\n                  and dont_recruit_reasons.dont_recruit\n            ) dont_recruit_candidate_positions on dont_recruit_candidate_positions.ct_cln_candidate_id = candidate_positions.ct_cln_candidate_id\nleft join ct_cln_position_names_ml cln_position_names_ml on cln_position_names_ml.ct_cln_position_name_id = cln_positions.name_tid and cln_position_names_ml.ct_language_id = 1\ninner join ct_persons persons on persons.id = cvs.ct_person_id\nleft join ct_persons_names_of_applicants persons_names_of_applicants on persons_names_of_applicants.ct_person_id = persons.id\nleft join ct_persons_surnames_of_applicants persons_surnames_of_applicants on persons_surnames_of_applicants.ct_person_id = persons.id\nleft join ct_persons cv_update_user_persons on cv_update_user_persons.id = cvs.update_uid\nleft join ct_persons_names_of_applicants cv_update_user_persons_names_of_applicants on cv_update_user_persons_names_of_applicants.ct_person_id = cv_update_user_persons.id\nleft join ct_persons_surnames_of_applicants cv_update_user_persons_surnames_of_applicants on cv_update_user_persons_surnames_of_applicants.ct_person_id = cv_update_user_persons.id\nleft join ct_addresses addresses on addresses.id = cvs.ct_address_id\nleft join ct_candidate_step_notices_ml candidate_step_notices_ml on candidate_step_notices_ml.ct_candidate_step_notice_id = candidate_steps.notice_tid and candidate_step_notices_ml.ct_language_id = 1\nleft join ct_position_step_names_ml position_step_names_ml on position_step_names_ml.ct_position_step_name_id = position_steps.name_tid and position_step_names_ml.ct_language_id = 1\nleft join ct_names_of_applicants_ml participate_names_of_applicants_ml on participate_names_of_applicants_ml.ct_person_name_id = participate_persons_names_of_applicants.name_tid and participate_names_of_applicants_ml.ct_language_id = 1\nleft join ct_surnames_of_applicants_ml participate_surnames_of_applicants_ml on participate_surnames_of_applicants_ml.ct_person_surname_id = participate_persons_surnames_of_applicants.surname_tid and participate_surnames_of_applicants_ml.ct_language_id = 1\nleft join ct_names_of_applicants_ml progress_update_user_names_of_applicants_ml on progress_update_user_names_of_applicants_ml.ct_person_name_id = progress_update_user_persons_names_of_applicants.name_tid and progress_update_user_names_of_applicants_ml.ct_language_id = 1\nleft join ct_surnames_of_applicants_ml progress_update_user_surnames_of_applicants_ml on progress_update_user_surnames_of_applicants_ml.ct_person_surname_id = progress_update_user_persons_surnames_of_applicants.surname_tid and progress_update_user_surnames_of_applicants_ml.ct_language_id = 1\nleft join ct_names_of_applicants_ml names_of_applicants_ml on names_of_applicants_ml.ct_person_name_id = persons_names_of_applicants.name_tid and names_of_applicants_ml.ct_language_id = 1\nleft join ct_surnames_of_applicants_ml surnames_of_applicants_ml on surnames_of_applicants_ml.ct_person_surname_id = persons_surnames_of_applicants.surname_tid and surnames_of_applicants_ml.ct_language_id = 1\nleft join ct_names_of_applicants_ml cv_update_user_names_of_applicants_ml on cv_update_user_names_of_applicants_ml.ct_person_name_id = cv_update_user_persons_names_of_applicants.name_tid and cv_update_user_names_of_applicants_ml.ct_language_id = 1\nleft join ct_surnames_of_applicants_ml cv_update_user_surnames_of_applicants_ml on cv_update_user_surnames_of_applicants_ml.ct_person_surname_id = cv_update_user_persons_surnames_of_applicants.surname_tid and cv_update_user_surnames_of_applicants_ml.ct_language_id = 1\n where  ( candidate_positions.ct_cln_position_id = '1801439851270844024' ) and  candidate_positions.ct_global_status_id != '1801439851258840040'\n   and  candidate_steps.ct_cln_event_id is null and  ( candidate_steps.ct_candidate_status_id = '1801439851238935057' )\norder by cln_candidates.id asc, cln_candidates.ct_last_candidate_position_id = candidate_positions.id desc, candidate_positions.is_active desc, candidate_positions.id desc)\n                    select tmp.*\n                    from tmp\n                    order by _order_0 desc, _order_1 asc, _order_2 asc\n                    \n limit 100 offset 0\n                "]},{"file":"/var/www/callnet/callnet-dev-api.synergetica.net/application/classes/Concept/Base.php","line":432,"function":"fetchRawData","class":"Callnet\\Concept\\DbBase","type":"->","args":[100,1,1,"19"]},{"function":"Callnet\\Concept\\{closure}","class":"Callnet\\Concept\\Base","type":"->","args":[]},{"file":"/var/www/callnet/callnet-dev-api.synergetica.net/application/classes/Concept/Base.php","line":448,"function":"call_user_func","args":[{}]},{"file":"/var/www/callnet/callnet-dev-api.synergetica.net/application/classes/Concept/Base.php","line":482,"function":"getDataFromMc","class":"Callnet\\Concept\\Base","type":"->","args":["fetchRawData","getData",100,1,null,null]},{"file":"/var/www/callnet/callnet-dev-api.synergetica.net/application/classes/Concept/DbBase.php","line":1075,"function":"getData","class":"Callnet\\Concept\\Base","type":"->","args":[100,1,null,null]},{"file":"/var/www/callnet/callnet-dev-api.synergetica.net/application/classes/Concept/Base.php","line":432,"function":"getData","class":"Callnet\\Concept\\DbBase","type":"->","args":[100,1,null,null]},{"function":"Callnet\\Concept\\{closure}","class":"Callnet\\Concept\\Base","type":"->","args":[]},{"file":"/var/www/callnet/callnet-dev-api.synergetica.net/application/classes/Concept/Base.php","line":448,"function":"call_user_func","args":[{}]},{"file":"/var/www/callnet/callnet-dev-api.synergetica.net/application/classes/Concept/Base.php","line":492,"function":"getDataFromMc","class":"Callnet\\Concept\\Base","type":"->","args":["getData","getMergeData",100,1,null,null]},{"file":"/var/www/callnet/callnet-dev-api.synergetica.net/application/classes/Concept/Base.php","line":523,"function":"getConceptData","class":"Callnet\\Concept\\Base","type":"->","args":[100,1,null,null]},{"file":"/var/www/callnet/callnet-dev-api.synergetica.net/application/controllers/CandidateController.php","line":595,"function":"getConcept","class":"Callnet\\Concept\\Base","type":"->","args":[100,1,null,null]},{"function":"positionCandidatesAction","class":"Callnet\\CandidateController","type":"->","args":[]},{"file":"/var/www/erp_synergy/core/BaseController.php","line":87,"function":"call_user_func","args":[[{},"positionCandidatesAction"]]},{"file":"/var/www/callnet/callnet-dev-api.synergetica.net/application/controllers/BaseController.php","line":96,"function":"invokeAction","class":"ERP_Core_BaseController","type":"->","args":["position_candidates"]},{"function":"Callnet\\{closure}","class":"Callnet\\BaseController","type":"->","args":[]},{"file":"/var/www/callnet/callnet-dev-api.synergetica.net/application/classes/Db.php","line":812,"function":"call_user_func","args":[{}]},{"file":"/var/www/callnet/callnet-dev-api.synergetica.net/application/controllers/BaseController.php","line":101,"function":"performRequestAction","class":"Callnet\\Db","type":"::","args":[{},"/api/candidate/position_candidates","POST",{"org_id":"1801439851242492101","position_id":"1801439851270844024","step_id":"1801439851270844046","ec_event_id":null,"filter_by_courses":null,"course_id":null,"status_id":"1801439851238935057","order_field":"rank","asc":null,"page":1}]},{"file":"/var/www/erp_synergy/core/Application.php","line":167,"function":"invokeAction","class":"Callnet\\BaseController","type":"->","args":["position_candidates"]},{"file":"/var/www/erp_synergy/core/Application.php","line":59,"function":"processURI","class":"ERP_Core_Application","type":"->","args":[]},{"file":"/var/www/callnet/callnet-dev-api.synergetica.net/api.php","line":5,"function":"run","class":"ERP_Core_Application","type":"->","args":[]}],"code":"42P01"}]},"httpCode":500}}}