2006-08-22 12:14:09.6504 SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning' 2006-08-22 12:14:09.6534 SELECT COUNT( DISTINCT( me.id ) ) FROM tracks me WHERE ( me.audio = ? ): '1' 2006-08-22 12:14:09.6795 SELECT COUNT( DISTINCT( me.id ) ) FROM albums me: 2006-08-22 12:14:09.6840 SELECT COUNT( DISTINCT( me.id ) ) FROM contributors me LEFT JOIN contributor_album contributorAlbums ON ( contributorAlbums.contributor = me.id ) JOIN albums album ON ( album.id = contributorAlbums.album ) WHERE ( ( ( album.compilation IS NULL ) OR ( album.compilation = ? ) ) AND contributorAlbums.role IN ( ?, ?, ?, ?, ? ) ): '0', '1', '2', '3', '4', '5' 2006-08-22 12:14:09.6937 ->addLibraryStats() found 11618 songs, 984 albums & 471 artists 2006-08-22 12:14:22.1796 Setup::rescan - initiating scan of type: [rescan] 2006-08-22 12:14:22.1808 SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning' 2006-08-22 12:14:22.1818 SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning' 2006-08-22 12:14:25.4628 SELECT COUNT( * ) FROM tracks me: 2006-08-22 12:14:25.4718 SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning' 2006-08-22 12:14:25.4779 Import: Adding Slim::Music::PlaylistFolderScan Scan 2006-08-22 12:14:25.4874 Import: Adding Slim::Music::MusicFolderScan Scan 2006-08-22 12:14:25.4890 SELECT me.name, me.value FROM metainformation me WHERE ( ( me.name = ? ) ): 'isScanning' 2006-08-22 12:14:25.4984 UPDATE metainformation SET value = ? WHERE ( name = ? ): '1', 'isScanning' 2006-08-22 12:14:25.4996 Import: Starting Slim::Music::MusicFolderScan scan 2006-08-22 12:14:28.5911 SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning' 2006-08-22 12:14:43.4544 levelMap: $VAR1 = { 'album' => 'track' }; 2006-08-22 12:14:43.4547 filters: $VAR1 = {}; 2006-08-22 12:14:43.4550 find: $VAR1 = {}; 2006-08-22 12:14:43.4553 $self->result_class: [Slim::Schema::Album] 2006-08-22 12:14:43.4555 descend: working on level: [Album] 2006-08-22 12:14:43.4556 $self->result_source->schema->source($level)->result_class: [Slim::Schema::Album] 2006-08-22 12:14:43.4558 Calling method: [browse] 2006-08-22 12:14:43.4582 SELECT COUNT( DISTINCT( me.id ) ) FROM albums me LEFT JOIN contributor_album contributorAlbums ON ( contributorAlbums.album = me.id ) JOIN contributors contributor ON ( contributor.id = contributorAlbums.contributor ): 2006-08-22 12:14:43.4620 SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning' 2006-08-22 12:15:22.1953 SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning' 2006-08-22 12:16:22.2071 SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning' 2006-08-22 12:17:22.2191 SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning' 2006-08-22 12:18:22.2336 SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning' 2006-08-22 12:19:22.2436 SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning' 2006-08-22 12:20:22.2548 SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning' 2006-08-22 12:21:22.2682 SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning' 2006-08-22 12:21:50.6403 SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'lastRescanTime' 2006-08-22 12:22:22.2799 SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning' 2006-08-22 12:23:22.2919 SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning' 2006-08-22 12:23:48.5398 Found 11637 files in \\bob\music\flac 2006-08-22 12:23:48.5609 SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( url = ? ): 'file:////bob/music/flac/_Various%20Artists%20-%20Soundtracks/Trainspotting/02%20Deep%20Blue%20Day.flac' 2006-08-22 12:23:48.7315 INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, channels, content_type, drm, filesize, lossless, rating, remote, samplerate, secs, timestamp, title, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): '1', '0', '17843799', '603418.62667719', '2', 'flc', '0', '17843799', '1', '0', '0', '44100', '236.506666666667', '1152590338', 'Deep Blue Day', 'DEEP BLUE DAY', 'DEEP BLUE DAY', '2', 'file:////bob/music/flac/_Various%20Artists%20-%20Soundtracks/Trainspotting/02%20Deep%20Blue%20Day.flac', '1996' 2006-08-22 12:23:48.7400 SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable FROM genres me WHERE ( ( me.namesearch = ? ) ): 'SOUNDTRACK' 2006-08-22 12:23:48.7543 INSERT INTO genres (name, namesearch, namesort) VALUES (?, ?, ?): 'Soundtrack', 'SOUNDTRACK', 'SOUNDTRACK' 2006-08-22 12:23:48.7619 SELECT me.genre, me.track FROM genre_track me WHERE ( ( me.genre = ? AND me.track = ? ) OR ( me.genre = ? AND me.track = ? ) ): '1', '1', '1', '1' 2006-08-22 12:23:48.7760 INSERT INTO genre_track (genre, track) VALUES (?, ?): '1', '1' 2006-08-22 12:23:48.7836 SELECT me.id, me.name, me.namesort, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id FROM contributors me WHERE ( ( me.namesearch = ? ) ): 'VARIOUS ARTISTS' 2006-08-22 12:23:48.7977 INSERT INTO contributors (musicbrainz_id, name, namesearch, namesort) VALUES (?, ?, ?, ?): 'NULL', 'Various Artists', 'VARIOUS ARTISTS', 'VARIOUS ARTISTS' 2006-08-22 12:23:48.8050 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( ( me.contributor = ? AND me.role = ? AND me.track = ? ) OR ( me.contributor = ? AND me.role = ? AND me.track = ? ) ): '1', '5', '1', '1', '5', '1' 2006-08-22 12:23:48.8192 INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?): '1', '5', '1' 2006-08-22 12:23:48.8262 SELECT me.id, me.name, me.namesort, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id FROM contributors me WHERE ( ( me.namesearch = ? ) ): 'BRIAN ENO' 2006-08-22 12:23:48.8280 INSERT INTO contributors (musicbrainz_id, name, namesearch, namesort) VALUES (?, ?, ?, ?): 'NULL', 'Brian Eno', 'BRIAN ENO', 'ENO BRIAN' 2006-08-22 12:23:48.8306 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( ( me.contributor = ? AND me.role = ? AND me.track = ? ) OR ( me.contributor = ? AND me.role = ? AND me.track = ? ) ): '2', '1', '1', '2', '1', '1' 2006-08-22 12:23:48.8322 INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?): '2', '1', '1' 2006-08-22 12:23:48.8354 SELECT me.id, me.titlesort, me.compilation, me.year, me.artwork, me.disc, me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak, me.musicbrainz_id, me.title FROM albums me LEFT JOIN tracks tracks ON ( tracks.album = me.id ) WHERE ( me.compilation = ? AND me.disc IS NULL AND me.discc IS NULL AND me.title = ? AND tracks.url LIKE ? ) GROUP BY me.id: '1', 'Trainspotting', 'file:////bob/music/flac/_Various%20Artists%20-%20Soundtracks/Trainspotting%' 2006-08-22 12:23:48.8511 INSERT INTO albums (title) VALUES (?): 'Trainspotting' 2006-08-22 12:23:48.8602 SELECT me.role, me.contributor, me.album FROM contributor_album me WHERE ( ( me.album = ? AND me.contributor = ? AND me.role = ? ) OR ( me.album = ? AND me.contributor = ? AND me.role = ? ) ): '1', '1', '5', '1', '1', '5' 2006-08-22 12:23:48.8743 INSERT INTO contributor_album (album, contributor, role) VALUES (?, ?, ?): '1', '1', '5' 2006-08-22 12:23:48.8816 SELECT me.role, me.contributor, me.album FROM contributor_album me WHERE ( ( me.album = ? AND me.contributor = ? AND me.role = ? ) OR ( me.album = ? AND me.contributor = ? AND me.role = ? ) ): '1', '2', '1', '1', '2', '1' 2006-08-22 12:23:48.8833 INSERT INTO contributor_album (album, contributor, role) VALUES (?, ?, ?): '1', '2', '1' 2006-08-22 12:23:48.8897 UPDATE albums SET compilation = ?, titlesearch = ?, titlesort = ?, year = ? WHERE ( id = ? ): '1', 'TRAINSPOTTING', 'TRAINSPOTTING', '1996', '1' 2006-08-22 12:23:48.8960 UPDATE tracks SET album = ? WHERE ( id = ? ): '1', '1' 2006-08-22 12:23:48.8989 SELECT me.id FROM years me WHERE ( ( me.id = ? ) ): '1996' 2006-08-22 12:23:48.9128 INSERT INTO years (id) VALUES (?): '1996' 2006-08-22 12:23:48.9325 SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( url = ? ): 'file:////bob/music/flac/Led%20Zeppelin/Houses%20of%20the%20Holy/03%20Over%20The%20Hills%20And%20Far%20Away.flac' 2006-08-22 12:23:48.9940 INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, channels, content_type, drm, filesize, lossless, rating, remote, samplerate, secs, timestamp, title, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): '1', '0', '29587890', '815520.551343901', '2', 'flc', '0', '29587890', '1', '0', '0', '44100', '290.2', '1153768265', 'Over The Hills And Far Away', 'OVER THE HILLS AND FAR AWAY', 'OVER THE HILLS AND FAR AWAY', '3', 'file:////bob/music/flac/Led%20Zeppelin/Houses%20of%20the%20Holy/03%20Over%20The%20Hills%20And%20Far%20Away.flac', '1973' 2006-08-22 12:23:48.9967 SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable FROM genres me WHERE ( ( me.namesearch = ? ) ): 'ROCK' 2006-08-22 12:23:48.9984 INSERT INTO genres (name, namesearch, namesort) VALUES (?, ?, ?): 'Rock', 'ROCK', 'ROCK' 2006-08-22 12:23:48.0006 SELECT me.genre, me.track FROM genre_track me WHERE ( ( me.genre = ? AND me.track = ? ) OR ( me.genre = ? AND me.track = ? ) ): '2', '2', '2', '2' 2006-08-22 12:23:48.0022 INSERT INTO genre_track (genre, track) VALUES (?, ?): '2', '2' 2006-08-22 12:23:48.0042 SELECT me.id, me.name, me.namesort, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id FROM contributors me WHERE ( ( me.namesearch = ? ) ): 'LED ZEPPELIN' 2006-08-22 12:23:48.0061 INSERT INTO contributors (musicbrainz_id, name, namesearch, namesort) VALUES (?, ?, ?, ?): 'NULL', 'Led Zeppelin', 'LED ZEPPELIN', 'LED ZEPPELIN' 2006-08-22 12:23:49.0090 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( ( me.contributor = ? AND me.role = ? AND me.track = ? ) OR ( me.contributor = ? AND me.role = ? AND me.track = ? ) ): '3', '1', '2', '3', '1', '2' 2006-08-22 12:23:49.0116 INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?): '3', '1', '2' 2006-08-22 12:23:49.0144 SELECT me.id, me.titlesort, me.compilation, me.year, me.artwork, me.disc, me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak, me.musicbrainz_id, me.title FROM albums me LEFT JOIN tracks tracks ON ( tracks.album = me.id ) WHERE ( me.compilation = ? AND me.disc IS NULL AND me.discc IS NULL AND me.title = ? AND tracks.url LIKE ? ) GROUP BY me.id: '0', 'Houses of the Holy', 'file:////bob/music/flac/Led%20Zeppelin/Houses%20of%20the%20Holy%' 2006-08-22 12:23:49.0179 INSERT INTO albums (title) VALUES (?): 'Houses of the Holy' 2006-08-22 12:23:49.0222 SELECT me.role, me.contributor, me.album FROM contributor_album me WHERE ( ( me.album = ? AND me.contributor = ? AND me.role = ? ) OR ( me.album = ? AND me.contributor = ? AND me.role = ? ) ): '2', '3', '1', '2', '3', '1' 2006-08-22 12:23:49.0238 INSERT INTO contributor_album (album, contributor, role) VALUES (?, ?, ?): '2', '3', '1' 2006-08-22 12:23:49.0255 UPDATE albums SET compilation = ?, titlesearch = ?, titlesort = ?, year = ? WHERE ( id = ? ): '0', 'HOUSES OF THE HOLY', 'HOUSES OF THE HOLY', '1973', '2' 2006-08-22 12:23:49.0270 UPDATE tracks SET album = ? WHERE ( id = ? ): '2', '2' 2006-08-22 12:23:49.0290 SELECT me.id FROM years me WHERE ( ( me.id = ? ) ): '1973' 2006-08-22 12:23:49.0303 INSERT INTO years (id) VALUES (?): '1973' 2006-08-22 12:23:49.0319 SELECT me.id, me.track, me.value FROM comments me WHERE ( track = ? AND value = ? ): '2', 'Original CD, not the 2005 remaster' 2006-08-22 12:23:49.0398 INSERT INTO comments (track, value) VALUES (?, ?): '2', 'Original CD, not the 2005 remaster' 2006-08-22 12:23:49.0584 SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( url = ? ): 'file:////bob/music/flac/The%20Notting%20Hillbillies/Missing...%20Presumed%20Having%20a%20Good%20Time/01%20Railroad%20Worksong.flac' 2006-08-22 12:23:49.1193 INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, channels, content_type, drm, filesize, lossless, rating, remote, samplerate, secs, timestamp, title, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): '1', '0', '30661110', '745952.907778409', '2', 'flc', '0', '30661110', '1', '0', '0', '44100', '328.773333333333', '1123053751', 'Railroad Worksong', 'RAILROAD WORKSONG', 'RAILROAD WORKSONG', '1', 'file:////bob/music/flac/The%20Notting%20Hillbillies/Missing...%20Presumed%20Having%20a%20Good%20Time/01%20Railroad%20Worksong.flac', '1990' 2006-08-22 12:23:49.1220 SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable FROM genres me WHERE ( ( me.namesearch = ? ) ): 'ROCK' 2006-08-22 12:23:49.1245 SELECT me.genre, me.track FROM genre_track me WHERE ( ( me.genre = ? AND me.track = ? ) OR ( me.genre = ? AND me.track = ? ) ): '2', '3', '2', '3' 2006-08-22 12:23:49.1260 INSERT INTO genre_track (genre, track) VALUES (?, ?): '2', '3' 2006-08-22 12:23:49.1281 SELECT me.id, me.name, me.namesort, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id FROM contributors me WHERE ( ( me.namesearch = ? ) ): 'THE NOTTING HILLBILLIES' 2006-08-22 12:23:49.1299 INSERT INTO contributors (musicbrainz_id, name, namesearch, namesort) VALUES (?, ?, ?, ?): 'NULL', 'The Notting Hillbillies', 'THE NOTTING HILLBILLIES', 'THE NOTTING HILLBILLIES' 2006-08-22 12:23:49.1323 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( ( me.contributor = ? AND me.role = ? AND me.track = ? ) OR ( me.contributor = ? AND me.role = ? AND me.track = ? ) ): '4', '1', '3', '4', '1', '3' 2006-08-22 12:23:49.1340 INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?): '4', '1', '3' 2006-08-22 12:23:49.1364 SELECT me.id, me.titlesort, me.compilation, me.year, me.artwork, me.disc, me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak, me.musicbrainz_id, me.title FROM albums me LEFT JOIN tracks tracks ON ( tracks.album = me.id ) WHERE ( me.disc IS NULL AND me.discc IS NULL AND me.title = ? AND tracks.url LIKE ? ) GROUP BY me.id: 'Missing... Presumed Having a Good Time', 'file:////bob/music/flac/The%20Notting%20Hillbillies/Missing...%20Presumed%20Having%20a%20Good%20Time%' 2006-08-22 12:23:49.1400 INSERT INTO albums (title) VALUES (?): 'Missing... Presumed Having a Good Time' 2006-08-22 12:23:49.1443 SELECT me.role, me.contributor, me.album FROM contributor_album me WHERE ( ( me.album = ? AND me.contributor = ? AND me.role = ? ) OR ( me.album = ? AND me.contributor = ? AND me.role = ? ) ): '3', '4', '1', '3', '4', '1' 2006-08-22 12:23:49.1460 INSERT INTO contributor_album (album, contributor, role) VALUES (?, ?, ?): '3', '4', '1' 2006-08-22 12:23:49.1476 UPDATE albums SET titlesearch = ?, titlesort = ?, year = ? WHERE ( id = ? ): 'MISSING PRESUMED HAVING A GOOD TIME', 'MISSING PRESUMED HAVING A GOOD TIME', '1990', '3' 2006-08-22 12:23:49.1492 UPDATE tracks SET album = ? WHERE ( id = ? ): '3', '3' 2006-08-22 12:23:49.1512 SELECT me.id FROM years me WHERE ( ( me.id = ? ) ): '1990' 2006-08-22 12:23:49.1525 INSERT INTO years (id) VALUES (?): '1990' 2006-08-22 12:23:49.1660 SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( url = ? ): 'file:////bob/music/flac/John%20Scofield/Works%20for%20Me/11%20Freepie.flac' 2006-08-22 12:23:49.2320 INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, channels, content_type, drm, filesize, lossless, rating, remote, samplerate, secs, timestamp, title, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): '1', '0', '10611487', '627940.10853478', '2', 'flc', '0', '10611487', '1', '0', '0', '44100', '135.133333333333', '1152399853', 'Freepie', 'FREEPIE', 'FREEPIE', '11', 'file:////bob/music/flac/John%20Scofield/Works%20for%20Me/11%20Freepie.flac', '2001' 2006-08-22 12:23:49.2347 SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable FROM genres me WHERE ( ( me.namesearch = ? ) ): 'JAZZ' 2006-08-22 12:23:49.2365 INSERT INTO genres (name, namesearch, namesort) VALUES (?, ?, ?): 'Jazz', 'JAZZ', 'JAZZ' 2006-08-22 12:23:49.2388 SELECT me.genre, me.track FROM genre_track me WHERE ( ( me.genre = ? AND me.track = ? ) OR ( me.genre = ? AND me.track = ? ) ): '3', '4', '3', '4' 2006-08-22 12:23:49.2403 INSERT INTO genre_track (genre, track) VALUES (?, ?): '3', '4' 2006-08-22 12:23:49.2424 SELECT me.id, me.name, me.namesort, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id FROM contributors me WHERE ( ( me.namesearch = ? ) ): 'JOHN SCOFIELD' 2006-08-22 12:23:49.2442 INSERT INTO contributors (musicbrainz_id, name, namesearch, namesort) VALUES (?, ?, ?, ?): 'NULL', 'John Scofield', 'JOHN SCOFIELD', 'SCOFIELD JOHN' 2006-08-22 12:23:49.2469 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( ( me.contributor = ? AND me.role = ? AND me.track = ? ) OR ( me.contributor = ? AND me.role = ? AND me.track = ? ) ): '5', '1', '4', '5', '1', '4' 2006-08-22 12:23:49.2485 INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?): '5', '1', '4' 2006-08-22 12:23:49.2510 SELECT me.id, me.titlesort, me.compilation, me.year, me.artwork, me.disc, me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak, me.musicbrainz_id, me.title FROM albums me LEFT JOIN tracks tracks ON ( tracks.album = me.id ) WHERE ( me.compilation = ? AND me.disc IS NULL AND me.discc IS NULL AND me.title = ? AND tracks.url LIKE ? ) GROUP BY me.id: '0', 'Works for Me', 'file:////bob/music/flac/John%20Scofield/Works%20for%20Me%' 2006-08-22 12:23:49.2548 INSERT INTO albums (title) VALUES (?): 'Works for Me' 2006-08-22 12:23:49.2592 SELECT me.role, me.contributor, me.album FROM contributor_album me WHERE ( ( me.album = ? AND me.contributor = ? AND me.role = ? ) OR ( me.album = ? AND me.contributor = ? AND me.role = ? ) ): '4', '5', '1', '4', '5', '1' 2006-08-22 12:23:49.2609 INSERT INTO contributor_album (album, contributor, role) VALUES (?, ?, ?): '4', '5', '1' 2006-08-22 12:23:49.2625 UPDATE albums SET compilation = ?, titlesearch = ?, titlesort = ?, year = ? WHERE ( id = ? ): '0', 'WORKS FOR ME', 'WORKS FOR ME', '2001', '4' 2006-08-22 12:23:49.2640 UPDATE tracks SET album = ? WHERE ( id = ? ): '4', '4' 2006-08-22 12:23:49.2660 SELECT me.id FROM years me WHERE ( ( me.id = ? ) ): '2001' 2006-08-22 12:23:49.2674 INSERT INTO years (id) VALUES (?): '2001' 2006-08-22 12:23:49.2806 SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( url = ? ): 'file:////bob/music/flac/_Various%20Artists%20-%20Soundtracks/Trainspotting/12%20A%20Final%20Hit.flac' 2006-08-22 12:23:49.3519 INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, channels, content_type, drm, filesize, lossless, rating, remote, samplerate, secs, timestamp, title, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): '1', '0', '15590804', '636818.99897855', '2', 'flc', '0', '15590804', '1', '0', '0', '44100', '195.8', '1152590338', 'A Final Hit', 'A FINAL HIT', 'A FINAL HIT', '12', 'file:////bob/music/flac/_Various%20Artists%20-%20Soundtracks/Trainspotting/12%20A%20Final%20Hit.flac', '1996' 2006-08-22 12:23:49.3545 SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable FROM genres me WHERE ( ( me.namesearch = ? ) ): 'SOUNDTRACK' 2006-08-22 12:23:49.3570 SELECT me.genre, me.track FROM genre_track me WHERE ( ( me.genre = ? AND me.track = ? ) OR ( me.genre = ? AND me.track = ? ) ): '1', '5', '1', '5' 2006-08-22 12:23:49.3585 INSERT INTO genre_track (genre, track) VALUES (?, ?): '1', '5' 2006-08-22 12:23:49.3605 SELECT me.id, me.name, me.namesort, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id FROM contributors me WHERE ( ( me.namesearch = ? ) ): 'VARIOUS ARTISTS' 2006-08-22 12:23:49.3631 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( ( me.contributor = ? AND me.role = ? AND me.track = ? ) OR ( me.contributor = ? AND me.role = ? AND me.track = ? ) ): '1', '5', '5', '1', '5', '5' 2006-08-22 12:23:49.3648 INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?): '1', '5', '5' 2006-08-22 12:23:49.3670 SELECT me.id, me.name, me.namesort, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id FROM contributors me WHERE ( ( me.namesearch = ? ) ): 'LEFTFIELD' 2006-08-22 12:23:49.3688 INSERT INTO contributors (musicbrainz_id, name, namesearch, namesort) VALUES (?, ?, ?, ?): 'NULL', 'Leftfield', 'LEFTFIELD', 'LEFTFIELD' 2006-08-22 12:23:49.3712 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( ( me.contributor = ? AND me.role = ? AND me.track = ? ) OR ( me.contributor = ? AND me.role = ? AND me.track = ? ) ): '6', '1', '5', '6', '1', '5' 2006-08-22 12:23:49.3729 INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?): '6', '1', '5' 2006-08-22 12:23:49.3955 SELECT me.id, me.titlesort, me.compilation, me.year, me.artwork, me.disc, me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak, me.musicbrainz_id, me.title FROM albums me WHERE ( ( ( me.id = ? ) ) ): '1' 2006-08-22 12:23:49.4014 SELECT me.role, me.contributor, me.album FROM contributor_album me WHERE ( ( me.album = ? AND me.contributor = ? AND me.role = ? ) OR ( me.album = ? AND me.contributor = ? AND me.role = ? ) ): '1', '1', '5', '1', '1', '5' 2006-08-22 12:23:49.4043 SELECT me.role, me.contributor, me.album FROM contributor_album me WHERE ( ( me.album = ? AND me.contributor = ? AND me.role = ? ) OR ( me.album = ? AND me.contributor = ? AND me.role = ? ) ): '1', '6', '1', '1', '6', '1' 2006-08-22 12:23:49.4061 INSERT INTO contributor_album (album, contributor, role) VALUES (?, ?, ?): '1', '6', '1' 2006-08-22 12:23:49.4082 UPDATE tracks SET album = ? WHERE ( id = ? ): '1', '5' 2006-08-22 12:23:49.4115 SELECT me.id FROM years me WHERE ( ( me.id = ? ) ): '1996' 2006-08-22 12:23:49.4266 SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( url = ? ): 'file:////bob/music/flac/Dean%20Evenson/Ascension/11%20Mystic%20Mountain%20Reprise.flac' 2006-08-22 12:23:49.4807 INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, channels, content_type, drm, filesize, lossless, rating, remote, samplerate, secs, timestamp, title, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): '1', '0', '12039171', '657508.978328173', '2', 'flc', '0', '12039171', '1', '0', '0', '44100', '146.426666666667', '1136152991', 'Mystic Mountain Reprise', 'MYSTIC MOUNTAIN REPRISE', 'MYSTIC MOUNTAIN REPRISE', '11', 'file:////bob/music/flac/Dean%20Evenson/Ascension/11%20Mystic%20Mountain%20Reprise.flac', '1995' 2006-08-22 12:23:49.4841 SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable FROM genres me WHERE ( ( me.namesearch = ? ) ): 'NEW AGE' 2006-08-22 12:23:49.4863 INSERT INTO genres (name, namesearch, namesort) VALUES (?, ?, ?): 'New Age', 'NEW AGE', 'NEW AGE' 2006-08-22 12:23:49.4886 SELECT me.genre, me.track FROM genre_track me WHERE ( ( me.genre = ? AND me.track = ? ) OR ( me.genre = ? AND me.track = ? ) ): '4', '6', '4', '6' 2006-08-22 12:23:49.4906 INSERT INTO genre_track (genre, track) VALUES (?, ?): '4', '6' 2006-08-22 12:23:49.4933 SELECT me.id, me.name, me.namesort, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id FROM contributors me WHERE ( ( me.namesearch = ? ) ): 'DEAN EVENSON' 2006-08-22 12:23:49.4953 INSERT INTO contributors (musicbrainz_id, name, namesearch, namesort) VALUES (?, ?, ?, ?): 'NULL', 'Dean Evenson', 'DEAN EVENSON', 'EVENSON DEAN' 2006-08-22 12:23:49.4980 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( ( me.contributor = ? AND me.role = ? AND me.track = ? ) OR ( me.contributor = ? AND me.role = ? AND me.track = ? ) ): '7', '1', '6', '7', '1', '6' 2006-08-22 12:23:49.5001 INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?): '7', '1', '6' 2006-08-22 12:23:49.5026 SELECT me.id, me.titlesort, me.compilation, me.year, me.artwork, me.disc, me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak, me.musicbrainz_id, me.title FROM albums me LEFT JOIN tracks tracks ON ( tracks.album = me.id ) WHERE ( me.disc IS NULL AND me.discc IS NULL AND me.title = ? AND tracks.url LIKE ? ) GROUP BY me.id: 'Ascension', 'file:////bob/music/flac/Dean%20Evenson/Ascension%' 2006-08-22 12:23:49.5063 INSERT INTO albums (title) VALUES (?): 'Ascension' 2006-08-22 12:23:49.5106 SELECT me.role, me.contributor, me.album FROM contributor_album me WHERE ( ( me.album = ? AND me.contributor = ? AND me.role = ? ) OR ( me.album = ? AND me.contributor = ? AND me.role = ? ) ): '5', '7', '1', '5', '7', '1' 2006-08-22 12:23:49.5123 INSERT INTO contributor_album (album, contributor, role) VALUES (?, ?, ?): '5', '7', '1' 2006-08-22 12:23:49.5140 UPDATE albums SET titlesearch = ?, titlesort = ?, year = ? WHERE ( id = ? ): 'ASCENSION', 'ASCENSION', '1995', '5' 2006-08-22 12:23:49.5155 UPDATE tracks SET album = ? WHERE ( id = ? ): '5', '6' 2006-08-22 12:23:49.5175 SELECT me.id FROM years me WHERE ( ( me.id = ? ) ): '1995' 2006-08-22 12:23:49.5190 INSERT INTO years (id) VALUES (?): '1995' 2006-08-22 12:23:49.5323 SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( url = ? ): 'file:////bob/music/flac/Earl%20Klugh/Midnight%20In%20San%20Juan/01%20Midnight%20In%20San%20Juan.flac' 2006-08-22 12:23:49.5710 INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, channels, content_type, drm, filesize, lossless, rating, remote, samplerate, secs, timestamp, title, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): '1', '0', '33300753', '749399.234751294', '2', 'flc', '0', '33300753', '1', '0', '0', '44100', '355.44', '1127088430', 'Midnight In San Juan', 'MIDNIGHT IN SAN JUAN', 'MIDNIGHT IN SAN JUAN', '1', 'file:////bob/music/flac/Earl%20Klugh/Midnight%20In%20San%20Juan/01%20Midnight%20In%20San%20Juan.flac', '1991' 2006-08-22 12:23:49.5737 SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable FROM genres me WHERE ( ( me.namesearch = ? ) ): 'JAZZ' 2006-08-22 12:23:49.5761 SELECT me.genre, me.track FROM genre_track me WHERE ( ( me.genre = ? AND me.track = ? ) OR ( me.genre = ? AND me.track = ? ) ): '3', '7', '3', '7' 2006-08-22 12:23:49.5777 INSERT INTO genre_track (genre, track) VALUES (?, ?): '3', '7' 2006-08-22 12:23:49.5798 SELECT me.id, me.name, me.namesort, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id FROM contributors me WHERE ( ( me.namesearch = ? ) ): 'EARL KLUGH' 2006-08-22 12:23:49.5816 INSERT INTO contributors (musicbrainz_id, name, namesearch, namesort) VALUES (?, ?, ?, ?): 'NULL', 'Earl Klugh', 'EARL KLUGH', 'KLUGH EARL' 2006-08-22 12:23:49.5842 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( ( me.contributor = ? AND me.role = ? AND me.track = ? ) OR ( me.contributor = ? AND me.role = ? AND me.track = ? ) ): '8', '1', '7', '8', '1', '7' 2006-08-22 12:23:49.5859 INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?): '8', '1', '7' 2006-08-22 12:23:49.5884 SELECT me.id, me.titlesort, me.compilation, me.year, me.artwork, me.disc, me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak, me.musicbrainz_id, me.title FROM albums me LEFT JOIN tracks tracks ON ( tracks.album = me.id ) WHERE ( me.disc IS NULL AND me.discc IS NULL AND me.title = ? AND tracks.url LIKE ? ) GROUP BY me.id: 'Midnight In San Juan', 'file:////bob/music/flac/Earl%20Klugh/Midnight%20In%20San%20Juan%' 2006-08-22 12:23:49.5919 INSERT INTO albums (title) VALUES (?): 'Midnight In San Juan' 2006-08-22 12:23:49.5961 SELECT me.role, me.contributor, me.album FROM contributor_album me WHERE ( ( me.album = ? AND me.contributor = ? AND me.role = ? ) OR ( me.album = ? AND me.contributor = ? AND me.role = ? ) ): '6', '8', '1', '6', '8', '1' 2006-08-22 12:23:49.5978 INSERT INTO contributor_album (album, contributor, role) VALUES (?, ?, ?): '6', '8', '1' 2006-08-22 12:23:49.5995 UPDATE albums SET titlesearch = ?, titlesort = ?, year = ? WHERE ( id = ? ): 'MIDNIGHT IN SAN JUAN', 'MIDNIGHT IN SAN JUAN', '1991', '6' 2006-08-22 12:23:49.6010 UPDATE tracks SET album = ? WHERE ( id = ? ): '6', '7' 2006-08-22 12:23:49.6030 SELECT me.id FROM years me WHERE ( ( me.id = ? ) ): '1991' 2006-08-22 12:23:49.6044 INSERT INTO years (id) VALUES (?): '1991' 2006-08-22 12:23:49.6176 SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( url = ? ): 'file:////bob/music/flac/Cat%20Stevens/Tea%20for%20the%20Tillerman/04%20Sad%20Lisa.flac' 2006-08-22 12:23:49.6882 INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, channels, content_type, drm, filesize, lossless, rating, remote, samplerate, secs, timestamp, title, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): '1', '0', '17770763', '634041.577444682', '2', 'flc', '0', '17770763', '1', '0', '0', '44100', '224.16', '1135802963', 'Sad Lisa', 'SAD LISA', 'SAD LISA', '4', 'file:////bob/music/flac/Cat%20Stevens/Tea%20for%20the%20Tillerman/04%20Sad%20Lisa.flac', '1970' 2006-08-22 12:23:49.6909 SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable FROM genres me WHERE ( ( me.namesearch = ? ) ): 'ROCK' 2006-08-22 12:23:49.6934 SELECT me.genre, me.track FROM genre_track me WHERE ( ( me.genre = ? AND me.track = ? ) OR ( me.genre = ? AND me.track = ? ) ): '2', '8', '2', '8' 2006-08-22 12:23:49.6949 INSERT INTO genre_track (genre, track) VALUES (?, ?): '2', '8' 2006-08-22 12:23:49.6971 SELECT me.id, me.name, me.namesort, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id FROM contributors me WHERE ( ( me.namesearch = ? ) ): 'CAT STEVENS' 2006-08-22 12:23:49.6990 INSERT INTO contributors (musicbrainz_id, name, namesearch, namesort) VALUES (?, ?, ?, ?): 'NULL', 'Cat Stevens', 'CAT STEVENS', 'STEVENS CAT' 2006-08-22 12:23:49.7015 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( ( me.contributor = ? AND me.role = ? AND me.track = ? ) OR ( me.contributor = ? AND me.role = ? AND me.track = ? ) ): '9', '1', '8', '9', '1', '8' 2006-08-22 12:23:49.7032 INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?): '9', '1', '8' 2006-08-22 12:23:49.7057 SELECT me.id, me.titlesort, me.compilation, me.year, me.artwork, me.disc, me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak, me.musicbrainz_id, me.title FROM albums me LEFT JOIN tracks tracks ON ( tracks.album = me.id ) WHERE ( me.compilation = ? AND me.disc IS NULL AND me.discc IS NULL AND me.title = ? AND tracks.url LIKE ? ) GROUP BY me.id: '0', 'Tea for the Tillerman', 'file:////bob/music/flac/Cat%20Stevens/Tea%20for%20the%20Tillerman%' 2006-08-22 12:23:49.7093 INSERT INTO albums (title) VALUES (?): 'Tea for the Tillerman' 2006-08-22 12:23:49.7141 SELECT me.role, me.contributor, me.album FROM contributor_album me WHERE ( ( me.album = ? AND me.contributor = ? AND me.role = ? ) OR ( me.album = ? AND me.contributor = ? AND me.role = ? ) ): '7', '9', '1', '7', '9', '1' 2006-08-22 12:23:49.7158 INSERT INTO contributor_album (album, contributor, role) VALUES (?, ?, ?): '7', '9', '1' 2006-08-22 12:23:49.7174 UPDATE albums SET compilation = ?, titlesearch = ?, titlesort = ?, year = ? WHERE ( id = ? ): '0', 'TEA FOR THE TILLERMAN', 'TEA FOR THE TILLERMAN', '1970', '7' 2006-08-22 12:23:49.7190 UPDATE tracks SET album = ? WHERE ( id = ? ): '7', '8' 2006-08-22 12:23:49.7210 SELECT me.id FROM years me WHERE ( ( me.id = ? ) ): '1970' 2006-08-22 12:23:49.7224 INSERT INTO years (id) VALUES (?): '1970' 2006-08-22 12:23:49.7240 SELECT me.id, me.track, me.value FROM comments me WHERE ( track = ? AND value = ? ): '8', 'Mobile Fidelity MFSL UDCD 519' 2006-08-22 12:23:49.7260 INSERT INTO comments (track, value) VALUES (?, ?): '8', 'Mobile Fidelity MFSL UDCD 519' 2006-08-22 12:23:49.7398 SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( url = ? ): 'file:////bob/music/flac/The%20Doobie%20Brothers/Best%20of%20the%20Doobies/09%20South%20City%20Midnight%20Lady.flac' 2006-08-22 12:23:49.8010 INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, channels, content_type, drm, filesize, lossless, rating, remote, samplerate, secs, timestamp, title, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): '1', '0', '31254711', '749994.672', '2', 'flc', '0', '31254711', '1', '0', '0', '44100', '333.333333333333', '1139725243', 'South City Midnight Lady', 'SOUTH CITY MIDNIGHT LADY', 'SOUTH CITY MIDNIGHT LADY', '9', 'file:////bob/music/flac/The%20Doobie%20Brothers/Best%20of%20the%20Doobies/09%20South%20City%20Midnight%20Lady.flac', '1976' 2006-08-22 12:23:49.8038 SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable FROM genres me WHERE ( ( me.namesearch = ? ) ): 'ROCK' 2006-08-22 12:23:49.8063 SELECT me.genre, me.track FROM genre_track me WHERE ( ( me.genre = ? AND me.track = ? ) OR ( me.genre = ? AND me.track = ? ) ): '2', '9', '2', '9' 2006-08-22 12:23:49.8078 INSERT INTO genre_track (genre, track) VALUES (?, ?): '2', '9' 2006-08-22 12:23:49.8099 SELECT me.id, me.name, me.namesort, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id FROM contributors me WHERE ( ( me.namesearch = ? ) ): 'THE DOOBIE BROTHERS' 2006-08-22 12:23:49.8118 INSERT INTO contributors (musicbrainz_id, name, namesearch, namesort) VALUES (?, ?, ?, ?): 'NULL', 'The Doobie Brothers', 'THE DOOBIE BROTHERS', 'DOOBIE BROTHERS' 2006-08-22 12:23:49.8144 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( ( me.contributor = ? AND me.role = ? AND me.track = ? ) OR ( me.contributor = ? AND me.role = ? AND me.track = ? ) ): '10', '1', '9', '10', '1', '9' 2006-08-22 12:23:49.8161 INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?): '10', '1', '9' 2006-08-22 12:23:49.8186 SELECT me.id, me.titlesort, me.compilation, me.year, me.artwork, me.disc, me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak, me.musicbrainz_id, me.title FROM albums me LEFT JOIN tracks tracks ON ( tracks.album = me.id ) WHERE ( me.compilation = ? AND me.disc IS NULL AND me.discc IS NULL AND me.title = ? AND tracks.url LIKE ? ) GROUP BY me.id: '0', 'Best of the Doobies', 'file:////bob/music/flac/The%20Doobie%20Brothers/Best%20of%20the%20Doobies%' 2006-08-22 12:23:49.8222 INSERT INTO albums (title) VALUES (?): 'Best of the Doobies' 2006-08-22 12:23:49.8265 SELECT me.role, me.contributor, me.album FROM contributor_album me WHERE ( ( me.album = ? AND me.contributor = ? AND me.role = ? ) OR ( me.album = ? AND me.contributor = ? AND me.role = ? ) ): '8', '10', '1', '8', '10', '1' 2006-08-22 12:23:49.8282 INSERT INTO contributor_album (album, contributor, role) VALUES (?, ?, ?): '8', '10', '1' 2006-08-22 12:23:49.8298 UPDATE albums SET compilation = ?, titlesearch = ?, titlesort = ?, year = ? WHERE ( id = ? ): '0', 'BEST OF THE DOOBIES', 'BEST OF THE DOOBIES', '1976', '8' 2006-08-22 12:23:49.8314 UPDATE tracks SET album = ? WHERE ( id = ? ): '8', '9' 2006-08-22 12:23:49.8339 SELECT me.id FROM years me WHERE ( ( me.id = ? ) ): '1976' 2006-08-22 12:23:49.8353 INSERT INTO years (id) VALUES (?): '1976' 2006-08-22 12:23:49.8370 SELECT me.id, me.track, me.value FROM comments me WHERE ( track = ? AND value = ? ): '9', 'DCC GZS-1121' 2006-08-22 12:23:49.8386 INSERT INTO comments (track, value) VALUES (?, ?): '9', 'DCC GZS-1121' 2006-08-22 12:23:49.8523 SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( url = ? ): 'file:////bob/music/flac/Patti%20Page/The%20Mercury%20Years,%20Volume%201/03%20I%20don%27t%20Care%20If%20The%20Sun%20Don%27t%20Shine.flac' 2006-08-22 12:23:49.9132 INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, channels, content_type, drm, filesize, lossless, rating, remote, samplerate, secs, timestamp, title, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): '1', '0', '10672328', '525934.363188168', '2', 'flc', '0', '10672328', '1', '0', '0', '44100', '162.266666666667', '1124581111', 'I don't Care If The Sun Don't Shine', 'I DON T CARE IF THE SUN DON T SHINE', 'I DON T CARE IF THE SUN DON T SHINE', '3', 'file:////bob/music/flac/Patti%20Page/The%20Mercury%20Years,%20Volume%201/03%20I%20don%27t%20Care%20If%20The%20Sun%20Don%27t%20Shine.flac', '1952' 2006-08-22 12:23:49.9164 SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable FROM genres me WHERE ( ( me.namesearch = ? ) ): 'VOCAL' 2006-08-22 12:23:49.9182 INSERT INTO genres (name, namesearch, namesort) VALUES (?, ?, ?): 'Vocal', 'VOCAL', 'VOCAL' 2006-08-22 12:23:49.9205 SELECT me.genre, me.track FROM genre_track me WHERE ( ( me.genre = ? AND me.track = ? ) OR ( me.genre = ? AND me.track = ? ) ): '5', '10', '5', '10' 2006-08-22 12:23:49.9221 INSERT INTO genre_track (genre, track) VALUES (?, ?): '5', '10' 2006-08-22 12:23:49.9243 SELECT me.id, me.name, me.namesort, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id FROM contributors me WHERE ( ( me.namesearch = ? ) ): 'PATTI PAGE' 2006-08-22 12:23:49.9262 INSERT INTO contributors (musicbrainz_id, name, namesearch, namesort) VALUES (?, ?, ?, ?): 'NULL', 'Patti Page', 'PATTI PAGE', 'PAGE PATTI' 2006-08-22 12:23:49.9288 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( ( me.contributor = ? AND me.role = ? AND me.track = ? ) OR ( me.contributor = ? AND me.role = ? AND me.track = ? ) ): '11', '1', '10', '11', '1', '10' 2006-08-22 12:23:49.9306 INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?): '11', '1', '10' 2006-08-22 12:23:49.9331 SELECT me.id, me.titlesort, me.compilation, me.year, me.artwork, me.disc, me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak, me.musicbrainz_id, me.title FROM albums me LEFT JOIN tracks tracks ON ( tracks.album = me.id ) WHERE ( me.disc IS NULL AND me.discc IS NULL AND me.title = ? AND tracks.url LIKE ? ) GROUP BY me.id: 'The Mercury Years, Volume 1', 'file:////bob/music/flac/Patti%20Page/The%20Mercury%20Years,%20Volume%201%' 2006-08-22 12:23:49.9366 INSERT INTO albums (title) VALUES (?): 'The Mercury Years, Volume 1' 2006-08-22 12:23:49.9410 SELECT me.role, me.contributor, me.album FROM contributor_album me WHERE ( ( me.album = ? AND me.contributor = ? AND me.role = ? ) OR ( me.album = ? AND me.contributor = ? AND me.role = ? ) ): '9', '11', '1', '9', '11', '1' 2006-08-22 12:23:49.9427 INSERT INTO contributor_album (album, contributor, role) VALUES (?, ?, ?): '9', '11', '1' 2006-08-22 12:23:49.9444 UPDATE albums SET titlesearch = ?, titlesort = ?, year = ? WHERE ( id = ? ): 'THE MERCURY YEARS VOLUME 1', 'MERCURY YEARS VOLUME 1', '1952', '9' 2006-08-22 12:23:49.9463 UPDATE tracks SET album = ? WHERE ( id = ? ): '9', '10' 2006-08-22 12:23:49.9484 SELECT me.id FROM years me WHERE ( ( me.id = ? ) ): '1952' 2006-08-22 12:23:49.9497 INSERT INTO years (id) VALUES (?): '1952' 2006-08-22 12:23:49.9662 SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( url = ? ): 'file:////bob/music/flac/Beatles/The%20Beatles%20[White%20Album]/Disc%201/16%20I%20Will.flac' 2006-08-22 12:23:50.0252 INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, channels, content_type, disc, drm, filesize, lossless, rating, remote, samplerate, secs, timestamp, title, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): '1', '0', '10110214', '762408.600528103', '2', 'flc', '1', '0', '10110214', '1', '0', '0', '44100', '106.04', '1123391259', 'I Will', 'I WILL', 'I WILL', '16', 'file:////bob/music/flac/Beatles/The%20Beatles%20[White%20Album]/Disc%201/16%20I%20Will.flac', '1968' 2006-08-22 12:23:50.0282 SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable FROM genres me WHERE ( ( me.namesearch = ? ) ): 'ROCK' 2006-08-22 12:23:50.0308 SELECT me.genre, me.track FROM genre_track me WHERE ( ( me.genre = ? AND me.track = ? ) OR ( me.genre = ? AND me.track = ? ) ): '2', '11', '2', '11' 2006-08-22 12:23:50.0324 INSERT INTO genre_track (genre, track) VALUES (?, ?): '2', '11' 2006-08-22 12:23:50.0345 SELECT me.id, me.name, me.namesort, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id FROM contributors me WHERE ( ( me.namesearch = ? ) ): 'THE BEATLES' 2006-08-22 12:23:50.0364 INSERT INTO contributors (musicbrainz_id, name, namesearch, namesort) VALUES (?, ?, ?, ?): 'NULL', 'The Beatles', 'THE BEATLES', 'BEATLES' 2006-08-22 12:23:50.0390 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( ( me.contributor = ? AND me.role = ? AND me.track = ? ) OR ( me.contributor = ? AND me.role = ? AND me.track = ? ) ): '12', '1', '11', '12', '1', '11' 2006-08-22 12:23:50.0408 INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?): '12', '1', '11' 2006-08-22 12:23:50.0430 SELECT me.id, me.titlesort, me.compilation, me.year, me.artwork, me.disc, me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak, me.musicbrainz_id, me.title FROM albums me WHERE ( me.discc = ? AND me.title = ? ) GROUP BY me.id: '2', 'The Beatles [White Album]' 2006-08-22 12:23:50.0466 INSERT INTO albums (title) VALUES (?): 'The Beatles [White Album]' 2006-08-22 12:23:50.0510 SELECT me.role, me.contributor, me.album FROM contributor_album me WHERE ( ( me.album = ? AND me.contributor = ? AND me.role = ? ) OR ( me.album = ? AND me.contributor = ? AND me.role = ? ) ): '10', '12', '1', '10', '12', '1' 2006-08-22 12:23:50.0527 INSERT INTO contributor_album (album, contributor, role) VALUES (?, ?, ?): '10', '12', '1' 2006-08-22 12:23:50.0545 UPDATE albums SET disc = ?, discc = ?, titlesearch = ?, titlesort = ?, year = ? WHERE ( id = ? ): '1', '2', 'THE BEATLES [WHITE ALBUM]', 'BEATLES [WHITE ALBUM]', '1968', '10' 2006-08-22 12:23:50.0562 UPDATE tracks SET album = ? WHERE ( id = ? ): '10', '11' 2006-08-22 12:23:50.0583 SELECT me.id FROM years me WHERE ( ( me.id = ? ) ): '1968' 2006-08-22 12:23:50.0597 INSERT INTO years (id) VALUES (?): '1968' 2006-08-22 12:23:50.0866 SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( url = ? ): 'file:////bob/music/flac/Tom%20Waits/Swordfishtrombones/09%20Frank%27s%20Wild%20Years.flac' 2006-08-22 12:23:50.1464 INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, channels, content_type, drm, filesize, lossless, rating, remote, samplerate, secs, timestamp, title, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): '1', '0', '8221246', '577486.259810238', '2', 'flc', '0', '8221246', '1', '0', '0', '44100', '113.826666666667', '1141529255', 'Frank's Wild Years', 'FRANK S WILD YEARS', 'FRANK S WILD YEARS', '9', 'file:////bob/music/flac/Tom%20Waits/Swordfishtrombones/09%20Frank%27s%20Wild%20Years.flac', '1983' 2006-08-22 12:23:50.1493 SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable FROM genres me WHERE ( ( me.namesearch = ? ) ): 'ROCK' 2006-08-22 12:23:50.1518 SELECT me.genre, me.track FROM genre_track me WHERE ( ( me.genre = ? AND me.track = ? ) OR ( me.genre = ? AND me.track = ? ) ): '2', '12', '2', '12' 2006-08-22 12:23:50.1533 INSERT INTO genre_track (genre, track) VALUES (?, ?): '2', '12' 2006-08-22 12:23:50.1555 SELECT me.id, me.name, me.namesort, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id FROM contributors me WHERE ( ( me.namesearch = ? ) ): 'TOM WAITS' 2006-08-22 12:23:50.1574 INSERT INTO contributors (musicbrainz_id, name, namesearch, namesort) VALUES (?, ?, ?, ?): 'NULL', 'Tom Waits', 'TOM WAITS', 'WAITS TOM' 2006-08-22 12:23:50.1600 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( ( me.contributor = ? AND me.role = ? AND me.track = ? ) OR ( me.contributor = ? AND me.role = ? AND me.track = ? ) ): '13', '1', '12', '13', '1', '12' 2006-08-22 12:23:50.1618 INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?): '13', '1', '12' 2006-08-22 12:23:50.1653 SELECT me.id, me.titlesort, me.compilation, me.year, me.artwork, me.disc, me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak, me.musicbrainz_id, me.title FROM albums me LEFT JOIN tracks tracks ON ( tracks.album = me.id ) WHERE ( me.compilation = ? AND me.disc IS NULL AND me.discc IS NULL AND me.title = ? AND tracks.url LIKE ? ) GROUP BY me.id: '0', 'Swordfishtrombones', 'file:////bob/music/flac/Tom%20Waits/Swordfishtrombones%' 2006-08-22 12:23:50.1689 INSERT INTO albums (title) VALUES (?): 'Swordfishtrombones' 2006-08-22 12:23:50.1732 SELECT me.role, me.contributor, me.album FROM contributor_album me WHERE ( ( me.album = ? AND me.contributor = ? AND me.role = ? ) OR ( me.album = ? AND me.contributor = ? AND me.role = ? ) ): '11', '13', '1', '11', '13', '1' 2006-08-22 12:23:50.1749 INSERT INTO contributor_album (album, contributor, role) VALUES (?, ?, ?): '11', '13', '1' 2006-08-22 12:23:50.1766 UPDATE albums SET compilation = ?, titlesearch = ?, titlesort = ?, year = ? WHERE ( id = ? ): '0', 'SWORDFISHTROMBONES', 'SWORDFISHTROMBONES', '1983', '11' 2006-08-22 12:23:50.1782 UPDATE tracks SET album = ? WHERE ( id = ? ): '11', '12' 2006-08-22 12:23:50.1802 SELECT me.id FROM years me WHERE ( ( me.id = ? ) ): '1983' 2006-08-22 12:23:50.1816 INSERT INTO years (id) VALUES (?): '1983' 2006-08-22 12:23:50.1948 SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( url = ? ): 'file:////bob/music/flac/U2/The%20Unforgettable%20Fire/01%20A%20Sort%20Of%20Homecoming.flac' 2006-08-22 12:23:50.2563 INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, channels, content_type, drm, filesize, lossless, rating, remote, samplerate, secs, timestamp, title, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): '1', '0', '35213631', '858226.569165143', '2', 'flc', '0', '35213631', '1', '0', '0', '44100', '328.2', '1149978699', 'A Sort Of Homecoming', 'A SORT OF HOMECOMING', 'A SORT OF HOMECOMING', '1', 'file:////bob/music/flac/U2/The%20Unforgettable%20Fire/01%20A%20Sort%20Of%20Homecoming.flac', '1984' 2006-08-22 12:23:50.2592 SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable FROM genres me WHERE ( ( me.namesearch = ? ) ): 'ROCK' 2006-08-22 12:23:50.2617 SELECT me.genre, me.track FROM genre_track me WHERE ( ( me.genre = ? AND me.track = ? ) OR ( me.genre = ? AND me.track = ? ) ): '2', '13', '2', '13' 2006-08-22 12:23:50.2632 INSERT INTO genre_track (genre, track) VALUES (?, ?): '2', '13' 2006-08-22 12:23:50.2653 SELECT me.id, me.name, me.namesort, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id FROM contributors me WHERE ( ( me.namesearch = ? ) ): 'U2' 2006-08-22 12:23:50.2672 INSERT INTO contributors (musicbrainz_id, name, namesearch, namesort) VALUES (?, ?, ?, ?): 'NULL', 'U2', 'U2', 'U2' 2006-08-22 12:23:50.2696 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( ( me.contributor = ? AND me.role = ? AND me.track = ? ) OR ( me.contributor = ? AND me.role = ? AND me.track = ? ) ): '14', '1', '13', '14', '1', '13' 2006-08-22 12:23:50.2713 INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?): '14', '1', '13' 2006-08-22 12:23:50.2741 SELECT me.id, me.titlesort, me.compilation, me.year, me.artwork, me.disc, me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak, me.musicbrainz_id, me.title FROM albums me LEFT JOIN tracks tracks ON ( tracks.album = me.id ) WHERE ( me.compilation = ? AND me.disc IS NULL AND me.discc IS NULL AND me.title = ? AND tracks.url LIKE ? ) GROUP BY me.id: '0', 'The Unforgettable Fire', 'file:////bob/music/flac/U2/The%20Unforgettable%20Fire%' 2006-08-22 12:23:50.2776 INSERT INTO albums (title) VALUES (?): 'The Unforgettable Fire' 2006-08-22 12:23:50.2820 SELECT me.role, me.contributor, me.album FROM contributor_album me WHERE ( ( me.album = ? AND me.contributor = ? AND me.role = ? ) OR ( me.album = ? AND me.contributor = ? AND me.role = ? ) ): '12', '14', '1', '12', '14', '1' 2006-08-22 12:23:50.2837 INSERT INTO contributor_album (album, contributor, role) VALUES (?, ?, ?): '12', '14', '1' 2006-08-22 12:23:50.2854 UPDATE albums SET compilation = ?, titlesearch = ?, titlesort = ?, year = ? WHERE ( id = ? ): '0', 'THE UNFORGETTABLE FIRE', 'UNFORGETTABLE FIRE', '1984', '12' 2006-08-22 12:23:50.2870 UPDATE tracks SET album = ? WHERE ( id = ? ): '12', '13'