SELECT deviceName, post_date as Time, post_content FROM wpqs_posts, wpqs_device_information WHERE deviceCTN = post_title and post_author = 2 ORDER BY wpqs_posts.ID DESC LIMIT 10