Re: Order by leads to an empty set.

2006-05-09 Thread Mohammed Sameer
On Tue, May 09, 2006 at 12:13:41PM -0400, Rhino wrote: > > - Original Message - > From: "Mohammed Sameer" <[EMAIL PROTECTED]> > To: > Sent: Tuesday, May 09, 2006 9:56 AM > Subject: Order by leads to an empty set. > > > >Hi all, >

Re: Order by leads to an empty set.

2006-05-09 Thread Rhino
- Original Message - From: "Mohammed Sameer" <[EMAIL PROTECTED]> To: Sent: Tuesday, May 09, 2006 9:56 AM Subject: Order by leads to an empty set. Hi all, I have a strange problem and I can't really understand what's going on! mysql> SELECT n.nid, n.

Order by leads to an empty set.

2006-05-09 Thread Mohammed Sameer
Hi all, I have a strange problem and I can't really understand what's going on! mysql> SELECT n.nid, n.sticky, n.created FROM node n WHERE n.type='image' AND (n.uid = 1 OR n.status = 1) ORDER BY n.created desc; Empty set (0.00 sec) mysql> SELECT n.nid, n.sticky, n.created FROM node n WHERE n.ty