1054 Unknown column '79¤cy' in 'where clause'
in:
[select distinct p.products_id, p.products_type,p.products_status,p.products_model,p.products_price,p.products_price_retail,p.products_price_sample,p.product_is_wholesale,p.product_wholesale_min,p.products_quantity, p.products_quantity_order_min, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description_es, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and p.products_quantity <> 0 and pd.language_id = '1' and 49 < p.`products_price` and p.`products_price` < 79¤cy=HKD and ( p2c.categories_id =163 or p2c.categories_id =164 or p2c.categories_id =165 or p2c.categories_id =166 or p2c.categories_id =167 or p2c.categories_id =168 or p2c.categories_id =169 or p2c.categories_id =170 or p2c.categories_id =171 or p2c.categories_id =172 or p2c.categories_id =173 or p2c.categories_id =174 or p2c.categories_id =175 or p2c.categories_id =176 or p2c.categories_id =177 or p2c.categories_id =178 or p2c.categories_id =179 or p2c.categories_id =180 or p2c.categories_id =181 or p2c.categories_id =182 or p2c.categories_id =183 or p2c.categories_id =184 or p2c.categories_id =185 or p2c.categories_id =186 or p2c.categories_id =187 or p2c.categories_id =188 or p2c.categories_id =189 or p2c.categories_id =191 or p2c.categories_id =192 or p2c.categories_id =193 or p2c.categories_id =194)]