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 (17409) 
  AND cscart_discussion_posts.status = 'A' 
ORDER BY 
  cscart_discussion_posts.timestamp DESC 
LIMIT 
  0, 10

Query time 0.00069

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": 4,
          "filtered": 100,
          "index_condition": "cscart_discussion_posts.`status` = 'A'",
          "attached_condition": "cscart_discussion_posts.thread_id <=> 17409 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
116401 17409 TS RE 1443490020 0 68.193.178.159 A Great unique product of high quality. Used to build industrial/modern fixture. A bit too expensive though. 5
16762 17409 Patty Sanders 1397868120 0 68.164.10.49 A I ordered the 975 canopy to create a fixture with vapor lights I already had in storage for my workroom. Recently got the parts I needed to create the fixture. Now I can have proper lighting in my workroom and save my eyes from damage. Thank you Barn Electric for being here. 5
1048 17409 Treasurehunter 1370103240 0 98.154.172.26 A I used it to go with antique barn light. Wish it was a bit tarnished to match with other galvanized parts on the light. It is well made. 5
947 17409 Albany landlord 1366335240 0 96.236.44.228 A For those of you wondering, the thread on this is an exact match for 1/2" black pipe. I made my own light fixture from black pipe and a pot rack with lighting and these were a very strong and secure way to mount them over the electric box. The price is crazy high for what it is, I would rather see it made out of cheaper steel than aluminum for my application. And it is power coated to order, though I didn't really need that either. But it is the only thing I could find anywhere that solved my problem. The owner was very responsive and helpful in answering my questions. 4