select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id where o.id_type not in (1,2,77,88) and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015)select distinct o.id_type, o.id, o.sid, o.active,o.idx from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id where o.id_type not in (1,2,77,88) and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) limit 0,1select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015)select distinct o.id_type, o.id, o.sid, o.active,o.idx from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) limit 0,1 Кухонные гарнитуры напольные купить по низкой цене в интернет-магазине MebelStol в Санкт-Петербурге
МебельСтол Контакты:
Адрес: 1-й Варшавский проезд, д. 1А, стр. 15 115201 Москва,
Телефон:8 (800) 555-39-46, Электронная почта: sales@mebelstol.ru
  • Ваш город:

    Ваш город Санкт-Петербург?
  • График работы:

    09:00 – 21:00

select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=886)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=887)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=890)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=896)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=897)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=889)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=953)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=954)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=908)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=907)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=986)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=910)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=366)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=369)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=422)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=478)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=428)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=429)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=1214)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=1215)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=1280)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=968)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015 or or1.id_r=1018)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015 or or1.id_r=1354)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015 or or1.id_r=1305)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=216)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=51)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=223)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=56)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=1179)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=47)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=1294)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=1295)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=413)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=963)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=308)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=331)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=487)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=400)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=1907)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=1705)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=2123)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=1264)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=1265)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=2182)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=1516)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=1523)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=859)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=1517)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id inner join meb_object_rubric as or2 on o.id_part=or2.id_part and o.id_type=or2.id_type and o.id=or2.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) and (or2.id_r=863)select count(*) from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015)select distinct o.id_type, o.id, o.sid, o.active,o.idx from meb_object as o inner join meb_object_rubric as orm on o.id_part=orm.id_part and o.id_type=orm.id_type and o.id=orm.id inner join meb_object_rubric as or1 on o.id_part=or1.id_part and o.id_type=or1.id_type and o.id=or1.id where o.id_type not in (1,2,77,88) and o.active=1 and orm.id_part=1 and orm.id_r=782 and (or1.id_r=1015) order by o.idx asc,o.id desc limit 0,24

Кухонные гарнитуры напольные

2 моделей
4.7
(4 Оценок)
Тип установки:
    Выводятся только:
    Тип установки:напольные
    4.2
    Стол с ящиками Сокол ТК-06.1
    10 345 ₽
    Габариты:
    850 х 600 х 600 мм
    Цвета:
    • image description
    • image description
    • image description
    Добавить в корзину
    4.5
    Стол с полками Сокол ТК-06
    10 345 ₽
    Габариты:
    850 х 600 х 600 мм
    Цвета:
    • image description
    • image description
    • image description
    Добавить в корзину