SELECT *
FROM
(
SELECT
f.*,
fc.alias as alias1
FROM
reg_firms as f
LEFT JOIN
reg_firms_cat as fc
ON fc.id = f.id_type
WHERE
f.id_type =
LIMIT 0,3
) as tab
ORDER BY menuindex