string(2501) "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 = '157' OR p.manufacturers_id = '155') and pd.products_name not like '%Велосипед дет%' and pd.products_name not like '%Браслетов%' and pd.products_name not like '%TREFL%' and p.products_date_added < '2016.02.21' and pd.products_name NOT LIKE '%гр %' and p.login=0 and p.hidelic=0 ORDER BY products_name ASC"

Цена недели ! С 28.12.2016

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


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