Database error: Unknown column 'cscart_product_sales.amount' in 'order clause' (1054)
Invalid query: SELECT SQL_CALC_FOUND_ROWS products.*, descr1.product as product, MIN(prices.price) as price, descr1.short_description, IF(descr1.short_description = '', descr1.full_description, '') as full_description, GROUP_CONCAT(IF(products_categories.link_type = 'M', CONCAT(products_categories.category_id, 'M'), products_categories.category_id)) as category_ids, products_categories.position FROM cscart_products as products LEFT JOIN cscart_product_options_inventory as inventory ON inventory.product_id = products.product_id LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'EN' LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') WHERE 1 AND cscart_categories.category_id IN (903, 1503, 1507, 1509, 1511, 612, 955, 1156, 1157, 1187, 1569, 1751, 2132, 2714, 3195, 3550, 1144, 1750, 613, 956, 1158, 1188, 1568, 1570, 1752, 1862, 1898, 2116, 2133, 2715, 3196, 3551, 1996, 3180, 2696, 954, 614, 957, 1159, 1189, 1571, 1753, 1863, 1899, 2117, 2134, 2716, 3197, 3552, 1853, 615, 958, 1190, 1198, 1572, 1754, 1864, 1900, 2118, 2135, 2717, 3198, 3553, 616, 959, 1191, 1199, 1573, 1755, 1865, 1901, 2119, 2136, 2718, 3199, 3549, 3554, 2131, 617, 960, 1192, 1200, 1574, 1756, 1866, 1902, 2121, 2137, 2719, 3200, 3555, 1186, 618, 961, 1193, 1201, 1575, 1757, 1867, 1903, 2122, 2138, 2720, 3201, 3556, 1869, 611, 619, 962, 1194, 1202, 1576, 1758, 1868, 1904, 2123, 2139, 2721, 3202, 3557, 1855, 620, 963, 1195, 1203, 1577, 1759, 1905, 2124, 2140, 2722, 3203, 3558, 1106, 621, 964, 1196, 1204, 1578, 1760, 1870, 1906, 2125, 2141, 2723, 3204, 3559, 1504, 1508, 1510, 1512, 622, 965, 1197, 1205, 1579, 1761, 1871, 1907, 2126, 2142, 2724, 3205, 3560, 1580, 1762, 1872, 1908, 2127, 2143, 2725, 3206, 3561, 1581, 1763, 1873, 1909, 2128, 2144, 2726, 3207, 3562, 1854, 1856, 2129, 1505, 1145, 1146, 1147, 1148, 1149, 1150, 1151, 1152, 1153, 1154, 1506, 1155) AND products.company_id = 0 AND IF(products.tracking = 'O', inventory.amount > 0, products.amount > 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) GROUP BY products.product_id ORDER BY cscart_product_sales.amount desc LIMIT 0, 20


Backtrace:
File:C:\xampp\htdocs\core\fn.database.php
Line:259
Function:db_error
File:C:\xampp\htdocs\core\fn.database.php
Line:29
Function:db_query
File:C:\xampp\htdocs\core\fn.catalog.php
Line:2953
Function:db_get_array
File:C:\xampp\htdocs\controllers\customer\categories.php
Line:69
Function:fn_get_products
File:C:\xampp\htdocs\core\fn.control.php
Line:568
Function:include
File:C:\xampp\htdocs\core\fn.control.php
Line:422
Function:fn_run_controller
File:C:\xampp\htdocs\index.php
Line:28
Function:fn_dispatch