sort-by-eav.sql

SELECT entry.id as entry_id, 
       v_brand.value as brand,
       v_year.value as year 
FROM entity
  JOIN entry 
    ON entity.id = entry.entity_id
  JOIN value v_brand 
    ON v_brand.parameter_id = 1 
    AND v_brand.entry_id = entry.id
  JOIN value v_year 
    ON v_year.parameter_id = 2 
    AND v_year.entry_id = entry.id
WHERE entity.name = 'Car'
ORDER BY year DESC, brand ASC