SELECT @rownum := @rownum+1 AS rnum
, ftb.*
FROM (SELECT * FROM goodstbl WHERE 1=1) ftb
, (SELECT @rownum :=0) AS R
ORDER BY rnum desc
LIMIT 0, 10;
SELECT @rownum:=@rownum+1 AS rnum, G.*, F.*
FROM goodstbl G LEFT JOIN firmtbl F
ON G.userId = F.firmId
, (SELECT @rownum:=0) TMP
ORDER BY rnum desc
LIMIT 0, 10