[thelist] sql: least/min value

[Joxn]

Joxn wrote:
> I'm using mySQL for this and I'm really confused as I think it *has* to
> be very easy, but I can't find the appropriate function to do so.

Damn, I've been really dumb. After I mailed this and went to bed, I had
the idea:

SELECT id, file, url FROM ads WHERE state='1' ORDER BY number_views
DESC, id LIMIT 0, 1

:)

If someone has an even easier idea, please let me know.
Gee, I really need some sleep after this weekend... :)

bye Joxn
-- 
   || //\\ \\// |\\||  ::  joxn at vernum.com  ::
 \\|| \\// //\\ ||\\|  ::      8053703      ::