posStart = 
count = 

				select 
					O.*, 
					A.Nome     as NomeAgente, 
					C.Nome     as NomeCliente, 
					F.Nome     as NomeFornitore,
					F.IdFornitori, 
					P.modalita as ModalitaPagamenti,
					AVO.AmmontareOrdineConIva
			from 
					ordini O
						inner join clienti   C on C.idclienti   = O.idcliente
						inner join fornitori F on F.idfornitori = O.idfornitore 
						inner join pagamenti P on P.idpagamenti = O.idpagamento
						inner join agenti    A on A.idagenti    = O.idagente
					  inner join AmmontareVariOrdini AVO on AVO.IdOrdine = O.IdOrdini
                                              and AVO.Anno = 2021
			where
          O.Anno = 2021 and
					(O.numfattura = 0 or O.numfattura is null) and
					1=1
			order by 
					O.IdOrdini ASC
						 
<rows total_count='29' rowStart=''>

<row id='11'><cell>11</cell><cell>Enewine di Ammanati Nicola</cell><cell>Azienda Agricola Bruni</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>467,48</cell><cell></cell><cell></cell><cell>0,00</cell></row>
<row id='17'><cell>17</cell><cell>Enewine di Ammanati Nicola</cell><cell>Azienda Agricola Tercic Matijaz</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>452,01</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='47'><cell>47</cell><cell>Papaveri e Papere srl</cell><cell>Tenuta Le Potazzine srl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>761,28</cell><cell></cell><cell></cell><cell>0,00</cell></row>
<row id='66'><cell>66</cell><cell>Ristorante Osteria della Pieve di Cerri Simone &amp; C snc</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>535,82</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='70'><cell>70</cell><cell>Enewine di Ammanati Nicola</cell><cell>Azienda Agricola Ghiga Enrico</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>360,77</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='87'><cell>87</cell><cell>Osteria da Cencio</cell><cell>Società Agricola Fattori di Fattori Giovanni ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>445,06</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='92'><cell>92</cell><cell>Cioccolato Argento di Di Bello Paola</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>283,28</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='97'><cell>97</cell><cell>La Bottega di Papacqua di Mannari Dario</cell><cell>Tenuta Iuzzolini sarl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>219,01</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='100'><cell>100</cell><cell>La Bufala Mozzarella Bistrot</cell><cell>Tenuta Iuzzolini sarl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>197,64</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='112'><cell>112</cell><cell>Osteria  del Contadino di Gastaldin Tommaso</cell><cell>Pojer e Sandri di Sandri Fiorentino &amp; C soc. agr. s.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>402,60</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='115'><cell>115</cell><cell>House Caf� di Voliani Martina</cell><cell>Maglio Arte Dolciaria Srl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>823,90</cell><cell></cell><cell></cell><cell>0,00</cell></row>
<row id='116'><cell>116</cell><cell>RO. BRES. snc di Rossini S. e Breschi MC.</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>338,92</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='119'><cell>119</cell><cell>Tutte Le Direzioni s.a.s di Vettori Mirco e C.</cell><cell>Fattoria Montellori S.S.A.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>541,68</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='122'><cell>122</cell><cell>Osteria da Cencio</cell><cell>Società Agricola La Fiorita di Bono Giancarla e Stefano S.S.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>272,30</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='125'><cell>125</cell><cell>Cia snc</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>732,00</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='127'><cell>127</cell><cell>San Domenico Italian Bistr� di Ipsaro Passione Salvatore</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>245,22</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='128'><cell>128</cell><cell>Enoteca Vicolo DiVino di M. De Prosperis</cell><cell>Tenuta Iuzzolini sarl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>416,14</cell><cell></cell><cell></cell><cell>0,00</cell></row>
<row id='133'><cell>133</cell><cell>G. &amp; G. sas di D&#039;Angelo G. e C.</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>438,10</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='134'><cell>134</cell><cell>Papaveri e Papere srl</cell><cell>Fattoria Montellori S.S.A.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>263,52</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='135'><cell>135</cell><cell>Papaveri e Papere srl</cell><cell>Pojer e Sandri di Sandri Fiorentino &amp; C soc. agr. s.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>557,35</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='139'><cell>139</cell><cell>Oyster srl</cell><cell>Maglio Arte Dolciaria Srl</cell><cell>Curcio Fabrizio</cell><cell>20/10/2021</cell><cell>1.121,78</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='154'><cell>154</cell><cell>Osteria Micheletti di M &amp; P srls</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>333,10</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='157'><cell>157</cell><cell>Gherarvini di Gherardini Matteo</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>615,43</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='158'><cell>158</cell><cell>Gherarvini di Gherardini Matteo</cell><cell>Pitars snc di Pittaro Paolo e f.lli Società Agricola</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>360,37</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='159'><cell>159</cell><cell>Gherarvini di Gherardini Matteo</cell><cell>Antica Distilleria Domenico Sibona S.p.A.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>465,55</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='160'><cell>160</cell><cell>La Pizzicagnola di Pardini F. e Pavolini G. snc</cell><cell>Pojer e Sandri di Sandri Fiorentino &amp; C soc. agr. s.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>273,36</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='161'><cell>161</cell><cell>Casa-Market srl</cell><cell>Fattoria Montellori S.S.A.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>555,76</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='162'><cell>162</cell><cell>Enoteca Vicolo DiVino di M. De Prosperis</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>803,19</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='164'><cell>164</cell><cell>A &amp; P Srl</cell><cell>Azienda Agricola Bruni</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>139,08</cell><cell></cell><cell>17/10/2021</cell><cell>0,00</cell></row>posStart = 
count = 

				select 
					O.*, 
					A.Nome     as NomeAgente, 
					C.Nome     as NomeCliente, 
					F.Nome     as NomeFornitore,
					F.IdFornitori, 
					P.modalita as ModalitaPagamenti,
					AVO.AmmontareOrdineConIva
			from 
					ordini O
						inner join clienti   C on C.idclienti   = O.idcliente
						inner join fornitori F on F.idfornitori = O.idfornitore 
						inner join pagamenti P on P.idpagamenti = O.idpagamento
						inner join agenti    A on A.idagenti    = O.idagente
					  inner join AmmontareVariOrdini AVO on AVO.IdOrdine = O.IdOrdini
                                              and AVO.Anno = 2021
			where
          O.Anno = 2021 and
					(O.numfattura = 0 or O.numfattura is null) and
					1=1
			order by 
					O.IdOrdini ASC
						 
