Aural Moon - Progressive Rock Discussion - The Aural Moon "FLAG PROJECT"

Yesterday in the speakeasy, someone referred to the project to add country of origin information to the Aural Moon music library as the "FLAG PROJECT" so, for lack of a better title, it is the "FLAG PROJECT".

If you want to help, here is what is needed. Doing this all manually in SAM will take much time. It would be far easier to simply issue a script of SQL commands to update this. So, if you want to help, here is what is needed:

Use this table (sorted by country name):

Code:

SELECT DISTINCT code, country FROM ip2country ORDER BY country ASC code country AF Afghanistan AX Aland Islands AL Albania DZ Algeria AS American Samoa AD Andorra AO Angola AI Anguilla AQ Antarctica AG Antigua and Barbuda AR Argentina AM Armenia AW Aruba AP Asia/Pacific Region AU Australia AT Austria AZ Azerbaijan BS Bahamas BH Bahrain BD Bangladesh BB Barbados BY Belarus BE Belgium BZ Belize BJ Benin BM Bermuda BT Bhutan BO Bolivia BA Bosnia and Herzegovina BW Botswana BV Bouvet Island BR Brazil IO British Indian Ocean Territory BN Brunei Darussalam BG Bulgaria BF Burkina Faso BI Burundi KH Cambodia CM Cameroon CA Canada CV Cape Verde KY Cayman Islands CF Central African Republic TD Chad CL Chile CN China CO Colombia KM Comoros CG Congo CD Congo CK Cook Islands CR Costa Rica HR Croatia CU Cuba CY Cyprus CZ Czech Republic DK Denmark DJ Djibouti DM Dominica DO Dominican Republic EC Ecuador EG Egypt SV El Salvador GQ Equatorial Guinea ER Eritrea EE Estonia ET Ethiopia EU Europe FK Falkland Islands (Malvinas) FO Faroe Islands FJ Fiji FI Finland FR France GF French Guiana PF French Polynesia GA Gabon GM Gambia GE Georgia DE Germany GH Ghana GI Gibraltar GR Greece GL Greenland GD Grenada GP Guadeloupe GU Guam GT Guatemala GG Guernsey GN Guinea GW Guinea-Bissau GY Guyana HT Haiti VA Holy See (Vatican City State) HN Honduras HK Hong Kong HU Hungary IS Iceland IN India ID Indonesia IR Iran IQ Iraq IE Ireland IM Isle of Man IL Israel IT Italy JM Jamaica JP Japan JE Jersey JO Jordan KZ Kazakhstan KE Kenya KI Kiribati KP Korea KR Korea KW Kuwait KG Kyrgyzstan LV Latvia LB Lebanon LS Lesotho LR Liberia LY Libyan Arab Jamahiriya LI Liechtenstein LT Lithuania LU Luxembourg MO Macau MK Macedonia MG Madagascar MW Malawi MY Malaysia MV Maldives ML Mali MT Malta MH Marshall Islands MQ Martinique MR Mauritania MU Mauritius YT Mayotte MX Mexico FM Micronesia MD Moldova MC Monaco MN Mongolia ME Montenegro MS Montserrat MA Morocco MZ Mozambique MM Myanmar NA Namibia NR Nauru NP Nepal NL Netherlands AN Netherlands Antilles NC New Caledonia NZ New Zealand NI Nicaragua NE Niger NG Nigeria NU Niue NF Norfolk Island MP Northern Mariana Islands NO Norway OM Oman PK Pakistan PW Palau PS Palestinian Territory PA Panama PG Papua New Guinea PY Paraguay PE Peru PH Philippines PN Pitcairn Islands PL Poland PT Portugal PR Puerto Rico QA Qatar RE Reunion RO Romania RU Russian Federation RW Rwanda KN Saint Kitts and Nevis LC Saint Lucia MF Saint Martin PM Saint Pierre and Miquelon VC Saint Vincent and the Grenadines WS Samoa SM San Marino ST Sao Tome and Principe SA Saudi Arabia SN Senegal RS Serbia SC Seychelles SL Sierra Leone SG Singapore SK Slovakia SI Slovenia SB Solomon Islands SO Somalia ZA South Africa ES Spain LK Sri Lanka SD Sudan SR Suriname SZ Swaziland SE Sweden CH Switzerland SY Syrian Arab Republic TW Taiwan TJ Tajikistan TZ Tanzania TH Thailand TL Timor-Leste TG Togo TK Tokelau TO Tonga TT Trinidad and Tobago TN Tunisia TR Turkey TM Turkmenistan TC Turks and Caicos Islands TV Tuvalu UG Uganda UA Ukraine AE United Arab Emirates GB United Kingdom US United States UM United States Minor Outlying Islands UY Uruguay UZ Uzbekistan VU Vanuatu VE Venezuela VN Vietnam VG Virgin Islands VI Virgin Islands WF Wallis and Futuna YE Yemen ZM Zambia ZW Zimbabwe

or this one (sorted by code):

Code:

SELECT DISTINCT code,country FROM joomla.ip2country ORDER BY code ASC code country AD Andorra AE United Arab Emirates AF Afghanistan AG Antigua and Barbuda AI Anguilla AL Albania AM Armenia AN Netherlands Antilles AO Angola AP Asia/Pacific Region AQ Antarctica AR Argentina AS American Samoa AT Austria AU Australia AW Aruba AX Aland Islands AZ Azerbaijan BA Bosnia and Herzegovina BB Barbados BD Bangladesh BE Belgium BF Burkina Faso BG Bulgaria BH Bahrain BI Burundi BJ Benin BM Bermuda BN Brunei Darussalam BO Bolivia BR Brazil BS Bahamas BT Bhutan BV Bouvet Island BW Botswana BY Belarus BZ Belize CA Canada CD Congo CF Central African Republic CG Congo CH Switzerland CK Cook Islands CL Chile CM Cameroon CN China CO Colombia CR Costa Rica CU Cuba CV Cape Verde CY Cyprus CZ Czech Republic DE Germany DJ Djibouti DK Denmark DM Dominica DO Dominican Republic DZ Algeria EC Ecuador EE Estonia EG Egypt ER Eritrea ES Spain ET Ethiopia EU Europe FI Finland FJ Fiji FK Falkland Islands (Malvinas) FM Micronesia FO Faroe Islands FR France GA Gabon GB United Kingdom GD Grenada GE Georgia GF French Guiana GG Guernsey GH Ghana GI Gibraltar GL Greenland GM Gambia GN Guinea GP Guadeloupe GQ Equatorial Guinea GR Greece GT Guatemala GU Guam GW Guinea-Bissau GY Guyana HK Hong Kong HN Honduras HR Croatia HT Haiti HU Hungary ID Indonesia IE Ireland IL Israel IM Isle of Man IN India IO British Indian Ocean Territory IQ Iraq IR Iran IS Iceland IT Italy JE Jersey JM Jamaica JO Jordan JP Japan KE Kenya KG Kyrgyzstan KH Cambodia KI Kiribati KM Comoros KN Saint Kitts and Nevis KP Korea KR Korea KW Kuwait KY Cayman Islands KZ Kazakhstan LB Lebanon LC Saint Lucia LI Liechtenstein LK Sri Lanka LR Liberia LS Lesotho LT Lithuania LU Luxembourg LV Latvia LY Libyan Arab Jamahiriya MA Morocco MC Monaco MD Moldova ME Montenegro MF Saint Martin MG Madagascar MH Marshall Islands MK Macedonia ML Mali MM Myanmar MN Mongolia MO Macau MP Northern Mariana Islands MQ Martinique MR Mauritania MS Montserrat MT Malta MU Mauritius MV Maldives MW Malawi MX Mexico MY Malaysia MZ Mozambique NA Namibia NC New Caledonia NE Niger NF Norfolk Island NG Nigeria NI Nicaragua NL Netherlands NO Norway NP Nepal NR Nauru NU Niue NZ New Zealand OM Oman PA Panama PE Peru PF French Polynesia PG Papua New Guinea PH Philippines PK Pakistan PL Poland PM Saint Pierre and Miquelon PN Pitcairn Islands PR Puerto Rico PS Palestinian Territory PT Portugal PW Palau PY Paraguay QA Qatar RE Reunion RO Romania RS Serbia RU Russian Federation RW Rwanda SA Saudi Arabia SB Solomon Islands SC Seychelles SD Sudan SE Sweden SG Singapore SI Slovenia SK Slovakia SL Sierra Leone SM San Marino SN Senegal SO Somalia SR Suriname ST Sao Tome and Principe SV El Salvador SY Syrian Arab Republic SZ Swaziland TC Turks and Caicos Islands TD Chad TG Togo TH Thailand TJ Tajikistan TK Tokelau TL Timor-Leste TM Turkmenistan TN Tunisia TO Tonga TR Turkey TT Trinidad and Tobago TV Tuvalu TW Taiwan TZ Tanzania UA Ukraine UG Uganda UM United States Minor Outlying Islands US United States UY Uruguay UZ Uzbekistan VA Holy See (Vatican City State) VC Saint Vincent and the Grenadines VE Venezuela VG Virgin Islands VI Virgin Islands VN Vietnam VU Vanuatu WF Wallis and Futuna WS Samoa YE Yemen YT Mayotte ZA South Africa ZM Zambia ZW Zimbabwe
Use the following template SQL query command:

