ул.Маерчака, 65, строение 22
0.00 руб.
0
В корзине пусто
0.00 руб.
0
В корзине пусто
8 (391) 2-911-900
ул.Маерчака, 65, строение 22
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 = 1 AND b.id = c.expack)
		
		where a.publish = 1 and (a.region = 'krs' or a.region = '') and a.parent in (175, 176, 177, 178, 174) AND `publish1` = 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:165
/home/www/z86227/htdocs/index.php:377
Каталог

Монтажные профили

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