<% response.setContentType("text/html;charset=UTF-8"); %> <%@ taglib uri="/tags/struts-html" prefix="html" %> <%@ taglib uri="http://java.sun.com/jstl/core" prefix="c" %> <%@ taglib uri="http://java.sun.com/jstl/sql" prefix="sql" %> <%@ page pageEncoding="euc-jp" %> select category_label ,category_id from mt_category ,mt_entry ,mt_placement main_placement where 1 = 1 and entry_id = placement_entry_id and placement_category_id = category_id and entry_created_on = ( select max(entry_created_on) from mt_entry ,mt_placement sub_placement where 1 = 1 and entry_id = sub_placement.placement_entry_id and sub_placement.placement_category_id = main_placement.placement_category_id ) order by entry_created_on desc megu's blog: Entries
select entry_id ,entry_title ,to_char(entry_created_on,'yyyy/mm/dd') as created_on from mt_entry ,mt_placement where entry_status = 2 and entry_id = placement_entry_id and placement_category_id = ? order by entry_created_on desc
Title Date
${categoryRow.category_label}
${entryRow.entry_title} ${entryRow.created_on}