--
-- Host: localhost    Database: debug
-- ------------------------------------------------------


--
-- Current Database: `debug`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `debug` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `debug`;

--
-- Table structure for table `album`
--

CREATE TABLE `album` (
  `idAlbum` int(11) NOT NULL AUTO_INCREMENT,
  `strAlbum` varchar(256) DEFAULT NULL,
  `strMusicBrainzAlbumID` text,
  `strArtists` text,
  `strGenres` text,
  `iYear` int(11) DEFAULT NULL,
  `idThumb` int(11) DEFAULT NULL,
  `bCompilation` int(11) NOT NULL DEFAULT '0',
  `strMoods` text,
  `strStyles` text,
  `strThemes` text,
  `strReview` text,
  `strImage` text,
  `strLabel` text,
  `strType` text,
  `iRating` int(11) DEFAULT NULL,
  `lastScraped` varchar(20) DEFAULT NULL,
  `dateAdded` varchar(20) DEFAULT NULL,
  `strReleaseType` text,
  PRIMARY KEY (`idAlbum`),
  UNIQUE KEY `idxAlbum_2` (`strMusicBrainzAlbumID`(36)),
  KEY `idxAlbum` (`strAlbum`(255)),
  KEY `idxAlbum_1` (`bCompilation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `album`
--

DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `tgrDeleteAlbum` AFTER DELETE ON `album`
 FOR EACH ROW BEGIN  DELETE FROM song WHERE song.idAlbum = old.idAlbum;  DELETE FROM album_artist WHERE album_artist.idAlbum = old.idAlbum;  DELETE FROM album_genre WHERE album_genre.idAlbum = old.idAlbum;  DELETE FROM albuminfosong WHERE albuminfosong.idAlbumInfo=old.idAlbum;  DELETE FROM art WHERE media_id=old.idAlbum AND media_type='album'; END */;;
DELIMITER ;

--
-- Table structure for table `album_artist`
--

CREATE TABLE `album_artist` (
  `idArtist` int(11) DEFAULT NULL,
  `idAlbum` int(11) DEFAULT NULL,
  `boolFeatured` int(11) DEFAULT NULL,
  `iOrder` int(11) DEFAULT NULL,
  `strJoinPhrase` text,
  `strArtist` text,
  UNIQUE KEY `idxAlbumArtist_1` (`idAlbum`,`idArtist`),
  UNIQUE KEY `idxAlbumArtist_2` (`idArtist`,`idAlbum`),
  KEY `idxAlbumArtist_3` (`boolFeatured`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `album_artist`
--


--
-- Table structure for table `album_genre`
--

CREATE TABLE `album_genre` (
  `idGenre` int(11) DEFAULT NULL,
  `idAlbum` int(11) DEFAULT NULL,
  `iOrder` int(11) DEFAULT NULL,
  UNIQUE KEY `idxAlbumGenre_1` (`idAlbum`,`idGenre`),
  UNIQUE KEY `idxAlbumGenre_2` (`idGenre`,`idAlbum`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `album_genre`
--


--
-- Temporary table structure for view `albumartistview`
--

/*!50001 DROP VIEW IF EXISTS `albumartistview`*/;
/*!50001 CREATE TABLE `albumartistview` (
  `idAlbum` tinyint NOT NULL,
  `idArtist` tinyint NOT NULL,
  `strArtist` tinyint NOT NULL,
  `strMusicBrainzArtistID` tinyint NOT NULL,
  `boolFeatured` tinyint NOT NULL,
  `strJoinPhrase` tinyint NOT NULL,
  `iOrder` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Table structure for table `albuminfosong`
--

CREATE TABLE `albuminfosong` (
  `idAlbumInfoSong` int(11) NOT NULL AUTO_INCREMENT,
  `idAlbumInfo` int(11) DEFAULT NULL,
  `iTrack` int(11) DEFAULT NULL,
  `strTitle` text,
  `iDuration` int(11) DEFAULT NULL,
  PRIMARY KEY (`idAlbumInfoSong`),
  KEY `idxAlbumInfoSong_1` (`idAlbumInfo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `albuminfosong`
--


--
-- Temporary table structure for view `albumview`
--

/*!50001 DROP VIEW IF EXISTS `albumview`*/;
/*!50001 CREATE TABLE `albumview` (
  `idAlbum` tinyint NOT NULL,
  `strAlbum` tinyint NOT NULL,
  `strMusicBrainzAlbumID` tinyint NOT NULL,
  `strArtists` tinyint NOT NULL,
  `strGenres` tinyint NOT NULL,
  `iYear` tinyint NOT NULL,
  `strMoods` tinyint NOT NULL,
  `strStyles` tinyint NOT NULL,
  `strThemes` tinyint NOT NULL,
  `strReview` tinyint NOT NULL,
  `strLabel` tinyint NOT NULL,
  `strType` tinyint NOT NULL,
  `strImage` tinyint NOT NULL,
  `iRating` tinyint NOT NULL,
  `bCompilation` tinyint NOT NULL,
  `iTimesPlayed` tinyint NOT NULL,
  `strReleaseType` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Table structure for table `art`
--

CREATE TABLE `art` (
  `art_id` int(11) NOT NULL AUTO_INCREMENT,
  `media_id` int(11) DEFAULT NULL,
  `media_type` text,
  `type` text,
  `url` text,
  PRIMARY KEY (`art_id`),
  KEY `ix_art` (`media_id`,`media_type`(20),`type`(20))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `art`
--


--
-- Table structure for table `artist`
--

CREATE TABLE `artist` (
  `idArtist` int(11) NOT NULL AUTO_INCREMENT,
  `strArtist` varchar(256) DEFAULT NULL,
  `strMusicBrainzArtistID` text,
  `strBorn` text,
  `strFormed` text,
  `strGenres` text,
  `strMoods` text,
  `strStyles` text,
  `strInstruments` text,
  `strBiography` text,
  `strDied` text,
  `strDisbanded` text,
  `strYearsActive` text,
  `strImage` text,
  `strFanart` text,
  `lastScraped` varchar(20) DEFAULT NULL,
  `dateAdded` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`idArtist`),
  UNIQUE KEY `idxArtist1` (`strMusicBrainzArtistID`(36)),
  KEY `idxArtist` (`strArtist`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `artist`
--

DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `tgrDeleteArtist` AFTER DELETE ON `artist`
 FOR EACH ROW BEGIN  DELETE FROM album_artist WHERE album_artist.idArtist = old.idArtist;  DELETE FROM song_artist WHERE song_artist.idArtist = old.idArtist;  DELETE FROM discography WHERE discography.idArtist = old.idArtist;  DELETE FROM art WHERE media_id=old.idArtist AND media_type='artist'; END */;;
DELIMITER ;

--
-- Temporary table structure for view `artistview`
--

/*!50001 DROP VIEW IF EXISTS `artistview`*/;
/*!50001 CREATE TABLE `artistview` (
  `idArtist` tinyint NOT NULL,
  `strArtist` tinyint NOT NULL,
  `strMusicBrainzArtistID` tinyint NOT NULL,
  `strBorn` tinyint NOT NULL,
  `strFormed` tinyint NOT NULL,
  `strGenres` tinyint NOT NULL,
  `strMoods` tinyint NOT NULL,
  `strStyles` tinyint NOT NULL,
  `strInstruments` tinyint NOT NULL,
  `strBiography` tinyint NOT NULL,
  `strDied` tinyint NOT NULL,
  `strDisbanded` tinyint NOT NULL,
  `strYearsActive` tinyint NOT NULL,
  `strImage` tinyint NOT NULL,
  `strFanart` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Table structure for table `content`
--

CREATE TABLE `content` (
  `strPath` text,
  `strScraperPath` text,
  `strContent` text,
  `strSettings` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `content`
--


--
-- Table structure for table `cue`
--

CREATE TABLE `cue` (
  `idPath` int(11) DEFAULT NULL,
  `strFileName` text,
  `strCuesheet` text,
  UNIQUE KEY `idxCue` (`idPath`,`strFileName`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cue`
--


--
-- Table structure for table `discography`
--

CREATE TABLE `discography` (
  `idArtist` int(11) DEFAULT NULL,
  `strAlbum` text,
  `strYear` text,
  KEY `idxDiscography_1` (`idArtist`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `discography`
--


--
-- Table structure for table `genre`
--

CREATE TABLE `genre` (
  `idGenre` int(11) NOT NULL AUTO_INCREMENT,
  `strGenre` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`idGenre`),
  KEY `idxGenre` (`strGenre`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `genre`
--


--
-- Table structure for table `karaokedata`
--

CREATE TABLE `karaokedata` (
  `iKaraNumber` int(11) DEFAULT NULL,
  `idSong` int(11) DEFAULT NULL,
  `iKaraDelay` int(11) DEFAULT NULL,
  `strKaraEncoding` text,
  `strKaralyrics` text,
  `strKaraLyrFileCRC` text,
  KEY `idxKaraNumber` (`iKaraNumber`),
  KEY `idxKarSong` (`idSong`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `karaokedata`
--


--
-- Table structure for table `path`
--

CREATE TABLE `path` (
  `idPath` int(11) NOT NULL AUTO_INCREMENT,
  `strPath` varchar(512) DEFAULT NULL,
  `strHash` text,
  PRIMARY KEY (`idPath`),
  KEY `idxPath` (`strPath`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `path`
--

DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `tgrDeletePath` AFTER DELETE ON `path`
 FOR EACH ROW BEGIN  DELETE FROM cue WHERE cue.idPath = old.idPath; END */;;
DELIMITER ;

--
-- Table structure for table `song`
--

CREATE TABLE `song` (
  `idSong` int(11) NOT NULL AUTO_INCREMENT,
  `idAlbum` int(11) DEFAULT NULL,
  `idPath` int(11) DEFAULT NULL,
  `strArtists` text,
  `strGenres` text,
  `strTitle` varchar(512) DEFAULT NULL,
  `iTrack` int(11) DEFAULT NULL,
  `iDuration` int(11) DEFAULT NULL,
  `iYear` int(11) DEFAULT NULL,
  `dwFileNameCRC` text,
  `strFileName` text,
  `strMusicBrainzTrackID` text,
  `iTimesPlayed` int(11) DEFAULT NULL,
  `iStartOffset` int(11) DEFAULT NULL,
  `iEndOffset` int(11) DEFAULT NULL,
  `idThumb` int(11) DEFAULT NULL,
  `lastplayed` varchar(20) DEFAULT NULL,
  `rating` char(1) DEFAULT '0',
  `comment` text,
  `mood` text,
  PRIMARY KEY (`idSong`),
  UNIQUE KEY `idxSong7` (`idAlbum`,`strMusicBrainzTrackID`(36)),
  KEY `idxSong` (`strTitle`(255)),
  KEY `idxSong1` (`iTimesPlayed`),
  KEY `idxSong2` (`lastplayed`),
  KEY `idxSong3` (`idAlbum`),
  KEY `idxSong6` (`idPath`,`strFileName`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `song`
--

DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `tgrDeleteSong` AFTER DELETE ON `song`
 FOR EACH ROW BEGIN  DELETE FROM song_artist WHERE song_artist.idSong = old.idSong;  DELETE FROM song_genre WHERE song_genre.idSong = old.idSong;  DELETE FROM karaokedata WHERE karaokedata.idSong = old.idSong;  DELETE FROM art WHERE media_id=old.idSong AND media_type='song'; END */;;
DELIMITER ;

--
-- Table structure for table `song_artist`
--

CREATE TABLE `song_artist` (
  `idArtist` int(11) DEFAULT NULL,
  `idSong` int(11) DEFAULT NULL,
  `boolFeatured` int(11) DEFAULT NULL,
  `iOrder` int(11) DEFAULT NULL,
  `strJoinPhrase` text,
  `strArtist` text,
  UNIQUE KEY `idxSongArtist_1` (`idSong`,`idArtist`),
  UNIQUE KEY `idxSongArtist_2` (`idArtist`,`idSong`),
  KEY `idxSongArtist_3` (`boolFeatured`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `song_artist`
--


--
-- Table structure for table `song_genre`
--

CREATE TABLE `song_genre` (
  `idGenre` int(11) DEFAULT NULL,
  `idSong` int(11) DEFAULT NULL,
  `iOrder` int(11) DEFAULT NULL,
  UNIQUE KEY `idxSongGenre_1` (`idSong`,`idGenre`),
  UNIQUE KEY `idxSongGenre_2` (`idGenre`,`idSong`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `song_genre`
--


--
-- Temporary table structure for view `songartistview`
--

/*!50001 DROP VIEW IF EXISTS `songartistview`*/;
/*!50001 CREATE TABLE `songartistview` (
  `idSong` tinyint NOT NULL,
  `idArtist` tinyint NOT NULL,
  `strArtist` tinyint NOT NULL,
  `strMusicBrainzArtistID` tinyint NOT NULL,
  `boolFeatured` tinyint NOT NULL,
  `strJoinPhrase` tinyint NOT NULL,
  `iOrder` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `songview`
--

/*!50001 DROP VIEW IF EXISTS `songview`*/;
/*!50001 CREATE TABLE `songview` (
  `idSong` tinyint NOT NULL,
  `strArtists` tinyint NOT NULL,
  `strGenres` tinyint NOT NULL,
  `strTitle` tinyint NOT NULL,
  `iTrack` tinyint NOT NULL,
  `iDuration` tinyint NOT NULL,
  `iYear` tinyint NOT NULL,
  `strFileName` tinyint NOT NULL,
  `strMusicBrainzTrackID` tinyint NOT NULL,
  `iTimesPlayed` tinyint NOT NULL,
  `iStartOffset` tinyint NOT NULL,
  `iEndOffset` tinyint NOT NULL,
  `lastplayed` tinyint NOT NULL,
  `rating` tinyint NOT NULL,
  `comment` tinyint NOT NULL,
  `idAlbum` tinyint NOT NULL,
  `strAlbum` tinyint NOT NULL,
  `strPath` tinyint NOT NULL,
  `iKaraNumber` tinyint NOT NULL,
  `iKaraDelay` tinyint NOT NULL,
  `strKaraEncoding` tinyint NOT NULL,
  `bCompilation` tinyint NOT NULL,
  `strAlbumArtists` tinyint NOT NULL,
  `strAlbumReleaseType` tinyint NOT NULL,
  `mood` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Table structure for table `version`
--

CREATE TABLE `version` (
  `idVersion` int(11) DEFAULT NULL,
  `iCompressCount` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `version`
--


--
-- Current Database: `debug`
--

USE `debug`;

--
-- Final view structure for view `albumartistview`
--

/*!50001 DROP TABLE IF EXISTS `albumartistview`*/;
/*!50001 DROP VIEW IF EXISTS `albumartistview`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`xbmc`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `albumartistview` AS select `MyMusic52`.`album_artist`.`idAlbum` AS `idAlbum`,`MyMusic52`.`album_artist`.`idArtist` AS `idArtist`,`MyMusic52`.`artist`.`strArtist` AS `strArtist`,`MyMusic52`.`artist`.`strMusicBrainzArtistID` AS `strMusicBrainzArtistID`,`MyMusic52`.`album_artist`.`boolFeatured` AS `boolFeatured`,`MyMusic52`.`album_artist`.`strJoinPhrase` AS `strJoinPhrase`,`MyMusic52`.`album_artist`.`iOrder` AS `iOrder` from (`MyMusic52`.`album_artist` join `MyMusic52`.`artist` on((`MyMusic52`.`album_artist`.`idArtist` = `MyMusic52`.`artist`.`idArtist`))) */;

--
-- Final view structure for view `albumview`
--

/*!50001 DROP TABLE IF EXISTS `albumview`*/;
/*!50001 DROP VIEW IF EXISTS `albumview`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`xbmc`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `albumview` AS select `MyMusic52`.`album`.`idAlbum` AS `idAlbum`,`MyMusic52`.`album`.`strAlbum` AS `strAlbum`,`MyMusic52`.`album`.`strMusicBrainzAlbumID` AS `strMusicBrainzAlbumID`,`MyMusic52`.`album`.`strArtists` AS `strArtists`,`MyMusic52`.`album`.`strGenres` AS `strGenres`,`MyMusic52`.`album`.`iYear` AS `iYear`,`MyMusic52`.`album`.`strMoods` AS `strMoods`,`MyMusic52`.`album`.`strStyles` AS `strStyles`,`MyMusic52`.`album`.`strThemes` AS `strThemes`,`MyMusic52`.`album`.`strReview` AS `strReview`,`MyMusic52`.`album`.`strLabel` AS `strLabel`,`MyMusic52`.`album`.`strType` AS `strType`,`MyMusic52`.`album`.`strImage` AS `strImage`,`MyMusic52`.`album`.`iRating` AS `iRating`,`MyMusic52`.`album`.`bCompilation` AS `bCompilation`,(select min(`MyMusic52`.`song`.`iTimesPlayed`) from `MyMusic52`.`song` where (`MyMusic52`.`song`.`idAlbum` = `MyMusic52`.`album`.`idAlbum`)) AS `iTimesPlayed`,`MyMusic52`.`album`.`strReleaseType` AS `strReleaseType` from `MyMusic52`.`album` */;

--
-- Final view structure for view `artistview`
--

/*!50001 DROP TABLE IF EXISTS `artistview`*/;
/*!50001 DROP VIEW IF EXISTS `artistview`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`xbmc`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `artistview` AS select `MyMusic52`.`artist`.`idArtist` AS `idArtist`,`MyMusic52`.`artist`.`strArtist` AS `strArtist`,`MyMusic52`.`artist`.`strMusicBrainzArtistID` AS `strMusicBrainzArtistID`,`MyMusic52`.`artist`.`strBorn` AS `strBorn`,`MyMusic52`.`artist`.`strFormed` AS `strFormed`,`MyMusic52`.`artist`.`strGenres` AS `strGenres`,`MyMusic52`.`artist`.`strMoods` AS `strMoods`,`MyMusic52`.`artist`.`strStyles` AS `strStyles`,`MyMusic52`.`artist`.`strInstruments` AS `strInstruments`,`MyMusic52`.`artist`.`strBiography` AS `strBiography`,`MyMusic52`.`artist`.`strDied` AS `strDied`,`MyMusic52`.`artist`.`strDisbanded` AS `strDisbanded`,`MyMusic52`.`artist`.`strYearsActive` AS `strYearsActive`,`MyMusic52`.`artist`.`strImage` AS `strImage`,`MyMusic52`.`artist`.`strFanart` AS `strFanart` from `MyMusic52`.`artist` */;

--
-- Final view structure for view `songartistview`
--

/*!50001 DROP TABLE IF EXISTS `songartistview`*/;
/*!50001 DROP VIEW IF EXISTS `songartistview`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`xbmc`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `songartistview` AS select `MyMusic52`.`song_artist`.`idSong` AS `idSong`,`MyMusic52`.`song_artist`.`idArtist` AS `idArtist`,`MyMusic52`.`artist`.`strArtist` AS `strArtist`,`MyMusic52`.`artist`.`strMusicBrainzArtistID` AS `strMusicBrainzArtistID`,`MyMusic52`.`song_artist`.`boolFeatured` AS `boolFeatured`,`MyMusic52`.`song_artist`.`strJoinPhrase` AS `strJoinPhrase`,`MyMusic52`.`song_artist`.`iOrder` AS `iOrder` from (`MyMusic52`.`song_artist` join `MyMusic52`.`artist` on((`MyMusic52`.`song_artist`.`idArtist` = `MyMusic52`.`artist`.`idArtist`))) */;

--
-- Final view structure for view `songview`
--

/*!50001 DROP TABLE IF EXISTS `songview`*/;
/*!50001 DROP VIEW IF EXISTS `songview`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`xbmc`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `songview` AS select `MyMusic52`.`song`.`idSong` AS `idSong`,`MyMusic52`.`song`.`strArtists` AS `strArtists`,`MyMusic52`.`song`.`strGenres` AS `strGenres`,`MyMusic52`.`song`.`strTitle` AS `strTitle`,`MyMusic52`.`song`.`iTrack` AS `iTrack`,`MyMusic52`.`song`.`iDuration` AS `iDuration`,`MyMusic52`.`song`.`iYear` AS `iYear`,`MyMusic52`.`song`.`strFileName` AS `strFileName`,`MyMusic52`.`song`.`strMusicBrainzTrackID` AS `strMusicBrainzTrackID`,`MyMusic52`.`song`.`iTimesPlayed` AS `iTimesPlayed`,`MyMusic52`.`song`.`iStartOffset` AS `iStartOffset`,`MyMusic52`.`song`.`iEndOffset` AS `iEndOffset`,`MyMusic52`.`song`.`lastplayed` AS `lastplayed`,`MyMusic52`.`song`.`rating` AS `rating`,`MyMusic52`.`song`.`comment` AS `comment`,`MyMusic52`.`song`.`idAlbum` AS `idAlbum`,`MyMusic52`.`album`.`strAlbum` AS `strAlbum`,`MyMusic52`.`path`.`strPath` AS `strPath`,`MyMusic52`.`karaokedata`.`iKaraNumber` AS `iKaraNumber`,`MyMusic52`.`karaokedata`.`iKaraDelay` AS `iKaraDelay`,`MyMusic52`.`karaokedata`.`strKaraEncoding` AS `strKaraEncoding`,`MyMusic52`.`album`.`bCompilation` AS `bCompilation`,`MyMusic52`.`album`.`strArtists` AS `strAlbumArtists`,`MyMusic52`.`album`.`strReleaseType` AS `strAlbumReleaseType`,`MyMusic52`.`song`.`mood` AS `mood` from (((`MyMusic52`.`song` join `MyMusic52`.`album` on((`MyMusic52`.`song`.`idAlbum` = `MyMusic52`.`album`.`idAlbum`))) join `MyMusic52`.`path` on((`MyMusic52`.`song`.`idPath` = `MyMusic52`.`path`.`idPath`))) left join `MyMusic52`.`karaokedata` on((`MyMusic52`.`song`.`idSong` = `MyMusic52`.`karaokedata`.`idSong`))) */;


