SELECT vd.id AS brand_id, vd.brand_name, vd.email, vd.vendor_type, vd.created_at, vd.is_approved, vd.status, vd.instagram_handle, vd.facebook_handle, vd.tiktok_handle, vd.is_special, vd.popularity FROM cscart_vd_vendors AS vd  WHERE 1  AND vd.is_approved = 'A'  ORDER BY vd.brand_name desc  LIMIT 64, 64

Query is invalid

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "read_sorted_file": {
          "filesort": {
            "sort_key": "vd.brand_name desc",
            "table": {
              "table_name": "vd",
              "access_type": "ALL",
              "rows": 283,
              "filtered": 100,
              "attached_condition": "vd.is_approved = 'A'"
            }
          }
        }
      }
    ]
  }
}