mysql> select WEEK('2019-07-11',1);
+----------------------+
| WEEK('2019-07-11',1) |
+----------------------+
|                   28 |
+----------------------+
1 row in set (0.05 sec)

mysql> 
mysql> select YEARWEEK('2019-07-11',1);
+--------------------------+
| YEARWEEK('2019-07-11',1) |
+--------------------------+
|                   201928 |
+--------------------------+
1 row in set (0.08 sec)

mysql> 

SQL> select year('2019-07-11')||WEEK('2019-07-11',1);

LINEID     YEAR('2019-07-11')||WEEK('2019-07-11',1)
---------- ----------------------------------------
1          201928