SELECT * FROM `product`, `pages`   WHERE
pages.hidden=0 AND 
product.status='current' AND
product.userId!=1 AND

(product.class='rental property' OR product.class='real estate') AND
product.pageId=pages.pkey AND
product.state='qld' AND
product.REAStandardPayDate!='' AND
product.REALastUpdate>'1739467501' AND
product.REALastUpdate<'1748193901' AND
product.userId!=1 AND
product.REA_AgencyID='APDBRI' AND
REAUniqueId!=''

order by product.REAStandardPayDate desc LIMIT 40<br>
Match Found to 21149258 is 21149528<br>
(REAUNIQUE ID: 21135440)
<br>