SELECT D.document_srl, REPLACE(D.content, 'http://', 'https://') AS content, IFNULL(V1.value, '') AS linkValue, IFNULL(V2.value, '') AS marginTop, IFNULL(V3.value, '') AS marginLeft, CASE WHEN V4.value IS NULL OR V4.value = '' THEN DATE_FORMAT(CURDATE(), '%Y%m%d') ELSE V4.value END AS startDay, CASE WHEN V5.value IS NULL OR V5.value = '' THEN DATE_FORMAT(CURDATE(), '%Y%m%d') ELSE V5.value END AS endDay FROM xe_documents D LEFT JOIN xe_document_extra_vars V1 ON (D.document_srl = V1.document_srl AND V1.eid = 'link') LEFT JOIN xe_document_extra_vars V2 ON (D.document_srl = V2.document_srl AND V2.eid = 'extra_vars1') LEFT JOIN xe_document_extra_vars V3 ON (D.document_srl = V3.document_srl AND V3.eid = 'extra_vars2') RIGHT JOIN xe_document_extra_vars V4 ON D.document_srl = V4.document_srl AND V4.eid = 'extra_vars3' AND IFNULL(V4.value, '') != '' RIGHT JOIN xe_document_extra_vars V5 ON D.document_srl = V5.document_srl AND V5.eid = 'extra_vars4' AND IFNULL(V5.value, '') != '' WHERE D.module_srl IN (253) AND STR_TO_DATE(V4.value, '%Y%m%d') <= CURDATE() AND STR_TO_DATE(V5.value, '%Y%m%d') >= CURDATE() ORDER BY D.document_srl DESC;