SELECT 
  cscart_discussion_posts.*, 
  cscart_discussion_messages.message, 
  cscart_discussion_rating.rating_value 
FROM 
  cscart_discussion_posts 
  LEFT JOIN cscart_discussion_messages ON cscart_discussion_messages.post_id = cscart_discussion_posts.post_id 
  LEFT JOIN cscart_discussion_rating ON cscart_discussion_rating.post_id = cscart_discussion_posts.post_id 
WHERE 
  cscart_discussion_posts.thread_id IN (18148) 
  AND cscart_discussion_posts.status = 'A' 
ORDER BY 
  cscart_discussion_posts.timestamp DESC 
LIMIT 
  0, 10

Query time 0.00087

JSON explain

{
  "query_block": {
    "select_id": 1,
    "read_sorted_file": {
      "filesort": {
        "sort_key": "cscart_discussion_posts.`timestamp` desc",
        "table": {
          "table_name": "cscart_discussion_posts",
          "access_type": "ref",
          "possible_keys": ["thread_id", "thread_id_2"],
          "key": "thread_id_2",
          "key_length": "6",
          "used_key_parts": ["thread_id", "status"],
          "ref": ["const", "const"],
          "rows": 8,
          "filtered": 100,
          "index_condition": "cscart_discussion_posts.`status` = 'A'",
          "attached_condition": "cscart_discussion_posts.thread_id <=> 18148 and cscart_discussion_posts.`status` <=> 'A'"
        }
      }
    },
    "table": {
      "table_name": "cscart_discussion_messages",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["post_id"],
      "ref": ["cscart_migrate.cscart_discussion_posts.post_id"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "cscart_discussion_rating",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["post_id"],
      "ref": ["cscart_migrate.cscart_discussion_posts.post_id"],
      "rows": 1,
      "filtered": 100
    }
  }
}

Result

post_id thread_id name timestamp user_id ip_address status email message rating_value
119372 18148 Judy Reina 1464446220 0 71.94.52.244 A I purchased two of these sconces in Delphite Blue. Installed in my guest bathroom which has a very coastal feel. They were PERFECT! Not only are they gorgeous, the quality is beyond exceptional. Super heavy duty and manufactured here in the good old USA! I get lots of positive comments on my Barn Lights. I will be purchasing more when I do my next bathroom remodel. I am a very happy customer. Thank you Barn Light! 5
118234 18148 Steven D Smith 1455894300 0 12.48.222.101 A Heavyweight, beautiful, practical fixtures! They look great on our 1934 service station building. Much, much higher quality than the other fixtures we reviewed. 5
116702 18148 Beth 1446943800 0 71.86.240.79 A We installed this sconce in our daughter's room. It is post and beam construction with a horse barn theme. The light is perfect! She loves it and so do we. The construction is excellent. 5
108762 18148 Lauren 1429991340 0 68.185.84.217 A We ordered 5 of these in dark green/heavy duty cast guard/ribbed glass. Our electrician who installed them on the back side of our home said they were to highest quality outdoor lights he'd ever worked with. We absolutely LOVE these lights. When they say "heavy duty" they mean it! But minus the "gaudy" feel associated with "heavy duty" decor. These look fantastic! We have no doubts they will make us happy for years to come. 5
106567 18148 Bonnie York 1427663220 1032951 24.176.217.82 A We bought 3 of these powder coated beauties to put on the back of our home with the wire cast guards and clear crackle glass. They added so much class and character to our home. They are quality workmanship. We have bought several products from this company and plan to purchase more. We love their service and their products. 5
105644 18148 Jay Dougherty 1426962660 0 68.15.62.157 A Just by picking these units out of the box you can tell the quality of their construction, not to mention they look great! 5
71161 18148 Jean Ochsner 1414701960 0 73.37.79.58 A I purchased the streamline industrial guard lights in galvanized finish (guard and light). These lights are heavy duty and can take the elements. We get driving rain with winds excess of 70 mph. I won't have any worries with these lights! 5
16886 18148 scott merrell 1398454140 0 94.142.186.1 A I purchased three of these lights and had them painted in marine grade black paint to combat the harsh Galveston coast elements. the style of the lights compliment my Gooseneck and Soho lights that i also purchased. these lights are excellent quality and look amazing. i've gotten so many compliments. 5