PDA

View Full Version : The Aural Moon "FLAG PROJECT"


VAXman
07-13-2010, 09:42 AM
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):
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):


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:

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

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

For example:

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.

VAXman
07-14-2010, 07:41 AM
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";

VAXman
07-14-2010, 01:32 PM
A sight change to the "rules of the game". Just post addendum to the list. I will take your inputs and sort and merge them, and then post the list. At that time, I will delete any addendum posts so as not the confuse anyone as to whether or not they have been added.

VAXman
07-16-2010, 06:37 AM
PLEASE! That is a semi-colon at the end of each statement; not a colon.

Please be sure you end each line with the ";" as the script engine of the SQL Query Browser is very unforgiving.

dnsrees
07-23-2010, 11:06 AM
ok - just posted A - Ae; will run through Am next.

VAXman
08-03-2010, 07:46 AM
The "A" bands are complete. I'm going to start working on the "B" bands unless someone else has already done so. Please advise if you have.

Thanks...
Wow! I think we all owe Dennis a huge kudos for all for work he's done.

Thanks. At this rate, I'll have to begin the recoding of the "request" stuff for country sorting sooner than I'd expected.

BTW, I don't know if you're keeping the list too. A quote was missing on Afroskull. You might want to amend it. If not, it's amended in the compete listing in the second post here.

dnsrees
08-03-2010, 09:37 AM
Wow! I think we all owe Dennis a huge kudos for all for work he's done.

Thanks. At this rate, I'll have to begin the recoding of the "request" stuff for country sorting sooner than I'd expected.

BTW, I don't know if you're keeping the list too. A quote was missing on Afroskull. You might want to amend it. If not, it's amended in the compete listing in the second post here.

Thanks Vax - I am keeping the list I work on just as a backup so I will fix that one entry - never know when that could come in handy:D

VAXman
08-03-2010, 01:20 PM
Thanks Vax - I am keeping the list I work on just as a backup so I will fix that one entry - never know when that could come in handy:D
I have several copies scattered about. This is too much effort to leave to chance of being lost.

dnsrees
08-05-2010, 05:56 AM
UPDATE samdb.songlist set lyrics="US" where artist="B Hansen";
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="UK" 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="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="UK" 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="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="UK" where artist="Barbieri, Richard";
UPDATE samdb.songlist set lyrics="UK" where artist="Barclay James Harvest";
UPDATE samdb.songlist set lyrics="UK" 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="UK" where artist="Bark Psychosis";
UPDATE samdb.songlist set lyrics="SE" where artist="Barr";
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="UK" 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="UK" where artist="Baumgartner, Eric";
UPDATE samdb.songlist set lyrics="US" where artist="Beane, Phil";
UPDATE samdb.songlist set lyrics="US" where artist="Bear, Jeff";
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="Beastie Boys";
UPDATE samdb.songlist set lyrics="US" where artist="Beat Circus";
UPDATE samdb.songlist set lyrics="UK" 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="UK" where artist="Beggar's Tail";
UPDATE samdb.songlist set lyrics="UK" where artist="Beggars Opera";
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="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";

Yesspaz
08-05-2010, 11:39 PM
Okay, not to be TOO nitpicky, but let's check with what's already done before doing more. Some are getting redone and changed from correct to incorrect. Also, be careful in spelling and punctuation. These are cut and paste from the master list above:

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

and

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

and

UPDATE samdb.songlist set lyrics="GB" where artist="Anderson, Bruford, Wakeman, Howe";
UPDATE samdb.songlist set lyrics="UK" where artist="Anderson, Bruford, Wakeman, Howe";
UPDATE samdb.songlist set lyrics="UK" where artist="Anderson, Ian ";
UPDATE samdb.songlist set lyrics="GB" where artist="Anderson, Ian";
UPDATE samdb.songlist set lyrics="US" where artist="Anderson, Jon";
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="UK" where artist="Anderson, Laurie";

and

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

and

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

and

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



... for the record, The Album Leaf and Ilium are both US bands.

