Meet Our Subject Librarians

user warning: Too many tables; MySQL can only use 61 tables in a join query: SELECT DISTINCT(node.nid) AS nid, node_data_field_display_image.field_display_image_fid AS node_data_field_display_image_field_display_image_fid, node_data_field_display_image.field_display_image_list AS node_data_field_display_image_field_display_image_list, node_data_field_display_image.field_display_image_data AS node_data_field_display_image_field_display_image_data, node.type AS node_type, node.vid AS node_vid, node.title AS node_title, node_data_field_title.field_title_value AS node_data_field_title_field_title_value, node_data_field_title.field_title_format AS node_data_field_title_field_title_format, node_revisions.body AS node_revisions_body, node_revisions.format AS node_revisions_format, term_data.name AS term_data_name, term_data.vid AS term_data_vid, term_data.tid AS term_data_tid, node_data_field_lastname.field_lastname_value AS node_data_field_lastname_field_lastname_value, RAND() AS _random FROM node node LEFT JOIN term_node term_node_value_0 ON node.vid = term_node_value_0.vid AND term_node_value_0.tid = 269 LEFT JOIN term_node term_node_value_1 ON node.vid = term_node_value_1.vid AND term_node_value_1.tid = 333 LEFT JOIN term_node term_node_value_2 ON node.vid = term_node_value_2.vid AND term_node_value_2.tid = 270 LEFT JOIN term_node term_node_value_3 ON node.vid = term_node_value_3.vid AND term_node_value_3.tid = 335 LEFT JOIN term_node term_node_value_4 ON node.vid = term_node_value_4.vid AND term_node_value_4.tid = 327 LEFT JOIN term_node term_node_value_5 ON node.vid = term_node_value_5.vid AND term_node_value_5.tid = 271 LEFT JOIN term_node term_node_value_6 ON node.vid = term_node_value_6.vid AND term_node_value_6.tid = 272 LEFT JOIN term_node term_node_value_7 ON node.vid = term_node_value_7.vid AND term_node_value_7.tid = 273 LEFT JOIN term_node term_node_value_8 ON node.vid = term_node_value_8.vid AND term_node_value_8.tid = 336 LEFT JOIN term_node term_node_value_9 ON node.vid = term_node_value_9.vid AND term_node_value_9.tid = 344 LEFT JOIN term_node term_node_value_10 ON node.vid = term_node_value_10.vid AND term_node_value_10.tid = 274 LEFT JOIN term_node term_node_value_11 ON node.vid = term_node_value_11.vid AND term_node_value_11.tid = 275 LEFT JOIN term_node term_node_value_12 ON node.vid = term_node_value_12.vid AND term_node_value_12.tid = 276 LEFT JOIN term_node term_node_value_13 ON node.vid = term_node_value_13.vid AND term_node_value_13.tid = 345 LEFT JOIN term_node term_node_value_14 ON node.vid = term_node_value_14.vid AND term_node_value_14.tid = 277 LEFT JOIN term_node term_node_value_15 ON node.vid = term_node_value_15.vid AND term_node_value_15.tid = 278 LEFT JOIN term_node term_node_value_16 ON node.vid = term_node_value_16.vid AND term_node_value_16.tid = 346 LEFT JOIN term_node term_node_value_17 ON node.vid = term_node_value_17.vid AND term_node_value_17.tid = 279 LEFT JOIN term_node term_node_value_18 ON node.vid = term_node_value_18.vid AND term_node_value_18.tid = 280 LEFT JOIN term_node term_node_value_19 ON node.vid = term_node_value_19.vid AND term_node_value_19.tid = 281 LEFT JOIN term_node term_node_value_20 ON node.vid = term_node_value_20.vid AND term_node_value_20.tid = 282 LEFT JOIN term_node term_node_value_21 ON node.vid = term_node_value_21.vid AND term_node_value_21.tid = 283 LEFT JOIN term_node term_node_value_22 ON node.vid = term_node_value_22.vid AND term_node_value_22.tid = 284 LEFT JOIN term_node term_node_value_23 ON node.vid = term_node_value_23.vid AND term_node_value_23.tid = 326 LEFT JOIN term_node term_node_value_24 ON node.vid = term_node_value_24.vid AND term_node_value_24.tid = 337 LEFT JOIN term_node term_node_value_25 ON node.vid = term_node_value_25.vid AND term_node_value_25.tid = 285 LEFT JOIN term_node term_node_value_26 ON node.vid = term_node_value_26.vid AND term_node_value_26.tid = 286 LEFT JOIN term_node term_node_value_27 ON node.vid = term_node_value_27.vid AND term_node_value_27.tid = 287 LEFT JOIN term_node term_node_value_28 ON node.vid = term_node_value_28.vid AND term_node_value_28.tid = 288 LEFT JOIN term_node term_node_value_29 ON node.vid = term_node_value_29.vid AND term_node_value_29.tid = 328 LEFT JOIN term_node term_node_value_30 ON node.vid = term_node_value_30.vid AND term_node_value_30.tid = 289 LEFT JOIN term_node term_node_value_31 ON node.vid = term_node_value_31.vid AND term_node_value_31.tid = 338 LEFT JOIN term_node term_node_value_32 ON node.vid = term_node_value_32.vid AND term_node_value_32.tid = 290 LEFT JOIN term_node term_node_value_33 ON node.vid = term_node_value_33.vid AND term_node_value_33.tid = 291 LEFT JOIN term_node term_node_value_34 ON node.vid = term_node_value_34.vid AND term_node_value_34.tid = 292 LEFT JOIN term_node term_node_value_35 ON node.vid = term_node_value_35.vid AND term_node_value_35.tid = 293 LEFT JOIN term_node term_node_value_36 ON node.vid = term_node_value_36.vid AND term_node_value_36.tid = 294 LEFT JOIN term_node term_node_value_37 ON node.vid = term_node_value_37.vid AND term_node_value_37.tid = 347 LEFT JOIN term_node term_node_value_38 ON node.vid = term_node_value_38.vid AND term_node_value_38.tid = 295 LEFT JOIN term_node term_node_value_39 ON node.vid = term_node_value_39.vid AND term_node_value_39.tid = 296 LEFT JOIN term_node term_node_value_40 ON node.vid = term_node_value_40.vid AND term_node_value_40.tid = 297 LEFT JOIN term_node term_node_value_41 ON node.vid = term_node_value_41.vid AND term_node_value_41.tid = 332 LEFT JOIN term_node term_node_value_42 ON node.vid = term_node_value_42.vid AND term_node_value_42.tid = 298 LEFT JOIN term_node term_node_value_43 ON node.vid = term_node_value_43.vid AND term_node_value_43.tid = 299 LEFT JOIN term_node term_node_value_44 ON node.vid = term_node_value_44.vid AND term_node_value_44.tid = 300 LEFT JOIN term_node term_node_value_45 ON node.vid = term_node_value_45.vid AND term_node_value_45.tid = 348 LEFT JOIN term_node term_node_value_46 ON node.vid = term_node_value_46.vid AND term_node_value_46.tid = 329 LEFT JOIN term_node term_node_value_47 ON node.vid = term_node_value_47.vid AND term_node_value_47.tid = 339 LEFT JOIN term_node term_node_value_48 ON node.vid = term_node_value_48.vid AND term_node_value_48.tid = 301 LEFT JOIN term_node term_node_value_49 ON node.vid = term_node_value_49.vid AND term_node_value_49.tid = 302 LEFT JOIN term_node term_node_value_50 ON node.vid = term_node_value_50.vid AND term_node_value_50.tid = 303 LEFT JOIN term_node term_node_value_51 ON node.vid = term_node_value_51.vid AND term_node_value_51.tid = 304 LEFT JOIN term_node term_node_value_52 ON node.vid = term_node_value_52.vid AND term_node_value_52.tid = 305 LEFT JOIN term_node term_node_value_53 ON node.vid = term_node_value_53.vid AND term_node_value_53.tid = 306 LEFT JOIN term_node term_node_value_54 ON node.vid = term_node_value_54.vid AND term_node_value_54.tid = 307 LEFT JOIN term_node term_node_value_55 ON node.vid = term_node_value_55.vid AND term_node_value_55.tid = 308 LEFT JOIN term_node term_node_value_56 ON node.vid = term_node_value_56.vid AND term_node_value_56.tid = 309 LEFT JOIN term_node term_node_value_57 ON node.vid = term_node_value_57.vid AND term_node_value_57.tid = 310 LEFT JOIN term_node term_node_value_58 ON node.vid = term_node_value_58.vid AND term_node_value_58.tid = 311 LEFT JOIN term_node term_node_value_59 ON node.vid = term_node_value_59.vid AND term_node_value_59.tid = 312 LEFT JOIN term_node term_node_value_60 ON node.vid = term_node_value_60.vid AND term_node_value_60.tid = 313 LEFT JOIN term_node term_node_value_61 ON node.vid = term_node_value_61.vid AND term_node_value_61.tid = 340 LEFT JOIN term_node term_node_value_62 ON node.vid = term_node_value_62.vid AND term_node_value_62.tid = 314 LEFT JOIN term_node term_node_value_63 ON node.vid = term_node_value_63.vid AND term_node_value_63.tid = 341 LEFT JOIN term_node term_node_value_64 ON node.vid = term_node_value_64.vid AND term_node_value_64.tid = 315 LEFT JOIN term_node term_node_value_65 ON node.vid = term_node_value_65.vid AND term_node_value_65.tid = 316 LEFT JOIN term_node term_node_value_66 ON node.vid = term_node_value_66.vid AND term_node_value_66.tid = 317 LEFT JOIN term_node term_node_value_67 ON node.vid = term_node_value_67.vid AND term_node_value_67.tid = 318 LEFT JOIN term_node term_node_value_68 ON node.vid = term_node_value_68.vid AND term_node_value_68.tid = 319 LEFT JOIN term_node term_node_value_69 ON node.vid = term_node_value_69.vid AND term_node_value_69.tid = 320 LEFT JOIN term_node term_node_value_70 ON node.vid = term_node_value_70.vid AND term_node_value_70.tid = 321 LEFT JOIN term_node term_node_value_71 ON node.vid = term_node_value_71.vid AND term_node_value_71.tid = 330 LEFT JOIN term_node term_node_value_72 ON node.vid = term_node_value_72.vid AND term_node_value_72.tid = 342 LEFT JOIN term_node term_node_value_73 ON node.vid = term_node_value_73.vid AND term_node_value_73.tid = 322 LEFT JOIN term_node term_node_value_74 ON node.vid = term_node_value_74.vid AND term_node_value_74.tid = 323 LEFT JOIN term_node term_node_value_75 ON node.vid = term_node_value_75.vid AND term_node_value_75.tid = 343 LEFT JOIN term_node term_node_value_76 ON node.vid = term_node_value_76.vid AND term_node_value_76.tid = 324 LEFT JOIN term_node term_node_value_77 ON node.vid = term_node_value_77.vid AND term_node_value_77.tid = 331 LEFT JOIN term_node term_node_value_78 ON node.vid = term_node_value_78.vid AND term_node_value_78.tid = 325 LEFT JOIN content_field_display_image node_data_field_display_image ON node.vid = node_data_field_display_image.vid LEFT JOIN content_type_profile node_data_field_title ON node.vid = node_data_field_title.vid LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid LEFT JOIN term_data term_data ON term_node_value_0.tid = term_data.tid LEFT JOIN content_type_profile node_data_field_lastname ON node.vid = node_data_field_lastname.vid WHERE (term_node_value_0.tid = 269 OR term_node_value_1.tid = 333 OR term_node_value_2.tid = 270 OR term_node_value_3.tid = 335 OR term_node_value_4.tid = 327 OR term_node_value_5.tid = 271 OR term_node_value_6.tid = 272 OR term_node_value_7.tid = 273 OR term_node_value_8.tid = 336 OR term_node_value_9.tid = 344 OR term_node_value_10.tid = 274 OR term_node_value_11.tid = 275 OR term_node_value_12.tid = 276 OR term_node_value_13.tid = 345 OR term_node_value_14.tid = 277 OR term_node_value_15.tid = 278 OR term_node_value_16.tid = 346 OR term_node_value_17.tid = 279 OR term_node_value_18.tid = 280 OR term_node_value_19.tid = 281 OR term_node_value_20.tid = 282 OR term_node_value_21.tid = 283 OR term_node_value_22.tid = 284 OR term_node_value_23.tid = 326 OR term_node_value_24.tid = 337 OR term_node_value_25.tid = 285 OR term_node_value_26.tid = 286 OR term_node_value_27.tid = 287 OR term_node_value_28.tid = 288 OR term_node_value_29.tid = 328 OR term_node_value_30.tid = 289 OR term_node_value_31.tid = 338 OR term_node_value_32.tid = 290 OR term_node_value_33.tid = 291 OR term_node_value_34.tid = 292 OR term_node_value_35.tid = 293 OR term_node_value_36.tid = 294 OR term_node_value_37.tid = 347 OR term_node_value_38.tid = 295 OR term_node_value_39.tid = 296 OR term_node_value_40.tid = 297 OR term_node_value_41.tid = 332 OR term_node_value_42.tid = 298 OR term_node_value_43.tid = 299 OR term_node_value_44.tid = 300 OR term_node_value_45.tid = 348 OR term_node_value_46.tid = 329 OR term_node_value_47.tid = 339 OR term_node_value_48.tid = 301 OR term_node_value_49.tid = 302 OR term_node_value_50.tid = 303 OR term_node_value_51.tid = 304 OR term_node_value_52.tid = 305 OR term_node_value_53.tid = 306 OR term_node_value_54.tid = 307 OR term_node_value_55.tid = 308 OR term_node_value_56.tid = 309 OR term_node_value_57.tid = 310 OR term_node_value_58.tid = 311 OR term_node_value_59.tid = 312 OR term_node_value_60.tid = 313 OR term_node_value_61.tid = 340 OR term_node_value_62.tid = 314 OR term_node_value_63.tid = 341 OR term_node_value_64.tid = 315 OR term_node_value_65.tid = 316 OR term_node_value_66.tid = 317 OR term_node_value_67.tid = 318 OR term_node_value_68.tid = 319 OR term_node_value_69.tid = 320 OR term_node_value_70.tid = 321 OR term_node_value_71.tid = 330 OR term_node_value_72.tid = 342 OR term_node_value_73.tid = 322 OR term_node_value_74.tid = 323 OR term_node_value_75.tid = 343 OR term_node_value_76.tid = 324 OR term_node_value_77.tid = 331 OR term_node_value_78.tid = 325) AND (node.type in ('profile')) AND (node.status = 1 OR (node.uid = 0 AND 0 <> 0) OR 0 = 1) GROUP BY nid ORDER BY node_data_field_lastname_field_lastname_value ASC, term_data_name ASC, node_data_field_title_field_title_value ASC, _random ASC in /home/drupal6/external/sites/all/modules/views/includes/view.inc on line 814.