Ошибка SQL: Column 'folder_ind_index' in SELECT is ambiguous
SQL: [SELECT /* 587,502626 */ a.folder_uid_id, a.folder_cnt_account, a.folder_hld_holder, a.folder_chr_link, a.folder_ref_parent, a.folder_chr_name, a.folder_txt_text, a.folder_int_count, # Данные о родителях IF(a.folder_ref_parent = 0, a.folder_uid_id, a.folder_ref_parent) AS folder_uid_parent, COALESCE(parent.folder_chr_name, parent.folder_chr_name, a.folder_chr_name) AS folder_chr_parentname, a.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 LEFT JOIN account_folder parent ON parent.folder_uid_id = a.folder_ref_parent WHERE a.folder_cnt_account = 587 AND a.folder_hld_holder = 19616 AND a.folder_mbr_member=0 AND a.folder_chr_link LIKE ? ORDER BY folder_ind_index , folder_uid_id LIMIT 1 /* module_id:502626 URN */]
Пользуясь сайтом, вы соглашаетесь с использованием cookies и политикой конфиденциальности.