Fine example of a country house built to the Arts and Crafts ideals. All the furniture is also Arts and Crafts

SELECT title, text, author, rating1, rating2, rating3, unix_timestamp(date) AS unixDate FROM reviews WHERE item_id = 31 AND `approved`= 1 ORDER BY `date` DESC