1054 - Unknown column 'md.filter1_name' in 'field list'
select distinct m.filter1_id as id, md.filter1_name as name, md.filter1_text as text from products p, products_to_categories p2c, filter1 m, filter1_info md where p.products_status = '1' and p.filter1_id = m.filter1_id and m.filter1_id = md.filter1_id and p.products_id = p2c.products_id and p2c.categories_id = '1581' AND md.languages_id = '4' order by md.filter1_name