SELECT
md_cms.md_cms_id as id,
md_cms.md_cms_masterkey as masterkey,
md_cms.md_cms_gid as gid,
md_cms.md_cms_position as position,
md_cms.md_cms_parentid as parentid,
md_cms.md_cms_lastdate as lastdate,
md_cms.md_cms_credate as credate,
md_cms.md_cms_pic as piccms,
md_cms.md_cms_ismain as ismain,
md_cms_detail.md_cms_detail_id as contantid,
md_cms_detail.md_cms_detail_subject as subject,
md_cms_detail.md_cms_detail_title as title,
md_cms_detail.md_cms_detail_title_short as shorttitle,
md_cms_detail.md_cms_detail_pic as pic,
md_cms_detail.md_cms_detail_icon as icon,
md_cms_detail.md_cms_detail_url as url,
md_cms_detail.md_cms_detail_target as target,
md_cms_detail.md_cms_detail_htmlfilename as htmlfilename,
md_cms_detail.md_cms_detail_view as view,
md_cms_detail.md_cms_detail_metatitle as metatitle,
md_cms_detail.md_cms_detail_description as description,
md_cms_detail.md_cms_detail_keywords as keywords,
md_cms_detail.md_cms_detail_type as type,
md_cms_detail.md_cms_detail_btn_name as btn_name
FROM
md_cms
INNER JOIN
md_cms_detail
ON
md_cms_detail.md_cms_detail_contantid = md_cms.md_cms_id
WHERE
md_cms_detail.md_cms_detail_subject != '' AND
((md_cms_detail.md_cms_detail_sdate='0000-00-00 00:00:00' AND
md_cms_detail.md_cms_detail_edate='0000-00-00 00:00:00') OR
(md_cms_detail.md_cms_detail_sdate='0000-00-00 00:00:00' AND
TO_DAYS(md_cms_detail.md_cms_detail_edate)>=TO_DAYS(NOW()) ) OR
(TO_DAYS(md_cms_detail.md_cms_detail_sdate)<=TO_DAYS(NOW()) AND
md_cms_detail.md_cms_detail_edate='0000-00-00 00:00:00' ) OR
(TO_DAYS(md_cms_detail.md_cms_detail_sdate)<=TO_DAYS(NOW()) AND
TO_DAYS(md_cms_detail.md_cms_detail_edate)>=TO_DAYS(NOW()) ))
AND md_cms_site ='1' AND md_cms_detail_language ='en' AND md_cms.md_cms_status != 'Disable' AND md_cms.md_cms_masterkey = 'footer-link' ORDER BY md_cms.md_cms_order DESC
SELECT
md_cms.md_cms_id as id,
md_cms.md_cms_masterkey as masterkey,
md_cms.md_cms_gid as gid,
md_cms.md_cms_position as position,
md_cms.md_cms_parentid as parentid,
md_cms.md_cms_lastdate as lastdate,
md_cms.md_cms_credate as credate,
md_cms.md_cms_pic as piccms,
md_cms.md_cms_ismain as ismain,
md_cms_detail.md_cms_detail_id as contantid,
md_cms_detail.md_cms_detail_subject as subject,
md_cms_detail.md_cms_detail_title as title,
md_cms_detail.md_cms_detail_title_short as shorttitle,
md_cms_detail.md_cms_detail_pic as pic,
md_cms_detail.md_cms_detail_icon as icon,
md_cms_detail.md_cms_detail_url as url,
md_cms_detail.md_cms_detail_target as target,
md_cms_detail.md_cms_detail_htmlfilename as htmlfilename,
md_cms_detail.md_cms_detail_view as view,
md_cms_detail.md_cms_detail_metatitle as metatitle,
md_cms_detail.md_cms_detail_description as description,
md_cms_detail.md_cms_detail_keywords as keywords,
md_cms_detail.md_cms_detail_type as type,
md_cms_detail.md_cms_detail_btn_name as btn_name
FROM
md_cms
INNER JOIN
md_cms_detail
ON
md_cms_detail.md_cms_detail_contantid = md_cms.md_cms_id
WHERE
md_cms_detail.md_cms_detail_subject != '' AND
((md_cms_detail.md_cms_detail_sdate='0000-00-00 00:00:00' AND
md_cms_detail.md_cms_detail_edate='0000-00-00 00:00:00') OR
(md_cms_detail.md_cms_detail_sdate='0000-00-00 00:00:00' AND
TO_DAYS(md_cms_detail.md_cms_detail_edate)>=TO_DAYS(NOW()) ) OR
(TO_DAYS(md_cms_detail.md_cms_detail_sdate)<=TO_DAYS(NOW()) AND
md_cms_detail.md_cms_detail_edate='0000-00-00 00:00:00' ) OR
(TO_DAYS(md_cms_detail.md_cms_detail_sdate)<=TO_DAYS(NOW()) AND
TO_DAYS(md_cms_detail.md_cms_detail_edate)>=TO_DAYS(NOW()) ))
AND md_cms_site ='1' AND md_cms_detail_language ='en' AND md_cms.md_cms_status != 'Disable' AND md_cms.md_cms_masterkey = 'esg' ORDER BY md_cms.md_cms_order DESC
SELECT
md_cms.md_cms_id as id,
md_cms.md_cms_masterkey as masterkey,
md_cms.md_cms_gid as gid,
md_cms.md_cms_position as position,
md_cms.md_cms_parentid as parentid,
md_cms.md_cms_lastdate as lastdate,
md_cms.md_cms_credate as credate,
md_cms.md_cms_pic as piccms,
md_cms.md_cms_ismain as ismain,
md_cms_detail.md_cms_detail_id as contantid,
md_cms_detail.md_cms_detail_subject as subject,
md_cms_detail.md_cms_detail_title as title,
md_cms_detail.md_cms_detail_title_short as shorttitle,
md_cms_detail.md_cms_detail_pic as pic,
md_cms_detail.md_cms_detail_icon as icon,
md_cms_detail.md_cms_detail_url as url,
md_cms_detail.md_cms_detail_target as target,
md_cms_detail.md_cms_detail_htmlfilename as htmlfilename,
md_cms_detail.md_cms_detail_view as view,
md_cms_detail.md_cms_detail_metatitle as metatitle,
md_cms_detail.md_cms_detail_description as description,
md_cms_detail.md_cms_detail_keywords as keywords,
md_cms_detail.md_cms_detail_type as type,
md_cms_detail.md_cms_detail_btn_name as btn_name
FROM
md_cms
INNER JOIN
md_cms_detail
ON
md_cms_detail.md_cms_detail_contantid = md_cms.md_cms_id
WHERE
md_cms_detail.md_cms_detail_subject != '' AND
((md_cms_detail.md_cms_detail_sdate='0000-00-00 00:00:00' AND
md_cms_detail.md_cms_detail_edate='0000-00-00 00:00:00') OR
(md_cms_detail.md_cms_detail_sdate='0000-00-00 00:00:00' AND
TO_DAYS(md_cms_detail.md_cms_detail_edate)>=TO_DAYS(NOW()) ) OR
(TO_DAYS(md_cms_detail.md_cms_detail_sdate)<=TO_DAYS(NOW()) AND
md_cms_detail.md_cms_detail_edate='0000-00-00 00:00:00' ) OR
(TO_DAYS(md_cms_detail.md_cms_detail_sdate)<=TO_DAYS(NOW()) AND
TO_DAYS(md_cms_detail.md_cms_detail_edate)>=TO_DAYS(NOW()) ))
AND md_cms_site ='1' AND md_cms_detail_language ='en' AND md_cms.md_cms_status != 'Disable' AND md_cms.md_cms_masterkey = 'ab' ORDER BY md_cms.md_cms_order DESC
SELECT
md_cms.md_cms_id as id,
md_cms.md_cms_masterkey as masterkey,
md_cms.md_cms_gid as gid,
md_cms.md_cms_position as position,
md_cms.md_cms_parentid as parentid,
md_cms.md_cms_lastdate as lastdate,
md_cms.md_cms_credate as credate,
md_cms.md_cms_pic as piccms,
md_cms.md_cms_ismain as ismain,
md_cms_detail.md_cms_detail_id as contantid,
md_cms_detail.md_cms_detail_subject as subject,
md_cms_detail.md_cms_detail_title as title,
md_cms_detail.md_cms_detail_title_short as shorttitle,
md_cms_detail.md_cms_detail_pic as pic,
md_cms_detail.md_cms_detail_icon as icon,
md_cms_detail.md_cms_detail_url as url,
md_cms_detail.md_cms_detail_target as target,
md_cms_detail.md_cms_detail_htmlfilename as htmlfilename,
md_cms_detail.md_cms_detail_view as view,
md_cms_detail.md_cms_detail_metatitle as metatitle,
md_cms_detail.md_cms_detail_description as description,
md_cms_detail.md_cms_detail_keywords as keywords,
md_cms_detail.md_cms_detail_type as type,
md_cms_detail.md_cms_detail_btn_name as btn_name
FROM
md_cms
INNER JOIN
md_cms_detail
ON
md_cms_detail.md_cms_detail_contantid = md_cms.md_cms_id
WHERE
md_cms_detail.md_cms_detail_subject != '' AND
((md_cms_detail.md_cms_detail_sdate='0000-00-00 00:00:00' AND
md_cms_detail.md_cms_detail_edate='0000-00-00 00:00:00') OR
(md_cms_detail.md_cms_detail_sdate='0000-00-00 00:00:00' AND
TO_DAYS(md_cms_detail.md_cms_detail_edate)>=TO_DAYS(NOW()) ) OR
(TO_DAYS(md_cms_detail.md_cms_detail_sdate)<=TO_DAYS(NOW()) AND
md_cms_detail.md_cms_detail_edate='0000-00-00 00:00:00' ) OR
(TO_DAYS(md_cms_detail.md_cms_detail_sdate)<=TO_DAYS(NOW()) AND
TO_DAYS(md_cms_detail.md_cms_detail_edate)>=TO_DAYS(NOW()) ))
AND md_cms_site ='1' AND md_cms_detail_language ='en' AND md_cms.md_cms_status != 'Disable' AND md_cms.md_cms_masterkey = 'career' ORDER BY md_cms.md_cms_order DESC
SELECT
md_cms.md_cms_id as id,
md_cms.md_cms_masterkey as masterkey,
md_cms.md_cms_gid as gid,
md_cms.md_cms_position as position,
md_cms.md_cms_parentid as parentid,
md_cms.md_cms_lastdate as lastdate,
md_cms.md_cms_credate as credate,
md_cms.md_cms_pic as piccms,
md_cms.md_cms_ismain as ismain,
md_cms_detail.md_cms_detail_id as contantid,
md_cms_detail.md_cms_detail_subject as subject,
md_cms_detail.md_cms_detail_title as title,
md_cms_detail.md_cms_detail_title_short as shorttitle,
md_cms_detail.md_cms_detail_pic as pic,
md_cms_detail.md_cms_detail_icon as icon,
md_cms_detail.md_cms_detail_url as url,
md_cms_detail.md_cms_detail_target as target,
md_cms_detail.md_cms_detail_htmlfilename as htmlfilename,
md_cms_detail.md_cms_detail_view as view,
md_cms_detail.md_cms_detail_metatitle as metatitle,
md_cms_detail.md_cms_detail_description as description,
md_cms_detail.md_cms_detail_keywords as keywords,
md_cms_detail.md_cms_detail_type as type,
md_cms_detail.md_cms_detail_btn_name as btn_name
FROM
md_cms
INNER JOIN
md_cms_detail
ON
md_cms_detail.md_cms_detail_contantid = md_cms.md_cms_id
WHERE
md_cms_detail.md_cms_detail_subject != '' AND
((md_cms_detail.md_cms_detail_sdate='0000-00-00 00:00:00' AND
md_cms_detail.md_cms_detail_edate='0000-00-00 00:00:00') OR
(md_cms_detail.md_cms_detail_sdate='0000-00-00 00:00:00' AND
TO_DAYS(md_cms_detail.md_cms_detail_edate)>=TO_DAYS(NOW()) ) OR
(TO_DAYS(md_cms_detail.md_cms_detail_sdate)<=TO_DAYS(NOW()) AND
md_cms_detail.md_cms_detail_edate='0000-00-00 00:00:00' ) OR
(TO_DAYS(md_cms_detail.md_cms_detail_sdate)<=TO_DAYS(NOW()) AND
TO_DAYS(md_cms_detail.md_cms_detail_edate)>=TO_DAYS(NOW()) ))
AND md_cms_site ='1' AND md_cms_detail_language ='en' AND md_cms.md_cms_status != 'Disable' AND md_cms.md_cms_masterkey = 'contactus' ORDER BY md_cms.md_cms_order DESC
SELECT
md_cms.md_cms_id as id,
md_cms.md_cms_masterkey as masterkey,
md_cms.md_cms_gid as gid,
md_cms.md_cms_position as position,
md_cms.md_cms_parentid as parentid,
md_cms.md_cms_lastdate as lastdate,
md_cms.md_cms_credate as credate,
md_cms.md_cms_pic as piccms,
md_cms.md_cms_ismain as ismain,
md_cms_detail.md_cms_detail_id as contantid,
md_cms_detail.md_cms_detail_subject as subject,
md_cms_detail.md_cms_detail_title as title,
md_cms_detail.md_cms_detail_title_short as shorttitle,
md_cms_detail.md_cms_detail_pic as pic,
md_cms_detail.md_cms_detail_icon as icon,
md_cms_detail.md_cms_detail_url as url,
md_cms_detail.md_cms_detail_target as target,
md_cms_detail.md_cms_detail_htmlfilename as htmlfilename,
md_cms_detail.md_cms_detail_view as view,
md_cms_detail.md_cms_detail_metatitle as metatitle,
md_cms_detail.md_cms_detail_description as description,
md_cms_detail.md_cms_detail_keywords as keywords,
md_cms_detail.md_cms_detail_type as type,
md_cms_detail.md_cms_detail_btn_name as btn_name
FROM
md_cms
INNER JOIN
md_cms_detail
ON
md_cms_detail.md_cms_detail_contantid = md_cms.md_cms_id
WHERE
md_cms_detail.md_cms_detail_subject != '' AND
((md_cms_detail.md_cms_detail_sdate='0000-00-00 00:00:00' AND
md_cms_detail.md_cms_detail_edate='0000-00-00 00:00:00') OR
(md_cms_detail.md_cms_detail_sdate='0000-00-00 00:00:00' AND
TO_DAYS(md_cms_detail.md_cms_detail_edate)>=TO_DAYS(NOW()) ) OR
(TO_DAYS(md_cms_detail.md_cms_detail_sdate)<=TO_DAYS(NOW()) AND
md_cms_detail.md_cms_detail_edate='0000-00-00 00:00:00' ) OR
(TO_DAYS(md_cms_detail.md_cms_detail_sdate)<=TO_DAYS(NOW()) AND
TO_DAYS(md_cms_detail.md_cms_detail_edate)>=TO_DAYS(NOW()) ))
AND md_cms_site ='1' AND md_cms_detail_language ='en' AND md_cms.md_cms_status != 'Disable' AND md_cms.md_cms_masterkey = 'family' ORDER BY md_cms.md_cms_order DESC
