select *, count(URGdata.vstockno) as cc from (
SELECT *,arrive_dat as ladate,
(select imageurl from URG_images where stock = vstockno and imagetype = 'V' and urgid = yardid order by imgname limit 1) as imageurl
FROM urg_veh_data left join URGdata on urg_veh_data.vstockno = URGdata.vstockno
where
urgid in ('NN39')
and crush_date = '0000-00-00 00:00:00'
and arrive_dat > NOW() - INTERVAL 60 DAY
) xxx
where imageurl is not NULL
group by vstockno
order by arrive_dat desc limit 16
