SELECT tenderstock.* , tenderinvoice.*,customer.country as order_country FROM tenderstock
LEFT JOIN tenderinvoice ON carid=ivcarid AND ivvalid=1
LEFT OUTER JOIN customer on ivuserid = userid
WHERE rno > 71000 AND rno < 900000 AND exotic_super = '1' AND coalesce(hide_customer,'') != '1'
ORDER BY buydate desc, rno desc LIMIT 6
FERRARI • 2024
296GTS • 296GTS
FERRARI • 2020
PORTOFINO • BASE GRADE
FERRARI • 2023
SF90 SPIDER • BASE GRADE
PORSCHE • 1994
911 • 911 CARRERA
ROLLS ROYCE • 2016
GHOST • GHOST SERIES2 EW
MCLAREN • 2015
650S • SPIDER