Hello guys i have some stuck about multiple join and multiple order by .
here i cut all field to make you understand what i feel
CREATE TABLE IF NOT EXISTS `li_product_post` ( `id_product_post` int(11) NOT NULL, `id_user` int(11) NOT NULL, `product_akurat` int(11) NOT NULL, `product_tidak_akurat` int(11) NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=latin1;INSERT INTO `li_product_post` (`id_product_post`, `id_user`, `product_akurat`, `product_tidak_akurat`) VALUES(1, 32, 5, 4),(2, 28, 1, 0),(3, 27, 0, 1),(4, 27, 2, 0),(5, 27, 0, 0);
i need to select data from that table which is priority
Order by id_product_post desc
product_akurat desc
product_tidak_akurat desc
group by id_user
so here is i make demo please see, the worng things i need to put id_product_post 5 in the first place not id_product_post 3 cause order by id_product_post desc the first priority, hope you guys help me !Thanks in advance