VAXman
08-06-2010, 06:20 AM
Okay, not to be TOO nitpicky, but let's check with what's already done before doing more. Some are getting redone and changed from correct to incorrect. Also, be careful in spelling and punctuation. These are cut and paste from the master list above:

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

and

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

and

UPDATE samdb.songlist set lyrics="GB" where artist="Anderson, Bruford, Wakeman, Howe";
UPDATE samdb.songlist set lyrics="UK" where artist="Anderson, Bruford, Wakeman, Howe";
UPDATE samdb.songlist set lyrics="UK" where artist="Anderson, Ian ";
UPDATE samdb.songlist set lyrics="GB" where artist="Anderson, Ian";
UPDATE samdb.songlist set lyrics="US" where artist="Anderson, Jon";
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="UK" where artist="Anderson, Laurie";

and

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

and

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

and

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



... for the record, The Album Leaf and Ilium are both US bands.

Hmm... It would appear that the sort/merge on Linux isn't as good as the sort/merge on VMS. I have been sorting on column 52 through the end and I've requested the removal of duplicates. Apparently, this is not happening. I'll be sure to sort/merge this on the better OS in the future.

"dc Talk/dcTalk" is in SAM's database that way. If you want to correct that, please do so with SAM. I think you still have station access.

"UK" should be "GB", I'll fix those. I've addressed the "Andersons" too.

VAXman
08-06-2010, 06:32 AM
BTW, there's going to be a certain level of errata. I will address this as noted. I've already made a mental note to change all "UK" to "GB".

Regardless of the monor errata, kudos to dnsrees for all his efforts.

There's still only a microcosm of the whole Aural Moon community mentioned in the first post. What are you all waiting for?

Yesspaz
08-06-2010, 10:42 AM
Oh, I'm not knocking dnsrees at all for his efforts. I've done a fraction of what he has. We just need to slow down and be more precise.

Also, I don't have station access anymore. dc Talk has a space.

dnsrees
08-09-2010, 04:42 PM
Ilium and Album Leaf, The were my errors. Typos or over edits to be sure.

I was using UK. Didn't see a rule that said GB was the standard. Sources I use to do the research, including MySpace, DPRP, and even everyone's favorite ProgArchives (which has the least amount of country info), tend to use UK.

Here is a consistent (as in multiple sources) explanation of the difference between GB and UK:


"The United Kingdom of Great Britain and Northern Ireland encompasses, as its full name suggests, Northern Ireland in addition to Great Britain.

Great Britain is composed of three areas: England, Scotland, and Wales.

As for England, it is the largest and most populous portion of the United Kingdom."


Given such an explaination, UK is certainly not wrong. After all, the original members of UK were all English and they didn't call themselves GB (England was already taken so that wasn't an option.)

I did not find a country code for Northern Ireland so at the very least if a band is based in Northern Ireland it seems we should use UK for them. GB would be inaccurate.


And for the record, both of these entries are technically correct:

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

Both are in the library; the former was born in Australia and appears to have based himself in a number of countries so what is the tie breaker?; the later is from California.

