A Database Error Occurred

Error Number: 1054

Unknown column 'FUNCTION.ARRAY' in 'where clause'

SELECT SQL_CALC_FOUND_ROWS distinct(p.products_id), p.products_model, p.products_price, p.manufacturers_id, p.products_turn_back_on, p.products_instore_pickup_only, p.products_instore_purchase_only, p.products_can_finance, p.products_stock_qty, p.products_temp_out_of_stock, p.products_msrp, p.products_map, pa.one_percent_logic, pd.products_rating, pd.products_release_date, ptc.categories_id, pd.products_description, m.manufacturers_name, cd.categories_name, pd.products_description, pd.products_features, pd.products_color, pd.products_size, pd.products_dimensions, pd.products_height, pd.products_depth, pd.products_width, pd.products_class_id, pc.products_class, p.products_image, p.products_image_sm_1, pd.products_name, parent_id, p.products_weight, p.products_quantity, options_values_price, products_options_name, products_options_length, products_status, products_options_values_name, p.products_price as real_price, pa.options_id, pa.options_values_id, pa.options_values_cost, pa.options_values_price, products_real_price, pf.is_freight, pd.products_notes, IF(s.specials_new_products_price < p.products_price AND p.products_original_special <> 1, s.specials_new_products_price, p.products_price) as products_price, p.products_price as products_actual_price, IF(p.products_quantity > 1, 1, 0) as quantity_buy_it_today, s.specials_new_products_price, s.expires_date, s.status, IF(p.manufacturers_id = 1386, 0, 1) as monogram_sort, tr.tv_resolution, tr.tv_resolution_id, th.tv_hertz, th.tv_hertz_id, p.blanket_logic, p.products_no_price_update, p.products_original_special, pd.store_location_id, sl.store_location , p.products_ordered,p.products_ordered_date FROM products p INNER JOIN products_to_categories ptc on (p.products_id = ptc.products_id) INNER JOIN products_description pd on (pd.products_id = p.products_id) INNER JOIN categories c on (c.categories_id = ptc.categories_id) INNER JOIN manufacturers m on (m.manufacturers_id = p.manufacturers_id) INNER JOIN categories_description cd on (cd.categories_id = ptc.categories_id) LEFT JOIN NEW_products_class pc on (pc.products_class_id = pd.products_class_id) LEFT JOIN products_attributes pa on (pa.products_id = p.products_id) LEFT JOIN products_options po on (pa.options_id = po.products_options_id) LEFT JOIN products_options_values pov on (pov.products_options_values_id = pa.options_values_id) LEFT JOIN specials s on (p.products_id = s.products_id AND s.expires_date > now() AND s.status = 1) LEFT JOIN products_freight pf on (p.products_id = pf.products_id) LEFT JOIN tv_resolutions tr on (pd.tv_resolution_id = tr.tv_resolution_id) LEFT JOIN tv_hertz th on (pd.tv_hertz_id = th.tv_hertz_id) LEFT JOIN products_store_locations sl ON (pd.store_location_id = sl.store_location_id) WHERE 1 = 1 AND products_status = 1 AND categories_status = 1 AND manufacturers_status = 1 AND products_quantity > 0 #AND (products_quantity >= 0 OR products_temp_out_of_stock = 1) AND p.products_id = FUNCTION.ARRAY-MERGE ORDER BY monogram_sort DESC, pd.products_release_date ASC