<rows total_count='29' rowStart=''>

<row id='11'><cell>11</cell><cell>Enewine di Ammanati Nicola</cell><cell>Azienda Agricola Bruni</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>467,48</cell><cell></cell><cell></cell><cell>0,00</cell></row>
<row id='17'><cell>17</cell><cell>Enewine di Ammanati Nicola</cell><cell>Azienda Agricola Tercic Matijaz</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>452,01</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='47'><cell>47</cell><cell>Papaveri e Papere srl</cell><cell>Tenuta Le Potazzine srl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>761,28</cell><cell></cell><cell></cell><cell>0,00</cell></row>
<row id='66'><cell>66</cell><cell>Ristorante Osteria della Pieve di Cerri Simone &amp; C snc</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>535,82</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='70'><cell>70</cell><cell>Enewine di Ammanati Nicola</cell><cell>Azienda Agricola Ghiga Enrico</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>360,77</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='87'><cell>87</cell><cell>Osteria da Cencio</cell><cell>Società Agricola Fattori di Fattori Giovanni ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>445,06</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='92'><cell>92</cell><cell>Cioccolato Argento di Di Bello Paola</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>283,28</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='97'><cell>97</cell><cell>La Bottega di Papacqua di Mannari Dario</cell><cell>Tenuta Iuzzolini sarl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>219,01</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='100'><cell>100</cell><cell>La Bufala Mozzarella Bistrot</cell><cell>Tenuta Iuzzolini sarl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>197,64</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='112'><cell>112</cell><cell>Osteria  del Contadino di Gastaldin Tommaso</cell><cell>Pojer e Sandri di Sandri Fiorentino &amp; C soc. agr. s.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>402,60</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='115'><cell>115</cell><cell>House Caf� di Voliani Martina</cell><cell>Maglio Arte Dolciaria Srl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>823,90</cell><cell></cell><cell></cell><cell>0,00</cell></row>
<row id='116'><cell>116</cell><cell>RO. BRES. snc di Rossini S. e Breschi MC.</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>338,92</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='119'><cell>119</cell><cell>Tutte Le Direzioni s.a.s di Vettori Mirco e C.</cell><cell>Fattoria Montellori S.S.A.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>541,68</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='122'><cell>122</cell><cell>Osteria da Cencio</cell><cell>Società Agricola La Fiorita di Bono Giancarla e Stefano S.S.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>272,30</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='125'><cell>125</cell><cell>Cia snc</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>732,00</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='127'><cell>127</cell><cell>San Domenico Italian Bistr� di Ipsaro Passione Salvatore</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>245,22</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='128'><cell>128</cell><cell>Enoteca Vicolo DiVino di M. De Prosperis</cell><cell>Tenuta Iuzzolini sarl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>416,14</cell><cell></cell><cell></cell><cell>0,00</cell></row>
<row id='133'><cell>133</cell><cell>G. &amp; G. sas di D&#039;Angelo G. e C.</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>438,10</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='134'><cell>134</cell><cell>Papaveri e Papere srl</cell><cell>Fattoria Montellori S.S.A.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>263,52</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='135'><cell>135</cell><cell>Papaveri e Papere srl</cell><cell>Pojer e Sandri di Sandri Fiorentino &amp; C soc. agr. s.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>557,35</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='139'><cell>139</cell><cell>Oyster srl</cell><cell>Maglio Arte Dolciaria Srl</cell><cell>Curcio Fabrizio</cell><cell>20/10/2021</cell><cell>1.121,78</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='154'><cell>154</cell><cell>Osteria Micheletti di M &amp; P srls</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>333,10</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='157'><cell>157</cell><cell>Gherarvini di Gherardini Matteo</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>615,43</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='158'><cell>158</cell><cell>Gherarvini di Gherardini Matteo</cell><cell>Pitars snc di Pittaro Paolo e f.lli Società Agricola</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>360,37</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='159'><cell>159</cell><cell>Gherarvini di Gherardini Matteo</cell><cell>Antica Distilleria Domenico Sibona S.p.A.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>465,55</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='160'><cell>160</cell><cell>La Pizzicagnola di Pardini F. e Pavolini G. snc</cell><cell>Pojer e Sandri di Sandri Fiorentino &amp; C soc. agr. s.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>273,36</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='161'><cell>161</cell><cell>Casa-Market srl</cell><cell>Fattoria Montellori S.S.A.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>555,76</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='162'><cell>162</cell><cell>Enoteca Vicolo DiVino di M. De Prosperis</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>803,19</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='164'><cell>164</cell><cell>A &amp; P Srl</cell><cell>Azienda Agricola Bruni</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>139,08</cell><cell></cell><cell>17/10/2021</cell><cell>0,00</cell></row>posStart = 
count = 

				select 
					O.*, 
					A.Nome     as NomeAgente, 
					C.Nome     as NomeCliente, 
					F.Nome     as NomeFornitore,
					F.IdFornitori, 
					P.modalita as ModalitaPagamenti,
					AVO.AmmontareOrdineConIva
			from 
					ordini O
						inner join clienti   C on C.idclienti   = O.idcliente
						inner join fornitori F on F.idfornitori = O.idfornitore 
						inner join pagamenti P on P.idpagamenti = O.idpagamento
						inner join agenti    A on A.idagenti    = O.idagente
					  inner join AmmontareVariOrdini AVO on AVO.IdOrdine = O.IdOrdini
                                              and AVO.Anno = 2021
			where
          O.Anno = 2021 and
					(O.numfattura = 0 or O.numfattura is null) and
					1=1
			order by 
					O.IdOrdini ASC
						 