dnsrees
08-20-2010, 09:23 PM
UPDATE samdb.songlist set lyrics="IT" where artist="BFA";
UPDATE samdb.songlist set lyrics="GB" where artist="Bhatia, Amin";
UPDATE samdb.songlist set lyrics="JP" where artist="Bi Kyo Ran";
UPDATE samdb.songlist set lyrics="GB" where artist="Big Big Train";
UPDATE samdb.songlist set lyrics="GB" where artist="Big Block 454";
UPDATE samdb.songlist set lyrics="US" where artist="Big Picture";
UPDATE samdb.songlist set lyrics="GB" where artist="Big Sleep";
UPDATE samdb.songlist set lyrics="US" where artist="Bigelf";
UPDATE samdb.songlist set lyrics="IT" where artist="Biglietto Per L'inferno";
UPDATE samdb.songlist set lyrics="SE" where artist="Bijou";
UPDATE samdb.songlist set lyrics="US" where artist="Birds And Buildings";
UPDATE samdb.songlist set lyrics="DE" where artist="Birth Control";
UPDATE samdb.songlist set lyrics="FR" where artist="Bise De Buse";
UPDATE samdb.songlist set lyrics="US" where artist="Bisharat, Charlie";
UPDATE samdb.songlist set lyrics="NL" where artist="Bittertown";
UPDATE samdb.songlist set lyrics="CS" where artist="Bittova, Iva";
UPDATE samdb.songlist set lyrics="SE" where artist="Black Bonzo";
UPDATE samdb.songlist set lyrics="IT" where artist="Black Jester";
UPDATE samdb.songlist set lyrics="US" where artist="Black Math Horseman";
UPDATE samdb.songlist set lyrics="CA" where artist="Black Mountain";
UPDATE samdb.songlist set lyrics="FR" where artist="Black Noodle Project, The";
UPDATE samdb.songlist set lyrics="GB" where artist="Black Widow";
UPDATE samdb.songlist set lyrics="GB" where artist="Blackfield ";
UPDATE samdb.songlist set lyrics="GB" where artist="Blackmore's Night";
UPDATE samdb.songlist set lyrics="CA" where artist="Blais, Jacques";
UPDATE samdb.songlist set lyrics="GB" where artist="Blake, Tim";
UPDATE samdb.songlist set lyrics="CR" where artist="Blanco Project, The";
UPDATE samdb.songlist set lyrics="AT" where artist="Blank Manuscript";
UPDATE samdb.songlist set lyrics="JP" where artist="Blazing Bronze";
UPDATE samdb.songlist set lyrics="CA" where artist="Bley, Paul";
UPDATE samdb.songlist set lyrics="BR" where artist="Blezqi Zatsaz";
UPDATE samdb.songlist set lyrics="DE" where artist="Blind Ego";
UPDATE samdb.songlist set lyrics="US" where artist="Blind Owl";
UPDATE samdb.songlist set lyrics="US" where artist="Blissful Behemoth";
UPDATE samdb.songlist set lyrics="IT" where artist="Blocco Mentale";
UPDATE samdb.songlist set lyrics="IT" where artist="Blondie Fox";
UPDATE samdb.songlist set lyrics="CA" where artist="Blood Ceremony";
UPDATE samdb.songlist set lyrics="ES" where artist="Bloque";
UPDATE samdb.songlist set lyrics="GB" where artist="Blue Shift";
UPDATE samdb.songlist set lyrics="US" where artist="Blue Man Group";
UPDATE samdb.songlist set lyrics="AR" where artist="Blue Universe";
UPDATE samdb.songlist set lyrics="GB" where artist="Bob's Your Monster";
UPDATE samdb.songlist set lyrics="GB" where artist="Boddy, Ian";
UPDATE samdb.songlist set lyrics="SE" where artist="Bodin, Tomas";
UPDATE samdb.songlist set lyrics="FR" where artist="Boffo, Jean-Pascal";
UPDATE samdb.songlist set lyrics="CZ" where artist="Bohemia";
UPDATE samdb.songlist set lyrics="BE" where artist="Bollenberg Experience";
UPDATE samdb.songlist set lyrics="FR" where artist="Bolling/Rampal";
UPDATE samdb.songlist set lyrics="US" where artist="Bolt";
UPDATE samdb.songlist set lyrics="IT" where artist="Bombelli, Daniela";
UPDATE samdb.songlist set lyrics="US" where artist="Bon";
UPDATE samdb.songlist set lyrics="IT" where artist="Bondage";
UPDATE samdb.songlist set lyrics="JP" where artist="Bondage Fruit";
UPDATE samdb.songlist set lyrics="US" where artist="Bondar & Wise";
UPDATE samdb.songlist set lyrics="NL" where artist="Bonebag";
UPDATE samdb.songlist set lyrics="FR" where artist="Bony, Fabrice ";
UPDATE samdb.songlist set lyrics="SE" where artist="Bornemark, Dan";
UPDATE samdb.songlist set lyrics="ES" where artist="Bort, Eduardo";
UPDATE samdb.songlist set lyrics="US" where artist="Bosch";
UPDATE samdb.songlist set lyrics="US" where artist="Boud Deun";
UPDATE samdb.songlist set lyrics="CA" where artist="Bouliane, Daniel";
UPDATE samdb.songlist set lyrics="US" where artist="Bourelly, Jean Paul ";
UPDATE samdb.songlist set lyrics="DK" where artist="Boutrup, Lars";
UPDATE samdb.songlist set lyrics="US" where artist="Bowes, Ant";
UPDATE samdb.songlist set lyrics="CA" where artist="BOX, The";
UPDATE samdb.songlist set lyrics="NL" where artist="Brainbox";
UPDATE samdb.songlist set lyrics="AU" where artist="Brainstorm ";
UPDATE samdb.songlist set lyrics="CH" where artist="Brainticket";
UPDATE samdb.songlist set lyrics="IT" where artist="Branduardi, Angelo";
UPDATE samdb.songlist set lyrics="FR" where artist="Bréant, François";
UPDATE samdb.songlist set lyrics="GB" where artist="Breathing Space";
UPDATE samdb.songlist set lyrics="CA" where artist="Bregent";
UPDATE samdb.songlist set lyrics="US" where artist="Bremner, Paul";
UPDATE samdb.songlist set lyrics="IT" where artist="Breznev Fan Club";
UPDATE samdb.songlist set lyrics="GB" where artist="Brian Auger's Oblivion Express";
UPDATE samdb.songlist set lyrics="FI" where artist="Bride Adorned";
UPDATE samdb.songlist set lyrics="SE" where artist="Brighteye Brison";
UPDATE samdb.songlist set lyrics="FR" where artist="Broguiere, Patrick";
UPDATE samdb.songlist set lyrics="SE" where artist="Brother Ape";
UPDATE samdb.songlist set lyrics="ZA" where artist="Brotherhood Of Breath";
UPDATE samdb.songlist set lyrics="NL" where artist="Brown vs Brown";
UPDATE samdb.songlist set lyrics="GB" where artist="Brown, Arthur";
UPDATE samdb.songlist set lyrics="US" where artist="Brown, Charles";
UPDATE samdb.songlist set lyrics="US" where artist="Bubblemath";
UPDATE samdb.songlist set lyrics="AR" where artist="Bubu";
UPDATE samdb.songlist set lyrics="US" where artist="Buckethead";
UPDATE samdb.songlist set lyrics="JP" where artist="Budderfly";
UPDATE samdb.songlist set lyrics="US" where artist="Buffett, Peter ";
UPDATE samdb.songlist set lyrics="IT" where artist="Buon Vecchio Charlie";
UPDATE samdb.songlist set lyrics="GB" where artist="Burke, Declan";
UPDATE samdb.songlist set lyrics="GB" where artist="Burness, Tim";
UPDATE samdb.songlist set lyrics="DK" where artist="Burnin' Red Ivanhoe";
UPDATE samdb.songlist set lyrics="GB" where artist="Bush, Kate";

