Getting a SQL error on On "All products" for a category

[atp29awr]

Hello,

I am seeing an error on one of the sections "All Products" related to the product category. I have a category tab as "Spiritual" in the menu. Under this is "All Products". When I click on this "All Products" tab, I see this error.

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by p.products_date_added DESC, pd.products_name LIMIT 120' at line 1
in:
[ order by p.products_date_added DESC, pd.products_name LIMIT 120]


I tried to check for "p.products_date_added" using the developer tool kit , I got it in


/html/includes/functions/functions_lookups.php

It showed me this:

Line #848 : $display_limit = " and date_format(p.products_date_added, '%Y%m') >= date_format(now(), '%Y%m')";

Line #851 : $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.products_date_added) <= 7';

Line #854 : $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.products_date_added) <= 14';

Line #857 : $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.products_date_added) <= 30';

Line #860 : $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.products_date_added) <= 60';

Line #863 : $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.products_date_added) <= 90';

Line #866 : $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.products_date_added) <= 120';

Line #914 : $new_range = ' and p.products_date_added >=' . $zc_new_date;

Line #917 : $new_range = ' and p.products_date_added >=' . $zc_new_date;


Kindly let me know what needs to done. Thanks a lot

[atp29awr]

Please help me in the issue. I do not want customers to see this error. Thanks!