StringBuffer sb = new StringBuffer("select t.id ,t.NAME,vendor_id,sort,longdesc ,VERSION ,os_id ,install_script,uninstall_script,status,create_time,G.NAME categoryname from"
+ " (SELECT A.ID,NAME,VENDOR_ID,SORT,LONGDESC,F.VERSION,F.OS_ID,INSTALL_SCRIPT,UNINSTALL_SCRIPT,F.STATUS,F.CREATE_TIME FROM APP A,APP_FILE F"
+ " where F.APP_ID=A.ID and $like(NAME,app_name) and $equal(A.ID,app_id) )t "
+ " LEFT JOIN category_app_rel c ON t.id = c.app_id LEFT JOIN category G ON c.c_id = G.id "
);
/*sb.append(" and $like(NAME,app_name)");
sb.append(" and $equal(A.ID,app_id)");*/
sb.append("order by t.CREATE_TIME DESC");
return db.getListResultByPage(bus, new SqlInfo(String.valueOf(sb)));
+ " (SELECT A.ID,NAME,VENDOR_ID,SORT,LONGDESC,F.VERSION,F.OS_ID,INSTALL_SCRIPT,UNINSTALL_SCRIPT,F.STATUS,F.CREATE_TIME FROM APP A,APP_FILE F"
+ " where F.APP_ID=A.ID and $like(NAME,app_name) and $equal(A.ID,app_id) )t "
+ " LEFT JOIN category_app_rel c ON t.id = c.app_id LEFT JOIN category G ON c.c_id = G.id "
);
/*sb.append(" and $like(NAME,app_name)");
sb.append(" and $equal(A.ID,app_id)");*/
sb.append("order by t.CREATE_TIME DESC");
return db.getListResultByPage(bus, new SqlInfo(String.valueOf(sb)));