Code:

UPDATE samdb.songlist set lyrics="xx" where artist="artist";

Fill in the CC (country code) and the artist name.

For example:

Code:

UPDATE samdb.songlist set lyrics="GB" where artist="YES";
Keep in mind that Jim does things like "The Moody Blues" -> "Moody Blues, The" and "Roger Waters" -> "Waters, Roger"
Post your efforts in this thread by keeping the SQL command inside the CODE tags (the hash # mark in the options above) and copy each preceding contribution and then add yours.
Don't top post!!! I will delete them!!!
JUST post the updated SQL.

Thanks. I will delete posts as they are accrued leaving only the most recent so as not to clutter this effort too much. Do not worry about duplicates. I will sort through. If you see an error, feel free to correct it when you post.

Also, the artist name must be exact. For example: "Premiata Forneria Marconi" is acceptable whereas "PFM" is not... unless you happen to find that Jim listed this band as "PFM" in the library. (hint: he didn't).

Thanks so far to:

Yesspaz
tobytanzer
dnsrees
jtmckinley
Wojtek

for their contributions to the effort.

Code:

UPDATE samdb.songlist set lyrics="DE" where artist="0.720 Aleacion";

UPDATE samdb.songlist set lyrics="GB" where artist="3";

UPDATE samdb.songlist set lyrics="NO" where artist="3rd and the Mortal, The";

UPDATE samdb.songlist set lyrics="US" where artist="3rdegree";

UPDATE samdb.songlist set lyrics="IT" where artist="3vel";

UPDATE samdb.songlist set lyrics="FR" where artist="4/3 de Trio";

UPDATE samdb.songlist set lyrics="US" where artist="4Front";

UPDATE samdb.songlist set lyrics="NL" where artist="5Bridges";

UPDATE samdb.songlist set lyrics="US" where artist="5uu’s";

UPDATE samdb.songlist set lyrics="GB" where artist="801";

UPDATE samdb.songlist set lyrics="UA" where artist="940811";

UPDATE samdb.songlist set lyrics="US" where artist="9 on Bali";

UPDATE samdb.songlist set lyrics="GB" where artist="Aardvark";

UPDATE samdb.songlist set lyrics="DE" where artist="Abacus";

UPDATE samdb.songlist set lyrics="DE" where artist="Abarax";

UPDATE samdb.songlist set lyrics="US" where artist="Abercrombie Holland DeJohnette";

UPDATE samdb.songlist set lyrics="US" where artist="Abercrombie, John";

UPDATE samdb.songlist set lyrics="US" where artist="Abigail's Ghost";

UPDATE samdb.songlist set lyrics="IT" where artist="Abiogenesi";

UPDATE samdb.songlist set lyrics="GB" where artist="Able Ganz";

UPDATE samdb.songlist set lyrics="LB" where artist="Abou-Khalil, Rabih";

UPDATE samdb.songlist set lyrics="GB" where artist="Abraham, Lee";

UPDATE samdb.songlist set lyrics="PL" where artist="Abraxas";

UPDATE samdb.songlist set lyrics="CL" where artist="Abrete Gandul";

UPDATE samdb.songlist set lyrics="SK" where artist="Abstract";

UPDATE samdb.songlist set lyrics="FR" where artist="Abus Dangereux ";

UPDATE samdb.songlist set lyrics="FR" where artist="Acanthe";

UPDATE samdb.songlist set lyrics="IT" where artist="Accordo Dei Contrari ";

UPDATE samdb.songlist set lyrics="FR" where artist="Achard, Cyril";

UPDATE samdb.songlist set lyrics="DK" where artist="Ache";

UPDATE samdb.songlist set lyrics="BR" where artist="Acidente";

UPDATE samdb.songlist set lyrics="FR" where artist="Acintya";

UPDATE samdb.songlist set lyrics="US" where artist="Ackerman, William";

UPDATE samdb.songlist set lyrics="IT" where artist="Acqua Fragile";

UPDATE samdb.songlist set lyrics="SE" where artist="A.C.T.";

UPDATE samdb.songlist set lyrics="JP" where artist="Adachi Kyodai ";

UPDATE samdb.songlist set lyrics="US" where artist="Adam's Castle";

UPDATE samdb.songlist set lyrics="NZ" where artist="Adam's Dream ";

UPDATE samdb.songlist set lyrics="US" where artist="Adams, Steve ";

UPDATE samdb.songlist set lyrics="US" where artist="Ad Astra";

UPDATE samdb.songlist set lyrics="CN" where artist="Addison Project";

UPDATE samdb.songlist set lyrics="GH" where artist="Addy, Obo";

UPDATE samdb.songlist set lyrics="IT" where artist="AdiB";

UPDATE samdb.songlist set lyrics="GB" where artist="Adiemus";

UPDATE samdb.songlist set lyrics="US" where artist="Ad Infinitum";

UPDATE samdb.songlist set lyrics="NZ" where artist="Adrian, Rudy";

UPDATE samdb.songlist set lyrics="US" where artist="Advent";

UPDATE samdb.songlist set lyrics="NO" where artist="Adventure";

UPDATE samdb.songlist set lyrics="IT" where artist="Aelian";

UPDATE samdb.songlist set lyrics="DE" where artist="Aera";

UPDATE samdb.songlist set lyrics="US" where artist="Aethellis";

UPDATE samdb.songlist set lyrics="BR" where artist="Aether";

UPDATE samdb.songlist set lyrics="GB" where artist="Affinity";

UPDATE samdb.songlist set lyrics="GB" where artist="Afforested";

UPDATE samdb.songlist set lyrics="GB" where artist="Afro Celt Sound System";

UPDATE samdb.songlist set lyrics="US" where artist="Afroskull";

UPDATE samdb.songlist set lyrics="HU" where artist="After Crying";

UPDATE samdb.songlist set lyrics="FR" where artist="Afterglow";

UPDATE samdb.songlist set lyrics="GB" where artist="Aftershock";

UPDATE samdb.songlist set lyrics="US" where artist="After The Fall";

UPDATE samdb.songlist set lyrics="US" where artist="Agalloch";

UPDATE samdb.songlist set lyrics="US" where artist="Agatsuma";

UPDATE samdb.songlist set lyrics="SE" where artist="Agebjörn, Johan with Lisa Barra";

UPDATE samdb.songlist set lyrics="FI" where artist="Ageness";

UPDATE samdb.songlist set lyrics="US" where artist="Agent Cooper";

UPDATE samdb.songlist set lyrics="SE" where artist="Agents Of Mercy";

UPDATE samdb.songlist set lyrics="DE" where artist="Agitation Free ";

UPDATE samdb.songlist set lyrics="AR" where artist="Agnus";

UPDATE samdb.songlist set lyrics="US" where artist="Ahleuchatistas";

UPDATE samdb.songlist set lyrics="IL" where artist="Ahvak";

UPDATE samdb.songlist set lyrics="JP" where artist="Ain Soph";

UPDATE samdb.songlist set lyrics="NO" where artist="Airbag";

UPDATE samdb.songlist set lyrics="CL" where artist="Aisles";

UPDATE samdb.songlist set lyrics="US" where artist="Ajalon";

UPDATE samdb.songlist set lyrics="CN" where artist="Akacia";

UPDATE samdb.songlist set lyrics="NO" where artist="Akasha";

UPDATE samdb.songlist set lyrics="JP" where artist="Akihisa Tsuboy & Natsuki Kido Duo";

UPDATE samdb.songlist set lyrics="NL" where artist="Akkerman, Jan";

UPDATE samdb.songlist set lyrics="SK" where artist="Ako Doma ";

UPDATE samdb.songlist set lyrics="BE" where artist="Aksak Maboul";

UPDATE samdb.songlist set lyrics="FI" where artist="Alamaailman Vasarat";

UPDATE samdb.songlist set lyrics="IT" where artist="A Lamuraglia";

UPDATE samdb.songlist set lyrics="GB" where artist="Alan Parsons Project, The";

UPDATE samdb.songlist set lyrics="FR" where artist="Alarcen, Jean-Pierre;

UPDATE samdb.songlist set lyrics="AR" where artist="Alas";

UPDATE samdb.songlist set lyrics="US" where artist="Alaska";

UPDATE samdb.songlist set lyrics="PL" where artist="Albion";

UPDATE samdb.songlist set lyrics="Uz" where artist="Al-Bird";

UPDATE samdb.songlist set lyrics="US" where artist="Album Leaf, The";

UPDATE samdb.songlist set lyrics="DE" where artist="Alcatraz ";

UPDATE samdb.songlist set lyrics="US" where artist="alec k. redfearn and the eyesores";

UPDATE samdb.songlist set lyrics="AU" where artist="Aleph";

UPDATE samdb.songlist set lyrics="AT" where artist="Alex Machacek, Matthew Garrison, Jeff Sipe";

UPDATE samdb.songlist set lyrics="GB" where artist="Alex Maguire Sextet";

UPDATE samdb.songlist set lyrics="IT" where artist="Algebra ";

UPDATE samdb.songlist set lyrics="US" where artist="Algernon";

UPDATE samdb.songlist set lyrics="IT" where artist="Alhambra";

UPDATE samdb.songlist set lyrics="DE" where artist="Alias Eye";

UPDATE samdb.songlist set lyrics="US" where artist="Ali, Azam";

UPDATE samdb.songlist set lyrics="US" where artist="Aliens, Ghosts And Demons";

UPDATE samdb.songlist set lyrics="FR" where artist="aLkemy";

UPDATE samdb.songlist set lyrics="GB" where artist="All About Eve";

UPDATE samdb.songlist set lyrics="AU" where artist="Allen, Daevid";

UPDATE samdb.songlist set lyrics="US" where artist="Allen, David";

UPDATE samdb.songlist set lyrics="US" where artist="Alomar, Carlos";

UPDATE samdb.songlist set lyrics="IT" where artist="Alphataurus";

UPDATE samdb.songlist set lyrics="US" where artist="Alpha Wave Movement";

UPDATE samdb.songlist set lyrics="ES" where artist="Alquilbencil";

UPDATE samdb.songlist set lyrics="CO" where artist="Alquimia ";

UPDATE samdb.songlist set lyrics="NL" where artist="Alquin";

UPDATE samdb.songlist set lyrics="GB" where artist="Also Eden";

UPDATE samdb.songlist set lyrics="ES" where artist="Altair";

UPDATE samdb.songlist set lyrics="IT" where artist="Altera";

UPDATE samdb.songlist set lyrics="US" where artist="Altered";

UPDATE samdb.songlist set lyrics="IT" where artist="Alusa Fallax";

UPDATE samdb.songlist set lyrics="MX" where artist="Alux";

UPDATE samdb.songlist set lyrics="MX" where artist="Alvarado, Carlos";

UPDATE samdb.songlist set lyrics="AR" where artist="Alvarez, Sergio";

UPDATE samdb.songlist set lyrics="MX" where artist="Aly";

UPDATE samdb.songlist set lyrics="US" where artist="Amado";

UPDATE samdb.songlist set lyrics="AR" where artist="Amagrama";

UPDATE samdb.songlist set lyrics="CA" where artist="Amalgame";

UPDATE samdb.songlist set lyrics="US" where artist="Amarans Plight";

UPDATE samdb.songlist set lyrics="ES" where artist="Amarok";

UPDATE samdb.songlist set lyrics="PL" where artist="Amaryllis";

UPDATE samdb.songlist set lyrics="GB" where artist="Amaseffer";

UPDATE samdb.songlist set lyrics="NL" where artist="Ambeon";

UPDATE samdb.songlist set lyrics="US" where artist="Amber Asylum";

UPDATE samdb.songlist set lyrics="AU" where artist="Ambitious Lovers";

UPDATE samdb.songlist set lyrics="US" where artist="Ambrosia";

UPDATE samdb.songlist set lyrics="DE" where artist="Amenophis";

UPDATE samdb.songlist set lyrics="US" where artist="American Football";

UPDATE samdb.songlist set lyrics="US" where artist="Amoebic Ensemble";

UPDATE samdb.songlist set lyrics="DE" where artist="Amon Duul";

UPDATE samdb.songlist set lyrics="DE" where artist="Amon Duul II";

UPDATE samdb.songlist set lyrics="FI" where artist="Amorphis";

UPDATE samdb.songlist set lyrics="DE" where artist="Amos Key ";

UPDATE samdb.songlist set lyrics="US" where artist="Analog Missionary";

UPDATE samdb.songlist set lyrics="NL" where artist="Anand";

UPDATE samdb.songlist set lyrics="PT" where artist="Ananga Ranga";

UPDATE samdb.songlist set lyrics="GB" where artist="Anathema";

UPDATE samdb.songlist set lyrics="FN" where artist="Ancient Bear Cult";

UPDATE samdb.songlist set lyrics="US" where artist="Ancient Future";

UPDATE samdb.songlist set lyrics="IT" where artist="Ancient Veil, The";

UPDATE samdb.songlist set lyrics="US" where artist="Ancient Vision";

UPDATE samdb.songlist set lyrics="DK" where artist="Andersen, Andre";

UPDATE samdb.songlist set lyrics="GB" where artist="Anderson, Bruford, Wakeman, Howe";

UPDATE samdb.songlist set lyrics="GB" where artist="Anderson, Ian";

UPDATE samdb.songlist set lyrics="GB" where artist="Anderson, Jon";

UPDATE samdb.songlist set lyrics="US" where artist="Anderson, Laurie";

UPDATE samdb.songlist set lyrics="US" where artist="Anderson, Marc";

UPDATE samdb.songlist set lyrics="US" where artist="Anderson, Michael";

UPDATE samdb.songlist set lyrics="SE" where artist="Anekdoten";

UPDATE samdb.songlist set lyrics="US" where artist="An Endless Sporadic";

UPDATE samdb.songlist set lyrics="FR" where artist="Ange";

UPDATE samdb.songlist set lyrics="US" where artist="Angel Earth";

UPDATE samdb.songlist set lyrics="US" where artist="Anger, Darol & Barbara Higbie";

UPDATE samdb.songlist set lyrics="SE" where artist="Anglagard";

UPDATE samdb.songlist set lyrics="BR" where artist="Anima Dominum";

UPDATE samdb.songlist set lyrics="US" where artist="Animal Collective";

UPDATE samdb.songlist set lyrics="SE" where artist="Anima Morte";

UPDATE samdb.songlist set lyrics="CU" where artist="Anima Mundi";

UPDATE samdb.songlist set lyrics="US" where artist="Animator ";

UPDATE samdb.songlist set lyrics="PL" where artist="Ankh";

UPDATE samdb.songlist set lyrics="AU" where artist="Annexed";

UPDATE samdb.songlist set lyrics="US" where artist="Annie Moses Band";

UPDATE samdb.songlist set lyrics="NO" where artist="Annot Rhül";

UPDATE samdb.songlist set lyrics="NO" where artist="Antidepressive Delivery";

UPDATE samdb.songlist set lyrics="AR" where artist="Antiheroe";

UPDATE samdb.songlist set lyrics="FR" where artist="Antiklimax";

UPDATE samdb.songlist set lyrics="GB" where artist="Antique Seeking Nuns";

UPDATE samdb.songlist set lyrics="IT" where artist="Antonelli Ensemble, Fabio";

UPDATE samdb.songlist set lyrics="IT" where artist="Antonius Rex ";

UPDATE samdb.songlist set lyrics="GB" where artist="Anubian Lights feat Nik Turner ";

UPDATE samdb.songlist set lyrics="US" where artist="Anubis Spire";

UPDATE samdb.songlist set lyrics="PK" where artist="Anwar, Faraz";

UPDATE samdb.songlist set lyrics="DE" where artist="Anyone's Daughter";

UPDATE samdb.songlist set lyrics="GR" where artist="Aphrodite's Child";

UPDATE samdb.songlist set lyrics="IT" where artist="A Piedi Nudi";

UPDATE samdb.songlist set lyrics="BR" where artist="Apocalypse";

UPDATE samdb.songlist set lyrics="DE" where artist="Apogee";

UPDATE samdb.songlist set lyrics="RU" where artist="Apple Pie";

UPDATE samdb.songlist set lyrics="US" where artist="Appleseed Cast, The";

UPDATE samdb.songlist set lyrics="US" where artist="Aquabats, The";

UPDATE samdb.songlist set lyrics="FN" where artist="Aquaplan";

UPDATE samdb.songlist set lyrics="GB" where artist="Aquaplanage";

UPDATE samdb.songlist set lyrics="US" where artist="Aquarius";

UPDATE samdb.songlist set lyrics="AR" where artist="Aquelarre";

UPDATE samdb.songlist set lyrics="US" where artist="Aquino, David";

UPDATE samdb.songlist set lyrics="FR" where artist="Arachnoid";

UPDATE samdb.songlist set lyrics="IR" where artist="Arashk";

UPDATE samdb.songlist set lyrics="MX" where artist="Arbatel";

UPDATE samdb.songlist set lyrics="IT" where artist="Arbogast";

UPDATE samdb.songlist set lyrics="GB" where artist="Arc";

UPDATE samdb.songlist set lyrics="IT" where artist="Arcanoise";

UPDATE samdb.songlist set lyrics="IT" where artist="Arcansiel";

UPDATE samdb.songlist set lyrics="SE" where artist="Archimedes Badkar";

UPDATE samdb.songlist set lyrics="GB" where artist="Archive ";

UPDATE samdb.songlist set lyrics="AR" where artist="Arco Iris ";

UPDATE samdb.songlist set lyrics="US" where artist="Arctic Fire";

UPDATE samdb.songlist set lyrics="GB" where artist="Ardley, Neal";

UPDATE samdb.songlist set lyrics="GB" where artist="Ardley, Neal - Carr, Ian - Rendel, Don";

UPDATE samdb.songlist set lyrics="IT" where artist="Area";

UPDATE samdb.songlist set lyrics="GB" where artist="Area 39";

UPDATE samdb.songlist set lyrics="IT" where artist="Areknamés";

UPDATE samdb.songlist set lyrics="GB" where artist="Arena";

UPDATE samdb.songlist set lyrics="GB" where artist="Argent";

UPDATE samdb.songlist set lyrics="GB" where artist="Argent, Rod";

UPDATE samdb.songlist set lyrics="DE" where artist="Argos";

UPDATE samdb.songlist set lyrics="IT" where artist="Aries";

UPDATE samdb.songlist set lyrics="BR" where artist="Arion";

UPDATE samdb.songlist set lyrics="US" where artist="Arkenstone, David";

UPDATE samdb.songlist set lyrics="BE" where artist="Arkham";

UPDATE samdb.songlist set lyrics="DE" where artist="A.R. & Machines";

UPDATE samdb.songlist set lyrics="GB" where artist="Armageddon";

UPDATE samdb.songlist set lyrics="IT" where artist="Armonite";

UPDATE samdb.songlist set lyrics="MX" where artist="Arreola, Alonso";

UPDATE samdb.songlist set lyrics="JP" where artist="Ars Nova";

UPDATE samdb.songlist set lyrics="JP" where artist="Ars Nova/Gerard";

UPDATE samdb.songlist set lyrics="GB" where artist="Art Bears ";

UPDATE samdb.songlist set lyrics="FR" where artist="Artcane";

UPDATE samdb.songlist set lyrics="US" where artist="Artension";

UPDATE samdb.songlist set lyrics="IT" where artist="Arti E Mestieri";

UPDATE samdb.songlist set lyrics="US" where artist="Art In America";

UPDATE samdb.songlist set lyrics="IL" where artist="Artland";

UPDATE samdb.songlist set lyrics="AM" where artist="Artsruni";

UPDATE samdb.songlist set lyrics="FR" where artist="Art Zoyd";

UPDATE samdb.songlist set lyrics="US" where artist="ARZ";

UPDATE samdb.songlist set lyrics="GB" where artist="Arzachel";

UPDATE samdb.songlist set lyrics="DE" where artist="Asgaart";

UPDATE samdb.songlist set lyrics="IT" where artist="Asgard";

UPDATE samdb.songlist set lyrics="JP" where artist="Ashada";

UPDATE samdb.songlist set lyrics="IL" where artist="Ashqelon Quilt, The";

UPDATE samdb.songlist set lyrics="DE" where artist="Ashra";

UPDATE samdb.songlist set lyrics="DE" where artist="Ash Ra Tempel";

UPDATE samdb.songlist set lyrics="FR" where artist="Asia Minor";

UPDATE samdb.songlist set lyrics="FR" where artist="Aside Beside";

UPDATE samdb.songlist set lyrics="CA" where artist="A Silver Mt. Zion";

UPDATE samdb.songlist set lyrics="US" where artist="Asobi Seksu";

UPDATE samdb.songlist set lyrics="NO" where artist="Aspera";

UPDATE samdb.songlist set lyrics="NL" where artist="Association PC";

UPDATE samdb.songlist set lyrics="US" where artist="Astoria";

UPDATE samdb.songlist set lyrics="US" where artist="Astra";

UPDATE samdb.songlist set lyrics="GB" where artist="Astralasia";

UPDATE samdb.songlist set lyrics="IT" where artist="Astralia";

UPDATE samdb.songlist set lyrics="CL" where artist="Astralis";

UPDATE samdb.songlist set lyrics="GB" where artist="Astral Navigations";

UPDATE samdb.songlist set lyrics="US" where artist="Astral Project";

UPDATE samdb.songlist set lyrics="IT" where artist="Astral Weeks";

UPDATE samdb.songlist set lyrics="JP" where artist="Asturias";

UPDATE samdb.songlist set lyrics="US" where artist="Atavism of Twilight";

UPDATE samdb.songlist set lyrics="PT" where artist="Atik Maze";

UPDATE samdb.songlist set lyrics="ES" where artist="Atila";

UPDATE samdb.songlist set lyrics="US" where artist="Atlantis";

UPDATE samdb.songlist set lyrics="SE" where artist="Atlas";

UPDATE samdb.songlist set lyrics="DE" where artist="Atmosfear";

UPDATE samdb.songlist set lyrics="FR" where artist="Atoll";

UPDATE samdb.songlist set lyrics="GB" where artist="Atomic Rooster";

UPDATE samdb.songlist set lyrics="IT" where artist="Aton's";

UPDATE samdb.songlist set lyrics="FR" where artist="Atria";

UPDATE samdb.songlist set lyrics="US" where artist="A Triggering Myth";

UPDATE samdb.songlist set lyrics="US" where artist="Attention Deficit ";

UPDATE samdb.songlist set lyrics="US" where artist="At War With Self";

UPDATE samdb.songlist set lyrics="GB" where artist="Audience";

UPDATE samdb.songlist set lyrics="IT" where artist="Audio";

UPDATE samdb.songlist set lyrics="US" where artist="Audio Adrenaline";

UPDATE samdb.songlist set lyrics="US" where artist="Audiocracy";

UPDATE samdb.songlist set lyrics="FR" where artist="Audren, Chris ";

UPDATE samdb.songlist set lyrics="IT" where artist="Aufklarung";

UPDATE samdb.songlist set lyrics="US" where artist="Aug, Jeff";

UPDATE samdb.songlist set lyrics="FI" where artist="Aural Night";

UPDATE samdb.songlist set lyrics="NL" where artist="Aurora Project, The";

UPDATE samdb.songlist set lyrics="GB" where artist="Auroris";

UPDATE samdb.songlist set lyrics="US" where artist="Automatic Man";

UPDATE samdb.songlist set lyrics="GB" where artist="Autumn";

UPDATE samdb.songlist set lyrics="US" where artist="Autumn Tears";

UPDATE samdb.songlist set lyrics="US" where artist="Avant Garden ";

UPDATE samdb.songlist set lyrics="IT" where artist="Avarta";

UPDATE samdb.songlist set lyrics="US" where artist="Aviary";

UPDATE samdb.songlist set lyrics="RU" where artist="Aviva Omnibus";

UPDATE samdb.songlist set lyrics="GR" where artist="Axis";

UPDATE samdb.songlist set lyrics="GB" where artist="Ayers, Kevin";

UPDATE samdb.songlist set lyrics="NL" where artist="Ayreon";

UPDATE samdb.songlist set lyrics="RU" where artist="Azazello ";

UPDATE samdb.songlist set lyrics="US" where artist="Azigza";

UPDATE samdb.songlist set lyrics="JP" where artist="Azuma";

UPDATE samdb.songlist set lyrics="US" where artist="Azureth";

UPDATE samdb.songlist set lyrics="SE" where artist="Baby Grandmothers";

UPDATE samdb.songlist set lyrics="US" where artist="Babylon";

UPDATE samdb.songlist set lyrics="BR" where artist="Bacamarte";

UPDATE samdb.songlist set lyrics="US" where artist="Bach & Leonard Overdrive";

UPDATE samdb.songlist set lyrics="IT" where artist="Bacio Della Medusa, Il";

UPDATE samdb.songlist set lyrics="US" where artist="Bad Alchemy";

UPDATE samdb.songlist set lyrics="US" where artist="Bad Dog U";

UPDATE samdb.songlist set lyrics="GB" where artist="Badger";

UPDATE samdb.songlist set lyrics="FR" where artist="Bag";

UPDATE samdb.songlist set lyrics="US" where artist="Bagsby, David";

UPDATE samdb.songlist set lyrics="US" where artist="Bagsby, Steve";

UPDATE samdb.songlist set lyrics="IR" where artist="Bahari, Agah";

UPDATE samdb.songlist set lyrics="GB" where artist="Bainbridge, David";

UPDATE samdb.songlist set lyrics="CA" where artist="Baird, Ken";

UPDATE samdb.songlist set lyrics="DE" where artist="Bairy, Herbert F.";

UPDATE samdb.songlist set lyrics="DE" where artist="Baja";

UPDATE samdb.songlist set lyrics="GB" where artist="Baker, Ginger";

UPDATE samdb.songlist set lyrics="RO" where artist="Balanescu Quartet, The";

UPDATE samdb.songlist set lyrics="US" where artist="Baliset";

UPDATE samdb.songlist set lyrics="RS" where artist="Balkan Horses Band";

UPDATE samdb.songlist set lyrics="IT" where artist="Balletto Di Bronzo, Il ";

UPDATE samdb.songlist set lyrics="NL" where artist="Balloon";

UPDATE samdb.songlist set lyrics="IT" where artist="Banco Del Mutuo Soccorso";

UPDATE samdb.songlist set lyrics="US" where artist="Banda Elastica";

UPDATE samdb.songlist set lyrics="US" where artist="Bandhada";

UPDATE samdb.songlist set lyrics="IT" where artist="Banfi, Baffo";

UPDATE samdb.songlist set lyrics="GB" where artist="Banks, Peter";

UPDATE samdb.songlist set lyrics="GB" where artist="Banks, Tony";

UPDATE samdb.songlist set lyrics="US" where artist="Banyan";

UPDATE samdb.songlist set lyrics="JP" where artist="Baraka";

UPDATE samdb.songlist set lyrics="IT" where artist="Barbati E Maiozzi";

UPDATE samdb.songlist set lyrics="GB" where artist="Barbieri, Richard";

UPDATE samdb.songlist set lyrics="GB" where artist="Barclay James Harvest";

UPDATE samdb.songlist set lyrics="GB" where artist="Bardens, Pete";

UPDATE samdb.songlist set lyrics="FR" where artist="Bardin, Didier";

UPDATE samdb.songlist set lyrics="US" where artist="Barefoot";

UPDATE samdb.songlist set lyrics="IT" where artist="Baricentro, Il";

UPDATE samdb.songlist set lyrics="GB" where artist="Bark Psychosis";

UPDATE samdb.songlist set lyrics="SE" where artist="Barr";

UPDATE samdb.songlist set lyrics="GB" where artist="Barrett, Syd";

UPDATE samdb.songlist set lyrics="IT" where artist="Barrock";

UPDATE samdb.songlist set lyrics="NL" where artist="Barstool Philosophers, The";

UPDATE samdb.songlist set lyrics="IQ" where artist="Basim, Al";

UPDATE samdb.songlist set lyrics="GB" where artist="Bass Communion";

UPDATE samdb.songlist set lyrics="IT" where artist="Battiato";

UPDATE samdb.songlist set lyrics="US" where artist="Battles";

UPDATE samdb.songlist set lyrics="GB" where artist="Baumgartner, Eric";

UPDATE samdb.songlist set lyrics="US" where artist="Beane, Phil";

UPDATE samdb.songlist set lyrics="DE" where artist="Bearded Project, The";

UPDATE samdb.songlist set lyrics="SE" where artist="Beardfish";

UPDATE samdb.songlist set lyrics="US" where artist="Bear, Jeff";

UPDATE samdb.songlist set lyrics="US" where artist="Beastie Boys";

UPDATE samdb.songlist set lyrics="US" where artist="Beat Circus";

UPDATE samdb.songlist set lyrics="GB" where artist="Beck, Jeff";

UPDATE samdb.songlist set lyrics="US" where artist="Beddia, Scott";

UPDATE samdb.songlist set lyrics="PT" where artist="Beduinos a Gasoleo";

UPDATE samdb.songlist set lyrics="DE" where artist="Beethoven, Ludwig Van";

UPDATE samdb.songlist set lyrics="IT" where artist="Beggar's Farm";

UPDATE samdb.songlist set lyrics="GB" where artist="Beggars Opera";

UPDATE samdb.songlist set lyrics="GB" where artist="Beggar's Tail";

UPDATE samdb.songlist set lyrics="YU" where artist="Begnagrad";

UPDATE samdb.songlist set lyrics="US" where artist="Belew, Adrian ";

UPDATE samdb.songlist set lyrics="US" where artist="Belew, Adrian Power Trio";

UPDATE samdb.songlist set lyrics="PL" where artist="Believe";

UPDATE samdb.songlist set lyrics="US" where artist="Bellador";

UPDATE samdb.songlist set lyrics="JP" where artist="Bellaphon";

UPDATE samdb.songlist set lyrics="US" where artist="Benjamin, Alan";

UPDATE samdb.songlist set lyrics="FR" where artist="Bensusan, Pierre & Didier Malherbe";

UPDATE samdb.songlist set lyrics="US" where artist="Bergamini, Joe";

UPDATE samdb.songlist set lyrics="HU" where artist="Bergendy";

UPDATE samdb.songlist set lyrics="CA" where artist="Bériau, Robert";

UPDATE samdb.songlist set lyrics="US" where artist="Berlin, Jeff";

UPDATE samdb.songlist set lyrics="US" where artist="Berry, Robert";

UPDATE samdb.songlist set lyrics="DE" where artist="Between";

UPDATE samdb.songlist set lyrics="SE" where artist="Between Interval";

UPDATE samdb.songlist set lyrics="US" where artist="Betz, Alfy With The Imaginar..";

UPDATE samdb.songlist set lyrics="US" where artist="Beyond Infinity";

UPDATE samdb.songlist set lyrics="US" where artist="Bezar, Emily";

UPDATE samdb.songlist set lyrics="US" where artist="B Hansen";

UPDATE samdb.songlist set lyrics="GB" where artist="Bill Bruford's Earthworks";

UPDATE samdb.songlist set lyrics="GB" where artist="Billy Mahonie";

UPDATE samdb.songlist set lyrics="US" where artist="Blue Man Group" ;

UPDATE samdb.songlist set lyrics="GB" where artist="Bowie, David";

UPDATE samdb.songlist set lyrics="US" where artist="Bozzio, Levin, Stevens";

UPDATE samdb.songlist set lyrics="US" where artist="Bozzio, Terry";

UPDATE samdb.songlist set lyrics="US" where artist="Bozzio, Terry & Billy Sheehan";

UPDATE samdb.songlist set lyrics="GB" where artist="Brand X";

UPDATE samdb.songlist set lyrics="GB" where artist="Bruce, Jack";

UPDATE samdb.songlist set lyrics="GB" where artist="Bruford";

UPDATE samdb.songlist set lyrics="GB" where artist="Bruford Levin";

UPDATE samdb.songlist set lyrics="US" where artist="Buckethead";

UPDATE samdb.songlist set lyrics="US" where artist="Burton, Metheny, Swallow, Sanchez";

UPDATE samdb.songlist set lyrics="US" where artist="Byrne, David";

UPDATE samdb.songlist set lyrics="US" where artist="California Guitar Trio";

UPDATE samdb.songlist set lyrics="GB" where artist="Camel";

UPDATE samdb.songlist set lyrics="US" where artist="Captain Beefheart & His Magic Band";

UPDATE samdb.songlist set lyrics="GB" where artist="Caravan";

UPDATE samdb.songlist set lyrics="US" where artist="Chaquico, Craig";

UPDATE samdb.songlist set lyrics="US" where artist="Chicago";

UPDATE samdb.songlist set lyrics="US" where artist="Chick Corea and John McLaughlin";

UPDATE samdb.songlist set lyrics="US" where artist="Cinemechanica";

UPDATE samdb.songlist set lyrics="US" where artist="Clarke, Di Meola & Ponty";

UPDATE samdb.songlist set lyrics="US" where artist="Clarke, Stanley";

UPDATE samdb.songlist set lyrics="US" where artist="Cobham, Billy";

UPDATE samdb.songlist set lyrics="US" where artist="Cobham, Billy - George Duke Band";

UPDATE samdb.songlist set lyrics="US" where artist="Colaiuta - Ford - Haslip";

UPDATE samdb.songlist set lyrics="PL" where artist="Collage";

UPDATE samdb.songlist set lyrics="US" where artist="Collections of Colonies of Bees";

UPDATE samdb.songlist set lyrics="GB" where artist="Collins, Phil";

UPDATE samdb.songlist set lyrics="US" where artist="Conspiracy";

UPDATE samdb.songlist set lyrics="US" where artist="Copeland, Stewart";

UPDATE samdb.songlist set lyrics="US" where artist="Corea, Chick";

UPDATE samdb.songlist set lyrics="US" where artist="Corea, Chick Elektric Band";

UPDATE samdb.songlist set lyrics="US" where artist="Corea/Hancock";

UPDATE samdb.songlist set lyrics="US" where artist="Corea Holland Altschul";

UPDATE samdb.songlist set lyrics="US" where artist="Coryell, Larry";

UPDATE samdb.songlist set lyrics="DE" where artist="Couch";

UPDATE samdb.songlist set lyrics="US" where artist="Crack The Sky";

UPDATE samdb.songlist set lyrics="US" where artist="Dandeeh";

UPDATE samdb.songlist set lyrics="US" where artist="Davis, Miles";

UPDATE samdb.songlist set lyrics="US" where artist="dc Talk";

UPDATE samdb.songlist set lyrics="US" where artist="dcTalk";

UPDATE samdb.songlist set lyrics="US" where artist="deGrassi, Alex";

UPDATE samdb.songlist set lyrics="US" where artist="De Johnette, Jack";

UPDATE samdb.songlist set lyrics="US" where artist="DiMeola, Al";

UPDATE samdb.songlist set lyrics="US" where artist="DiMeola, Al World Sinfonia";

UPDATE samdb.songlist set lyrics="US" where artist="DiMeola, DeLucia, McLaughlin";

UPDATE samdb.songlist set lyrics="US" where artist="Dixie Dregs";

UPDATE samdb.songlist set lyrics="CA" where artist="Do Make Say Think" ;

UPDATE samdb.songlist set lyrics="US" where artist="Don Caballero" ;

UPDATE samdb.songlist set lyrics="US" where artist="Dream Theater";

UPDATE samdb.songlist set lyrics="US" where artist="Eagles";

UPDATE samdb.songlist set lyrics="US" where artist="Egan, Mark";

UPDATE samdb.songlist set lyrics="IS" where artist="Eir, Margrét" ;

UPDATE samdb.songlist set lyrics="GB" where artist="Electric Light Orchestra";

UPDATE samdb.songlist set lyrics="US" where artist="Enchant";

UPDATE samdb.songlist set lyrics="GB" where artist="Eno, Brian";

UPDATE samdb.songlist set lyrics="GB" where artist="Eno, Brian - David Byrne";

UPDATE samdb.songlist set lyrics="GB" where artist="Eno, Brian & Harold Budd";

UPDATE samdb.songlist set lyrics="GB" where artist="Eno, Roger";

UPDATE samdb.songlist set lyrics="US" where artist="Explorers Club";

UPDATE samdb.songlist set lyrics="US" where artist="Explosions in the Sky" ;

UPDATE samdb.songlist set lyrics="GB" where artist="Fairport Convention";

UPDATE samdb.songlist set lyrics="GB" where artist="Family";

UPDATE samdb.songlist set lyrics="GB" where artist="Flash";

UPDATE samdb.songlist set lyrics="US" where artist="Fleck, Bela & the Flecktones";

UPDATE samdb.songlist set lyrics="US" where artist="Fontanelle";

UPDATE samdb.songlist set lyrics="GB" where artist="Fripp & Eno";

UPDATE samdb.songlist set lyrics="GB" where artist="Fripp, Robert";

UPDATE samdb.songlist set lyrics="GB" where artist="Fripp, Robert & Summers, Andy";

UPDATE samdb.songlist set lyrics="US" where artist="Frisell, Bill";

UPDATE samdb.songlist set lyrics="US" where artist="Frisell, Bill and Hall, Jim";

UPDATE samdb.songlist set lyrics="US" where artist="Frogg Cafe";

UPDATE samdb.songlist set lyrics="GB" where artist="Gabriel";

UPDATE samdb.songlist set lyrics="GB" where artist="Gabriel, Peter";

UPDATE samdb.songlist set lyrics="AU" where artist="Gambale, Frank";

UPDATE samdb.songlist set lyrics="US" where artist="Gambale Hamm Smith";

UPDATE samdb.songlist set lyrics="US" where artist="Garage a Trois";

UPDATE samdb.songlist set lyrics="US" where artist="Garaj Mahal";

UPDATE samdb.songlist set lyrics="US" where artist="Garaj Mahal & Fareed Haque";

UPDATE samdb.songlist set lyrics="US" where artist="Gary Burton Quartet, Eberhard Weber";

UPDATE samdb.songlist set lyrics="GB" where artist="Genesis";

UPDATE samdb.songlist set lyrics="GB" where artist="Gentle Giant";

UPDATE samdb.songlist set lyrics="GB" where artist="Giles, Giles And Fripp";

UPDATE samdb.songlist set lyrics="GB" where artist="Gilmour, David";

UPDATE samdb.songlist set lyrics="US" where artist="Glass Hammer";

UPDATE samdb.songlist set lyrics="US" where artist="Glass, Philip";

UPDATE samdb.songlist set lyrics="GB" where artist="God Is An Astronaut";

UPDATE samdb.songlist set lyrics="CA" where artist="Godspeed! You Black Emperor" ;

UPDATE samdb.songlist set lyrics="GB" where artist="Gong";

UPDATE samdb.songlist set lyrics="US" where artist="Grand Funk Railroad";

UPDATE samdb.songlist set lyrics="US" where artist="Grateful Dead";

UPDATE samdb.songlist set lyrics="DE" where artist="Grobschnitt";

UPDATE samdb.songlist set lyrics="US" where artist="Groove";

UPDATE samdb.songlist set lyrics="GB" where artist="GTR";

UPDATE samdb.songlist set lyrics="US" where artist="Gunn, Trey";

UPDATE samdb.songlist set lyrics="US" where artist="Gunn, Trey Band";

UPDATE samdb.songlist set lyrics="GB" where artist="Hackett, Steve";

UPDATE samdb.songlist set lyrics="CZ" where artist="Hammer, Jan";

UPDATE samdb.songlist set lyrics="US" where artist="Hamm, Stuart";

UPDATE samdb.songlist set lyrics="US" where artist="Hancock, Herbie";

UPDATE samdb.songlist set lyrics="CA" where artist="Harmonium";

UPDATE samdb.songlist set lyrics="GB" where artist="Harper, Roy";

UPDATE samdb.songlist set lyrics="GB" where artist="Harper, Roy and Page, Jimmy";

UPDATE samdb.songlist set lyrics="GB" where artist="Harrison, Gavin";

UPDATE samdb.songlist set lyrics="GB" where artist="Harrison, George";

UPDATE samdb.songlist set lyrics="GB" where artist="Hatfield And The North";

UPDATE samdb.songlist set lyrics="GB" where artist="Hawkwind";

UPDATE samdb.songlist set lyrics="US" where artist="Henderson, Scott/Steve Smith/Victor Wooten";

UPDATE samdb.songlist set lyrics="JP" where artist="Hiromi";

UPDATE samdb.songlist set lyrics="CA" where artist="Holdsworth, Allan";

UPDATE samdb.songlist set lyrics="CA" where artist="Holdsworth, Pasqua, Haslip & Wackerman";

UPDATE samdb.songlist set lyrics="US" where artist="Hosemobile";

UPDATE samdb.songlist set lyrics="US" where artist="Howe, Greg";

UPDATE samdb.songlist set lyrics="GB" where artist="Howe, Steve";

UPDATE samdb.songlist set lyrics="US" where artist="Hydro";

UPDATE samdb.songlist set lyrics="IT" where artist="Ibis";

UPDATE samdb.songlist set lyrics="NL" where artist="Ice";

UPDATE samdb.songlist set lyrics="ES" where artist="Iceberg";

UPDATE samdb.songlist set lyrics="CN" where artist="I Ching";

UPDATE samdb.songlist set lyrics="IT" where artist="Iconae";

UPDATE samdb.songlist set lyrics="MX" where artist="Iconoclasta";

UPDATE samdb.songlist set lyrics="GB" where artist="If";

UPDATE samdb.songlist set lyrics="US" where artist="If These Trees Could Talk";

UPDATE samdb.songlist set lyrics="US" where artist="Ilium";

UPDATE samdb.songlist set lyrics="NL" where artist="Illumion";

UPDATE samdb.songlist set lyrics="GB" where artist="Illusion";

UPDATE samdb.songlist set lyrics="US" where artist="Iluvata";

UPDATE samdb.songlist set lyrics="PL" where artist="Iluzjon";

UPDATE samdb.songlist set lyrics="RU" where artist="Ilyin, Gennady";

UPDATE samdb.songlist set lyrics="GB" where artist="In Cahoots";

UPDATE samdb.songlist set lyrics="BR" where artist="Index";

UPDATE samdb.songlist set lyrics="GB" where artist="Indian Summer";

UPDATE samdb.songlist set lyrics="AT" where artist="Indigo";

UPDATE samdb.songlist set lyrics="SE" where artist="Indisciplined Lucy";

UPDATE samdb.songlist set lyrics="PL" where artist="Indukti";

UPDATE samdb.songlist set lyrics="US" where artist="Infinty";

UPDATE samdb.songlist set lyrics="NL" where artist="Inflection";

UPDATE samdb.songlist set lyrics="RU" where artist="Infront";

UPDATE samdb.songlist set lyrics="US" where artist="Initiation";

UPDATE samdb.songlist set lyrics="GB" where artist="Inme";

UPDATE samdb.songlist set lyrics="US" where artist="Inner Resonance";

UPDATE samdb.songlist set lyrics="ES" where artist="In Nomine";

UPDATE samdb.songlist set lyrics="JP" where artist="Inoue, Tetsu";

UPDATE samdb.songlist set lyrics="DE" where artist="Inquire";

UPDATE samdb.songlist set lyrics="GB" where artist="Intellignetsia";

UPDATE samdb.songlist set lyrics="JP" where artist="Interface";

UPDATE samdb.songlist set lyrics="JP" where artist="Interiors";

UPDATE samdb.songlist set lyrics="JP" where artist="Interpose+";

UPDATE samdb.songlist set lyrics="DE" where artist="Intersphere, The";

UPDATE samdb.songlist set lyrics="SE" where artist="In The Labyrinth";

UPDATE samdb.songlist set lyrics="SE" where artist="Intoitus";

UPDATE samdb.songlist set lyrics="US" where artist="Intra";

UPDATE samdb.songlist set lyrics="US" where artist="Invisigoth";

UPDATE samdb.songlist set lyrics="GB" where artist="I/O Earth";

UPDATE samdb.songlist set lyrics="GB" where artist="Iommi, Tommy";

UPDATE samdb.songlist set lyrics="GB" where artist="Iona";

UPDATE samdb.songlist set lyrics="GB" where artist="IQ";

UPDATE samdb.songlist set lyrics="US" where artist="Iron Kim Style";

UPDATE samdb.songlist set lyrics="US" where artist="Isham, Mark";

UPDATE samdb.songlist set lyrics="SE" where artist="Isildurs Bane";

UPDATE samdb.songlist set lyrics="CH" where artist="Island";

UPDATE samdb.songlist set lyrics="BE" where artist="Isopoda";

UPDATE samdb.songlist set lyrics="CA" where artist="Isosceles Project, The";

UPDATE samdb.songlist set lyrics="NL" where artist="Isotope";

UPDATE samdb.songlist set lyrics="US" where artist="Isotope 217";

UPDATE samdb.songlist set lyrics="GB" where artist="It";

UPDATE samdb.songlist set lyrics="IT" where artist="Italian Rock Session Band";

UPDATE samdb.songlist set lyrics="GB" where artist="It Bites";

UPDATE samdb.songlist set lyrics="DE" where artist="It In you, The";

UPDATE samdb.songlist set lyrics="US" where artist="It's A Beautiful Day";

UPDATE samdb.songlist set lyrics="NO" where artist="It's The End";

UPDATE samdb.songlist set lyrics="DE" where artist="Ivory";

UPDATE samdb.songlist set lyrics="NL" where artist="Ixion";

UPDATE samdb.songlist set lyrics="US" where artist="IZZ";

UPDATE samdb.songlist set lyrics="US" where artist="IZZ Lite";

UPDATE samdb.songlist set lyrics="GB" where artist="Jade Warrior";

UPDATE samdb.songlist set lyrics="FR" where artist="Jarre, Jean-Michel";

UPDATE samdb.songlist set lyrics="US" where artist="Jarrett, Keith";

UPDATE samdb.songlist set lyrics="US" where artist="Jefferson Airplane";

UPDATE samdb.songlist set lyrics="GB" where artist="Jenkins, Jon";

UPDATE samdb.songlist set lyrics="GB" where artist="Jethro Tull";

UPDATE samdb.songlist set lyrics="GB" where artist="Joe Jackson & Friends";

UPDATE samdb.songlist set lyrics="US" where artist="Johnson, Eric";

UPDATE samdb.songlist set lyrics="GB" where artist="Jon And Vangelis";

UPDATE samdb.songlist set lyrics="GB" where artist="Jones, Howard";

UPDATE samdb.songlist set lyrics="GB" where artist="Jones, John Paul";

UPDATE samdb.songlist set lyrics="GB" where artist="Jon & Vangelis";

UPDATE samdb.songlist set lyrics="US" where artist="Journey";

UPDATE samdb.songlist set lyrics="US" where artist="Kansas";

UPDATE samdb.songlist set lyrics="US" where artist="Keaggy King & Dente";

UPDATE samdb.songlist set lyrics="US" where artist="Keaggy, Phil";

UPDATE samdb.songlist set lyrics="GB" where artist="Keith Emerson Band";

UPDATE samdb.songlist set lyrics="US" where artist="Keneally, Mike";

UPDATE samdb.songlist set lyrics="US" where artist="King Black Acid";

UPDATE samdb.songlist set lyrics="GB" where artist="King Crimson";

UPDATE samdb.songlist set lyrics="GB" where artist="King Crimson P1";

UPDATE samdb.songlist set lyrics="GB" where artist="King Crimson P2";

UPDATE samdb.songlist set lyrics="GB" where artist="King Crimson P3";

UPDATE samdb.songlist set lyrics="GB" where artist="King Crimson P4";

UPDATE samdb.songlist set lyrics="US" where artist="Kottke, Leo";

UPDATE samdb.songlist set lyrics="DE" where artist="Krafwerk";

UPDATE samdb.songlist set lyrics="US" where artist="Krantz, Wayne";

UPDATE samdb.songlist set lyrics="US" where artist="Krieger, Robby";

UPDATE samdb.songlist set lyrics="US" where artist="Kronos Quartet";

UPDATE samdb.songlist set lyrics="DE" where artist="Lake";

UPDATE samdb.songlist set lyrics="CA" where artist="Lanois, Daniel";

UPDATE samdb.songlist set lyrics="US" where artist="Laurie Anderson";

UPDATE samdb.songlist set lyrics="GB" where artist="Led Zeppelin";

UPDATE samdb.songlist set lyrics="CA" where artist="Lee, Geddy";

UPDATE samdb.songlist set lyrics="US" where artist="Letter E, The";

UPDATE samdb.songlist set lyrics="US" where artist="Levin, Tony";

UPDATE samdb.songlist set lyrics="US" where artist="Levin, Tony Band";

UPDATE samdb.songlist set lyrics="US" where artist="Lifetime (Tony Williams)";

UPDATE samdb.songlist set lyrics="US" where artist="Liquid Tension Experiment";

UPDATE samdb.songlist set lyrics="US" where artist="Little Feat";

UPDATE samdb.songlist set lyrics="PL" where artist="Lizard";

UPDATE samdb.songlist set lyrics="DE" where artist="Lucifer's Friend";

UPDATE samdb.songlist set lyrics="US" where artist="Lumen" ;

UPDATE samdb.songlist set lyrics="PL" where artist="Lunatic Soul";

UPDATE samdb.songlist set lyrics="US" where artist="Macalpine, Tony";

UPDATE samdb.songlist set lyrics="AT" where artist="Machacek, Alex";

UPDATE samdb.songlist set lyrics="AT" where artist="Machacek, Matthew Garrison, Jeff Sipe";

UPDATE samdb.songlist set lyrics="GB" where artist="Magnetophone";

UPDATE samdb.songlist set lyrics="GB" where artist="Mahavishnu Orchestra";

UPDATE samdb.songlist set lyrics="US" where artist="Mahavishnu Project";

UPDATE samdb.songlist set lyrics="SE" where artist="Malmsteen, Yngwie";

UPDATE samdb.songlist set lyrics="CA" where artist="Maneige";

UPDATE samdb.songlist set lyrics="GB" where artist="Marillion";

UPDATE samdb.songlist set lyrics="MX" where artist="Mars Volta, The";

UPDATE samdb.songlist set lyrics="US" where artist="Maserati";

UPDATE samdb.songlist set lyrics="GB" where artist="Mason, Nick";

UPDATE samdb.songlist set lyrics="GB" where artist="Massive Attack";

UPDATE samdb.songlist set lyrics="US" where artist="Mays, Lyle";

UPDATE samdb.songlist set lyrics="GB" where artist="McLaughlin, John";

UPDATE samdb.songlist set lyrics="US" where artist="Medeski, Martin & Wood" ;

UPDATE samdb.songlist set lyrics="US" where artist="Medeski, Scofield, Martin & Wood" ;

UPDATE samdb.songlist set lyrics="US" where artist="Metheny, Pat";

UPDATE samdb.songlist set lyrics="PL" where artist="Millenium";

UPDATE samdb.songlist set lyrics="CA" where artist="Miriodor";

UPDATE samdb.songlist set lyrics="GB" where artist="Mogwai" ;

UPDATE samdb.songlist set lyrics="JP" where artist="Mono";

UPDATE samdb.songlist set lyrics="US" where artist="Montrose";

UPDATE samdb.songlist set lyrics="US" where artist="Montrose, Ronnie";

UPDATE samdb.songlist set lyrics="GB" where artist="Moody Blues, The";

UPDATE samdb.songlist set lyrics="GB" where artist="Moraz, Pat / John Wetton / Bill Bruford";

UPDATE samdb.songlist set lyrics="CH" where artist="Moraz, Patrick";

UPDATE samdb.songlist set lyrics="GB" where artist="Moraz, Patrick + Bill Bruford";

UPDATE samdb.songlist set lyrics="CA" where artist="Morse Code";

UPDATE samdb.songlist set lyrics="US" where artist="Morse, Neal";

UPDATE samdb.songlist set lyrics="US" where artist="Morse, Steve";

UPDATE samdb.songlist set lyrics="DE" where artist="Mozart, Wolfgang Amadeus";

UPDATE samdb.songlist set lyrics="PL" where artist="Mr. Gil";

UPDATE samdb.songlist set lyrics="US" where artist="MST3K";

UPDATE samdb.songlist set lyrics="RU" where artist="Mussorgsky";

UPDATE samdb.songlist set lyrics="CA" where artist="Mystery";

UPDATE samdb.songlist set lyrics="DE" where artist="Neu!";

UPDATE samdb.songlist set lyrics="GB" where artist="Oldfield, Mike";

UPDATE samdb.songlist set lyrics="PL" where artist="Osada Vida";

UPDATE samdb.songlist set lyrics="US" where artist="OSI";

UPDATE samdb.songlist set lyrics="US" where artist="Oysterhead";

UPDATE samdb.songlist set lyrics="US" where artist="Pele";

UPDATE samdb.songlist set lyrics="US" where artist="Pell Mell";

UPDATE samdb.songlist set lyrics="US" where artist="Phish";

UPDATE samdb.songlist set lyrics="US" where artist="Physics";

UPDATE samdb.songlist set lyrics="GB" where artist="Pink Floyd";

UPDATE samdb.songlist set lyrics="US" where artist="P.O.D.";

UPDATE samdb.songlist set lyrics="CA" where artist="Pollen";

UPDATE samdb.songlist set lyrics="GB" where artist="Procol Harum";

UPDATE samdb.songlist set lyrics="BE" where artist="Quantum Fantay";

UPDATE samdb.songlist set lyrics="US" where artist="Quarkspace";

UPDATE samdb.songlist set lyrics="PT" where artist="Quarteto 1111";

UPDATE samdb.songlist set lyrics="GB" where artist="Quatermass";

UPDATE samdb.songlist set lyrics="BR" where artist="Quaterna Requiem";

UPDATE samdb.songlist set lyrics="GB" where artist="Queen";

UPDATE samdb.songlist set lyrics="IT" where artist="Quella Vecchia Locanda";

UPDATE samdb.songlist set lyrics="US" where artist="Questions in Dialect";

UPDATE samdb.songlist set lyrics="PL" where artist="Quidam";

UPDATE samdb.songlist set lyrics="GB" where artist="Quiet Sun";

UPDATE samdb.songlist set lyrics="JP" where artist="Quikion + Lithuma Qnombus";

UPDATE samdb.songlist set lyrics="GB" where artist="Quintessence";

UPDATE samdb.songlist set lyrics="CA" where artist="Qwaarn";

UPDATE samdb.songlist set lyrics="ZA" where artist="Rabin, Trevor";

UPDATE samdb.songlist set lyrics="PL" where artist="Riverside";

UPDATE samdb.songlist set lyrics="JP" where artist="Rovo" ;

UPDATE samdb.songlist set lyrics="PL" where artist="RSC";

UPDATE samdb.songlist set lyrics="US" where artist="Rumah Sakit" ;

UPDATE samdb.songlist set lyrics="CA" where artist="Rush" ;

UPDATE samdb.songlist set lyrics="US" where artist="Russian Circles";

UPDATE samdb.songlist set lyrics="PL" where artist="Sandstone";

UPDATE samdb.songlist set lyrics="PL" where artist="Satellite";

UPDATE samdb.songlist set lyrics="PL" where artist="SBB";

UPDATE samdb.songlist set lyrics="US" where artist="Schon, Neal";

UPDATE samdb.songlist set lyrics="DE" where artist="Schulze, Klaus";

UPDATE samdb.songlist set lyrics="US" where artist="Sherwood, Billy" ;

UPDATE samdb.songlist set lyrics="IS" where artist="Sigur Ros" ;

UPDATE samdb.songlist set lyrics="PL" where artist="Skaldowie";

UPDATE samdb.songlist set lyrics="CA" where artist="Sloche";

UPDATE samdb.songlist set lyrics="US" where artist="Smith, Michael W.";

UPDATE samdb.songlist set lyrics="GB" where artist="Squire, Chris";

UPDATE samdb.songlist set lyrics="US" where artist="Sweet Smoke";

UPDATE samdb.songlist set lyrics="DE" where artist="Tangerine Dream";

UPDATE samdb.songlist set lyrics="US" where artist="Tarentel" ;

UPDATE samdb.songlist set lyrics="US" where artist="Torn, David";

UPDATE samdb.songlist set lyrics="DE" where artist="To Rococo Rot";

UPDATE samdb.songlist set lyrics="US" where artist="Tortoise" ;

UPDATE samdb.songlist set lyrics="US" where artist="Turing Machine";

UPDATE samdb.songlist set lyrics="IT" where artist="Ubi Maior";

UPDATE samdb.songlist set lyrics="GB" where artist="UFO";

UPDATE samdb.songlist set lyrics="GB" where artist="U.K.";

UPDATE samdb.songlist set lyrics="US" where artist="UKZ";

UPDATE samdb.songlist set lyrics="MX" where artist="Ulises III ";

UPDATE samdb.songlist set lyrics="SE" where artist="Ulitma Thule";

UPDATE samdb.songlist set lyrics="NO" where artist="Ulver";

UPDATE samdb.songlist set lyrics="NL" where artist="Ulysses";

UPDATE samdb.songlist set lyrics="US" where artist="Umphrey's McGee";

UPDATE samdb.songlist set lyrics="US" where artist="UN1SON";

UPDATE samdb.songlist set lyrics="US" where artist="Uncle Gut";

UPDATE samdb.songlist set lyrics="US" where artist="Uncle Moe's Space Ranch";

UPDATE samdb.songlist set lyrics="GB" where artist="Underground Railroad, The";

UPDATE samdb.songlist set lyrics="AR" where artist="Under Linden";

UPDATE samdb.songlist set lyrics="US" where artist="Under The Big Tree";

UPDATE samdb.songlist set lyrics="US" where artist="Under The Sun";

UPDATE samdb.songlist set lyrics="FR" where artist="Undetermined Nation";

UPDATE samdb.songlist set lyrics="SE" where artist="Unicorn";

UPDATE samdb.songlist set lyrics="SE" where artist="Unifaun";

UPDATE samdb.songlist set lyrics="AU" where artist="Unitopia";

UPDATE samdb.songlist set lyrics="IT" where artist="Universal Totem Orchestra";

UPDATE samdb.songlist set lyrics="US" where artist="University of Errors";

UPDATE samdb.songlist set lyrics="BE" where artist="Univers Zeo";

UPDATE samdb.songlist set lyrics="IT" where artist="Uno";

UPDATE samdb.songlist set lyrics="US" where artist="Unruh, Steve";

UPDATE samdb.songlist set lyrics="US" where artist="Unwed Sailor";

UPDATE samdb.songlist set lyrics="CA" where artist="Upright";

UPDATE samdb.songlist set lyrics="US" where artist="Upsilon Acrux";

UPDATE samdb.songlist set lyrics="PL" where artist="Urbaniak, Michal";

UPDATE samdb.songlist set lyrics="US" where artist="Urban, Robert";

UPDATE samdb.songlist set lyrics="GB" where artist="Uriah Heep";

UPDATE samdb.songlist set lyrics="NL" where artist="Us";

UPDATE samdb.songlist set lyrics="US" where artist="Utopia";

UPDATE samdb.songlist set lyrics="CA" where artist="Uzeb";

UPDATE samdb.songlist set lyrics="CZ" where artist="Uz jsme doma";

UPDATE samdb.songlist set lyrics="FI" where artist="Uzva";

UPDATE samdb.songlist set lyrics="CA" where artist="Victor";

UPDATE samdb.songlist set lyrics="GB" where artist="Wakeman, Rick";

UPDATE samdb.songlist set lyrics="GB" where artist="Waters, Roger";

UPDATE samdb.songlist set lyrics="US" where artist="Weather Report";

UPDATE samdb.songlist set lyrics="GB" where artist="Woe";

UPDATE samdb.songlist set lyrics="PL" where artist="Wojtek Szadkowski feat. Peter";

UPDATE samdb.songlist set lyrics="GB" where artist="Yak";

UPDATE samdb.songlist set lyrics="FR" where artist="Yang";

UPDATE samdb.songlist set lyrics="GR" where artist="Yanni";

UPDATE samdb.songlist set lyrics="CN" where artist="Yashu";

UPDATE samdb.songlist set lyrics="DE" where artist="Yatha Sidhra";

UPDATE samdb.songlist set lyrics="GB" where artist="Yes";

UPDATE samdb.songlist set lyrics="RO" where artist="Yesterdays";

UPDATE samdb.songlist set lyrics="US" where artist="Yeti";

UPDATE samdb.songlist set lyrics="CA" where artist="Yeti Rain";

UPDATE samdb.songlist set lyrics="US" where artist="Yezda Urfa";

UPDATE samdb.songlist set lyrics="IT" where artist="Yleclipse";

UPDATE samdb.songlist set lyrics="US" where artist="Yoke Shire";

UPDATE samdb.songlist set lyrics="CL" where artist="Yonhosago";

UPDATE samdb.songlist set lyrics="IT" where artist="Zaal";

UPDATE samdb.songlist set lyrics="GB" where artist="Zakkarias";

UPDATE samdb.songlist set lyrics="US" where artist="Zao";

UPDATE samdb.songlist set lyrics="US" where artist="Zappa - Beefheart";

UPDATE samdb.songlist set lyrics="US" where artist="Zappa, Frank";

UPDATE samdb.songlist set lyrics="IT" where artist="Zappa, Riccardo";

UPDATE samdb.songlist set lyrics="DK" where artist="Zaragon";

UPDATE samdb.songlist set lyrics="IT" where artist="Zauber";

UPDATE samdb.songlist set lyrics="US" where artist="Z-Axis";

UPDATE samdb.songlist set lyrics="NZ" where artist="Zaza, Neil";

UPDATE samdb.songlist set lyrics="US" where artist="Zed";

UPDATE samdb.songlist set lyrics="CH" where artist="Zeigler, Matthais";

UPDATE samdb.songlist set lyrics="SE" where artist="Zello";

UPDATE samdb.songlist set lyrics="US" where artist="Zen Carnival";

UPDATE samdb.songlist set lyrics="CH" where artist="Zenit";

UPDATE samdb.songlist set lyrics="DE" where artist="Zenobia";

UPDATE samdb.songlist set lyrics="US" where artist="Zenpool";

UPDATE samdb.songlist set lyrics="US" where artist="Zen Rock and Roll";

UPDATE samdb.songlist set lyrics="US" where artist="Zenter, Michael";

UPDATE samdb.songlist set lyrics="JP" where artist="Zettaimu";

UPDATE samdb.songlist set lyrics="US" where artist="Zevious";

UPDATE samdb.songlist set lyrics="IL" where artist="Zingdale";

UPDATE samdb.songlist set lyrics="IT" where artist="Zita Ensemble";

UPDATE samdb.songlist set lyrics="RU" where artist="Zodiac";

UPDATE samdb.songlist set lyrics="US" where artist="Zombi";

UPDATE samdb.songlist set lyrics="DE" where artist="Zomby Woof";

UPDATE samdb.songlist set lyrics="DE" where artist="Zone Six";

UPDATE samdb.songlist set lyrics="GB" where artist="Zoo Lunaire";

UPDATE samdb.songlist set lyrics="US" where artist="Zorn, John";

UPDATE samdb.songlist set lyrics="IT" where artist="Zu";

UPDATE samdb.songlist set lyrics="IT" where artist="Zuffanti, Fabio";

UPDATE samdb.songlist set lyrics="ES" where artist="Zyclope";