Notice: Use of undefined constant HEADING_DESCRIPTION - assumed 'HEADING_DESCRIPTION' in /var/www/scat-technology/russian/featured-products.php on line 5

Notice: Use of undefined constant HEADING_KEYWORDS - assumed 'HEADING_KEYWORDS' in /var/www/scat-technology/russian/featured-products.php on line 6

Notice: Use of undefined constant MODULE_BOXES_FILTER_TITLE - assumed 'MODULE_BOXES_FILTER_TITLE' in /var/www/scat-technology/russian/includes/modules/boxes/bm_filter.php on line 13

Notice: Use of undefined constant MODULE_BOXES_FILTER_DESCRIPTION - assumed 'MODULE_BOXES_FILTER_DESCRIPTION' in /var/www/scat-technology/russian/includes/modules/boxes/bm_filter.php on line 14

Notice: Use of undefined constant MODULE_HEADER_TAGS_YANDEX_ANALYTICS_TITLE - assumed 'MODULE_HEADER_TAGS_YANDEX_ANALYTICS_TITLE' in /var/www/scat-technology/russian/includes/modules/header_tags/ht_yandex_analytics.php on line 14

Notice: Use of undefined constant MODULE_HEADER_TAGS_YANDEX_ANALYTICS_DESCRIPTION - assumed 'MODULE_HEADER_TAGS_YANDEX_ANALYTICS_DESCRIPTION' in /var/www/scat-technology/russian/includes/modules/header_tags/ht_yandex_analytics.php on line 15

Notice: Use of undefined constant MODULE_HEADER_TAGS_YANDEX_ANALYTICS_TITLE - assumed 'MODULE_HEADER_TAGS_YANDEX_ANALYTICS_TITLE' in /var/www/scat-technology/russian/includes/modules/header_tags/ht_yandex_analytics.php on line 14

Notice: Use of undefined constant MODULE_HEADER_TAGS_YANDEX_ANALYTICS_DESCRIPTION - assumed 'MODULE_HEADER_TAGS_YANDEX_ANALYTICS_DESCRIPTION' in /var/www/scat-technology/russian/includes/modules/header_tags/ht_yandex_analytics.php on line 15

Featured Products

1054 - Unknown column 'p.products_price' in 'field list'

select distinct p.products_id, p.products_model, pd.short_description, pd.products_name, pd.teaser, p.products_image, p.products_price, p.products_tax_class_id, p.currencies_code, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, p.products_date_added, p.products_quantity, p.products_weight, p.products_date_available, p.delivery, products_quantity_order_min from products p left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by p.products_date_added DESC, pd.products_name limit 0, 15

[TEP STOP]