SELECT a.*, a.id AS value, a.name AS text, a.makeid, a.alias, a.description, a.image, a.metakey, a.metadesc, a.ecount,c.name AS make_name
FROM #__expautos_model AS a
LEFT JOIN #__expautos_make AS c ON c.id = a.makeid
WHERE a.ecount > 0
ORDER BY a.name asc