select * from device WHERE id_brand= and `show`>0 order by name<br><br>