<rows total_count='29' rowStart=''>

<row id='11'><cell>11</cell><cell>Enewine di Ammanati Nicola</cell><cell>Azienda Agricola Bruni</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>467,48</cell><cell></cell><cell></cell><cell>0,00</cell></row>
<row id='17'><cell>17</cell><cell>Enewine di Ammanati Nicola</cell><cell>Azienda Agricola Tercic Matijaz</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>452,01</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='47'><cell>47</cell><cell>Papaveri e Papere srl</cell><cell>Tenuta Le Potazzine srl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>761,28</cell><cell></cell><cell></cell><cell>0,00</cell></row>
<row id='66'><cell>66</cell><cell>Ristorante Osteria della Pieve di Cerri Simone &amp; C snc</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>535,82</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='70'><cell>70</cell><cell>Enewine di Ammanati Nicola</cell><cell>Azienda Agricola Ghiga Enrico</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>360,77</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='87'><cell>87</cell><cell>Osteria da Cencio</cell><cell>Società Agricola Fattori di Fattori Giovanni ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>445,06</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='92'><cell>92</cell><cell>Cioccolato Argento di Di Bello Paola</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>283,28</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='97'><cell>97</cell><cell>La Bottega di Papacqua di Mannari Dario</cell><cell>Tenuta Iuzzolini sarl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>219,01</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='100'><cell>100</cell><cell>La Bufala Mozzarella Bistrot</cell><cell>Tenuta Iuzzolini sarl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>197,64</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='112'><cell>112</cell><cell>Osteria  del Contadino di Gastaldin Tommaso</cell><cell>Pojer e Sandri di Sandri Fiorentino &amp; C soc. agr. s.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>402,60</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='115'><cell>115</cell><cell>House Caf� di Voliani Martina</cell><cell>Maglio Arte Dolciaria Srl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>823,90</cell><cell></cell><cell></cell><cell>0,00</cell></row>
<row id='116'><cell>116</cell><cell>RO. BRES. snc di Rossini S. e Breschi MC.</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>338,92</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='119'><cell>119</cell><cell>Tutte Le Direzioni s.a.s di Vettori Mirco e C.</cell><cell>Fattoria Montellori S.S.A.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>541,68</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='122'><cell>122</cell><cell>Osteria da Cencio</cell><cell>Società Agricola La Fiorita di Bono Giancarla e Stefano S.S.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>272,30</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='125'><cell>125</cell><cell>Cia snc</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>732,00</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='127'><cell>127</cell><cell>San Domenico Italian Bistr� di Ipsaro Passione Salvatore</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>245,22</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='128'><cell>128</cell><cell>Enoteca Vicolo DiVino di M. De Prosperis</cell><cell>Tenuta Iuzzolini sarl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>416,14</cell><cell></cell><cell></cell><cell>0,00</cell></row>
<row id='133'><cell>133</cell><cell>G. &amp; G. sas di D&#039;Angelo G. e C.</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>438,10</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='134'><cell>134</cell><cell>Papaveri e Papere srl</cell><cell>Fattoria Montellori S.S.A.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>263,52</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='135'><cell>135</cell><cell>Papaveri e Papere srl</cell><cell>Pojer e Sandri di Sandri Fiorentino &amp; C soc. agr. s.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>557,35</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='139'><cell>139</cell><cell>Oyster srl</cell><cell>Maglio Arte Dolciaria Srl</cell><cell>Curcio Fabrizio</cell><cell>20/10/2021</cell><cell>1.121,78</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='154'><cell>154</cell><cell>Osteria Micheletti di M &amp; P srls</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>333,10</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='157'><cell>157</cell><cell>Gherarvini di Gherardini Matteo</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>615,43</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='158'><cell>158</cell><cell>Gherarvini di Gherardini Matteo</cell><cell>Pitars snc di Pittaro Paolo e f.lli Società Agricola</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>360,37</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='159'><cell>159</cell><cell>Gherarvini di Gherardini Matteo</cell><cell>Antica Distilleria Domenico Sibona S.p.A.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>465,55</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='160'><cell>160</cell><cell>La Pizzicagnola di Pardini F. e Pavolini G. snc</cell><cell>Pojer e Sandri di Sandri Fiorentino &amp; C soc. agr. s.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>273,36</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='161'><cell>161</cell><cell>Casa-Market srl</cell><cell>Fattoria Montellori S.S.A.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>555,76</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='162'><cell>162</cell><cell>Enoteca Vicolo DiVino di M. De Prosperis</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>803,19</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='164'><cell>164</cell><cell>A &amp; P Srl</cell><cell>Azienda Agricola Bruni</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>139,08</cell><cell></cell><cell>17/10/2021</cell><cell>0,00</cell></row>posStart = 
count = 

				select 
					O.*, 
					A.Nome     as NomeAgente, 
					C.Nome     as NomeCliente, 
					F.Nome     as NomeFornitore,
					F.IdFornitori, 
					P.modalita as ModalitaPagamenti,
					AVO.AmmontareOrdineConIva
			from 
					ordini O
						inner join clienti   C on C.idclienti   = O.idcliente
						inner join fornitori F on F.idfornitori = O.idfornitore 
						inner join pagamenti P on P.idpagamenti = O.idpagamento
						inner join agenti    A on A.idagenti    = O.idagente
					  inner join AmmontareVariOrdini AVO on AVO.IdOrdine = O.IdOrdini
                                              and AVO.Anno = 2021
			where
          O.Anno = 2021 and
					(O.numfattura = 0 or O.numfattura is null) and
					1=1
			order by 
					C.Nome ASC, O.IdOrdini ASC
						 
