Code:
INVALID SQL: 1052 : Column: 'avail' in where clause is ambiguous
SQL QUERY FAILURE: SELECT * FROM xcart_products,xcart_categories,xcart_pricing WHERE forsale='Y' AND avail>0 AND categoryid=82 AND xcart_categories.productid=xcart_products.productid AND xcart_products.productid=xcart_pricing.productid ORDER BY RAND() LIMIT 5
is this because im using a other language