select cellID,min((cv*point)*90) as cv,ticketTot,`point`,lotnum ,sernum,barcode from (SELECT cv,cellID,ticketTot,`point`,lotnum ,sernum,barcode FROM mx_lottary WHERE lotTime="9:50" AND lotdate="2025-12-09" AND uID="74" group by barcode order by rand(), ticketTot desc,isadvance asc) as C group by barcode order by rand(), ticketTot DESC0543