1 package com.teamkonzept.webman.mainint.db.queries.content; 2 3 import java.sql.Connection ; 4 import com.teamkonzept.db.*; 5 6 public class SelectDistinctFromSiteTreeContentTree extends TKPrepQuery 7 { 8 9 public final static boolean prepared = true; 10 11 public final static String [] order = 12 { 13 "LEFT_NR", "RIGHT_NR" 14 }; 15 16 public final static Object [][] types = null; 17 18 public final static boolean[] relevants = { true }; 19 20 public final static String sqlString = "SELECT DISTINCT ST.SITE_NODE_ID FROM SITE_TREE ST, CONTENT_TREE CT WHERE ST.PG_CONTENT_NODE = CT.CONTENT_NODE_ID AND CT.LEFT_NR >= ? AND CT.RIGHT_NR <= ?"; 21 22 public void initQuery(Connection con) { 23 super.initQuery( 24 con, 25 prepared, 26 order, 27 types, 28 relevants, 29 sqlString ); 30 } 31 32 } | Popular Tags |