ул.Маерчака, 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 (4, 5, 6, 7, 8, 9, 10, 3) 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:167
/home/www/z86227/htdocs/index.php:407
Каталог

Биты и насадки

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