SELECT Rpt_InvoiceReadings.MPAN, Rpt_InvoiceReadings.site_addr, Rpt_InvoiceReadings.CheckDigit, Rpt_InvoiceReadings.UniqueId2, Rpt_InvoiceReadings.UniqueId1, \
       Rpt_InvoiceReadings.region, Rpt_InvoiceReadings.LineLossFactor, Rpt_InvoiceReadings.MeterTimeSwitchCode, Rpt_InvoiceReadings.profile_num, Rpt_InvoiceReadings.stmt_num, \
	   Rpt_InvoiceReadings.meter_id, Rpt_InvoiceReadings.units, Rpt_InvoiceReadings.PricePerKwh, Rpt_InvoiceReadings.amount, Rpt_InvoiceReadings.RegisterType, \
	   Rpt_InvoiceReadings.tariff_desc, Rpt_InvoiceReadings.EmergenceyPhoneNo, Rpt_InvoiceReadings.meter_ref, AC.acc_type_id, AC.type_name, AC.type_desc, RLD.ROTA_GROUP, \
	   blockTariff.block1UnitRate, blockTariff.block1UnitsUsed, blockTariff.block1TotalCharge, blockTariff.block2UnitRate, blockTariff.block2UnitsUsed, blockTariff.block2TotalCharge, \
	   blockTariff.block3UnitRate, blockTariff.block3UnitsUsed, blockTariff.block3TotalCharge, blockTariff.block4UnitRate, blockTariff.block4UnitsUsed, blockTariff.block4TotalCharge, \
    CASE M.selected_estimated_usage \
	  WHEN ''Alternative'' THEN M.alt_estimated_usage \
	  WHEN ''User'' THEN M.user_estimated_usage \
	  ELSE M.estimated_usage \
    END AS estimated_usage \
	  FROM   DBS.dbo.Rpt_InvoiceReadings_Summary Rpt_InvoiceReadings \
	  INNER JOIN Meter M on M.meter_id = Rpt_InvoiceReadings.meter_id \
	  INNER JOIN Account_types AC ON AC.acc_type_id = M.account_type_id \
	  LEFT JOIN RLD_DATA RLD on RLD.POSTCODE = M.post_code \
	  LEFT JOIN ( \
			  SELECT {1} AS meterID, {0} AS stmtNum, \
			         block1.unit_rate AS block1UnitRate, block1.units_used AS block1UnitsUsed, block1.total_charge AS block1TotalCharge, \
				     block2.unit_rate AS block2UnitRate, block2.units_used AS block2UnitsUsed, block2.total_charge AS block2TotalCharge, \
				     block3.unit_rate AS block3UnitRate, block3.units_used AS block3UnitsUsed, block3.total_charge AS block3TotalCharge, \
				     block4.unit_rate AS block4UnitRate, block4.units_used AS block4UnitsUsed, block4.total_charge AS block4TotalCharge \
			  FROM Stmt_unit_charge block1 \
			  LEFT JOIN stmt_unit_charge block4 ON \
				block4.meter_id = {1} AND \
				block4.stmt_num = {0} AND \
				block4.block_number = 4 \
			  LEFT JOIN stmt_unit_charge block3 ON \
				block3.meter_id = {1} AND \
				block3.stmt_num = {0} AND \
				block3.block_number = 3 \
			  LEFT JOIN stmt_unit_charge block2 ON \
				block2.meter_id = {1} AND \
				block2.stmt_num = {0} AND \
				block2.block_number = 2 \
			  WHERE                    --block1 \
				block1.meter_id = {1} AND \
				block1.stmt_num = {0} AND \
				block1.block_number = 1 \
			    ) blockTariff \
			ON blockTariff.meterID = Rpt_InvoiceReadings.meter_id \
			AND blockTariff.stmtNum = Rpt_InvoiceReadings.stmt_num \
	  WHERE  Rpt_InvoiceReadings.stmt_num = {0} \
	  AND    Rpt_InvoiceReadings.meter_id = {1} \
	  AND Rpt_InvoiceReadings.RegisterType <> ''Gas'' \
	  ORDER BY Rpt_InvoiceReadings.tariff_desc, Rpt_InvoiceReadings.meter_ref, Rpt_InvoiceReadings.RegisterType