id	summary	reporter	owner	description	type	status	priority	milestone	component	version	resolution	keywords	cc	blockedby	blocking
647	Fehler in Produkt-Filter	Torsten Riemer	Gerhard Waldemair	"Aus dem Demoshop 2.00 Log erhalte ich folgenden Meldung:

{{{
02/09/2015 10:25:17 E_USER_WARNING - 1052 - Column 'manufacturers_id' in where clause is ambiguous<br/><br/>SELECT DISTINCT c.categories_id as id,
               cd.categories_name as name 
                                FROM products p
                                JOIN products_description pd
                                     ON p.products_id = pd.products_id
                                        AND pd.language_id = '2'
                                        AND trim(pd.products_name) != ''
                                JOIN manufacturers m 
                                     ON m.manufacturers_id = p.manufacturers_id
                                      JOIN products_to_categories p2c 
                   ON p2c.products_id = p.products_id
              JOIN categories c 
                   ON c.categories_id = p2c.categories_id 
                      
              JOIN categories_description cd 
                   ON cd.categories_id = p2c.categories_id
                      AND cd.language_id = '2' 
                                     
                               WHERE p.products_status = '1'
                                      AND manufacturers_id = '1' 
                                     
                            ORDER BY name in File: /.../.../.../.../.../web/tags/modified-2.00/inc/db_functions_mysqli.inc.php on Line: 152
02/09/2015 10:25:17 Backtrace #0 - /.../.../.../.../.../web/tags/modified-2.00/inc/db_functions.inc.php called at Line 104
02/09/2015 10:25:17 Backtrace #1 - /.../.../.../.../.../web/tags/modified-2.00/includes/modules/listing_filter.php called at Line 128
02/09/2015 10:25:17 Backtrace #2 - /.../.../.../.../.../web/tags/modified-2.00/includes/modules/product_listing.php called at Line 166
02/09/2015 10:25:17 Backtrace #3 - /.../.../.../.../.../web/tags/modified-2.00/includes/modules/default.php called at Line 304
02/09/2015 10:25:17 Backtrace #4 - /.../.../.../.../.../web/tags/modified-2.00/index.php called at Line 33
}}}
"	Bug/Fehler	closed	hoch	modified-shop-2.0.0.0	Shop	2.0.0.0	fixed