01.SELECT
02. mc.med_idlab
03. , mi.namelab
04. , mu.name
05. ,mi.unitprice
06.,mc_ii.remain AS num1,(mc_ii.remain*mi.unitprice) AS price1
07.,mro.med_amount AS num2,(mro.med_amount*mi.unitprice) AS price2
08.,(mc_ii.remain+mro.med_amount) AS num3
09.,((mc_ii.remain*mi.unitprice)+(mro.med_amount*mi.unitprice)) AS price3
10.,SUM(mi1.confirm) AS num4,(SUM(mi1.confirm)*mi.unitprice) AS price4
11.,mr.remain AS num5 ,(mr.remain*mi.unitprice ) AS price5
12.FROM
13.med_cal mc
14.INNER JOIN med_items mi ON mi.med_items_id=mc.med_idlab
15.INNER JOIN med_unit mu ON mu.med_unit_id=mi.idunit
16.INNER JOIN med_receive_order mro ON mro.med_idlab=mc.med_idlab
17.INNER JOIN med_inorder mi1 ON mi1.idlab=mc.med_idlab
18.INNER JOIN med_remain mr ON mr.med_idlab=mc.med_idlab
19.LEFT JOIN (
20.SELECT *
21.FROM med_cal
22.WHERE date_update BETWEEN DATE_ADD('2017-02-01', INTERVAL -1 MONTH)
23.AND DATE_ADD('2017-02-16', INTERVAL -1 MONTH)
24.) mc_ii ON mc.med_idlab = mc_ii.med_idlab
25.
26.where mc.date_update between '2017-02-01'AND '2017-02-16'
27.
28.GROUP BY mc.med_idlab
29.ORDER BY mi.med_items_id ASC