dnsrees
08-20-2010, 09:25 PM
ok - the b's are done. I'll start on the C's next unless someone is already doing that.

Yesspaz
02-17-2011, 10:44 PM
UPDATE samdb.songlist set lyrics="SE" where artist="Sinkadus";
UPDATE samdb.songlist set lyrics="US" where artist="Hoekstra, Joel";
UPDATE samdb.songlist set lyrics="US" where artist="Fonya";

TheFish
02-18-2011, 01:25 AM
Eric Valley is Swiss. Not french. He didn't mind but correct is correct.

warrplayer
02-18-2011, 03:41 PM
UPDATE samdb.songlist set lyrics="US" where artist="99 Names of God";
UPDATE samdb.songlist set lyrics="CH" where artist="Circus";
UPDATE samdb.songlist set lyrics="US" where artist="Hands";
UPDATE samdb.songlist set lyrics="US" where artist="Herd Of Instinct";

Roger -Dot- Lee
02-23-2011, 03:20 AM
Man, I have REALLY missed the collaborative spirit of this group. Keep it up and I might start being not so scarce.

Oh, and potentially good news on the job front. More elsewhere if sufficient interest is shown and sufficient memory is retained.

Oh, and do we have any NZ moonies and have they checked in?

mailotron
02-24-2011, 10:30 AM
i decided today to help the project. i began with the initial Z bands . unfortunately when i reached the Zodiac band name , a single keyboard mistake kicked me out of this message box and all the work done was lost .. Does it work if I work on a' word sheet 'then copy and paste it in the message box?

