PlusEME error in query!

[Brad]

hey guys I keep getting this MySQL error, Can you please comment a fix, thanks!

Error en query:
SELECT FROM ITEMS WHERE user_id=@userid AND room_id='0' LIMIT 8000;
MySql.Data.MySqlClient.MySqlException (0x80004005): 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 'FROM ITEMS WHERE user_id=31 AND room_id='0' LIMIT 8000' at line 1
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at Database_Manager.Database.Session_Details.QueryAdapter.getTable() in c:\Users\Westy\Desktop\EMU\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 136

 

[JayC]

I believe the correct format of this SQL would be:
SELECT FROM `items` WHERE `user_id`='31' AND `room_id`='0' LIMIT 8000