Notice: Undefined index: work_place in /var/www/vhosts/idealturnik.ru/httpdocs/config/settings.inc.php on line 22 Notice: Undefined index: work_place in /var/www/vhosts/idealturnik.ru/httpdocs/config/settings.inc.php on line 22 Notice: Undefined index: HTTP_REFERER in /var/www/vhosts/idealturnik.ru/httpdocs/config/config.inc.php on line 107 Notice: Undefined offset: 2 in /var/www/vhosts/idealturnik.ru/httpdocs/config/config.inc.php on line 109 Notice: A session had already been started - ignoring session_start() in /var/www/vhosts/idealturnik.ru/cabinet.idealturnik.ru/core/cmsCore.php on line 32 Notice: Use of undefined constant GUEST - assumed 'GUEST' in /var/www/vhosts/idealturnik.ru/cabinet.idealturnik.ru/core/cmsCore.php on line 44 Notice: Undefined index: login in /var/www/vhosts/idealturnik.ru/cabinet.idealturnik.ru/core/cmsCore.php on line 47 Notice: Undefined index: temp in /var/www/vhosts/idealturnik.ru/cabinet.idealturnik.ru/core/cmsCore.php on line 54 Notice: Undefined index: count in /var/www/vhosts/idealturnik.ru/cabinet.idealturnik.ru/core/cmsCore.php on line 54 Notice: Undefined index: notice in /var/www/vhosts/idealturnik.ru/cabinet.idealturnik.ru/core/cmsCore.php on line 111 Специальные предложения - Идеальный турник-брусья Notice: Undefined index: off_work_place in /var/www/vhosts/idealturnik.ru/httpdocs/_basket.php on line 1 Notice: Undefined index: work_place in /var/www/vhosts/idealturnik.ru/httpdocs/_basket.php on line 12
Корзина ()
Notice: Undefined variable: aBlockCategories in /var/www/vhosts/idealturnik.ru/httpdocs/tools/smarty/sysplugins/smarty_internal_data.php on line 291
10:00 - 19:00 ПН - ВС 8 (499) 647-43-58


бесплатная доставка

Скидки

гарантия подлинности

гарантия качества 18 месяцев

надежная и быстрая доставка

хотите вернуть покупку?



Категории

Warning: mysql_query(): MySQL server has gone away in /var/www/vhosts/idealturnik.ru/httpdocs/classes/MySQL.php on line 149 Warning: mysql_query(): Error reading result set's header in /var/www/vhosts/idealturnik.ru/httpdocs/classes/MySQL.php on line 149 MySQL server has gone away

		SELECT p.*, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`,
		pl.`name`, p.`ean13`, p.`upc`, i.`id_image`, il.`legend`, t.`rate`, m.`name` AS manufacturer_name,
		DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL 20 DAY)) > 0 AS new
		FROM `ps_product` p
		LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 2)
		LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1)
		LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
		LEFT JOIN `ps_tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group`
		                                           AND tr.`id_country` = 177
	                                           	   AND tr.`id_state` = 0)
	    LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`)
		LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
		WHERE 1
		AND p.`active` = 1
		AND p.`show_price` = 1
		 AND p.`id_product` IN (49, 2018, 47, 2989, 48, 3664, 1476, 1339, 451, 468, 2751, 1368, 2101, 2689, 3752, 2383, 6545, 2801, 445, 2105, 4943, 46, 1970, 2754, 879, 407, 2104, 1274, 1798, 748, 2096, 1531, 2208, 3276, 2623, 2990, 3173, 2746, 3712, 2107, 1014, 3099, 1695, 2679, 5808, 3536, 7609, 2106, 3756, 7291, 4655, 397, 443, 5101, 1526, 3750, 3705, 2100, 3754, 3749, 7253, 7255, 3746, 3710, 3709, 2102, 3708, 2203, 3753, 3711, 3713, 2103, 3714, 3734, 3735, 3753, 2109, 2110, 3736, 3743, 7256, 7257, 3741, 3733, 3732, 3745, 3707, 3731, 2108, 3755, 3706, 3730, 3748, 3747, 3729, 3728, 3751, 3727, 3739, 3726, 3737, 3738, 7389, 3725, 3724, 3723, 3722, 2112, 3721, 3720, 3719, 3718, 2113, 2279, 2026, 2220, 2221, 2217, 2097, 2368, 2655, 1300, 2656, 378, 179, 7391, 3177, 1778, 2302, 3175, 3577, 1530, 1453, 3167, 3183, 3171, 3164, 2886, 2888, 2970, 2800, 406, 2280, 2120, 2008, 1477, 2684, 909, 3694, 3695, 3696, 3697, 3698, 3699, 3700, 3701, 3702, 3703, 7390, 7378, 7393, 7392, 7395, 7396, 7397, 7398, 7399, 7400, 7401, 7402, 7403, 7404, 7405, 7406, 7407, 7408, 7409, 7410, 7411, 7412, 7413, 7414, 7415, 7416, 7417, 7418, 7419, 7420, 7421, 7422, 7423, 7424, 7425, 7426, 7427, 405, 7533)
		AND p.`id_product` IN (
			SELECT cp.`id_product`
			FROM `ps_category_group` cg
			LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`)
			WHERE cg.`id_group` = 1
		)
		ORDER BY p.`price` asc
		LIMIT 0, 50