<rows total_count='29' rowStart=''>

<row id='164'><cell>164</cell><cell>A &amp; P Srl</cell><cell>Azienda Agricola Bruni</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>139,08</cell><cell></cell><cell>17/10/2021</cell><cell>0,00</cell></row>
<row id='161'><cell>161</cell><cell>Casa-Market srl</cell><cell>Fattoria Montellori S.S.A.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>555,76</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='125'><cell>125</cell><cell>Cia snc</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>732,00</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='92'><cell>92</cell><cell>Cioccolato Argento di Di Bello Paola</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>283,28</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='11'><cell>11</cell><cell>Enewine di Ammanati Nicola</cell><cell>Azienda Agricola Bruni</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>467,48</cell><cell></cell><cell></cell><cell>0,00</cell></row>
<row id='17'><cell>17</cell><cell>Enewine di Ammanati Nicola</cell><cell>Azienda Agricola Tercic Matijaz</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>452,01</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='70'><cell>70</cell><cell>Enewine di Ammanati Nicola</cell><cell>Azienda Agricola Ghiga Enrico</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>360,77</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='128'><cell>128</cell><cell>Enoteca Vicolo DiVino di M. De Prosperis</cell><cell>Tenuta Iuzzolini sarl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>416,14</cell><cell></cell><cell></cell><cell>0,00</cell></row>
<row id='162'><cell>162</cell><cell>Enoteca Vicolo DiVino di M. De Prosperis</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>803,19</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='133'><cell>133</cell><cell>G. &amp; G. sas di D&#039;Angelo G. e C.</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>438,10</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='157'><cell>157</cell><cell>Gherarvini di Gherardini Matteo</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>615,43</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='158'><cell>158</cell><cell>Gherarvini di Gherardini Matteo</cell><cell>Pitars snc di Pittaro Paolo e f.lli Società Agricola</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>360,37</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='159'><cell>159</cell><cell>Gherarvini di Gherardini Matteo</cell><cell>Antica Distilleria Domenico Sibona S.p.A.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>465,55</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='115'><cell>115</cell><cell>House Caf� di Voliani Martina</cell><cell>Maglio Arte Dolciaria Srl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>823,90</cell><cell></cell><cell></cell><cell>0,00</cell></row>
<row id='97'><cell>97</cell><cell>La Bottega di Papacqua di Mannari Dario</cell><cell>Tenuta Iuzzolini sarl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>219,01</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='100'><cell>100</cell><cell>La Bufala Mozzarella Bistrot</cell><cell>Tenuta Iuzzolini sarl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>197,64</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='160'><cell>160</cell><cell>La Pizzicagnola di Pardini F. e Pavolini G. snc</cell><cell>Pojer e Sandri di Sandri Fiorentino &amp; C soc. agr. s.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>273,36</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='112'><cell>112</cell><cell>Osteria  del Contadino di Gastaldin Tommaso</cell><cell>Pojer e Sandri di Sandri Fiorentino &amp; C soc. agr. s.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>402,60</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='87'><cell>87</cell><cell>Osteria da Cencio</cell><cell>Società Agricola Fattori di Fattori Giovanni ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>445,06</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='122'><cell>122</cell><cell>Osteria da Cencio</cell><cell>Società Agricola La Fiorita di Bono Giancarla e Stefano S.S.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>272,30</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='154'><cell>154</cell><cell>Osteria Micheletti di M &amp; P srls</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>333,10</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='139'><cell>139</cell><cell>Oyster srl</cell><cell>Maglio Arte Dolciaria Srl</cell><cell>Curcio Fabrizio</cell><cell>20/10/2021</cell><cell>1.121,78</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='47'><cell>47</cell><cell>Papaveri e Papere srl</cell><cell>Tenuta Le Potazzine srl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>761,28</cell><cell></cell><cell></cell><cell>0,00</cell></row>
<row id='134'><cell>134</cell><cell>Papaveri e Papere srl</cell><cell>Fattoria Montellori S.S.A.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>263,52</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='135'><cell>135</cell><cell>Papaveri e Papere srl</cell><cell>Pojer e Sandri di Sandri Fiorentino &amp; C soc. agr. s.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>557,35</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='66'><cell>66</cell><cell>Ristorante Osteria della Pieve di Cerri Simone &amp; C snc</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>535,82</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='116'><cell>116</cell><cell>RO. BRES. snc di Rossini S. e Breschi MC.</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>338,92</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='127'><cell>127</cell><cell>San Domenico Italian Bistr� di Ipsaro Passione Salvatore</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>245,22</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='119'><cell>119</cell><cell>Tutte Le Direzioni s.a.s di Vettori Mirco e C.</cell><cell>Fattoria Montellori S.S.A.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>541,68</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>posStart = 
count = 

				select 
					O.*, 
					A.Nome     as NomeAgente, 
					C.Nome     as NomeCliente, 
					F.Nome     as NomeFornitore,
					F.IdFornitori, 
					P.modalita as ModalitaPagamenti,
					AVO.AmmontareOrdineConIva
			from 
					ordini O
						inner join clienti   C on C.idclienti   = O.idcliente
						inner join fornitori F on F.idfornitori = O.idfornitore 
						inner join pagamenti P on P.idpagamenti = O.idpagamento
						inner join agenti    A on A.idagenti    = O.idagente
					  inner join AmmontareVariOrdini AVO on AVO.IdOrdine = O.IdOrdini
                                              and AVO.Anno = 2021
			where
          O.Anno = 2021 and
					(O.numfattura = 0 or O.numfattura is null) and
					1=1
			order by 
					C.Nome ASC, O.IdOrdini ASC
						 
