AND-Clause nach GROUP BY in /account.php

[noRiddle]

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: ​AND-Clause nach GROUP BY in /account.php

Gruß,
noRiddle

[Gerhard Waldemair]

In 14686:

fix #2299 - revised r8571 (categories_name for last viewed history) - change sql for conditions