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=4784 and (IF(s.status, s.specials_new_products_price, p.products_calculated_price) > 249) and (IF(s.status, s.specials_new_products_price, p.products_calculated_price) <= 499) order by pef.products_extra_fields_order asc