<rows total_count='29' rowStart=''>

<row id='164'><cell>164</cell><cell>A &amp; P Srl</cell><cell>Azienda Agricola Bruni</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>139,08</cell><cell></cell><cell>17/10/2021</cell><cell>0,00</cell></row>
<row id='161'><cell>161</cell><cell>Casa-Market srl</cell><cell>Fattoria Montellori S.S.A.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>555,76</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='125'><cell>125</cell><cell>Cia snc</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>732,00</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='92'><cell>92</cell><cell>Cioccolato Argento di Di Bello Paola</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>283,28</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='11'><cell>11</cell><cell>Enewine di Ammanati Nicola</cell><cell>Azienda Agricola Bruni</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>467,48</cell><cell></cell><cell></cell><cell>0,00</cell></row>
<row id='17'><cell>17</cell><cell>Enewine di Ammanati Nicola</cell><cell>Azienda Agricola Tercic Matijaz</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>452,01</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='70'><cell>70</cell><cell>Enewine di Ammanati Nicola</cell><cell>Azienda Agricola Ghiga Enrico</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>360,77</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='128'><cell>128</cell><cell>Enoteca Vicolo DiVino di M. De Prosperis</cell><cell>Tenuta Iuzzolini sarl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>416,14</cell><cell></cell><cell></cell><cell>0,00</cell></row>
<row id='162'><cell>162</cell><cell>Enoteca Vicolo DiVino di M. De Prosperis</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>803,19</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='133'><cell>133</cell><cell>G. &amp; G. sas di D&#039;Angelo G. e C.</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>438,10</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='157'><cell>157</cell><cell>Gherarvini di Gherardini Matteo</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>615,43</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='158'><cell>158</cell><cell>Gherarvini di Gherardini Matteo</cell><cell>Pitars snc di Pittaro Paolo e f.lli Società Agricola</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>360,37</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='159'><cell>159</cell><cell>Gherarvini di Gherardini Matteo</cell><cell>Antica Distilleria Domenico Sibona S.p.A.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>465,55</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='115'><cell>115</cell><cell>House Caf� di Voliani Martina</cell><cell>Maglio Arte Dolciaria Srl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>823,90</cell><cell></cell><cell></cell><cell>0,00</cell></row>
<row id='97'><cell>97</cell><cell>La Bottega di Papacqua di Mannari Dario</cell><cell>Tenuta Iuzzolini sarl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>219,01</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='100'><cell>100</cell><cell>La Bufala Mozzarella Bistrot</cell><cell>Tenuta Iuzzolini sarl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>197,64</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='160'><cell>160</cell><cell>La Pizzicagnola di Pardini F. e Pavolini G. snc</cell><cell>Pojer e Sandri di Sandri Fiorentino &amp; C soc. agr. s.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>273,36</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='112'><cell>112</cell><cell>Osteria  del Contadino di Gastaldin Tommaso</cell><cell>Pojer e Sandri di Sandri Fiorentino &amp; C soc. agr. s.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>402,60</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='87'><cell>87</cell><cell>Osteria da Cencio</cell><cell>Società Agricola Fattori di Fattori Giovanni ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>445,06</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='122'><cell>122</cell><cell>Osteria da Cencio</cell><cell>Società Agricola La Fiorita di Bono Giancarla e Stefano S.S.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>272,30</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='154'><cell>154</cell><cell>Osteria Micheletti di M &amp; P srls</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>333,10</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='139'><cell>139</cell><cell>Oyster srl</cell><cell>Maglio Arte Dolciaria Srl</cell><cell>Curcio Fabrizio</cell><cell>20/10/2021</cell><cell>1.121,78</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='47'><cell>47</cell><cell>Papaveri e Papere srl</cell><cell>Tenuta Le Potazzine srl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>761,28</cell><cell></cell><cell></cell><cell>0,00</cell></row>
<row id='134'><cell>134</cell><cell>Papaveri e Papere srl</cell><cell>Fattoria Montellori S.S.A.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>263,52</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='135'><cell>135</cell><cell>Papaveri e Papere srl</cell><cell>Pojer e Sandri di Sandri Fiorentino &amp; C soc. agr. s.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>557,35</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='66'><cell>66</cell><cell>Ristorante Osteria della Pieve di Cerri Simone &amp; C snc</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>535,82</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='116'><cell>116</cell><cell>RO. BRES. snc di Rossini S. e Breschi MC.</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>338,92</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='127'><cell>127</cell><cell>San Domenico Italian Bistr� di Ipsaro Passione Salvatore</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>245,22</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='119'><cell>119</cell><cell>Tutte Le Direzioni s.a.s di Vettori Mirco e C.</cell><cell>Fattoria Montellori S.S.A.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>541,68</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>posStart = 
count = 

				select 
					O.*, 
					A.Nome     as NomeAgente, 
					C.Nome     as NomeCliente, 
					F.Nome     as NomeFornitore,
					F.IdFornitori, 
					P.modalita as ModalitaPagamenti,
					AVO.AmmontareOrdineConIva
			from 
					ordini O
						inner join clienti   C on C.idclienti   = O.idcliente
						inner join fornitori F on F.idfornitori = O.idfornitore 
						inner join pagamenti P on P.idpagamenti = O.idpagamento
						inner join agenti    A on A.idagenti    = O.idagente
					  inner join AmmontareVariOrdini AVO on AVO.IdOrdine = O.IdOrdini
                                              and AVO.Anno = 2021
			where
          O.Anno = 2021 and
					(O.numfattura = 0 or O.numfattura is null) and
					1=1
			order by 
					O.IdOrdini ASC
						 
