string(2343) "select distinct p.products_id, p.products_fsk18, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_oldprice, p.products_model, p.products_vpe, p.products_quantity, p.sklad2, p.products_vpe_status, p.products_vpe_value, p.products_tax_class_id, p.products_date_added, p.products_datenew, p.products_dlina, p.products_shirina, p.products_vysota, p.products_ves, p.products_upakovka, p.products_multiphoto, p.products_video, p.products_vozrastot, p.products_vozrastdo, p.manufacturers_id, p.products_weight, p.products_akciya, m.manufacturers_name from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id, categories c, products_to_categories p2c WHERE pd.language_id = '1' and c.categories_status=1 and p.products_id = p2c.products_id and c.categories_id = p2c.categories_id and products_status = '1' and (p.manufacturers_id = '158' OR p.manufacturers_id = '172') and p.products_date_added < '2016.02.21' and pd.products_name LIKE '%гр %' and p.login=0 and p.hidelic=0 ORDER BY products_name ASC"

АКЦИЯ! С 09.01.2017

Акция! Новогодняя распродажа

Есть в наличии
грн   
Google Plus VKontakte facebook twitter youtube
 
* Характеристики, цвет и комплектация товара могут изменяться производителем без уведомления
Бренды

Вверх

Развернуть тулбар