1054 - Unknown column 'final_price' in 'group statement'
select distinct * from products p left join products_to_categories p2c on p2c.products_id = p.products_id left join categories c on c.categories_id = p2c.categories_id where (to_days(p.products_date_available) <= to_days(now()) and to_days(p.products_date_offline) > to_days(now())) and p.products_quantity > 0 and c.categories_status = '1' and p.products_image > 0 and ((p.products_set like '%meyer%' or p.products_setsubtitle like '%meyer%' or p.products_series like '%meyer%' or p.products_origtitle like '%meyer%' or p.products_author like '%meyer%' or p.products_author_2 like '%meyer%' or p.products_author_3 like '%meyer%' or p.products_subtitle like '%meyer%' or p.products_name like '%meyer%' or p.manufacturer like '%meyer%' or p.products_isbn like '%meyer%') ) group by final_price , p.products_date_added desc, p.products_name limit 0, 20
