#1064 - 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 'group by id limit 20'

SELECT derivedtable.* FROM (

select column1,column2,column3 match(sutun1,sutun2) against('aranan' IN BOOLEAN MODE) AS newscore FROM tablo1 where match(sutun1,sutun2) against('aranan' IN BOOLEAN MODE)

union

select column1,column2,column3 match(sutun1,sutun2) against('aranan' IN BOOLEAN MODE) AS newscore FROM tablo2 where match(sutun1,sutun2) against('aranan' IN BOOLEAN MODE)

) as derivedtable order by newscore DESC group by id limit 20