mariocc
02-24-2011, 11:56 AM
I want to do the same..is it possible to send a xls file or doc file ..copy/p ?

VAXman
02-24-2011, 01:11 PM
i decided today to help the project. i began with the initial Z bands . unfortunately when i reached the Zodiac band name , a single keyboard mistake kicked me out of this message box and all the work done was lost .. Does it work if I work on a' word sheet 'then copy and paste it in the message box?
Yes. OR... let me know and I'll give you an ftp login to upload your effort.

VAXman
02-24-2011, 01:12 PM
I want to do the same..is it possible to send a xls file or doc file ..copy/p ?
DO ME NO FAVORS! Keep anything Micro$oft out of my sight.

Plain *TEXT* with the SQL. Text!!! not something that looks like text.

mailotron
02-24-2011, 02:41 PM
Yes. OR... let me know and I'll give you an ftp login to upload your effort.

ok and thx vax

dnsrees
02-24-2011, 04:52 PM
Vax - can you post the latest set? Would be a shame if someone started working on a portion that is already complete.

Yesspaz
03-10-2011, 03:43 PM
UPDATE samdb.songlist set lyrics="RU" where artist="Dreams of My Sky";
UPDATE samdb.songlist set lyrics="CA" where artist="Saga";
UPDATE samdb.songlist set lyrics="US" where artist="Gak Omek, The";
UPDATE samdb.songlist set lyrics="IT" where artist="Filoritmia";
UPDATE samdb.songlist set lyrics="HU" where artist="Solaris";
UPDATE samdb.songlist set lyrics="GB" where artist="Voyager Project";
UPDATE samdb.songlist set lyrics="FR" where artist="Ponty, Jean-Luc";
UPDATE samdb.songlist set lyrics="GB" where artist="Wishbone Ash";
UPDATE samdb.songlist set lyrics="CA" where artist="True Myth";
UPDATE samdb.songlist set lyrics="DE" where artist="Kraan";
UPDATE samdb.songlist set lyrics="US" where artist="Wood, Mark";
UPDATE samdb.songlist set lyrics="JP" where artist="Mr. Sirius";
UPDATE samdb.songlist set lyrics="GB" where artist="Citizen Cain";
UPDATE samdb.songlist set lyrics="GB" where artist="Motiffe";
UPDATE samdb.songlist set lyrics="DE" where artist="Passport";

Yesspaz
07-17-2011, 09:30 AM
UPDATE samdb.songlist set lyrics="IT" where artist="Luz Escondida";
UPDATE samdb.songlist set lyrics="GB" where artist="Powell, Cozy";
UPDATE samdb.songlist set lyrics="US" where artist="Tunnels";
UPDATE samdb.songlist set lyrics="FR" where artist="Sandrose";
UPDATE samdb.songlist set lyrics="US" where artist="Deluge Grander";
UPDATE samdb.songlist set lyrics="US" where artist="Chroma Key";
UPDATE samdb.songlist set lyrics="GB" where artist="Wally";
UPDATE samdb.songlist set lyrics="GB" where artist="Mostly Autumn";
UPDATE samdb.songlist set lyrics="US" where artist="Scofield, John & Pat Metheny";
UPDATE samdb.songlist set lyrics="US" where artist="Zappa, Frank";
UPDATE samdb.songlist set lyrics="EE" where artist="Kaseke";
UPDATE samdb.songlist set lyrics="NA" where artist="Flairck";
UPDATE samdb.songlist set lyrics="NO" where artist="Ericksen, Mats";

