1327 Undeclared variable: MAX_DISPLAY_PRODUCTS_LISTING
in:
[select p.products_quantity, p.products_id,p.products_model,p.products_show_id,p.products_type,p.products_status,p.products_price, p.products_price_retail, p.products_price_unit,p.products_quantity,p.master_categories_id,p.products_sort_order,p.products_onsale,p.products_image_server from products p left join products_description pd on (p.products_id = pd.products_id) and (pd.language_id = '1') where p.products_status = 1 and ((p.master_categories_id = 23) or (p.products_id in (select products_id from products_to_categories where categories_id = 23))) and p.products_onsale = 1 and p.products_quantity > 0 and (p.p_tag > 1) order by p.products_sort_order ASC limit 0, MAX_DISPLAY_PRODUCTS_LISTING]