Search the Community
Showing results for tags 'order by join table multiple'.
Found 1 result
-
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
