( select p.products_fsk18, p.products_shippingtime, p.products_model, p.label_id, p.products_ean, pd.products_name, p.products_id, p.products_price, m.manufacturers_name, p.products_quantity, p.products_image, p.products_page_url, p.products_status, p.products_new, p.products_best, p.products_dcount, p.not_available, p.products_weight, pd.products_short_description, pd.products_description, p.manufacturers_id, p.products_vpe, p.products_vpe_status, p.products_vpe_value, p.products_discount_allowed, p.products_tax_class_id from products_description pd, manufacturers m, products p left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.not_available<>1 and p.products_price>0 and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '713' GROUP BY p.products_id ORDER BY pd.products_name limit 1000 ) UNION ( select p.products_fsk18, p.products_shippingtime, p.products_model, p.label_id, p.products_ean, pd.products_name, p.products_id, p.products_price, m.manufacturers_name, p.products_quantity, p.products_image, p.products_page_url, p.products_status, p.products_new, p.products_best, p.products_dcount, p.not_available, p.products_weight, pd.products_short_description, pd.products_description, p.manufacturers_id, p.products_vpe, p.products_vpe_status, p.products_vpe_value, p.products_discount_allowed, p.products_tax_class_id from products_description pd, manufacturers m, products p left join specials s on p.products_id = s.products_id where p.products_status = '1' and (p.not_available=1 or p.products_price=0) and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '713' GROUP BY p.products_id ORDER BY pd.products_name limit 1000 ) Homefort интернет магазин - купить товары Homefort в Киеве и Украине

Homefort