public ArrayList<Article> getUnpublishedArticle(int authorID) throws SQLException {
		ConnectionManager conn=null;
		ArrayList<Integer> intArtID = new ArrayList<Integer>();
		ArrayList<Integer> finalselectedArticleID = new  ArrayList<Integer>();
		ArrayList<Article> unpubArticle = new ArrayList<Article>();
		String queryArticle = "select ArticleAuthor.articleID from ArticleAuthor where ArticleAuthor.authorID =" + authorID;
		try {
			conn = new ConnectionManager();
			Statement st = conn.getInstance().getConnection().createStatement();
			ResultSet rs = st.executeQuery(queryArticle);
			while (rs.next()) {
				int  articleId=rs.getInt("ArticleAuthor.articleID");
				System.out.println("articleIDs aayi:"+articleId);
				intArtID.add(articleId);
			}
			System.out.println(intArtID);
			rs.close();
			for(int a: intArtID){
				Statement st1 = conn.getInstance().getConnection().createStatement();
				String selectQuery2 = "Select articleID from Article where articleID!="+a;
				ResultSet rs1 = st1.executeQuery(selectQuery2);
				while(rs1.next()){
					int  articleId=rs1.getInt("articleID");
					if(!intArtID.contains(articleId)){
						if(!finalselectedArticleID.contains(articleId)){
							finalselectedArticleID.add(articleId);
						}
					}
				}
			}
			System.out.println("Final ids:"+finalselectedArticleID);
			for(int autID : finalselectedArticleID  ){
				Statement st2 = conn.getInstance().getConnection().createStatement();
				String q = "select articleID, title, summary from Article where articleID="+autID;
				ResultSet rs2 = st2.executeQuery(q);
				while (rs2.next()) {
					String unpublishedTitle = (String) rs2.getObject("title");
					String unpublishedSummary = (String) rs2.getObject("summary");
					int  articeIde=rs2.getInt("articleID");
					Article article2 = new Article(articeIde, unpublishedTitle, unpublishedSummary);
					unpubArticle.add(article2);
				}
				System.out.println(unpubArticle);
				rs2.close();
				st2.close();
			}
			st.close();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			if (conn!=null){
				conn.close();
			}
		}
		return unpubArticle;
	}