Yesspaz
07-22-2011, 08:34 AM
UPDATE samdb.songlist set lyrics="US" where artist="House of Usher";
UPDATE samdb.songlist set lyrics="US" where artist="McLuhan";
UPDATE samdb.songlist set lyrics="US" where artist="Thanatopsis";
UPDATE samdb.songlist set lyrics="US" where artist="Pentwater";
UPDATE samdb.songlist set lyrics="IT" where artist="Trama";
UPDATE samdb.songlist set lyrics="GB" where artist="Random Hold";

emperorken
07-24-2011, 11:10 PM
bump

emperorken
07-25-2011, 08:28 AM
UPDATE samdb.songlist set lyrics="US" where artist="Macalpine, Tony";
UPDATE samdb.songlist set lyrics="AT" where artist="MacHacek;
UPDATE samdb.songlist set lyrics="AT" where artist="Machacek, Alex;
UPDATE samdb.songlist set lyrics="BE" where artist="Machiavel;
UPDATE samdb.songlist set lyrics="JP" where artist="Machine And The Synergetic Nuts;
UPDATE samdb.songlist set lyrics="ES" where artist="Macìa, Manoel;
UPDATE samdb.songlist set lyrics="GB" where artist="Mackay, Duncan;
UPDATE samdb.songlist set lyrics="AU" where artist="Mackenzie Theory;
UPDATE samdb.songlist set lyrics="IT" where artist="Macro Marco;
UPDATE samdb.songlist set lyrics="IT" where artist="Mad Crayon;
UPDATE samdb.songlist set lyrics="AU" where artist="Madder Lake;
UPDATE samdb.songlist set lyrics="SE" where artist="Made In Sweden;
UPDATE samdb.songlist set lyrics="BE" where artist="Madelgaire;
UPDATE samdb.songlist set lyrics="DE" where artist="Madrigal;
UPDATE samdb.songlist set lyrics="DK" where artist="Mads Vinding Group;
UPDATE samdb.songlist set lyrics="US" where artist="Madsen, Bernie;
UPDATE samdb.songlist set lyrics="GB" where artist="Mae, Vanessa;
UPDATE samdb.songlist set lyrics="US" where artist="Maelström Percussion Ensemble;
UPDATE samdb.songlist set lyrics="GB" where artist="Maestoso;
UPDATE samdb.songlist set lyrics="JP" where artist="Magdalena;
UPDATE samdb.songlist set lyrics="US" where artist="Magellan;
UPDATE samdb.songlist set lyrics="US" where artist="Magellan Music;
UPDATE samdb.songlist set lyrics="GB" where artist="Magenta;
UPDATE samdb.songlist set lyrics="GB" where artist="Magenta w/Annie Haslam;
UPDATE samdb.songlist set lyrics="IT" where artist="Maggiore, Giorgio;
UPDATE samdb.songlist set lyrics="US" where artist="Magic Elf, The;
UPDATE samdb.songlist set lyrics="NO" where artist="Magic Pie;
UPDATE samdb.songlist set lyrics="JP" where artist="Magical Power Mako;
UPDATE samdb.songlist set lyrics="FR" where artist="Magma;
UPDATE samdb.songlist set lyrics="FR" where artist="Magnesis;
UPDATE samdb.songlist set lyrics="IT" where artist="Magnetic Sound Machine;

