Туматову Руслану за содействие на всех этапах разработки и внимательность к деталям!
Expression #1 of ORDER BY clause is not in SELECT list, references column 'updinsy_db.h.ord' which is not in SELECT list; this is incompatible with DISTINCT in query: SELECT DISTINCT SQL_CALC_FOUND_ROWS h.id as id, h.rel as pid
FROM cms3_hierarchy h, cms3_permissions p, cms3_hierarchy_relations hr, cms3_objects o
WHERE h.lang_id = '1' AND h.is_deleted = '0' AND h.is_active = '1' AND (p.rel_id = h.id AND p.level & 1 AND p.owner_id IN(265)) AND h.id = hr.child_id AND (hr.level <= 3 AND hr.rel_id = '1001') AND h.obj_id = o.id
ORDER BY h.ord ASCExpression #1 of ORDER BY clause is not in SELECT list, references column 'updinsy_db.h.ord' which is not in SELECT list; this is incompatible with DISTINCT in query: SELECT DISTINCT SQL_CALC_FOUND_ROWS h.id as id, h.rel as pid
FROM cms3_hierarchy h, cms3_permissions p, cms3_hierarchy_relations hr, cms3_objects o
WHERE h.lang_id = '1' AND h.is_deleted = '0' AND h.is_active = '1' AND (p.rel_id = h.id AND p.level & 1 AND p.owner_id IN(265)) AND h.id = hr.child_id AND (hr.level <= 3 AND hr.rel_id = '1001') AND h.obj_id = o.id
ORDER BY h.ord ASC
Двухсторонняя 1с-интеграция выгружено более 6500 товаров
Работа в архиве
