-- name: get_plot_lists :manyWITH grouped_listsAS (SELECTl.id,l.name,l.created_at,        array_agg(p2l.cadastral_number)AS cadastral_numbersFROMpublic.plot_listsAS lLEFT JOINpublic.land_plot2plot_listAS p2lONl.id=p2l.plot_list_idGROUP BYl.id,l.name)SELECTgl.name,gl.cadastral_numbers,    (SELECTCOUNT(*)FROMpublic.plot_lists)AS totalFROM grouped_lists glORDER BYgl.created_atLIMIT @pagination_limit OFFSET (@page-1)* @pagination_limit;

asyncdefget_plot_lists(self,*,-page:Optional[Any],pagination_limit:int)->AsyncIterator[get_plot_listsRow]:result=awaitself._conn.stream(sqlalchemy.text(GET_PLOT_LISTS), {"p1":-page,"p2":pagination_limit})asyncforrowinresult:yieldget_plot_listsRow(name=row[0],cadastral_numbers=row[1],total=row[2],        )