{"id":15428,"date":"2022-09-01T06:00:00","date_gmt":"2022-08-31T21:00:00","guid":{"rendered":"https:\/\/www.muscle-hypertrophy.com\/?p=15428"},"modified":"2022-07-18T08:30:54","modified_gmt":"2022-07-17T23:30:54","slug":"%e6%84%9f%e5%ba%a6%ef%bc%8c%e7%89%b9%e7%95%b0%e5%ba%a6%e3%82%92%e6%b1%82%e3%82%81%e3%82%8b%e3%83%a6%e3%83%bc%e3%82%b6%e3%83%bc%e5%ae%9a%e7%be%a9%e9%96%a2%e6%95%b0%e3%82%92sql-server%e3%81%a7%e4%bd%9c","status":"publish","type":"post","link":"https:\/\/www.muscle-hypertrophy.com\/?p=15428","title":{"rendered":"\u611f\u5ea6\uff0c\u7279\u7570\u5ea6\u3092\u6c42\u3081\u308b\u30e6\u30fc\u30b6\u30fc\u5b9a\u7fa9\u306e\u30b9\u30ab\u30e9\u30fc\u5024\u95a2\u6570\u3092SQL Server\u3067\u5b9a\u7fa9\u3059\u308b"},"content":{"rendered":"\n<p>\u3000\u524d\u56de\u306e\u8a18\u4e8b\u3067\u306f<a href=\"https:\/\/www.muscle-hypertrophy.com\/?p=15405\" target=\"_blank\" rel=\"noopener\">\u968e\u4e57\u3092\u6c42\u3081\u308b\u30e6\u30fc\u30b6\u30fc\u5b9a\u7fa9\u95a2\u6570<\/a>\u3092\u7d4c\u3066<a href=\"https:\/\/www.muscle-hypertrophy.com\/?p=15412\" target=\"_blank\" rel=\"noopener\">Fisher\u306e\u76f4\u63a5\u78ba\u7387\u3092\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3067\u6c42\u3081\u305f<\/a>\uff0e\u4eca\u56de\u306f\u56db\u5206\u8868\u304b\u3089\u611f\u5ea6\u3068\u7279\u7570\u5ea6\u3092\u6c42\u3081\u305f\u3044\uff0e<\/p>\n<p><!--more--><\/p>\n<h2>\u56db\u5206\u8868\u3068\u306f<\/h2>\n<p>\u3000\u56db\u5206\u8868\u3068\u306f\u8868\u982d\u306b\u771f\u5b9f\u306e\u6709\u7121\uff0c\u8868\u5074\u306b\u691c\u67fb\u306e\u7d50\u679c\u3092\u8a18\u8ff0\u3057\u305f\u8868\u306e\u3053\u3068\u3067\u3042\u308b\uff0e<\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<th style=\"width: 25%;\">\u00a0<\/th>\n<th style=\"width: 25%;\">\u75be\u75c5\u3042\u308a<\/th>\n<th style=\"width: 25%;\">\u75be\u75c5\u306a\u3057<\/th>\n<th style=\"width: 25%;\">\u00a0<\/th>\n<\/tr>\n<tr>\n<th style=\"width: 25%;\">\u691c\u67fb\u967d\u6027<\/th>\n<td style=\"width: 25%;\">a<\/td>\n<td style=\"width: 25%;\">b<\/td>\n<td style=\"width: 25%;\">a+b<\/td>\n<\/tr>\n<tr>\n<th style=\"width: 25%;\">\u691c\u67fb\u9670\u6027<\/th>\n<td style=\"width: 25%;\">c<\/td>\n<td style=\"width: 25%;\">d<\/td>\n<td style=\"width: 25%;\">c+d<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 25%;\">\u00a0<\/td>\n<td style=\"width: 25%;\">a+c<\/td>\n<td style=\"width: 25%;\">b+d<\/td>\n<td style=\"width: 25%;\">N<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>\u611f\u5ea6\uff0c\u7279\u7570\u5ea6\u3068\u306f<\/h2>\n<p>\u3000a+c\u304c\u5b9f\u969b\u306b\u75be\u75c5\u306e\u3042\u308b\u4eba\u6570\uff0ca\u306f\u305d\u306e\u3046\u3061\u691c\u67fb\u3067\u967d\u6027\u3068\u306a\u3063\u305f\u4eba\u6570\u3067\u3042\u308b\uff0e\u611f\u5ea6\u3068\u306fa\/(a+c)\u306e\u3053\u3068\u3067\u3042\u308b\uff0e<\/p>\n<p>\u3000b+d\u304c\u5b9f\u969b\u306b\u75be\u75c5\u306e\u306a\u3044\u4eba\u6570\uff0cd\u306f\u305d\u306e\u3046\u3061\u691c\u67fb\u3067\u9670\u6027\u3068\u306a\u3063\u305f\u4eba\u6570\u3067\u3042\u308b\uff0e\u7279\u7570\u5ea6\u3068\u306fd\/(b+d)\u306e\u3053\u3068\u3067\u3042\u308b\uff0e<\/p>\n<p>\u3000\u3061\u306a\u307f\u306b a\/(a+b) \u3092\u967d\u6027\u7684\u4e2d\u7387\uff0cd\/(c+d) \u3092\u9670\u6027\u7684\u4e2d\u7387\u3068\u3044\u3046\uff0e<\/p>\n<p>\u3000b \u306f\u691c\u67fb\u304c\u967d\u6027\u3067\u3082\u5b9f\u969b\u306b\u306f\u75be\u75c5\u306e\u306a\u3044\u4eba\u6570\u306e\u3053\u3068\u3067\uff0c\u507d\u967d\u6027\u3068\u3044\u3046\uff0e<\/p>\n<p>\u3000c \u306f\u691c\u67fb\u304c\u9670\u6027\u3067\u3082\u5b9f\u969b\u306b\u306f\u75be\u75c5\u306e\u3042\u308b\u4eba\u6570\u306e\u3053\u3068\u3067\uff0c\u507d\u9670\u6027\u3068\u3044\u3046\uff0e<\/p>\n<h2>\u53d7\u4fe1\u8005\u52d5\u4f5c\u7279\u6027\u66f2\u7dda\u3068\u306f<\/h2>\n<p>\u3000Receiver Operating Characteristic curve \u3068\u3044\u3044\uff0c\u982d\u6587\u5b57\u3092\u53d6\u3063\u3066 ROC \u66f2\u7dda\u3068\u3044\u3046\uff0e\u3082\u3068\u3082\u3068\u306f\u30ec\u30fc\u30c0\u30fc\u6280\u8853\u3067\u3042\u3063\u3066\uff0c\u96d1\u97f3\u306e\u4e2d\u304b\u3089\u6575\u6a5f\u3092\u691c\u51fa\u3059\u308b\u53d7\u4fe1\u8005\u306e\u7279\u6027\u3092\u6e2c\u308b\u305f\u3081\u306e\u65b9\u6cd5\u3068\u3057\u3066\u958b\u767a\u3055\u308c\u305f\uff0e\u6a2a\u8ef8\u306b 1 &#8211; \u7279\u7570\u5ea6\uff0c\u7e26\u8ef8\u306b\u611f\u5ea6\u3092\u30d7\u30ed\u30c3\u30c8\u3059\u308b\u3068\u4e0b\u56f3\u306e\u3088\u3046\u306a\u66f2\u7dda\u304c\u63cf\u304b\u308c\u308b\uff0e\u66f2\u7dda\u306f\u539f\u70b9\uff0c(0, 1), (1, 1) \u306e\u7bc4\u56f2\u5185\u306b\u63cf\u304b\u308c\uff0c\u70b9 (0,1) \u306b\u8fd1\u3044\u307b\u3069\u691c\u67fb\u3068\u3057\u3066\u6709\u52b9\u3067\u3042\u308b\u3068\u3055\u308c\u308b\uff0e<\/p>\n<figure id=\"attachment_15329\" aria-describedby=\"caption-attachment-15329\" style=\"width: 525px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/270.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-15329\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/270-1024x1015.png\" alt=\"\u6b7b\u4ea1\u306e\u65e5\u6700\u9ad8\u6c17\u6e29\u306eROC\" width=\"525\" height=\"520\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/270-1024x1015.png 1024w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/270-300x297.png 300w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/270-150x150.png 150w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/270-768x761.png 768w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/270-1536x1523.png 1536w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/270-100x100.png 100w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/270.png 1653w\" sizes=\"auto, (max-width: 525px) 100vw, 525px\" \/><\/a><figcaption id=\"caption-attachment-15329\" class=\"wp-caption-text\">\u6b7b\u4ea1\u306e\u65e5\u6700\u9ad8\u6c17\u6e29\u306eROC<\/figcaption><\/figure>\n<h2>\u611f\u5ea6\uff0c\u7279\u7570\u5ea6\u3092\u6c42\u3081\u308b\u30e6\u30fc\u30b6\u30fc\u5b9a\u7fa9\u306e\u30b9\u30ab\u30e9\u30fc\u5024\u95a2\u6570<\/h2>\n<p>\u3000\u7e70\u308a\u8fd4\u3057\u306b\u306a\u308b\u304c\u611f\u5ea6\u3068\u306f a\/(a+c), \u7279\u7570\u5ea6\u3068\u306f d\/(b+d) \u304c\u5b9a\u7fa9\u3067\u3042\u308b\uff0e\u3053\u308c\u3092SQL Server\u306e\u30e6\u30fc\u30b6\u30fc\u5b9a\u7fa9\u95a2\u6570\u306b\u5b9f\u88c5\u3059\u308b\uff0e<\/p>\n<p>\u3000\u4e0b\u56f3\u306e\u3088\u3046\u306b\u300c\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u300d\u300c\u95a2\u6570\u300d\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u300c\u65b0\u898f\u4f5c\u6210\u300d\u300c\u30b9\u30ab\u30e9\u30fc\u5024\u95a2\u6570&#8230;\u300d\u3078\u3068\u9032\u3080\uff0e<\/p>\n<figure id=\"attachment_15419\" aria-describedby=\"caption-attachment-15419\" style=\"width: 493px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/00-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-15419\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/00-1.png\" alt=\"\u300c\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u300d\u300c\u95a2\u6570\u300d\u300c\u65b0\u898f\u4f5c\u6210\u300d\u300c\u30b9\u30ab\u30e9\u30fc\u5024\u95a2\u6570...\u300d\" width=\"493\" height=\"275\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/00-1.png 493w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/00-1-300x167.png 300w\" sizes=\"auto, (max-width: 493px) 100vw, 493px\" \/><\/a><figcaption id=\"caption-attachment-15419\" class=\"wp-caption-text\">\u300c\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u300d\u300c\u95a2\u6570\u300d\u300c\u65b0\u898f\u4f5c\u6210\u300d\u300c\u30b9\u30ab\u30e9\u30fc\u5024\u95a2\u6570&#8230;\u300d<\/figcaption><\/figure>\n<p>\u3000\u4e0b\u8a18\u30b3\u30fc\u30c9\u3092\u30af\u30a8\u30ea\u30a6\u30a3\u30f3\u30c9\u30a6\u306b\u8a18\u8ff0\u3057\u5b9f\u884c\u3059\u308b\uff0e\u5f15\u6570\u306f\u672c\u6765\u6574\u6570\u578b\u3067\u3042\u308b\u304c\uff0cSQL Server \u3067\u306f\u6574\u6570\u306e\u8a08\u7b97\u7d50\u679c\u306f\u6574\u6570\u306b\u4e38\u3081\u3089\u308c\u308b\u305f\u3081\uff0c\u5272\u308a\u7b97\u306e\u969b\u306b\u554f\u984c\u3068\u306a\u308b\uff0e\u305d\u306e\u305f\u3081\u5f15\u6570\u306e\u30c7\u30fc\u30bf\u578b\u3092\u5c0f\u6570\u578b\u3067\u5b9a\u7fa9\u3057\u3066\u3044\u308b\uff0e\u306a\u304a\uff0cSpecificity \u3092\u6c42\u3081\u308b\u95a2\u6570\u306f\u540d\u524d\u304c\u9055\u3046\u3060\u3051\u3067\uff0c\u3084\u3063\u3066\u3044\u308b\u3053\u3068\u306f\u7b2c\u4e00\u5f15\u6570\u3092\u7b2c\u4e8c\u5f15\u6570\u3067\u5272\u308b\u3060\u3051\u306e\u540c\u3058\u51e6\u7406\u3067\u3042\u308b\uff0e<\/p>\n<ul>\n<li>1\u884c\u76ee USE \u53e5\u3067\u95a2\u6570\u3092\u7d44\u307f\u8fbc\u3080\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u6307\u5b9a\u3059\u308b<\/li>\n<li>3\u884c\u76ee CREATE FUNCTION \u3067\u95a2\u6570\u540d\u3092\u5b9a\u7fa9\u3059\u308b<\/li>\n<li>5\u884c\u76ee\u30686\u884c\u76ee\uff0c\u95a2\u6570\u540d\u306e\u6b21\u306e ( ) \u5185\u3067\u5f15\u6570\u3068\u305d\u306e\u30c7\u30fc\u30bf\u578b\u3092\u5b9a\u7fa9\u3059\u308b\uff0e\u5f15\u6570\u304c\u8907\u6570\u3042\u308b\u5834\u5408\u306f\u30b3\u30f3\u30de\u3067\u533a\u5207\u308b<\/li>\n<li>8\u884c\u76ee RETURNS \u3067\u623b\u308a\u5024\u306e\u30c7\u30fc\u30bf\u578b\u3092\u5b9a\u7fa9\u3059\u308b<\/li>\n<li>10\u884c\u76ee\u4ee5\u964d BEGIN \u304b\u3089 END \u307e\u3067\u3067\u95a2\u6570\u306e\u5185\u5bb9\u3092\u5b9a\u7fa9\u3059\u308b<\/li>\n<li>13\u884c\u76ee RETURN \u3067\u95a2\u6570\u306b\u623b\u308a\u5024\u3092\u4ee3\u5165\u3059\u308b<\/li>\n<\/ul>\n<pre>USE [HeatStrokeDB]\nGO\nCREATE FUNCTION [dbo].[Sensitivity]\n(\n\t@a\tFLOAT,\n\t@b\tFLOAT\n)\nRETURNS FLOAT\nAS\nBEGIN\n\tDECLARE @ResultVar\tFLOAT\n\tSET\t@ResultVar = @a\/@b\n\tRETURN\t@ResultVar\nEND<\/pre>\n<h2>\u611f\u5ea6\uff0c\u7279\u7570\u5ea6\u3092\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u306b\u7d44\u307f\u8fbc\u3080<\/h2>\n<p>\u3000\u3053\u3053\u307e\u3067\u6765\u305f\u3089<a href=\"https:\/\/www.muscle-hypertrophy.com\/?p=15291\" target=\"_blank\" rel=\"noopener\">\u65e5\u6700\u9ad8\u6c17\u6e29\u3068\u71b1\u4e2d\u75c7\u306e\u91cd\u75c7\u5ea6\u5225\u306e\u642c\u9001\u4eba\u54e1\u6570\u3092\u691c\u8a0e\u3059\u308b<\/a>\u3067\u4f7f\u7528\u3057\u305f\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u306b\u3053\u308c\u3089\u306e\u95a2\u6570\u3092\u7d44\u307f\u8fbc\u3093\u3067\u3057\u307e\u304a\u3046\uff0e\u30e6\u30fc\u30b6\u30fc\u5b9a\u7fa9\u95a2\u6570\uff08\u3053\u3053\u3067\u306f Sensitivity \u3042\u308b\u3044\u306f Specificity\uff09\u306e\u524d\u306bdbo.\u3092\u66f8\u304d\u52a0\u3048\u3066\u304a\u304b\u306a\u3044\u3068\uff0c\u300c\u7d44\u307f\u8fbc\u307f\u95a2\u6570\u540d\u3068\u3057\u3066\u8a8d\u8b58\u3055\u308c\u307e\u305b\u3093\u300d\u3068\u3044\u3046\u30a8\u30e9\u30fc\u304c\u51fa\u308b\uff0e<\/p>\n<pre>USE [HeatStrokeDB]\nGO\nALTER PROCEDURE [dbo].[Temperature_Death] \n\t@Temperature int\nAS\nBEGIN\nSELECT\t@Temperature\t\t\t\t\t\t\tAS '\u95be\u5024'\n,\tSUM(CASE WHEN E.[\u50b7\u75c5\u7a0b\u5ea6\uff1a\u6b7b\u4ea1] &gt; 0 AND T.\u65e5\u6700\u9ad8\u6c17\u6e29 &gt;= @Temperature THEN 1 ELSE 0 END)\tAS a\n,\tSUM(CASE WHEN E.[\u50b7\u75c5\u7a0b\u5ea6\uff1a\u6b7b\u4ea1] = 0 AND T.\u65e5\u6700\u9ad8\u6c17\u6e29 &gt;= @Temperature THEN 1 ELSE 0 END)\tAS b\n,\tSUM(CASE WHEN E.[\u50b7\u75c5\u7a0b\u5ea6\uff1a\u6b7b\u4ea1] &gt; 0 AND T.\u65e5\u6700\u9ad8\u6c17\u6e29 &lt;  @Temperature THEN 1 ELSE 0 END)\tAS c\n,\tSUM(CASE WHEN E.[\u50b7\u75c5\u7a0b\u5ea6\uff1a\u6b7b\u4ea1] = 0 AND T.\u65e5\u6700\u9ad8\u6c17\u6e29 &lt;  @Temperature THEN 1 ELSE 0 END)\tAS d\n,\tSUM(CASE WHEN E.[\u50b7\u75c5\u7a0b\u5ea6\uff1a\u6b7b\u4ea1] &gt; 0 THEN 1 ELSE 0 END)\t\tAS 'a+c'\n,\tSUM(CASE WHEN E.[\u50b7\u75c5\u7a0b\u5ea6\uff1a\u6b7b\u4ea1] = 0 THEN 1 ELSE 0 END)\t\tAS 'b+d'\n,\tSUM(CASE WHEN T.\u65e5\u6700\u9ad8\u6c17\u6e29 &gt;= @Temperature THEN 1 ELSE 0 END)\tAS 'a+b'\n,\tSUM(CASE WHEN T.\u65e5\u6700\u9ad8\u6c17\u6e29 &lt;  @Temperature THEN 1 ELSE 0 END)\tAS 'c+d'\n,\tCOUNT(*)\t\t\t\t\t\t\tAS N\n,\tdbo.Sensitivity(SUM(CASE WHEN E.[\u50b7\u75c5\u7a0b\u5ea6\uff1a\u6b7b\u4ea1] &gt; 0 AND T.\u65e5\u6700\u9ad8\u6c17\u6e29 &gt;= @Temperature THEN 1 ELSE 0 END)\n,\tSUM(CASE WHEN E.[\u50b7\u75c5\u7a0b\u5ea6\uff1a\u6b7b\u4ea1] &gt; 0 THEN 1 ELSE 0 END))\t\tAS 'Sensitivity'\n,\tdbo.Specificity(SUM(CASE WHEN E.[\u50b7\u75c5\u7a0b\u5ea6\uff1a\u6b7b\u4ea1] = 0 AND T.\u65e5\u6700\u9ad8\u6c17\u6e29 &lt;  @Temperature THEN 1 ELSE 0 END)\n,\tSUM(CASE WHEN E.[\u50b7\u75c5\u7a0b\u5ea6\uff1a\u6b7b\u4ea1] = 0 THEN 1 ELSE 0 END))\t\tAS 'Specificity'\n,\t1 - dbo.Specificity(SUM(CASE WHEN E.[\u50b7\u75c5\u7a0b\u5ea6\uff1a\u6b7b\u4ea1] = 0 AND T.\u65e5\u6700\u9ad8\u6c17\u6e29 &lt; @Temperature THEN 1 ELSE 0 END)\n,\tSUM(CASE WHEN E.[\u50b7\u75c5\u7a0b\u5ea6\uff1a\u6b7b\u4ea1] = 0 THEN 1 ELSE 0 END))\t\tAS '1-Specificity'\nFROM\tdbo.T_HeatStroke\tAS E\nINNER JOIN\tdbo.T_MaxTemperature\tAS T\nON\tE.\u65e5\u4ed8 = T.\u5e74\u6708\u65e5\nAND\tE.\u90fd\u9053\u5e9c\u770c\u30b3\u30fc\u30c9 = T.\u90fd\u9053\u5e9c\u770c\u30b3\u30fc\u30c9\nEND\nGO<\/pre>\n<h2>\u307e\u3068\u3081<\/h2>\n<p>\u3000SQL Server\u306e\u30e6\u30fc\u30b6\u30fc\u5b9a\u7fa9\u95a2\u6570\u3067\u611f\u5ea6\u3068\u7279\u7570\u5ea6\u3092\u5b9a\u7fa9\u3057\uff0c\u56db\u5206\u8868\u3092\u4f5c\u6210\u3059\u308b\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3092\u5b9a\u7fa9\u3057\u305f\uff0e\u3053\u3053\u304b\u3089ROC\u66f2\u7dda\u3092\u63cf\u304f\u3053\u3068\u304c\u3067\u304d\u308b\uff0e\u95be\u5024\u3092\u6c42\u3081\u308b\u307e\u3067\u3042\u3068\u4e00\u6b69\u3067\u3042\u308b\uff0e<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3000\u524d\u56de\u306e\u8a18\u4e8b\u3067\u306f\u968e\u4e57\u3092\u6c42\u3081\u308b\u30e6\u30fc\u30b6\u30fc\u5b9a\u7fa9\u95a2\u6570\u3092\u7d4c\u3066Fisher\u306e\u76f4\u63a5\u78ba\u7387\u3092\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3067\u6c42\u3081\u305f\uff0e\u4eca\u56de\u306f\u56db\u5206\u8868\u304b\u3089\u611f\u5ea6\u3068\u7279\u7570\u5ea6\u3092\u6c42\u3081\u305f\u3044\uff0e<\/p>\n","protected":false},"author":1,"featured_media":15329,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[11902,11886,11223,11247,5471,11882,7752,3561,3562,2885,4673,4000,11897,9695,11883,11210,4672,11216,11217,2740,6389,2872,3560,7154,2498,7455,2937,11877,3574,32,2499,4555,11876,6542,11895,11894,11904,11901,11896,11211,11905,3549,11220,8386,3542,11899,2487,11903,11900,11888,5063,661,2893,7856,11221,11889,11887,9098,11906,11878,11930,5064,660,659,11230,2965,11880,2588,11891,11893,11890,11892,11898],"class_list":["post-15428","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology","tag-1--2","tag-alter-procedure","tag-begin","tag-case-when","tag-count-2","tag-create-function","tag-declare","tag-else","tag-end","tag-float","tag-from","tag-inner-join","tag-receiver-operating-characteristic-curve","tag-return","tag-returns","tag-roc","tag-select","tag-sensitivity","tag-specificity","tag-sql-server","tag-sum","tag-t-sql","tag-then","tag-use","tag-2498","tag-7455","tag-2937","tag-11877","tag-3574","tag-32","tag-2499","tag-4555","tag-11876","tag-6542","tag-11895","tag-11894","tag-11904","tag-11901","tag-11896","tag-11211","tag-11905","tag-3549","tag-11220","tag-8386","tag-3542","tag-11899","tag-2487","tag-11903","tag-11900","tag-11888","tag-5063","tag-661","tag-2893","tag-7856","tag-11221","tag-11889","tag-11887","tag-9098","tag-11906","tag-11878","tag-11930","tag-5064","tag-660","tag-659","tag-11230","tag-2965","tag-11880","tag-2588","tag-11891","tag-11893","tag-11890","tag-11892","tag-11898"],"_links":{"self":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/15428","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=15428"}],"version-history":[{"count":25,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/15428\/revisions"}],"predecessor-version":[{"id":15567,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/15428\/revisions\/15567"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/media\/15329"}],"wp:attachment":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=15428"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=15428"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=15428"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}