
I am try gather some statistics from a database and it need group by week numbers. and the results return unexpected.
SELECT create_date, WEEK(create_date) as week FROM `ttable` +---------------------+-------------+ | craete_date | week | +---------------------+-------------+ | 2018-01-02 00:00:00 | 0 | | 2018-04-10 00:00:00 | 14 | | 2018-03-13 00:00:00 | 10 | | 2018-03-30 00:00:00 | 12 | +---------------------+-------------+From the above you will found that the week number was wrong. and MySQL counts the first days of the year that do not belong week 1 as week 0.
This is because MySQL default week() function caused the issue. because in MySQL the first day of week is Sunday and it range was 0 to 53 weeks. And you need change the MySQL mode with the below table.

To use config.xml version number on APP. you need install APP VERSION with npm.
To display the version number on APP.
this.platform.ready().then(() => { this.appVersion.getVersionNumber().then((value) => { var value = value.replace(/"/g, ''); this.version = 'v'+value; }) });and then put {{version}} where you want to display in html page.
and the output will be like this v1.0.1

In IONIC 3 LoadingController you can set the content or text in starting. But if the loading is for getting information from many place and you want to display how many percent was completed or the process until which step.
this.loading = this.loadingCtrl.create({content: 'Please wait...'});