Message-ID: <72f379a3-0bba-b0fb-975c-d20b76d33fff@gmail.com>
Date: Wed, 19 Jan 2022 05:56:17 -0700
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
 Thunderbird/91.5.0
Subject: Re: Clean up shop database
Content-Language: en-CA
To: pgsql-sql@lists.postgresql.org
References: <20220119120317479683.54287f97@klingler.net>
 <9713782b-9c29-2497-be30-6dd1af0d550c@gmail.com>
 <20220119134059286538.4c015b19@klingler.net>
From: Rob Sargent <robjsargent@gmail.com>
In-Reply-To: <20220119134059286538.4c015b19@klingler.net>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/72f379a3-0bba-b0fb-975c-d20b76d33fff%40gmail.com>
Precedence: bulk

On 1/19/22 05:40, Richard Klingler wrote:
> Odd...gives me the same result....
>
> Tried another approach as the ordered is known where to start
> from....but still the same:
>
> select p.productid as id, p.name_de as name
> from product p, orderitems i,orders
> where p.productid = i.orderitems2productid
> and i.orderitems2orderid = orders.orderid
> and orders.orderid < 14483
> and p.pieces < 1
> and p.active = 't'
> group by id
> order by id desc
>
> Still lists products after January 1st 2021...but I know what is going
> on....

(On this list top-posting is frowned upon.  Inline or bottom-posting 
preferred.)
The above query does not restrict order date?

select p.*,max(o.orderdate)
from product p join orderitem t on p.productid = t.orderitems2productid
join order o on t.orderitems2orderid = o.orderid
group by p.productid
having max(o.orderdate < 'January 1 2021'

>