ул. Мало-Якутская, 19/2
0.00 руб.
0
В корзине пусто
0.00 руб.
0
В корзине пусто
8 (3952) 505-175
ул. Мало-Якутская, 19/2
SELECT a.*, b.name as expack_name, b.id as expack_id, b.sku as expack_sku, c.cy as exprice_cy, c.val as exprice_val FROM pik_exgood a
		inner join pik_expack b ON (b.parent = a.id)
		inner join pik_exprice_good c ON (c.parent = 3 AND b.id = c.expack)
		
		where a.publish = 1 and (a.region = 'irkutsk' or a.region = '') and a.parent in (184, 246, 251, 185, 186, 187, 188, 247, 248, 249, 250, 303, 252, 253, 254, 183) AND `publish3` = 1
		group by a.id order by a.name asc
LIMIT -12, 12

/home/www/z86227/htdocs/idb.php:496
/home/www/z86227/htdocs/i24.php:131
/home/www/z86227/htdocs/component/ex/ex.php:394
/home/www/z86227/htdocs/component/ex/ex.php:72
/home/www/z86227/htdocs/component/ex/ex.php:36
/home/www/z86227/htdocs/icore.php:196
/home/www/z86227/htdocs/theme/index/index.php:167
/home/www/z86227/htdocs/index.php:407
Каталог

Монтажная пена, клей и герметики

Наименование
Цена
Отображать по:
Список товаров пуст.
Отображать по: