SELECT "Cantidad " AS reservas."Concepto", COUNT(*) AS reservas."Total Reservas", 1.0*(SELECT COUNT(*) FROM reservas WHERE reservas.Agencia=-1 AND reservas.Desde >= ':1' AND reservas.Desde <= ':2') AS reservas."Res. Directos", 1.0*(SELECT COUNT(*) FROM reservas WHERE reservas.Agencia>-1 AND reservas.Desde >= ':1' AND reservas.Desde <= ':2') AS reservas."Res. Canales", 1.0*(SELECT COUNT(*) FROM reservas WHERE reservas.Agencia=-2 AND reservas.Desde >= ':1' AND reservas.Desde <= ':2') AS reservas."Res. Prop.", 1.0*SUM(reservas.Hasta-reservas.Desde) AS reservas."Total Noches", 1.0*(SELECT SUM(reservas.Hasta-reservas.Desde) FROM reservas WHERE reservas.Agencia=-1 AND reservas.Desde >= ':1' AND reservas.Desde <= ':2') AS reservas."Noc. Directos", 1.0*(SELECT SUM(reservas.Hasta-reservas.Desde) FROM reservas WHERE reservas.Agencia>-1 AND reservas.Desde >= ':1' AND reservas.Desde <= ':2') AS reservas."Noc. Canales", 1.0*(SELECT SUM(reservas.Hasta-reservas.Desde) FROM reservas WHERE reservas.Agencia=-2 AND reservas.Desde >= ':1' AND reservas.Desde <= ':2') AS reservas."Noc. Prop." FROM reservas WHERE reservas.Desde >= ':1' AND reservas.Desde <= ':2' UNION ALL SELECT "Porcentaje" AS reservas."Concepto", 100, (100.0*(SELECT COUNT(*) FROM reservas WHERE reservas.Agencia=-1 AND reservas.Desde >= ':1' AND reservas.Desde <= ':2')/COUNT(*)) AS reservas."Res. Directos", (100.0*(SELECT COUNT(*) FROM reservas WHERE reservas.Agencia>-1 AND reservas.Desde >= ':1' AND reservas.Desde <= ':2')/COUNT(*)) AS reservas."Res. Canales", (100.0*(SELECT COUNT(*) FROM reservas WHERE reservas.Agencia=-2 AND reservas.Desde >= ':1' AND reservas.Desde <= ':2')/COUNT(*)) AS reservas."Res. Prop.", 100, (100.0*(SELECT SUM(reservas.Hasta-reservas.Desde) FROM reservas WHERE reservas.Agencia=-1 AND reservas.Desde >= ':1' AND reservas.Desde <= ':2') /(SUM(reservas.Hasta-reservas.Desde))) AS reservas."Noc. Directos", (100.0*(SELECT SUM(reservas.Hasta-reservas.Desde) FROM reservas WHERE reservas.Agencia>-1 AND reservas.Desde >= ':1' AND reservas.Desde <= ':2') /(SUM(reservas.Hasta-reservas.Desde))) AS reservas."Noc. Canales", (100.0*(SELECT SUM(reservas.Hasta-reservas.Desde) FROM reservas WHERE reservas.Agencia=-2 AND reservas.Desde >= ':1' AND reservas.Desde <= ':2') /(SUM(reservas.Hasta-reservas.Desde))) AS reservas."Noc. Prop." FROM reservas WHERE reservas.Desde >= ':1' AND reservas.Desde <= ':2'