Ошибка SQL: Unknown column 'root.folder_ref_parent' in 'SELECT'
SQL: [SELECT /* 587,502626 */ folder_uid_id, folder_cnt_account, folder_hld_holder, folder_chr_link, folder_ref_parent, folder_chr_name, folder_txt_text, folder_int_count, # Данные о родителях IF(root.folder_ref_parent = 0, root.folder_uid_id, root.folder_ref_parent) AS folder_uid_parent, COALESCE(root.folder_chr_name, root.folder_chr_name, root.folder_chr_name) AS folder_chr_parentname, folder_img_160x120image, # https://support.plarson.ru/issues/23874 ( WITH RECURSIVE folder_tree AS ( SELECT root.folder_uid_id AS root_id, root.folder_uid_id AS id, root.folder_ref_parent AS parent_id, 1 AS level FROM account_folder root WHERE root.folder_cnt_account = 587 AND root.folder_hld_holder = 19616 AND root.folder_mbr_member = 0 AND root.folder_enm_spec = 'NO' # Скрыть в меню UNION ALL SELECT folder_tree.root_id, child.folder_uid_id AS id, child.folder_ref_parent AS parent_id, folder_tree.level + 1 AS level FROM account_folder child JOIN folder_tree ON folder_tree.id = child.folder_ref_parent WHERE child.folder_cnt_account = 587 AND child.folder_hld_holder = 19616 AND child.folder_mbr_member = 0 AND child.folder_enm_spec = 'NO' # Скрыть в меню ) SELECT GROUP_CONCAT(DISTINCT id ORDER BY id) FROM folder_tree WHERE root_id = a.folder_uid_id ) AS folders_ids, # Вычисляем ID всех прилинкованных товаров внутри папки и подпапок # https://support.plarson.ru/issues/23874 ( WITH RECURSIVE folder_tree AS ( SELECT root.folder_uid_id AS root_id, root.folder_uid_id AS id, root.folder_ref_parent AS parent_id, 1 AS level FROM account_folder root WHERE root.folder_cnt_account = 587 AND root.folder_hld_holder = 19616 AND root.folder_mbr_member = 0 AND root.folder_enm_spec = 'NO' # Скрыть в меню UNION ALL SELECT folder_tree.root_id, child.folder_uid_id AS id, child.folder_ref_parent AS parent_id, folder_tree.level + 1 AS level FROM account_folder child JOIN folder_tree ON folder_tree.id = child.folder_ref_parent WHERE child.folder_cnt_account = 587 AND child.folder_hld_holder = 19616 AND child.folder_mbr_member = 0 AND child.folder_enm_spec = 'NO' # Скрыть в меню ) SELECT GROUP_CONCAT(join_this ORDER BY join_this) FROM folder_tree INNER JOIN reestr_join ON join_that = id AND join_account = 587 AND join_this_holder = 19616 AND join_this_table = 'account_product' AND join_holder = 19616 AND join_that_table = 'account_folder' WHERE root_id = a.folder_uid_id ) AS products_ids, folder_ind_index, folder_chr_title, folder_txt_descr, folder_txt_keywords FROM account_folder a WHERE folder_cnt_account = 587 AND folder_hld_holder = 19616 AND folder_mbr_member=0 AND folder_chr_link LIKE ? ORDER BY folder_ind_index , folder_uid_id LIMIT 1 /* module_id:502626 URN */]
SQL: [SELECT /* 587,502626 */ folder_uid_id, folder_cnt_account, folder_hld_holder, folder_chr_link, folder_ref_parent, folder_chr_name, folder_txt_text, folder_int_count, # Данные о родителях IF(root.folder_ref_parent = 0, root.folder_uid_id, root.folder_ref_parent) AS folder_uid_parent, COALESCE(root.folder_chr_name, root.folder_chr_name, root.folder_chr_name) AS folder_chr_parentname, folder_img_160x120image, # https://support.plarson.ru/issues/23874 ( WITH RECURSIVE folder_tree AS ( SELECT root.folder_uid_id AS root_id, root.folder_uid_id AS id, root.folder_ref_parent AS parent_id, 1 AS level FROM account_folder root WHERE root.folder_cnt_account = 587 AND root.folder_hld_holder = 19616 AND root.folder_mbr_member = 0 AND root.folder_enm_spec = 'NO' # Скрыть в меню UNION ALL SELECT folder_tree.root_id, child.folder_uid_id AS id, child.folder_ref_parent AS parent_id, folder_tree.level + 1 AS level FROM account_folder child JOIN folder_tree ON folder_tree.id = child.folder_ref_parent WHERE child.folder_cnt_account = 587 AND child.folder_hld_holder = 19616 AND child.folder_mbr_member = 0 AND child.folder_enm_spec = 'NO' # Скрыть в меню ) SELECT GROUP_CONCAT(DISTINCT id ORDER BY id) FROM folder_tree WHERE root_id = a.folder_uid_id ) AS folders_ids, # Вычисляем ID всех прилинкованных товаров внутри папки и подпапок # https://support.plarson.ru/issues/23874 ( WITH RECURSIVE folder_tree AS ( SELECT root.folder_uid_id AS root_id, root.folder_uid_id AS id, root.folder_ref_parent AS parent_id, 1 AS level FROM account_folder root WHERE root.folder_cnt_account = 587 AND root.folder_hld_holder = 19616 AND root.folder_mbr_member = 0 AND root.folder_enm_spec = 'NO' # Скрыть в меню UNION ALL SELECT folder_tree.root_id, child.folder_uid_id AS id, child.folder_ref_parent AS parent_id, folder_tree.level + 1 AS level FROM account_folder child JOIN folder_tree ON folder_tree.id = child.folder_ref_parent WHERE child.folder_cnt_account = 587 AND child.folder_hld_holder = 19616 AND child.folder_mbr_member = 0 AND child.folder_enm_spec = 'NO' # Скрыть в меню ) SELECT GROUP_CONCAT(join_this ORDER BY join_this) FROM folder_tree INNER JOIN reestr_join ON join_that = id AND join_account = 587 AND join_this_holder = 19616 AND join_this_table = 'account_product' AND join_holder = 19616 AND join_that_table = 'account_folder' WHERE root_id = a.folder_uid_id ) AS products_ids, folder_ind_index, folder_chr_title, folder_txt_descr, folder_txt_keywords FROM account_folder a WHERE folder_cnt_account = 587 AND folder_hld_holder = 19616 AND folder_mbr_member=0 AND folder_chr_link LIKE ? ORDER BY folder_ind_index , folder_uid_id LIMIT 1 /* module_id:502626 URN */]