query 1 deleted some views

SELECT mo.referencia,
       ent.unidades AS entrada,
       ven.unidades AS vendidas,
       taprov.precio

FROM modelo AS mo

   JOIN (SELECT mo.modelo_id AS id_modelo,
                SUM(lin.unidades_reales)::INT AS unidades,
                MIN(cab.time_stamp_recepcion)::DATE AS min_fecha

         FROM modelo AS mo
            JOIN articulo AS art ON art.id_modelo = mo.modelo_id
            JOIN albaran_entrada_linea AS lin ON lin.id_articulo = art.articulo_id
            JOIN albaran_entrada_cabecera AS cab ON cab.albaran_id = lin.id_albaran

         WHERE cab.id_almacen_destino = 109

         GROUP BY mo.modelo_id

         HAVING MIN(cab.time_stamp_recepcion)::DATE = (CURRENT_DATE - INTERVAL '30 days')::DATE ) AS ent ON ent.id_modelo = mo.modelo_id

   JOIN (SELECT mo.modelo_id AS id_modelo,
                (CASE
                   WHEN SUM(tic.unidades) > 0
                      THEN  SUM(tic.unidades)
                   ELSE 0
                END
                +
                CASE
                   WHEN SUM(res.unidades) > 0
                      THEN SUM(res.unidades)
                   ELSE 0
                END)::int AS unidades
         FROM modelo AS mo
            JOIN articulo AS art ON art.id_modelo = mo.modelo_id

            LEFT JOIN (SELECT lin.id_articulo,
                              SUM(lin.unidades) AS unidades
                       FROM t109.ticket_cabecera AS cab
                          JOIN t109.ticket_linea AS lin ON lin.id_ticket = cab.ticket_id
                       GROUP BY lin.id_articulo) AS tic ON tic.id_articulo = art.articulo_id

            LEFT JOIN (SELECT lin.id_articulo,
                              SUM(lin.unidades) AS unidades
                       FROM t109.reserva_cabecera AS cab
                          JOIN t109.reserva_linea AS lin ON lin.id_reserva = cab.reserva_id
                       WHERE cab.recogido = TRUE
                       GROUP BY lin.id_articulo) AS res ON res.id_articulo = art.articulo_id

       GROUP BY mo.modelo_id) AS ven ON ven.id_modelo = mo.modelo_id

   JOIN tarifa_proveedor_modelo_precio AS taprov ON taprov.id_modelo = mo.modelo_id
                                                AND taprov.id_tarifa = 3

   /* with this join it works much faster
   JOIN tarifa_modelo_precio AS taprov ON taprov.id_modelo = mo.modelo_id
                                      AND taprov.id_tarifa = 3
   */

WHERE mo.id_seccion <> 4
  AND (ent.unidades <> 0 OR ven.unidades <> 0)

ORDER BY referencia;