WARNING(512): "SQL Error" in /home/semtek_de/www/inc/xtc_db_error.inc.php:33 (Details)
Backtrace:
#0  trigger_error called at [/home/semtek_de/www/inc/xtc_db_error.inc.php:33]
#1  xtc_db_error called at [/home/semtek_de/www/inc/xtc_db_query.inc.php:68]
#2  xtc_db_query called at [/home/semtek_de/www/includes/application_top.php:247]
#3  xtDBquery called at [/home/semtek_de/www/includes/classes/split_page_results.php:52]
#4  (#splitPageResults_ORIGIN) splitPageResults_ORIGIN called at [/home/semtek_de/www/includes/modules/product_listing.php:42]
#5  include called at [/home/semtek_de/www/includes/modules/default.php:531]
#6  include called at [/home/semtek_de/www/index.php:128]
Context: Array
(
    [query] => 
						SELECT DISTINCT
							p.products_fsk18,
							p.products_shippingtime,
							p.products_model,
							p.products_ean,
							pd.products_name,
							m.manufacturers_name,
							p.products_quantity,
							p.products_image,
							p.products_weight,
							p.gm_show_weight,
							pd.products_short_description,
							pd.products_description,
							pd.gm_alt_text,
							pd.products_meta_description,
							p.products_id,
							p.manufacturers_id,
							p.products_price,
							p.products_vpe,
							p.products_vpe_status,
							p.products_vpe_value,
							p.products_discount_allowed,
							p.products_tax_class_id
							,
										ROUND(IF(s.status = "1" AND p.products_id = s.products_id, s.specials_new_products_price, p.products_price), 2) AS final_price
						FROM
							products AS p
								LEFT JOIN products_description AS pd ON (pd.products_id = p.products_id)
								LEFT JOIN manufacturers AS m ON (m.manufacturers_id = p.manufacturers_id)
								LEFT JOIN specials AS s ON (s.products_id = p.products_id)
								LEFT JOIN feature_index AS fi ON (fi.products_id = p.products_id) 
						WHERE
							p.products_status = 1
							AND pd.language_id = "2"
							AND fi.categories_index LIKE "%-4162-%"
							 ORDER BY p.best_price ASC 
    [errno] => 1054
    [error] => Unknown column 'p.best_price' in 'order clause'
    [t_error_string] => ================================================================================
================================================================================

Query: 
						SELECT DISTINCT
							p.products_fsk18,
							p.products_shippingtime,
							p.products_model,
							p.products_ean,
							pd.products_name,
							m.manufacturers_name,
							p.products_quantity,
							p.products_image,
							p.products_weight,
							p.gm_show_weight,
							pd.products_short_description,
							pd.products_description,
							pd.gm_alt_text,
							pd.products_meta_description,
							p.products_id,
							p.manufacturers_id,
							p.products_price,
							p.products_vpe,
							p.products_vpe_status,
							p.products_vpe_value,
							p.products_discount_allowed,
							p.products_tax_class_id
							,
										ROUND(IF(s.status = "1" AND p.products_id = s.products_id, s.specials_new_products_price, p.products_price), 2) AS final_price
						FROM
							products AS p
								LEFT JOIN products_description AS pd ON (pd.products_id = p.products_id)
								LEFT JOIN manufacturers AS m ON (m.manufacturers_id = p.manufacturers_id)
								LEFT JOIN specials AS s ON (s.products_id = p.products_id)
								LEFT JOIN feature_index AS fi ON (fi.products_id = p.products_id) 
						WHERE
							p.products_status = 1
							AND pd.language_id = "2"
							AND fi.categories_index LIKE "%-4162-%"
							 ORDER BY p.best_price ASC 

Error: Unknown column 'p.best_price' in 'order clause' (error 1054)


    [coo_error_log] => FileLog Object
        (
            [v_log_active] => 1
            [v_file_base] => errors
            [v_file_suffix] => 3cc7a02ca422a43bcc968242ea5a00de
            [v_max_filesize] => 1048576
        )

)


