SELECT A.* , A.READS + 1 AS `READS` , CASE WHEN A.SORT_1 < -10000000000 THEN 'N' ELSE A.IS_SECRET END AS IS_SECRET , IF(A.STA_DATE IS NULL OR A.STA_DATE = '', NULL, CONCAT(SUBSTRING(A.STA_DATE, 1, 4), '-', SUBSTRING(A.STA_DATE, 5, 2), '-', SUBSTRING(A.STA_DATE, 7, 2))) AS STA_DATE , IF(A.END_DATE IS NULL OR A.END_DATE = '', NULL, CONCAT(SUBSTRING(A.END_DATE, 1, 4), '-', SUBSTRING(A.END_DATE, 5, 2), '-', SUBSTRING(A.END_DATE, 7, 2))) AS END_DATE , CASE WHEN A.SORT_1 < -10000000000 THEN 'Y' ELSE 'N' END AS IS_NOTICE , CASE WHEN LENGTH(IFNULL(A.STA_DATE, '')) = 8 AND LENGTH(IFNULL(A.END_DATE, '')) = 8 THEN (CASE WHEN UNIX_TIMESTAMP(SUBSTRING(NOW(), 1, 10)) BETWEEN UNIX_TIMESTAMP(A.STA_DATE) AND UNIX_TIMESTAMP(A.END_DATE) THEN 'Y' ELSE 'N' END) WHEN LENGTH(IFNULL(A.STA_DATE, '')) = 8 THEN (CASE WHEN UNIX_TIMESTAMP(SUBSTRING(NOW(), 1, 10)) >= UNIX_TIMESTAMP(A.STA_DATE) THEN 'Y' ELSE 'N' END) WHEN LENGTH(IFNULL(A.END_DATE, '')) = 8 THEN (CASE WHEN UNIX_TIMESTAMP(SUBSTRING(NOW(), 1, 10)) <= UNIX_TIMESTAMP(A.END_DATE) THEN 'Y' ELSE 'N' END) ELSE 'Y' END AS IS_ING , B.NAME AS CATE_NAME , B.SORT AS CATE_SORT FROM TB_BBS_POST A LEFT JOIN TB_BBS_CATE B ON A.CATE_SEQ = B.CATE_SEQ WHERE A.POST_SEQ = 2719 AND A.BBS_SEQ = 3
Server shutdown in progress