SELECT `s`.`id`, `s`.`title` `stitle`, `s`.`description` `sdesc`, `s`.`image_url_small`, `p`.`title` `ptitle`, `p`.`description` `pdesc`
FROM `playlists` `p`, `playlists_streams` `ps`, `streams` `s`
WHERE `s`.`id` = `ps`.`streams_id` AND `p`.`id` = `ps`.`playlists_id` AND `p`.`id` = (
     SELECT `pu`.`playlists_id`
     FROM `playlists_users` `pu`, `users` `u`
     WHERE `u`.`username` = %s AND `u`.`id` = `pu`.`users_id`
     LIMIT %s,1)
ORDER BY `ps`.`order` ASC