The the query in the "sales_items.php" shoulb be:
Code:
// the database query
$query = "SELECT * FROM $sql_tbl[products],$sql_tbl[pricing] WHERE forsale='Y' AND avail>0 AND $sql_tbl[products].productid LIKE $sql_tbl[pricing].productid AND $sql_tbl[products].list_price - $sql_tbl[pricing].price > 19 ORDER by xcart_products.productID DESC LIMIT 0,10 ";
Sorry