Новости:
Legrand: 673681
Перекл промежут СЛНК INSPIRIA
Серия Inspiria
Выключатели/Переключатели
| Цвет: | Бежевый |
| Номинальный ток, А: | 10 |
| Количество клавиш: | 1 |
| Способ монтажа: | Скрытый |
| Степень защиты: | IP20 |
| Наличие подсветки: | - |
Предназначен для установки в электрических сетях жилых и общественных зданий и используется для управления приборами освещения, вентиляции и т.д. Используется для управления нагрузкой с трех или более мест.
Особенности изделия:
- Компактный механизм с глубиной всего 20 мм. комфортно размещается в различных монтажных коробках.
- Материал клавиши - глянцевый пластик АБС, стоек к выгоранию и загрязнениям.
- Все токоведущие части выключателя имеют защиту от случайного прикосновения.
- Для подсоединения проводов используются винтовые зажимы.
- Улучшенная эргономика снижает вероятность искрения при коммутации светодиодов.
- Ход клавиши короткий, не громкий.
Ошибка: Запрос (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 '/tmp/#sql_ac9_28.MYI' (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 './ec_electric_db/ss_ec_online_items_fields.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