Session: Array
(
    [tracking] => Array
        (
            [http_referer] => Array
                (
                    [path] => 
                )

            [ip] => 184.72.197.101
            [date] => 2013-06-18 09:54:27
            [browser] => CCBot/2.0
            [pageview_history] => Array
                (
                )

        )

    [tracked] => 1
    [language] => german
    [languages_id] => 2
    [language_charset] => iso-8859-15
    [language_code] => de
    [currency] => EUR
    [customers_status] => Array
        (
            [customers_status_id] => 1
            [customers_status_name] => Gast
            [customers_status_image] => guest_status.gif
            [customers_status_discount] => 0.00
            [customers_status_public] => 0
            [customers_status_min_order] => 49.99
            [customers_status_max_order] => 0
            [customers_status_ot_discount_flag] => 0
            [customers_status_ot_discount] => 0.00
            [customers_status_graduated_prices] => 1
            [customers_status_show_price] => 1
            [customers_status_show_price_tax] => 1
            [customers_status_add_tax_ot] => 1
            [customers_status_payment_unallowed] => 
            [customers_status_shipping_unallowed] => 
            [customers_status_discount_attributes] => 0
            [customers_fsk18] => 0
            [customers_fsk18_display] => 1
            [customers_status_write_reviews] => 0
            [customers_status_read_reviews] => 1
        )

    [cart] => shoppingCart Object
        (
            [contents] => Array
                (
                )

            [total] => 0
            [weight] => 0
            [content_type] => 
        )

    [wishList] => wishList Object
        (
            [contents] => Array
                (
                )

            [total] => 0
            [weight] => 0
            [content_type] => 
        )

    [lightbox] => GMLightboxControl Object
        (
            [previous] => false
            [actual] => false
        )

    [coo_filter_manager] => FilterManager Object
        (
            [v_categories_id] => 4162
            [v_feature_value_id_array] => Array
                (
                )

            [v_feature_value_group_array] => Array
                (
                )

            [v_price_range_start] => 0
            [v_price_range_end] => 
            [v_filter_active] => 1
        )

    [account_type] => 0
    [actual_content] => Array
        (
            [] => Array
                (
                    [qty] => 0
                )

        )

    [magnaIsInstalled] => 1
    [gm_history] => Array
        (
            [0] => Array
                (
                    [URL] => /GLP/Impression-Meisterstueck/
                    [FILENAME] => /home/semtek_de/www/index.php
                    [CLOSE] => /GLP/Impression-Meisterstueck/
                )

        )

    [last_listing_sql] => 
						SELECT DISTINCT
							p.products_fsk18,
							p.products_shippingtime,
							p.products_model,
							p.products_ean,
							pd.products_name,
							m.manufacturers_name,
							p.products_quantity,
							p.products_image,
							p.products_weight,
							p.gm_show_weight,
							pd.products_short_description,
							pd.products_description,
							pd.gm_alt_text,
							pd.products_meta_description,
							p.products_id,
							p.manufacturers_id,
							p.products_price,
							p.products_vpe,
							p.products_vpe_status,
							p.products_vpe_value,
							p.products_discount_allowed,
							p.products_tax_class_id
							,
										ROUND(IF(s.status = "1" AND p.products_id = s.products_id, s.specials_new_products_price, p.products_price), 2) AS final_price
						FROM
							products AS p
								LEFT JOIN products_description AS pd ON (pd.products_id = p.products_id)
								LEFT JOIN manufacturers AS m ON (m.manufacturers_id = p.manufacturers_id)
								LEFT JOIN specials AS s ON (s.products_id = p.products_id)
								LEFT JOIN feature_index AS fi ON (fi.products_id = p.products_id) 
						WHERE
							p.products_status = 1
							AND pd.language_id = "2"
							AND fi.categories_index LIKE "%-4162-%"
							 ORDER BY p.best_price ASC 
)