SELECT prodname, category, model, price, stock

Sorry, as an AI language model I don't have access to any database or specific data. However, I can help you with the SQL syntax for selecting the columns from a table.

The syntax for selecting multiple columns from a table is as follows:

SELECT column1, column2, column3, ... FROM table_name;

In the above syntax, you need to replace the column names and table name with the actual names of the columns and table that you want to retrieve data from.

For example, if you have a table named "products" with columns named "prodname", "category", "model", "price", and "stock", then the SQL query for selecting these columns would look like this:

SELECT prodname, category, model, price, stock FROM products;

This query will retrieve all the records from the "products" table and display the data from the specified columns.