<rows total_count='29' rowStart=''>

<row id='11'><cell>11</cell><cell>Enewine di Ammanati Nicola</cell><cell>Azienda Agricola Bruni</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>467,48</cell><cell></cell><cell></cell><cell>0,00</cell></row>
<row id='17'><cell>17</cell><cell>Enewine di Ammanati Nicola</cell><cell>Azienda Agricola Tercic Matijaz</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>452,01</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='47'><cell>47</cell><cell>Papaveri e Papere srl</cell><cell>Tenuta Le Potazzine srl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>761,28</cell><cell></cell><cell></cell><cell>0,00</cell></row>
<row id='66'><cell>66</cell><cell>Ristorante Osteria della Pieve di Cerri Simone &amp; C snc</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>535,82</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='70'><cell>70</cell><cell>Enewine di Ammanati Nicola</cell><cell>Azienda Agricola Ghiga Enrico</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>360,77</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='87'><cell>87</cell><cell>Osteria da Cencio</cell><cell>Società Agricola Fattori di Fattori Giovanni ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>445,06</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='92'><cell>92</cell><cell>Cioccolato Argento di Di Bello Paola</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>283,28</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='97'><cell>97</cell><cell>La Bottega di Papacqua di Mannari Dario</cell><cell>Tenuta Iuzzolini sarl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>219,01</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='100'><cell>100</cell><cell>La Bufala Mozzarella Bistrot</cell><cell>Tenuta Iuzzolini sarl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>197,64</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='112'><cell>112</cell><cell>Osteria  del Contadino di Gastaldin Tommaso</cell><cell>Pojer e Sandri di Sandri Fiorentino &amp; C soc. agr. s.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>402,60</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='115'><cell>115</cell><cell>House Caf� di Voliani Martina</cell><cell>Maglio Arte Dolciaria Srl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>823,90</cell><cell></cell><cell></cell><cell>0,00</cell></row>
<row id='116'><cell>116</cell><cell>RO. BRES. snc di Rossini S. e Breschi MC.</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>338,92</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='119'><cell>119</cell><cell>Tutte Le Direzioni s.a.s di Vettori Mirco e C.</cell><cell>Fattoria Montellori S.S.A.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>541,68</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='122'><cell>122</cell><cell>Osteria da Cencio</cell><cell>Società Agricola La Fiorita di Bono Giancarla e Stefano S.S.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>272,30</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='125'><cell>125</cell><cell>Cia snc</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>732,00</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='127'><cell>127</cell><cell>San Domenico Italian Bistr� di Ipsaro Passione Salvatore</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>245,22</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='128'><cell>128</cell><cell>Enoteca Vicolo DiVino di M. De Prosperis</cell><cell>Tenuta Iuzzolini sarl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>416,14</cell><cell></cell><cell></cell><cell>0,00</cell></row>
<row id='133'><cell>133</cell><cell>G. &amp; G. sas di D&#039;Angelo G. e C.</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>438,10</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='134'><cell>134</cell><cell>Papaveri e Papere srl</cell><cell>Fattoria Montellori S.S.A.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>263,52</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='135'><cell>135</cell><cell>Papaveri e Papere srl</cell><cell>Pojer e Sandri di Sandri Fiorentino &amp; C soc. agr. s.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>557,35</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='139'><cell>139</cell><cell>Oyster srl</cell><cell>Maglio Arte Dolciaria Srl</cell><cell>Curcio Fabrizio</cell><cell>20/10/2021</cell><cell>1.121,78</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='154'><cell>154</cell><cell>Osteria Micheletti di M &amp; P srls</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>333,10</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='157'><cell>157</cell><cell>Gherarvini di Gherardini Matteo</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>615,43</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='158'><cell>158</cell><cell>Gherarvini di Gherardini Matteo</cell><cell>Pitars snc di Pittaro Paolo e f.lli Società Agricola</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>360,37</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='159'><cell>159</cell><cell>Gherarvini di Gherardini Matteo</cell><cell>Antica Distilleria Domenico Sibona S.p.A.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>465,55</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='160'><cell>160</cell><cell>La Pizzicagnola di Pardini F. e Pavolini G. snc</cell><cell>Pojer e Sandri di Sandri Fiorentino &amp; C soc. agr. s.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>273,36</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='161'><cell>161</cell><cell>Casa-Market srl</cell><cell>Fattoria Montellori S.S.A.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>555,76</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='162'><cell>162</cell><cell>Enoteca Vicolo DiVino di M. De Prosperis</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>803,19</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='164'><cell>164</cell><cell>A &amp; P Srl</cell><cell>Azienda Agricola Bruni</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>139,08</cell><cell></cell><cell>17/10/2021</cell><cell>0,00</cell></row>posStart = 
count = 

				select 
					O.*, 
					A.Nome     as NomeAgente, 
					C.Nome     as NomeCliente, 
					F.Nome     as NomeFornitore,
					F.IdFornitori, 
					P.modalita as ModalitaPagamenti,
					AVO.AmmontareOrdineConIva
			from 
					ordini O
						inner join clienti   C on C.idclienti   = O.idcliente
						inner join fornitori F on F.idfornitori = O.idfornitore 
						inner join pagamenti P on P.idpagamenti = O.idpagamento
						inner join agenti    A on A.idagenti    = O.idagente
					  inner join AmmontareVariOrdini AVO on AVO.IdOrdine = O.IdOrdini
                                              and AVO.Anno = 2022
			where
          O.Anno = 2022 and
					(O.numfattura = 0 or O.numfattura is null) and
					1=1
			order by 
					O.IdOrdini ASC
						 
