SQL-запрос:
(/* list */ SELECT obj_photo.o_id o_id, obj_photo.o_name o_name, obj_photo.o_class_id o_class_id, obj_photo.o_create_date o_create_date, obj_photo.o_change_date o_change_date, pt_photo.other_link other_link, pt_photo.pseudo_url pseudo_url, pt_photo.in_new_window in_new_window, pt_photo.is_home_page is_home_page, pt_photo.lang_id lang_id, pt_photo.domain_id domain_id, pt_photo.template_id template_id, pt_photo.template2_id template2_id, MAX(r_state) r_state, link_photo.r_position r_position, link_photo.r_parent_id r_parent_id , photo.image FROM `bagira_objects` obj_photo, `bagira_pages` pt_photo, `bagira_rels` link_photo, `bagira_rights`, `bagira___photo` photo WHERE pt_photo.p_obj_id = obj_photo.o_id and obj_photo.o_to_trash = 0 and obj_photo.o_class_id = "48" and obj_photo.o_id = photo.obj_id and ( link_photo.r_children_id = obj_photo.o_id and link_photo.r_field_id is NULL and link_photo.r_parent_id = "2088" ) and pt_photo.active = "1" and r_obj_id = obj_photo.o_id and r_state > 0 and (r_group_id is NULL or r_group_id = "" or r_group_id = "48") and pt_photo.lang_id = "1" and pt_photo.domain_id = "1" GROUP BY obj_photo.o_id) UNION (/* list */ SELECT obj_photo.o_id o_id, obj_photo.o_name o_name, obj_photo.o_class_id o_class_id, obj_photo.o_create_date o_create_date, obj_photo.o_change_date o_change_date, pt_photo.other_link other_link, pt_photo.pseudo_url pseudo_url, pt_photo.in_new_window in_new_window, pt_photo.is_home_page is_home_page, pt_photo.lang_id lang_id, pt_photo.domain_id domain_id, pt_photo.template_id template_id, pt_photo.template2_id template2_id, MAX(r_state) r_state, link_photo.r_position r_position, link_photo.r_parent_id r_parent_id , photo.image FROM `bagira_objects` obj_photo, `bagira_pages` pt_photo, `bagira_rels` link_photo, `bagira_rights`, `bagira___promo` photo WHERE pt_photo.p_obj_id = obj_photo.o_id and obj_photo.o_to_trash = 0 and obj_photo.o_class_id = "89" and obj_photo.o_id = photo.obj_id and ( link_photo.r_children_id = obj_photo.o_id and link_photo.r_field_id is NULL and link_photo.r_parent_id = "2088" ) and pt_photo.active = "1" and r_obj_id = obj_photo.o_id and r_state > 0 and (r_group_id is NULL or r_group_id = "" or r_group_id = "48") and pt_photo.lang_id = "1" and pt_photo.domain_id = "1" GROUP BY obj_photo.o_id) ORDER BY r_position asc

ОШИБКИ:
SQLSTATE[HY000]: General error: 1271 Illegal mix of collations for operation 'UNION'

Шкафы купе в Омске. Мир мебельной фурнитуры «ММФ»

«МИР МЕБЕЛЬНОЙ ФУРНИТУРЫ»

Салон ул. Химиков 4 тел.: 26-98-73
Салон ул. 70 лет октября 18 тел.: 70-27-47
Склад ул. Вавилова 227  тел.: 907-957
Единая справочная тел.: 8-913-602-11-93
Инструкция сборки С и Н.doc

ПРАЙС- ЛИСТ 01.10.2016 г.xlsx

Комплект роликов на одну дверь С

Цена: по прайсу р.