root@ubuntu1604lts:/home/ushastry# docker run --name bug87824 -e MYSQL_ROOT_PASSWORD=mysql123 -d mysql/mysql-server:latest Unable to find image 'mysql/mysql-server:latest' locally latest: Pulling from mysql/mysql-server 5881d531c681: Pull complete d89828eb4f77: Pull complete ea98aaa7449c: Pull complete cf5fc5a695e9: Pull complete Digest: sha256:09a1410e8bf0eed4743b93808d5b2536d090d10ebfd41344fc50cc82981528f8 Status: Downloaded newer image for mysql/mysql-server:latest 6363a4f8922b6d3db57845d73837b812f1cb4f85df45e9281f135b5c8e1b2335 root@ubuntu1604lts:/home/ushastry# root@ubuntu1604lts:/home/ushastry# ## root@ubuntu1604lts:/home/ushastry# docker run --name bug87824 -e MYSQL_ROOT_PASSWORD=mysql123 -d mysql/mysql-server:latest Unable to find image 'mysql/mysql-server:latest' locally latest: Pulling from mysql/mysql-server 5881d531c681: Pull complete d89828eb4f77: Pull complete ea98aaa7449c: Pull complete cf5fc5a695e9: Pull complete Digest: sha256:09a1410e8bf0eed4743b93808d5b2536d090d10ebfd41344fc50cc82981528f8 Status: Downloaded newer image for mysql/mysql-server:latest 6363a4f8922b6d3db57845d73837b812f1cb4f85df45e9281f135b5c8e1b2335 root@ubuntu1604lts:/home/ushastry# root@ubuntu1604lts:/home/ushastry# docker exec -it bug87824 mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 Server version: 5.7.19 MySQL Community Server (GPL) Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> create database bug87824; Query OK, 1 row affected (0.00 sec) mysql> use bug87824 Database changed mysql> show variables like 'sql_mode'; +---------------+-------------------------------------------------------------------------------------------------------------------------------------------+ | Variable_name | Value | +---------------+-------------------------------------------------------------------------------------------------------------------------------------------+ | sql_mode | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | +---------------+-------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> DROP TABLE IF EXISTS patients_query; Query OK, 0 rows affected, 1 warning (0.01 sec) mysql> CREATE TABLE `patients_query` ( -> `id_` int(11) NOT NULL AUTO_INCREMENT, -> `id` int(11) NOT NULL DEFAULT '0', -> `external_id` varchar(50) NOT NULL DEFAULT '0', -> `master_patient_id` varchar(50) NOT NULL DEFAULT '0', -> `list_type` int(11) NOT NULL DEFAULT '0', -> `list_name` varchar(100) NOT NULL DEFAULT '0', -> `NameFirst` varchar(64) NOT NULL, -> `NameLast` varchar(255) NOT NULL, -> `company_id` int(11) NOT NULL, -> `company_ids` varchar(255) NOT NULL, -> `dob` varchar(50) NOT NULL, -> `AddrStreet` varchar(255) NOT NULL, -> `AddrStreet2` varchar(100) NOT NULL, -> `AddrStreet3` varchar(100) NOT NULL, -> `AddrZip` varchar(15) NOT NULL, -> `AddrCity` varchar(63) NOT NULL, -> `AddrState` varchar(50) NOT NULL, -> `account_number` varchar(255) NOT NULL, -> `admit_service_date` varchar(255) NOT NULL, -> `location_service` varchar(255) NOT NULL, -> `has_patient_list_history` tinyint(4) NOT NULL, -> `is_active` tinyint(4) NOT NULL, -> `phone` varchar(20) NOT NULL, -> `email` varchar(63) NOT NULL, -> `do_not_share_my_data` tinyint(4) NOT NULL DEFAULT '0', -> PRIMARY KEY (`id_`), -> KEY `list_type` (`list_type`), -> KEY `company_id` (`company_id`), -> KEY `list_type_company_id` (`list_type`,`company_id`), -> KEY `master_patient_id` (`master_patient_id`), -> KEY `id` (`id`), -> KEY `master_patien_listy_type` (`master_patient_id`,`list_type`), -> KEY `NameFirst` (`NameFirst`), -> KEY `NameLast` (`NameLast`), -> KEY `dob` (`dob`) -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8; Query OK, 0 rows affected (0.05 sec) mysql> set @id:=0; Query OK, 0 rows affected (0.00 sec) mysql> mysql> insert into `patients_query` values -> ( @id:=@id+1 -> ,@id:=@id+1 -> ,@id:=@id+1 -> ,@id:=@id+1 -> ,@id:=@id+1 -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,@id:=@id+1 -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,FLOOR(RAND() * 99999) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,FLOOR((RAND() * (1-0+1))+0) -> ,FLOOR((RAND() * (1-0+1))+0) -> ,FLOOR(RAND() * 99999) -> ,md5(rand()*1000000) -> ,FLOOR((RAND() * (1-0+1))+0) -> ) -> ,( @id:=@id+1 -> ,@id:=@id+1 -> ,@id:=@id+1 -> ,@id:=@id+1 -> ,@id:=@id+1 -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,@id:=@id+1 -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,FLOOR(RAND() * 99999) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,FLOOR((RAND() * (1-0+1))+0) -> ,FLOOR((RAND() * (1-0+1))+0) -> ,FLOOR(RAND() * 99999) -> ,md5(rand()*1000000) -> ,FLOOR((RAND() * (1-0+1))+0) -> ) -> ,( @id:=@id+1 -> ,@id:=@id+1 -> ,@id:=@id+1 -> ,@id:=@id+1 -> ,@id:=@id+1 -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,@id:=@id+1 -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,FLOOR(RAND() * 99999) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,FLOOR((RAND() * (1-0+1))+0) -> ,FLOOR((RAND() * (1-0+1))+0) -> ,FLOOR(RAND() * 99999) -> ,md5(rand()*1000000) -> ,FLOOR((RAND() * (1-0+1))+0) -> ) -> ,( @id:=@id+1 -> ,@id:=@id+1 -> ,@id:=@id+1 -> ,@id:=@id+1 -> ,@id:=@id+1 -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,@id:=@id+1 -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,FLOOR(RAND() * 99999) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,FLOOR((RAND() * (1-0+1))+0) -> ,FLOOR((RAND() * (1-0+1))+0) -> ,FLOOR(RAND() * 99999) -> ,md5(rand()*1000000) -> ,FLOOR((RAND() * (1-0+1))+0) -> ); Query OK, 4 rows affected (0.13 sec) Records: 4 Duplicates: 0 Warnings: 0 mysql> mysql> mysql> insert into `patients_query`( -> `id`, -> `external_id`, -> `master_patient_id`, -> `list_type`, -> `list_name`, -> `NameFirst`, -> `NameLast`, -> `company_id`, -> `company_ids`, -> `dob`, -> `AddrStreet`, -> `AddrStreet2`, -> `AddrStreet3`, -> `AddrZip`, -> `AddrCity`, -> `AddrState`, -> `account_number`, -> `admit_service_date`, -> `location_service`, -> `has_patient_list_history`, -> `is_active`, -> `phone`, -> `email`, -> `do_not_share_my_data` -> ) -> select @id:=@id+1 -> ,@id:=@id+1 -> ,@id:=@id+1 -> ,@id:=@id+1 -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,@id:=@id+1 -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,FLOOR(RAND() * 99999) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,FLOOR((RAND() * (1-0+1))+0) -> ,FLOOR((RAND() * (1-0+1))+0) -> ,FLOOR(RAND() * 99999) -> ,md5(rand()*1000000) -> ,FLOOR((RAND() * (1-0+1))+0) -> from `patients_query` k1, `patients_query` k2, `patients_query` k3, `patients_query` k4,`patients_query` k5,`patients_query` k6, `patients_query` k7, `patients_query` k8, `patients_query` k9,`patients_query` k0,`patients_query` ka, `patients_query` kb, `patients_query` kc, `patients_query` kd limit 450000; Query OK, 450000 rows affected (2 min 10.42 sec) Records: 450000 Duplicates: 0 Warnings: 0 mysql> DROP TABLE IF EXISTS patients_query_removed; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> CREATE TABLE `patients_query_removed` ( -> `id_` int(11) NOT NULL AUTO_INCREMENT, -> `id` int(11) NOT NULL DEFAULT '0', -> `external_id` varchar(50) NOT NULL DEFAULT '0', -> `master_patient_id` varchar(50) NOT NULL DEFAULT '0', -> `list_type` int(11) NOT NULL DEFAULT '0', -> `list_name` varchar(100) NOT NULL DEFAULT '0', -> `NameFirst` varchar(64) NOT NULL, -> `NameLast` varchar(255) NOT NULL, -> `company_id` int(11) NOT NULL, -> `company_ids` varchar(255) NOT NULL, -> `dob` varchar(50) NOT NULL, -> `AddrStreet` varchar(255) NOT NULL, -> `AddrStreet2` varchar(100) NOT NULL, -> `AddrStreet3` varchar(100) NOT NULL, -> `AddrZip` varchar(15) NOT NULL, -> `AddrCity` varchar(63) NOT NULL, -> `AddrState` varchar(50) NOT NULL, -> `account_number` varchar(255) NOT NULL, -> `admit_service_date` varchar(255) NOT NULL, -> `location_service` varchar(255) NOT NULL, -> `has_patient_list_history` tinyint(4) NOT NULL, -> `is_active` tinyint(4) NOT NULL, -> `phone` varchar(20) NOT NULL, -> `email` varchar(63) NOT NULL, -> `do_not_share_my_data` tinyint(4) NOT NULL DEFAULT '0', -> PRIMARY KEY (`id_`), -> KEY `list_type` (`list_type`), -> KEY `company_id` (`company_id`), -> KEY `list_type_company_id` (`list_type`,`company_id`), -> KEY `master_patient_id` (`master_patient_id`), -> KEY `id` (`id`), -> KEY `master_patien_listy_type` (`master_patient_id`,`list_type`), -> KEY `NameFirst` (`NameFirst`), -> KEY `NameLast` (`NameLast`), -> KEY `dob` (`dob`) -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8; Query OK, 0 rows affected (0.09 sec) mysql> mysql> mysql> set @id:=0; Query OK, 0 rows affected (0.00 sec) mysql> mysql> insert into `patients_query_removed` values -> ( @id:=@id+1 -> ,@id:=@id+1 -> ,@id:=@id+1 -> ,@id:=@id+1 -> ,@id:=@id+1 -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,@id:=@id+1 -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,FLOOR(RAND() * 99999) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,FLOOR((RAND() * (1-0+1))+0) -> ,FLOOR((RAND() * (1-0+1))+0) -> ,FLOOR(RAND() * 99999) -> ,md5(rand()*1000000) -> ,FLOOR((RAND() * (1-0+1))+0) -> ) -> ,( @id:=@id+1 -> ,@id:=@id+1 -> ,@id:=@id+1 -> ,@id:=@id+1 -> ,@id:=@id+1 -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,@id:=@id+1 -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,FLOOR(RAND() * 99999) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,FLOOR((RAND() * (1-0+1))+0) -> ,FLOOR((RAND() * (1-0+1))+0) -> ,FLOOR(RAND() * 99999) -> ,md5(rand()*1000000) -> ,FLOOR((RAND() * (1-0+1))+0) -> ) -> ,( @id:=@id+1 -> ,@id:=@id+1 -> ,@id:=@id+1 -> ,@id:=@id+1 -> ,@id:=@id+1 -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,@id:=@id+1 -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,FLOOR(RAND() * 99999) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,FLOOR((RAND() * (1-0+1))+0) -> ,FLOOR((RAND() * (1-0+1))+0) -> ,FLOOR(RAND() * 99999) -> ,md5(rand()*1000000) -> ,FLOOR((RAND() * (1-0+1))+0) -> ) -> ,( @id:=@id+1 -> ,@id:=@id+1 -> ,@id:=@id+1 -> ,@id:=@id+1 -> ,@id:=@id+1 -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,@id:=@id+1 -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,FLOOR(RAND() * 99999) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,FLOOR((RAND() * (1-0+1))+0) -> ,FLOOR((RAND() * (1-0+1))+0) -> ,FLOOR(RAND() * 99999) -> ,md5(rand()*1000000) -> ,FLOOR((RAND() * (1-0+1))+0) -> ); Query OK, 4 rows affected (0.03 sec) Records: 4 Duplicates: 0 Warnings: 0 mysql> mysql> mysql> insert into `patients_query_removed`( -> `id`, -> `external_id`, -> `master_patient_id`, -> `list_type`, -> `list_name`, -> `NameFirst`, -> `NameLast`, -> `company_id`, -> `company_ids`, -> `dob`, -> `AddrStreet`, -> `AddrStreet2`, -> `AddrStreet3`, -> `AddrZip`, -> `AddrCity`, -> `AddrState`, -> `account_number`, -> `admit_service_date`, -> `location_service`, -> `has_patient_list_history`, -> `is_active`, -> `phone`, -> `email`, -> `do_not_share_my_data` -> ) -> select @id:=@id+1 -> ,@id:=@id+1 -> ,@id:=@id+1 -> ,@id:=@id+1 -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,@id:=@id+1 -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,FLOOR(RAND() * 99999) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,md5(rand()*1000000) -> ,FLOOR((RAND() * (1-0+1))+0) -> ,FLOOR((RAND() * (1-0+1))+0) -> ,FLOOR(RAND() * 99999) -> ,md5(rand()*1000000) -> ,FLOOR((RAND() * (1-0+1))+0) -> from `patients_query_removed` k1, `patients_query_removed` k2, `patients_query_removed` k3, `patients_query_removed` k4,`patients_query_removed` k5,`patients_query_removed` k6, `patients_query_removed` k7, `patients_query_removed` k8, `patients_query_removed` k9,`patients_query_removed` k0,`patients_query_removed` ka, `patients_query_removed` kb, `patients_query_removed` kc, `patients_query_removed` kd limit 5000; Query OK, 5000 rows affected (1.91 sec) Records: 5000 Duplicates: 0 Warnings: 0 mysql> mysql> ysql> mysql> set global internal_tmp_disk_storage_engine = InnoDB; Query OK, 0 rows affected (0.02 sec) mysql> -- reconnect session and attempt to run below query multiple times mysql> select * from (select * from patients_query union select * from patients_query_removed) A limit 10; +-----+----+-------------+-------------------+-----------+----------------------------------+----------------------------------+----------------------------------+------------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+---------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+--------------------------+-----------+-------+----------------------------------+----------------------+ | id_ | id | external_id | master_patient_id | list_type | list_name | NameFirst | NameLast | company_id | company_ids | dob | AddrStreet | AddrStreet2 | AddrStreet3 | AddrZip | AddrCity | AddrState | account_number | admit_service_date | location_service | has_patient_list_history | is_active | phone | email | do_not_share_my_data | +-----+----+-------------+-------------------+-----------+----------------------------------+----------------------------------+----------------------------------+------------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+---------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+--------------------------+-----------+-------+----------------------------------+----------------------+ | 1 | 2 | 3 | 4 | 5 | 1eed08ff4e8d4c7d4f76159e34fd4d3b | 5bc6a03939a931741a5f28506561abf5 | 89cb73d71c3d522707a6a1a3dd0bf10f | 6 | ad7c2e9293384a808250ae08651f5944 | eff688a4009afbc1c5bad8124fc7c40c | c96799672155ff182ab6b792ed1ffac2 | 1cbd9b730469b380b015c4cb02e6bde7 | 69d89972a25e8c7c5dee95d9562866da | 96494 | ddafe1e5f86b7575f3a377abd102151c | 9116ac397172ea3a055cdd946588c4cd | 204bb99559d968253c9e0b24b5530d31 | 9f06a50c1a4e2c28cdc759bb83d95fd0 | 4f93812a97a19acbe86d2565776d6494 | 0 | 1 | 83413 | 5ec192c522e69d3b232be2eaac767f7d | 1 | | 7 | 8 | 9 | 10 | 11 | b9ea579eacca31d7bcc1e75ef03b8c4e | f58c6b8fa46cf5e9f50072c5fa4cff76 | ca7d03db2b8faa5e9aa8760cf9692761 | 12 | e6f91b259dbb0505210156e2a2002e24 | 76302149923460ec8560f725adf58076 | f19031b23d6cb831866062693a60fe50 | 0a82d7d775c014fff1a3ba5ca15fd6b4 | a73a4859bd858753a98ddfbb55d28798 | 46032 | 31fb29e21e991c52132efe5a6b421744 | 5f9ea8265befea3863b52650876c22df | e76c2ce2088de84d924c241f29988532 | e21d8b99edf24c23e4fe8f906142af7c | fc43bc74ab0bd063662678af849f150f | 1 | 1 | 85191 | 09bc2142f9312d9f4ee79701c4251ef4 | 1 | | 13 | 14 | 15 | 16 | 17 | a7ba7d17a87c9c71ab7fd04b891a659a | 57af0746b5537299e3841c79c7fad763 | bee4e2b1ce18c8b168a062e4f0ddc98e | 18 | dc5d2908cbb94313cbd64fe9b732d337 | 1e758d6014d718d5782c21dc226b2f3a | 42a7640574d1149dd8572efec60e34bf | d3f3302a8e5ab52014bbaba208eae68b | 05b4de1a1e40ba930f4b964df0987540 | 70318 | 26489b7969c560f26a0fe17af09c77ec | 6097cfef91d6863dbc5d29aadb769cf1 | f76190749368b0f63eb6c170087eccf0 | b97fea68a41eb54becd3dd6caeddd0b1 | fd170186e77425e59042d28d9320699d | 1 | 1 | 6230 | e203e8250ef3400de80938c02947d2b1 | 1 | | 19 | 20 | 21 | 22 | 23 | 434bdeae2a813d1a7f045fc1364de13d | f160dd05683cb0a65fe7151d2af571e8 | ca9f08b5bcae19ed7993a4e3016e0608 | 24 | 8505e07a78b5f903e6b3c8d2309c709c | f552a530f41e519e6854eecee490a887 | be47e17884ff379c7a6810991015c4d8 | 3581c2921b160bbf35ff294e255a2bc8 | 2f128c019f2203a63a55fbb0c723745f | 15291 | 061910940aee75bc7da0e43c7df4e784 | c83fcd51472324ae541e6ca4c1044f00 | e21ee0bf8382748b833c7e956e9e4e74 | daa6aa12798eb323ed11b287ff28a63a | 295b6fe5f9d81bcf57bd2041001b0ba6 | 1 | 1 | 68488 | 86e536d6b515fb65c870f08b8b502901 | 0 | | 20 | 25 | 26 | 27 | 28 | 740011ef4d83e0d0958fb6086a36b9a9 | 0cb262cfae085c8f9ea49e73b0888ee7 | e8f02826c5957c5b793dad8215eba552 | 29 | a5c37c350672da8f126667b8baa9f0f4 | dc9b1b9561efc5352015730d817502fa | f1818b503164fd23a50760c7751e099f | 9812a53181be78035fec4298c5439551 | 5958384046314eacfc9eb3040b502769 | 60707 | 3711cacc4727720629327c672f89ccaf | fc9074868aa259f5477a35d3d0cd4773 | 7992af0131786f6230d27fe4b36f5c55 | cdde97182729f2e610e1e3eb4ac6f250 | 39edf94f4552f475b9948809dd1b72c9 | 0 | 0 | 15373 | 9ec471b7ec3fca6f85c3c5db7941bdb4 | 1 | | 21 | 30 | 31 | 32 | 33 | bba7d5984ece182497aed607754ff43b | 9e0d04cd531f69fbe6f5a14dc5ea1ea4 | 809fbb25f2d8bae3442c832904d57a8a | 34 | 8dacb8a875dea2a966004eb3a220119b | db081a1a8f5d495fb7127fd3e76dde62 | 0e2d2631eb85050a42a2b0f0d32d293e | 43976259f14d86663299e513138094d2 | efb0ed0f2f813a81fa2b82e3af2b9026 | 54195 | 25d0726289accd36d24f81d8764c2cd1 | 58ff455fc7da87af6bdbe40a4d7f56df | ba495ad99c843215bc6f4db2f116e44e | f9addac02da891dca05bc9601bfe94f5 | 41cfa63d1495a2dc8306adbc6b5d53d5 | 0 | 0 | 57017 | 7131f153776111c4012b881c774a32c9 | 0 | | 22 | 35 | 36 | 37 | 38 | 27aa614979fd27b10e50b7af18d27243 | e627c331895b976e42c1d44237c7db3e | b26e99bd6771892e4ea0af02bf3ac220 | 39 | 47a4fea52260c1710d177f9005d7aa72 | dcab3d577fdd95bcb4ccb6628d589c3e | 3d7ccf5ef3a6a28141fb8a27824f44bb | 10947d16ae293e1053a6d119910bd562 | ce2dee20cdf5fe9ce6aea2002a3a25fa | 83523 | 00983e4173b9c1841a5c3ab114aba8dd | e574225a7b31fca6d409eebbdd7917f7 | a6dfab015723c63fed130526e82667cf | 5a80862d3dabf5a517a604eea7d6e0b9 | 45c82d7c5c923c0a6439efbddd7949ef | 0 | 0 | 79234 | 6256b023ba0b72975b3da6b7850e8d90 | 0 | | 23 | 40 | 41 | 42 | 43 | 72976c626276be410e98742e9b1d8d63 | 35a41a4fc6fa3bada59389f12e20aecb | 6de519de17bf6e27dd646c4d8180335b | 44 | 83cdcb4ea87ee430df46789c0894adec | c550742f7d2e3dd4245e6cccd1a13a6c | 70459786db9ba48c3a3b97db254757e4 | b326f33f65660d185c443d73bd03fb39 | e917a22b83663ab72a3dc86480b306fd | 62966 | 0b6de4f867fd0c2c8997f723517e0c54 | c6489fe9fd8e8ee3160894119728b631 | b9009ff000444fb62f9473cbeb613886 | 6245526dd930ca9649c44a7bcabc5af8 | f7b00c0b8c3eb0907fe2c25dda1162b5 | 1 | 1 | 85806 | 14bf38d632af210bb80d6188a823eb52 | 0 | | 24 | 45 | 46 | 47 | 48 | 634dd147c24a4ca84822136e80485a8d | f1ebde97c523fd26e138e3b0ff11827b | e32470055f5ee84854f84f48a5d17bcb | 49 | 2afbf35ef5f741cb20bf8cf8f50d09a1 | d0a37901def8969f7f24cfbcfe72ef1a | 27b3a1fad04d75e18ca08f8c1b5a79c7 | 120d054280f6fc7896fd9334af538bb0 | 51a0c6b17beed3d0b85e3f99a63c1973 | 330 | be08ee1279a0bcef3a8ecbec4ee3d668 | 858c916a3d4f10a68cd73025902d2e40 | 49d77c1c8d7ce086e495d898ecab21b1 | c6f9568dbab4f3f7b5fc05f70e3c48f8 | 228ea4947987c907c699c9f4c1a78140 | 1 | 0 | 10855 | fe3b5ef6f2fa5544ad59f0bd1886f630 | 0 | | 25 | 50 | 51 | 52 | 53 | 0e7398cb6dc1f784c794b88773d8627b | 310658cf4f5043909047a18fdd654189 | f4f8c81619eb529d2aa9ef3ba6f27054 | 54 | b2663c20ef41d903949df183139f4112 | a8fe74e90ad96cad2fac89ab00508153 | f2de9813a9017bf3f8e800c9c96f9e03 | 96a207a738cbc51a122e39e48069e3ce | 1ee6f7a4111913542681b977aae18aa1 | 94470 | 1d38c3a6bd72c82f9c83cb338c0b8b72 | 2f52a12ab8c22142e758b9c60c6d3cf4 | 5299e8c8c7ce4b6849d9354798eced0b | 3361336cf0358e0a706dc5cc4940f0de | 83e85985bac8b8fa1d9f4e9448da3c40 | 1 | 1 | 1750 | e074efcd605000c08ea159b493873a5f | 1 | +-----+----+-------------+-------------------+-----------+----------------------------------+----------------------------------+----------------------------------+------------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+---------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+--------------------------+-----------+-------+----------------------------------+----------------------+ 10 rows in set (33.41 sec) mysql> select * from (select * from patients_query union select * from patients_query_removed) A limit 10; +-----+----+-------------+-------------------+-----------+----------------------------------+----------------------------------+----------------------------------+------------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+---------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+--------------------------+-----------+-------+----------------------------------+----------------------+ | id_ | id | external_id | master_patient_id | list_type | list_name | NameFirst | NameLast | company_id | company_ids | dob | AddrStreet | AddrStreet2 | AddrStreet3 | AddrZip | AddrCity | AddrState | account_number | admit_service_date | location_service | has_patient_list_history | is_active | phone | email | do_not_share_my_data | +-----+----+-------------+-------------------+-----------+----------------------------------+----------------------------------+----------------------------------+------------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+---------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+--------------------------+-----------+-------+----------------------------------+----------------------+ | 1 | 2 | 3 | 4 | 5 | 1eed08ff4e8d4c7d4f76159e34fd4d3b | 5bc6a03939a931741a5f28506561abf5 | 89cb73d71c3d522707a6a1a3dd0bf10f | 6 | ad7c2e9293384a808250ae08651f5944 | eff688a4009afbc1c5bad8124fc7c40c | c96799672155ff182ab6b792ed1ffac2 | 1cbd9b730469b380b015c4cb02e6bde7 | 69d89972a25e8c7c5dee95d9562866da | 96494 | ddafe1e5f86b7575f3a377abd102151c | 9116ac397172ea3a055cdd946588c4cd | 204bb99559d968253c9e0b24b5530d31 | 9f06a50c1a4e2c28cdc759bb83d95fd0 | 4f93812a97a19acbe86d2565776d6494 | 0 | 1 | 83413 | 5ec192c522e69d3b232be2eaac767f7d | 1 | | 7 | 8 | 9 | 10 | 11 | b9ea579eacca31d7bcc1e75ef03b8c4e | f58c6b8fa46cf5e9f50072c5fa4cff76 | ca7d03db2b8faa5e9aa8760cf9692761 | 12 | e6f91b259dbb0505210156e2a2002e24 | 76302149923460ec8560f725adf58076 | f19031b23d6cb831866062693a60fe50 | 0a82d7d775c014fff1a3ba5ca15fd6b4 | a73a4859bd858753a98ddfbb55d28798 | 46032 | 31fb29e21e991c52132efe5a6b421744 | 5f9ea8265befea3863b52650876c22df | e76c2ce2088de84d924c241f29988532 | e21d8b99edf24c23e4fe8f906142af7c | fc43bc74ab0bd063662678af849f150f | 1 | 1 | 85191 | 09bc2142f9312d9f4ee79701c4251ef4 | 1 | | 13 | 14 | 15 | 16 | 17 | a7ba7d17a87c9c71ab7fd04b891a659a | 57af0746b5537299e3841c79c7fad763 | bee4e2b1ce18c8b168a062e4f0ddc98e | 18 | dc5d2908cbb94313cbd64fe9b732d337 | 1e758d6014d718d5782c21dc226b2f3a | 42a7640574d1149dd8572efec60e34bf | d3f3302a8e5ab52014bbaba208eae68b | 05b4de1a1e40ba930f4b964df0987540 | 70318 | 26489b7969c560f26a0fe17af09c77ec | 6097cfef91d6863dbc5d29aadb769cf1 | f76190749368b0f63eb6c170087eccf0 | b97fea68a41eb54becd3dd6caeddd0b1 | fd170186e77425e59042d28d9320699d | 1 | 1 | 6230 | e203e8250ef3400de80938c02947d2b1 | 1 | | 19 | 20 | 21 | 22 | 23 | 434bdeae2a813d1a7f045fc1364de13d | f160dd05683cb0a65fe7151d2af571e8 | ca9f08b5bcae19ed7993a4e3016e0608 | 24 | 8505e07a78b5f903e6b3c8d2309c709c | f552a530f41e519e6854eecee490a887 | be47e17884ff379c7a6810991015c4d8 | 3581c2921b160bbf35ff294e255a2bc8 | 2f128c019f2203a63a55fbb0c723745f | 15291 | 061910940aee75bc7da0e43c7df4e784 | c83fcd51472324ae541e6ca4c1044f00 | e21ee0bf8382748b833c7e956e9e4e74 | daa6aa12798eb323ed11b287ff28a63a | 295b6fe5f9d81bcf57bd2041001b0ba6 | 1 | 1 | 68488 | 86e536d6b515fb65c870f08b8b502901 | 0 | | 20 | 25 | 26 | 27 | 28 | 740011ef4d83e0d0958fb6086a36b9a9 | 0cb262cfae085c8f9ea49e73b0888ee7 | e8f02826c5957c5b793dad8215eba552 | 29 | a5c37c350672da8f126667b8baa9f0f4 | dc9b1b9561efc5352015730d817502fa | f1818b503164fd23a50760c7751e099f | 9812a53181be78035fec4298c5439551 | 5958384046314eacfc9eb3040b502769 | 60707 | 3711cacc4727720629327c672f89ccaf | fc9074868aa259f5477a35d3d0cd4773 | 7992af0131786f6230d27fe4b36f5c55 | cdde97182729f2e610e1e3eb4ac6f250 | 39edf94f4552f475b9948809dd1b72c9 | 0 | 0 | 15373 | 9ec471b7ec3fca6f85c3c5db7941bdb4 | 1 | | 21 | 30 | 31 | 32 | 33 | bba7d5984ece182497aed607754ff43b | 9e0d04cd531f69fbe6f5a14dc5ea1ea4 | 809fbb25f2d8bae3442c832904d57a8a | 34 | 8dacb8a875dea2a966004eb3a220119b | db081a1a8f5d495fb7127fd3e76dde62 | 0e2d2631eb85050a42a2b0f0d32d293e | 43976259f14d86663299e513138094d2 | efb0ed0f2f813a81fa2b82e3af2b9026 | 54195 | 25d0726289accd36d24f81d8764c2cd1 | 58ff455fc7da87af6bdbe40a4d7f56df | ba495ad99c843215bc6f4db2f116e44e | f9addac02da891dca05bc9601bfe94f5 | 41cfa63d1495a2dc8306adbc6b5d53d5 | 0 | 0 | 57017 | 7131f153776111c4012b881c774a32c9 | 0 | | 22 | 35 | 36 | 37 | 38 | 27aa614979fd27b10e50b7af18d27243 | e627c331895b976e42c1d44237c7db3e | b26e99bd6771892e4ea0af02bf3ac220 | 39 | 47a4fea52260c1710d177f9005d7aa72 | dcab3d577fdd95bcb4ccb6628d589c3e | 3d7ccf5ef3a6a28141fb8a27824f44bb | 10947d16ae293e1053a6d119910bd562 | ce2dee20cdf5fe9ce6aea2002a3a25fa | 83523 | 00983e4173b9c1841a5c3ab114aba8dd | e574225a7b31fca6d409eebbdd7917f7 | a6dfab015723c63fed130526e82667cf | 5a80862d3dabf5a517a604eea7d6e0b9 | 45c82d7c5c923c0a6439efbddd7949ef | 0 | 0 | 79234 | 6256b023ba0b72975b3da6b7850e8d90 | 0 | | 23 | 40 | 41 | 42 | 43 | 72976c626276be410e98742e9b1d8d63 | 35a41a4fc6fa3bada59389f12e20aecb | 6de519de17bf6e27dd646c4d8180335b | 44 | 83cdcb4ea87ee430df46789c0894adec | c550742f7d2e3dd4245e6cccd1a13a6c | 70459786db9ba48c3a3b97db254757e4 | b326f33f65660d185c443d73bd03fb39 | e917a22b83663ab72a3dc86480b306fd | 62966 | 0b6de4f867fd0c2c8997f723517e0c54 | c6489fe9fd8e8ee3160894119728b631 | b9009ff000444fb62f9473cbeb613886 | 6245526dd930ca9649c44a7bcabc5af8 | f7b00c0b8c3eb0907fe2c25dda1162b5 | 1 | 1 | 85806 | 14bf38d632af210bb80d6188a823eb52 | 0 | | 24 | 45 | 46 | 47 | 48 | 634dd147c24a4ca84822136e80485a8d | f1ebde97c523fd26e138e3b0ff11827b | e32470055f5ee84854f84f48a5d17bcb | 49 | 2afbf35ef5f741cb20bf8cf8f50d09a1 | d0a37901def8969f7f24cfbcfe72ef1a | 27b3a1fad04d75e18ca08f8c1b5a79c7 | 120d054280f6fc7896fd9334af538bb0 | 51a0c6b17beed3d0b85e3f99a63c1973 | 330 | be08ee1279a0bcef3a8ecbec4ee3d668 | 858c916a3d4f10a68cd73025902d2e40 | 49d77c1c8d7ce086e495d898ecab21b1 | c6f9568dbab4f3f7b5fc05f70e3c48f8 | 228ea4947987c907c699c9f4c1a78140 | 1 | 0 | 10855 | fe3b5ef6f2fa5544ad59f0bd1886f630 | 0 | | 25 | 50 | 51 | 52 | 53 | 0e7398cb6dc1f784c794b88773d8627b | 310658cf4f5043909047a18fdd654189 | f4f8c81619eb529d2aa9ef3ba6f27054 | 54 | b2663c20ef41d903949df183139f4112 | a8fe74e90ad96cad2fac89ab00508153 | f2de9813a9017bf3f8e800c9c96f9e03 | 96a207a738cbc51a122e39e48069e3ce | 1ee6f7a4111913542681b977aae18aa1 | 94470 | 1d38c3a6bd72c82f9c83cb338c0b8b72 | 2f52a12ab8c22142e758b9c60c6d3cf4 | 5299e8c8c7ce4b6849d9354798eced0b | 3361336cf0358e0a706dc5cc4940f0de | 83e85985bac8b8fa1d9f4e9448da3c40 | 1 | 1 | 1750 | e074efcd605000c08ea159b493873a5f | 1 | +-----+----+-------------+-------------------+-----------+----------------------------------+----------------------------------+----------------------------------+------------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+---------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+--------------------------+-----------+-------+----------------------------------+----------------------+ 10 rows in set (28.64 sec) mysql> \q Bye root@ubuntu1604lts:/home/ushastry# docker exec -it bug87824 mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 98 Server version: 5.7.19 MySQL Community Server (GPL) Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show databases; use+--------------------+ | Database | +--------------------+ | information_schema | | bug87824 | | mysql | | performance_schema | | sys | +--------------------+ 5 rows in set (0.78 sec) mysql> use bug87824 Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> select * from (select * from patients_query union select * from patients_query_removed) A limit 10; +-----+----+-------------+-------------------+-----------+----------------------------------+----------------------------------+----------------------------------+------------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+---------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+--------------------------+-----------+-------+----------------------------------+----------------------+ | id_ | id | external_id | master_patient_id | list_type | list_name | NameFirst | NameLast | company_id | company_ids | dob | AddrStreet | AddrStreet2 | AddrStreet3 | AddrZip | AddrCity | AddrState | account_number | admit_service_date | location_service | has_patient_list_history | is_active | phone | email | do_not_share_my_data | +-----+----+-------------+-------------------+-----------+----------------------------------+----------------------------------+----------------------------------+------------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+---------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+--------------------------+-----------+-------+----------------------------------+----------------------+ | 1 | 2 | 3 | 4 | 5 | 1eed08ff4e8d4c7d4f76159e34fd4d3b | 5bc6a03939a931741a5f28506561abf5 | 89cb73d71c3d522707a6a1a3dd0bf10f | 6 | ad7c2e9293384a808250ae08651f5944 | eff688a4009afbc1c5bad8124fc7c40c | c96799672155ff182ab6b792ed1ffac2 | 1cbd9b730469b380b015c4cb02e6bde7 | 69d89972a25e8c7c5dee95d9562866da | 96494 | ddafe1e5f86b7575f3a377abd102151c | 9116ac397172ea3a055cdd946588c4cd | 204bb99559d968253c9e0b24b5530d31 | 9f06a50c1a4e2c28cdc759bb83d95fd0 | 4f93812a97a19acbe86d2565776d6494 | 0 | 1 | 83413 | 5ec192c522e69d3b232be2eaac767f7d | 1 | | 7 | 8 | 9 | 10 | 11 | b9ea579eacca31d7bcc1e75ef03b8c4e | f58c6b8fa46cf5e9f50072c5fa4cff76 | ca7d03db2b8faa5e9aa8760cf9692761 | 12 | e6f91b259dbb0505210156e2a2002e24 | 76302149923460ec8560f725adf58076 | f19031b23d6cb831866062693a60fe50 | 0a82d7d775c014fff1a3ba5ca15fd6b4 | a73a4859bd858753a98ddfbb55d28798 | 46032 | 31fb29e21e991c52132efe5a6b421744 | 5f9ea8265befea3863b52650876c22df | e76c2ce2088de84d924c241f29988532 | e21d8b99edf24c23e4fe8f906142af7c | fc43bc74ab0bd063662678af849f150f | 1 | 1 | 85191 | 09bc2142f9312d9f4ee79701c4251ef4 | 1 | | 13 | 14 | 15 | 16 | 17 | a7ba7d17a87c9c71ab7fd04b891a659a | 57af0746b5537299e3841c79c7fad763 | bee4e2b1ce18c8b168a062e4f0ddc98e | 18 | dc5d2908cbb94313cbd64fe9b732d337 | 1e758d6014d718d5782c21dc226b2f3a | 42a7640574d1149dd8572efec60e34bf | d3f3302a8e5ab52014bbaba208eae68b | 05b4de1a1e40ba930f4b964df0987540 | 70318 | 26489b7969c560f26a0fe17af09c77ec | 6097cfef91d6863dbc5d29aadb769cf1 | f76190749368b0f63eb6c170087eccf0 | b97fea68a41eb54becd3dd6caeddd0b1 | fd170186e77425e59042d28d9320699d | 1 | 1 | 6230 | e203e8250ef3400de80938c02947d2b1 | 1 | | 19 | 20 | 21 | 22 | 23 | 434bdeae2a813d1a7f045fc1364de13d | f160dd05683cb0a65fe7151d2af571e8 | ca9f08b5bcae19ed7993a4e3016e0608 | 24 | 8505e07a78b5f903e6b3c8d2309c709c | f552a530f41e519e6854eecee490a887 | be47e17884ff379c7a6810991015c4d8 | 3581c2921b160bbf35ff294e255a2bc8 | 2f128c019f2203a63a55fbb0c723745f | 15291 | 061910940aee75bc7da0e43c7df4e784 | c83fcd51472324ae541e6ca4c1044f00 | e21ee0bf8382748b833c7e956e9e4e74 | daa6aa12798eb323ed11b287ff28a63a | 295b6fe5f9d81bcf57bd2041001b0ba6 | 1 | 1 | 68488 | 86e536d6b515fb65c870f08b8b502901 | 0 | | 20 | 25 | 26 | 27 | 28 | 740011ef4d83e0d0958fb6086a36b9a9 | 0cb262cfae085c8f9ea49e73b0888ee7 | e8f02826c5957c5b793dad8215eba552 | 29 | a5c37c350672da8f126667b8baa9f0f4 | dc9b1b9561efc5352015730d817502fa | f1818b503164fd23a50760c7751e099f | 9812a53181be78035fec4298c5439551 | 5958384046314eacfc9eb3040b502769 | 60707 | 3711cacc4727720629327c672f89ccaf | fc9074868aa259f5477a35d3d0cd4773 | 7992af0131786f6230d27fe4b36f5c55 | cdde97182729f2e610e1e3eb4ac6f250 | 39edf94f4552f475b9948809dd1b72c9 | 0 | 0 | 15373 | 9ec471b7ec3fca6f85c3c5db7941bdb4 | 1 | | 21 | 30 | 31 | 32 | 33 | bba7d5984ece182497aed607754ff43b | 9e0d04cd531f69fbe6f5a14dc5ea1ea4 | 809fbb25f2d8bae3442c832904d57a8a | 34 | 8dacb8a875dea2a966004eb3a220119b | db081a1a8f5d495fb7127fd3e76dde62 | 0e2d2631eb85050a42a2b0f0d32d293e | 43976259f14d86663299e513138094d2 | efb0ed0f2f813a81fa2b82e3af2b9026 | 54195 | 25d0726289accd36d24f81d8764c2cd1 | 58ff455fc7da87af6bdbe40a4d7f56df | ba495ad99c843215bc6f4db2f116e44e | f9addac02da891dca05bc9601bfe94f5 | 41cfa63d1495a2dc8306adbc6b5d53d5 | 0 | 0 | 57017 | 7131f153776111c4012b881c774a32c9 | 0 | | 22 | 35 | 36 | 37 | 38 | 27aa614979fd27b10e50b7af18d27243 | e627c331895b976e42c1d44237c7db3e | b26e99bd6771892e4ea0af02bf3ac220 | 39 | 47a4fea52260c1710d177f9005d7aa72 | dcab3d577fdd95bcb4ccb6628d589c3e | 3d7ccf5ef3a6a28141fb8a27824f44bb | 10947d16ae293e1053a6d119910bd562 | ce2dee20cdf5fe9ce6aea2002a3a25fa | 83523 | 00983e4173b9c1841a5c3ab114aba8dd | e574225a7b31fca6d409eebbdd7917f7 | a6dfab015723c63fed130526e82667cf | 5a80862d3dabf5a517a604eea7d6e0b9 | 45c82d7c5c923c0a6439efbddd7949ef | 0 | 0 | 79234 | 6256b023ba0b72975b3da6b7850e8d90 | 0 | | 23 | 40 | 41 | 42 | 43 | 72976c626276be410e98742e9b1d8d63 | 35a41a4fc6fa3bada59389f12e20aecb | 6de519de17bf6e27dd646c4d8180335b | 44 | 83cdcb4ea87ee430df46789c0894adec | c550742f7d2e3dd4245e6cccd1a13a6c | 70459786db9ba48c3a3b97db254757e4 | b326f33f65660d185c443d73bd03fb39 | e917a22b83663ab72a3dc86480b306fd | 62966 | 0b6de4f867fd0c2c8997f723517e0c54 | c6489fe9fd8e8ee3160894119728b631 | b9009ff000444fb62f9473cbeb613886 | 6245526dd930ca9649c44a7bcabc5af8 | f7b00c0b8c3eb0907fe2c25dda1162b5 | 1 | 1 | 85806 | 14bf38d632af210bb80d6188a823eb52 | 0 | | 24 | 45 | 46 | 47 | 48 | 634dd147c24a4ca84822136e80485a8d | f1ebde97c523fd26e138e3b0ff11827b | e32470055f5ee84854f84f48a5d17bcb | 49 | 2afbf35ef5f741cb20bf8cf8f50d09a1 | d0a37901def8969f7f24cfbcfe72ef1a | 27b3a1fad04d75e18ca08f8c1b5a79c7 | 120d054280f6fc7896fd9334af538bb0 | 51a0c6b17beed3d0b85e3f99a63c1973 | 330 | be08ee1279a0bcef3a8ecbec4ee3d668 | 858c916a3d4f10a68cd73025902d2e40 | 49d77c1c8d7ce086e495d898ecab21b1 | c6f9568dbab4f3f7b5fc05f70e3c48f8 | 228ea4947987c907c699c9f4c1a78140 | 1 | 0 | 10855 | fe3b5ef6f2fa5544ad59f0bd1886f630 | 0 | | 25 | 50 | 51 | 52 | 53 | 0e7398cb6dc1f784c794b88773d8627b | 310658cf4f5043909047a18fdd654189 | f4f8c81619eb529d2aa9ef3ba6f27054 | 54 | b2663c20ef41d903949df183139f4112 | a8fe74e90ad96cad2fac89ab00508153 | f2de9813a9017bf3f8e800c9c96f9e03 | 96a207a738cbc51a122e39e48069e3ce | 1ee6f7a4111913542681b977aae18aa1 | 94470 | 1d38c3a6bd72c82f9c83cb338c0b8b72 | 2f52a12ab8c22142e758b9c60c6d3cf4 | 5299e8c8c7ce4b6849d9354798eced0b | 3361336cf0358e0a706dc5cc4940f0de | 83e85985bac8b8fa1d9f4e9448da3c40 | 1 | 1 | 1750 | e074efcd605000c08ea159b493873a5f | 1 | +-----+----+-------------+-------------------+-----------+----------------------------------+----------------------------------+----------------------------------+------------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+---------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+--------------------------+-----------+-------+----------------------------------+----------------------+ 10 rows in set (29.12 sec) mysql> -- select * from (select * from patients_query union select * from patients_query_removed) A limit 10; ## Ran above query some 15-20 times with no luck