Got error 28 from storage engineselect * from ( select * from dealer_banners where tipo='principal' AND (dealer_id='0' or dealer_id='38') AND vigencia >= CURDATE() order by orden, dealer_id desc ) as tmp group by orden limit 4