Array
(
    [0] => Array
        (
            [file] => /nfs/c07/h03/mnt/100892/domains/alaskasealife.org/html/includes/modules/projects/explorer.php
            [line] => 266
            [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] => 5
                                )

                            [1] => 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] => 2021-04-01 12:35:14
                                    [all_cat_ids] => 3
                                    [all_cat_positions] => 1
                                    [cat_id] => 3
                                    [cat_name] => Marine Mammals
                                    [position] => 1
                                    [_item_qty] => 5
                                )

                            [2] => 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] => 5
                                )

                            [3] => 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] => 5
                                )

                            [4] => 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] => 5
                                )

                            [5] => 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] => 4
                                )

                            [6] => 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] => 4
                                )

                            [7] => 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] => 4
                                )

                            [8] => 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] => 4
                                )

                            [9] => 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
                                )

                            [10] => 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] => CMS_MYSQL_DATETIME
                    [_date] => CMS_MYSQL_DATE
                    [_time] => CMS_MYSQL_TIME
                    [get_module_url_content_field] => content
                    [form_data_feed] => 
                    [no_multi_form_item_numerator] => 
                    [is_preview] => 
                    [preview_data] => 
                    [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] => 5
                                            [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] => 4
                                            [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] => 5
                                    [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] => 4
                                    [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] => 5
                                )

                            [1] => 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] => 2021-04-01 12:35:14
                                    [all_cat_ids] => 3
                                    [all_cat_positions] => 1
                                    [cat_id] => 3
                                    [cat_name] => Marine Mammals
                                    [position] => 1
                                    [_item_qty] => 5
                                )

                            [2] => 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] => 5
                                )

                            [3] => 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] => 5
                                )

                            [4] => 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] => 5
                                )

                            [5] => 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] => 4
                                )

                            [6] => 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] => 4
                                )

                            [7] => 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] => 4
                                )

                            [8] => 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] => 4
                                )

                            [9] => 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
                                )

                            [10] => 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] => 11
                            [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] => 5
                                        )

                                    [1] => 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] => 2021-04-01 12:35:14
                                            [all_cat_ids] => 3
                                            [all_cat_positions] => 1
                                            [cat_id] => 3
                                            [cat_name] => Marine Mammals
                                            [position] => 1
                                            [_item_qty] => 5
                                        )

                                    [2] => 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] => 5
                                        )

                                    [3] => 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] => 5
                                        )

                                    [4] => 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] => 5
                                        )

                                    [5] => 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] => 4
                                        )

                                    [6] => 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] => 4
                                        )

                                    [7] => 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] => 4
                                        )

                                    [8] => 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] => 4
                                        )

                                    [9] => 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
                                        )

                                    [10] => 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] => CMS_MYSQL_DATETIME
                                    [_date] => CMS_MYSQL_DATE
                                    [_time] => CMS_MYSQL_TIME
                                    [get_module_url_content_field] => content
                                    [form_data_feed] => 
                                    [no_multi_form_item_numerator] => 
                                    [is_preview] => 
                                    [preview_data] => 
                                )

                            [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] => 3
                                        )

                                    [visible] => Array
                                        (
                                            [0] => visible
                                            [1] => 1
                                        )

                                    [archive] => Array
                                        (
                                            [0] => archive
                                            [1] => 1
                                        )

                                    [name] => Array
                                        (
                                            [0] => name
                                            [1] => 253
                                        )

                                    [project_categories] => Array
                                        (
                                            [0] => project_categories
                                            [1] => 253
                                        )

                                    [description] => Array
                                        (
                                            [0] => description
                                            [1] => 252
                                        )

                                    [thumb] => Array
                                        (
                                            [0] => thumb
                                            [1] => 3
                                        )

                                    [project_pages] => Array
                                        (
                                            [0] => project_pages
                                            [1] => 253
                                        )

                                    [start_date] => Array
                                        (
                                            [0] => start_date
                                            [1] => 13
                                        )

                                    [staff_members_1] => Array
                                        (
                                            [0] => staff_members_1
                                            [1] => 253
                                        )

                                    [staff_members_2] => Array
                                        (
                                            [0] => staff_members_2
                                            [1] => 253
                                        )

                                    [species] => Array
                                        (
                                            [0] => species
                                            [1] => 253
                                        )

                                    [created] => Array
                                        (
                                            [0] => created
                                            [1] => 12
                                        )

                                    [modified] => Array
                                        (
                                            [0] => modified
                                            [1] => 12
                                        )

                                    [all_cat_ids] => Array
                                        (
                                            [0] => all_cat_ids
                                            [1] => 253
                                        )

                                    [all_cat_positions] => Array
                                        (
                                            [0] => all_cat_positions
                                            [1] => 253
                                        )

                                    [cat_id] => Array
                                        (
                                            [0] => cat_id
                                            [1] => 3
                                        )

                                    [cat_name] => Array
                                        (
                                            [0] => cat_name
                                            [1] => 253
                                        )

                                    [position] => Array
                                        (
                                            [0] => position
                                            [1] => 3
                                        )

                                    [_item_qty] => Array
                                        (
                                            [0] => _item_qty
                                            [1] => 8
                                        )

                                )

                            [search_fields] => 
                            [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] => Array
                                (
                                )

                        )

                )

            [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