select `songs`.*, `artist_song`.`artist_id` as `pivot_artist_id`, `artist_song`.`song_id` as `pivot_song_id` from `songs` innerjoin `artist_song` on `songs`.`id` = `artist_song`.`song_id` where `artist_song`.`artist_id` =147and `published` =1orderby `id` desc