musiccaps_details (view)
1 row where musiccaps_aspects contains "low quality", musiccaps_names contains "Electronic tuner" and "youtube_published" is on date 2012-03-24
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| How to make BUN BO HUE - Vietnamese Spicy Beef Noodle Soup | Helen's Recipes | The low quality song features a country song that consists of an acoustic rhythm guitar chord progression over which a mellow male vocal is singing. The recording got noisy at the end of the loop, which sounded like a microphone was turned on. It sounds vintage, warm, happy and fun. | 2012-03-24T22:44:31Z | Helen's Recipes (Vietnamese Food) | Ingredients: For 6-8 servings (1kg = 2,2 lb) - 1kg pork trotters (pig's front feet) - 1kg beef shank - 1kg beef/pork bone - 1kg rice vermicelli noodle - 5 stalk lemon grass - 1tbsp minced lemongrass - 1tbsp minced garlic - 1tbsp minced shallot - 1tbsp chili powder - fresh greens: herbs (mint, Viet mint rau ram, Thai basil), bean sprout, banana blossom, shredded lectuce/ cabbage, split water spinach etc. - lime, sugar, salt, fish sauce - 2 tbsp Vietnamese shrimp sauce (mam ruoc) -Optional: blood cubes, Vietnamese shrimp patties, Vietnamese ham ►Full recipe | Xem công thức đầy đủ : https://helenrecipes.com ► GET MY COOKBOOKS | Đặt mua sách nấu ăn của Helen http://helenrecipes.com/cookbook/ ►Subscribe for NEW VIDEO EVERY FRIDAY (Turn on the BELL icon to get notified for new uploads) | Đăng ký kênh & ấn vào chuông để nhận thông báo khi có video mới: https://bit.ly/36S0p0I ►Items in my kitchen: www.amazon.com/shop/helenrecipes Các sản phẩm trong bếp nhà Helen: https://shopee.vn/m/Helenrecipe ►My Instagram: http://instagram.com/helenrecipes/ ►Facebook | Cập nhập ý tưởng nấu nướng mỗi ngày https://www.facebook.com/Helenrecipes ► Support on Patreon https://www.patreon.com/helenrecipes ►Some of your favorites | Các video được yêu thích nhất: Best ever Pho Recipe | Phở: https://youtu.be/EpRBxau3ou0 Original Bun Bo | Bún Bò Huế: https://youtu.be/4222YFNqDP8 Vietnamese Baguette | Bí Kiếp Bánh Mì Gia Truyền: https://youtu.be/Dz9r3vNRxPA Cooking with Grandma | Vào Bếp cùng Ngoại: https://youtu.be/UkZL4Dkjqpg All Vietnamese desserts | Các món tráng miệng https://bit.ly/3rAMEvn Everyday family meals | Bữa cơm gia đình https://bit.ly/3jzuiZ0 #HelenRecipes #vietnamesefood #vietnameserecipes Music by KÁ http://www.facebook.com/dungranka/app_178091127385 "Don't think twice it's alright" "A morning song" "Sparrow sparrow" | ["Music", "Electronic tuner"] | ["low quality", "noisy", "acoustic rhythm guitar", "mellow male vocal", "happy", "fun", "country"] | 4 | eOmQbJljnqE | 3858 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW musiccaps_details AS select
musiccaps.url as video,
json_object(
'label',
coalesce(videos.title, 'Missing from YouTube'),
'href',
musiccaps.url
) as youtube_link,
musiccaps.caption as musiccaps_caption,
videos.publishedAt as youtube_published,
videos.channelTitle as youtube_channel,
videos.description as youtube_description,
musiccaps.audioset_names as musiccaps_names,
musiccaps.aspect_list as musiccaps_aspects,
musiccaps.author_id as musiccaps_author,
videos.id as youtube_id,
musiccaps.rowid as musiccaps_rowid
from
musiccaps
left join videos on musiccaps.ytid = videos.id;