使用GROUP_CONCAT在查询中忽略LIMIT

I need to select some rows from second table and concatenate them in comma-separated string. Query works well except one problem - It always selects all rows and ignores LIMIT.I need to select some rows from second table an