Drama OST

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'pmm.mptype ='video' ORDER BY po.post_date DESC LIMIT 8' at line 4]
SELECT * FROM wpkn_postmeta pm LEFT JOIN wpkn_posts po ON pm.post_id = po.ID LEFT JOIN(SELECT meta_key as song_type, meta_value as mptype, post_id FROM wpkn_postmeta WHERE meta_key ='song_type') as pmm ON pmm.post_id=pm.post_id WHERE pm.meta_key ='song_genre' AND pm.meta_value REGEXP '"183"' pmm.mptype ='video' ORDER BY po.post_date DESC LIMIT 8