Go Back   Aural Moon - Progressive Rock Discussion > Prog Rock Discussion > General Discussion/Prog News
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 07-13-2010, 09:42 AM
VAXman's Avatar
VAXman(Admin) VAXman is online now
progger propellerhead
 
Join Date: Dec 2003
Location: Presently reside in Jackson (southern) NJ (20 miles east of NEARfest 2002 & 2003
Posts: 2,362
Send a message via AIM to VAXman Send a message via Skype™ to VAXman
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:
  1. 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
  2. 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";
  3. Keep in mind that Jim does things like "The Moody Blues" "Moody Blues, The" and "Roger Waters" "Waters, Roger"

  4. 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.

  5. Don't top post!!! I will delete them!!!

  6. 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 -- Watcher of the moon, watcher of all.
----------------Mopper of the moon, mopper of all.
-------------------- Aural Moon's Janitorial Services
---------------------and Restroom Supplies, and Techno-patsy --

Cogito ergo iMac.         

Last edited by VAXman : 07-14-2010 at 07:03 AM.
Reply With Quote
  #2  
Old 07-14-2010, 07:41 AM
VAXman's Avatar
VAXman(Admin) VAXman is online now
progger propellerhead
 
Join Date: Dec 2003
Location: Presently reside in Jackson (southern) NJ (20 miles east of NEARfest 2002 & 2003
Posts: 2,362
Send a message via AIM to VAXman Send a message via Skype™ to VAXman
Re: The Aural Moon "FLAG PROJECT"

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";
__________________
VAXman -- Watcher of the moon, watcher of all.
----------------Mopper of the moon, mopper of all.
-------------------- Aural Moon's Janitorial Services
---------------------and Restroom Supplies, and Techno-patsy --

Cogito ergo iMac.         

Last edited by VAXman : 08-06-2010 at 06:28 AM.
Reply With Quote
  #3  
Old 07-14-2010, 01:32 PM
VAXman's Avatar
VAXman(Admin) VAXman is online now
progger propellerhead
 
Join Date: Dec 2003
Location: Presently reside in Jackson (southern) NJ (20 miles east of NEARfest 2002 & 2003
Posts: 2,362
Send a message via AIM to VAXman Send a message via Skype™ to VAXman
Re: The Aural Moon "FLAG PROJECT"

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 -- Watcher of the moon, watcher of all.
----------------Mopper of the moon, mopper of all.
-------------------- Aural Moon's Janitorial Services
---------------------and Restroom Supplies, and Techno-patsy --

Cogito ergo iMac.         

Last edited by VAXman : 07-16-2010 at 06:21 AM.
Reply With Quote
  #4  
Old 07-16-2010, 06:37 AM
VAXman's Avatar
VAXman(Admin) VAXman is online now
progger propellerhead
 
Join Date: Dec 2003
Location: Presently reside in Jackson (southern) NJ (20 miles east of NEARfest 2002 & 2003
Posts: 2,362
Send a message via AIM to VAXman Send a message via Skype™ to VAXman
Re: The Aural Moon "FLAG PROJECT"

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.
__________________
VAXman -- Watcher of the moon, watcher of all.
----------------Mopper of the moon, mopper of all.
-------------------- Aural Moon's Janitorial Services
---------------------and Restroom Supplies, and Techno-patsy --

Cogito ergo iMac.         
Reply With Quote
  #5  
Old 07-23-2010, 11:06 AM
dnsrees's Avatar
dnsrees dnsrees is offline
SparkDogg
 
Join Date: Jun 2010
Location: Sarasota, Florida
Posts: 40
Re: The Aural Moon "FLAG PROJECT"

ok - just posted A - Ae; will run through Am next.
Reply With Quote
  #6  
Old 08-03-2010, 07:46 AM
VAXman's Avatar
VAXman(Admin) VAXman is online now
progger propellerhead
 
Join Date: Dec 2003
Location: Presently reside in Jackson (southern) NJ (20 miles east of NEARfest 2002 & 2003
Posts: 2,362
Send a message via AIM to VAXman Send a message via Skype™ to VAXman
Re: The Aural Moon "FLAG PROJECT"

Quote:
Originally Posted by dnsrees View Post
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.
__________________
VAXman -- Watcher of the moon, watcher of all.
----------------Mopper of the moon, mopper of all.
-------------------- Aural Moon's Janitorial Services
---------------------and Restroom Supplies, and Techno-patsy --

Cogito ergo iMac.         
Reply With Quote
  #7  
Old 08-03-2010, 09:37 AM
dnsrees's Avatar
dnsrees dnsrees is offline
SparkDogg
 
Join Date: Jun 2010
Location: Sarasota, Florida
Posts: 40
Re: The Aural Moon "FLAG PROJECT"

Quote:
Originally Posted by VAXman View Post
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

Last edited by dnsrees : 08-03-2010 at 09:40 AM.
Reply With Quote
  #8  
Old 08-03-2010, 01:20 PM
VAXman's Avatar
VAXman(Admin) VAXman is online now
progger propellerhead
 
Join Date: Dec 2003
Location: Presently reside in Jackson (southern) NJ (20 miles east of NEARfest 2002 & 2003
Posts: 2,362
Send a message via AIM to VAXman Send a message via Skype™ to VAXman
Re: The Aural Moon "FLAG PROJECT"

Quote:
Originally Posted by dnsrees View Post
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
I have several copies scattered about. This is too much effort to leave to chance of being lost.
__________________
VAXman -- Watcher of the moon, watcher of all.
----------------Mopper of the moon, mopper of all.
-------------------- Aural Moon's Janitorial Services
---------------------and Restroom Supplies, and Techno-patsy --

Cogito ergo iMac.         
Reply With Quote
  #9  
Old 08-05-2010, 05:56 AM
dnsrees's Avatar
dnsrees dnsrees is offline
SparkDogg
 
Join Date: Jun 2010
Location: Sarasota, Florida
Posts: 40
Re: The Aural Moon "FLAG PROJECT"

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";
Reply With Quote
  #10  
Old 08-05-2010, 11:39 PM
Yesspaz's Avatar
Yesspaz Yesspaz is offline
Moderator
 
Join Date: May 2001
Location: Brandon, MS
Posts: 3,134
Re: The Aural Moon "FLAG PROJECT"

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.
__________________
Feels like I'm fiddling while Rome is burning down.
Think I'll lay my fiddle down, take a rifle from the ground!
Reply With Quote
  #11  
Old 08-06-2010, 06:20 AM
VAXman's Avatar
VAXman(Admin) VAXman is online now
progger propellerhead
 
Join Date: Dec 2003
Location: Presently reside in Jackson (southern) NJ (20 miles east of NEARfest 2002 & 2003
Posts: 2,362
Send a message via AIM to VAXman Send a message via Skype™ to VAXman
Re: The Aural Moon "FLAG PROJECT"

Quote:
Originally Posted by Yesspaz View Post
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 -- Watcher of the moon, watcher of all.
----------------Mopper of the moon, mopper of all.
-------------------- Aural Moon's Janitorial Services
---------------------and Restroom Supplies, and Techno-patsy --

Cogito ergo iMac.         
Reply With Quote
  #12  
Old 08-06-2010, 06:32 AM
VAXman's Avatar
VAXman(Admin) VAXman is online now
progger propellerhead
 
Join Date: Dec 2003
Location: Presently reside in Jackson (southern) NJ (20 miles east of NEARfest 2002 & 2003
Posts: 2,362
Send a message via AIM to VAXman Send a message via Skype™ to VAXman
Re: The Aural Moon "FLAG PROJECT"

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?
__________________
VAXman -- Watcher of the moon, watcher of all.
----------------Mopper of the moon, mopper of all.
-------------------- Aural Moon's Janitorial Services
---------------------and Restroom Supplies, and Techno-patsy --

Cogito ergo iMac.         
Reply With Quote
  #13  
Old 08-06-2010, 10:42 AM
Yesspaz's Avatar
Yesspaz Yesspaz is offline
Moderator
 
Join Date: May 2001
Location: Brandon, MS
Posts: 3,134
Re: The Aural Moon "FLAG PROJECT"

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.
__________________
Feels like I'm fiddling while Rome is burning down.
Think I'll lay my fiddle down, take a rifle from the ground!
Reply With Quote
  #14  
Old 08-09-2010, 04:42 PM
dnsrees's Avatar
dnsrees dnsrees is offline
SparkDogg
 
Join Date: Jun 2010
Location: Sarasota, Florida
Posts: 40
Re: The Aural Moon "FLAG PROJECT"

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.

Last edited by dnsrees : 08-09-2010 at 04:54 PM.
Reply With Quote
  #15  
Old 08-20-2010, 09:23 PM
dnsrees's Avatar
dnsrees dnsrees is offline
SparkDogg
 
Join Date: Jun 2010
Location: Sarasota, Florida
Posts: 40
Re: The Aural Moon "FLAG PROJECT"

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";
Reply With Quote
  #16  
Old 08-20-2010, 09:25 PM
dnsrees's Avatar
dnsrees dnsrees is offline
SparkDogg
 
Join Date: Jun 2010
Location: Sarasota, Florida
Posts: 40
Re: The Aural Moon "FLAG PROJECT"

ok - the b's are done. I'll start on the C's next unless someone is already doing that.
Reply With Quote
  #17  
Old 02-17-2011, 10:44 PM
Yesspaz's Avatar
Yesspaz Yesspaz is offline
Moderator
 
Join Date: May 2001
Location: Brandon, MS
Posts: 3,134
Re: The Aural Moon "FLAG PROJECT"

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";
__________________
Feels like I'm fiddling while Rome is burning down.
Think I'll lay my fiddle down, take a rifle from the ground!

Last edited by Yesspaz : 02-17-2011 at 11:38 PM.
Reply With Quote
  #18  
Old 02-18-2011, 01:25 AM
TheFish's Avatar
TheFish TheFish is offline
No clue anymore
 
Join Date: Jan 2007
Location: Campbell, CA
Posts: 1,005
Re: The Aural Moon "FLAG PROJECT"

Eric Valley is Swiss. Not french. He didn't mind but correct is correct.
__________________
"A lie gets halfway around the world before the truth has a chance to get its pants on." - Winston Churchill

" A dog will look up to you, A cat will look down on you, but a pig will look you straight in the eye" - W. Churchill

"There are three things Money can't buy, Manners, Morals and Integrity." - Me
Reply With Quote
  #19  
Old 02-18-2011, 03:41 PM
warrplayer's Avatar
warrplayer warrplayer is offline
Registered User
 
Join Date: Jul 2010
Posts: 71
Re: The Aural Moon "FLAG PROJECT"

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";

Last edited by warrplayer : 02-19-2011 at 06:34 PM.
Reply With Quote
  #20  
Old 02-23-2011, 03:20 AM
Roger -Dot- Lee's Avatar
Roger -Dot- Lee(Admin) Roger -Dot- Lee is offline
El Queso Grande
 
Join Date: Mar 2004
Location: Feet from the southern tip of the San Francisco Bay. Pity me.
Posts: 1,076
Send a message via ICQ to Roger -Dot- Lee Send a message via AIM to Roger -Dot- Lee
Re: The Aural Moon "FLAG PROJECT"

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?
__________________
Roger -Dot- Lee
El Queso Media Grande
Unrepentant Geek
Officially sanctioned station dude emeritus
Generally agreed upon second in command of OS, Web, and hardware. On the Moon.

"[m]y iPod is solar powered" Aural Moon!
Reply With Quote
Reply


Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump



All times are GMT -5. The time now is 01:49 AM.