Новости:
Legrand: 673672
Перекл 1кл IP44 АЛЮ INSPIRIA
Серия Inspiria
Выключатели/Переключатели
| Цвет: | Алюминий |
| Номинальный ток, А: | 10 |
| Количество клавиш: | 1 |
| Способ монтажа: | Скрытый |
| Степень защиты: | IP44 |
| Наличие подсветки: | - |
Предназначен для установки в местах с повышенной влажностью (например, ванные комнаты, веранды, кладовки, подвалы, коридоры и т.п.) и используется для управления нагрузкой с одного, двух или более мест (совместно с промежуточными выключателями).
Особенности изделия:
- Компактный механизм с глубиной всего 20 мм. комфортно размещается в различных монтажных коробках.
- Материал клавиши - глянцевый пластик АБС, стоек к выгоранию и загрязнениям.
- Все токоведущие части выключателя имеют защиту от случайного прикосновения.
- Безвинтовые зажимы для присоединения проводов обеспечивают быстрое подключение и отключение, гарантируют надежное и долговечное соеднинение и не требуют обслуживания.
- Удобные широкие толкатели облегчают работу по демонтажу провода.
- Улучшенная эргономика снижает вероятность искрения при коммутации светодиодов.
- Ход клавиши короткий, не громкий.
- Благодаря наличию защитной мембраны обладает степенью пыле-влагозащиты IP44 и подходит для размещения в местах с повышенной влажностью.
Ошибка: Запрос (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "67" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "4" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "67" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "10" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "4" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "67" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "4" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "67" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "10" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "4" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "67" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "4" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "67" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "10" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "4" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "67" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "10" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "4" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "67" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "10" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "4" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "67" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "4" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "67" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "4" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) вызвал ошибку Out of resources when opening file './ec_electric_db/ss_ec_online_items.MYD' (Errcode: 24)
Array
(
[0] => Array
(
[file] => /var/www/system/lib/db.php
[line] => 80
[function] => db_query
[args] => Array
(
[0] => (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "10" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "10" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "10" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "10" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "10" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
)
)
[1] => Array
(
[file] => /var/www/_content/pages/text/29/429_1
[line] => 2146
[function] => db_getAssocs
[args] => Array
(
[0] => (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "10" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "10" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "10" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "10" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "10" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie= "Inspiria" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
)
)
[2] => Array
(
[file] => /var/www/system/handler/index.php
[line] => 357
[args] => Array
(
[0] => /var/www/_content/pages/text/29/429_1
)
[function] => require
)
)
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, null given in /var/www/system/lib/db.php on line 82
Ошибка: Запрос (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "67" and i.serie = "Lighting Management" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Valena Classic" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "4" and i.serie = "Valena Classic" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "67" and i.serie = "Valena Classic" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "10" and i.serie = "Valena Classic" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Cariva" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "4" and i.serie = "Cariva" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "67" and i.serie = "Cariva" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Celiane" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "4" and i.serie = "Celiane" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "67" and i.serie = "Celiane" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "10" and i.serie = "Celiane" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Plexo" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "4" and i.serie = "Plexo" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "67" and i.serie = "Plexo" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "4" and i.serie = "Mosaic" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "67" and i.serie = "Mosaic" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "10" and i.serie = "Mosaic" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Mosaic" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Galea Life" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "4" and i.serie = "Galea Life" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "67" and i.serie = "Galea Life" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "10" and i.serie = "Galea Life" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Valena Life/Allure" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "4" and i.serie = "Valena Life/Allure" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "67" and i.serie = "Valena Life/Allure" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "10" and i.serie = "Valena Allure" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Etika" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "4" and i.serie = "Etika" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "67" and i.serie = "Etika" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Quteo" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "4" and i.serie = "Quteo" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "67" and i.serie = "Quteo" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Oteo" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "4" and i.serie = "Oteo" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from ss_ec_online_items as i left join ss_ec_online_groups as g on g._id = i.group left join ss_ec_online_groups_fields as g_f on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0 left join ss_ec_online_items_fields as i_f on i_f.item_id = i._id and i_f.field_id = g_f._id where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Odace" and i._disabled=0 order by i_f.value != "Алюминий", i._id limit 1) вызвал ошибку Out of resources when opening file '/tmp/#sql_ac9_58.MYD' (Errcode: 24)
Array
(
[0] => Array
(
[file] => /var/www/system/lib/db.php
[line] => 80
[function] => db_query
[args] => Array
(
[0] => (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie = "Lighting Management" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Valena Classic" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie = "Valena Classic" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie = "Valena Classic" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "10" and i.serie = "Valena Classic" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Cariva" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie = "Cariva" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie = "Cariva" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Celiane" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie = "Celiane" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie = "Celiane" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "10" and i.serie = "Celiane" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Plexo" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie = "Plexo" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie = "Plexo" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie = "Mosaic" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie = "Mosaic" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "10" and i.serie = "Mosaic" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Mosaic" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Galea Life" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie = "Galea Life" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie = "Galea Life" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "10" and i.serie = "Galea Life" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Valena Life/Allure" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie = "Valena Life/Allure" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie = "Valena Life/Allure" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "10" and i.serie = "Valena Allure" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Etika" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie = "Etika" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie = "Etika" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Quteo" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie = "Quteo" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie = "Quteo" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Oteo" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie = "Oteo" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Odace" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
)
)
[1] => Array
(
[file] => /var/www/_content/pages/text/29/429_1
[line] => 2183
[function] => db_getAssocs
[args] => Array
(
[0] => (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie = "Lighting Management" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Valena Classic" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie = "Valena Classic" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie = "Valena Classic" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "10" and i.serie = "Valena Classic" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Cariva" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie = "Cariva" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie = "Cariva" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Celiane" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie = "Celiane" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie = "Celiane" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "10" and i.serie = "Celiane" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Plexo" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie = "Plexo" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie = "Plexo" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie = "Mosaic" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie = "Mosaic" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "10" and i.serie = "Mosaic" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Mosaic" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Galea Life" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie = "Galea Life" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie = "Galea Life" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "10" and i.serie = "Galea Life" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Valena Life/Allure" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie = "Valena Life/Allure" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie = "Valena Life/Allure" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "10" and i.serie = "Valena Allure" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Etika" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie = "Etika" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie = "Etika" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Quteo" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie = "Quteo" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "67" and i.serie = "Quteo" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Oteo" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "4" and i.serie = "Oteo" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
UNION (select i._id, i.reference, i.title, i.brand, g._id as group_id, g.title as `group`, i.serie, i.see_also_self from
ss_ec_online_items as i
left join
ss_ec_online_groups as g
on g._id = i.group
left join
ss_ec_online_groups_fields as g_f
on g_f._master_id=i.`group` and g_f.title="Цвет" and g_f._disabled=0
left join
ss_ec_online_items_fields as i_f
on i_f.item_id = i._id and i_f.field_id = g_f._id
where i.brand = "Legrand" and i.`group` = "5" and i.serie = "Odace" and i._disabled=0
order by i_f.value != "Алюминий", i._id
limit 1)
)
)
[2] => Array
(
[file] => /var/www/system/handler/index.php
[line] => 357
[args] => Array
(
[0] => /var/www/_content/pages/text/29/429_1
)
[function] => require
)
)
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, null given in /var/www/system/lib/db.php on line 82