<rows total_count='1' rowStart=''>

<row id='2'><cell>2</cell><cell>Baccarossa di Cappelli Grazia</cell><cell>Antica Distilleria Domenico Sibona S.p.A.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>880,74</cell><cell></cell><cell></cell><cell>0,00</cell></row>posStart = 
count = 

				select 
					O.*, 
					A.Nome     as NomeAgente, 
					C.Nome     as NomeCliente, 
					F.Nome     as NomeFornitore,
					F.IdFornitori, 
					P.modalita as ModalitaPagamenti,
					AVO.AmmontareOrdineConIva
			from 
					ordini O
						inner join clienti   C on C.idclienti   = O.idcliente
						inner join fornitori F on F.idfornitori = O.idfornitore 
						inner join pagamenti P on P.idpagamenti = O.idpagamento
						inner join agenti    A on A.idagenti    = O.idagente
					  inner join AmmontareVariOrdini AVO on AVO.IdOrdine = O.IdOrdini
                                              and AVO.Anno = 2021
			where
          O.Anno = 2021 and
					(O.numfattura = 0 or O.numfattura is null) and
					1=1
			order by 
					O.IdOrdini ASC
						 
<rows total_count='29' rowStart=''>

<row id='11'><cell>11</cell><cell>Enewine di Ammanati Nicola</cell><cell>Azienda Agricola Bruni</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>467,48</cell><cell></cell><cell></cell><cell>0,00</cell></row>
<row id='17'><cell>17</cell><cell>Enewine di Ammanati Nicola</cell><cell>Azienda Agricola Tercic Matijaz</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>452,01</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='47'><cell>47</cell><cell>Papaveri e Papere srl</cell><cell>Tenuta Le Potazzine srl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>761,28</cell><cell></cell><cell></cell><cell>0,00</cell></row>
<row id='66'><cell>66</cell><cell>Ristorante Osteria della Pieve di Cerri Simone &amp; C snc</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>535,82</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='70'><cell>70</cell><cell>Enewine di Ammanati Nicola</cell><cell>Azienda Agricola Ghiga Enrico</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>360,77</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='87'><cell>87</cell><cell>Osteria da Cencio</cell><cell>Società Agricola Fattori di Fattori Giovanni ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>445,06</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='92'><cell>92</cell><cell>Cioccolato Argento di Di Bello Paola</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>283,28</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='97'><cell>97</cell><cell>La Bottega di Papacqua di Mannari Dario</cell><cell>Tenuta Iuzzolini sarl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>219,01</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='100'><cell>100</cell><cell>La Bufala Mozzarella Bistrot</cell><cell>Tenuta Iuzzolini sarl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>197,64</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='112'><cell>112</cell><cell>Osteria  del Contadino di Gastaldin Tommaso</cell><cell>Pojer e Sandri di Sandri Fiorentino &amp; C soc. agr. s.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>402,60</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='115'><cell>115</cell><cell>House Caf� di Voliani Martina</cell><cell>Maglio Arte Dolciaria Srl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>823,90</cell><cell></cell><cell></cell><cell>0,00</cell></row>
<row id='116'><cell>116</cell><cell>RO. BRES. snc di Rossini S. e Breschi MC.</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>338,92</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='119'><cell>119</cell><cell>Tutte Le Direzioni s.a.s di Vettori Mirco e C.</cell><cell>Fattoria Montellori S.S.A.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>541,68</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='122'><cell>122</cell><cell>Osteria da Cencio</cell><cell>Società Agricola La Fiorita di Bono Giancarla e Stefano S.S.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>272,30</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='125'><cell>125</cell><cell>Cia snc</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>732,00</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='127'><cell>127</cell><cell>San Domenico Italian Bistr� di Ipsaro Passione Salvatore</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>245,22</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='128'><cell>128</cell><cell>Enoteca Vicolo DiVino di M. De Prosperis</cell><cell>Tenuta Iuzzolini sarl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>416,14</cell><cell></cell><cell></cell><cell>0,00</cell></row>
<row id='133'><cell>133</cell><cell>G. &amp; G. sas di D&#039;Angelo G. e C.</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>438,10</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='134'><cell>134</cell><cell>Papaveri e Papere srl</cell><cell>Fattoria Montellori S.S.A.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>263,52</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='135'><cell>135</cell><cell>Papaveri e Papere srl</cell><cell>Pojer e Sandri di Sandri Fiorentino &amp; C soc. agr. s.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>557,35</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='139'><cell>139</cell><cell>Oyster srl</cell><cell>Maglio Arte Dolciaria Srl</cell><cell>Curcio Fabrizio</cell><cell>20/10/2021</cell><cell>1.121,78</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='154'><cell>154</cell><cell>Osteria Micheletti di M &amp; P srls</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>333,10</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='157'><cell>157</cell><cell>Gherarvini di Gherardini Matteo</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>615,43</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='158'><cell>158</cell><cell>Gherarvini di Gherardini Matteo</cell><cell>Pitars snc di Pittaro Paolo e f.lli Società Agricola</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>360,37</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='159'><cell>159</cell><cell>Gherarvini di Gherardini Matteo</cell><cell>Antica Distilleria Domenico Sibona S.p.A.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>465,55</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='160'><cell>160</cell><cell>La Pizzicagnola di Pardini F. e Pavolini G. snc</cell><cell>Pojer e Sandri di Sandri Fiorentino &amp; C soc. agr. s.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>273,36</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='161'><cell>161</cell><cell>Casa-Market srl</cell><cell>Fattoria Montellori S.S.A.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>555,76</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='162'><cell>162</cell><cell>Enoteca Vicolo DiVino di M. De Prosperis</cell><cell>Podere La Regola di Luca e Flavio Nuti ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>803,19</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='164'><cell>164</cell><cell>A &amp; P Srl</cell><cell>Azienda Agricola Bruni</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>139,08</cell><cell></cell><cell>17/10/2021</cell><cell>0,00</cell></row>posStart = 
count = 

				select 
					O.*, 
					A.Nome     as NomeAgente, 
					C.Nome     as NomeCliente, 
					F.Nome     as NomeFornitore,
					F.IdFornitori, 
					P.modalita as ModalitaPagamenti,
					AVO.AmmontareOrdineConIva
			from 
					ordini O
						inner join clienti   C on C.idclienti   = O.idcliente
						inner join fornitori F on F.idfornitori = O.idfornitore 
						inner join pagamenti P on P.idpagamenti = O.idpagamento
						inner join agenti    A on A.idagenti    = O.idagente
					  inner join AmmontareVariOrdini AVO on AVO.IdOrdine = O.IdOrdini
                                              and AVO.Anno = 2020
			where
          O.Anno = 2020 and
					(O.numfattura = 0 or O.numfattura is null) and
					1=1
			order by 
					O.IdOrdini ASC
						 
