대구청년커뮤니티포털 '젊프'
select AP_SEQ, AP_TITLE, AP_ORGAN_NM, AP_CATE, AP_SDATE, AP_EDATE, AP_THUMB,
AP_FLAG, AP_TAG, AP_DEL_YN, AP_REG_DT, AP_DEADLINE_YN, AP_YOUTH,
datediff(AP_EDATE, date_format(now(), '%Y-%m-%d')) as datedf,
if(datediff(AP_EDATE, date_format(now(), '%Y-%m-%d')) >= 0 and datediff(AP_EDATE, date_format(now(), '%Y-%m-%d')) <= 3, 1, 0) as deadline,
ifnull(AP_EDATE, date_format(AP_REG_DT, '%Y-%m-%d')) AS AP_EDATES,
AP_CATES, AP_YFLAG
from mc_application
where AP_DEL_YN = 'N' and
AP_FLAG != '3' and
AP_TFLAG = '1'
and AP_YFLAG = :search_yflag
order by deadline desc,
AP_FLAG asc,
(CASE WHEN AP_FLAG = 1 THEN AP_EDATES END)asc,
(CASE WHEN AP_FLAG != 1 THEN AP_EDATES END)desc,
AP_REG_DT desc
limit 48, 8
