Books & Media
While choosing a tourist route, we often need prompting, since it is difficult to orient oneself in an unknown territory. Especially when the goal of your travel is Russia, St Petersburg, the Hermitage Museum. While preparing for your tour, you may make up your own program and work out a special route using guide-books of high professional level, published in various languages and richly illustrated.
[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 = '156' OR c.parent_id = '156') order by p.products_sort_order, pd.products_name limit 0, 50]