musiccaps_details (view)
1 row where musiccaps_aspects contains "drone", musiccaps_aspects contains "electronic bagpipe" and "youtube_published" is on date 2011-07-23
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 |
---|---|---|---|---|---|---|---|---|---|---|
Ross Electronic Bagpipes | Solo electronic bagpipe. | 2011-07-23T20:35:19Z | Mississippi Mike | The video is a review for the product I have bought, the Ross Electronic Bagpipe, by William Ross, of Ross Technologies. William Ross is a great guy and he designed and built the instrument himself. Ross, you got my endorsement. I'm extremely happy with the product, it's simply amazing. The shipping was faster than greased-up lightening, the price was more than affordable and seller communication was outstanding, friendly and professional. Again, I couldn't be happier to share my experience and recommend the product, which can be found right here: http://myworld.ebay.com/ailwil/?_trksid=p4340.l2559 If you're looking for electronic bagpipes, I wouldn't hesitate at all buying this model. And the song, well, you can hear and make your own conclusions, I think it sounds awesome and it actually surprised me and blew me away of how good it is, exceeding all my expectations. Ross Technologies have a fine product for an EXCELLENT PRICE!!! Before anybody asks me I don't get commission, I don't have anything to do with the company, neither any of my views represent that of the company, I'm just an extremely happy customer that felt the need to share the experience with other potential buyers. I hope I did the product some good justice, despite my crappy beginner playing, them good Ross folk take a lot of pride in making those wonderful instruments and they rightfully deserve a good review. The tune is Scots Wha Ha'e e Wi' Wallace Bled (Scots) or Scots Who Have With Wallace Bled (English), commonly known as Scots Wha Hae.The song was played for Robert the Bruce's troops on their march to Bannockburn, where brave Scots whooped the hell out of invading English troops, securing Scottish Independence then. Robert Burns composed the lyrics and they are said to be Bruce's address to his men before the battle. A beautiful, patriotic and outstanding melody. It's been about a year since I have made this video (this paragraph is being written in July 2012) and I thought it would be nice to let people that come here know that I'… | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["electronic bagpipe", "drone", "solo"] | 8 | JNw0A8pRnsQ | 1997 |
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;