Select Code to Download

#Last record Tested Good
       
...
   WHERE lastname >='z%' AND lastname >= 'a%'
   ORDER BY user_id DESC LIMIT 1 ) sub
   ORDER BY lastname ASC #Works fine hard coded

   SELECT * FROM ( 
   SELECT * FROM users 
   WHERE lastname <='z%' AND lastname >= 'a%'
   ORDER BY user_id DESC LIMIT 1 ) sub
   ORDER BY lastname ASC

SELECT * FROM users 
ORDER BY lastname DESC
LIMIT 1