id	summary	reporter	owner	description	type	status	priority	milestone	component	version	resolution	keywords	cc	blockedby	blocking
2299	AND-Clause nach GROUP BY in /account.php	noRiddle	somebody	"In dieser Query 
{{{
  $product_history_query = xtDBquery(""SELECT p.*,
                                             pd.*,
                                             cd.categories_name 
                                        FROM "".TABLE_PRODUCTS."" p
                                        JOIN "".TABLE_PRODUCTS_DESCRIPTION."" pd 
                                             ON p.products_id=pd.products_id
                                                AND pd.language_id='"".(int) $_SESSION['languages_id'].""'
                                        JOIN "".TABLE_PRODUCTS_TO_CATEGORIES."" p2c
                                             ON p.products_id = p2c.products_id
                                        JOIN "".TABLE_CATEGORIES_DESCRIPTION."" cd
                                             ON cd.categories_id = p2c.categories_id
                                                AND cd.language_id = '"".(int) $_SESSION['languages_id'].""'
                                       WHERE p.products_status = '1'
                                         AND p.products_id = '"".(int) $_SESSION['tracking']['products_history'][$i].""'
                                    GROUP BY p.products_id
                                             "".PRODUCTS_CONDITIONS_P);
}}}

müssen die PRODUCTS_CONDITIONS_P vor dem ""GROUP BY""-Befehl stehen:
{{{
                                       WHERE p.products_status = '1'
                                         AND p.products_id = '"".(int) $_SESSION['tracking']['products_history'][$i].""'
                                           "".PRODUCTS_CONDITIONS_P.""
                                    GROUP BY p.products_id"");
}}}

Da die Query seltsamerweise keinen Fehler wirft ist es nicht dringend, allerdings greift das Filtern nach den Permissions nicht.

Thread dazu: [https://www.modified-shop.org/forum/index.php?topic=42497.msg391674#msg391674 AND-Clause nach GROUP BY in /account.php]

Gruß,
noRiddle"	Bug/Fehler	closed	normal	modified-shop-2.0.8.0	Shop	2.0.7.2	fixed