SET @counter=0;
select @counter:=@counter+1 AS _id, a.* FROM live a WHERE liveroom_id = 1 ORDER BY start_time DESC,id DESC

以上查询 在使用sqls的时候需要怎么做？