| 0.0005 |
SELECT COUNT(*) AS `numrows`
FROM `tb_board` `A`
WHERE `A`.`board_code` = 'teenstar'
AND `A`.`board_category` IN('국제회의 및 소식')
AND `A`.`is_notice` = 'N'
AND `A`.`is_use` = 'Y'
|
| 0.0033 |
SELECT A.*, (SELECT REPLACE(full_path, '/bsteenstar/www', '') FROM tb_board_upload WHERE seq = A.seq AND upload_type = 'image' ORDER BY file_no ASC LIMIT 1) AS thumb_path, (SELECT COUNT(*) FROM tb_board_upload WHERE seq = A.seq AND upload_type = 'file') AS file_cnt
FROM `tb_board` `A`
WHERE `A`.`board_code` = 'teenstar'
AND `A`.`board_category` IN('국제회의 및 소식')
AND `A`.`is_notice` = 'N'
AND `A`.`is_use` = 'Y'
ORDER BY `A`.`regist_date` DESC
LIMIT 12
|
| 0.0004 |
SELECT A.*, (SELECT REPLACE(full_path, '/bsteenstar/www', '') FROM tb_board_upload WHERE seq = A.seq AND upload_type = 'image' ORDER BY file_no ASC LIMIT 1) AS thumb_path, (SELECT COUNT(*) FROM tb_board_upload WHERE seq = A.seq AND upload_type = 'file') AS file_cnt
FROM `tb_board` `A`
WHERE `A`.`board_code` = 'teenstar'
AND `A`.`board_category` IN('국제회의 및 소식')
AND `A`.`is_notice` = 'Y'
AND `A`.`is_use` = 'Y'
ORDER BY `A`.`regist_date` DESC
|
2023.11.20
2022.02.01
2020.12.25
2020.08.18
2012.08.15