>>91936 Yeah, I'm stick on my phone, not on a computer so torrents aren't going to help. Honestly, I'm looking to use this as a ringtone in the first place.
>>92231 I 'member. Outlaw star opening theme Wasn't there another show they made set in the same universe as Outlaw Star but it was unfortunately pretty shit?
>>418869 The 'intro' animation of the movie isn't so bad either, though obviously the musics not a dramatic anime theme song like Tank! is. Cowboy Bebop Movie Opening
>>419487 Gunsmith cats is pretty fucked due to that character in the opening, Minnie May. She is highly sexxed and looks like a little kid despite being a teenager due to taking growth-stunting drugs to try and stay attractive to her pedo boyfriend who is a much older man.
SELECT *, (
SELECT GROUP_CONCAT(DISTINCT `kobaboardban`.`boardid` ORDER BY `kobaboardban`.`boardid` SEPARATOR ',')
FROM `kobaboardban` WHERE `banid` = `id` GROUP BY `banid`
) AS `active_boards`
FROM `kobaban`
WHERE (
(`iplong1` = '03eeca4c')
OR
(`iplong1` <= '03eeca4c' AND '03eeca4c' <= `iplong2`)
)
AND `type` IN(-1,0,1,2,3)
AND (`id` IN ( SELECT `banid` FROM `kobaboardban` WHERE `boardid` IN(4) )
OR `global` = 1)
ORDER BY `type`,`expiration` DESC
no rows found or affected (prepared query)
time taken: 0.00363588
SELECT p.*,
r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid,
s.total_posts, s.total_files, s.total_image, s.total_audio, s.total_video, s.total_swf, s.unique_ip, s.unique_user
FROM `kobapost` p
LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid
LEFT JOIN `kobapoststats` s on p.boardid = s.boardid and p.postid = s.threadid
WHERE
p.`boardid` = '4'
AND p.`postid` = '90667'
AND `parentid` = '0'
AND `deleted` = '0'
UNION ALL
SELECT p.*,
r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid,
null as total_posts, null as total_files, null as total_image, null as total_audio, null as total_video, null as total_swf, null as unique_ip, null as unique_user
FROM `kobapost` p
LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid
WHERE
p.`boardid` = '4'
AND `parentid` = '90667'
AND `deleted` = '0'
ORDER BY `parentid`,`postid`