BEFORE:
Array
(
    [0] => products_name
    [1] => products_model
    [2] => products.seo_keyword_01
)



AFTER:
Array
(
    [0] => products_name
    [1] => products_model
    [2] => products.seo_keyword_01
    [3] => productstats.intelligent_sort_order ASC
    [4] => products.sort_order ASC
    [5] => products_description.products_name ASC
)

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC, products.sort_order ASC, products_description.products_name ASC ' at line 1

SELECT DISTINCT products.products_id, seo_cpath , products_name, products_model, products.seo_keyword_01, productstats.intelligent_sort_order ASC, products.sort_order ASC, products_description.products_name ASC FROM products LEFT JOIN products_description USING(products_id) LEFT JOIN products_extra USING(products_id) LEFT JOIN productstats USING(products_id) LEFT JOIN manufacturers USING(manufacturers_id) LEFT JOIN products_seocpath ON products_seocpath.products_id = products.products_id AND products_seocpath.store_id = "1" WHERE 1=1 AND products.products_id = "1186" ORDER BY productstats.intelligent_sort_order ASC , products.sort_order ASC , products_description.products_name ASC LIMIT 0, 50

[TEP STOP]