Method 1
mysql -e "select * from vicidial_list order by entry_date desc limit 100\G;" asterisk
Method 2
database name asterisk
select asterisk;
MariaDB [asterisk]> select * from vicidial_list order by entry_date desc limit 10\G;
*************************** 1. row ***************************
lead_id: 2874301
entry_date: 2021-06-14 16:57:51
modify_date: 2021-06-14 16:58:18
status: SVYHU
user: VDAD
vendor_lead_code: 999999
source_id: NULL
list_id: 998
gmt_offset_now: 0.00
called_since_last_reset: Y
phone_code:
phone_number: 393333635186
title: NULL
first_name: Test
middle_initial: NULL
last_name: Call
address1: Test Call
address2: 2
address3: 3
city: Springfield
state: IL
province: NULL
postal_code: NULL
country_code: NULL
gender: U
date_of_birth: NULL
alt_phone: NULL
email: NULL
security_phrase: 6
comments: ROBOCALL test call placed 2021-06-14 16:57:51
called_count: 1
last_local_call_time: 2021-06-14 16:57:51
rank: 99
owner: Test Outbound Call
entry_list_id: 0
http://www.eflo.net/VICIDIALforum/viewtopic.php?f=2&t=38605
