MYSQL

QUERY

• PHP 7.4.33
• QUERY_STRING=
• q=municipios
• param=inc14
• param2=
• param3=

Session:

Array
(
    [language] => es
    [makedonation] => 
    [counter] => Array
        (
            [adblock] => 0
        )

    [feeds] => Array
        (
        )

    [did_poll] => 
    [resicaso] => Caso
    [sysop] => 
    [colored_list] => 1
    [once_donate] => 1
    [page_loads] => 1
    [flag_referer] => 
    [login_try] => 0
    [lostmail_try] => 0
    [user] => Array
        (
            [key] => 0
            [name] => 
            [email] => 
            [privilege] => 0
            [expire] => 0000-00-00
        )

    [PAYNOW] => Array
        (
            [AMOUNT] => 0
            [PRODUCT] => 
            [PIC] => https://cvcanarias.com/img/cv-logo.png
        )

    [toggle] => Array
        (
            [pwdforget] => 1
        )

)

VARDUMP

array(89) {
  ["_GET"]=>
  array(0) {
  }
  ["_POST"]=>
  array(0) {
  }
  ["_COOKIE"]=>
  array(0) {
  }
  ["_FILES"]=>
  array(0) {
  }
  ["_SESSION"]=>
  &array(1) {
    ["CKWCVC"]=>
    array(16) {
      ["language"]=>
      string(2) "es"
      ["makedonation"]=>
      bool(false)
      ["counter"]=>
      array(1) {
        ["adblock"]=>
        int(0)
      }
      ["feeds"]=>
      array(0) {
      }
      ["did_poll"]=>
      bool(false)
      ["resicaso"]=>
      string(4) "Caso"
      ["sysop"]=>
      bool(false)
      ["colored_list"]=>
      bool(true)
      ["once_donate"]=>
      bool(true)
      ["page_loads"]=>
      int(1)
      ["flag_referer"]=>
      bool(false)
      ["login_try"]=>
      int(0)
      ["lostmail_try"]=>
      int(0)
      ["user"]=>
      array(5) {
        ["key"]=>
        int(0)
        ["name"]=>
        string(0) ""
        ["email"]=>
        string(0) ""
        ["privilege"]=>
        int(0)
        ["expire"]=>
        string(10) "0000-00-00"
      }
      ["PAYNOW"]=>
      array(3) {
        ["AMOUNT"]=>
        float(0)
        ["PRODUCT"]=>
        string(0) ""
        ["PIC"]=>
        string(38) "https://cvcanarias.com/img/cv-logo.png"
      }
      ["toggle"]=>
      array(1) {
        ["pwdforget"]=>
        bool(true)
      }
    }
  }
  ["time_start"]=>
  float(1778530323.7294)
  ["q"]=>
  string(10) "municipios"
  ["param"]=>
  string(5) "inc14"
  ["_REQUEST"]=>
  array(0) {
  }
  ["errorLog"]=>
  string(34) "./errors/20260511211203_errors.log"
  ["ARROW_UP_RED"]=>
  string(49) ""
  ["ARROW_UP_GREEN"]=>
  string(51) ""
  ["ARROW_DOWN_RED"]=>
  string(51) ""
  ["ARROW_DOWN_GREEN"]=>
  string(53) ""
  ["ARROW_EQUAL"]=>
  string(47) ""
  ["FLAG_useDatatables"]=>
  bool(false)
  ["FLAG_useDiskus"]=>
  bool(false)
  ["gLock"]=>
  string(120) ""
  ["aBGcol"]=>
  array(5) {
    [0]=>
    string(7) "#e2efd9"
    [1]=>
    string(7) "#fff2cc"
    [2]=>
    string(7) "#ffab57"
    [3]=>
    string(7) "#ff3e11"
    [4]=>
    string(7) "#7e082a"
  }
  ["aFGcol"]=>
  array(5) {
    [0]=>
    string(7) "#000000"
    [1]=>
    string(7) "#000000"
    [2]=>
    string(7) "#000000"
    [3]=>
    string(7) "#ffffff"
    [4]=>
    string(7) "#ffffff"
  }
  ["dataIT"]=>
  string(5) "d/m/Y"
  ["dataEN"]=>
  string(5) "d/m/Y"
  ["datIT"]=>
  string(3) "d/m"
  ["datEN"]=>
  string(3) "d/m"
  ["halfdate"]=>
  string(3) "d/m"
  ["fulldate"]=>
  string(5) "d/m/Y"
  ["date14"]=>
  string(10) "2026-04-26"
  ["url"]=>
  array(3) {
    [0]=>
    string(0) ""
    [1]=>
    string(10) "municipios"
    [2]=>
    string(5) "inc14"
  }
  ["param2"]=>
  string(0) ""
  ["param3"]=>
  string(0) ""
  ["value1"]=>
  string(8) "el-pinar"
  ["k1"]=>
  int(38901)
  ["ogimage"]=>
  string(13) "fbbannerq.jpg"
  ["ogurl"]=>
  string(44) "https://covid-cvcanarias.project.ckware.com/"
  ["sub"]=>
  string(0) ""
  ["aj"]=>
  string(5) "false"
  ["ss"]=>
  string(0) ""
  ["TITLE"]=>
  string(90) "Seguimiento en tiempo real de la propagación de la COVID-19 en los municipios de Canarias"
  ["is_muni"]=>
  bool(false)
  ["is_isla"]=>
  bool(false)
  ["DAT"]=>
  array(15) {
    ["es_key"]=>
    int(4351)
    ["es_date"]=>
    string(10) "2022-03-19"
    ["es_ccaa"]=>
    string(8) "Canarias"
    ["es_ccaa_iso"]=>
    string(2) "CN"
    ["es_pfizer"]=>
    int(2807838)
    ["es_pfizerp"]=>
    int(232640)
    ["es_az"]=>
    int(455710)
    ["es_moderna"]=>
    int(810350)
    ["es_janssen"]=>
    int(132660)
    ["es_dosis_in"]=>
    int(4439198)
    ["es_dosis_out"]=>
    int(4109009)
    ["es_out_perc"]=>
    string(5) "92.56"
    ["es_1atleast"]=>
    int(1815936)
    ["es_pers"]=>
    int(1744484)
    ["es_pers1"]=>
    int(0)
  }
  ["ttc"]=>
  int(2)
  ["totalrows"]=>
  int(0)
  ["row"]=>
  array(6) {
    ["cv_total"]=>
    string(6) "333243"
    ["cv_active"]=>
    string(5) "13700"
    ["cv_hospital"]=>
    string(3) "188"
    ["cv_uci"]=>
    string(2) "17"
    ["cv_death"]=>
    string(4) "1633"
    ["cv_recover"]=>
    string(6) "317910"
  }
  ["mu_date"]=>
  string(10) "2022-03-29"
  ["today"]=>
  bool(true)
  ["sql"]=>
  string(975) "
    SELECT 
    tm.mn_municipio,
    tm.mn_isla,
    t1.hmun_data AS date, 
    (t1.hmun_cases - t2.hmun_cases) as diff_casi, 
    -- (t1.hmun_cases - t7.hmun_cases) as diff_casi7, 
    -- (t1.hmun_cases - t14.hmun_cases) as diff_casi14, 
    (t1.hmun_cases - t7.hmun_cases)/ GREATEST(1,tm.mn_people)*100000 as ia7, 
    (t1.hmun_cases - t14.hmun_cases)/ GREATEST(1,tm.mn_people)*100000 as ia14 
    FROM ck_hist_muni AS t1 
    LEFT JOIN ck_hist_muni AS t2 ON t2.hmun_mun = t1.hmun_mun AND t2.hmun_data = t1.hmun_data - INTERVAL 1 DAY 
    LEFT JOIN ck_hist_muni AS t7 ON t7.hmun_mun = t1.hmun_mun AND t7.hmun_data = t1.hmun_data - INTERVAL 7 DAY 
    LEFT JOIN ck_hist_muni AS t14 ON t14.hmun_mun = t1.hmun_mun AND t14.hmun_data = t1.hmun_data - INTERVAL 14 DAY 
    LEFT JOIN ck_municipios AS tm ON tm.mn_zip = t1.hmun_mun
    WHERE t1.hmun_data > '2026-04-26' AND t1.hmun_data <> '2026-05-11'
    ORDER BY t1.hmun_data DESC, tm.mn_municipio ASC                     
    "
  ["cv_total"]=>
  string(6) "333243"
  ["cv_death"]=>
  string(4) "1633"
  ["cv_recover"]=>
  string(6) "317910"
  ["cv_hospital"]=>
  string(3) "188"
  ["cv_uci"]=>
  string(2) "17"
  ["now"]=>
  int(1778530323)
  ["your_date"]=>
  int(1580428800)
  ["datediff"]=>
  int(198101523)
  ["firstCovidDays"]=>
  float(2293)
  ["mu_key"]=>
  int(169651)
  ["mu_time"]=>
  string(8) "14:00:33"
  ["mu_isla"]=>
  string(9) "EL HIERRO"
  ["mu_municipio"]=>
  string(9) "EL HIERRO"
  ["mu_people"]=>
  int(11147)
  ["mu_zip"]=>
  string(1) "7"
  ["mu_total"]=>
  int(2065)
  ["mu_pc"]=>
  float(18.53)
  ["mu_death"]=>
  int(8)
  ["mu_heal"]=>
  int(2012)
  ["mu_active"]=>
  int(45)
  ["mu_home"]=>
  int(44)
  ["mu_hosp"]=>
  int(1)
  ["mu_uci"]=>
  int(0)
  ["mu_dias_nc"]=>
  int(1)
  ["mu_cv14d"]=>
  float(924.02)
  ["mu_cv14dh"]=>
  int(103)
  ["mu_cv7d"]=>
  int(51)
  ["mu_cv7dh"]=>
  float(457.52)
  ["mu_tipo_mun"]=>
  string(4) "Caso"
  ["mu_lln1"]=>
  int(0)
  ["mu_lln2"]=>
  int(0)
  ["mu_lltot"]=>
  int(0)
  ["mu_codmun"]=>
  int(0)
  ["mu_provisional"]=>
  int(0)
  ["cv_active"]=>
  string(5) "13700"
  ["readMUdate"]=>
  string(10) "2022-04-01"
  ["aVar"]=>
  array(0) {
  }
  ["menuchoice"]=>
  string(5) "Todos"
  ["fburl"]=>
  string(31) "https%3A%2F%2Fcvcanarias.com%2F"
  ["dtlang"]=>
  string(7) "Spanish"
  ["punto"]=>
  string(1) "."
  ["virgola"]=>
  string(1) ","
}