Data
Year(s)
Date(s)

 

2007 2008 2009 2010 2011 2012 2013 2014 2015 Total
approved 509 412 228 263 315 392 431 611 169 3,330
Total 509 412 228 263 315 392 431 611 169 3,330
Array
(
    [0] => Array
        (
            [query] => select `state_abbr`, `state_name`, count(job_id) AS total from `_job` left join `_zipcode` on `job_zip_new` = `zipcode` where `job_type` = ? and `job_status` = ? and `job_date_remove` >= CURDATE() group by `state_abbr`
            [bindings] => Array
                (
                    [0] => post
                    [1] => approved
                )

            [time] => 2.44
        )

    [1] => Array
        (
            [query] => select YEAR(`job_date_approved`) AS a_id, YEAR(`job_date_approved`) AS a_name, job_status AS b_id, job_status AS b_name, COUNT(1) AS `cross_count` from `_job` where `job_type` = ? and `job_status` = ? group by `a_id`, `b_id`
            [bindings] => Array
                (
                    [0] => post
                    [1] => approved
                )

            [time] => 49.78
        )

)