select `id`,`title_en`,`code`,`price_before`,`price_after`,`view_en`,`images` from products where depart=12 and active=1 order by id desc , priority desc limit 24