Creating playlist 7
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 = 'sat' OR scheduled_datetime = '2022-09-24 00:0:00') AND status = 'enabled';

Warning. Playlist 2 exhausted

idobi Radio - idobi.com :: 4 (3600) [[4]] (17) [playlist]

INSERT INTO zp_idobi (path, hour, length, track, artist) VALUES ('2014/Eddie/Production/04 Sweepers/1404 Sweeper 12.mp3', '0', '4', 'idobi.com', 'idobi Radio');

idobi.com - idobi 60 :: 68 (3600) [[64]] (23) [playlist]

INSERT INTO zp_idobi (path, hour, length, track, artist) VALUES ('2015/Eddie/Production/Fill/60/idobi - New on Howl 4a.mp3', '0', '68', 'idobi 60', 'idobi.com');

idobi Session - idobi.com/video :: 81 (3600) [[13]] (251) [playlist]

INSERT INTO zp_idobi (path, hour, length, track, artist) VALUES ('2016/Eddie/Production/Sweepers - Session Set Ups/06-03-16 idobi - THIS is idobi radio.mp3', '0', '81', 'idobi.com/video', 'idobi Session');

The Young Wild - In The Wild :: 312 (3600) [[231]] (250) [playlist]

INSERT INTO zp_idobi (path, hour, length, track, artist) VALUES ('2016/Eddie/idobi Sessions/The Young Wild - idobi Session - In The Wild.mp3', '0', '312', 'In The Wild', 'The Young Wild');

idobi Radio - New Music :: 328 (3600) [[16]] (28) [playlist]

INSERT INTO zp_idobi (path, hour, length, track, artist) VALUES ('2016/Eddie/Production/Sweepers - New Music 1609/160809 idobi - New Music 8.mp3', '0', '328', 'New Music', 'idobi Radio');

Real Friends - Empty Picture Frames :: 513 (3600) [[185]] (13) [playlist]

INSERT INTO zp_idobi (path, hour, length, track, artist) VALUES ('2016/Fearless/2016/Real Friends/The Home Inside My Head/Real Friends - The Home Inside My Head - Empty Picture Frames.mp3', '0', '513', 'Empty Picture Frames', 'Real Friends');

idobi.com - idobi 60 :: 576 (3600) [[63]] (23) [playlist]

INSERT INTO zp_idobi (path, hour, length, track, artist) VALUES ('2015/Eddie/Production/Fill/60/idobi - New on Anthm 1b.mp3', '0', '576', 'idobi 60', 'idobi.com');

idobi Radio - idobi.com :: 583 (3600) [[7]] (34) [playlist]

INSERT INTO zp_idobi (path, hour, length, track, artist) VALUES ('2010/tags/idobi Radio - idobi Radio Tags - Quietdrive Justin - idobicom.mp3', '0', '583', 'idobi.com', 'idobi Radio');