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 = 20th-anniversary
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] => 0000
[staff_members_1] => 77,33
[staff_members_2] =>
[species] =>
[created] => 2016-10-19 16:02:50
[modified] => 2022-01-28 14:28:19
[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] => 2022-04-20 08:10:39
[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] => 20th-anniversary
[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] => 0000
[staff_members_1] => 77,33
[staff_members_2] =>
[species] =>
[created] => 2016-10-19 16:02:50
[modified] => 2022-01-28 14:28:19
[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] => 2022-04-20 08:10:39
[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] => 0000
[staff_members_1] => 77,33
[staff_members_2] =>
[species] =>
[created] => 2016-10-19 16:02:50
[modified] => 2022-01-28 14:28:19
[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] => 2022-04-20 08:10:39
[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 '20th' in 'where clause']