4233   Select *pParent;    /* Current UNION ALL term of the other query */  in flattenSubquery()  local
4523   for(pParent=p; pParent; pParent=pParent->pPrior, pSub=pSub->pPrior){  in flattenSubquery()
4530     pSrc = pParent->pSrc;     /* FROM clause of the outer query */  in flattenSubquery()
4532     if( pParent==p ){  in flattenSubquery()
4554       pParent->pSrc = pSrc;  in flattenSubquery()
4584     if( pSub->pOrderBy && (pParent->selFlags & SF_NoopOrderBy)==0 ){  in flattenSubquery()
4599       assert( pParent->pOrderBy==0 );  in flattenSubquery()
4600       pParent->pOrderBy = pOrderBy;  in flattenSubquery()
4609       if( pParent->pWhere ){  in flattenSubquery()
4610         pParent->pWhere = sqlite3PExpr(pParse, TK_AND, pWhere, pParent->pWhere);  in flattenSubquery()
4612         pParent->pWhere = pWhere;  in flattenSubquery()
4623       substSelect(&x, pParent, 0);  in flattenSubquery()
4628     pParent->selFlags |= pSub->selFlags & SF_Compound;  in flattenSubquery()
4638       pParent->pLimit = pSub->pLimit;  in flattenSubquery()
4645       recomputeColumnsUsed(pParent, &pSrc->a[i+iFrom]);  in flattenSubquery()