SELECT 
  cscart_discussion_posts.*, 
  cscart_discussion_messages.message, 
  cscart_discussion_rating.rating_value, 
  cscart_discussion.* 
FROM 
  cscart_discussion_posts 
  INNER JOIN cscart_discussion ON cscart_discussion.thread_id = cscart_discussion_posts.thread_id 
  INNER JOIN cscart_discussion_messages ON cscart_discussion_messages.post_id = cscart_discussion_posts.post_id 
  INNER JOIN cscart_discussion_rating ON cscart_discussion_rating.post_id = cscart_discussion_posts.post_id 
WHERE 
  1 
  AND cscart_discussion.company_id = 1 
ORDER BY 
  cscart_discussion_posts.timestamp desc

Query time 0.00069

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_discussion_rating ALL PRIMARY 24 Using temporary; Using filesort
1 SIMPLE cscart_discussion_messages eq_ref PRIMARY PRIMARY 3 cscart_dev_4_16.cscart_discussion_rating.post_id 1
1 SIMPLE cscart_discussion_posts eq_ref PRIMARY,thread_id,thread_id_2 PRIMARY 3 cscart_dev_4_16.cscart_discussion_rating.post_id 1
1 SIMPLE cscart_discussion eq_ref PRIMARY,idx_company_id PRIMARY 3 cscart_dev_4_16.cscart_discussion_posts.thread_id 1 Using where

Result

post_id thread_id name timestamp user_id ip_address status message rating_value object_id object_type type company_id
27 26 Ignatius Parks 1729680734 7 b9b1bd04 D Enim esse accusamus 5 0 E B 1
26 26 Mihail Leguckiy 1729680028 7 b9b1bd04 D dghhhhhhhhhhhhhhhhhhhhw 3 0 E B 1
25 26 Bell Matthews 1729679688 0 b9b1bd04 D Enim aut qui est qua 3 0 E B 1
24 26 Jayme Shepard 1729679609 0 b9b1bd04 D Nostrud velit dolore 5 0 E B 1
23 26 Yardley Lara 1729679535 0 b9b1bd04 D Quos ut voluptatem a 5 0 E B 1
22 26 Ali Nichols 1729679179 29 b9b1bd04 D Ut dolorem maiores s 4 0 E B 1
20 43 Dim 1720015380 0 2e964957 A Dim 5 46 A B 1
21 43 Alex 1720015380 0 2e964957 A Alex 4 46 A B 1
17 25 John 1383914729 0 10.7.7.93 A I’ve been using an iPhone 5 daily for the past year, and the iPhone 5s seems to feel exactly the same: the same curved edges, same dimensions, same everything. It's only an updated Home button and the new camera flash which make you realize that this is not an iPhone 5. Many people think that releasing the same design twice is bad, and there are others who realize that sometimes there's no need for change. Apple might want to understand that the competition is strong, and it needs to stay relevant. 3 239 P B 1
18 26 Alex 1383914729 0 10.7.7.93 A You guys have the BEST customer service known to man!!! I have always been impressed with how fast you help us out! 4 0 E B 1
16 24 Melissa 1383914678 0 10.7.7.93 A I was hesitant to choose between Nikon and Canon at first, but when I had a chance to compare the 2 similar models of the 2 competing giants, I chose Nikon. It just feels right, you know. The colors, the matrix, the interface — everything about this product is just beyond expectations! I've already made a portfolio with the help of it. Simply perfect! 5 167 P B 1
19 26 Michael 1383914678 0 10.7.7.93 A You're the best! Thank you most graciously and appreciatively! 5 0 E B 1
15 23 George 1383914632 0 10.7.7.93 A A good and reliable phone is a necessity for a person like me, that's why I decided to choose iPhone. Apple is a remarkable company, and it is always at pace with time, forward-thinking and innovative. The iPhone is clear-cut, easy-to-use and definitely the most stylish phone on the market now. I enjoy it, although I sometimes experience troubles with software & maintenance, and there phone is literally crammed with a lot of features I never use. I would recommend this mostly to younger generation, whereas people of my age might find it a bit bewildering at first. 4 238 P B 1
14 22 Alex 1383914559 0 10.7.7.93 A I was looking for a handy and easy-to-use camcorder when I came across this little bird, and I have to say — it really does everything perfectly! Whether you just want to catch some memory in a form of a video, or plan to do a full video project — this camcorder will become your best friend! All the necessary features are present and easily adjustable. I didn't come across any problem using this amazing piece of technology. Definitely worth its money! 4 172 P B 1
13 21 Jeniffer 1383914502 0 10.7.7.93 A Good picture quality for a LED-based LCD, with relatively deep levels in dark scenes, as well as good white balance in the bright ones. It includes built-in Wi-Fi, 3D with a pair of glasses, and many other cool features. Overall it's quite good, although the picture sometimes loses fidelity from off-angle in dark scenes. 4 8 P B 1
11 19 Brian 1383914367 0 10.7.7.93 A Absolutely enjoy this TV. The colors are amazing: the depth, the balance and everything else is just top notch! I can plug in my hard drive and watch videos instantly! I am still amazed at the clarity from all the angles. Just getting into Blue-ray capabilities now. Although the price is relatively high, I can truly say that it's a stunning piece of technological craftsmanship. 4 1 P B 1
10 18 David 1383914308 0 10.7.7.93 A I am extremely satisfied with this LCD TV. I have searched for and read all I could about the flat screen TVS. I am so impressed with the picture and sound quality, even though some of the reviews I read did not give this model the best reviews on sound quality and volume. All in all, the benefits for me are: Built-in speakers, Bright display, Durable, Realistic color, Lightweight, can be carried by one person. Would definitely recommend this to my friends. 4 5 P B 1
9 17 Michael 1311079049 0 127.0.0.1 A We don't get much of a choice here in Russia, really only the Iconia, Xoom & the Samsung Galaxy, so far this Iconia is my favourite. 5 224 P B 1
8 17 John 1311063983 0 127.0.0.1 A I got the Galaxy Tab over on Friday from a local BestBuy apparent they are not suppose to sell it until Monday. The screen has very wide viewing angle, I looked at the Ipad2 before I looked at the Galaxy Tab, and I couldn't tell the difference based on memory, but I'm sure Galaxy Tab is better. Though the screen is better than the Xoom which I also own. 4 224 P B 1
5 3 Customer Customer 1129559626 3 192.168.0.2 A Beautiful boots. My opinion is they are just best. 4 78 P B 1
2 1 A PC Hardware Fan 1129559367 0 192.168.0.2 A This monitor is way too light (everything appears faded out), and adjusting the contrast and brightness controls don't help. No matter what brightness contrast setting is used, everything is either way too dim & gray or way too light. The monitor's brightness & contrast controls seem to have the exact same function - contrast setting appears to actually be adjusting the brightness and nothing seems to be actually changing the contrast. This will probably be returned soon, unless someone can tell me how to get the correct brightness/contrast setting. 2 228 P B 1
4 2 Guest 1129558457 0 192.168.0.2 A I do not like. At all. 2 242 P B 1
3 2 Admin Admin 1129558427 1 192.168.0.2 A Just a perfect product! 5 242 P B 1
1 1 Customer Customer 1129547428 3 192.168.0.2 A I first noticed this monitor at one of those computer stores where they place all the monitors on the same shelf. This one really stood out for color and very sharp focus. I watch movies and play some games and I haven't noticed any ghosting. The only thing that I wish I could do is rotate the screen for word processing (kind of a minor complaint). Otherwise this is a very good monitor and the price is good for a 3D LCD. 4 228 P B 1