cof_dash_vendascategoria

SELECT to_char(i.dateinvoiced, 'MM'::text) AS categoria,

    ol.qtyinvoiced AS value,

    pc.name AS serie,

    ol.ad_org_id,

    ol.ad_client_id,

    ol.c_invoice_id,

    pc.m_product_category_id,

    p.name

   FROM (((c_invoice i

     JOIN c_invoiceline ol ON ((i.c_invoice_id = ol.c_invoice_id)))

     LEFT JOIN m_product p ON ((ol.m_product_id = p.m_product_id)))

     LEFT JOIN m_product_category pc ON ((p.m_product_category_id = pc.m_product_category_id)))

  WHERE ((i.docstatus = ANY (ARRAY['CO'::bpchar, 'CL'::bpchar, 'RE'::bpchar])) AND (p.issold = 'Y'::bpchar) AND (i.issotrx = 'Y'::bpchar) AND (p.m_product_id > (0)::numeric) AND (pc.m_product_category_id IN ( SELECT p2.m_product_category_id

           FROM (c_invoiceline_v ol2

             JOIN m_product p2 ON ((ol2.m_product_id = p2.m_product_id)))

          GROUP BY p2.m_product_category_id

          ORDER BY (sum(ol2.qtyinvoiced))

         LIMIT 5)))

  ORDER BY ol.qtyinvoiced DESC;