| SQL |
select header_code,depth,friendly_url,friendly_path,enclosure,shop_narrowby,shop_price_range,link_sort_order,link_image_hover,link_image_standard,linkimage,published_end_date,published_start_date,published,cache_page,private_content_redirect_document_id,document_text_blocks,document_text_mobile,content_id,indexentry,page_category,crosssite_content,page_plugins,page_scripts,user_security,page_descrption,disclaimer_docid,title_language_code,language_code,title_label,sidemenu_top_docid,sidemenu_bottom_docid,haschildren,secure_areas,calendar_category,link_to_form,description,title,document_text,cart_options,cart_query,photoalbum,related_document_id,page_banner,linked_form_label,form_responder_document_id,page_margin,private_content,private_content_svrproduct,document_id,hidepanel,content_location,parent_title,downloads,allowindex,removeformatting,parent_id,location,config_settings,custom_variables,shop_category_link,page_bgcolor,page_style,live_version from
p_portal
where
document_id='14586'
and published='Y'
and (published_start_date is null or ( published_start_date<={d '2020-07-15'} and published_end_date>={d '2020-07-15'} )) |