Array ( [0] => Array ( [file] => /home/r8zf2ak6yfpv/public_html/includes/modules/staff_members/viewer.php [line] => 284 [function] => db_get_by_sql [args] => Array ( [0] => SELECT p.* FROM projects p LEFT JOIN project_categories c ON FIND_IN_SET(c.id, p.project_categories) > 0 WHERE p.visible = 1 AND ( c.id IS NULL OR c.visible = 1 ) AND ( FIND_IN_SET(, p.`staff_members_1`) > 0 OR FIND_IN_SET(, p.`staff_members_2`) > 0 ) ORDER BY p.start_date DESC ) ) [1] => Array ( [file] => /home/r8zf2ak6yfpv/public_html/includes/modules/staff_members/viewer.php [line] => 22 [function] => detail [class] => StaffMembersViewer [object] => StaffMembersViewer Object ( [var_names] => Array ( [0] => called_method_name ) [id] => 77 [staff_member] => [back_button_text] => < BACK TO TEAM [selected_category] => 3 [prevent_listing_link] => [parameters] => Array ( [0] => ) [identifier] => StaffMembersViewer [mod_name] => staff_members_viewer [mod_loc] => staff_members/viewer [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] => [listings_heading1] => Our Team [interests_label] => RESEARCH INTEREST: [staff_sort_order] => last_name [called_method_name] => detail [categories] => Array ( [1] => Array ( [id] => 1 [staff_member_category_id] => 0 [active] => 1 [name] => Primary Science Staff [listing_type] => full [position] => 1 [created] => 2013-10-04 15:50:38 [modified] => 2015-12-30 12:20:30 [_table_name] => staff_member_categories ) [2] => Array ( [id] => 2 [staff_member_category_id] => 0 [active] => 1 [name] => Additional Science Staff [listing_type] => single_line [position] => 2 [created] => 2013-10-04 15:50:53 [modified] => 2015-12-30 12:20:30 [_table_name] => staff_member_categories ) [3] => Array ( [id] => 3 [staff_member_category_id] => 0 [active] => 1 [name] => Senior Management Team [listing_type] => full [position] => 3 [created] => 2014-04-05 09:25:38 [modified] => 2015-12-30 12:20:30 [_table_name] => staff_member_categories ) [4] => Array ( [id] => 4 [staff_member_category_id] => 0 [active] => 1 [name] => Board of Directors [listing_type] => single_line [position] => 4 [created] => 2014-04-06 23:59:55 [modified] => 2015-12-30 12:20:30 [_table_name] => staff_member_categories ) [5] => Array ( [id] => 5 [staff_member_category_id] => 0 [active] => 1 [name] => Scientific Advisory Committee [listing_type] => single_line [position] => 5 [created] => 2014-04-07 00:01:06 [modified] => 2015-12-30 12:20:30 [_table_name] => staff_member_categories ) ) [listings_link] => //www.alaskasealife.org/team [detail_link] => /team [member_name] => ) [type] => -> [args] => Array ( ) ) [2] => Array ( [file] => /home/r8zf2ak6yfpv/public_html/includes/functions.php [line] => 1728 [function] => lc_staff_members_viewer [args] => Array ( [0] => [1] => ) ) [3] => Array ( [file] => /home/r8zf2ak6yfpv/public_html/includes/functions.php [line] => 1651 [function] => cms_load_module [args] => Array ( [0] => staff_members/viewer ) ) [4] => Array ( [file] => /home/r8zf2ak6yfpv/public_html/includes/functions.php [line] => 1602 [function] => process_image_tags [args] => Array ( [0] =>db_get_by_sql: Could not execute query. [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' p.`staff_members_1`) > 0 OR FIND_IN_SET(, p.`staff_members_2`) > 0 ) ...' at line 11][[staff_members/viewer]][1] => ) ) [5] => Array ( [file] => /home/r8zf2ak6yfpv/public_html/includes/functions.php [line] => 1750 [function] => process_tags [args] => Array ( [0] =>[[module_tools/param_setter: staff_members/viewer, listings_heading1, Our Team]] [[module_tools/param_setter: staff_members/viewer, back_button_text, < BACK TO TEAM]] [[module_tools/param_setter: staff_members/viewer, interests_label, RESEARCH INTEREST:]][[module_tools/param_setter: staff_members/viewer, selected_category, 3]] [[module_tools/param_setter: staff_members/viewer, staff_sort_order, last_name]] [[staff_members/viewer]]) ) [6] => Array ( [file] => /home/r8zf2ak6yfpv/public_html/index.php(584) : eval()'d code [line] => 85 [function] => cms_embed_page [args] => Array ( [0] =>[[module_tools/param_setter: staff_members/viewer, listings_heading1, Our Team]] [[module_tools/param_setter: staff_members/viewer, back_button_text, < BACK TO TEAM]] [[module_tools/param_setter: staff_members/viewer, interests_label, RESEARCH INTEREST:]][[module_tools/param_setter: staff_members/viewer, selected_category, 3]] [[module_tools/param_setter: staff_members/viewer, staff_sort_order, last_name]] [[staff_members/viewer]]) ) [7] => Array ( [file] => /home/r8zf2ak6yfpv/public_html/index.php [line] => 584 [function] => eval ) )
SELECT p.* FROM projects p LEFT JOIN project_categories c ON FIND_IN_SET(c.id, p.project_categories) > 0 WHERE p.visible = 1 AND ( c.id IS NULL OR c.visible = 1 ) AND ( FIND_IN_SET(, p.`staff_members_1`) > 0 OR FIND_IN_SET(, p.`staff_members_2`) > 0 ) ORDER BY p.start_date DESC