> I'm using the following query
>
> SELECT DISTINCT a.addrdsp,a.listdate,a.solddate,a.lpricea,a.sprice
> FROM archive a, archive b
> WHERE a.status='s' AND a.addrdsp IS NOT NULL
> AND a.addrdsp = b.addrdsp AND a.solddate < b.solddate
> AND date_add(a.solddate, interval 1 year) > b.solddate
I'm using the following query
SELECT DISTINCT a.addrdsp,a.listdate,a.solddate,a.lpricea,a.sprice
FROM archive a, archive b
WHERE a.status='s' AND a.addrdsp IS NOT NULL
AND a.addrdsp = b.addrdsp AND a.solddate < b.solddate
AND date_add(a.solddate, interval 1 year) > b.solddate
ORDER BY a.add
