Connection conn = connect();


		String tableName = "tmp_prodxy_" + System.currentTimeMillis();
		String sqlCreate = "create temporary table " + tableName + " (id bigint not null) ";
		String sqlAddIndex = "create index tmp_idx_" + tableName + " on " + tableName + "(id)";
		String sqlAddData = "insert into " + tableName + " values " + insertClause;
		String sqlQuery = "select distinct tfm.blogPostId, tfm.publishedDate " +
				"from TopicFilterMatch tfm join " + tableName + " tmp on tfm.blogPostId = tmp.id " +
				" where tfm.topicFilterId in (" + topicFilterList+ ") and tfm.postStatusId<1";
		String sqlDrop = "drop table " + tableName;
		
		System.out.println("PRODXY:" + tableName + "\n" + sqlCreate 
				 + "\n" + sqlAddIndex + "\n" + sqlAddData + "\n" + sqlQuery+ "\n" + sqlDrop);

		
		Statement stmt = null;
		ArrayList<Long> results = new ArrayList();
		ResultSet rs = null;
		int result = 0;
		try {
			
			stmt = conn.createStatement();
			stmt.execute(sqlCreate);
			stmt.close();
			stmt = conn.createStatement();
			stmt.execute(sqlAddIndex);
			stmt.close();
			
			stmt = conn.createStatement();
			rs = stmt.executeQuery(sqlQuery);

			
			while (rs.next()) {
				results.add(rs.getTimestamp("publishedDate").getTime());	
			}
			
			stmt.close();
			stmt = conn.createStatement();
			stmt.execute(sqlDrop);

		} catch (Exception e) {
			
			e.printStackTrace();
			
		}