SELECT 
  discussion_posts.*, 
  discussion_messages.message, 
  discussion_rating.rating_value 
FROM 
  discussion_posts 
  LEFT JOIN discussion_messages ON discussion_messages.post_id = discussion_posts.post_id 
  LEFT JOIN discussion_rating ON discussion_rating.post_id = discussion_posts.post_id 
WHERE 
  discussion_posts.thread_id = 8883 
  AND discussion_posts.status = 'A' 
ORDER BY 
  discussion_posts.timestamp DESC 
LIMIT 
  0, 10

Query time 0.00071

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1.28"
    },
    "ordering_operation": {
      "using_filesort": true,
      "nested_loop": [
        {
          "table": {
            "table_name": "discussion_posts",
            "access_type": "ref",
            "possible_keys": [
              "thread_id",
              "thread_id_2"
            ],
            "key": "thread_id",
            "used_key_parts": [
              "thread_id"
            ],
            "key_length": "3",
            "ref": [
              "const"
            ],
            "rows_examined_per_scan": 3,
            "rows_produced_per_join": 0,
            "filtered": "10.00",
            "cost_info": {
              "read_cost": "0.75",
              "eval_cost": "0.03",
              "prefix_cost": "1.05",
              "data_read_per_join": "134"
            },
            "used_columns": [
              "post_id",
              "thread_id",
              "name",
              "timestamp",
              "user_id",
              "ip_address",
              "status"
            ],
            "attached_condition": "(`goimagine`.`discussion_posts`.`status` = 'A')"
          }
        },
        {
          "table": {
            "table_name": "discussion_messages",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "post_id"
            ],
            "key_length": "3",
            "ref": [
              "goimagine.discussion_posts.post_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 0,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.10",
              "eval_cost": "0.03",
              "prefix_cost": "1.18",
              "data_read_per_join": "7"
            },
            "used_columns": [
              "message",
              "post_id"
            ]
          }
        },
        {
          "table": {
            "table_name": "discussion_rating",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "post_id"
            ],
            "key_length": "3",
            "ref": [
              "goimagine.discussion_posts.post_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 0,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.08",
              "eval_cost": "0.03",
              "prefix_cost": "1.28",
              "data_read_per_join": "4"
            },
            "used_columns": [
              "rating_value",
              "post_id"
            ]
          }
        }
      ]
    }
  }
}

Result

post_id thread_id name timestamp user_id ip_address status message rating_value
1342 8883 Tiffany Martin 1649788740 10049 4450ef87 A I'd leave 6 stars if possible! This maker went out of their way to confirm my order. The item beautifully packaged and shipped in a timely manner 5
1341 8883 Tiffany 1649788680 0 4450ef87 A I'd give this marker 6 stars if possible! 5
1335 8883 Tiffany Martin 1649775720 10049 4450ef87 A This was my first purchase off the this marketplace and if this is beginning of this venture, I am beyond excited to see what is to come. This maker took the time to reach out to me personally to confirm my order details. Not only did my item arrive fast, it was carefully packaged and shipped in a lovely gift box. The quality of my dog's tag is superb. I'd give 6 stars if it was an option! 5