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=619 and (or1.id_r=974)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=619 and (or1.id_r=974) 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=619 and (or1.id_r=974)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=619 and (or1.id_r=974) 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=619 and (or1.id_r=974) 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=619 and (or1.id_r=974) 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=619 and (or1.id_r=974) and (or2.id_r=888)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=619 and (or1.id_r=974) 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=619 and (or1.id_r=974) 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=619 and (or1.id_r=974) and (or2.id_r=891)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=619 and (or1.id_r=974) and (or2.id_r=893)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=619 and (or1.id_r=974) and (or2.id_r=895)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=619 and (or1.id_r=974) 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=619 and (or1.id_r=974) 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=619 and (or1.id_r=974) and (or2.id_r=898)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=619 and (or1.id_r=974) and (or2.id_r=899)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=619 and (or1.id_r=974) and (or2.id_r=949)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=619 and (or1.id_r=974) and (or2.id_r=1219)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=619 and (or1.id_r=974) and (or2.id_r=1380)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=619 and (or1.id_r=974) and (or2.id_r=1381)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=619 and (or1.id_r=974) 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=619 and (or1.id_r=974) 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=619 and (or1.id_r=974) and (or2.id_r=906)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=619 and (or1.id_r=974) 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=619 and (or1.id_r=974) 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=619 and (or1.id_r=974) and (or2.id_r=916)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=619 and (or1.id_r=974) and (or2.id_r=935)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=619 and (or1.id_r=974) and (or2.id_r=364)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=619 and (or1.id_r=974) and (or2.id_r=425)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=619 and (or1.id_r=974) and (or2.id_r=981)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=619 and (or1.id_r=974) and (or2.id_r=983)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=619 and (or1.id_r=974) and (or2.id_r=1213)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=619 and (or1.id_r=974) 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=619 and (or1.id_r=974) 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=619 and (or1.id_r=974) and (or2.id_r=1278)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=619 and (or1.id_r=974) and (or2.id_r=1296)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=619 and (or1.id_r=974 or or1.id_r=967)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=619 and (or1.id_r=974 or or1.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=619 and (or1.id_r=974 or or1.id_r=969)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=619 and (or1.id_r=974 or or1.id_r=970)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=619 and (or1.id_r=974 or or1.id_r=971)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=619 and (or1.id_r=974 or or1.id_r=972)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=619 and (or1.id_r=974 or or1.id_r=973)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=619 and (or1.id_r=974)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=619 and (or1.id_r=974 or or1.id_r=975)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=619 and (or1.id_r=974) and (or2.id_r=977)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=619 and (or1.id_r=974) and (or2.id_r=978)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=619 and (or1.id_r=974) and (or2.id_r=979)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=619 and (or1.id_r=974) and (or2.id_r=957)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=619 and (or1.id_r=974) and (or2.id_r=958)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=619 and (or1.id_r=974) and (or2.id_r=959)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=619 and (or1.id_r=974) and (or2.id_r=48)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=619 and (or1.id_r=974) 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=619 and (or1.id_r=974) 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=619 and (or1.id_r=974) 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=619 and (or1.id_r=974) and (or2.id_r=388)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=619 and (or1.id_r=974) and (or2.id_r=350)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=619 and (or1.id_r=974) and (or2.id_r=351)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=619 and (or1.id_r=974) and (or2.id_r=352)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=619 and (or1.id_r=974) and (or2.id_r=353)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=619 and (or1.id_r=974) and (or2.id_r=358)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=619 and (or1.id_r=974) and (or2.id_r=359)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=619 and (or1.id_r=974) and (or2.id_r=360)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=619 and (or1.id_r=974) and (or2.id_r=361)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=619 and (or1.id_r=974) and (or2.id_r=418)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=619 and (or1.id_r=974) and (or2.id_r=545)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=619 and (or1.id_r=974) 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=619 and (or1.id_r=974) and (or2.id_r=356)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=619 and (or1.id_r=974) and (or2.id_r=354)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=619 and (or1.id_r=974) and (or2.id_r=355)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=619 and (or1.id_r=974) 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=619 and (or1.id_r=974) and (or2.id_r=962)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=619 and (or1.id_r=974) and (or2.id_r=1116)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=619 and (or1.id_r=974) and (or2.id_r=19)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=619 and (or1.id_r=974) and (or2.id_r=135)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=619 and (or1.id_r=974) and (or2.id_r=196)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=619 and (or1.id_r=974) and (or2.id_r=230)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=619 and (or1.id_r=974) and (or2.id_r=284)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=619 and (or1.id_r=974) and (or2.id_r=496)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=619 and (or1.id_r=974) and (or2.id_r=1541)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=619 and (or1.id_r=974) and (or2.id_r=2130)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=619 and (or1.id_r=974) 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=619 and (or1.id_r=974) and (or2.id_r=864)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=619 and (or1.id_r=974) and (or2.id_r=871)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=619 and (or1.id_r=974) and (or2.id_r=873)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=619 and (or1.id_r=974)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=619 and (or1.id_r=974) order by o.idx asc,o.id desc limit 0,24

Обеденные группы камень

2 моделей
4.3
(2 Оценок)
Материал столешницы:
    Выводятся только:
    Материал столешницы:камень
    4.2
    Обеденная группа Sheffilton SHT-DS288
    125 834 ₽
    Габариты:
    2600 х 2220 х 850 мм
    Цвета:
    • image description
    • image description
    Добавить в корзину
    4.3
    Обеденная группа Sheffilton SHT-DS289
    123 522 ₽
    Габариты:
    2600 х 2000 х 820 мм
    Цвета:
    • image description
    • image description
    Добавить в корзину