Add prices Drops to FrontController

[DieterK]

Hello,
i whant to hide the menu for prices drops if there are none, i couldnt find a sql statment to just get one product if "price drop".
when i try
 

        $products = Product::getPricesDrop(
            (int)Context::getContext()->language->id
        );

i get an error

(1/1) ContextErrorException

Notice: Trying to get property 'id' of non-object

Any Ideas ?
sorry for early post hit control enter.

Best Regards,
Dieter
 

Edited July 18, 2022 by DieterK (see edit history)