Browse our extensive selection of Barstools. Purchase and seat your guests in style and comfort. Our store offers Barstools from the Contemporary to the Traditional and assures you will find what you are looking for.
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=4811 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
