Сложный запрос

SELECT
  *,
  (price_ex_VAT - cost_price_ex_VAT) AS diff
FROM Product
WHERE product_ID IN (
  SELECT product_ID
  FROM ProductOrder
  WHERE invoice_ID IN (
    SELECT invoice_id
    FROM invoice
    WHERE
      invoice_datetime BETWEEN d1 AND d2
  )
)
ORDER BY diff DESC
LIMIT N;

SELECT
  *, (price_ex_VAT - cost_price_ex_VAT) AS diff, SUM(diff) AS sum_diff
  FROM Product
    WHERE product_ID IN (
      SELECT product_ID
        FROM ProductOrder
          WHERE invoice_ID IN (
            SELECT invoice_id
            FROM invoice
            WHERE
              invoice_datetime BETWEEN d1 AND d2
          )
    )
  GROUP BY product_ID
  ORDER BY sum_diff DESC
LIMIT N;

SELECT
  *,
  SUM(price_ex_VAT - cost_price_ex_VAT) AS sum_diff
FROM
    Product AS p JOIN ProductOrder AS po
      ON p.product_id = po.product_ID
WHERE p.product_ID IN (
  SELECT po.product_ID
  FROM ProductOrder AS po
  WHERE invoice_ID IN (
    SELECT invoice_ID
    FROM Invoice
    WHERE
      invoice_datetime BETWEEN '2016-01-01' AND '2016-08-08'
  )
)
GROUP BY p.product_ID
ORDER BY sum_diff DESC
LIMIT 5

SELECT
  *,
  SUM(price_ex_VAT - cost_price_ex_VAT) AS sum_diff
FROM
    Product AS p JOIN ProductOrder AS po
      ON p.product_id = po.product_ID
  JOIN Invoice AS inv ON po.invoice_ID = inv.invoice_ID
WHERE DATE(inv.invoice_datetime) BETWEEN '2016-08-01' AND '2016-08-13'
GROUP BY p.product_ID
ORDER BY sum_diff DESC
LIMIT 5