Too many tables in Viewsausgabe

Hey,

seitdem ich mehrere Taxonomy-Begriffe in einer Ansicht ausgebe, bekomme ich folgende Meldung:

user warning: Too many tables; MySQL can only use 61 tables in a join query: SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, node.language AS node_language, node_data_field_image.field_image_fid AS node_data_field_image_field_image_fid, node_data_field_image.field_image_list AS node_data_field_image_field_image_list, node_data_field_image.field_image_data AS node_data_field_image_field_image_data, node.type AS node_type, node.vid AS node_vid 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 = 80 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 = 272 LEFT JOIN term_node term_node_value_3 ON node.vid = term_node_value_3.vid AND term_node_value_3.tid = 287 LEFT JOIN term_node term_node_value_4 ON node.vid = term_node_value_4.vid AND term_node_value_4.tid = 341 LEFT JOIN term_node term_node_value_5 ON node.vid = term_node_value_5.vid AND term_node_value_5.tid = 285 LEFT JOIN term_node term_node_value_6 ON node.vid = term_node_value_6.vid AND term_node_value_6.tid = 327 LEFT JOIN term_node term_node_value_7 ON node.vid = term_node_value_7.vid AND term_node_value_7.tid = 326 LEFT JOIN term_node term_node_value_8 ON node.vid = term_node_value_8.vid AND term_node_value_8.tid = 350 LEFT JOIN term_node term_node_value_9 ON node.vid = term_node_value_9.vid AND term_node_value_9.tid = 271 LEFT JOIN term_node term_node_value_10 ON node.vid = term_node_value_10.vid AND term_node_value_10.tid = 342 LEFT JOIN term_node term_node_value_11 ON node.vid = term_node_value_11.vid AND term_node_value_11.tid = 332 LEFT JOIN term_node term_node_value_12 ON node.vid = term_node_value_12.vid AND term_node_value_12.tid = 328 LEFT JOIN term_node term_node_value_13 ON node.vid = term_node_value_13.vid AND term_node_value_13.tid = 321 LEFT JOIN term_node term_node_value_14 ON node.vid = term_node_value_14.vid AND term_node_value_14.tid = 290 LEFT JOIN term_node term_node_value_15 ON node.vid = term_node_value_15.vid AND term_node_value_15.tid = 340 LEFT JOIN term_node term_node_value_16 ON node.vid = term_node_value_16.vid AND term_node_value_16.tid = 293 LEFT JOIN term_node term_node_value_17 ON node.vid = term_node_value_17.vid AND term_node_value_17.tid = 354 LEFT JOIN term_node term_node_value_18 ON node.vid = term_node_value_18.vid AND term_node_value_18.tid = 82 LEFT JOIN term_node term_node_value_19 ON node.vid = term_node_value_19.vid AND term_node_value_19.tid = 92 LEFT JOIN term_node term_node_value_20 ON node.vid = term_node_value_20.vid AND term_node_value_20.tid = 345 LEFT JOIN term_node term_node_value_21 ON node.vid = term_node_value_21.vid AND term_node_value_21.tid = 310 LEFT JOIN term_node term_node_value_22 ON node.vid = term_node_value_22.vid AND term_node_value_22.tid = 320 LEFT JOIN term_node term_node_value_23 ON node.vid = term_node_value_23.vid AND term_node_value_23.tid = 348 LEFT JOIN term_node term_node_value_24 ON node.vid = term_node_value_24.vid AND term_node_value_24.tid = 132 LEFT JOIN term_node term_node_value_25 ON node.vid = term_node_value_25.vid AND term_node_value_25.tid = 274 LEFT JOIN term_node term_node_value_26 ON node.vid = term_node_value_26.vid AND term_node_value_26.tid = 329 LEFT JOIN term_node term_node_value_27 ON node.vid = term_node_value_27.vid AND term_node_value_27.tid = 347 LEFT JOIN term_node term_node_value_28 ON node.vid = term_node_value_28.vid AND term_node_value_28.tid = 307 LEFT JOIN term_node term_node_value_29 ON node.vid = term_node_value_29.vid AND term_node_value_29.tid = 284 LEFT JOIN term_node term_node_value_30 ON node.vid = term_node_value_30.vid AND term_node_value_30.tid = 296 LEFT JOIN term_node term_node_value_31 ON node.vid = term_node_value_31.vid AND term_node_value_31.tid = 288 LEFT JOIN term_node term_node_value_32 ON node.vid = term_node_value_32.vid AND term_node_value_32.tid = 301 LEFT JOIN term_node term_node_value_33 ON node.vid = term_node_value_33.vid AND term_node_value_33.tid = 312 LEFT JOIN term_node term_node_value_34 ON node.vid = term_node_value_34.vid AND term_node_value_34.tid = 352 LEFT JOIN term_node term_node_value_35 ON node.vid = term_node_value_35.vid AND term_node_value_35.tid = 270 LEFT JOIN term_node term_node_value_36 ON node.vid = term_node_value_36.vid AND term_node_value_36.tid = 305 LEFT JOIN term_node term_node_value_37 ON node.vid = term_node_value_37.vid AND term_node_value_37.tid = 318 LEFT JOIN term_node term_node_value_38 ON node.vid = term_node_value_38.vid AND term_node_value_38.tid = 346 LEFT JOIN term_node term_node_value_39 ON node.vid = term_node_value_39.vid AND term_node_value_39.tid = 283 LEFT JOIN term_node term_node_value_40 ON node.vid = term_node_value_40.vid AND term_node_value_40.tid = 275 LEFT JOIN term_node term_node_value_41 ON node.vid = term_node_value_41.vid AND term_node_value_41.tid = 315 LEFT JOIN term_node term_node_value_42 ON node.vid = term_node_value_42.vid AND term_node_value_42.tid = 278 LEFT JOIN term_node term_node_value_43 ON node.vid = term_node_value_43.vid AND term_node_value_43.tid = 41 LEFT JOIN term_node term_node_value_44 ON node.vid = term_node_value_44.vid AND term_node_value_44.tid = 280 LEFT JOIN term_node term_node_value_45 ON node.vid = term_node_value_45.vid AND term_node_value_45.tid = 273 LEFT JOIN term_node term_node_value_46 ON node.vid = term_node_value_46.vid AND term_node_value_46.tid = 289 LEFT JOIN term_node term_node_value_47 ON node.vid = term_node_value_47.vid AND term_node_value_47.tid = 311 LEFT JOIN term_node term_node_value_48 ON node.vid = term_node_value_48.vid AND term_node_value_48.tid = 324 LEFT JOIN term_node term_node_value_49 ON node.vid = term_node_value_49.vid AND term_node_value_49.tid = 309 LEFT JOIN term_node term_node_value_50 ON node.vid = term_node_value_50.vid AND term_node_value_50.tid = 300 LEFT JOIN term_node term_node_value_51 ON node.vid = term_node_value_51.vid AND term_node_value_51.tid = 306 LEFT JOIN term_node term_node_value_52 ON node.vid = term_node_value_52.vid AND term_node_value_52.tid = 95 LEFT JOIN term_node term_node_value_53 ON node.vid = term_node_value_53.vid AND term_node_value_53.tid = 304 LEFT JOIN term_node term_node_value_54 ON node.vid = term_node_value_54.vid AND term_node_value_54.tid = 276 LEFT JOIN term_node term_node_value_55 ON node.vid = term_node_value_55.vid AND term_node_value_55.tid = 281 LEFT JOIN term_node term_node_value_56 ON node.vid = term_node_value_56.vid AND term_node_value_56.tid = 355 LEFT JOIN term_node term_node_value_57 ON node.vid = term_node_value_57.vid AND term_node_value_57.tid = 298 LEFT JOIN term_node term_node_value_58 ON node.vid = term_node_value_58.vid AND term_node_value_58.tid = 295 LEFT JOIN term_node term_node_value_59 ON node.vid = term_node_value_59.vid AND term_node_value_59.tid = 282 LEFT JOIN term_node term_node_value_60 ON node.vid = term_node_value_60.vid AND term_node_value_60.tid = 336 LEFT JOIN term_node term_node_value_61 ON node.vid = term_node_value_61.vid AND term_node_value_61.tid = 297 LEFT JOIN term_node term_node_value_62 ON node.vid = term_node_value_62.vid AND term_node_value_62.tid = 277 LEFT JOIN term_node term_node_value_63 ON node.vid = term_node_value_63.vid AND term_node_value_63.tid = 107 LEFT JOIN term_node term_node_value_64 ON node.vid = term_node_value_64.vid AND term_node_value_64.tid = 299 LEFT JOIN term_node term_node_value_65 ON node.vid = term_node_value_65.vid AND term_node_value_65.tid = 331 LEFT JOIN term_node term_node_value_66 ON node.vid = term_node_value_66.vid AND term_node_value_66.tid = 313 LEFT JOIN term_node term_node_value_67 ON node.vid = term_node_value_67.vid AND term_node_value_67.tid = 322 LEFT JOIN term_node term_node_value_68 ON node.vid = term_node_value_68.vid AND term_node_value_68.tid = 291 LEFT JOIN term_node term_node_value_69 ON node.vid = term_node_value_69.vid AND term_node_value_69.tid = 286 LEFT JOIN term_node term_node_value_70 ON node.vid = term_node_value_70.vid AND term_node_value_70.tid = 316 LEFT JOIN term_node term_node_value_71 ON node.vid = term_node_value_71.vid AND term_node_value_71.tid = 308 LEFT JOIN term_node term_node_value_72 ON node.vid = term_node_value_72.vid AND term_node_value_72.tid = 330 LEFT JOIN term_node term_node_value_73 ON node.vid = term_node_value_73.vid AND term_node_value_73.tid = 357 LEFT JOIN term_node term_node_value_74 ON node.vid = term_node_value_74.vid AND term_node_value_74.tid = 325 LEFT JOIN term_node term_node_value_75 ON node.vid = term_node_value_75.vid AND term_node_value_75.tid = 356 LEFT JOIN term_node term_node_value_76 ON node.vid = term_node_value_76.vid AND term_node_value_76.tid = 303 LEFT JOIN term_node term_node_value_77 ON node.vid = term_node_value_77.vid AND term_node_value_77.tid = 317 LEFT JOIN term_node term_node_value_78 ON node.vid = term_node_value_78.vid AND term_node_value_78.tid = 335 LEFT JOIN term_node term_node_value_79 ON node.vid = term_node_value_79.vid AND term_node_value_79.tid = 323 LEFT JOIN term_node term_node_value_80 ON node.vid = term_node_value_80.vid AND term_node_value_80.tid = 343 LEFT JOIN term_node term_node_value_81 ON node.vid = term_node_value_81.vid AND term_node_value_81.tid = 349 LEFT JOIN term_node term_node_value_82 ON node.vid = term_node_value_82.vid AND term_node_value_82.tid = 319 LEFT JOIN term_node term_node_value_83 ON node.vid = term_node_value_83.vid AND term_node_value_83.tid = 302 LEFT JOIN term_node term_node_value_84 ON node.vid = term_node_value_84.vid AND term_node_value_84.tid = 344 LEFT JOIN term_node term_node_value_85 ON node.vid = term_node_value_85.vid AND term_node_value_85.tid = 337 LEFT JOIN term_node term_node_value_86 ON node.vid = term_node_value_86.vid AND term_node_value_86.tid = 292 LEFT JOIN term_node term_node_value_87 ON node.vid = term_node_value_87.vid AND term_node_value_87.tid = 338 LEFT JOIN term_node term_node_value_88 ON node.vid = term_node_value_88.vid AND term_node_value_88.tid = 279 LEFT JOIN term_node term_node_value_89 ON node.vid = term_node_value_89.vid AND term_node_value_89.tid = 314 LEFT JOIN term_node term_node_value_90 ON node.vid = term_node_value_90.vid AND term_node_value_90.tid = 353 LEFT JOIN term_node term_node_value_91 ON node.vid = term_node_value_91.vid AND term_node_value_91.tid = 339 LEFT JOIN term_node term_node_value_92 ON node.vid = term_node_value_92.vid AND term_node_value_92.tid = 269 LEFT JOIN term_node term_node_value_93 ON node.vid = term_node_value_93.vid AND term_node_value_93.tid = 294 LEFT JOIN term_node term_node_value_94 ON node.vid = term_node_value_94.vid AND term_node_value_94.tid = 334 LEFT JOIN term_node term_node_value_95 ON node.vid = term_node_value_95.vid AND term_node_value_95.tid = 351 LEFT JOIN content_type_ad node_data_field_image ON node.vid = node_data_field_image.vid WHERE (node.type in ('ad')) AND (term_node_value_0.tid = 80 OR term_node_value_1.tid = 333 OR term_node_value_2.tid = 272 OR term_node_value_3.tid = 287 OR term_node_value_4.tid = 341 OR term_node_value_5.tid = 285 OR term_node_value_6.tid = 327 OR term_node_value_7.tid = 326 OR term_node_value_8.tid = 350 OR term_node_value_9.tid = 271 OR term_node_value_10.tid = 342 OR term_node_value_11.tid = 332 OR term_node_value_12.tid = 328 OR term_node_value_13.tid = 321 OR term_node_value_14.tid = 290 OR term_node_value_15.tid = 340 OR term_node_value_16.tid = 293 OR term_node_value_17.tid = 354 OR term_node_value_18.tid = 82 OR term_node_value_19.tid = 92 OR term_node_value_20.tid = 345 OR term_node_value_21.tid = 310 OR term_node_value_22.tid = 320 OR term_node_value_23.tid = 348 OR term_node_value_24.tid = 132 OR term_node_value_25.tid = 274 OR term_node_value_26.tid = 329 OR term_node_value_27.tid = 347 OR term_node_value_28.tid = 307 OR term_node_value_29.tid = 284 OR term_node_value_30.tid = 296 OR term_node_value_31.tid = 288 OR term_node_value_32.tid = 301 OR term_node_value_33.tid = 312 OR term_node_value_34.tid = 352 OR term_node_value_35.tid = 270 OR term_node_value_36.tid = 305 OR term_node_value_37.tid = 318 OR term_node_value_38.tid = 346 OR term_node_value_39.tid = 283 OR term_node_value_40.tid = 275 OR term_node_value_41.tid = 315 OR term_node_value_42.tid = 278 OR term_node_value_43.tid = 41 OR term_node_value_44.tid = 280 OR term_node_value_45.tid = 273 OR term_node_value_46.tid = 289 OR term_node_value_47.tid = 311 OR term_node_value_48.tid = 324 OR term_node_value_49.tid = 309 OR term_node_value_50.tid = 300 OR term_node_value_51.tid = 306 OR term_node_value_52.tid = 95 OR term_node_value_53.tid = 304 OR term_node_value_54.tid = 276 OR term_node_value_55.tid = 281 OR term_node_value_56.tid = 355 OR term_node_value_57.tid = 298 OR term_node_value_58.tid = 295 OR term_node_value_59.tid = 282 OR term_node_value_60.tid = 336 OR term_node_value_61.tid = 297 OR term_node_value_62.tid = 277 OR term_node_value_63.tid = 107 OR term_node_value_64.tid = 299 OR term_node_value_65.tid = 331 OR term_node_value_66.tid = 313 OR term_node_value_67.tid = 322 OR term_node_value_68.tid = 291 OR term_node_value_69.tid = 286 OR term_node_value_70.tid = 316 OR term_node_value_71.tid = 308 OR term_node_value_72.tid = 330 OR term_node_value_73.tid = 357 OR term_node_value_74.tid = 325 OR term_node_value_75.tid = 356 OR term_node_value_76.tid = 303 OR term_node_value_77.tid = 317 OR term_node_value_78.tid = 335 OR term_node_value_79.tid = 323 OR term_node_value_80.tid = 343 OR term_node_value_81.tid = 349 OR term_node_value_82.tid = 319 OR term_node_value_83.tid = 302 OR term_node_value_84.tid = 344 OR term_node_value_85.tid = 337 OR term_node_value_86.tid = 292 OR term_node_value_87.tid = 338 OR term_node_value_88.tid = 279 OR term_node_value_89.tid = 314 OR term_node_value_90.tid = 353 OR term_node_value_91.tid = 339 OR term_node_value_92.tid = 269 OR term_node_value_93.tid = 294 OR term_node_value_94.tid = 334 OR term_node_value_95.tid = 351) AND (node.nid != 8) GROUP BY nid in C:\xampp\htdocs\new\sites\all\modules\views\includes\view.inc on line 775.

Ich habe mich ein wenig schlau gemacht und weiß mitlerweile, dass es zuviele Tabellen sind. Meine Ansicht, gibt Taxonomy-Begriffe aus die als Tags bzw. Schlagwörter für den Beitrag von mir zugeordnet werden und unter dem jeweiligen Beitrag angezeigt werden. Benutzer können somit ähnliche Beiträge filtern... Darum geht es hier auch gar nicht, sondern ich möchte gerne wissen, wie ich diese Fehlermeldung wegbekomme ohne weniger Tags verwenden zu müssen,... falls es hilft, ich benutze das Theme http://drupal.org/project/mix_and_match habe gelesen dass es was mit dem Theme zutun haben kann aufgrund zu weniger Tabellen.

Bitte um schnelle Hilfe, Seite soll bald online gehen.

Vielen Dank!