public static PetitionList getPetitionListByCategory(int categoryID, String order, int start, int limit) throws ESellException{
					
					makeConnection();
			    	PreparedStatement preparedStatement = null;
			    	
			        if(conn != null)
			        {
			            try {
			            	//Statement vorbereiten
			                String sql = "SELECT * from petitions WHERE category_id = ? ORDER BY ? LIMIT ?, ?";
			                preparedStatement = conn.prepareStatement(sql);
			                
			                preparedStatement.setInt(1, categoryID);
			                preparedStatement.setString(2, order);
			                preparedStatement.setInt(3, start);
			                preparedStatement.setInt(4, limit);
			                
			                //Statement absetzen
			                ResultSet result = preparedStatement.executeQuery();
			                
			                ArrayList<Petition> petitionList = new ArrayList<Petition>();
			                
			                //Fr jeden Datensatz ein Objekt anlegen und in die Liste packen
			                while(result.next())
			                {
			                	Petition petition = new Petition(result);
			                	petitionList.add(petition);
			                }
			                
			                return new PetitionList(petitionList);
			            } catch (SQLException e) {
			                e.printStackTrace();
			                throw new ESellException(ESellException.ErrorCode.DB_ERR);
			            }
			        }
			        else
			        {
			        	throw new ESellException(ESellException.ErrorCode.DB_ERR);
			        }
				}