I have two blocks of the same type on the category page, set in local.xml:
<block type="catalog/layer_view" template="catalog/layer/view.phtml"/>
When using the category filter an error is thrown:
You cannot define a correlation name 'attribute_2_idx' more than once
But my design requires that I have two different filter areas on the category page.
All other resolutions I've found say to just remove one of the blocks - this is not an option in this scenario.
Any ideas? Thanks.