<rows total_count='12' rowStart=''>

<row id='44'><cell>44</cell><cell>Ristorante Martini Diana snc</cell><cell>Società Agricola Fattori di Fattori Giovanni ss</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>374,78</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='48'><cell>48</cell><cell>Foto Silvi di Elena Cioni ed Enrico Guerrini snc</cell><cell>Fattoria Montellori S.S.A.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>879,68</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='57'><cell>57</cell><cell>La Bottega di Papacqua di Mannari Dario</cell><cell>Aringhieri Distribuzione</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>261,32</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='65'><cell>65</cell><cell>La Torre del Luppolo SNC di Giubbilini Francesco &amp; C.</cell><cell>Aringhieri Distribuzione</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>826,09</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='76'><cell>76</cell><cell>La Botte Piena di Ammannati Nicola e Monti Michela snc</cell><cell>Azienda Agricola Ghiga Enrico</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>292,17</cell><cell>0</cell><cell></cell><cell>292,17</cell></row>
<row id='77'><cell>77</cell><cell>Seaside cafe di Nardi Alessandro snc</cell><cell>Pojer e Sandri di Sandri Fiorentino &amp; C soc. agr. s.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>526,38</cell><cell></cell><cell></cell><cell>0,00</cell></row>
<row id='86'><cell>86</cell><cell>La Bottega di Montemagno di Castaldo Stefania</cell><cell>Azienda Agricola Rebuli Angelo e Figli s.a.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>187,39</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='103'><cell>103</cell><cell>La Curva di Gaetano Sciandr�</cell><cell>Aringhieri Distribuzione</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>130,30</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='162'><cell>162</cell><cell>L&#039;Arte del Bere di Tridenti Elena, Fabrizio &amp; C. Sas</cell><cell>Maglio Arte Dolciaria Srl</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>614,41</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='170'><cell>170</cell><cell>La Torre del Luppolo SNC di Giubbilini Francesco &amp; C.</cell><cell>Aringhieri Distribuzione</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>743,71</cell><cell>0</cell><cell></cell><cell>0,00</cell></row>
<row id='173'><cell>173</cell><cell>Foto Silvi di Elena Cioni ed Enrico Guerrini snc</cell><cell>Pojer e Sandri di Sandri Fiorentino &amp; C soc. agr. s.</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>690,49</cell><cell></cell><cell></cell><cell>0,00</cell></row>
<row id='179'><cell>179</cell><cell>La Botte Piena di Ammannati Nicola e Monti Michela snc</cell><cell>Azienda Agricola Ghiga Enrico</cell><cell>Curcio Fabrizio</cell><cell></cell><cell>278,44</cell><cell>0</cell><cell></cell><cell>278,44</cell></row>