Array
(
    [0] => Array
        (
            [file] => /nfs/c07/h03/mnt/100892/domains/alaskasealife.org/html/includes/modules/projects/explorer.php
            [line] => 270
            [function] => db_get_by_sql
            [args] => Array
                (
                    [0] => 
						SELECT
							a.*
							
						FROM projects a
						LEFT JOIN project_categories b ON FIND_IN_SET(b.id, a.project_categories) > 0
						WHERE a.id = 20120830-Walrus%20Calves%20Pakak%20and%20Mitik%20Entertain%20Each%20Other%20and%20Visitors%20to%20the%20Alaska%20SeaLife%20Center.pdf
						AND a.visible = 1
						AND (b.id IS NULL OR b.visible = 1)
						GROUP BY a.id
					
                )

        )

    [1] => Array
        (
            [file] => /nfs/c07/h03/mnt/100892/domains/alaskasealife.org/html/index.php
            [line] => 542
            [function] => ProjectsExplorer
            [class] => ProjectsExplorer
            [object] => ProjectsExplorer Object
                (
                    [var_names] => Array
                        (
                            [0] => called_method_name
                        )

                    [table_basename] => project
                    [category_parent_field] => 
                    [project_query] => 
				SELECT
					c.*,
					
					CONCAT_WS(',', temp.cat_id) as all_cat_ids,
					CONCAT_WS('-', temp.position) as all_cat_positions, 
					
					temp.* 				
				FROM (
						SELECT
							a.id as cat_id,
							a.name as cat_name,
							
							a.position,
							
							COUNT(b.id) as _item_qty
						FROM project_categories a 
						LEFT JOIN projects b ON FIND_IN_SET(a.id, b.project_categories) > 0
						WHERE a.visible = 1
						AND b.visible = 1
						GROUP BY  a.id
					) as temp
				LEFT JOIN projects c ON FIND_IN_SET(temp.cat_id, c.project_categories) > 0
				WHERE c.id IS NOT NULL
				AND c.visible = 1
				
				GROUP BY c.id
				ORDER BY all_cat_positions, c.name							
			
                    [list_type] => thumb_list
                    [omit_search] => 
                    [page_size] => 24
                    [addl_filter_types] => 
                    [no_auto_category_filter] => 
                    [is_search] => 
                    [projects] => Array
                        (
                            [0] => Array
                                (
                                    [id] => 47
                                    [visible] => 1
                                    [archive] => 0
                                    [name] => Bioenergetics in Steller sea lions
                                    [project_categories] => 3
                                    [description] => 
                                    [thumb] => 62810
                                    [project_pages] => 95,97
                                    [start_date] => 
                                    [staff_members_1] => 77,33
                                    [staff_members_2] => 
                                    [species] => 
                                    [created] => 2016-10-19 16:02:50
                                    [modified] => 2016-11-10 15:01:20
                                    [all_cat_ids] => 3
                                    [all_cat_positions] => 1
                                    [cat_id] => 3
                                    [cat_name] => Marine Mammals
                                    [position] => 1
                                    [_item_qty] => 8
                                )

                            [1] => Array
                                (
                                    [id] => 44
                                    [visible] => 1
                                    [archive] => 0
                                    [name] => Biotelemetry Development
                                    [project_categories] => 3
                                    [description] => Principal Investigator: Dr. Russ Andrews
Collaborators: John Skinner (ASLC), Randy Davis (Texas A&M)
Funding: NOAA, NPRB, ONR [thumb] => 1602 [project_pages] => 33,34,35,36 [start_date] => 0000 [staff_members_1] => 37 [staff_members_2] => [species] => [created] => 2015-04-16 16:34:34 [modified] => 2018-02-16 13:08:54 [all_cat_ids] => 3 [all_cat_positions] => 1 [cat_id] => 3 [cat_name] => Marine Mammals [position] => 1 [_item_qty] => 8 ) [2] => Array ( [id] => 49 [visible] => 1 [archive] => 0 [name] => Physiology and Health of Cooperating Arctic Seals (PHOCAS) [project_categories] => 3 [description] => [thumb] => 154190 [project_pages] => 103,104,105,106 [start_date] => 0000 [staff_members_1] => 150 [staff_members_2] => 73 [species] => [created] => 2016-12-16 11:25:30 [modified] => 2018-12-06 14:18:21 [all_cat_ids] => 3 [all_cat_positions] => 1 [cat_id] => 3 [cat_name] => Marine Mammals [position] => 1 [_item_qty] => 8 ) [3] => Array ( [id] => 37 [visible] => 1 [archive] => 0 [name] => Remote Monitoring [project_categories] => 3 [description] => [thumb] => 4186 [project_pages] => 24,65,66,67 [start_date] => 0000 [staff_members_1] => 12 [staff_members_2] => 72 [species] => [created] => 2014-07-15 13:06:41 [modified] => 2018-12-28 09:51:31 [all_cat_ids] => 3 [all_cat_positions] => 1 [cat_id] => 3 [cat_name] => Marine Mammals [position] => 1 [_item_qty] => 8 ) [4] => Array ( [id] => 42 [visible] => 1 [archive] => 0 [name] => Steller Sea Lion Reproductive Biology [project_categories] => 3 [description] => Collaborators: Renae Sattler, Brandon Russell
[thumb] => 1659 [project_pages] => 29 [start_date] => [staff_members_1] => [staff_members_2] => 73,33 [species] => [created] => 2014-07-15 14:33:17 [modified] => 2016-10-19 15:39:58 [all_cat_ids] => 3 [all_cat_positions] => 1 [cat_id] => 3 [cat_name] => Marine Mammals [position] => 1 [_item_qty] => 8 ) [5] => Array ( [id] => 39 [visible] => 1 [archive] => 0 [name] => Steller Sea Lion Survival and Reproduction [project_categories] => 3 [description] => Principal Investigators: Markus Horning, Jo-Ann Mellish
Collaborators: Terril Efird, John Maniscalco, John Skinner
Status: Active [thumb] => 1650 [project_pages] => 26,68,69,70 [start_date] => [staff_members_1] => 77 [staff_members_2] => [species] => [created] => 2014-07-15 13:48:01 [modified] => 2016-03-01 10:47:43 [all_cat_ids] => 3 [all_cat_positions] => 1 [cat_id] => 3 [cat_name] => Marine Mammals [position] => 1 [_item_qty] => 8 ) [6] => Array ( [id] => 48 [visible] => 1 [archive] => 0 [name] => Survival and Depredation in Harbor Seals [project_categories] => 3 [description] => [thumb] => 1657 [project_pages] => 99,101,102 [start_date] => [staff_members_1] => 77 [staff_members_2] => 33,38 [species] => [created] => 2016-11-10 10:35:47 [modified] => 2016-11-21 15:53:37 [all_cat_ids] => 3 [all_cat_positions] => 1 [cat_id] => 3 [cat_name] => Marine Mammals [position] => 1 [_item_qty] => 8 ) [7] => Array ( [id] => 46 [visible] => 1 [archive] => 0 [name] => Walrus Diets in Bristol Bay [project_categories] => 3 [description] => [thumb] => 6345 [project_pages] => 92,93,94 [start_date] => [staff_members_1] => [staff_members_2] => 9,12 [species] => [created] => 2015-04-24 13:40:19 [modified] => 2015-05-08 16:21:39 [all_cat_ids] => 3 [all_cat_positions] => 1 [cat_id] => 3 [cat_name] => Marine Mammals [position] => 1 [_item_qty] => 8 ) [8] => Array ( [id] => 33 [visible] => 1 [archive] => 0 [name] => Eider Reintroduction Planning [project_categories] => 4 [description] => [thumb] => 11898 [project_pages] => 20,56,57 [start_date] => [staff_members_1] => 2 [staff_members_2] => 9,74,40,7 [species] => [created] => 2014-07-15 12:37:11 [modified] => 2016-02-12 10:15:19 [all_cat_ids] => 4 [all_cat_positions] => 2 [cat_id] => 4 [cat_name] => Birds [position] => 2 [_item_qty] => 5 ) [9] => Array ( [id] => 29 [visible] => 1 [archive] => 0 [name] => Marine Bird Sensitivity to Hydrocarbons [project_categories] => 4 [description] => [thumb] => 2132 [project_pages] => 16,88,89 [start_date] => [staff_members_1] => 2 [staff_members_2] => 74 [species] => [created] => 2014-07-15 12:21:15 [modified] => 2016-02-05 15:41:14 [all_cat_ids] => 4 [all_cat_positions] => 2 [cat_id] => 4 [cat_name] => Birds [position] => 2 [_item_qty] => 5 ) [10] => Array ( [id] => 34 [visible] => 1 [archive] => 0 [name] => SDM for Sustainable Arctic Communities [project_categories] => 4 [description] => [thumb] => 11895 [project_pages] => 21,59,60 [start_date] => [staff_members_1] => 2 [staff_members_2] => 82 [species] => [created] => 2014-07-15 12:47:12 [modified] => 2016-02-05 15:40:19 [all_cat_ids] => 4 [all_cat_positions] => 2 [cat_id] => 4 [cat_name] => Birds [position] => 2 [_item_qty] => 5 ) [11] => Array ( [id] => 31 [visible] => 1 [archive] => 0 [name] => Seabird Habitat Use and Productivity [project_categories] => 4 [description] => [thumb] => 11899 [project_pages] => 18,52,53 [start_date] => [staff_members_1] => 2 [staff_members_2] => 12,40,71,7 [species] => [created] => 2014-07-15 12:30:01 [modified] => 2016-02-12 10:10:14 [all_cat_ids] => 4 [all_cat_positions] => 2 [cat_id] => 4 [cat_name] => Birds [position] => 2 [_item_qty] => 5 ) [12] => Array ( [id] => 30 [visible] => 1 [archive] => 0 [name] => Tracking Eider Diets [project_categories] => 4 [description] => [thumb] => 11900 [project_pages] => 17,49,50 [start_date] => [staff_members_1] => 2 [staff_members_2] => 7 [species] => [created] => 2014-07-15 12:25:04 [modified] => 2016-02-12 10:16:03 [all_cat_ids] => 4 [all_cat_positions] => 2 [cat_id] => 4 [cat_name] => Birds [position] => 2 [_item_qty] => 5 ) [13] => Array ( [id] => 35 [visible] => 1 [archive] => 0 [name] => Bioindicators for Coastal Monitoring [project_categories] => 6 [description] => [thumb] => 11896 [project_pages] => 22,62,63 [start_date] => [staff_members_1] => 2 [staff_members_2] => 9 [species] => [created] => 2014-07-15 12:47:47 [modified] => 2016-02-12 10:14:35 [all_cat_ids] => 6 [all_cat_positions] => 4 [cat_id] => 6 [cat_name] => Other [position] => 4 [_item_qty] => 2 ) [14] => Array ( [id] => 32 [visible] => 1 [archive] => 0 [name] => Conceptual Ecological Modeling [project_categories] => 6 [description] => [thumb] => 11897 [project_pages] => 19,54,55 [start_date] => [staff_members_1] => 2 [staff_members_2] => [species] => [created] => 2014-07-15 12:34:33 [modified] => 2016-02-12 10:09:34 [all_cat_ids] => 6 [all_cat_positions] => 4 [cat_id] => 6 [cat_name] => Other [position] => 4 [_item_qty] => 2 ) ) [primary_fields] => Array ( [id] => int(11) [visible] => tinyint(1) [archive] => tinyint(1) [name] => varchar(255) [project_categories] => varchar(255) [description] => text [thumb] => int(11) [project_pages] => varchar(255) [start_date] => year(4) [staff_members_1] => varchar(255) [staff_members_2] => varchar(255) [species] => varchar(255) [created] => datetime [modified] => datetime ) [category_fields] => Array ( [id] => int(11) [visible] => tinyint(1) [name] => varchar(255) [position] => int(11) [created] => datetime [modified] => datetime ) [has_archive] => [id] => 20120830-Walrus%20Calves%20Pakak%20and%20Mitik%20Entertain%20Each%20Other%20and%20Visitors%20to%20the%20Alaska%20SeaLife%20Center.pdf [project] => [main_link] => [page_id] => [current_categories] => [side_panel] => [date_format] => F, jS Y [search_project_list_label] => Project list [quickview_truncate_length] => 200 [quickview_more_link_text] => Learn More [quickview_module_page] => /science_spotlight [quickview_view_all_link_text] => All Science [module_label] => [parameters] => Array ( [0] => quickview ) [identifier] => ProjectsExplorer [mod_name] => projects_explorer [mod_loc] => projects/explorer [original_action] => quickview [action] => quickview [current_back_state] => 1 [mod_inc] => 0 [is_preprocess] => [lccms_module_js] => [is_mobile] => [datetime] => 2019-03-23 15:31:04 [_date] => 2019-03-23 [_time] => 15:31:04 [form_data_feed] => [no_multi_form_item_numerator] => [called_method_name] => quickview [primary_table] => projects [category_table] => project_categories [pages_table] => project_pages [linkage_column] => project_categories [all_categories] => Array ( [3] => Array ( [id] => 3 [visible] => 1 [name] => Marine Mammals [position] => 1 [created] => 2013-10-07 14:54:26 [modified] => 2015-05-05 18:35:24 [_table_name] => project_categories ) [4] => Array ( [id] => 4 [visible] => 1 [name] => Birds [position] => 2 [created] => 2013-10-07 14:54:37 [modified] => 2015-05-05 18:35:24 [_table_name] => project_categories ) [5] => Array ( [id] => 5 [visible] => 1 [name] => Fish & Invertebrates [position] => 3 [created] => 2013-10-07 14:54:52 [modified] => 2015-05-05 18:35:24 [_table_name] => project_categories ) [6] => Array ( [id] => 6 [visible] => 1 [name] => Other [position] => 4 [created] => 2014-07-15 11:41:45 [modified] => 2015-05-05 18:35:24 [_table_name] => project_categories ) ) [category_position_data] => Array ( [id_column] => [position_column] => [joins] => [cat_qtys] => Array ( [0] => Array ( [qty] => 8 [id] => 3 [visible] => 1 [name] => Marine Mammals [position] => 1 [created] => 2013-10-07 14:54:26 [modified] => 2015-05-05 18:35:24 ) [1] => Array ( [qty] => 5 [id] => 4 [visible] => 1 [name] => Birds [position] => 2 [created] => 2013-10-07 14:54:37 [modified] => 2015-05-05 18:35:24 ) [2] => Array ( [qty] => 0 [id] => 5 [visible] => 1 [name] => Fish & Invertebrates [position] => 3 [created] => 2013-10-07 14:54:52 [modified] => 2015-05-05 18:35:24 ) [3] => Array ( [qty] => 2 [id] => 6 [visible] => 1 [name] => Other [position] => 4 [created] => 2014-07-15 11:41:45 [modified] => 2015-05-05 18:35:24 ) ) ) [category_qty_data] => Array ( [0] => Array ( [qty] => 8 [id] => 3 [visible] => 1 [name] => Marine Mammals [position] => 1 [created] => 2013-10-07 14:54:26 [modified] => 2015-05-05 18:35:24 ) [1] => Array ( [qty] => 5 [id] => 4 [visible] => 1 [name] => Birds [position] => 2 [created] => 2013-10-07 14:54:37 [modified] => 2015-05-05 18:35:24 ) [2] => Array ( [qty] => 0 [id] => 5 [visible] => 1 [name] => Fish & Invertebrates [position] => 3 [created] => 2013-10-07 14:54:52 [modified] => 2015-05-05 18:35:24 ) [3] => Array ( [qty] => 2 [id] => 6 [visible] => 1 [name] => Other [position] => 4 [created] => 2014-07-15 11:41:45 [modified] => 2015-05-05 18:35:24 ) ) [all_projects] => Array ( [0] => Array ( [id] => 47 [visible] => 1 [archive] => 0 [name] => Bioenergetics in Steller sea lions [project_categories] => 3 [description] => [thumb] => 62810 [project_pages] => 95,97 [start_date] => [staff_members_1] => 77,33 [staff_members_2] => [species] => [created] => 2016-10-19 16:02:50 [modified] => 2016-11-10 15:01:20 [all_cat_ids] => 3 [all_cat_positions] => 1 [cat_id] => 3 [cat_name] => Marine Mammals [position] => 1 [_item_qty] => 8 ) [1] => Array ( [id] => 44 [visible] => 1 [archive] => 0 [name] => Biotelemetry Development [project_categories] => 3 [description] => Principal Investigator: Dr. Russ Andrews
Collaborators: John Skinner (ASLC), Randy Davis (Texas A&M)
Funding: NOAA, NPRB, ONR [thumb] => 1602 [project_pages] => 33,34,35,36 [start_date] => 0000 [staff_members_1] => 37 [staff_members_2] => [species] => [created] => 2015-04-16 16:34:34 [modified] => 2018-02-16 13:08:54 [all_cat_ids] => 3 [all_cat_positions] => 1 [cat_id] => 3 [cat_name] => Marine Mammals [position] => 1 [_item_qty] => 8 ) [2] => Array ( [id] => 49 [visible] => 1 [archive] => 0 [name] => Physiology and Health of Cooperating Arctic Seals (PHOCAS) [project_categories] => 3 [description] => [thumb] => 154190 [project_pages] => 103,104,105,106 [start_date] => 0000 [staff_members_1] => 150 [staff_members_2] => 73 [species] => [created] => 2016-12-16 11:25:30 [modified] => 2018-12-06 14:18:21 [all_cat_ids] => 3 [all_cat_positions] => 1 [cat_id] => 3 [cat_name] => Marine Mammals [position] => 1 [_item_qty] => 8 ) [3] => Array ( [id] => 37 [visible] => 1 [archive] => 0 [name] => Remote Monitoring [project_categories] => 3 [description] => [thumb] => 4186 [project_pages] => 24,65,66,67 [start_date] => 0000 [staff_members_1] => 12 [staff_members_2] => 72 [species] => [created] => 2014-07-15 13:06:41 [modified] => 2018-12-28 09:51:31 [all_cat_ids] => 3 [all_cat_positions] => 1 [cat_id] => 3 [cat_name] => Marine Mammals [position] => 1 [_item_qty] => 8 ) [4] => Array ( [id] => 42 [visible] => 1 [archive] => 0 [name] => Steller Sea Lion Reproductive Biology [project_categories] => 3 [description] => Collaborators: Renae Sattler, Brandon Russell
[thumb] => 1659 [project_pages] => 29 [start_date] => [staff_members_1] => [staff_members_2] => 73,33 [species] => [created] => 2014-07-15 14:33:17 [modified] => 2016-10-19 15:39:58 [all_cat_ids] => 3 [all_cat_positions] => 1 [cat_id] => 3 [cat_name] => Marine Mammals [position] => 1 [_item_qty] => 8 ) [5] => Array ( [id] => 39 [visible] => 1 [archive] => 0 [name] => Steller Sea Lion Survival and Reproduction [project_categories] => 3 [description] => Principal Investigators: Markus Horning, Jo-Ann Mellish
Collaborators: Terril Efird, John Maniscalco, John Skinner
Status: Active [thumb] => 1650 [project_pages] => 26,68,69,70 [start_date] => [staff_members_1] => 77 [staff_members_2] => [species] => [created] => 2014-07-15 13:48:01 [modified] => 2016-03-01 10:47:43 [all_cat_ids] => 3 [all_cat_positions] => 1 [cat_id] => 3 [cat_name] => Marine Mammals [position] => 1 [_item_qty] => 8 ) [6] => Array ( [id] => 48 [visible] => 1 [archive] => 0 [name] => Survival and Depredation in Harbor Seals [project_categories] => 3 [description] => [thumb] => 1657 [project_pages] => 99,101,102 [start_date] => [staff_members_1] => 77 [staff_members_2] => 33,38 [species] => [created] => 2016-11-10 10:35:47 [modified] => 2016-11-21 15:53:37 [all_cat_ids] => 3 [all_cat_positions] => 1 [cat_id] => 3 [cat_name] => Marine Mammals [position] => 1 [_item_qty] => 8 ) [7] => Array ( [id] => 46 [visible] => 1 [archive] => 0 [name] => Walrus Diets in Bristol Bay [project_categories] => 3 [description] => [thumb] => 6345 [project_pages] => 92,93,94 [start_date] => [staff_members_1] => [staff_members_2] => 9,12 [species] => [created] => 2015-04-24 13:40:19 [modified] => 2015-05-08 16:21:39 [all_cat_ids] => 3 [all_cat_positions] => 1 [cat_id] => 3 [cat_name] => Marine Mammals [position] => 1 [_item_qty] => 8 ) [8] => Array ( [id] => 33 [visible] => 1 [archive] => 0 [name] => Eider Reintroduction Planning [project_categories] => 4 [description] => [thumb] => 11898 [project_pages] => 20,56,57 [start_date] => [staff_members_1] => 2 [staff_members_2] => 9,74,40,7 [species] => [created] => 2014-07-15 12:37:11 [modified] => 2016-02-12 10:15:19 [all_cat_ids] => 4 [all_cat_positions] => 2 [cat_id] => 4 [cat_name] => Birds [position] => 2 [_item_qty] => 5 ) [9] => Array ( [id] => 29 [visible] => 1 [archive] => 0 [name] => Marine Bird Sensitivity to Hydrocarbons [project_categories] => 4 [description] => [thumb] => 2132 [project_pages] => 16,88,89 [start_date] => [staff_members_1] => 2 [staff_members_2] => 74 [species] => [created] => 2014-07-15 12:21:15 [modified] => 2016-02-05 15:41:14 [all_cat_ids] => 4 [all_cat_positions] => 2 [cat_id] => 4 [cat_name] => Birds [position] => 2 [_item_qty] => 5 ) [10] => Array ( [id] => 34 [visible] => 1 [archive] => 0 [name] => SDM for Sustainable Arctic Communities [project_categories] => 4 [description] => [thumb] => 11895 [project_pages] => 21,59,60 [start_date] => [staff_members_1] => 2 [staff_members_2] => 82 [species] => [created] => 2014-07-15 12:47:12 [modified] => 2016-02-05 15:40:19 [all_cat_ids] => 4 [all_cat_positions] => 2 [cat_id] => 4 [cat_name] => Birds [position] => 2 [_item_qty] => 5 ) [11] => Array ( [id] => 31 [visible] => 1 [archive] => 0 [name] => Seabird Habitat Use and Productivity [project_categories] => 4 [description] => [thumb] => 11899 [project_pages] => 18,52,53 [start_date] => [staff_members_1] => 2 [staff_members_2] => 12,40,71,7 [species] => [created] => 2014-07-15 12:30:01 [modified] => 2016-02-12 10:10:14 [all_cat_ids] => 4 [all_cat_positions] => 2 [cat_id] => 4 [cat_name] => Birds [position] => 2 [_item_qty] => 5 ) [12] => Array ( [id] => 30 [visible] => 1 [archive] => 0 [name] => Tracking Eider Diets [project_categories] => 4 [description] => [thumb] => 11900 [project_pages] => 17,49,50 [start_date] => [staff_members_1] => 2 [staff_members_2] => 7 [species] => [created] => 2014-07-15 12:25:04 [modified] => 2016-02-12 10:16:03 [all_cat_ids] => 4 [all_cat_positions] => 2 [cat_id] => 4 [cat_name] => Birds [position] => 2 [_item_qty] => 5 ) [13] => Array ( [id] => 35 [visible] => 1 [archive] => 0 [name] => Bioindicators for Coastal Monitoring [project_categories] => 6 [description] => [thumb] => 11896 [project_pages] => 22,62,63 [start_date] => [staff_members_1] => 2 [staff_members_2] => 9 [species] => [created] => 2014-07-15 12:47:47 [modified] => 2016-02-12 10:14:35 [all_cat_ids] => 6 [all_cat_positions] => 4 [cat_id] => 6 [cat_name] => Other [position] => 4 [_item_qty] => 2 ) [14] => Array ( [id] => 32 [visible] => 1 [archive] => 0 [name] => Conceptual Ecological Modeling [project_categories] => 6 [description] => [thumb] => 11897 [project_pages] => 19,54,55 [start_date] => [staff_members_1] => 2 [staff_members_2] => [species] => [created] => 2014-07-15 12:34:33 [modified] => 2016-02-12 10:09:34 [all_cat_ids] => 6 [all_cat_positions] => 4 [cat_id] => 6 [cat_name] => Other [position] => 4 [_item_qty] => 2 ) ) [pagination] => Pagination Object ( [inc] => 0 [page] => 1 [size] => 24 [sizes] => Array ( [0] => 12 [1] => 24 [2] => 48 ) [total_records] => 15 [link] => [records] => Array ( [0] => Array ( [id] => 47 [visible] => 1 [archive] => 0 [name] => Bioenergetics in Steller sea lions [project_categories] => 3 [description] => [thumb] => 62810 [project_pages] => 95,97 [start_date] => [staff_members_1] => 77,33 [staff_members_2] => [species] => [created] => 2016-10-19 16:02:50 [modified] => 2016-11-10 15:01:20 [all_cat_ids] => 3 [all_cat_positions] => 1 [cat_id] => 3 [cat_name] => Marine Mammals [position] => 1 [_item_qty] => 8 ) [1] => Array ( [id] => 44 [visible] => 1 [archive] => 0 [name] => Biotelemetry Development [project_categories] => 3 [description] => Principal Investigator: Dr. Russ Andrews
Collaborators: John Skinner (ASLC), Randy Davis (Texas A&M)
Funding: NOAA, NPRB, ONR [thumb] => 1602 [project_pages] => 33,34,35,36 [start_date] => 0000 [staff_members_1] => 37 [staff_members_2] => [species] => [created] => 2015-04-16 16:34:34 [modified] => 2018-02-16 13:08:54 [all_cat_ids] => 3 [all_cat_positions] => 1 [cat_id] => 3 [cat_name] => Marine Mammals [position] => 1 [_item_qty] => 8 ) [2] => Array ( [id] => 49 [visible] => 1 [archive] => 0 [name] => Physiology and Health of Cooperating Arctic Seals (PHOCAS) [project_categories] => 3 [description] => [thumb] => 154190 [project_pages] => 103,104,105,106 [start_date] => 0000 [staff_members_1] => 150 [staff_members_2] => 73 [species] => [created] => 2016-12-16 11:25:30 [modified] => 2018-12-06 14:18:21 [all_cat_ids] => 3 [all_cat_positions] => 1 [cat_id] => 3 [cat_name] => Marine Mammals [position] => 1 [_item_qty] => 8 ) [3] => Array ( [id] => 37 [visible] => 1 [archive] => 0 [name] => Remote Monitoring [project_categories] => 3 [description] => [thumb] => 4186 [project_pages] => 24,65,66,67 [start_date] => 0000 [staff_members_1] => 12 [staff_members_2] => 72 [species] => [created] => 2014-07-15 13:06:41 [modified] => 2018-12-28 09:51:31 [all_cat_ids] => 3 [all_cat_positions] => 1 [cat_id] => 3 [cat_name] => Marine Mammals [position] => 1 [_item_qty] => 8 ) [4] => Array ( [id] => 42 [visible] => 1 [archive] => 0 [name] => Steller Sea Lion Reproductive Biology [project_categories] => 3 [description] => Collaborators: Renae Sattler, Brandon Russell
[thumb] => 1659 [project_pages] => 29 [start_date] => [staff_members_1] => [staff_members_2] => 73,33 [species] => [created] => 2014-07-15 14:33:17 [modified] => 2016-10-19 15:39:58 [all_cat_ids] => 3 [all_cat_positions] => 1 [cat_id] => 3 [cat_name] => Marine Mammals [position] => 1 [_item_qty] => 8 ) [5] => Array ( [id] => 39 [visible] => 1 [archive] => 0 [name] => Steller Sea Lion Survival and Reproduction [project_categories] => 3 [description] => Principal Investigators: Markus Horning, Jo-Ann Mellish
Collaborators: Terril Efird, John Maniscalco, John Skinner
Status: Active [thumb] => 1650 [project_pages] => 26,68,69,70 [start_date] => [staff_members_1] => 77 [staff_members_2] => [species] => [created] => 2014-07-15 13:48:01 [modified] => 2016-03-01 10:47:43 [all_cat_ids] => 3 [all_cat_positions] => 1 [cat_id] => 3 [cat_name] => Marine Mammals [position] => 1 [_item_qty] => 8 ) [6] => Array ( [id] => 48 [visible] => 1 [archive] => 0 [name] => Survival and Depredation in Harbor Seals [project_categories] => 3 [description] => [thumb] => 1657 [project_pages] => 99,101,102 [start_date] => [staff_members_1] => 77 [staff_members_2] => 33,38 [species] => [created] => 2016-11-10 10:35:47 [modified] => 2016-11-21 15:53:37 [all_cat_ids] => 3 [all_cat_positions] => 1 [cat_id] => 3 [cat_name] => Marine Mammals [position] => 1 [_item_qty] => 8 ) [7] => Array ( [id] => 46 [visible] => 1 [archive] => 0 [name] => Walrus Diets in Bristol Bay [project_categories] => 3 [description] => [thumb] => 6345 [project_pages] => 92,93,94 [start_date] => [staff_members_1] => [staff_members_2] => 9,12 [species] => [created] => 2015-04-24 13:40:19 [modified] => 2015-05-08 16:21:39 [all_cat_ids] => 3 [all_cat_positions] => 1 [cat_id] => 3 [cat_name] => Marine Mammals [position] => 1 [_item_qty] => 8 ) [8] => Array ( [id] => 33 [visible] => 1 [archive] => 0 [name] => Eider Reintroduction Planning [project_categories] => 4 [description] => [thumb] => 11898 [project_pages] => 20,56,57 [start_date] => [staff_members_1] => 2 [staff_members_2] => 9,74,40,7 [species] => [created] => 2014-07-15 12:37:11 [modified] => 2016-02-12 10:15:19 [all_cat_ids] => 4 [all_cat_positions] => 2 [cat_id] => 4 [cat_name] => Birds [position] => 2 [_item_qty] => 5 ) [9] => Array ( [id] => 29 [visible] => 1 [archive] => 0 [name] => Marine Bird Sensitivity to Hydrocarbons [project_categories] => 4 [description] => [thumb] => 2132 [project_pages] => 16,88,89 [start_date] => [staff_members_1] => 2 [staff_members_2] => 74 [species] => [created] => 2014-07-15 12:21:15 [modified] => 2016-02-05 15:41:14 [all_cat_ids] => 4 [all_cat_positions] => 2 [cat_id] => 4 [cat_name] => Birds [position] => 2 [_item_qty] => 5 ) [10] => Array ( [id] => 34 [visible] => 1 [archive] => 0 [name] => SDM for Sustainable Arctic Communities [project_categories] => 4 [description] => [thumb] => 11895 [project_pages] => 21,59,60 [start_date] => [staff_members_1] => 2 [staff_members_2] => 82 [species] => [created] => 2014-07-15 12:47:12 [modified] => 2016-02-05 15:40:19 [all_cat_ids] => 4 [all_cat_positions] => 2 [cat_id] => 4 [cat_name] => Birds [position] => 2 [_item_qty] => 5 ) [11] => Array ( [id] => 31 [visible] => 1 [archive] => 0 [name] => Seabird Habitat Use and Productivity [project_categories] => 4 [description] => [thumb] => 11899 [project_pages] => 18,52,53 [start_date] => [staff_members_1] => 2 [staff_members_2] => 12,40,71,7 [species] => [created] => 2014-07-15 12:30:01 [modified] => 2016-02-12 10:10:14 [all_cat_ids] => 4 [all_cat_positions] => 2 [cat_id] => 4 [cat_name] => Birds [position] => 2 [_item_qty] => 5 ) [12] => Array ( [id] => 30 [visible] => 1 [archive] => 0 [name] => Tracking Eider Diets [project_categories] => 4 [description] => [thumb] => 11900 [project_pages] => 17,49,50 [start_date] => [staff_members_1] => 2 [staff_members_2] => 7 [species] => [created] => 2014-07-15 12:25:04 [modified] => 2016-02-12 10:16:03 [all_cat_ids] => 4 [all_cat_positions] => 2 [cat_id] => 4 [cat_name] => Birds [position] => 2 [_item_qty] => 5 ) [13] => Array ( [id] => 35 [visible] => 1 [archive] => 0 [name] => Bioindicators for Coastal Monitoring [project_categories] => 6 [description] => [thumb] => 11896 [project_pages] => 22,62,63 [start_date] => [staff_members_1] => 2 [staff_members_2] => 9 [species] => [created] => 2014-07-15 12:47:47 [modified] => 2016-02-12 10:14:35 [all_cat_ids] => 6 [all_cat_positions] => 4 [cat_id] => 6 [cat_name] => Other [position] => 4 [_item_qty] => 2 ) [14] => Array ( [id] => 32 [visible] => 1 [archive] => 0 [name] => Conceptual Ecological Modeling [project_categories] => 6 [description] => [thumb] => 11897 [project_pages] => 19,54,55 [start_date] => [staff_members_1] => 2 [staff_members_2] => [species] => [created] => 2014-07-15 12:34:33 [modified] => 2016-02-12 10:09:34 [all_cat_ids] => 6 [all_cat_positions] => 4 [cat_id] => 6 [cat_name] => Other [position] => 4 [_item_qty] => 2 ) ) [no_limit_sql] => SELECT c.*, CONCAT_WS(',', temp.cat_id) as all_cat_ids, CONCAT_WS('-', temp.position) as all_cat_positions, temp.* FROM ( SELECT a.id as cat_id, a.name as cat_name, a.position, COUNT(b.id) as _item_qty FROM project_categories a LEFT JOIN projects b ON FIND_IN_SET(a.id, b.project_categories) > 0 WHERE a.visible = 1 AND b.visible = 1 GROUP BY a.id ) as temp LEFT JOIN projects c ON FIND_IN_SET(temp.cat_id, c.project_categories) > 0 WHERE c.id IS NOT NULL AND c.visible = 1 GROUP BY c.id ORDER BY all_cat_positions, c.name [no_limit] => [sql_pre_search] => SELECT c.*, CONCAT_WS(',', temp.cat_id) as all_cat_ids, CONCAT_WS('-', temp.position) as all_cat_positions, temp.* FROM ( SELECT a.id as cat_id, a.name as cat_name, a.position, COUNT(b.id) as _item_qty FROM project_categories a LEFT JOIN projects b ON FIND_IN_SET(a.id, b.project_categories) > 0 WHERE a.visible = 1 AND b.visible = 1 GROUP BY a.id ) as temp LEFT JOIN projects c ON FIND_IN_SET(temp.cat_id, c.project_categories) > 0 WHERE c.id IS NOT NULL AND c.visible = 1 GROUP BY c.id ORDER BY all_cat_positions, c.name [sql_level] => 0 [table] => projects [table_alias] => projects [go_to_record] => [link_html] => [link_inc] => [no_back_state] => 1 [cms_mod] => CMS_Module Object ( [parameters] => Array ( [0] => ) [identifier] => CMS_Module [mod_name] => c_m_s__module [mod_loc] => c_m_s__module_ [original_action] => [action] => [current_back_state] => 1 [mod_inc] => 1 [is_preprocess] => [lccms_module_js] => [is_mobile] => [datetime] => 2019-03-23 15:31:04 [_date] => 2019-03-23 [_time] => 15:31:04 [form_data_feed] => [no_multi_form_item_numerator] => ) [mysql_ini_vars] => [mysql_ini_vars_results] => [class_prefix] => projects_ [table_name_proper] => Projects [table_name_proper_sing] => Project [no_admin_add_button] => [table_row_inc] => [default_sort] => all_cat_positions, c.name [default_sort_dir] => [link_start] => [all_fields] => Array ( [id] => Array ( [0] => id [1] => int ) [visible] => Array ( [0] => visible [1] => int ) [archive] => Array ( [0] => archive [1] => int ) [name] => Array ( [0] => name [1] => string ) [project_categories] => Array ( [0] => project_categories [1] => string ) [description] => Array ( [0] => description [1] => blob ) [thumb] => Array ( [0] => thumb [1] => int ) [project_pages] => Array ( [0] => project_pages [1] => string ) [start_date] => Array ( [0] => start_date [1] => year ) [staff_members_1] => Array ( [0] => staff_members_1 [1] => string ) [staff_members_2] => Array ( [0] => staff_members_2 [1] => string ) [species] => Array ( [0] => species [1] => string ) [created] => Array ( [0] => created [1] => datetime ) [modified] => Array ( [0] => modified [1] => datetime ) [all_cat_ids] => Array ( [0] => all_cat_ids [1] => string ) [all_cat_positions] => Array ( [0] => all_cat_positions [1] => string ) [cat_id] => Array ( [0] => cat_id [1] => int ) [cat_name] => Array ( [0] => cat_name [1] => string ) [position] => Array ( [0] => position [1] => int ) [_item_qty] => Array ( [0] => _item_qty [1] => int ) ) [search_fields] => Array ( [0] => name [1] => project_categories [2] => description [3] => project_pages [4] => staff_members_1 [5] => staff_members_2 [6] => species [7] => all_cat_ids [8] => all_cat_positions [9] => cat_name ) [search_all_fields] => [omit_from_search_fields] => Array ( ) [integer_search_fields] => [search_field_name_key] => pagination_search0 [search_option_key] => [search_by_letter_key] => pagination_search_by_letter0 [show_search_count] => [no_search_term] => [no_search_encoding] => [hide_date_search] => [date_search_fields] => [view_all_remove_vars] => [week_search_range_start] => Sun [week_search_range_end] => Sat [week_search_range_str] => ( Sun-Sat ) [date_search_time] => [search_filter_options] => [search_filter_options_field] => [show_search_by_letter] => [search_by_letter_field_name] => [search_strip_link_sub_pages] => [search_uses_advanced_toggle] => [filter_by_fields] => Array ( ) [filter_by_fields_delimiter] => , [filter_by_link_up] => Array ( [project_categories] => project_categories ) [filter_by_link_up_only_used_options] => 1 [csv_export] => [related_field_data] => Array ( ) [related_value_data] => Array ( ) [no_order_by] => [add_on_order] => [table_field_options] => ) ) [type] => -> [args] => Array ( [0] => quickview ) ) )
db_get_by_sql: Could not execute query. [Unknown column 'Walrus' in 'where clause']
SELECT a.* FROM projects a LEFT JOIN project_categories b ON FIND_IN_SET(b.id, a.project_categories) > 0 WHERE a.id = 20120830-Walrus%20Calves%20Pakak%20and%20Mitik%20Entertain%20Each%20Other%20and%20Visitors%20to%20the%20Alaska%20SeaLife%20Center.pdf AND a.visible = 1 AND (b.id IS NULL OR b.visible = 1) GROUP BY a.id