CREATE TABLE `z_temp_table_7` ( `id` int(11) NOT NULL AUTO_INCREMENT, `path` text CHARACTER SET latin1 NOT NULL, `length` int(11) NOT NULL, `track` text CHARACTER SET latin1 NOT NULL, `artist` text CHARACTER SET latin1 NOT NULL, PRIMARY KEY (`id`), KEY `Artist` (`artist`(20)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO z_temp_table_7 (path, length, track, artist) SELECT DISTINCT pathname,length,title,track_artists.name AS artist FROM tracks, playlist_tracks, track_artists WHERE ( playlist_tracks.trackid = tracks.id ) AND ( playlist_tracks.playlistid = 7 ) AND (track_artists.id = tracks.artistid) ORDER BY RAND();
Process 7
Creating playlist 8
CREATE TABLE `z_temp_table_8` ( `id` int(11) NOT NULL AUTO_INCREMENT, `path` text CHARACTER SET latin1 NOT NULL, `length` int(11) NOT NULL, `track` text CHARACTER SET latin1 NOT NULL, `artist` text CHARACTER SET latin1 NOT NULL, PRIMARY KEY (`id`), KEY `Artist` (`artist`(20)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO z_temp_table_8 (path, length, track, artist) SELECT DISTINCT pathname,length,title,track_artists.name AS artist FROM tracks, playlist_tracks, track_artists WHERE ( playlist_tracks.trackid = tracks.id ) AND ( playlist_tracks.playlistid = 8 ) AND (track_artists.id = tracks.artistid) ORDER BY RAND();
Process 8
Creating playlist 9
CREATE TABLE `z_temp_table_9` ( `id` int(11) NOT NULL AUTO_INCREMENT, `path` text CHARACTER SET latin1 NOT NULL, `length` int(11) NOT NULL, `track` text CHARACTER SET latin1 NOT NULL, `artist` text CHARACTER SET latin1 NOT NULL, PRIMARY KEY (`id`), KEY `Artist` (`artist`(20)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO z_temp_table_9 (path, length, track, artist) SELECT DISTINCT pathname,length,title,track_artists.name AS artist FROM tracks, playlist_tracks, track_artists WHERE ( playlist_tracks.trackid = tracks.id ) AND ( playlist_tracks.playlistid = 9 ) AND (track_artists.id = tracks.artistid) ORDER BY RAND();
Process 9
Creating playlist 16
CREATE TABLE `z_temp_table_16` ( `id` int(11) NOT NULL AUTO_INCREMENT, `path` text CHARACTER SET latin1 NOT NULL, `length` int(11) NOT NULL, `track` text CHARACTER SET latin1 NOT NULL, `artist` text CHARACTER SET latin1 NOT NULL, PRIMARY KEY (`id`), KEY `Artist` (`artist`(20)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO z_temp_table_16 (path, length, track, artist) SELECT DISTINCT pathname,length,title,track_artists.name AS artist FROM tracks, playlist_tracks, track_artists WHERE ( playlist_tracks.trackid = tracks.id ) AND ( playlist_tracks.playlistid = 16 ) AND (track_artists.id = tracks.artistid) ORDER BY RAND();
Process 16
Creating playlist 15
CREATE TABLE `z_temp_table_15` ( `id` int(11) NOT NULL AUTO_INCREMENT, `path` text CHARACTER SET latin1 NOT NULL, `length` int(11) NOT NULL, `track` text CHARACTER SET latin1 NOT NULL, `artist` text CHARACTER SET latin1 NOT NULL, PRIMARY KEY (`id`), KEY `Artist` (`artist`(20)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO z_temp_table_15 (path, length, track, artist) SELECT DISTINCT pathname,length,title,track_artists.name AS artist FROM tracks, playlist_tracks, track_artists WHERE ( playlist_tracks.trackid = tracks.id ) AND ( playlist_tracks.playlistid = 15 ) AND (track_artists.id = tracks.artistid) ORDER BY RAND();
Process 15
Creating playlist 33
CREATE TABLE `z_temp_table_33` ( `id` int(11) NOT NULL AUTO_INCREMENT, `path` text CHARACTER SET latin1 NOT NULL, `length` int(11) NOT NULL, `track` text CHARACTER SET latin1 NOT NULL, `artist` text CHARACTER SET latin1 NOT NULL, PRIMARY KEY (`id`), KEY `Artist` (`artist`(20)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO z_temp_table_33 (path, length, track, artist) SELECT DISTINCT pathname,length,title,track_artists.name AS artist FROM tracks, playlist_tracks, track_artists WHERE ( playlist_tracks.trackid = tracks.id ) AND ( playlist_tracks.playlistid = 33 ) AND (track_artists.id = tracks.artistid) ORDER BY RAND();
Process 33
Creating playlist 13
CREATE TABLE `z_temp_table_13` ( `id` int(11) NOT NULL AUTO_INCREMENT, `path` text CHARACTER SET latin1 NOT NULL, `length` int(11) NOT NULL, `track` text CHARACTER SET latin1 NOT NULL, `artist` text CHARACTER SET latin1 NOT NULL, PRIMARY KEY (`id`), KEY `Artist` (`artist`(20)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO z_temp_table_13 (path, length, track, artist) SELECT DISTINCT pathname,length,title,track_artists.name AS artist FROM tracks, playlist_tracks, track_artists WHERE ( playlist_tracks.trackid = tracks.id ) AND ( playlist_tracks.playlistid = 13 ) AND (track_artists.id = tracks.artistid) ORDER BY RAND();
Process 13
Creating playlist 14
CREATE TABLE `z_temp_table_14` ( `id` int(11) NOT NULL AUTO_INCREMENT, `path` text CHARACTER SET latin1 NOT NULL, `length` int(11) NOT NULL, `track` text CHARACTER SET latin1 NOT NULL, `artist` text CHARACTER SET latin1 NOT NULL, PRIMARY KEY (`id`), KEY `Artist` (`artist`(20)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO z_temp_table_14 (path, length, track, artist) SELECT DISTINCT pathname,length,title,track_artists.name AS artist FROM tracks, playlist_tracks, track_artists WHERE ( playlist_tracks.trackid = tracks.id ) AND ( playlist_tracks.playlistid = 14 ) AND (track_artists.id = tracks.artistid) ORDER BY RAND();
Process 14
Creating playlist 10
CREATE TABLE `z_temp_table_10` ( `id` int(11) NOT NULL AUTO_INCREMENT, `path` text CHARACTER SET latin1 NOT NULL, `length` int(11) NOT NULL, `track` text CHARACTER SET latin1 NOT NULL, `artist` text CHARACTER SET latin1 NOT NULL, PRIMARY KEY (`id`), KEY `Artist` (`artist`(20)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO z_temp_table_10 (path, length, track, artist) SELECT DISTINCT pathname,length,title,track_artists.name AS artist FROM tracks, playlist_tracks, track_artists WHERE ( playlist_tracks.trackid = tracks.id ) AND ( playlist_tracks.playlistid = 10 ) AND (track_artists.id = tracks.artistid) ORDER BY RAND();
Process 10
Creating playlist 250
CREATE TABLE `z_temp_table_250` ( `id` int(11) NOT NULL AUTO_INCREMENT, `path` text CHARACTER SET latin1 NOT NULL, `length` int(11) NOT NULL, `track` text CHARACTER SET latin1 NOT NULL, `artist` text CHARACTER SET latin1 NOT NULL, PRIMARY KEY (`id`), KEY `Artist` (`artist`(20)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO z_temp_table_250 (path, length, track, artist) SELECT DISTINCT pathname,length,title,track_artists.name AS artist FROM tracks, playlist_tracks, track_artists WHERE ( playlist_tracks.trackid = tracks.id ) AND ( playlist_tracks.playlistid = 250 ) AND (track_artists.id = tracks.artistid) ORDER BY RAND();
Process 250
Creating playlist 265
CREATE TABLE `z_temp_table_265` ( `id` int(11) NOT NULL AUTO_INCREMENT, `path` text CHARACTER SET latin1 NOT NULL, `length` int(11) NOT NULL, `track` text CHARACTER SET latin1 NOT NULL, `artist` text CHARACTER SET latin1 NOT NULL, PRIMARY KEY (`id`), KEY `Artist` (`artist`(20)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO z_temp_table_265 (path, length, track, artist) SELECT DISTINCT pathname,length,title,track_artists.name AS artist FROM tracks, playlist_tracks, track_artists WHERE ( playlist_tracks.trackid = tracks.id ) AND ( playlist_tracks.playlistid = 265 ) AND (track_artists.id = tracks.artistid) ORDER BY RAND();
Process 265
Creating playlist 264
CREATE TABLE `z_temp_table_264` ( `id` int(11) NOT NULL AUTO_INCREMENT, `path` text CHARACTER SET latin1 NOT NULL, `length` int(11) NOT NULL, `track` text CHARACTER SET latin1 NOT NULL, `artist` text CHARACTER SET latin1 NOT NULL, PRIMARY KEY (`id`), KEY `Artist` (`artist`(20)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO z_temp_table_264 (path, length, track, artist) SELECT DISTINCT pathname,length,title,track_artists.name AS artist FROM tracks, playlist_tracks, track_artists WHERE ( playlist_tracks.trackid = tracks.id ) AND ( playlist_tracks.playlistid = 264 ) AND (track_artists.id = tracks.artistid) ORDER BY RAND();
Process 264
Creating playlist 266
CREATE TABLE `z_temp_table_266` ( `id` int(11) NOT NULL AUTO_INCREMENT, `path` text CHARACTER SET latin1 NOT NULL, `length` int(11) NOT NULL, `track` text CHARACTER SET latin1 NOT NULL, `artist` text CHARACTER SET latin1 NOT NULL, PRIMARY KEY (`id`), KEY `Artist` (`artist`(20)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO z_temp_table_266 (path, length, track, artist) SELECT DISTINCT pathname,length,title,track_artists.name AS artist FROM tracks, playlist_tracks, track_artists WHERE ( playlist_tracks.trackid = tracks.id ) AND ( playlist_tracks.playlistid = 266 ) AND (track_artists.id = tracks.artistid) ORDER BY RAND();
Process 266
Creating playlist 2
CREATE TABLE `z_temp_table_2` ( `id` int(11) NOT NULL AUTO_INCREMENT, `path` text CHARACTER SET latin1 NOT NULL, `length` int(11) NOT NULL, `track` text CHARACTER SET latin1 NOT NULL, `artist` text CHARACTER SET latin1 NOT NULL, PRIMARY KEY (`id`), KEY `Artist` (`artist`(20)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO z_temp_table_2 (path, length, track, artist) SELECT DISTINCT pathname,length,title,track_artists.name AS artist FROM tracks, playlist_tracks, track_artists WHERE ( playlist_tracks.trackid = tracks.id ) AND ( playlist_tracks.playlistid = 2 ) AND (track_artists.id = tracks.artistid) ORDER BY RAND();
Process 2
Creating playlist 17
CREATE TABLE `z_temp_table_17` ( `id` int(11) NOT NULL AUTO_INCREMENT, `path` text CHARACTER SET latin1 NOT NULL, `length` int(11) NOT NULL, `track` text CHARACTER SET latin1 NOT NULL, `artist` text CHARACTER SET latin1 NOT NULL, PRIMARY KEY (`id`), KEY `Artist` (`artist`(20)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO z_temp_table_17 (path, length, track, artist) SELECT DISTINCT pathname,length,title,track_artists.name AS artist FROM tracks, playlist_tracks, track_artists WHERE ( playlist_tracks.trackid = tracks.id ) AND ( playlist_tracks.playlistid = 17 ) AND (track_artists.id = tracks.artistid) ORDER BY RAND();
Process 17
Creating playlist 23
CREATE TABLE `z_temp_table_23` ( `id` int(11) NOT NULL AUTO_INCREMENT, `path` text CHARACTER SET latin1 NOT NULL, `length` int(11) NOT NULL, `track` text CHARACTER SET latin1 NOT NULL, `artist` text CHARACTER SET latin1 NOT NULL, PRIMARY KEY (`id`), KEY `Artist` (`artist`(20)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO z_temp_table_23 (path, length, track, artist) SELECT DISTINCT pathname,length,title,track_artists.name AS artist FROM tracks, playlist_tracks, track_artists WHERE ( playlist_tracks.trackid = tracks.id ) AND ( playlist_tracks.playlistid = 23 ) AND (track_artists.id = tracks.artistid) ORDER BY RAND();
Process 23
Creating playlist 24
CREATE TABLE `z_temp_table_24` ( `id` int(11) NOT NULL AUTO_INCREMENT, `path` text CHARACTER SET latin1 NOT NULL, `length` int(11) NOT NULL, `track` text CHARACTER SET latin1 NOT NULL, `artist` text CHARACTER SET latin1 NOT NULL, PRIMARY KEY (`id`), KEY `Artist` (`artist`(20)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO z_temp_table_24 (path, length, track, artist) SELECT DISTINCT pathname,length,title,track_artists.name AS artist FROM tracks, playlist_tracks, track_artists WHERE ( playlist_tracks.trackid = tracks.id ) AND ( playlist_tracks.playlistid = 24 ) AND (track_artists.id = tracks.artistid) ORDER BY RAND();
Process 24
Creating playlist 12
CREATE TABLE `z_temp_table_12` ( `id` int(11) NOT NULL AUTO_INCREMENT, `path` text CHARACTER SET latin1 NOT NULL, `length` int(11) NOT NULL, `track` text CHARACTER SET latin1 NOT NULL, `artist` text CHARACTER SET latin1 NOT NULL, PRIMARY KEY (`id`), KEY `Artist` (`artist`(20)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO z_temp_table_12 (path, length, track, artist) SELECT DISTINCT pathname,length,title,track_artists.name AS artist FROM tracks, playlist_tracks, track_artists WHERE ( playlist_tracks.trackid = tracks.id ) AND ( playlist_tracks.playlistid = 12 ) AND (track_artists.id = tracks.artistid) ORDER BY RAND();
Process 12
Creating playlist 28
CREATE TABLE `z_temp_table_28` ( `id` int(11) NOT NULL AUTO_INCREMENT, `path` text CHARACTER SET latin1 NOT NULL, `length` int(11) NOT NULL, `track` text CHARACTER SET latin1 NOT NULL, `artist` text CHARACTER SET latin1 NOT NULL, PRIMARY KEY (`id`), KEY `Artist` (`artist`(20)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO z_temp_table_28 (path, length, track, artist) SELECT DISTINCT pathname,length,title,track_artists.name AS artist FROM tracks, playlist_tracks, track_artists WHERE ( playlist_tracks.trackid = tracks.id ) AND ( playlist_tracks.playlistid = 28 ) AND (track_artists.id = tracks.artistid) ORDER BY RAND();
Process 28
Creating playlist 11
CREATE TABLE `z_temp_table_11` ( `id` int(11) NOT NULL AUTO_INCREMENT, `path` text CHARACTER SET latin1 NOT NULL, `length` int(11) NOT NULL, `track` text CHARACTER SET latin1 NOT NULL, `artist` text CHARACTER SET latin1 NOT NULL, PRIMARY KEY (`id`), KEY `Artist` (`artist`(20)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO z_temp_table_11 (path, length, track, artist) SELECT DISTINCT pathname,length,title,track_artists.name AS artist FROM tracks, playlist_tracks, track_artists WHERE ( playlist_tracks.trackid = tracks.id ) AND ( playlist_tracks.playlistid = 11 ) AND (track_artists.id = tracks.artistid) ORDER BY RAND();
Process 11
Creating playlist 5
CREATE TABLE `z_temp_table_5` ( `id` int(11) NOT NULL AUTO_INCREMENT, `path` text CHARACTER SET latin1 NOT NULL, `length` int(11) NOT NULL, `track` text CHARACTER SET latin1 NOT NULL, `artist` text CHARACTER SET latin1 NOT NULL, PRIMARY KEY (`id`), KEY `Artist` (`artist`(20)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO z_temp_table_5 (path, length, track, artist) SELECT DISTINCT pathname,length,title,track_artists.name AS artist FROM tracks, playlist_tracks, track_artists WHERE ( playlist_tracks.trackid = tracks.id ) AND ( playlist_tracks.playlistid = 5 ) AND (track_artists.id = tracks.artistid) ORDER BY RAND();
Process 5
Creating playlist 34
CREATE TABLE `z_temp_table_34` ( `id` int(11) NOT NULL AUTO_INCREMENT, `path` text CHARACTER SET latin1 NOT NULL, `length` int(11) NOT NULL, `track` text CHARACTER SET latin1 NOT NULL, `artist` text CHARACTER SET latin1 NOT NULL, PRIMARY KEY (`id`), KEY `Artist` (`artist`(20)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO z_temp_table_34 (path, length, track, artist) SELECT DISTINCT pathname,length,title,track_artists.name AS artist FROM tracks, playlist_tracks, track_artists WHERE ( playlist_tracks.trackid = tracks.id ) AND ( playlist_tracks.playlistid = 34 ) AND (track_artists.id = tracks.artistid) ORDER BY RAND();
Process 34
Creating playlist 157
CREATE TABLE `z_temp_table_157` ( `id` int(11) NOT NULL AUTO_INCREMENT, `path` text CHARACTER SET latin1 NOT NULL, `length` int(11) NOT NULL, `track` text CHARACTER SET latin1 NOT NULL, `artist` text CHARACTER SET latin1 NOT NULL, PRIMARY KEY (`id`), KEY `Artist` (`artist`(20)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO z_temp_table_157 (path, length, track, artist) SELECT DISTINCT pathname,length,title,track_artists.name AS artist FROM tracks, playlist_tracks, track_artists WHERE ( playlist_tracks.trackid = tracks.id ) AND ( playlist_tracks.playlistid = 157 ) AND (track_artists.id = tracks.artistid) ORDER BY RAND();
Process 157
Creating playlist 251
CREATE TABLE `z_temp_table_251` ( `id` int(11) NOT NULL AUTO_INCREMENT, `path` text CHARACTER SET latin1 NOT NULL, `length` int(11) NOT NULL, `track` text CHARACTER SET latin1 NOT NULL, `artist` text CHARACTER SET latin1 NOT NULL, PRIMARY KEY (`id`), KEY `Artist` (`artist`(20)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO z_temp_table_251 (path, length, track, artist) SELECT DISTINCT pathname,length,title,track_artists.name AS artist FROM tracks, playlist_tracks, track_artists WHERE ( playlist_tracks.trackid = tracks.id ) AND ( playlist_tracks.playlistid = 251 ) AND (track_artists.id = tracks.artistid) ORDER BY RAND();
Process 251
Creating playlist 288
CREATE TABLE `z_temp_table_288` ( `id` int(11) NOT NULL AUTO_INCREMENT, `path` text CHARACTER SET latin1 NOT NULL, `length` int(11) NOT NULL, `track` text CHARACTER SET latin1 NOT NULL, `artist` text CHARACTER SET latin1 NOT NULL, PRIMARY KEY (`id`), KEY `Artist` (`artist`(20)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO z_temp_table_288 (path, length, track, artist) SELECT DISTINCT pathname,length,title,track_artists.name AS artist FROM tracks, playlist_tracks, track_artists WHERE ( playlist_tracks.trackid = tracks.id ) AND ( playlist_tracks.playlistid = 288 ) AND (track_artists.id = tracks.artistid) ORDER BY RAND();
Process 288
Hour: 0
Get Schedule: SELECT * FROM playlists WHERE accountid='2' AND type='scheduled' AND (HOUR(scheduled_datetime)) = '0' AND MINUTE(scheduled_datetime) = '0' AND (scheduled_weekdays = 'mon' OR scheduled_datetime = '2023-06-05 00:0:00') AND status = 'enabled';
Warning. Playlist 2 exhausted
idobi Radio - idobi.com :: 6 (3600) [[6]] (17) [playlist]
INSERT INTO zp_idobi (path, hour, length, track, artist) VALUES ('2014/Eddie/Production/04 Sweepers/1404 Sweeper 14.mp3', '0', '6', 'idobi.com', 'idobi Radio');
idobi.com - idobi 60 :: 69 (3600) [[63]] (23) [playlist]
INSERT INTO zp_idobi (path, hour, length, track, artist) VALUES ('2015/Eddie/Production/Fill/60/idobi - New on Anthm 3b.mp3', '0', '69', 'idobi 60', 'idobi.com');
idobi Session - idobi.com/video :: 81 (3600) [[12]] (251) [playlist]
INSERT INTO zp_idobi (path, hour, length, track, artist) VALUES ('2016/Eddie/Production/Sweepers - Session Set Ups/05-18-16 idobi session 01.mp3', '0', '81', 'idobi.com/video', 'idobi Session');
The Brevet - Embers :: 263 (3600) [[182]] (250) [playlist]
INSERT INTO zp_idobi (path, hour, length, track, artist) VALUES ('2016/Eddie/idobi Sessions/The Brevet - idobi Session - Embers.mp3', '0', '263', 'Embers', 'The Brevet');
idobi Radio - New Music :: 276 (3600) [[13]] (28) [playlist]
INSERT INTO zp_idobi (path, hour, length, track, artist) VALUES ('2016/Eddie/Production/Sweepers - New Music 1609/160809 idobi - New Music 9.mp3', '0', '276', 'New Music', 'idobi Radio');
SAINTE - With Or Without Me :: 447 (3600) [[171]] (13) [playlist]
INSERT INTO zp_idobi (path, hour, length, track, artist) VALUES ('2017/Cleared Music/Sainte/Sainte - With Or Without Me - With Or Without Me.mp3', '0', '447', 'With Or Without Me', 'SAINTE');
idobi.com - idobi 60 :: 510 (3600) [[63]] (23) [playlist]
INSERT INTO zp_idobi (path, hour, length, track, artist) VALUES ('2015/Eddie/Production/Fill/60/idobi - New on Anthm 1a.mp3', '0', '510', 'idobi 60', 'idobi.com');
idobi Radio - idobi.com :: 517 (3600) [[7]] (34) [playlist]
INSERT INTO zp_idobi (path, hour, length, track, artist) VALUES ('2010/tags/idobi Radio - idobi Radio Tags - FOB Pete - idobicom.mp3', '0', '517', 'idobi.com', 'idobi Radio');