очередная ошибка после последнего обновления.
Есть usel следующего содержания:
<?xml version="1.0" encoding="utf-8"?>
<selection>
<target result="pages count">
<type module="catalog" method="object" />
<category depth="1">{1}</category>
</target>
<property name="price">
<min-value>{price_min}</min-value>
<max-value>{price_max}</max-value>
</property>
<sort order="{order_mode}">{order_field}</sort>
<limit page="{page}">{limit}</limit>
</selection>
При вызове
u sel://catalog-goodslist-filter /80/?limit=10&page=0&o rder_mode=ascending&order_ field=price&price_min=1230 0&price_max=12400
кидает исключение:
Not unique table/alias: 'oc_8918' in query: SELECT SQL_CACHE SQL_CALC_FOUND_ROWS h.id FROM cms3_hierarchy h, cms3_object_content oc_8918, cms3_hierarchy_relations hr, cms3_objects o LEFT JOIN cms3_object_content oc_8918 ON oc_8918.obj_id=o.id AND oc_8918.field_id = '8918' WHERE o.type_id IN (11, 912, 913, 914, 915, 916, 917, 918, 919, 920, 921, 922, 923, 924, 925, 926, 927, 928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 938, 939, 940, 941, 942, 943, 944, 945, 946, 947, 948, 949, 950, 951, 952, 953, 954, 955, 956, 957, 958, 959, 960, 961, 962, 963, 964, 965, 966, 967, 968, 969, 970, 981, 985, 986, 987, 988, 989, 990, 991, 992, 993, 994, 995, 996, 997, 998, 999, 1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1030, 1031, 1032, 1033, 1034, 1035, 1036, 1037, 1067, 1068, 1069, 1070, 1071, 1072, 1073, 1074, 1075, 1076, 1077) AND h.type_id IN (6) AND ((oc_8918.obj_id = o.id AND oc_8918.field_id = 8918 AND ((oc_8918.float_val BETWEEN '12300' AND '12400')))) AND h.domain_id = '1' AND h.lang_id = '1' AND h.is_deleted = '0' AND h.is_active = '1' AND h.id = hr.child_id AND ((hr.level <= 3 AND hr.rel_id = '80')) AND h.obj_id = o.id ORDER BY oc_8918.float_val ASC, h.ord ASC LIMIT 0, 10
Скачать буклет
Скачать (4Mb)

