SELECT DISTINCT c.*, l.short_name AS location, m.name || ' '::text || coalesce(c.description, ''::text) AS long_description, m.name as maker_name, vk_types.short_name as vk_type_short_name, vk_types.name as vk_type_name, case when c.vk_type in ('VN','VL') then 0 else coalesce(c.sold_date,now())::date-c.created_on::date end AS days_in_inventory, (select events.id || ':' || events.type from events where events.info=c.id and events.type in ('CARTECH', 'CARTECHPREP','CARTECH_ENTER', 'CARTECHPREP_ENTER') and events.status in ('PENDING','PRINTED') limit 1) as cartech_in_action, (select td.id from testdrives as td where td.car_id=c.id and td.from_date<=now() and td.to_date>=now() limit 1) as testdrive_in_actionFROM cars AS c LEFT OUTER JOIN locations AS l ON c.location_id = l.idLEFT OUTER JOIN makers AS m ON c.maker = m.idLEFT OUTER JOIN models AS mo ON c.type = mo.type AND c.maker = mo.makerLEFT OUTER JOIN vk_types ON vk_types.id = c.vk_typeWHERE (l.id <> 249 OR l.id is NULL) AND c.sold = FALSE