Last active
March 16, 2024 09:15
-
-
Save mon-jai/d7ce3182c3285def70a563217e58c8ea to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
url | title | artist | playlist | position | |
---|---|---|---|---|---|
https://www.youtube.com/watch?v=p5YjEc9cGtU | APARECIUM | To sync | 0 | ||
https://www.youtube.com/watch?v=f9TH7HruP-Y | 잘 지내길 바래 | Kim Seungmin | To sync | 1 | |
https://www.youtube.com/watch?v=tcCIylFRHlQ | Young | To sync | 2 | ||
https://www.youtube.com/watch?v=W6RvzhJ4dU8 | 의류수거함 | To sync | 3 | ||
https://www.youtube.com/watch?v=GrRF9yFGCS0 | love on loop (LOL) | To sync | 4 | ||
https://www.youtube.com/watch?v=YnbhWaNnalU | Butterfly | 박준하 | To sync | 5 | |
https://www.youtube.com/watch?v=utHlhF1DG7E | On my mind | To sync | 6 | ||
https://www.youtube.com/watch?v=2lYz6l9utB4 | 2 Things | To sync | 7 | ||
https://www.youtube.com/watch?v=WuUQX7Fz8SM | Chance ) (合作演出:Peakboy (픽보이)和Peakboy) | Chan | To sync | 8 | |
https://www.youtube.com/watch?v=WuUQX7Fz8SM | Chance ) (合作演出:Peakboy (픽보이)和Peakboy) | HAAN | To sync | 8 | |
https://www.youtube.com/watch?v=E8opiI2sfjo | 우리 다투게 돼도 이것만 기억해 줄래 눈을 맞추고 서로가 서로의 손잡아 주며 낮은 목소리와 예쁜 말투로 상처 주지 않게 노력을 하고 ● | 그리즐리(Grizzly) | To sync | 9 | |
https://www.youtube.com/watch?v=3vSlfwzpTf4 | What kind of future | To sync | 10 | ||
https://www.youtube.com/watch?v=GNq84hPUafw | Beige coat | 그리즐리(Grizzly) | To sync | 11 | |
https://www.youtube.com/watch?v=HcOuoNgrhFg | 널 떠올리는 중이야 | 키드 와인 | To sync | 12 | |
https://www.youtube.com/watch?v=HcOuoNgrhFg | 널 떠올리는 중이야 | 제이씨 유카 | To sync | 12 | |
https://www.youtube.com/watch?v=HcOuoNgrhFg | 널 떠올리는 중이야 | 파테코 | To sync | 12 | |
https://www.youtube.com/watch?v=7KgUMhVlVQU | 밤 (Night) | To sync | 13 | ||
https://www.youtube.com/watch?v=5BH1XVaIAMc | 사랑이 아닌 단어로 사랑을 말해요 | To sync | 14 | ||
https://www.youtube.com/watch?v=7B-13RrLZA8 | Leave (Prod. PATEKO) | To sync | 15 | ||
https://www.youtube.com/watch?v=Ux1iX-Y5lW8 | PILLOW | To sync | 16 | ||
https://www.youtube.com/watch?v=r04O1Twg968 | Amor | To sync | 17 | ||
https://www.youtube.com/watch?v=e_-U6M_Nq-U | What was that | To sync | 18 | ||
https://www.youtube.com/watch?v=C0wHFZ_B4sg | Say I Love You | To sync | 19 | ||
https://www.youtube.com/watch?v=Dtpc5t13gl4 | Good Bye (合作演出:KIMMUSEUM) | To sync | 20 | ||
https://www.youtube.com/watch?v=35e-Kkd-_pI | 흘려보내 (It's All Good) | To sync | 21 | ||
https://www.youtube.com/watch?v=aDAATq7pb9U | YOU AND I | To sync | 22 | ||
https://www.youtube.com/watch?v=YqPCzTSgXZo | After a few summers (My love X TOIL, Gist) | To sync | 23 | ||
https://www.youtube.com/watch?v=npacTDziTcA | 3 2 1 | To sync | 24 | ||
https://www.youtube.com/watch?v=BRSU44qAsg4 | 사랑노래 | dori | To sync | 25 | |
https://www.youtube.com/watch?v=MftH94rRj6Y | Rewind (合作演出:SOLE) | To sync | 26 | ||
https://www.youtube.com/watch?v=E0sjqspwMoQ | Take care | To sync | 27 | ||
https://www.youtube.com/watch?v=tQLdAiPKlDE | 금방 도착해 (合作演出:프리든 (FR:EDEN)和yourbeagle) | To sync | 28 | ||
https://www.youtube.com/watch?v=hSXHHeaxloQ | 난 너를 보면 When I See You (合作演出:吉米·布朗) | To sync | 29 | ||
https://www.youtube.com/watch?v=_KmCy56WvjY | Like We Turn the pages | To sync | 30 | ||
https://www.youtube.com/watch?v=zcm6b9661no | OUT OF MY SIGHT | To sync | 31 | ||
https://www.youtube.com/watch?v=wEqQkhhubdI | Special Request (合作演出:Boni) | Wilcox | To sync | 32 | |
https://www.youtube.com/watch?v=eFcI7q1h-1g | Say Yes | 로꼬 | To sync | 33 | |
https://www.youtube.com/watch?v=eFcI7q1h-1g | Say Yes | 펀치 (Punch) | To sync | 33 | |
https://www.youtube.com/watch?v=bqgfzySCitI | Talk tomorrow | To sync | 34 | ||
https://www.youtube.com/watch?v=H5mKUVo89sA | LEON - MAGNOLIA. | 가사 (Lyrics) | To sync | 35 | ||
https://www.youtube.com/watch?v=NEEYDEH43ak | LA SOL MI | To sync | 36 | ||
https://www.youtube.com/watch?v=ZWtT6jVfzOo | PALETTE 팔레트 | To sync | 37 | ||
https://www.youtube.com/watch?v=EXtIEyMgJAk | Bookend | To sync | 38 | ||
https://www.youtube.com/watch?v=49j5w3DZp0Q | 말해줘 | To sync | 39 | ||
https://www.youtube.com/watch?v=EWEjALLh1YQ | 네가 듣기를 | To sync | 40 | ||
https://www.youtube.com/watch?v=g6nvfZ4s-sU | Our Memories | To sync | 41 | ||
https://www.youtube.com/watch?v=W7bccZ5Iw7M | Happy Ending | WR | To sync | 42 | |
https://www.youtube.com/watch?v=W7bccZ5Iw7M | Happy Ending | 에이든 | To sync | 42 | |
https://www.youtube.com/watch?v=fzHkwh1VWWM | Maybe it'll be the last time (合作演出:Ayul) | 뎁트 | To sync | 43 | |
https://www.youtube.com/watch?v=KhCHWLCf26M | 이런 내 맘 | To sync | 44 | ||
https://www.youtube.com/watch?v=VcxuSqIa-z8 | HANGANG (合作演出:BIG Naughty) | To sync | 45 | ||
https://www.youtube.com/watch?v=RIMsqb-1aCo | orange | 콜린 | To sync | 46 | |
https://www.youtube.com/watch?v=vm3T2sdeIOY | Boat | To sync | 47 | ||
https://www.youtube.com/watch?v=aqw3o-eWe_M | 내일이 있잖아 (feat. Jayci yucca (제이씨 유카)) | To sync | 48 | ||
https://www.youtube.com/watch?v=bwgl3X1q5bQ | Girlfriend | dori | To sync | 49 | |
https://www.youtube.com/watch?v=frOlxVcxCro | 대충 입고 나와 Natural | To sync | 50 | ||
https://www.youtube.com/watch?v=6Bs-YqjlRf0 | Rain Song (合作演出:Colde) | To sync | 51 | ||
https://www.youtube.com/watch?v=5-QVKnoHLfw | Stupid | To sync | 52 | ||
https://www.youtube.com/watch?v=AZu138zEtn8 | Comin' Through | To sync | 53 | ||
https://www.youtube.com/watch?v=aaPSnf2SqVs | Hate | eldon | To sync | 54 | |
https://www.youtube.com/watch?v=OlXr5YD-MWA | Beyond Love (Feat. 10CM) (정이라고 하자 ) (feat. 10CM) | To sync | 55 | ||
https://www.youtube.com/watch?v=csdBrz_544U | MOVIE | To sync | 56 | ||
https://www.youtube.com/watch?v=h0ccMK0U9nY | Alone (合作演出:LeeHi) | To sync | 57 | ||
https://www.youtube.com/watch?v=zHd1JcExu1k | Attraction(갖고놀래) ) (合作演出:Dynamic Duo) | To sync | 58 | ||
https://www.youtube.com/watch?v=dJRkhdWsu_M | Officially Missing You | To sync | 59 | ||
https://www.youtube.com/watch?v=7B6zArUXVbE | Episode (에피소드) | To sync | 60 | ||
https://www.youtube.com/watch?v=yXgwR66k2MY | I′ll be there (合作演出:Gist和Han Yo Han) | To sync | 61 | ||
https://www.youtube.com/watch?v=LJrxa5kej6A | Ordinary Confession | To sync | 62 | ||
https://www.youtube.com/watch?v=jLmWEWvn0QY | After Love (合作演出:Han Yo Han) | 키드 와인 | To sync | 63 | |
https://www.youtube.com/watch?v=jLmWEWvn0QY | After Love (合作演出:Han Yo Han) | 제이씨 유카 | To sync | 63 | |
https://www.youtube.com/watch?v=jLmWEWvn0QY | After Love (合作演出:Han Yo Han) | 파테코 | To sync | 63 | |
https://www.youtube.com/watch?v=LDDSPMGqJXw | Still (合作演出:LIPNINE和OUREALGOAT) | To sync | 64 | ||
https://www.youtube.com/watch?v=PK02_Q5hHKo | Rainy day (合作演出:Skinny Brown和ASH ISLAND) | To sync | 65 | ||
https://www.youtube.com/watch?v=2VkWaOOF4Rc | 가까운 듯 먼 그대여 (Closely Far Away) | To sync | 66 | ||
https://www.youtube.com/watch?v=-0T0Qb5RW7I | Think About You | To sync | 67 | ||
https://www.youtube.com/watch?v=wZgsxnYqHps | Black Heart (feat. Leellamarz & BE′O) | To sync | 68 | ||
https://www.youtube.com/watch?v=EjpnDnUR1KM | GONE | To sync | 69 | ||
https://www.youtube.com/watch?v=tfXQJlYZI3U | unplugged boy | TWS | To sync | 70 | |
https://www.youtube.com/watch?v=k5--FlrIkjM | i'm so tired.. (feat. THAMA) | To sync | 71 | ||
https://www.youtube.com/watch?v=swyfsFsuVS4 | One of a Kind (feat. Sarah Kang) | To sync | 72 | ||
https://www.youtube.com/watch?v=bwgl3X1q5bQ | Girlfriend | dori | To sync | 73 | |
https://www.youtube.com/watch?v=G2uB49Tf0oc | Sketch | Korean R&B Soul | 1 | ||
https://www.youtube.com/watch?v=zjonG8y8JqI | Your Dog Loves You (合作演出:Crush) | Colde (콜드) | Korean R&B Soul | 19 | |
https://www.youtube.com/watch?v=N9AND2vjruI | OCEAN (合作演出:Hoyeon Kim) | Korean R&B Soul | 20 | ||
https://www.youtube.com/watch?v=2mcgfLkNdgs | Love song (合作演出:Sonny Zero和prettyhappy) | Korean R&B Soul | 22 | ||
https://www.youtube.com/watch?v=lE-oKzXbnPA | House party (合作演出:Ashley Alisha和Sonny Zero) | Korean R&B Soul | 25 | ||
https://www.youtube.com/watch?v=n9PX7hKmpbQ | Picture | Korean R&B Soul | 32 | ||
https://www.youtube.com/watch?v=OI_D8dGCCUM | Like We Turn the Pages | homezone | Korean R&B Soul | 33 | |
https://www.youtube.com/watch?v=RuQ0PAprbEo | Back to You | Korean R&B Soul | 34 | ||
https://www.youtube.com/watch?v=uCkRX8dnViI | Swim | Korean R&B Soul | 35 | ||
https://www.youtube.com/watch?v=K_kxh2rFlcQ | day off | Korean R&B Soul | 39 | ||
https://www.youtube.com/watch?v=Pi3BsZKflNY | Let Me Know (K-Pop Version) | Korean R&B Soul | 44 | ||
https://www.youtube.com/watch?v=Fi0seIkfQvE | Symphony | Korean R&B Soul | 45 | ||
https://www.youtube.com/watch?v=aH0l8tPYJoQ | steam | Korean R&B Soul | 46 | ||
https://www.youtube.com/watch?v=o-NWHY0CisU | SCOPE | Korean R&B Soul | 50 | ||
https://www.youtube.com/watch?v=mmnfTWAn32g | 8'O Clock | Korean R&B Soul | 54 | ||
https://www.youtube.com/watch?v=bZ7eKU3Ovs8 | HERO (合作演出:Mirani) | Korean R&B Soul | 55 | ||
https://www.youtube.com/watch?v=_jt_ZJ4jCPY | huge mood | Korean R&B Soul | 73 | ||
https://www.youtube.com/watch?v=_ZMEBNr_VUc | cocoa | Korean R&B Soul | 78 | ||
https://www.youtube.com/watch?v=oouhW_n3SNk | Mom | Korean R&B Soul | 87 | ||
https://www.youtube.com/watch?v=g6nvfZ4s-sU | Our Memories | Korean R&B Soul | 90 | ||
https://www.youtube.com/watch?v=9h5aKG_6yFE | We Need to Talk (合作演出:OLNL) | Korean R&B Soul | 92 | ||
https://www.youtube.com/watch?v=t8F8-5V12Nc | Paint Laurent | Korean R&B Soul | 93 | ||
https://www.youtube.com/watch?v=TwXp-r30-Lw | Give Me Something (合作演出:루디밀러(Ruddie Miller)) | Korean R&B Soul | 95 | ||
https://www.youtube.com/watch?v=MUk7HzEut-s | Door | Korean R&B Soul | 101 | ||
https://www.youtube.com/watch?v=pTVUKrvdOGA | you got it | Korean R&B Soul | 118 | ||
https://www.youtube.com/watch?v=AbVBf-ymJ5E | You & Dive | Korean R&B Soul | 123 | ||
https://www.youtube.com/watch?v=NK6PFJ-HCes | Good Bye (合作演出:KIMMUSEUM) | Korean R&B Soul | 135 | ||
https://www.youtube.com/watch?v=zyZ8CL8stww | I`m In Love | Korean R&B Soul | 138 | ||
https://www.youtube.com/watch?v=49j5w3DZp0Q | 말해줘 | Korean R&B Soul | 143 | ||
https://www.youtube.com/watch?v=bwgl3X1q5bQ | Girlfriend | dori | Korean R&B Soul | 144 | |
https://www.youtube.com/watch?v=5-QVKnoHLfw | Stupid | Korean R&B Soul | 145 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select | |
"https://www.youtube.com/watch?v=" || song.id as url, | |
song.title, | |
artist.name as artist, | |
playlist.name as playlist, | |
position | |
from | |
song | |
left join album_artist_map on song.albumid = album_artist_map.albumid | |
left join artist on artistid = artist.id | |
join playlist_song_map on song.id = playlist_song_map.songid | |
join playlist on playlist_song_map.playlistid = playlist.id | |
where | |
playlistid in (select id from playlist where name = "To sync") or | |
( | |
playlistid in (select id from playlist where name = "Korean R&B Soul") and | |
-- console.log(JSON.stringify([...document.querySelectorAll("ytd-playlist-video-renderer:not([style-type=playlist-video-renderer-style-recommended-video]) a#video-title")].map(a => new URL(a.href).searchParams.get("v")))) | |
song.id not in ("pbNs7tAUFkk", "YnbhWaNnalU", "Z1KC6MbMP0E", "J6T20-1OzQs", "BRSU44qAsg4", "PpvnbuEdsAI", "FjeMSl0mJn8", "6Wc9f58Cjkg", "MOGORrUJn5Q", "_TEC725XtQI", "Xp6i0hh-Xb4", "oIWH9TMM1uM", "fMWtXjzJZe8", "M10dlRWr6KA", "E8opiI2sfjo", "OsL79kVNjZA", "x603ANFLOcc", "iOb3Q0QocvI", "q_3gmzmJQ4M", "AJ75-7IIjRs", "Gv8yd4txLvY", "ejj2s-bJno0", "R-rSZnqY3Vo", "dyoqm5HUOqo", "s_54B-xxYOw", "H0b88oUtbcQ", "gFb1TftvdoM", "uQHOi4V_7hs", "uB_9BbWKseQ", "2sbUuHVB3TQ", "AuQQzpVKvHM", "3-CtmsyVF5Y", "ZQHb41O77Xc", "UUaWYfnNKQs", "HRJZPSP0-8w", "p425gzmQr5o", "i8-viRyJm44", "3oesYjxdpsQ", "GklAb-7WmoQ", "4TFBumOpRvo", "RLl1isnpKjw", "mVdGOiLexc0", "lOTIc1clr24", "mOEQ0k3Ov9U", "Xf1pbexFs0w", "emFqcsqJMIs", "vAa8R_ze6ZI", "Aon-n3hLSto", "bfNfCk81lEc", "GYxoW3aPDLI", "T-_IDNq3A2E", "-0T0Qb5RW7I", "2COAu1l6hUQ", "ZRXv71PIjaU", "PD_ta-pPwJ4", "SURytqHIW4k", "dL933fNCWVo", "5ogEEJxWVUA", "FFi7GGsZYX0", "bDG08FNHY5Y", "LauCe3Hj82I", "tEEj-UbCMa0", "eBqWK8FSJ6k", "2lYz6l9utB4", "LZZNQNh_VOE", "awTnfmRDPFE", "Gdw8O_z6CFc", "gBxW1ZmiKvo", "fGOZuM_PkFI", "V485sQFzH_Y", "MadQD32SHbs", "9r0EqOIELbs", "NVxpUvaaFUk", "mi40n_wLakk", "KJkYPC-Lc6k", "aXs4L6weqEI", "WCecY4at8Hs", "nBoBoN81CP8", "-Xdl-vnfbkE", "Ev-7DoHXcEc", "K-YZgcDXxSE", "oBHiTpGjgQ4", "ZZ6JT3h9Zjc", "vVI20mtY2m4", "GawcBhdIS28", "xY96vqtMTA0", "TMWM8yAR8jA", "0rTs4K-P3PE", "DMqk_h3SJEE", "SVpRheYgnMI", "Sp_Z2tBVniI", "g2mbvJC7zVY", "O4GV8qtMj8s", "rfEwWdFoshQ", "3COtfQxYQQY", "C_RkY2mxzDg", "eCxsQycskp0", "ouoCpQHLuzQ", "JJSJASLaLpA", "7nP98vbUc0Y", "N2nxrFUHwWI", "f-4TnQfhhQM", "eHs567_GHWU", "-mD9vXVv0Xs", "V2Ca_9EAI9E", "BrKjA3wb2OQ", "IFg07zaCIVA", "A_cqn2lSLC0", "2zWoXGKrgx8", "v6_xBkJdgkU", "SXsRmgBiTdk", "G-2Kd40JWMQ", "E5NSwcCo8o4", "_8CBV5P1W_A", "PPvj4-1YcdA", "F4XiX3QZ-48", "CR_fsOGEig8", "VERztkyg3iw", "-F1G2vgta6o", "a3rUjsz07Z0", "3l72P-Ow3Qw", "j076MB9E8IE", "uEol_CTmvn4", "GNq84hPUafw", "7WbDdcp6bJk", "gwOQl2SQdkw") | |
) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment