Furnish your Dining Room in style with our large selection of China Cabinets that will suit any style and budget. Bring elegance and storage to your Dining Room and allow your prized possessions to sparkle.
MySQL error: 1054 - Unknown column 's.status' in 'where clause'
select distinct pef.products_extra_fields_id, pef.products_extra_fields_name from products_extra_fields pef inner join products_to_products_extra_fields p2pef on pef.products_extra_fields_id=p2pef.products_extra_fields_id inner join products p on p.products_id=p2pef.products_id inner join products_to_categories p2c on p.products_id=p2c.products_id where p.products_status='1' and p.products_quantity>0 and p.products_set_only=0 and p.is_discontinued=0 and pef.is_searchable=1 and p2c.categories_id=4791 and (IF(s.status, s.specials_new_products_price, p.products_calculated_price) > 2999) order by pef.products_extra_fields_order asc