emperorken
07-25-2011, 08:40 AM
UPDATE samdb.songlist set lyrics="US" where artist="Macalpine, Tony";
UPDATE samdb.songlist set lyrics="AT" where artist="MacHacek";
UPDATE samdb.songlist set lyrics="AT" where artist="Machacek, Alex";
UPDATE samdb.songlist set lyrics="BE" where artist="Machiavel";
UPDATE samdb.songlist set lyrics="JP" where artist="Machine And The Synergetic Nuts";
UPDATE samdb.songlist set lyrics="ES" where artist="Macìa, Manoel";
UPDATE samdb.songlist set lyrics="GB" where artist="Mackay, Duncan";
UPDATE samdb.songlist set lyrics="AU" where artist="Mackenzie Theory";
UPDATE samdb.songlist set lyrics="IT" where artist="Macro Marco";
UPDATE samdb.songlist set lyrics="IT" where artist="Mad Crayon";
UPDATE samdb.songlist set lyrics="AU" where artist="Madder Lake";
UPDATE samdb.songlist set lyrics="SE" where artist="Made In Sweden";
UPDATE samdb.songlist set lyrics="BE" where artist="Madelgaire";
UPDATE samdb.songlist set lyrics="DE" where artist="Madrigal";
UPDATE samdb.songlist set lyrics="DK" where artist="Mads Vinding Group";
UPDATE samdb.songlist set lyrics="US" where artist="Madsen, Bernie";
UPDATE samdb.songlist set lyrics="GB" where artist="Mae, Vanessa";
UPDATE samdb.songlist set lyrics="US" where artist="Maelström Percussion Ensemble";
UPDATE samdb.songlist set lyrics="GB" where artist="Maestoso";
UPDATE samdb.songlist set lyrics="JP" where artist="Magdalena";
UPDATE samdb.songlist set lyrics="US" where artist="Magellan";
UPDATE samdb.songlist set lyrics="US" where artist="Magellan Music";
UPDATE samdb.songlist set lyrics="GB" where artist="Magenta";
UPDATE samdb.songlist set lyrics="GB" where artist="Magenta w/Annie Haslam";
UPDATE samdb.songlist set lyrics="IT" where artist="Maggiore, Giorgio";
UPDATE samdb.songlist set lyrics="US" where artist="Magic Elf, The";
UPDATE samdb.songlist set lyrics="NO" where artist="Magic Pie";
UPDATE samdb.songlist set lyrics="JP" where artist="Magical Power Mako";
UPDATE samdb.songlist set lyrics="FR" where artist="Magma";
UPDATE samdb.songlist set lyrics="FR" where artist="Magnesis";
UPDATE samdb.songlist set lyrics="IT" where artist="Magnetic Sound Machine";

Corrected. Disregard porevious.

Yesspaz
07-31-2011, 02:52 PM
UPDATE samdb.songlist set lyrics="SE" where artist="Brighteye Brison";
UPDATE samdb.songlist set lyrics="US" where artist="Gleeson, Patrick";
UPDATE samdb.songlist set lyrics="AU" where artist="Dead Letter Circus";
UPDATE samdb.songlist set lyrics="FR" where artist="Nemo";
UPDATE samdb.songlist set lyrics="GB" where artist="Seventh Wave";
UPDATE samdb.songlist set lyrics="US" where artist="Tuner";
UPDATE samdb.songlist set lyrics="SE" where artist="Larrson, Lalle";
UPDATE samdb.songlist set lyrics="SE" where artist="De Gladas Kapell";
UPDATE samdb.songlist set lyrics="SE" where artist="Brighteye Brison";

gr8sho92
10-27-2013, 10:36 PM
A few questions. First, is the methodology described in this thread still the latest way to get things updated in the database?

Second, was Dale involved in any of this? My memory is a bit fuzzy but I thought he was involved in some mass update.

Third, can a pull be done from the database to show which artists are flagless?

And finally, is there an editor to proof submissions if one choses to participate?

Yesspaz
10-30-2013, 05:18 PM
Third, can a pull be done from the database to show which artists are flagless?

And finally, is there an editor to proof submissions if one choses to participate?Nice call on three for sure.

gr8sho92
10-31-2013, 08:21 PM
Judging by the amount of songs being played without a flag, I'm guessing the list is going to be fairly large.

BTW, if there was a public database with an API or SPI to access data like country of origin, I'm sure a neat program could be written to actually populate the missing values.

Yesspaz
11-01-2013, 08:27 PM
BTW, if there was a public database with an API or SPI to access data like country of origin, I'm sure a neat program could be written to actually populate the missing values.Except for how often those databases are inaccurate. I've seen correct country flags changed to incorrect because someone "added" the value in this list by going through it alphabetically, doing them all.

My MO, back when I worked on it, was when I saw an artist without a flag play, I wrote it down. When I had twenty or so I did those. I may have to get back to that a bit.