Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #mengambil data online sesuai bulan 5 tahun 2018 dengan user id 1304
- SELECT SUM(D1) AS D1,SUM(D2) AS D2,SUM(D3) AS D3,SUM(D4) AS D4,SUM(D5) AS D5,SUM(D6) AS D6,SUM(D7) AS D7,SUM(D8) AS D8,SUM(D9) AS D9,SUM(D10) AS D10,SUM(D11) AS D11,SUM(D12) AS D12,SUM(D13) AS D13,SUM(D14) AS D14,SUM(D15) AS D15,SUM(D16) AS D16,SUM(D17) AS D17,SUM(D18) AS D18,SUM(D19) AS D19,SUM(D20) AS D20,SUM(D21) AS D21,SUM(D22) AS D22,SUM(D23) AS D23,SUM(D24) AS D24,SUM(D25) AS D25,SUM(D26) AS D26,SUM(D27) AS D27,SUM(D28) AS D28,SUM(D29) AS D29,SUM(D30) AS D30,SUM(D31) AS D31 FROM (SELECT SUM(IF( daily =1, 1, 0) ) AS D1,SUM(IF( daily =2, 1, 0) ) AS D2,SUM(IF( daily =3, 1, 0) ) AS D3,SUM(IF( daily =4, 1, 0) ) AS D4,SUM(IF( daily =5, 1, 0) ) AS D5,SUM(IF( daily =6, 1, 0) ) AS D6,SUM(IF( daily =7, 1, 0) ) AS D7,SUM(IF( daily =8, 1, 0) ) AS D8,SUM(IF( daily =9, 1, 0) ) AS D9,SUM(IF( daily =10, 1, 0) ) AS D10,SUM(IF( daily =11, 1, 0) ) AS D11,SUM(IF( daily =12, 1, 0) ) AS D12,SUM(IF( daily =13, 1, 0) ) AS D13,SUM(IF( daily =14, 1, 0) ) AS D14,SUM(IF( daily =15, 1, 0) ) AS D15,SUM(IF( daily =16, 1, 0) ) AS D16,SUM(IF( daily =17, 1, 0) ) AS D17,SUM(IF( daily =18, 1, 0) ) AS D18,SUM(IF( daily =19, 1, 0) ) AS D19,SUM(IF( daily =20, 1, 0) ) AS D20,SUM(IF( daily =21, 1, 0) ) AS D21,SUM(IF( daily =22, 1, 0) ) AS D22,SUM(IF( daily =23, 1, 0) ) AS D23,SUM(IF( daily =24, 1, 0) ) AS D24,SUM(IF( daily =25, 1, 0) ) AS D25,SUM(IF( daily =26, 1, 0) ) AS D26,SUM(IF( daily =27, 1, 0) ) AS D27,SUM(IF( daily =28, 1, 0) ) AS D28,SUM(IF( daily =29, 1, 0) ) AS D29,SUM(IF( daily =30, 1, 0) ) AS D30,SUM(IF( daily =31, 1, 0) ) AS D31 FROM (SELECT user_id, username, DAY(tr_date) AS daily FROM driver_reg_log WHERE MONTH(tr_date) = '5' AND YEAR(tr_date) = '2018' AND payload LIKE '%"status":1%' AND user_id = '1304') NewData LEFT JOIN users u on u.username = NewData.username GROUP BY daily) Final
- -> ;
- +------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+
- | D1 | D2 | D3 | D4 | D5 | D6 | D7 | D8 | D9 | D10 | D11 | D12 | D13 | D14 | D15 | D16 | D17 | D18 | D19 | D20 | D21 | D22 | D23 | D24 | D25 | D26 | D27 | D28 | D29 | D30 | D31 |
- +------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+
- | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1781 | 0 | 0 |
- +------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+
- 1 row in set (0.02 sec)
- SHOW profile for query 29;
- +----------------------+----------+
- | Status | Duration |
- +----------------------+----------+
- | starting | 0.000267 |
- | checking permissions | 0.000006 |
- | checking permissions | 0.000004 |
- | Opening tables | 0.000014 |
- | init | 0.000142 |
- | System lock | 0.000008 |
- | optimizing | 0.000004 |
- | optimizing | 0.000013 |
- | statistics | 0.000126 |
- | preparing | 0.000021 |
- | Creating tmp table | 0.000030 |
- | Sorting result | 0.000008 |
- | statistics | 0.000006 |
- | preparing | 0.000008 |
- | executing | 0.000006 |
- | Sending data | 0.000014 |
- | executing | 0.000002 |
- | Sending data | 0.023424 |
- | Creating sort index | 0.000058 |
- | end | 0.000006 |
- | query end | 0.000009 |
- | removing tmp table | 0.000007 |
- | query end | 0.000006 |
- | closing tables | 0.000003 |
- | removing tmp table | 0.000005 |
- | closing tables | 0.000008 |
- | freeing items | 0.000033 |
- | cleaning up | 0.000025 |
- +----------------------+----------+
- 28 rows in set, 1 warning (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
