_NOT_QUERY: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0,3 ) as tab ORDER BY menuindex' at line 25

Query: 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