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` = '22efad90')
OR
(`iplong1` <= '22efad90' AND '22efad90' <= `iplong2`)
)
AND `type` IN(-1,0,1,2,3)
AND (`id` IN ( SELECT `banid` FROM `kobaboardban` WHERE `boardid` IN(16) )
OR `global` = 1)
ORDER BY `type`,`expiration` DESC
no rows found or affected (prepared query)
time taken: 0.00060201
SELECT * FROM `kobapost` WHERE `boardid` = '16'
AND `deleted` = 0
AND `parentid` = 0
ORDER BY
`pin` DESC,
`bumped` DESC