Currently I am on Magento 2.4.2 which was upgraded from 2.3.0. The issue which I am facing right now is that I am not able to see any products displayed on category page.
After debugging the below file:
and below function in the above path:
public function getCollection(\Magento\Catalog\Model\Category $category)
I found the collection query which is as below:
SELECT `e`.* FROM `catalog_product_entity` AS `e` WHERE (NULL)
I guess WHERE(NULL) condition might be the culprit here.
Any idea why am I getting this WHERE(NULL) condition and any suggestions to resolve this