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(7) )
OR `global` = 1)
ORDER BY `type`,`expiration` DESC
no rows found or affected (prepared query)
time taken: 0.00167203
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` = '7'
AND p.`postid` = '43945'
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` = '7'
AND `parentid` = '43945'
AND `deleted` = '0'
ORDER BY `parentid`,`postid`