Skip to content

Instantly share code, notes, and snippets.

@mon-jai
Last active March 16, 2024 09:15
Show Gist options
  • Save mon-jai/d7ce3182c3285def70a563217e58c8ea to your computer and use it in GitHub Desktop.
Save mon-jai/d7ce3182c3285def70a563217e58c8ea to your computer and use it in GitHub Desktop.
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
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