The articles of interior decoration often combine several functions. For example, a clock may be used as a visiting-card-holder, a box for letters as a writing-set base. It is such pieces of interior decoration that we offer you in this section. The articles could be selected in various styles and materials, basing on the works by masters of various epochs, be they the famous Kolyvan stonecutters or antique sculptors.
[select p.products_weight, p.products_model, p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from zen_products_description pd, zen_products p left join zen_manufacturers m on p.manufacturers_id = m.manufacturers_id, zen_products_to_categories p2c INNER JOIN zen_categories c ON p2c.categories_id = c.categories_id left join zen_specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and (c.categories_id = '188' OR c.parent_id = '188') order by p.products_sort_order, pd.products_name limit 0, 50]