4235   Select *pSub1;      /* Pointer to the rightmost select in sub-query */  in flattenSubquery()  local
4340     for(pSub1=pSub; pSub1; pSub1=pSub1->pPrior){  in flattenSubquery()
4341       testcase( (pSub1->selFlags & (SF_Distinct|SF_Aggregate))==SF_Distinct );  in flattenSubquery()
4342       testcase( (pSub1->selFlags & (SF_Distinct|SF_Aggregate))==SF_Aggregate );  in flattenSubquery()
4345       assert( pSub->pEList->nExpr==pSub1->pEList->nExpr );  in flattenSubquery()
4346       if( (pSub1->selFlags & (SF_Distinct|SF_Aggregate))!=0    /* (17b) */  in flattenSubquery()
4347        || (pSub1->pPrior && pSub1->op!=TK_ALL)                 /* (17a) */  in flattenSubquery()
4348        || pSub1->pSrc->nSrc<1                                  /* (17c) */  in flattenSubquery()
4350        || pSub1->pWin                                          /* (17e) */  in flattenSubquery()
4355       if( iFrom>0 && (pSub1->pSrc->a[0].fg.jointype & JT_LTORJ)!=0 ){  in flattenSubquery()
4361       testcase( pSub1->pSrc->nSrc>1 );  in flattenSubquery()
4379       for(pSub1=pSub->pPrior; pSub1; pSub1=pSub1->pPrior){  in flattenSubquery()
4380         assert( pSub1->pEList!=0 );  in flattenSubquery()
4381         assert( pSub1->pEList->nExpr>ii );  in flattenSubquery()
4382         assert( pSub1->pEList->a[ii].pExpr!=0 );  in flattenSubquery()
4383         if( sqlite3ExprAffinity(pSub1->pEList->a[ii].pExpr)!=aff ){  in flattenSubquery()
4408   pSub1 = pSubitem->pSelect;  in flattenSubquery()
4484     pSubitem->pSelect = pSub1;  in flattenSubquery()
4522   pSub = pSub1;  in flattenSubquery()
4653   sqlite3WalkSelect(&w,pSub1);  in flattenSubquery()
4654   sqlite3SelectDelete(db, pSub1);  in flattenSubquery()