SLIK BESTEMMES P3-MUSIKKEN
SELECT p3s.tid_spilt, sa.artistnavn_visning, sl.laat_id, sl.laat_tittel_visning, sa.artistbilde_lastfm, p3p.pid, p3p.programtittel, p3p.program_url, p3p.podkast_url, p3p.program_bilde_url, p3p.nrk_radio_serienavn, lm.spotify_track_href, lm.info_artikkel_url, lm.youtube_url, lm.p3_beskrivelse
FROM sjef_laater sl, sjef_artister sa, p3_programmer p3p, p3_spillelister p3s
LEFT JOIN p3_spillelister_laat_meta lm ON lm.laat_id = p3s.laat_id
WHERE p3s.laat_id = sl.laat_id
AND sl.artist_id = sa.artist_id
AND p3s.program_id = p3p.pid AND p3p.pid = '30' ORDER BY p3s.tid_spilt DESC
LIMIT 100
9. september 2013
|
 Radioresepsjonens Valgvake
|
| 23:50 | Freedom Of '76 Ween | Spotify |
| 23:36 | Sun Hits The Sky (Radio Edit) Supergrass | Spotify |
| 23:35 | Somebody's Baby Jackson Browne | Spotify |
| 23:21 | The Fox (What Does The Fox Say?) Ylvis | Spotify |
| 23:19 | Bad Reputation Thin Lizzy | Spotify |
| 23:05 | Where Can I Go Laura Marling | Spotify |
| 23:02 | The '59 Sound The Gaslight Anthem | Spotify |
| 22:52 | Running To The Sea Röyksopp + Susanne Sundfør | Spotify |
| 22:42 | The Concept Teenage Fanclub | Spotify |
| 22:28 | The Thread Art Garfunkel + Maia Sharp + Buddy Mondlock | Spotify |
| 22:22 | Strövtåg I Hembygden Mando Diao | Spotify |
| 22:15 | Learn To Fly Foo Fighters | Spotify |
| 22:00 | I'm Shakin' Jack White | Spotify |
13. september 2011
|
| 00:55 | Knives Out Radiohead | Spotify |
| 00:50 | On A Rope Rocket From The Crypt | Spotify |
| 00:43 | Only Love Can Break Your Heart YOUNG, NEIL (CAN) & CRAZY HORSE (USA) | Spotify |
| 00:33 | Night By Night Steely Dan | Spotify |
| 00:26 | Don't Let Go Weezer | Spotify |
| 00:13 | Truth Hits Everybody The Police | Spotify |
| 00:09 | Somebody's Baby Jackson Browne | Spotify |
12. september 2011
|
| 23:58 | Wonderous Stories Yes | Spotify |
| 23:50 | Fools Gold The Stone Roses | Spotify |
| 23:41 | Little Sparrow Dolly Parton | Spotify |
| 23:30 | Offernatt Kvelertak + Ryan McKenney | Spotify |
| 23:19 | Badlands Bruce Springsteen & The E-Street Band | Spotify |
| 23:09 | Tom Sawyer Rush | Spotify |
| 23:05 | Benediction Thurston Moore | Spotify |
| 22:54 | Even If You Don't Ween | Spotify |
| 22:41 | Follow You, Follow Me Genesis | Spotify |
| 22:35 | All New Low The Hellacopters | Spotify |
| 22:32 | Run Of The Mill George Harrison | Spotify |
| 22:21 | Step On Happy Mondays | Spotify |
| 22:09 | In France They Kiss On Main Street Joni Mitchell | Spotify |
| 22:00 | Bridge Burning Foo Fighters | Spotify |
Tips: Du kan finne spillelister til et bestemt program ved å bruke programvelgeren til høyre over lista.
For vurdering av musikk til P3s spillelister, kontakt musikkprodusenterP3@nrk.no.
Radioresepsjonens Valgvake