SELECT tenderstock.*,dealer_stock.*, tenderinvoice.*,customer.country as order_country FROM dealer_stock LEFT JOIN tenderstock ON id = carid::text AND source = 'zm' LEFT JOIN tenderinvoice ON carid=ivcarid AND ivvalid=1 LEFT OUTER JOIN customer on tenderinvoice.ivuserid = userid WHERE true AND rno < 900000 AND (tenderstock.deletedate IS NULL or tenderstock.eff_deletedate > current_date ) AND coalesce(hide_customer,'') != '1' order by rno desc , rno desc , rno desc OFFSET 0 LIMIT 80