public static ArrayList<Productos> sqlSelectAtributos(Productos pro){
        ArrayList<Productos> prod = new ArrayList();
        String sql = "SELECT de.nombre, at.atributo " +
                        "FROM atributos at " +
                        "INNER JOIN cat_subcat_tit_attr_descr pr ON at.idatributos = pr.atributos_id " +
                        "INNER JOIN descripcion de ON de.iddescripcion = pr.descripcion_id " +
                        "WHERE 1=1 " +
                        "AND pr.categorias_id = '"+pro.getIdCat()+"' " +
                        "AND pr.subcategorias_id = '"+pro.getIdSubCat()+"' " +
                        "AND pr.titulo_id = '"+pro.getIdTitulo()+"'"
                        + " ORDER BY textarea ASC";
        if(!BD.getInstance().sqlSelect(sql)){
            return prod;
        }        
        while(BD.getInstance().sqlFetch()){
            prod.add(new Productos(BD.getInstance().getString("atributo")
                                        ,BD.getInstance().getString("nombre") ));
        }
        return prod;
    }