{"id":191,"date":"2016-02-20T15:54:22","date_gmt":"2016-02-20T08:54:22","guid":{"rendered":"http:\/\/www.oopsbox.com\/?p=191"},"modified":"2016-02-20T19:32:08","modified_gmt":"2016-02-20T12:32:08","slug":"re-visit-2","status":"publish","type":"post","link":"https:\/\/www.oopsbox.com\/?p=191","title":{"rendered":"Re-Visit"},"content":{"rendered":"<p>\u0e27\u0e31\u0e19\u0e19\u0e35\u0e49 20 \u0e01\u0e38\u0e21\u0e20\u0e32\u0e1e\u0e31\u0e19\u0e18\u0e4c 2559 \u0e40\u0e1b\u0e47\u0e19\u0e27\u0e31\u0e19\u0e17\u0e35\u0e48<a href=\"https:\/\/th.wikipedia.org\/wiki\/%E0%B8%9E%E0%B8%AD%E0%B8%AA\" target=\"_blank\">\u0e27\u0e07\u0e1e\u0e2d\u0e2a<\/a>\u0e01\u0e25\u0e31\u0e1a\u0e21\u0e32\u0e21\u0e35\u0e40\u0e1e\u0e25\u0e07\u0e43\u0e2b\u0e49\u0e1f\u0e31\u0e07\u0e2d\u0e35\u0e01\u0e04\u0e23\u0e31\u0e49\u0e07\u0e0a\u0e37\u0e48\u0e2d\u0e40\u0e1e\u0e25\u0e07 &#8220;<em>\u0e23\u0e31\u0e01\u0e2d\u0e22\u0e39\u0e48\u0e23\u0e2d\u0e1a\u0e01\u0e32\u0e22<\/em>&#8221; \u0e40\u0e23\u0e32\u0e01\u0e47\u0e23\u0e2d\u0e1f\u0e31\u0e07\u0e40\u0e1e\u0e25\u0e07\u0e19\u0e30 \u0e40\u0e1e\u0e25\u0e07\u0e17\u0e35\u0e48\u0e40\u0e1b\u0e47\u0e19\u0e40\u0e2a\u0e35\u0e22\u0e07\u0e23\u0e49\u0e2d\u0e07\u0e02\u0e2d\u0e07\u0e04\u0e38\u0e13\u0e42\u0e08\u0e49\u00a0 \u0e41\u0e15\u0e48\u0e01\u0e47\u0e21\u0e35\u0e14\u0e23\u0e32\u0e21\u0e48\u0e32\u0e19\u0e34\u0e14\u0e2b\u0e19\u0e48\u0e2d\u0e22\u0e41\u0e15\u0e48\u0e40\u0e23\u0e32\u0e01\u0e47\u0e23\u0e2d\u0e1f\u0e31\u0e07\u0e08\u0e32\u0e01\u0e41\u0e2b\u0e25\u0e48\u0e07 Official \u0e19\u0e30 \u0e23\u0e2d\u0e1f\u0e31\u0e07\u0e41\u0e1a\u0e1a\u0e15\u0e37\u0e48\u0e19\u0e40\u0e15\u0e49\u0e19\u0e40\u0e25\u0e22<\/p>\n<p>\u0e0a\u0e48\u0e27\u0e07\u0e17\u0e35\u0e48\u0e23\u0e2d\u0e1f\u0e31\u0e07\u0e40\u0e1e\u0e25\u0e07\u0e14\u0e49\u0e27\u0e22 \u0e2d\u0e48\u0e32\u0e19\u0e01\u0e32\u0e23\u0e4c\u0e15\u0e39\u0e19\u0e44\u0e1b\u0e40\u0e23\u0e37\u0e48\u0e2d\u0e22\u0e40\u0e1b\u0e37\u0e48\u0e2d\u0e22 (\u0e19\u0e35\u0e48\u0e04\u0e37\u0e2d\u0e0a\u0e48\u0e27\u0e07\u0e27\u0e48\u0e32\u0e07\u0e41\u0e27\u0e4a\u0e1a\u0e19\u0e36\u0e07\u0e08\u0e23\u0e34\u0e07 \u0e46 ) \u0e19\u0e36\u0e01\u0e16\u0e36\u0e07\u0e23\u0e32\u0e22\u0e07\u0e32\u0e19\u0e17\u0e32\u0e07\u0e14\u0e49\u0e32\u0e19\u0e2a\u0e32\u0e18\u0e32\u0e23\u0e13\u0e2a\u0e38\u0e02\u0e23\u0e32\u0e22\u0e07\u0e32\u0e19\u0e2b\u0e19\u0e36\u0e48\u0e07\u0e17\u0e35\u0e48\u0e04\u0e19\u0e02\u0e2d\u0e23\u0e32\u0e22\u0e07\u0e32\u0e19\u0e21\u0e31\u0e01\u0e08\u0e30\u0e1a\u0e2d\u0e01\u0e27\u0e48\u0e32 <em>&#8220;Re-Visit \u0e42\u0e23\u0e04 XX \u0e20\u0e32\u0e22\u0e43\u0e19 YY \u0e0a\u0e31\u0e48\u0e27\u0e42\u0e21\u0e07\/\u0e27\u0e31\u0e19 \u0e19\u0e30&#8221;<\/em> \u0e17\u0e33\u0e19\u0e2d\u0e07\u0e19\u0e35\u0e49 \u0e04\u0e33\u0e27\u0e48\u0e32 Re-Visit \u0e07\u0e48\u0e32\u0e22 \u0e46 \u0e1a\u0e49\u0e32\u0e19 \u0e46 \u0e01\u0e47\u0e04\u0e37\u0e2d\u0e01\u0e32\u0e23\u0e01\u0e25\u0e31\u0e1a\u0e21\u0e32\u0e23\u0e31\u0e01\u0e29\u0e32\u0e0b\u0e49\u0e33\u0e14\u0e49\u0e27\u0e22\u0e42\u0e23\u0e04\u0e40\u0e14\u0e34\u0e21 \u0e08\u0e30\u0e2a\u0e32\u0e40\u0e2b\u0e15\u0e38\u0e2b\u0e19\u0e36\u0e48\u0e07 \u0e2a\u0e2d\u0e07 \u0e2a\u0e32\u0e21 \u0e2b\u0e23\u0e37\u0e2d\u0e2d\u0e30\u0e44\u0e23\u0e01\u0e47\u0e41\u0e25\u0e49\u0e27\u0e41\u0e15\u0e48 \u0e0b\u0e36\u0e48\u0e07\u0e01\u0e25\u0e38\u0e48\u0e21\u0e23\u0e32\u0e22\u0e07\u0e32\u0e19\u0e19\u0e35\u0e49\u0e21\u0e31\u0e01\u0e08\u0e30\u0e16\u0e39\u0e01\u0e19\u0e33\u0e21\u0e32\u0e40\u0e1b\u0e47\u0e19 CQI \u0e02\u0e2d\u0e07\u0e42\u0e23\u0e07\u0e1e\u0e22\u0e32\u0e1a\u0e32\u0e25\u0e14\u0e49\u0e27\u0e22<\/p>\n<p>\u0e40\u0e23\u0e37\u0e48\u0e2d\u0e07\u0e04\u0e38\u0e13\u0e20\u0e32\u0e1e\u0e40\u0e23\u0e37\u0e48\u0e2d\u0e07\u0e19\u0e31\u0e49\u0e19\u0e08\u0e1a\u0e44\u0e1b\u0e2b\u0e25\u0e48\u0e30\u0e01\u0e31\u0e19 \u0e41\u0e15\u0e48\u0e40\u0e23\u0e32\u0e43\u0e19\u0e10\u0e32\u0e19\u0e30\u0e02\u0e2d\u0e07\u0e19\u0e31\u0e01\u0e04\u0e2d\u0e21\u0e1e\u0e34\u0e27\u0e40\u0e15\u0e2d\u0e23\u0e4c\u0e17\u0e35\u0e48\u0e08\u0e30\u0e19\u0e33\u0e40\u0e2a\u0e19\u0e2d\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e15\u0e23\u0e07\u0e19\u0e31\u0e49\u0e19\u0e2d\u0e2d\u0e01\u0e21\u0e32 \u0e21\u0e32\u0e14\u0e39\u0e2b\u0e19\u0e36\u0e48\u0e07\u0e43\u0e19\u0e27\u0e34\u0e18\u0e35\u0e43\u0e19\u0e01\u0e32\u0e23\u0e40\u0e23\u0e35\u0e22\u0e01\u0e14\u0e39\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25 Re-Visit \u0e2d\u0e2d\u0e01\u0e21\u0e32\u0e01\u0e31\u0e19\u0e14\u0e35\u0e01\u0e27\u0e48\u0e32<\/p>\n<p>\u0e2a\u0e21\u0e21\u0e38\u0e15\u0e34\u0e27\u0e48\u0e32\u0e40\u0e23\u0e32\u0e21\u0e35\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e14\u0e31\u0e21\u0e21\u0e35\u0e48 \u0e2b\u0e38\u0e48\u0e19\u0e19\u0e34\u0e48\u0e07 \u0e46 \u0e15\u0e31\u0e49\u0e07\u0e44\u0e27\u0e49\u0e2b\u0e25\u0e48\u0e30\u0e01\u0e31\u0e19 (\u0e40\u0e23\u0e32\u0e43\u0e0a\u0e49\u0e1a\u0e23\u0e34\u0e01\u0e32\u0e23\u0e08\u0e32\u0e01\u0e40\u0e27\u0e47\u0e1a <a href=\"http:\/\/www.generatedata.com\/\" target=\"_blank\">www.generatedata.com<\/a> \u0e40\u0e2b\u0e21\u0e37\u0e2d\u0e19\u0e40\u0e14\u0e34\u0e21 \u0e17\u0e38\u0e01\u0e2d\u0e22\u0e48\u0e32\u0e07\u0e2a\u0e21\u0e21\u0e38\u0e15\u0e34\u0e2b\u0e21\u0e14\u0e19\u0e30 \u0e27\u0e31\u0e19\u0e17\u0e35\u0e48\u0e40\u0e2d\u0e22 \u0e42\u0e23\u0e04\u0e40\u0e2d\u0e22 \u0e40\u0e1c\u0e37\u0e48\u0e2d\u0e2a\u0e07\u0e2a\u0e31\u0e22)<\/p>\n<ul>\n<li><del><\/del>id \u0e40\u0e1b\u0e47\u0e19 PK \u0e40\u0e09\u0e22 \u0e46<\/li>\n<li>HN \u0e40\u0e1b\u0e47\u0e19 Hospital Number \u0e43\u0e04\u0e23\u0e44\u0e1b\u0e42\u0e23\u0e07\u0e1e\u0e22\u0e32\u0e1a\u0e32\u0e25 \u0e01\u0e47\u0e08\u0e30\u0e44\u0e14\u0e49\u0e22\u0e34\u0e19\u0e04\u0e33\u0e19\u0e35\u0e49 \u0e04\u0e37\u0e2d\u0e23\u0e2b\u0e31\u0e2a\u0e17\u0e35\u0e48\u0e42\u0e23\u0e07\u0e1e\u0e22\u0e32\u0e1a\u0e32\u0e25\u0e15\u0e31\u0e49\u0e07\u0e02\u0e36\u0e49\u0e19\u0e41\u0e17\u0e19\u0e15\u0e31\u0e27\u0e1a\u0e38\u0e04\u0e04\u0e25\u0e40\u0e1e\u0e37\u0e48\u0e2d\u0e44\u0e21\u0e48\u0e43\u0e2b\u0e49\u0e0b\u0e49\u0e33\u0e01\u0e31\u0e19\u0e2b\u0e25\u0e48\u0e30\u0e01\u0e31\u0e19<\/li>\n<li>VisitDateTime \u0e40\u0e1b\u0e47\u0e19\u0e27\u0e31\u0e19\u0e17\u0e35\u0e48\u0e40\u0e02\u0e49\u0e32\u0e17\u0e33\u0e01\u0e32\u0e23\u0e23\u0e31\u0e01\u0e29\u0e32<\/li>\n<li>PDX \u0e40\u0e1b\u0e47\u0e19\u0e42\u0e23\u0e04\u0e17\u0e35\u0e48\u0e27\u0e34\u0e19\u0e34\u0e08\u0e09\u0e31\u0e22<\/li>\n<\/ul>\n<p>\u0e2a\u0e21\u0e21\u0e38\u0e15\u0e34\u0e21\u0e35\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e1b\u0e23\u0e30\u0e21\u0e32\u0e13\u0e19\u0e35\u0e49<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">DROP\u00a0TABLE\u00a0IF\u00a0EXISTS\u00a0`Visit`;\r\nCREATE\u00a0TABLE\u00a0IF\u00a0NOT\u00a0EXISTS\u00a0`Visit`\u00a0(\r\n\u00a0\u00a0`id`\u00a0mediumint(9)\u00a0NOT\u00a0NULL,\r\n\u00a0\u00a0`HN`\u00a0varchar(255)\u00a0DEFAULT\u00a0NULL,\r\n\u00a0\u00a0`VisitDateTime`\u00a0datetime(6)\u00a0DEFAULT\u00a0NULL,\r\n\u00a0\u00a0`PDX`\u00a0varchar(255)\u00a0DEFAULT\u00a0NULL\r\n)\u00a0ENGINE=InnoDB\u00a0DEFAULT\u00a0CHARSET=utf8;\r\n\r\nTRUNCATE\u00a0TABLE\u00a0`Visit`;\r\n\r\nINSERT\u00a0DELAYED\u00a0INTO\u00a0`Visit`\u00a0VALUES\r\n(1000,\u00a0'10',\u00a0'2015-12-28\u00a012:03:00.000000',\u00a0'Z133'),\r\n(1001,\u00a0'10',\u00a0'2016-08-01\u00a012:21:00.000000',\u00a0'J069'),\r\n(1002,\u00a0'9',\u00a0'2015-11-25\u00a012:42:00.000000',\u00a0'K30'),\r\n(1003,\u00a0'4',\u00a0'2015-07-13\u00a012:14:00.000000',\u00a0'Z00'),\r\n(1004,\u00a0'10',\u00a0'2015-12-21\u00a012:20:00.000000',\u00a0'U77'),\r\n(1005,\u00a0'4',\u00a0'2015-08-31\u00a012:16:00.000000',\u00a0'K30'),\r\n(1006,\u00a0'3',\u00a0'2016-05-26\u00a012:16:00.000000',\u00a0'Z00'),\r\n(1007,\u00a0'10',\u00a0'2015-04-29\u00a012:10:00.000000',\u00a0'K30'),\r\n(1008,\u00a0'7',\u00a0'2015-02-24\u00a012:59:00.000000',\u00a0'J069'),\r\n(1009,\u00a0'10',\u00a0'2016-06-06\u00a012:11:00.000000',\u00a0'Z00'),\r\n(1010,\u00a0'2',\u00a0'2015-04-21\u00a012:29:00.000000',\u00a0'Z00'),\r\n(1011,\u00a0'5',\u00a0'2016-02-09\u00a012:08:00.000000',\u00a0'Z000'),\r\n(1012,\u00a0'7',\u00a0'2016-07-12\u00a012:09:00.000000',\u00a0'E119'),\r\n(1013,\u00a0'6',\u00a0'2016-02-04\u00a012:29:00.000000',\u00a0'Z480'),\r\n(1014,\u00a0'3',\u00a0'2016-10-31\u00a012:52:00.000000',\u00a0'Z133'),\r\n(1015,\u00a0'7',\u00a0'2015-05-24\u00a012:47:00.000000',\u00a0'Z133'),\r\n(1016,\u00a0'7',\u00a0'2016-01-01\u00a012:34:00.000000',\u00a0'Z000'),\r\n(1017,\u00a0'3',\u00a0'2015-08-01\u00a012:11:00.000000',\u00a0'Z133'),\r\n(1018,\u00a0'8',\u00a0'2016-02-22\u00a012:27:00.000000',\u00a0'U77'),\r\n(1019,\u00a0'6',\u00a0'2015-08-29\u00a012:54:00.000000',\u00a0'Z480'),\r\n(1020,\u00a0'1',\u00a0'2016-02-28\u00a012:43:00.000000',\u00a0'E119'),\r\n(1021,\u00a0'8',\u00a0'2015-10-18\u00a012:19:00.000000',\u00a0'Z480'),\r\n(1022,\u00a0'7',\u00a0'2016-05-29\u00a012:30:00.000000',\u00a0'Z133'),\r\n(1023,\u00a0'1',\u00a0'2016-07-23\u00a012:47:00.000000',\u00a0'J069'),\r\n(1024,\u00a0'3',\u00a0'2015-12-08\u00a012:42:00.000000',\u00a0'Z00'),\r\n(1025,\u00a0'7',\u00a0'2016-12-08\u00a012:45:00.000000',\u00a0'U77'),\r\n(1026,\u00a0'5',\u00a0'2016-12-10\u00a012:42:00.000000',\u00a0'Z480'),\r\n(1027,\u00a0'3',\u00a0'2015-05-21\u00a012:19:00.000000',\u00a0'Z480'),\r\n(1028,\u00a0'7',\u00a0'2016-11-28\u00a012:45:00.000000',\u00a0'U77'),\r\n(1029,\u00a0'7',\u00a0'2015-06-27\u00a012:16:00.000000',\u00a0'J00'),\r\n(1030,\u00a0'10',\u00a0'2015-08-23\u00a012:33:00.000000',\u00a0'E119'),\r\n(1031,\u00a0'5',\u00a0'2015-12-05\u00a012:22:00.000000',\u00a0'Z9912'),\r\n(1032,\u00a0'8',\u00a0'2016-12-27\u00a012:27:00.000000',\u00a0'Z133'),\r\n(1033,\u00a0'1',\u00a0'2016-05-01\u00a012:12:00.000000',\u00a0'E119'),\r\n(1034,\u00a0'9',\u00a0'2015-07-06\u00a012:26:00.000000',\u00a0'Z133'),\r\n(1035,\u00a0'3',\u00a0'2015-07-05\u00a012:49:00.000000',\u00a0'Z9912'),\r\n(1036,\u00a0'3',\u00a0'2015-03-03\u00a012:35:00.000000',\u00a0'J00'),\r\n(1037,\u00a0'1',\u00a0'2016-09-07\u00a012:25:00.000000',\u00a0'U77'),\r\n(1038,\u00a0'8',\u00a0'2016-03-31\u00a012:25:00.000000',\u00a0'K30'),\r\n(1039,\u00a0'9',\u00a0'2016-03-21\u00a012:51:00.000000',\u00a0'Z000'),\r\n(1040,\u00a0'3',\u00a0'2015-03-11\u00a012:38:00.000000',\u00a0'Z480'),\r\n(1041,\u00a0'2',\u00a0'2016-10-12\u00a012:29:00.000000',\u00a0'Z000'),\r\n(1042,\u00a0'4',\u00a0'2016-08-13\u00a012:04:00.000000',\u00a0'E119'),\r\n(1043,\u00a0'8',\u00a0'2015-11-10\u00a012:13:00.000000',\u00a0'E119'),\r\n(1044,\u00a0'5',\u00a0'2016-07-08\u00a012:57:00.000000',\u00a0'Z133'),\r\n(1045,\u00a0'6',\u00a0'2015-05-12\u00a012:05:00.000000',\u00a0'J069'),\r\n(1046,\u00a0'8',\u00a0'2016-01-23\u00a012:27:00.000000',\u00a0'U77'),\r\n(1047,\u00a0'2',\u00a0'2016-01-21\u00a012:03:00.000000',\u00a0'J00'),\r\n(1048,\u00a0'4',\u00a0'2015-12-29\u00a012:38:00.000000',\u00a0'K30'),\r\n(1049,\u00a0'2',\u00a0'2016-10-02\u00a012:26:00.000000',\u00a0'Z133'),\r\n(1050,\u00a0'8',\u00a0'2015-06-07\u00a012:40:00.000000',\u00a0'Z000'),\r\n(1051,\u00a0'10',\u00a0'2015-07-21\u00a012:33:00.000000',\u00a0'Z9912'),\r\n(1052,\u00a0'2',\u00a0'2017-02-08\u00a012:02:00.000000',\u00a0'K30'),\r\n(1053,\u00a0'2',\u00a0'2015-08-26\u00a012:34:00.000000',\u00a0'U77'),\r\n(1054,\u00a0'4',\u00a0'2017-02-05\u00a012:52:00.000000',\u00a0'Z133'),\r\n(1055,\u00a0'7',\u00a0'2016-05-07\u00a012:07:00.000000',\u00a0'J069'),\r\n(1056,\u00a0'2',\u00a0'2016-12-20\u00a012:57:00.000000',\u00a0'Z480'),\r\n(1057,\u00a0'5',\u00a0'2015-04-07\u00a012:39:00.000000',\u00a0'U77'),\r\n(1058,\u00a0'6',\u00a0'2015-08-24\u00a012:52:00.000000',\u00a0'E119'),\r\n(1059,\u00a0'6',\u00a0'2015-08-10\u00a012:54:00.000000',\u00a0'K30'),\r\n(1060,\u00a0'5',\u00a0'2016-01-09\u00a012:19:00.000000',\u00a0'Z000'),\r\n(1061,\u00a0'1',\u00a0'2015-05-26\u00a012:31:00.000000',\u00a0'K30'),\r\n(1062,\u00a0'7',\u00a0'2017-02-05\u00a012:46:00.000000',\u00a0'J00'),\r\n(1063,\u00a0'7',\u00a0'2016-12-24\u00a012:16:00.000000',\u00a0'Z480'),\r\n(1064,\u00a0'1',\u00a0'2016-01-20\u00a012:04:00.000000',\u00a0'Z480'),\r\n(1065,\u00a0'6',\u00a0'2016-01-06\u00a012:38:00.000000',\u00a0'U77'),\r\n(1066,\u00a0'4',\u00a0'2015-12-19\u00a012:56:00.000000',\u00a0'E119'),\r\n(1067,\u00a0'1',\u00a0'2016-11-29\u00a012:37:00.000000',\u00a0'J069'),\r\n(1068,\u00a0'9',\u00a0'2015-03-26\u00a012:36:00.000000',\u00a0'U77'),\r\n(1069,\u00a0'1',\u00a0'2016-08-17\u00a012:01:00.000000',\u00a0'K30'),\r\n(1070,\u00a0'3',\u00a0'2016-02-26\u00a012:42:00.000000',\u00a0'J069'),\r\n(1071,\u00a0'6',\u00a0'2016-08-23\u00a012:17:00.000000',\u00a0'J00'),\r\n(1072,\u00a0'10',\u00a0'2016-03-19\u00a012:54:00.000000',\u00a0'Z9912'),\r\n(1073,\u00a0'1',\u00a0'2017-02-18\u00a012:31:00.000000',\u00a0'Z000'),\r\n(1074,\u00a0'9',\u00a0'2016-02-05\u00a012:51:00.000000',\u00a0'Z480'),\r\n(1075,\u00a0'9',\u00a0'2015-11-14\u00a012:30:00.000000',\u00a0'K30'),\r\n(1076,\u00a0'6',\u00a0'2015-03-23\u00a012:34:00.000000',\u00a0'E119'),\r\n(1077,\u00a0'10',\u00a0'2015-08-26\u00a012:11:00.000000',\u00a0'Z9912'),\r\n(1078,\u00a0'9',\u00a0'2015-05-04\u00a012:58:00.000000',\u00a0'Z480'),\r\n(1079,\u00a0'9',\u00a0'2016-01-04\u00a012:47:00.000000',\u00a0'U77'),\r\n(1080,\u00a0'8',\u00a0'2016-03-28\u00a012:53:00.000000',\u00a0'Z480'),\r\n(1081,\u00a0'6',\u00a0'2016-03-21\u00a012:05:00.000000',\u00a0'Z480'),\r\n(1082,\u00a0'6',\u00a0'2016-07-05\u00a012:16:00.000000',\u00a0'Z000'),\r\n(1083,\u00a0'3',\u00a0'2015-06-19\u00a012:00:00.000000',\u00a0'Z133'),\r\n(1084,\u00a0'1',\u00a0'2016-05-19\u00a012:26:00.000000',\u00a0'Z000'),\r\n(1085,\u00a0'6',\u00a0'2015-12-15\u00a012:05:00.000000',\u00a0'U77'),\r\n(1086,\u00a0'5',\u00a0'2015-05-31\u00a012:28:00.000000',\u00a0'Z9912'),\r\n(1087,\u00a0'2',\u00a0'2015-05-25\u00a012:53:00.000000',\u00a0'K30'),\r\n(1088,\u00a0'6',\u00a0'2016-11-09\u00a012:51:00.000000',\u00a0'J069'),\r\n(1089,\u00a0'5',\u00a0'2016-07-24\u00a012:22:00.000000',\u00a0'J069'),\r\n(1090,\u00a0'10',\u00a0'2016-12-11\u00a012:22:00.000000',\u00a0'J069'),\r\n(1091,\u00a0'1',\u00a0'2015-09-25\u00a012:37:00.000000',\u00a0'J069'),\r\n(1092,\u00a0'9',\u00a0'2015-06-26\u00a012:13:00.000000',\u00a0'Z133'),\r\n(1093,\u00a0'8',\u00a0'2016-10-24\u00a012:21:00.000000',\u00a0'Z000'),\r\n(1094,\u00a0'1',\u00a0'2017-01-25\u00a012:07:00.000000',\u00a0'Z00'),\r\n(1095,\u00a0'5',\u00a0'2015-09-21\u00a012:21:00.000000',\u00a0'E119'),\r\n(1096,\u00a0'6',\u00a0'2017-02-05\u00a012:05:00.000000',\u00a0'Z480'),\r\n(1097,\u00a0'4',\u00a0'2016-05-13\u00a012:52:00.000000',\u00a0'Z9912'),\r\n(1098,\u00a0'7',\u00a0'2016-12-08\u00a012:38:00.000000',\u00a0'Z000'),\r\n(1099,\u00a0'6',\u00a0'2015-08-26\u00a012:00:00.000000',\u00a0'Z00');\r\n\r\n--\r\n--\u00a0Indexes\u00a0for\u00a0table\u00a0`Visit`\r\n--\r\nALTER\u00a0TABLE\u00a0`Visit`\r\n\u00a0\u00a0ADD\u00a0PRIMARY\u00a0KEY\u00a0(`id`);\r\n<\/pre>\n<p>\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25 Re-Visit \u0e43\u0e19\u0e17\u0e35\u0e48\u0e19\u0e35\u0e49\u0e2b\u0e21\u0e32\u0e22\u0e16\u0e36\u0e07\u0e21\u0e35\u0e01\u0e32\u0e23\u0e40\u0e02\u0e49\u0e32\u0e21\u0e32\u0e23\u0e31\u0e01\u0e29\u0e32\u0e0b\u0e49\u0e33 (\u0e43\u0e19\u0e42\u0e23\u0e04\u0e40\u0e14\u0e34\u0e21) \u0e40\u0e0a\u0e48\u0e19<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">+------+------+----------------------------+-------+\r\n|\u00a0id\u00a0\u00a0\u00a0|\u00a0HN\u00a0\u00a0\u00a0|\u00a0VisitDateTime\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0PDX\u00a0\u00a0\u00a0|\r\n+------+------+----------------------------+-------+\r\n|\u00a01033\u00a0|\u00a01\u00a0\u00a0\u00a0\u00a0|\u00a02016-05-01\u00a012:12:00.000000\u00a0|\u00a0E119\u00a0\u00a0|\r\n|\u00a01020\u00a0|\u00a01\u00a0\u00a0\u00a0\u00a0|\u00a02016-02-28\u00a012:43:00.000000\u00a0|\u00a0E119\u00a0\u00a0|\r\n|\u00a01067\u00a0|\u00a01\u00a0\u00a0\u00a0\u00a0|\u00a02016-11-29\u00a012:37:00.000000\u00a0|\u00a0J069\u00a0\u00a0|\r\n|\u00a01023\u00a0|\u00a01\u00a0\u00a0\u00a0\u00a0|\u00a02016-07-23\u00a012:47:00.000000\u00a0|\u00a0J069\u00a0\u00a0|\r\n|\u00a01091\u00a0|\u00a01\u00a0\u00a0\u00a0\u00a0|\u00a02015-09-25\u00a012:37:00.000000\u00a0|\u00a0J069\u00a0\u00a0|\r\n|\u00a01069\u00a0|\u00a01\u00a0\u00a0\u00a0\u00a0|\u00a02016-08-17\u00a012:01:00.000000\u00a0|\u00a0K30\u00a0\u00a0\u00a0|\r\n|\u00a01061\u00a0|\u00a01\u00a0\u00a0\u00a0\u00a0|\u00a02015-05-26\u00a012:31:00.000000\u00a0|\u00a0K30\u00a0\u00a0\u00a0|\r\n|\u00a01037\u00a0|\u00a01\u00a0\u00a0\u00a0\u00a0|\u00a02016-09-07\u00a012:25:00.000000\u00a0|\u00a0U77\u00a0\u00a0\u00a0|\r\n<\/pre>\n<p>\u0e08\u0e30\u0e40\u0e2b\u0e47\u0e19\u0e27\u0e48\u0e32 \u0e2d\u0e35\u0e15\u0e32 HN=1 \u0e21\u0e32\u0e23\u0e31\u0e01\u0e29\u0e32\u0e2b\u0e25\u0e32\u0e22\u0e04\u0e23\u0e31\u0e49\u0e07\u0e41\u0e25\u0e30\u0e1a\u0e32\u0e07\u0e04\u0e23\u0e31\u0e49\u0e07\u0e17\u0e35\u0e48\u0e21\u0e32\u0e01\u0e47\u0e16\u0e39\u0e01\u0e27\u0e34\u0e19\u0e34\u0e08\u0e09\u0e31\u0e22\u0e14\u0e49\u0e27\u0e22\u0e42\u0e23\u0e04\u0e40\u0e14\u0e34\u0e21 \u0e46 \u0e17\u0e35\u0e48\u0e40\u0e04\u0e22\u0e21\u0e32 \u0e1a\u0e32\u0e07\u0e04\u0e23\u0e31\u0e49\u0e07\u0e01\u0e47\u0e44\u0e21\u0e48\u0e0b\u0e49\u0e33 \u0e41\u0e15\u0e48\u0e40\u0e23\u0e32\u0e2a\u0e19\u0e43\u0e08\u0e15\u0e31\u0e27\u0e17\u0e35\u0e48\u0e0b\u0e49\u0e33\u0e2b\u0e25\u0e48\u0e30\u0e01\u0e31\u0e19 \u0e15\u0e32\u0e21\u0e42\u0e08\u0e17\u0e22\u0e4c\u0e17\u0e35\u0e48\u0e27\u0e48\u0e32 <em>&#8220;Re-Visit \u0e42\u0e23\u0e04 XX \u0e20\u0e32\u0e22\u0e43\u0e19 YY \u0e0a\u0e31\u0e48\u0e27\u0e42\u0e21\u0e07\/\u0e27\u0e31\u0e19 \u0e19\u0e30&#8221; <\/em>\u0e27\u0e34\u0e18\u0e35\u0e01\u0e32\u0e23\u0e01\u0e47\u0e04\u0e37\u0e2d \u0e40\u0e23\u0e32\u0e08\u0e30\u0e43\u0e0a\u0e49\u0e01\u0e32\u0e23 JOIN \u0e15\u0e31\u0e27\u0e21\u0e31\u0e19\u0e40\u0e2d\u0e07\u0e2d\u0e2d\u0e01\u0e21\u0e32\u0e40\u0e1e\u0e37\u0e48\u0e2d\u0e2b\u0e32\u0e04\u0e27\u0e32\u0e21\u0e15\u0e48\u0e32\u0e07 \u0e2a\u0e48\u0e27\u0e19\u0e1f\u0e31\u0e07\u0e01\u0e4c\u0e0a\u0e31\u0e48\u0e19 <span class=\"\">TIMESTAMPDIFF<\/span> \u0e01\u0e47\u0e2b\u0e32\u0e04\u0e27\u0e32\u0e21\u0e15\u0e48\u0e32\u0e07\u0e02\u0e2d\u0e07\u0e2a\u0e2d\u0e07\u0e0a\u0e48\u0e27\u0e07\u0e40\u0e27\u0e25\u0e32\u0e43\u0e19\u0e2b\u0e19\u0e48\u0e27\u0e22\u0e17\u0e35\u0e48\u0e01\u0e33\u0e2b\u0e19\u0e14 \u0e25\u0e2d\u0e07\u0e2b\u0e32\u0e2d\u0e48\u0e32\u0e19\u0e40\u0e1e\u0e34\u0e48\u0e21\u0e40\u0e15\u0e34\u0e21\u0e19\u0e30\u0e04\u0e23\u0e31\u0e1a \ud83d\ude1b<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">SELECT \r\n    A.*,\r\n    V.*,\r\n    TIMESTAMPDIFF(DAY, A.VisitDateTime, V.VisitDateTime) AS DayOfReVisit\r\nFROM Visit A \r\n    LEFT JOIN Visit V ON A.HN = V.HN AND A.PDX = V.PDX\r\nWHERE A.VisitDateTime &gt; V.VisitDateTime\r\nORDER BY A.HN;<\/pre>\n<p>\u0e1c\u0e25\u0e25\u0e31\u0e1e\u0e18\u0e4c\u0e01\u0e47\u0e08\u0e30\u0e1b\u0e23\u0e30\u0e21\u0e32\u0e13\u0e19\u0e35\u0e49<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-194\" src=\"https:\/\/www.oopsbox.com\/wp-content\/uploads\/Selection_051.png\" alt=\"Selection_051\" width=\"895\" height=\"470\" srcset=\"https:\/\/www.oopsbox.com\/wp-content\/uploads\/Selection_051.png 895w, https:\/\/www.oopsbox.com\/wp-content\/uploads\/Selection_051-300x158.png 300w, https:\/\/www.oopsbox.com\/wp-content\/uploads\/Selection_051-768x403.png 768w\" sizes=\"auto, (max-width: 895px) 100vw, 895px\" \/><\/p>\n<p>\u0e19\u0e35\u0e48\u0e01\u0e47\u0e41\u0e04\u0e48\u0e2b\u0e19\u0e36\u0e48\u0e07\u0e43\u0e19\u0e2b\u0e25\u0e32\u0e22 \u0e46 \u0e27\u0e34\u0e18\u0e35 \u0e02\u0e2d\u0e43\u0e2b\u0e49\u0e2a\u0e19\u0e38\u0e01\u0e01\u0e31\u0e1a\u0e01\u0e32\u0e23\u0e14\u0e39\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25 \u0e2e\u0e48\u0e32\u0e32\u0e32\u0e32\u0e32<\/p>\n<p>\u0e1b\u0e25. \u0e44\u0e1b\u0e23\u0e2d\u0e1f\u0e31\u0e07\u0e40\u0e1e\u0e25\u0e07\u0e23\u0e31\u0e01\u0e2d\u0e22\u0e39\u0e48\u0e23\u0e2d\u0e1a\u0e01\u0e32\u0e22\u0e14\u0e49\u0e27\u0e22\u0e01\u0e31\u0e19<\/p>\n<p><iframe loading=\"lazy\" title=\"Teaser PAUSE &quot;\u0e23\u0e31\u0e01\u0e2d\u0e22\u0e39\u0e48\u0e23\u0e2d\u0e1a\u0e01\u0e32\u0e22&quot; V.3 friends\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/hvkGCMUklec?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<div id=\"s-share-buttons\" class=\"\"><div class=\"s-single-share\">\n\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"fb-share-button\" data-href=\"https:\/\/www.oopsbox.com\/?p=191\" data-type=\"button_count\"><\/div><\/div><div class=\"s-single-share\"><a href=\"https:\/\/twitter.com\/share\" class=\"twitter-share-button\"><\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/div><div class=\"s-single-share\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"g-plusone\" data-size=\"medium\"><\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div><div class=\"s-single-share\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"\/\/www.pinterest.com\/pin\/create\/button\/\" data-pin-do=\"buttonBookmark\"  data-pin-color=\"red\"><img decoding=\"async\" src=\"\/\/assets.pinterest.com\/images\/pidgets\/pinit_fg_en_rect_red_20.png\" \/><\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<script type=\"text\/javascript\" async defer src=\"\/\/assets.pinterest.com\/js\/pinit.js\"><\/script>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/div><div class=\"s-single-share\">\n\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"mailto:?Subject=Re-Visit&Body=Here%20is%20the%20link%20to%20the%20article:%20https:\/\/www.oopsbox.com\/?p=191\" title=\"Email\" class=\"s3-email\"><img decoding=\"async\" src=\"https:\/\/www.oopsbox.com\/wp-content\/plugins\/simple-social-share\/includes\/..\/images\/share-email.png\"><\/a>\n\t\t\t\t\t\t\t\t\t\t\t<\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>\u0e27\u0e31\u0e19\u0e19\u0e35\u0e49 20 \u0e01\u0e38\u0e21\u0e20\u0e32\u0e1e\u0e31\u0e19\u0e18\u0e4c 2559 \u0e40\u0e1b\u0e47\u0e19\u0e27\u0e31\u0e19\u0e17\u0e35\u0e48\u0e27\u0e07\u0e1e\u0e2d\u0e2a\u0e01\u0e25\u0e31\u0e1a\u0e21\u0e32\u0e21\u0e35\u0e40\u0e1e\u0e25\u0e07\u0e43\u0e2b\u0e49\u0e1f\u0e31\u0e07\u0e2d\u0e35\u0e01\u0e04\u0e23\u0e31\u0e49\u0e07\u0e0a\u0e37\u0e48\u0e2d\u0e40\u0e1e\u0e25\u0e07 &#8220;\u0e23\u0e31\u0e01\u0e2d\u0e22\u0e39\u0e48\u0e23\u0e2d\u0e1a\u0e01\u0e32\u0e22&#8221; \u0e40\u0e23\u0e32\u0e01\u0e47\u0e23\u0e2d\u0e1f\u0e31\u0e07\u0e40\u0e1e\u0e25\u0e07\u0e19\u0e30 \u0e40\u0e1e\u0e25\u0e07\u0e17\u0e35\u0e48\u0e40\u0e1b\u0e47\u0e19\u0e40\u0e2a\u0e35\u0e22\u0e07\u0e23\u0e49\u0e2d\u0e07\u0e02\u0e2d\u0e07\u0e04\u0e38\u0e13\u0e42\u0e08\u0e49  \u0e23\u0e2d\u0e1f\u0e31\u0e07\u0e41\u0e1a\u0e1a\u0e15\u0e37\u0e48\u0e19\u0e40\u0e15\u0e49\u0e19\u0e40\u0e25\u0e22 \u0e0a\u0e48\u0e27\u0e07\u0e17\u0e35\u0e48\u0e23\u0e2d\u0e1f\u0e31\u0e07\u0e40\u0e1e\u0e25\u0e07\u0e14\u0e49\u0e27\u0e22 \u0e2d\u0e48\u0e32\u0e19\u0e01\u0e32\u0e23\u0e4c\u0e15\u0e39\u0e19\u0e44\u0e1b\u0e40\u0e23\u0e37\u0e48\u0e2d\u0e22\u0e40\u0e1b\u0e37\u0e48\u0e2d\u0e22 (\u0e19\u0e35\u0e48\u0e04\u0e37\u0e2d\u0e0a\u0e48\u0e27\u0e07\u0e27\u0e48\u0e32\u0e07\u0e41\u0e27\u0e4a\u0e1a\u0e19\u0e36\u0e07\u0e08\u0e23\u0e34\u0e07 \u0e46 ) \u0e19\u0e36\u0e01\u0e16\u0e36\u0e07\u0e23\u0e32\u0e22\u0e07\u0e32\u0e19\u0e17\u0e32\u0e07\u0e14\u0e49\u0e32\u0e19\u0e2a\u0e32\u0e18\u0e32\u0e23\u0e13\u0e2a\u0e38\u0e02\u0e23\u0e32\u0e22\u0e07\u0e32\u0e19\u0e2b\u0e19\u0e36\u0e48\u0e07\u0e17\u0e35\u0e48\u0e04\u0e19\u0e02\u0e2d\u0e23\u0e32\u0e22\u0e07\u0e32\u0e19\u0e21\u0e31\u0e01\u0e08\u0e30\u0e1a\u0e2d\u0e01\u0e27\u0e48\u0e32 &#8220;Re-Visit \u0e42\u0e23\u0e04 XX \u0e20\u0e32\u0e22\u0e43\u0e19 YY \u0e0a\u0e31\u0e48\u0e27\u0e42\u0e21\u0e07\/\u0e27\u0e31\u0e19 \u0e19\u0e30&#8221; &#8230;<\/p>\n","protected":false},"author":1,"featured_media":195,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[5],"tags":[12,20],"class_list":["post-191","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-mysql","tag-sql","entry"],"views":2955,"_links":{"self":[{"href":"https:\/\/www.oopsbox.com\/index.php?rest_route=\/wp\/v2\/posts\/191","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oopsbox.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oopsbox.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oopsbox.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oopsbox.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=191"}],"version-history":[{"count":8,"href":"https:\/\/www.oopsbox.com\/index.php?rest_route=\/wp\/v2\/posts\/191\/revisions"}],"predecessor-version":[{"id":203,"href":"https:\/\/www.oopsbox.com\/index.php?rest_route=\/wp\/v2\/posts\/191\/revisions\/203"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.oopsbox.com\/index.php?rest_route=\/wp\/v2\/media\/195"}],"wp:attachment":[{"href":"https:\/\/www.oopsbox.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=191"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oopsbox.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=191"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oopsbox.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=191"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}